Oracle API packages 5.1.1

Export invoices.

Manually enable or disable the access service.

Cancel auto top up subscription.

Change a service subsciption to a specified price plan.

Change the Customer Care portal password for the current user.

Stop temporary suspension.

Stop temporary suspension.

Stop service suspension.

Get a list of available services.

Get reserved charge log lines details by account.

Enable or disable additional periodic services within a price plan subscription.

Specify a value of a subject custom field. Cannot be used with custom fields that are multiple.

Register a customer in Self-Care portal.

Create or replace address and address-to-subject bind.

Add a service to a to a current charge log.

Create prepayment invoice.

Remove a service from a current charge log.

Add a new price plan for the next belling period (if there is no active subscription).

Add a new price plan for the next belling period (if there is no active subscription).

Change antivirus software subscription state.

Set promised pay for an account.

Get payments, charges and credit limits details.

Get current and already rendered services.

Find cutomer by login and phone number.

Setting active locale.

Unbind address from subject.

Create a subscription to a network service.

Stop services suspensions by account.

Change a service subsciption to a specified price plan.

Fill the temporary table with detailed service usage statistics.

Get a list of subscriptions with dates the service provisioning ends. Based on the reserved lines of charge logs.

Suspend services by account.

Suspend subscription.

Get available promised pay amount. Based on Recommended payment feature. Returns details about available credit limits or reason why it is not available. If the promised pay is denied, there will be NULLS in N_PROMISED_PAY_SUM and D_PROMISED_PAY_DAY columns, and there is a denial reason in VC_PROMISED_PAY column.

Get states of services that the customer has subscribed to.

Specify a value of an equipment custom field. Cannot be used with custom fields that are multiple.

Reset customer cabinet password.

Activate a card.

Create antivirus software subscription.

Add a child service subscription to a current price plan scubscrition.

Add a child service subscription to a current price plan scubscrition.

Remove a child service subscription from a price plan subscription.

Kill session.

Return caught error message with its full stack.

Raise an exception with custom code.

Raise an exception. Obsolete, use RAISE_ERROR instead.

Raise an exception with stack from existing exception. Uses ERROR type for new exception.

Raise an exception with stack from existing exception.

Raise an exception.

Сохранение доп. параметра оборудования. Используется в HARD.

Reset counter by CDR.

Flush bad accounting lines to archive.

Create external tables for network service.

Create data collect line.

Find EX_DATA_COLLECT line for cumulative updates.

Create entire region branch (used in the bulk loading of regions).

Load phone numbers, subscriptions and equipment.

Load provider equipment.

Create a charge log by subscription.

Load regions.

Load actual charge logs.

Load IP-addresses, service subscriptions and equipment.

Load customers from a CSV file.

Delete a mapping record.

Create or replace a mapping record.

Value from bank statement contents.

Table type for values from bank statement contents.

Prepare data on new banks to be created.

Load bank statement contents into the temporary table.

Create a new subscription to auto top-up for an account and cancel existing unverified ones.

Make a virtual payment. The procedure is used by the HID agent.

Load payments from 1C. Warning: please use the UTF-8 encoding.

Lock an autopayment to be processed.

Change a payment document status. The procedure is used by the HPD agent.

Cancel all payment requests for an account specified in a payment order.

Activate a subscription to auto top-up.

Create a subscription to auto top-up according to a rule.

Create current accounts based on the prepared data.

DEPRECATED: please use CREATE_PAYMENT instead. Make a payment. The procedure is used by the HPD agent.

Process a result of an autopayment.

Cancel a subscription to auto top-up.

Create or update a bank.

Make a payment.

Create new banks based on the prepared data.

Delete a payment.

Set a payment rating.

Prepare data on new current accounts to be added to organizations.

Get a value of a bank's "Transaction ID counter" field

Update a token for an active subscription to auto top-up.

Change a bank statement status. Warning: this procedure is called only by SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE.

Get a value of a bank's "Transaction ID counter" field The function is used by the HPD agent.

Get a value of a bank's "Transaction ID counter" field

Create or update a payment.

Create or update a payment record.

Table type for details on customer accounts.

Table type for subscriptions to auto top-up found by initial payments.

Table type for document numbers and their ratings.

Table type for data on customers, basic subjects and accounts.

Table type for created unprocessed autopayments.

Table type for customers with customer accounts and ratings.

Find a customer and a customer account by a document. When it is an invoice, the customer should be its participant. When the document is a service contract, the customer is retrieved from a subscription to a service under this contract.

Check if there is enough data to create a payment document.

Find a payment order by payment details. The function is used by the HPD agent.

Get data on a subject (an individual or an organization).

Get an account by its number and bank.

Get an account and its bank by an account number.

Find a payment order by payment details. The procedure is used by the HPD agent.

Check whether a payment with specified data exists. The function is used by the HPD agent.

Find a customer account to credit a payment. The function is used by the HPD agent.

Get an individual's last name, fist name and middle name or an organization's name by an account.

Check payment details.

Get details on a customer account.

Get a rating that represents an accuracy of matching payment data with data on a customer's account and a basic subject.

Add a value to a payment record.

Find a bank by a BIC and a correspondent account.

Get a bank by its code.

Get a list of created unprocessed autopayments.

Find a customer account to credit a payment. The customer account is searched in the following order: 1) getting the account by its number from rc_PAYMENT.VC_FORWHO_ACCOUNT (if specified), 2) getting the account by a document (a service contract or an invoice) extracted from a purpose of the payment, 3) getting the account by its number extracted from the purpose of the payment, 4) getting the account by the payer's tax ID, 5) getting the account by the payer's current account.

Find a customer account to credit a payment. The procedure is used by the HPD agent.

Get a list of subscriptions to auto top-up found by an initial payment.

Get a payment type by its code.

Delete configuration template.

Get template table row by ID

Sync configurations by equipment binds

Sync configurations by version

Sync configurations by customer equipment

Sync configurations by provider equipment

Create or replace configuration template.

Re-generate all substitutions for template deffered

Send profiles into queue by firm.

Delete profile template.

Create and update profiles for provider equipment.

Create and update profiles for customer equipment.

Do not use this procedure.

Create or replace profile template attribute.

For customer equipment: generate profiles, send profiles into queue, generate commands.

Re-generate all profiles for equipment.

For provider equipment: generate profiles, send profiles into queue, generate commands.

Re-generate all profiles for context.

Send profiles into queue by base version.

Delete profile template attribute.

Create and update profiles.

Create and update all profiles by firm.

Re-generate all substitutions for template.

Re-generate all substitutions for template.

Remove profiles by template

Send profiles into queue.

Create or replace profile template.

Create and update all profiles by firm if time interval was changed.

Charge an adjustment of a specicfied amount against a specified account.

Change invoice state. Attention: this procedure is only to be called from SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE. The actual state change is performed there, this procedure only performs invoice-specific operations.

Get cursor value.

Create proforma invoices

Create or replace invoice content line.