Oracle API packages 6.2.1

Delete accounting data from temporary table TT_VALUES

Collect accounting data in temporary table TT_V_ACC_LINES.

Change antivirus software subscription state.

Find cutomer by login and phone number.

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

Suspend services by account.

Activate a card.

Change a service subsciption to a specified price plan.

Get reserved charge log lines details by account.

Get a list of available services.

Manually enable or disable the access service.

Add redirect phone number.

Register a customer in Self-Care portal.

Create a subscription to a network service.

Add a service to a to a current charge log.

Create prepayment invoice.

Get states of services that the customer has subscribed to.

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

Remove a child service subscription from a price plan subscription.

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.

Change a service subsciption to a specified price plan.

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

Set customer additional parameter.

Set promised pay for an account.

Cancel auto top up subscription.

Remove a service from a current charge log.

Stop temporary suspension.

Stop temporary suspension.

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.

Change the Customer Care portal password for the current user.

Stop service suspension.

Stop services suspensions by account.

Get payments, charges and credit limits details.

Get current and already rendered services.

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).

Close redirect phone number period.

Fill the temporary table with detailed service usage statistics.

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

Reset customer cabinet password.

Setting active locale.

Unbind address from subject.

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

Kill session.

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

Raise an exception with custom code.

Raise an exception. Obsolete, use RAISE_ERROR instead.

Raise an exception with stack from existing exception.

Raise an exception.

Return caught error message with its full stack.

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

Reset counter by CDR.

Create external tables for network service.

Create data collect line.

Flush bad accounting lines to archive.

Find EX_DATA_COLLECT line for cumulative updates.

Create a charge log by subscription.

Load phone numbers, subscriptions and equipment.

Load regions.

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

Load provider equipment.

Load customers from a CSV file.

Load IP-addresses, service subscriptions and equipment.

Create or replace a mapping record.

Delete a mapping record.

Table type for values from bank statement contents.

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

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

Create or update a payment.

Load bank statement contents into the temporary table.

Delete a payment.

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

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

Lock an autopayment to be processed.

Set custom value to customer.

Set custom value to invoice.

Refund payment.

Get reversal payment order.

Activate a subscription to auto top-up.

Create new banks based on the prepared data.

Prepare data on new banks to be created.

Process a result of an autopayment.

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

Create or update a bank.

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

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

Cancel a subscription to auto top-up.

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

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

Get auto top up by account.

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

Create current accounts based on the prepared data.

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

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

Get not refunded payments list in date range.

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

Make a payment.

Set a payment rating.

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 list of account payments in date range.

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.

Check payment details.

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

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.

Get an account and its bank by an account number.

Get an account by its number and bank.

Find a customer and a customer account by a document. When it is a charge log, 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.

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 job parameter number value by parameter code.

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

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

Get list of account payments in date range.

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

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

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

Find a bank by a BIC and a correspondent account.

Get a bank by its code.

Get a payment type by its code.

Get details on a customer account.

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

Get a list of created unprocessed autopayments.

Get account and bank by firm base subject.

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

Add a value to a payment record.

Create or replace configuration template.

Sync configurations by equipment binds

Get template table row by ID

Delete configuration template.

Sync configurations by customer equipment

Sync configurations by version

Sync configurations by provider equipment

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

Create and update all profiles by firm.

Re-generate all substitutions for template deferred

Send profiles into queue.

Delete profile template.

Create and update profiles.

Re-generate all substitutions for template.

Re-generate all substitutions for template.

Remove profiles by template

Create or replace profile template attribute.

Create and update profiles for provider equipment.

Send profiles into queue by firm.

Create and update profiles for customer equipment.

Do not use this procedure.

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

Re-generate all profiles for equipment.

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

Re-generate all profiles for context.

Delete profile template attribute.

Send profiles into queue by base version.

Create or replace profile template.

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

Activate a voucher in payment mode or in service provisioning mode. HPD uses this procedure.

Activate a voucher in payment mode or in service provisioning mode.

Delete a voucher record.

Activate a voucher in payment mode or in service provisioning mode.

Load new vouchers from CSV. Each line must have the following fields: voucher number, account name (login) , PIN-code.

Change the state of a vouchers issuance statement. ATTENTION: this procedure must only be called from within SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE.

Check a voucher.

Create cards for a voucher issuance statement.

Create or replace a voucher record.

Create or replace document header. Attention: after calling this procedure you need to check if card numbers and PIN-codes are uniquie using SD_CARDS_PKG_S.CHECK_ISSUE_CARDS(num_N_DOC_ID).