Oracle API packages 5.1.2

Objects

ACC_BILLS_PKG

Invoice export for accounting software

  • PROCEDURE UNLOAD_DOCUMENTS
    Export invoices.

AP_USER_OFFICE_PKG

Customer care portal package

  • PROCEDURE ADD_GOOD_SUBSCR
    Add a child service subscription to a current price plan scubscrition.
  • FUNCTION ADD_GOOD_SUBSCR
    Add a child service subscription to a current price plan scubscrition.
  • PROCEDURE AV_SERVICE_CHANGE_STATE
    Change antivirus software subscription state.
  • FUNCTION CUSTOMER_BY_LOGIN_AND_PHONE
    Find cutomer by login and phone number.
  • PROCEDURE PUT_SUBJ_VALUE
    Specify a value of a subject custom field. Cannot be used with custom fields that are multiple.
  • FUNCTION USERS_BILLED_SERVS_LIST
    Get current and already rendered services.
  • FUNCTION ADD_TARIFF
    Add a new price plan for the next belling period (if there is no active subscription).
  • PROCEDURE ADD_TARIFF
    Add a new price plan for the next belling period (if there is no active subscription).
  • PROCEDURE SI_SUBJ_ADDRESSES_DEL
    Unbind address from subject.
  • FUNCTION SUSPEND_SERVICE
    Suspend subscription.
  • FUNCTION ADD_AV_SERVICE
    Create antivirus software subscription.
  • PROCEDURE DO_TARIFF_CHANGE
    Change a service subsciption to a specified price plan.
  • FUNCTION GET_ACC_RESERVED_LIST
    Get reserved charge log lines details by account.
  • PROCEDURE GET_PROMISED_PAY
    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.
  • FUNCTION STOP_TEMP_BLOCKING
    Stop temporary suspension.
  • PROCEDURE STOP_TEMP_BLOCKING
    Stop temporary suspension.
  • FUNCTION USER_AVAILABLE_SERVS_LIST
    Get a list of available services.
  • FUNCTION GET_USER_GOODS_STATES
    Get states of services that the customer has subscribed to.
  • PROCEDURE PASSWD
    Change the Customer Care portal password for the current user.
  • PROCEDURE SUBSCRIBE_ON_SERVICE
    Create a subscription to a network service.
  • FUNCTION USERS_ACC_DETALIZATION
    Get payments, charges and credit limits details.
  • FUNCTION GET_USER_GOODS_ENDING
    Get a list of subscriptions with dates the service provisioning ends. Based on the reserved lines of charge logs.
  • PROCEDURE REMOVE_GOOD_SUBSCR
    Remove a child service subscription from a price plan subscription.
  • PROCEDURE RESET_PASSWORD
    Reset customer cabinet password.
  • PROCEDURE SET_ACTIVE_LOCALE
    Setting active locale.
  • PROCEDURE SET_PROMISED_PAY
    Set promised pay for an account.
  • PROCEDURE FILL_DETAILED_SERV_STAT
    Fill the temporary table with detailed service usage statistics.
  • PROCEDURE CANCEL_AUTO_TOP_UP
    Cancel auto top up subscription.
  • PROCEDURE REGISTER_USER_OFFICE_SUBSCR
    Register a customer in Self-Care portal.
  • FUNCTION SUSPEND_ACCOUNT_SERVICES
    Suspend services by account.
  • PROCEDURE UNLOCK_SERVICE
    Stop service suspension.
  • FUNCTION UNSUSPEND_ACCOUNT_SERVS
    Stop services suspensions by account.
  • PROCEDURE ACCESS_SERV_CHG_STATE
    Manually enable or disable the access service.
  • PROCEDURE ACTIVATE_CARD
    Activate a card.
  • PROCEDURE ADD_GOOD_TO_INVOICE
    Add a service to a to a current charge log.
  • FUNCTION CHANGE_TARIFF
    Change a service subsciption to a specified price plan.
  • PROCEDURE CREATE_PREPAYMENT_BILL
    Create prepayment invoice.
  • PROCEDURE PROCESS_ADD_GOODS
    Enable or disable additional periodic services within a price plan subscription.
  • PROCEDURE PUT_OBJ_VALUE
    Specify a value of an equipment custom field. Cannot be used with custom fields that are multiple.
  • PROCEDURE REMOVE_GOOD_FROM_INVOICE
    Remove a service from a current charge log.
  • PROCEDURE SI_SUBJ_ADDRESSES_PUT_EX
    Create or replace address and address-to-subject bind.

EP_SESSIONS_PUB_PKG

Provisioning sessions management

  • PROCEDURE KILL_SESSION
    Kill session.

ERRORS_PKG_S

Errors and exceptions

  • PROCEDURE RAISE_ERROR
    Raise an exception.
  • PROCEDURE RAISE_ERROR_WITH_CODE
    Raise an exception with custom code.
  • PROCEDURE RE_RAISE_ERROR_OLD
    Raise an exception with stack from existing exception. Uses ERROR type for new exception.
  • PROCEDURE RAISE_ERROR_OLD
    Raise an exception. Obsolete, use RAISE_ERROR instead.
  • PROCEDURE RE_RAISE
    Raise an exception with stack from existing exception.
  • FUNCTION GET_ERROR_MESSAGE
    Return caught error message with its full stack.

EX_AAA_PKG

Внешний API для работы с CDR и AAA-сервером (заточено под FreeRADIUS)

  • TYPE RAD_NAS_OBJ_TABLE_TYPE PL/SQL TABLE
  • PROCEDURE OBJ_VALUE_PUT
    Сохранение доп. параметра оборудования. Используется в HARD.

EX_DATA_COLLECT_PKG

Collecting data usage statistics

  • PROCEDURE CREATE_EXTERNAL_TABLES
    Create external tables for network service.
  • PROCEDURE EX_DATA_COLLECT_RESET
    Reset counter by CDR.
  • PROCEDURE FLUSH_BAD_ACCOUNTING
    Flush bad accounting lines to archive.
  • PROCEDURE EX_DATA_COLLECT_PUT
    Create data collect line.
  • FUNCTION FIND_DATA_COLLECT_LINE
    Find EX_DATA_COLLECT line for cumulative updates.

EX_LOADINGS_PKG

External data bulk loading

  • PROCEDURE LOAD_PHONE_NUMBERS_FROM_CSV
    Load phone numbers, subscriptions and equipment.
  • PROCEDURE LOAD_REGIONS_FROM_CSV
    Load regions.
  • PROCEDURE LOAD_USERS_FROM_CSV
    Load customers from a CSV file.
  • PROCEDURE CREATE_WHOLE_REGION_BRANCH
    Create entire region branch (used in the bulk loading of regions).
  • PROCEDURE LOAD_PROV_EQUIP_FROM_CSV
    Load provider equipment.
  • PROCEDURE LOAD_IP_ADDRESSES_FROM_CSV
    Load IP-addresses, service subscriptions and equipment.
  • PROCEDURE CREATE_INVOICE_BY_SUBJ_GOOD
    Create a charge log by subscription.
  • PROCEDURE LOAD_ACTUAL_INVOICES_FROM_CSV
    Load actual charge logs.

EX_MAPPINGS_PKG

Mappings for external entities

  • PROCEDURE EX_MAPPINGS_DEL
    Delete a mapping record.
  • PROCEDURE EX_MAPPINGS_PUT
    Create or replace a mapping record.

EX_PAYMENTS_PKG

Loading and processing payments from external systems.

  • TYPE BANK_STATEMENT_ROW PL/SQL RECORD
    Value from bank statement contents.
  • TYPE TT_BANK_STATEMENT_TYPE PL/SQL TABLE
    Table type for values from bank statement contents.
  • PROCEDURE CANCEL_AUTO_TOP_UP
    Cancel a subscription to auto top-up.
  • PROCEDURE CREATE_AUTO_TOP_UP
    Create a subscription to auto top-up according to a rule.
  • FUNCTION GET_TRANSACTION_ID_FOR_CHARGE
    Get a value of a bank's "Transaction ID counter" field The function is used by the HPD agent.
  • FUNCTION GET_TRANSACTION_ID_FOR_CHARGE
    Get a value of a bank's "Transaction ID counter" field
  • PROCEDURE EX_PAYMENTS_SET_RATING
    Set a payment rating.
  • PROCEDURE BANK_PUT
    Create or update a bank.
  • PROCEDURE EX_CREATE_NEW_BANKS
    Create new banks based on the prepared data.
  • FUNCTION GET_TXN_ID_BY_CODE
    Get a value of a bank's "Transaction ID counter" field
  • PROCEDURE TRY_TO_CANCEL_PAY_REQ_BY_DOC
    Cancel all payment requests for an account specified in a payment order.
  • FUNCTION BANK_STATEMENT_TO_TT
    Load bank statement contents into the temporary table.
  • PROCEDURE CREATE_PAYMENT
    Make a payment.
  • PROCEDURE EX_CREATE_NEW_ACCOUNTS
    Create current accounts based on the prepared data.
  • PROCEDURE EX_PAYMENTS_CHARGE
    DEPRECATED: please use CREATE_PAYMENT instead. Make a payment. The procedure is used by the HPD agent.
  • PROCEDURE LOAD_PAYMENTS_1C
    Load payments from 1C. Warning: please use the UTF-8 encoding.
  • PROCEDURE SET_TOP_UP_REQUEST_RESULT
    Process a result of an autopayment.
  • PROCEDURE EX_PAYMENTS_CHANGE_DOC_STATE
    Change a payment document status. The procedure is used by the HPD agent.
  • PROCEDURE ACTIVATE_AUTO_TOP_UP
    Activate a subscription to auto top-up.
  • PROCEDURE CREATE_ATU_SUBSCRIPTION
    Create a new subscription to auto top-up for an account and cancel existing unverified ones.
  • PROCEDURE EX_PAYMENTS_CHARGE_VIRTUAL
    Make a virtual payment. The procedure is used by the HID agent.
  • PROCEDURE EX_PREPARE_NEW_BANKS
    Prepare data on new banks to be created.
  • FUNCTION LOCK_TOP_UP_REQUEST
    Lock an autopayment to be processed.
  • PROCEDURE EX_PAYMENTS_PUT
    Create or update a payment.
  • PROCEDURE EX_PAYMENTS_PUT
    Create or update a payment record.
  • PROCEDURE EX_PAYMENTS_CHANGE_STATE
    Change a bank statement status. Warning: this procedure is called only by SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE.
  • PROCEDURE EX_PAYMENTS_DEL
    Delete a payment.
  • PROCEDURE EX_PREPARE_NEW_ACCOUNTS
    Prepare data on new current accounts to be added to organizations.
  • PROCEDURE UPDATE_AUTO_TOP_UP_TOKEN
    Update a token for an active subscription to auto top-up.

EX_PAYMENTS_PKG_S

Retrieving data on payments, accounts, banks, subscriptions to auto top-up and autopayments.

  • TYPE ACCOUNT_DETAILS_TBL PL/SQL TABLE
    Table type for details on customer accounts.
  • TYPE AUTO_TOP_UPS_INIT_CHARGES_TBL PL/SQL TABLE
    Table type for subscriptions to auto top-up found by initial payments.
  • TYPE DOC_NO_RATING_TABLE PL/SQL TABLE
    Table type for document numbers and their ratings.
  • TYPE PAYMENT_FORWHO_TABLE_TYPE PL/SQL TABLE
    Table type for data on customers, basic subjects and accounts.
  • TYPE TOP_UP_CARD_CHARGES_TBL PL/SQL TABLE
    Table type for created unprocessed autopayments.
  • TYPE USER_RATING_TABLE PL/SQL TABLE
    Table type for customers with customer accounts and ratings.
  • PROCEDURE GET_BANK_ID
    Find a bank by a BIC and a correspondent account.
  • FUNCTION GET_BANK_ID
    Get a bank by its code.
  • FUNCTION CHECK_PAY_PARAMS
    Check payment details.
  • FUNCTION GET_ACCOUNT_DETAILS_P
    Get details on a customer account.
  • PROCEDURE GET_ACCOUNT_INFO
    Find a customer account to credit a payment. The procedure is used by the HPD agent.
  • FUNCTION GET_PAY_TYPE_ID
    Get a payment type by its code.
  • PROCEDURE GET_ACCOUNT_BY_DOCUMENT
    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.
  • FUNCTION GET_ACCOUNT_ID
    Get an account by its number and bank.
  • PROCEDURE GET_PAYMENT
    Find a payment order by payment details. The procedure is used by the HPD agent.
  • FUNCTION GET_TOP_UP_REQUESTS
    Get a list of created unprocessed autopayments.
  • PROCEDURE GET_ACCOUNT_RATING_FOR_PAYMENT
    Get a rating that represents an accuracy of matching payment data with data on a customer's account and a basic subject.
  • PROCEDURE GET_ADDITIONAL_ACCOUNT_INFO
    Get an individual's last name, fist name and middle name or an organization's name by an account.
  • FUNCTION GET_PAYMENT_ID_BY_TXN_ID
    Find a payment order by payment details. The function is used by the HPD agent.
  • FUNCTION IS_PAYMENT_EXIST
    Check whether a payment with specified data exists. The function is used by the HPD agent.
  • PROCEDURE FIND_USER_ACCOUNT_BY_PAYMENT
    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.
  • FUNCTION GET_ACCOUNT_ID_FOR_CHARGE
    Find a customer account to credit a payment. The function is used by the HPD agent.
  • FUNCTION GET_ATU_INIT_CHARGES
    Get a list of subscriptions to auto top-up found by an initial payment.
  • FUNCTION GET_SUBJECT_INFO
    Get data on a subject (an individual or an organization).
  • PROCEDURE GET_ACCOUNT_AND_BANK_BY_NUMBER
    Get an account and its bank by an account number.
  • FUNCTION IS_PAYMENT_READY_FOR_CREATE
    Check if there is enough data to create a payment document.
  • PROCEDURE PARSE_PAYMENT_1C
    Add a value to a payment record.

RP_CONFIGURATIONS_PKG

  • PROCEDURE SYNC_CONFIGURATIONS_BY_BINDS
    Sync configurations by equipment binds
  • PROCEDURE SP_CONFIGURATION_TEMPLATES_DEL
    Delete configuration template.
  • PROCEDURE SP_CONFIGURATION_TEMPLATES_PUT
    Create or replace configuration template.
  • PROCEDURE SYNC_CONFIGURATIONS_BY_PE
    Sync configurations by provider equipment
  • PROCEDURE SYNC_CONFIGURATIONS_BY_CE
    Sync configurations by customer equipment
  • PROCEDURE SYNC_CONFIGURATIONS_BY_VERSION
    Sync configurations by version
  • FUNCTION GET_TEMPLATE
    Get template table row by ID

RP_PROFILES_PKG

  • PROCEDURE SEND_ALL_PROFILES
    Send profiles into queue by firm.
  • PROCEDURE SEND_PROFILES_BY_BASE
    Send profiles into queue by base version.
  • PROCEDURE RECREATE_FOR_TEMPLATE
    Re-generate all substitutions for template.
  • PROCEDURE RECREATE_FOR_TEMPLATE
    Re-generate all substitutions for template.
  • PROCEDURE SYNC_CUSTOMER_PROFILES
    Create and update profiles for customer equipment.
  • PROCEDURE REMOVE_PROFILES_BY_TEMPLATE
    Remove profiles by template
  • PROCEDURE SP_PROFILE_TPLS_C_PUT
    Create or replace profile template attribute.
  • PROCEDURE SP_PROFILE_TPLS_PUT
    Create or replace profile template.
  • PROCEDURE RECREATE_FOR_CONTEXT
    Re-generate all profiles for context.
  • PROCEDURE SCHEDULE_RECREATE_FOR_TEMPLATE
    Re-generate all substitutions for template deffered
  • PROCEDURE SP_PROFILE_TPLS_C_DEL
    Delete profile template attribute.
  • PROCEDURE GENERATE_PROVIDER_EQ_PROFILES
    For provider equipment: generate profiles, send profiles into queue, generate commands.
  • PROCEDURE SEND_PROFILES
    Send profiles into queue.
  • PROCEDURE GENERATE_CUSTOMER_EQ_PROFILES
    For customer equipment: generate profiles, send profiles into queue, generate commands.
  • PROCEDURE RECREATE_FOR_EQUIPMENT
    Re-generate all profiles for equipment.
  • PROCEDURE SP_PROFILE_TPLS_DEL
    Delete profile template.
  • FUNCTION SYNC_ALL_PROFILES
    Create and update all profiles by firm.
  • PROCEDURE SYNC_PROVIDER_PROFILES
    Create and update profiles for provider equipment.
  • FUNCTION TRY_SYNC_ALL_PROFILES
    Create and update all profiles by firm if time interval was changed.
  • PROCEDURE GENERATE_ALL_IN_BATCHES
    Do not use this procedure.
  • PROCEDURE SYNCHRONIZE_PROFILES
    Create and update profiles.

SD_BALANCE_ADJUSTMENTS_PKG

  • PROCEDURE CHARGE_ADJUSTMENT
    Charge an adjustment of a specicfied amount against a specified account.

SD_BILLS_PKG

Invoices

  • TYPE RENDERED_SERVICES_TBL PL/SQL TABLE
  • FUNCTION GET_RENDERED_SERVICES
    Get cursor value.
  • PROCEDURE SD_BILLS_ADVANCE_CREATE
    Create proforma invoices
  • PROCEDURE SD_BILLS_C_DEL
    Delete invoice content line.
  • PROCEDURE SD_BILLS_CREATE
    Create invoices.
  • PROCEDURE SD_BILLS_C_PUT
    Create or replace invoice content line.
  • PROCEDURE SD_BILLS_T_PUT
    Create or replace invoice header.
  • FUNCTION SD_BILLS_PREPAYMENT_CREATE
    Create prepayment invoice.
  • PROCEDURE SD_BILLS_CHANGE_STATE
    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.

SD_CARDS_PKG

Vouchers issuance statement management

  • PROCEDURE CHECK_CARD
    Check a voucher.
  • PROCEDURE LOAD_CARDS
    Load new vouchers from CSV. Each line must have the following fields: voucher number, account name (login) , PIN-code.
  • PROCEDURE SD_CARDS_ISSUE_T_PUT
    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).
  • PROCEDURE ACTIVATE_CARD
    Activate a voucher in payment mode or in service provisioning mode. HPD uses this procedure.
  • FUNCTION ACTIVATE_CARD
    Activate a voucher in payment mode or in service provisioning mode.
  • FUNCTION REDEEM_CARD
    Activate a voucher in payment mode or in service provisioning mode.
  • PROCEDURE SD_CARDS_ISSUE_C_DEL
    Delete a voucher record.
  • PROCEDURE SD_CARDS_ISSUE_CHANGE_STATE
    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.
  • PROCEDURE CREATE_CARDS
    Create cards for a voucher issuance statement.
  • PROCEDURE SD_CARDS_ISSUE_C_PUT
    Create or replace a voucher record.

SD_CARDS_PKG_S

Service package for vouchers issuance statement management

  • PROCEDURE CHECK_CARD_LOGINS_FORMAT
    Check if logins have the correct format. Raises an exception if the logins consist not only of latin letters and numbers.
  • PROCEDURE CHECK_ISSUE_CARDS
    Check if voucher numbers and PIN-codes are correct. The procedure looks for collisions in PIN-codes and numbers of vouchers in voucher issuance statements by the same provider and with periods intersecting with the given document. Raises an exception if the numbers and PIN-codes with wrong formats were found. Uniqueness is checked inly of the activation type "PIN code only" is specified in the vouchers issuance statement. Raises an exception if the collisions were found.
  • PROCEDURE CHECK_CARD_LOGINS_UNIQ
    Check uniqueness of voucher logins by document. The procedure looks for collisions in all voucher issuance statements by the same provider and with periods intersecting with the given document. Raises an exception if the collisions were found.
  • PROCEDURE CHECK_CARD_NUMBERS
    Check uniqueness of voucher numbers by document. The procedure looks for collisions in all voucher issuance statements by the same provider and with periods intersecting with the given document. Raises an exception if the collisions were found.
  • PROCEDURE CHECK_CARD_PINS_FORMAT
    Check if PIN-codes have the correct length and formats. Raises an exception if the length or format does not match the ones specified in the vouchers issuance statement.
  • PROCEDURE CHECK_CARD_PINS_UNIQ
    Check uniqueness of voucher PIN-codes by document. The procedure looks for collisions in all voucher issuance statements by the same provider and with periods intersecting with the given document. Raises an exception if the collisions were found.

SD_COMMITMENTS_PUB_PKG

Contract commitments

  • PROCEDURE CANCEL_ETF
    Cancel early termination fee charge.
  • PROCEDURE RENEW_COMMITMENT
    Renew contract commitment.
  • PROCEDURE TERMINATE_CONTRACT_EARLY
    Terminate contract commitment.
  • PROCEDURE REPLACE_EQUIPMENT
    Change equipment in commitment.

SD_CONTRACTS_PKG

Customer contract management

  • PROCEDURE DISSOLVE
    Terminate a contract.
  • PROCEDURE TRANSIT_CONTRACT_STATE
    Change contract/annex/addendum state (with disabled manual transition checks).
  • PROCEDURE SD_CONTRACTS_DISSOLVE
    Terminate contract/appendix/addendum. 1) Sets the charge logs end dates to contract termination date. 2) Sets the subscriptions end dates to contract termination date. 3) Deletes the subscriptions to services that can be provided after the contract is terminated. 4) Sets the contract end date.
  • PROCEDURE SD_CONTRACTS_COPY
    Copy a contract/appendix/addendum.
  • PROCEDURE SD_CONTRACTS_CHANGE_STATE
    Change contract/appendix/addendum state. Attention: this procedure is only to be called from SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE. Actual state change is happening there. This procedure only performs contract-specific operations.
  • PROCEDURE SD_CONTRACTS_PUT
    Create or replace a customer contract.

SD_DOCUMENTS_PKG

Documents management.

  • PROCEDURE SD_DOC_COMMENTS_DEL
    Delete a comment.
  • PROCEDURE SD_DOC_VALUES_DEL
    Delete a document custom field.
  • PROCEDURE SI_DOC_OBJECTS_DEL
    Delete a binding between an object and a document.
  • PROCEDURE PUT_DOC_SUBJECT
    Assign a role to a subject in a document. Unspecified subject is found by an account.
  • PROCEDURE SD_DOCUMENTS_CHANGE_STATE
    Change a document status.
  • PROCEDURE SD_DOCUMENTS_DEL
    Delete a document.
  • PROCEDURE SD_DOCUMENTS_PUT
    Create or update a document.
  • PROCEDURE SD_DOC_COMMENTS_PUT
    Add or update a comment to a document.
  • PROCEDURE SD_DOC_COMMENTS_UNSET_EXEC
    Clear a comment execution date.
  • PROCEDURE SI_DOC_OBJECTS_PUT
    Add or update a binding between an object and a document.
  • PROCEDURE SI_DOC_SUBJECTS_DEL
    Delete a binding between a subject and a document.
  • PROCEDURE SI_DOC_SUBJECTS_PUT
    Add or update a binding between a subject and a document. Unspecified subject is found by an account.
  • PROCEDURE RENUMERATE_LINES
    Renumber contents lines in the document. When foreign key names for parent and child lines are passed, the procedure renumbers all nesting levels. When no child foreign key is passed, all lines are renumbered using the foreign key for parent lines. In this case, child lines (if any) will be numbered in the same way as the parent ones. If you want to renumber only child lines, pass only the child foreign key and use a recursion level equal to 1.
  • PROCEDURE SD_DOC_COMMENTS_SET_EXEC
    Set a comment execution date.
  • PROCEDURE SD_DOC_FILES_PUT
    Add or update a binding between a file and a document.
  • PROCEDURE TAG
    Tag a document.
  • PROCEDURE PUT_DOC_VALUE
    Add a value of a document custom field. Warning: do not use this procedure for custom fields that can have multiple values. The procedure is used by the HID agent.
  • PROCEDURE SD_DOCUMENTS_COPY
    Copy a document.
  • PROCEDURE SD_DOC_FILES_DEL
    Delete a binding between a file and a document.
  • PROCEDURE SD_DOC_DOCUMENTS_DEL
    Delete a binding between documents.
  • PROCEDURE SD_DOC_DOCUMENTS_PUT
    Add or update a binding between documents.
  • PROCEDURE SD_DOC_VALUES_PUT
    Add or update a value of a document custom field. The procedure is used by the HID agent.

SD_DOCUMENTS_PKG_S

Retrieving data on documents and their custom fields.

  • TYPE DOC_COMMENT_TABLE_TYPE PL/SQL TABLE
    Table type for comments to documents.
  • TYPE DOC_COMMENT_TYPE PL/SQL RECORD
    Document comment.
  • TYPE DOC_PERIOD_TABLE_TYPE PL/SQL TABLE
    Table type for documents with their periods.
  • TYPE DOC_PERIOD_TYPE PL/SQL RECORD
    Document with its validity period.
  • TYPE DOC_STATE PL/SQL RECORD
    Document status.
  • TYPE DOC_STATES_LIST PL/SQL TABLE
    Table type for document statuses.
  • TYPE SD_DOC_BINDS_LIST PL/SQL RECORD
    Binding between documents.
  • TYPE SD_DOC_BINDS_LIST_TABLE_TYPE PL/SQL TABLE
    Table type for bindings between documents.
  • TYPE SD_DOC_FILES_TABLE_TYPE PL/SQL TABLE
    Table type for document print templates.
  • TYPE SD_DOC_FILE_TYPE PL/SQL RECORD
    Print template for a document.
  • TYPE SD_DOC_LIST PL/SQL RECORD
    Document bound to a specific document.
  • TYPE SD_DOC_LIST_TABLE_TYPE PL/SQL TABLE
    Table type for documents bound to a specific document.
  • FUNCTION GET_ADDR_BY_ROLE
    Get an address by a role in a document.
  • FUNCTION GET_D_TIME
    Get a document time.
  • FUNCTION GET_HIGHER_DOC_LIST
    Get a list of parent documents.
  • PROCEDURE CHK_DOC_CONTAINDED_PERIOD
    Check for a document period to be nested in a period of another (basic) document. Start dates of the document periods are to be non-empty.
  • FUNCTION GET_ACCOUNT_BY_ROLE
    Get a subject's account by a role in a document.
  • FUNCTION GET_DOC_BY_BIND
    Get a document bound to a specified one.
  • FUNCTION GET_D_END
    Get an end date of a document validity period.
  • FUNCTION GET_N_FIRM_ID
    Get a division a document belongs to.
  • FUNCTION GET_N_REASON_DOC_ID
    Get a reason document.
  • FUNCTION GET_PAYMENT_HISTORY_COMMENT
    Get a comment on a payment by a document.
  • PROCEDURE CHK_DOCS_SUBJECTS
    Check if a subject that is assigned a specified role in a document has a role in another (basic) document.
  • PROCEDURE CLEAR_DUBS_TT_V_DOC_BINDS
    Delete duplicates with data on bound documents from the temporary table TT_V_DOC_BINDS.
  • FUNCTION GET_DOC_C_VALUE
    Get a char value of a custom field.
  • FUNCTION GET_DOC_C_VALUE
    Get a char value of a custom field.
  • FUNCTION GET_DOC_N_REF_ID
    Get a value of a drop-down list (a reference value).
  • FUNCTION GET_DOC_N_REF_ID
    Get a value of a drop-down list (a reference value).
  • FUNCTION GET_DOC_PERIOD_STRING
    Get a document validity period as a string.
  • FUNCTION GET_DOC_VALUE
    Get a document record.
  • FUNCTION GET_N_CONTRACT_ID
    Get a service contract by an annex or an addendum.
  • FUNCTION GET_N_DOC_TYPE_ID
    Get a document type.
  • FUNCTION GET_N_SINGLE_DOC_ID
    Get a document by a provider. Warning: the function works only for documents that are unique in terms of periods and providers.
  • FUNCTION GET_SUBJECT_BY_ROLE
    Get a subject by a role in a document.
  • FUNCTION IS_DOC_DRAFT
    Check whether a document is a draft.
  • PROCEDURE CHK_DOC_PERIOD
    Check (and adjust if needed) a document period.
  • PROCEDURE GEN_DOC_CODE_NAME_IF_NEEDED
    Generate a document code and name (if not generated yet).
  • FUNCTION GET_DOC_PATTERN_FILES_LIST
    Get a list of document print templates.
  • FUNCTION GET_N_DOC_STATE_ID
    Get a document status.
  • FUNCTION GET_N_PARENT_DOC_ID
    Get a parent document.
  • FUNCTION GET_VC_DOC_CODE
    Get a document code.
  • FUNCTION IS_EXIST_DOC_NO
    Check whether an uncanceled document with the same number as the specified document exists.
  • PROCEDURE CHECK_SINGLE_DOC_PERIOD_CLN
    Check a document period. The procedure searches for a document with the same type, provider and client as the specified one, and a period that overlaps the document period. If such a document is found, an error message is added to the temporary table TT_MESSAGE_LOGS.
  • FUNCTION DOCUMENT_SUBJECTS_HISTORY
    Get a list of changes in subjects bound to a document.
  • FUNCTION DOCUMENT_VALUES_HISTORY
    Get a list of changes in document custom fields values.
  • PROCEDURE GENERATE_DOC_CODE_NAME
    Generate a document code and name.
  • FUNCTION GET_AVAILABLE_DOC_TRANSITIONS
    Get a list of statuses a document can be transferred to from its current status.
  • FUNCTION GET_DOC_BINDS_DOC_LIST
    Get a list of all bound documents.
  • FUNCTION GET_DOC_C_FL_VALUE
    Get a value of a check box custom field.
  • FUNCTION GET_DOC_C_FL_VALUE
    Get a value of a check box custom field.
  • FUNCTION GET_DOC_VALUE_ROW
    Get a record with a value of a custom field.
  • FUNCTION GET_DOC_VALUE_ROW
    Get a record with a value of a custom field.
  • FUNCTION GET_DOC_VC_VALUE
    Get a string value of a custom field.
  • FUNCTION GET_DOC_VC_VALUE
    Get a string value of a custom field.
  • FUNCTION GET_N_SUBDOC_WORKFLOW_ID
    Get a service contract workflow by a basic contract.
  • FUNCTION GET_VALUE_BY_ROLE
    Get a record for a binding between a subject and a document.
  • FUNCTION GET_VC_DOC_NO
    Get a document number.
  • FUNCTION DOCUMENT_HISTORY
    Get a list of changes in document parameters common for all documents.
  • FUNCTION DOCUMENT_OBJECTS_HISTORY
    Get a list of changes in objects bound to a document.
  • FUNCTION GET_DOC_NEAREST_DOC_LIST
    Get a list of closest bound documents.
  • FUNCTION GET_DOC_PERIOD_INTERSECT
    Check whether periods of two documents intersect. Warning: please avoid using this function in SELECT statements since no indexes for period start and end dates are used.
  • FUNCTION GET_DOC_PERIOD_INTERSECT
    Check whether periods of two documents overlap. Warning: please avoid using this function in SELECT statements since no indexes for period start and end dates are used.
  • FUNCTION GET_INTERSECT_DOC_LIST
    Get a list of documents which periods overlap with a specified one.
  • FUNCTION GET_LAST_COMMENT
    Get the last comment to a document.
  • FUNCTION GET_STORNO_PROC_BY_DOC
    Get a procedure for copying a document and check whether the document can be reversed.
  • FUNCTION GET_VC_DOC_NAME
    Get a document name.
  • PROCEDURE CHECK_SINGLE_DOC_PERIOD
    Check a document period. The procedure is for documents that must exist at any given time, be unique in terms of periods and providers, and have non-empty period start dates (exchange rates specifications, time intervals specifications). It searches for intersections and gaps between document periods. If there are any, error messages are added to the temporary table TT_MESSAGE_LOGS.
  • FUNCTION DOCUMENT_ADDRESSES_HISTORY
    Get a list of changes in addresses bound to a document.
  • FUNCTION DOCUMENT_CONTENT_HISTORY
    Get a list of changes in document contents.
  • FUNCTION DOCUMENT_GOODS_HISTORY
    Get a list of changes in services bound to a document.
  • FUNCTION DOCUMENT_GOOD_AUTHORS
    Get a list of users who created subscriptions.
  • FUNCTION DOCUMENT_SPECIAL_HISTORY
    Get a list of changes in document parameters specific for this type of documents.
  • PROCEDURE FILL_TT_V_DOC_BINDS
    Fill the temporary table TT_V_DOC_BINDS with data on bound documents.
  • FUNCTION GET_ADDR_VALUE_BY_ROLE
    Get a record for a binding between an address and a document.
  • FUNCTION GET_DOC_D_VALUE
    Get a date value of a custom field.
  • FUNCTION GET_DOC_D_VALUE
    Get a date value of a custom field.
  • FUNCTION GET_DOC_N_VALUE
    Get a numerical value of a custom field.
  • FUNCTION GET_DOC_N_VALUE
    Get a numerical value of a custom field.
  • FUNCTION GET_NEIGHBOR_DOC_LIST
    Get a list of documents with the same type and provider as a specified one, ordered by document periods start dates. You can restrict start and end dates in document periods.
  • FUNCTION GET_NEXT_DOC_NO
    Get the next available number by a document type.
  • FUNCTION GET_N_DOC_WORKFLOW_ID
    Get a document workflow.
  • FUNCTION GET_OBJ_VALUE_BY_ROLE
    Get a record for a binding between an object and a document.
  • FUNCTION GET_DOC_CL_VALUE
    Get a CLOB value of a custom field.
  • FUNCTION GET_DOC_CL_VALUE
    Get a CLOB value of a custom field.
  • FUNCTION GET_D_BEGIN
    Get a start date of a document validity period.
  • FUNCTION GET_OBJECT_BY_ROLE
    Get an object by a role in a document.
  • FUNCTION GET_ROOT_BASE_CONTRACT_ID
    Get a top-level basic contract for a contract.
  • FUNCTION GET_SUBJECT_BY_PARENT_ROLE
    Get a subject by a role either in a document or one of its parent documents.

SD_INVOICES_PKG

DEPRECATED in v5.1! Charge log management

  • PROCEDURE SD_INVOICES_C_DEL
    Delete a charge log line.
  • PROCEDURE CANCEL_CHARGE_LOG
    Cancel charge log.
  • PROCEDURE CHANGE_INVOICE_PERIOD
    Change end date of a charge log (both premature closing and stretching of a charge log).
  • PROCEDURE SET_CHARGE_LOG_CLOSE_REASON
    Set charge log end.
  • PROCEDURE DISCONNECT_ACCESS_SERVS
    DEPRECATED in v5.1! Switch off all access services by account.
  • PROCEDURE ACCESS_SERV_CHG_STATE
    DEPRECATED in v5.1! Switch access service on/off.
  • PROCEDURE EXECUTE_CHARGE_LOG
    Change charge log state to executed.
  • PROCEDURE SD_INVOICES_T_PUT
    Create or replace charge log header.
  • PROCEDURE CONNECT_ACCESS_SERVS
    DEPRECATED in v5.1! Switch on all access services by account.
  • PROCEDURE SD_INVOICES_C_PUT
    Create or replace a charge log content line.
  • PROCEDURE RAISE_DOC_EVENTS
    DEPRECATED in v5.1! Generate events by charge log.
  • PROCEDURE ACTUALIZE_CHARGE_LOG
    Change charge log state to actual.
  • PROCEDURE CORRECT_INVOICE_TOTAL_SUMS
    Correcting decimal amounts by charge log.
  • PROCEDURE MAKE_CHARGE_LOG_CLOSABLE
    Make charge log closable.
  • PROCEDURE COMPRESS_CHARGE_LOG
    Compress charge log contents. Collapses lines in SD_GOOD_MOVES.

SD_INVOICES_PKG_S

DEPRECATED in v5.1! Service package for charge log management

  • TYPE DEFER_PARAMS PL/SQL RECORD
    Defer params from price order by charge log.
  • TYPE GOOD_BURST_VALUE PL/SQL RECORD
    Current burst value for service.
  • TYPE GOOD_BURST_VALUE_TYPE PL/SQL TABLE
  • FUNCTION GET_APPLIED_PROVISION_RULE
    Get provision rule that charge log was created with.
  • FUNCTION GET_DOC_FOR_CURRENT_GOOD
    Определить инвойс для оказываемой в текущий момент услуги.
  • FUNCTION GET_INVOICE_PAR_LINE_FOR_GOOD
    Подбор подходящей родительской строки в инвойсе для потоковых услуг.
  • FUNCTION GET_PRICE_BY_RGMT
    Определить по ОРДУ действующую строку ПЦ для потоковой услуги.
  • FUNCTION GET_LAST_TARIFF
    Определение последнего тарифного плана абонента.
  • FUNCTION GET_PRICE_LINE_AND_ACCOUNT
    Определение родительской строки ПЦ и счета по услуге в составе тарифного плана.
  • FUNCTION GET_INVOICE_LINE_FOR_GOOD
    Get latest charge log line for a specified service and a customer/account/contract/equipment within a specified time period.
  • FUNCTION GET_NONPAY_BLOCK_INVOICE
    Определение текущего инвойса по блокировке за неуплату по лицевому счету.
  • FUNCTION GET_PREPARED_CHARGE_LOG
    Get prepared charge log by subscription. Raises too_many_rows if several prepared charge logs found.
  • FUNCTION IS_NONPAY_SUSPENSION_CL
    Check if charge log is for nonpayment suspension
  • FUNCTION GET_INVOICE_BEGIN_DATE
    Определение даты начала действия инвойса.
  • FUNCTION GET_DEFER_PARAMS
    Get price order defer parameters by charge log.
  • FUNCTION GET_INVOICE_ID_BY_SUBJ_GOOD
    Определение инвойса по подписке на услугу.
  • FUNCTION GET_INVOICE_LINE_BY_OBJECT
    Определить строку движения по оборудованию и детальной услуге, входящей в неизвестный тарифный план.
  • FUNCTION GET_BILLING_DATE
    Get charge log billing date.
  • FUNCTION GET_CLOSE_REASON_ID
    Получение причины закрытия инвойса.
  • FUNCTION GET_INVOICE_BY_CONTRACT
    Определить последний инвойс по договору и счету (без учета того, выставлен инвойс по тарифному плану или услуге).
  • FUNCTION CALC_PRICE_FOR_INVOICE_GOOD
    Расчет стоимости подключения услуги в составе пакета по действующему инвойсу.
  • FUNCTION GET_BLOCKING_GP_PRICE
    Определение тарифа блокировки по договору на оказание услуг, доп. соглашению или приложению.
  • FUNCTION GET_INVOICE_BURST_VALUES
    Получение текущих значений burst для услуг в составе тарифного плана.
  • FUNCTION GET_INVOICE_LINE_PRICE_GOOD
    Определить строку движения по фирме, оборудованию и детальной услуге, входящей в неизвестный тарифный план.
  • FUNCTION GET_PRICE_DOC
    Получение заголовка приказа по ценам, который используется в инвойсе.

SD_OVERDRAFTS_PKG

Credit limit management

  • PROCEDURE REPAY_OVERDRAFT
    Repay currently active credit limit.
  • PROCEDURE SD_OVERDRAFTS_CHANGE_STATE
    Change state of a credit limit certificate. Attention: this procedure is only to be called from SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE. Actual state change is happening there. This procedure only performs discount-certificate-specific operations.
  • PROCEDURE SET_PERMANENT_OVERDRAFT
    Set permanent credit limit.
  • PROCEDURE RG_OVERDRAFTS_PUT
    Create or replace a record in the credit limit register.
  • PROCEDURE SD_OVERDRAFTS_PUT
    Create or replace a credit limit record.
  • PROCEDURE RG_OVERDRAFTS_RECALC_BY_DOC
    Recreate credit limit register lines by a document.
  • PROCEDURE SET_TEMPORAL_OVERDRAFT
    Set temporary credit limit.
  • PROCEDURE CLOSE_OVERDRAFT_BY_CONTRACT
    Close credit limits by contract.
  • PROCEDURE UNSET_PERMANENT_OVERDRAFT
    Remove currently active permanent credit limit.
  • PROCEDURE SD_OVERDRAFTS_DEL
    Delete a credit limit record.
  • PROCEDURE UNSET_TEMPORAL_OVERDRAFT
    Remove currently active temporary credit limit.

SD_OVERDRAFTS_PKG_S

Service functions for credit limit management

  • TYPE ACCOUNT_OVERDTAFT PL/SQL RECORD
    Credit limit record for customer credit limit history.
  • TYPE ACC_OVERDTAFT_LIST_TABLE_TYPE PL/SQL TABLE
  • TYPE TOTAL_CREDIT_LIMIT PL/SQL RECORD
    Amount of all credit limits.
  • TYPE TOTAL_CREDIT_LIMIT_ROWS PL/SQL TABLE
  • FUNCTION GET_ACCOUNT_OVERDRAFTS_LIST
    Get history of credit limits for account.
  • FUNCTION GET_CUR_OVERDRAFT
    Get current credit limit amount.
  • FUNCTION GET_TOTAL_CREDIT_LIMIT
    Get total credit limit amount and the closest credit limit end date.
  • FUNCTION GET_LAST_PROMISED_PAYMENT
    Get last promised payment info.
  • PROCEDURE GET_ACCOUNT_OVERDRAFT
    Get total credit limit amount and the closest credit limit end date.
  • PROCEDURE GET_TEMPORAL_OVERDRAFT
    Get a current temporary credit limit and the nearest closing date.
  • PROCEDURE GET_PERMANENT_OVERDRAFT
    Get permanent credit limit.

SD_PAYMENTS_PKG

Payment documents management

  • PROCEDURE SD_PAYMENTS_CHANGE_STATE
    Change document state. Attention: this procedure is only to be called from SD_DOC_STATES_PKG.SD_DOCUMENTS_CHANGE_STATE.
  • PROCEDURE SD_PAYMENTS_C_PUT
    Create or replace payment document content line.
  • PROCEDURE SD_PAYMENTS_T_PUT
    Create or replace a payment.
  • PROCEDURE SD_PAYMENTS_CHARGE
    Create payment.
  • PROCEDURE SD_PAYMENTS_C_DEL
    Delete payment document content line.

SD_REPORTS_PKG

Reports handling

  • TYPE RPT_ACCOUNT_BALANCE_TABLE_TYPE PL/SQL TABLE
  • TYPE RPT_ACCOUNT_BALANCE_TYPE PL/SQL RECORD
    Record type for customer accounts status report.
  • FUNCTION RPT_ACCOUNT_BALANCE
    Customer account status report.
  • PROCEDURE SET_REPORT_DATE
    Set report date.
  • FUNCTION GET_REPORT_DATE
    Get report date.

SD_REQUESTS_PKG

Работа с заявками

  • PROCEDURE SD_REQUESTS_PUT
    Добавление или изменение данных по заявке. Используется в HID.
  • PROCEDURE SD_REQUESTS_COPY
    Копирование документа.
  • PROCEDURE SD_REQUESTS_GOODS_DEL
    Удаление записи об услуге.
  • PROCEDURE SD_REQUESTS_GOODS_PUT
    Добавление или изменение записи об услуге, которая будет оказана абоненту.
  • PROCEDURE SD_REQUESTS_EQUIP_DEL
    Удаление записи об оборудовании.
  • PROCEDURE SD_REQUESTS_EQUIP_PUT
    Добавление или изменение записи об оборудовании.

SI_ADDRESSES_PKG

Addresses management

  • PROCEDURE SI_ADDRESSES_DEL
    Delete an address.
  • PROCEDURE SI_ADDRESSES_PUT
    Create or replace an address.
  • PROCEDURE SI_ADDR_ADDRESSES_DEL
    Delete an address-to-address bind.
  • PROCEDURE SI_OBJ_ADDRESSES_CHG_STATE
    Change address state.
  • PROCEDURE SI_OBJ_ADDRESSES_CHG_STATE
    DEPRECATED in v5.1! Change state of all address-to-object binds by object. Only active binds with end date after dt_D_OPER (or open-ended) are changed.
  • PROCEDURE SI_OBJ_ADDRESSES_PUT
    Create or replace an address-to-object bind.
  • PROCEDURE SI_SUBJ_ADDRESSES_TYPE_DEL
    DEPRECATED in v5.1! Delete or switch off all addresses of a specified type and purpose from a subject.
  • PROCEDURE SI_PROVIDER_ADDRESSES_PUT
    Fill SI_PROVIDER_ADDRESSES row.
  • PROCEDURE SI_PROVIDER_IP_ADDRESSES_PUT
    Bind an address to a provider.
  • PROCEDURE BIND_SUBNET_TO_SUBNET_GROUP
    Bind a subnet to a subnet group.
  • PROCEDURE SI_ADDR_ADDRESSES_PUT
    Create or replace an address-to-address bind.
  • PROCEDURE SI_SUBJ_ADDRESSES_DEL
    Delete an address-to-subject bind.
  • PROCEDURE SI_SUBJ_ADDRESSES_PUT
    Create or replace an address-to-subject bind.
  • PROCEDURE TEL_CODE_DEL
    Unbind an area code from a provider and send a message to the queue.
  • PROCEDURE SI_OBJ_ADDRESSES_PUT_EX
    Create or replace an address and bind it to an object.
  • PROCEDURE SI_OBJ_ADDRESSES_PUT_EX
    Create or replace an address-to-object bind for an existing address.
  • PROCEDURE SI_OBJ_ADDRESSES_TYPE_DEL
    DEPRECATED in v5.1! Delete or close all addresses of a specified type and purpose from an object.
  • PROCEDURE SI_SUBJ_ADDRESSES_PUT_EX
    Create or replace an address and bind it to a subject.
  • PROCEDURE UNBIND_SUBNET_FROM_GROUP
    Unbind a subnet from a subnet group by address and provider.
  • PROCEDURE SI_PROVIDER_IP_ADDRESSES_DEL
    Remove provider IP-address bind.
  • PROCEDURE SI_PROVIDER_VLANS_DEL
    Unbind VLAN from a provider.
  • PROCEDURE SI_PROVIDER_VLANS_PUT
    Bind VLAN to a provider.
  • PROCEDURE SI_PROV_SUBNETS_PUT
    Create or update a subnet.
  • PROCEDURE SI_PROV_SUBNET_GROUPS_PUT
    Create or update a subnet group.
  • PROCEDURE SI_DOC_ADDRESSES_DEL
    Delete an address-to-document bind.
  • PROCEDURE SI_OBJ_ADDRESSES_DEL
    Delete an address-to-object bind.
  • PROCEDURE SI_PROVIDER_IP_ADDR_CHILDS_DEL
    Remove provider IP-address children.
  • PROCEDURE SI_PROV_SUBNET_GROUPS_DEL
    Delete a subnet group.
  • PROCEDURE SI_PROVIDER_ADDRESSES_DEL
    Remove provider address bind.
  • PROCEDURE SI_PROVIDER_ADDRESSES_PUT_EX
    Save an address and bind it to a provider.
  • PROCEDURE TEL_CODE_PUT
    Save an area code, bind it to a provider and send a message to the queue.
  • PROCEDURE SEND_CODES_BY_PROVIDER
    Send codes with zones to queue.
  • PROCEDURE SI_DOC_ADDRESSES_PUT
    Create or replace an address-to-document bind.
  • PROCEDURE SI_OBJ_ADDRESSES_CLOSE
    Close validity period of an address-to-object bind.

SI_COMPANIES_PKG

Organizations record management

  • PROCEDURE SI_COMPANIES_DEL
    Delete organization record.
  • PROCEDURE SI_COMPANIES_PUT
    Create or replace organization record.
  • PROCEDURE SI_ORGANIZATIONS_PUT
    Create or replace organization record.

SI_DEVICES_PKG

Net equipment management

  • PROCEDURE SI_PASSIVE_EQUIP_PUT
    Create or replace passive equipment.
  • PROCEDURE SI_PASSIVE_EQUIP_DEL
    Delete passive equipment.
  • PROCEDURE SI_DEVICES_DEL
    Delete active equipment.
  • PROCEDURE SI_DEVICES_PUT
    Create or replace active equipment.
  • PROCEDURE TRANSFER_USER_EQUIP_BINDS
    DEPRECATED in v5.1! Transfer equipment binds from one equipment to another.

SI_EMPLOYEES_PKG

Employee record management

  • PROCEDURE SI_EMPLOYEES_DEL
    Delete employee record.
  • PROCEDURE SI_EMPLOYEES_PUT
    Create or replace employee record.
  • PROCEDURE SI_EMPLOYEES_EX_PUT
    Create or replace employee record with basic subject.

SI_OBJECTS_PKG

Objects management

  • PROCEDURE SI_OBJ_SUBJECTS_PUT
    Create or replace an object-to-subject bind.
  • PROCEDURE ADD_OBJECT_SPEC
    Add specification objects to a main object.
  • FUNCTION ADD_ONE_OBJECT_SPEC
    Add a specification component to a main object.
  • PROCEDURE SI_OBJ_VALUES_PUT
    Create or replace a custom field value record.
  • PROCEDURE INITIALIZE_CONTENT
    Initialize object components. Does not create components by specifications with unspecified quantity.
  • PROCEDURE SI_OBJECTS_CHG_STATE
    Change object state.
  • FUNCTION SI_OBJECTS_CHG_STATE
    Change object state.
  • PROCEDURE SI_OBJ_FILES_DEL
    Delete a file-to-object bind.
  • PROCEDURE SI_OBJ_SUBJECTS_DEL
    Delete an object-to-subject bind.
  • PROCEDURE GET_AUTH_PARAMS
    Get authentication credentials. See also SI_OBJECTS_PKG_S.GET_MANAGEMENT_PARAMS.
  • PROCEDURE PUT_OBJ_VALUE
    Save object custom field value. Attention: does not support multiple custom fields.
  • PROCEDURE PUT_OBJ_VALUE
    Save object custom field value. Attention: does not support multiple custom fields.
  • PROCEDURE SI_OBJ_COMMENTS_SET_EXEC
    Set actual execution date of an object comment.
  • PROCEDURE SI_OBJ_LOCALES_DEL
    Delete an object locale.
  • PROCEDURE SI_OBJ_SPECIAL_SETTINGS_PUT
    DEPRECATED in v5.1! Create or replace a RADIUS-parameters line for a network service.
  • PROCEDURE SI_SUBJ_SERVICES_CHG_PASS
    Change password in an equipment management record.
  • PROCEDURE SI_SUBJ_SERVICES_DEL
    Delete an equipment management record.
  • PROCEDURE SI_OBJECTS_DEL
    Remove an object.
  • PROCEDURE SI_OBJECTS_PUT
    Create or replace an object.
  • PROCEDURE SI_OBJ_COMMENTS_PUT
    Create or replace an object comment.
  • PROCEDURE SI_OBJ_GOODS_DEL
    Delete an object-to-product-catalog-entry bind.
  • PROCEDURE SI_OBJ_LOCALES_PUT
    Create or replace an object locale.
  • PROCEDURE SI_OBJ_SPECIAL_SETTINGS_DEL
    DEPRECATED in v5.1! Delete a RADIUS-parameters line of a network service.
  • PROCEDURE SI_OBJ_COMMENTS_UNSET_EXEC
    Reset actual execution date of an object comment.
  • PROCEDURE SI_OBJ_FILES_PUT
    Create or replace a file-to-object bind.
  • PROCEDURE SI_OBJ_OBJECTS_BINDS_PUT
    Create or replace an object-to-object bind.
  • PROCEDURE SI_OBJ_OBJECTS_DEL
    Remove and object-to-object bind.
  • PROCEDURE SI_OBJ_OBJECTS_PUT
    Create or replace an object-to-object bind.
  • PROCEDURE UPDATE_DEPEND_VERSIONS
    Update version of dependent entities (custom fields, addresses, etc.).
  • PROCEDURE AV_VALUES_PUT
    DEPRECATED in v5.1! Edit AV custom field values.
  • PROCEDURE CHANGE_OBJECT_OWNER
    Change an owner of an object.
  • PROCEDURE SI_OBJ_VALUES_DEL
    Remove a custom field value of an object.
  • PROCEDURE CHANGE_STATE
    Change object state (wrapper).
  • PROCEDURE SI_OBJ_COMMENTS_DEL
    Delete an object comment.
  • PROCEDURE SI_OBJ_GOODS_PUT
    Create or replace an object-to-product-catalog-entry bind.
  • PROCEDURE SI_SUBJ_SERVICES_PUT
    Create or replace an equipment management record.

SI_OBJECTS_PKG_S

Object management

  • TYPE NEAREST_OBJ_LIST PL/SQL RECORD
    Object record for object-by-address lookup.
  • TYPE NEAREST_OBJ_LIST_TABLE_TYPE PL/SQL TABLE
  • TYPE OBJ_BINDS_LIST PL/SQL RECORD
    Object bind record
  • TYPE OBJ_BINDS_LIST_TABLE_TYPE PL/SQL TABLE
  • TYPE SI_OBJECTS_TABLE_TYPE PL/SQL TABLE
    Table of object records.
  • FUNCTION CHECK_CDR_CLEANUP
    DEPRECATED in v5.1! Check if the CDR cleanup job should be created.
  • PROCEDURE GENERATE_OBJ_CODE_OR_NAME
    Generate code OR name for an object.
  • FUNCTION GET_CODE_BY_ID
    Get object code.
  • PROCEDURE GET_MANAGEMENT_PARAMS
    DEPRECATED in v5.1! Get equipment management params. See also SI_OBJECTS_PKG.GET_AUTH_PARAMS.
  • FUNCTION GET_OBJ_CL_VALUE
    Get CLOB custom field value.
  • FUNCTION GET_OBJ_CL_VALUE
    Get CLOB custom field value.
  • PROCEDURE GET_OBJ_REALTY
    Get a real estate object and a region which the given object is situated in.
  • FUNCTION GET_USE_OBJECT_ID
    DEPRECATED in v5.1! Get customer equipment.
  • FUNCTION GET_BOUND_OBJECT_ID
    DEPRECATED in v5.1! Get first bound object.
  • PROCEDURE GET_ID_BY_ADDRESS
    Find an object by address and type. Only works for addresses bound to object components. Used in HID.
  • FUNCTION GET_ID_BY_ADDRESS
    Find an object by address and type. Only works for addresses bound to object components. Simplified version of the procedure.
  • FUNCTION GET_ID_BY_ADDRESS
    Get object by its address (simple option).
  • FUNCTION GET_N_GOOD_ID
    Get product catalog entry by object.
  • FUNCTION GET_OBJ_N_VALUE
    Get numeric custom field value.
  • FUNCTION GET_OBJ_N_VALUE
    Get numeric custom field value.
  • FUNCTION GET_OBJ_REALTY_OBJECT
    Get a real estate object which the given object is situated in.
  • FUNCTION IS_CUSTOMER_EQUIPMENT
    Is object customer equipment?
  • PROCEDURE CHECK_OBJ_ACTIVE_USER_GOODS
    Check if the equipment is used in active service subscriptions. Raises an exception if used.
  • FUNCTION GET_NEAREST_FREE_EQUIPMENT
    DEPRECATED in v5.1! Find equipment available for binding. Lookup is made by address.
  • FUNCTION GET_N_OBJ_SUBJECT_ID
    Get object-to-subject bind by object and role.
  • FUNCTION GET_OBJ_BINDS
    Get a list of equipment bound to a given port.
  • FUNCTION GET_OBJ_N_REF_ID
    Get reference custom field value.
  • FUNCTION GET_OBJ_N_REF_ID
    Get reference custom field value.
  • FUNCTION GET_OBJ_OWNER_ID
    Get owner of an object. Also works for components. Used in HID.
  • FUNCTION GET_OBJ_VC_REF_NAME
    Get reference name custom field value.
  • FUNCTION GET_OBJ_VC_REF_NAME
    Get reference name custom field value.
  • FUNCTION GET_OBJ_VC_VALUE
    Get string custom field value.
  • FUNCTION GET_OBJ_VC_VALUE
    Get string custom field value.
  • PROCEDURE CHECK_EQUIP_CHANGE_OWNER
    Check if the equipment can change owners. Must be done after SI_SUBJECTS_PUT!
  • PROCEDURE CHECK_OBJ_ACTIVE_INVOICES
    Check if the equipment is used in actual/prepared/processing charge logs. Raises an exception if used.
  • FUNCTION GET_ID
    DEPRECATED in v5.1! Find object by code, ID or an address of a component. Address type is required for address lookup.
  • FUNCTION GET_MAIN_N_OBJECT_ID
    Get main object.
  • FUNCTION GET_N_GOOD_BRANCH_ID
    Get product catalog branch by object.
  • FUNCTION GET_OBJ_VC_REF_CODE
    Get reference code custom field value.
  • FUNCTION GET_OBJ_VC_REF_CODE
    Get reference code custom field value.
  • FUNCTION GET_SERV_MIN_PASS_STRENGTH
    Get minimum password strength for a network service.
  • FUNCTION CHECK_CDR_FORCE_FINISH
    DEPRECATED in v5.1! Check if the CDR force finishing job should be created.
  • PROCEDURE CHECK_OBJ_ACTIVE_SERV_SUBSCR
    Check if the equipment is used in active service subscriptions of a specified customer. If a customer is not specified all subscriptions will be checked. Raises an exception if used.
  • FUNCTION GET_NAME_BY_ID
    Get object name.
  • FUNCTION GET_OBJ_VALUE_ROW
    Get custom field value record.
  • FUNCTION IS_OBJECT_CODE_EXIST
    Check if an object with a given code exists.
  • FUNCTION IS_PROVIDER_EQUIPMENT
    Is object provider equipment?
  • FUNCTION DOES_OBJECT_CODE_EXIST
    Check if an object with a given code exists.
  • PROCEDURE GET_GOOD_PERMITTED_SERVS
    Check if there are services permitted for a specified equipment.
  • FUNCTION GET_N_FIRM_ID
    Get object division.
  • FUNCTION GET_OBJECT
    Get object record.
  • FUNCTION OBJECT_HISTORY
    List changes by object.
  • FUNCTION CHECK_COLLECTOR_EX_DATA
    DEPRECATED in v5.1! Check if the collector job should be created.
  • FUNCTION GET_ID_BY_CODE
    Find object by code. Used in HID.
  • FUNCTION GET_ID_BY_CODE
    Find object by code and main object.
  • FUNCTION GET_N_OBJ_KIND_ID
    DEPRECATED in v5.1! Get object kind.
  • FUNCTION GET_N_OBJ_STATE_ID
    Get object state.
  • FUNCTION GET_OBJ_D_VALUE
    Get date custom field value.
  • FUNCTION GET_OBJ_D_VALUE
    Get date custom field value.
  • FUNCTION GET_CODE_BY_ID_EX
    Get full object name (with main object).
  • FUNCTION GET_N_SUBJECT_ID_BY_ROLE
    Get subject bound to an object by role.
  • FUNCTION GET_OBJ_C_FL_VALUE
    Get boolean custom field value.
  • FUNCTION GET_OBJ_C_FL_VALUE
    Get boolean custom field value.
  • FUNCTION GET_OBJ_VALUE
    Get custom field value record.
  • FUNCTION GET_OBJ_VALUE
    Get custom field value record.
  • FUNCTION GET_USER_EQUIP_BY_BIND
    DEPRECATED in v5.1! Find customer equipment by bound equipment. Works only for binds where the customer equipment is primary.
  • PROCEDURE GET_USER_EQUIP_BY_BIND
    DEPRECATED in v5.1! Find customer equipment by bound equipment. Works only for binds where the customer equipment is primary.

SI_PERSONS_PKG

Individuals record management

  • PROCEDURE SI_PERSONS_PUT
    Create or replace individual record.
  • PROCEDURE SI_PERSONS_CHG_NO_PRIVATE
    Edit individual record without editing personal details.
  • PROCEDURE SI_PERSONS_DEL
    Delete individual record.

SI_REF_PKG_S

Reference data management

  • FUNCTION GET_VC_VALUE_FOR_REGION
    Get the string value of a reference data entry for regions.
  • FUNCTION GET_N_VALUE_2
    Get the second numeric value of a reference data entry.
  • FUNCTION GET_C_VALUE_2
    Get the second char value of a reference data entry.
  • FUNCTION GET_N_REF_TYPE_ID
    Get a reference data id.
  • FUNCTION GET_C_VALUE
    Get the char value of a reference data entry.
  • FUNCTION GET_NAME_BY_CODE
    Get reference data entry name by its code.
  • FUNCTION GET_NAME_BY_ID
    Get reference data entry name by its id.
  • FUNCTION GET_N_REF_BASE_ID
    Get a basic reference data entry.
  • FUNCTION IS_VALUE_IN_REF
    Check if a reference data entry is in reference data.
  • FUNCTION GET_CODE_BY_ID
    Get code of a reference data entry by its id.
  • FUNCTION GET_ID_BY_CODE
    Get id of a reference data entry by its code. Providing reference data id is recommended as in case of code collision the function will return NULL.
  • FUNCTION GET_VC_VALUE
    Get the string value of a reference data entry.
  • FUNCTION GET_D_VALUE
    Get the date value of a reference data entry.
  • FUNCTION GET_ID_BY_NAME
    Get id of a reference data entry by its name.
  • FUNCTION GET_N_VALUE
    Get the numeric value of a reference data entry.
  • FUNCTION GET_VC_VALUE_2
    Get the second string value of a reference data entry. Used in HPD.
  • FUNCTION IS_REF_DEL
    Check if a reference data entry can be deleted.
  • FUNCTION GET_ID_BY_CODE_EX
    Get id of a reference data entry by its code.
  • FUNCTION GET_ID_BY_VC_VALUE_2
    Get id of a reference data entry by its second string value.
  • FUNCTION GET_N_PAR_REF_ID
    Get a parent reference data entry.
  • FUNCTION GET_VALUE
    Get the table record of a reference data entry.
  • FUNCTION GET_VC_VALUE_3
    Get the third string value of a reference data entry.
  • FUNCTION GET_VC_VALUE_4
    Get the fourth string value of a reference data entry.
  • FUNCTION GET_ID_BY_VC_VALUE
    Get id of a reference data entry by its string value.
  • PROCEDURE RESET_CACHE
    Reset the refs cache.

SI_SUBJECTS_PKG

Subjects management

  • PROCEDURE SI_SUBJ_ACCOUNTS_PUT
    Create or replace an account.
  • PROCEDURE SI_SUBJ_GROUPS_PUT
    Create or replace a subject group.
  • PROCEDURE SI_SUBJ_SUBJECTS_DEL
    Delete a subject-to-subject bind.
  • PROCEDURE SI_SUBJ_SUBJECTS_PUT
    Create or replace a subject-to-subject bind.
  • PROCEDURE TAG
    Tag a subject.
  • PROCEDURE LI_SUBJ_VALUES_TYPE_PUT
    Create or replace an L-table record for a subject custom field type.
  • PROCEDURE SI_SUBJ_COMMENTS_SET_EXEC
    Set actual execution date of a subject comment.
  • PROCEDURE SI_SUBJ_FILES_PUT
    Create or replace a file-to-subject bind.
  • PROCEDURE SI_SUBJ_GROUP_PUT
    DEPRECATED in v5.1! Create or replace a subject group.
  • PROCEDURE SI_SUBJ_VALUES_TYPE_DEL
    Delete a subject custom field type.
  • PROCEDURE SI_SUBJ_VALUES_TYPE_PUT
    Create or replace a subject custom field type.
  • PROCEDURE PUT_SUBJ_VALUE
    Save subject custom field value. Attention: does not support multiple custom fields.
  • PROCEDURE SI_SUBJECTS_CHG_STATE
    Change state of a subject.
  • FUNCTION SI_SUBJECTS_CHG_STATE
    Change state of a subject.
  • PROCEDURE SI_SUBJ_SERVICES_CHECK_PASS
    Check password.
  • PROCEDURE SI_SUBJ_VALUES_PUT
    Create or replace subject custom field value.
  • PROCEDURE SI_SUBJ_SERVICES_CHG_PASS
    Change password in a network service subscription.
  • PROCEDURE SI_SUBJ_COMMENTS_DEL
    Delete a subject comment.
  • PROCEDURE SI_SUBJ_SERV_CREATE
    DEPRECATED in v5.1! Batch creation of network service subscriptions.
  • PROCEDURE SI_SUBJ_VALUES_DEL
    Delete a subject custom field value.
  • PROCEDURE CHANGE_STATE
    Change state of a subject (wrapper).
  • PROCEDURE SI_SUBJ_CHG_PARENT_SUBJ_ID
    Change a parent subject of a specified subject.
  • PROCEDURE SI_SUBJ_SERVICES_PUT
    Create or replace a network service subscription or an equipment management record.
  • PROCEDURE UPDATE_DEPENDENCIES
    Update versions of dependent values.
  • PROCEDURE UPDATE_REAL_LOGIN
    Update "real" logins by subject or object.
  • PROCEDURE SI_SUBJECTS_DEL
    Delete a subject record.
  • FUNCTION SI_SUBJ_DEPEND_OBJ_CHG_STATE
    Change state of all customer equipment.
  • PROCEDURE SI_SUBJ_DEPEND_OBJ_CHG_STATE
    Change state of all customer equipment.
  • PROCEDURE SI_SUBJ_SERVICES_DEL
    Delete a network service subscription or an equipment management record.
  • PROCEDURE SI_SUBJECTS_ACTUALIZE
    Actualize a subject.
  • PROCEDURE SI_SUBJECTS_PUT
    Create or replace a subject.
  • PROCEDURE SI_SUBJ_ACCOUNTS_DEL
    Delete an account.
  • PROCEDURE SI_SUBJ_COMMENTS_PUT
    Create or replace a subject commen.
  • PROCEDURE SI_SUBJ_COMMENTS_UNSET_EXEC
    Reset actual execution date of a subject comment.
  • PROCEDURE SI_SUBJ_FILES_DEL
    Delete a file-to-subject bind.

SI_SUBJECTS_PKG_S

Subjects management

  • TYPE SUBJ_ACC_BALANCE PL/SQL RECORD
    Account balance record for start and end of a billing period.
  • TYPE SUBJ_ACC_BALANCE_TABLE_TYPE PL/SQL TABLE
  • FUNCTION GET_BASE_SUBJECT_ID
    Get basic subject. Used in HPD.
  • FUNCTION GET_N_FIRM_ID
    Get division.
  • FUNCTION GET_SUBJECT_ACCOUNTS_BALANCE
    Get total balance of subject's accounts for start and end of a specified period.
  • FUNCTION GET_SUBJECT_BY_ACCOUNT
    Get subject by account.
  • FUNCTION GET_SUBJ_VALUE_BY_CODE
    Get custom field line.
  • FUNCTION GET_BASE_CONTR_BY_SUBJ
    Get a basic contract by recipient subject.
  • FUNCTION GET_RANDOM_SUBJECT_ID
    DEPRECATED in v5.1! Get random subject with specified parameters.
  • FUNCTION GET_SUBJ_SERV_LOGIN_REAL
    Get customer login for a network service subscription.
  • FUNCTION GET_SUBJ_TYPE_ID
    Get subject type.
  • FUNCTION GET_VC_NAME
    Get subject name.
  • FUNCTION GET_N_SUBJ_OWNER_ID
    Get subject owner.
  • FUNCTION GET_SUBJ_CL_VALUE
    Get CLOB custom field value.
  • FUNCTION GET_SUBJ_C_VALUE
    Get char custom field value.
  • FUNCTION GET_SUBJ_N_VALUE
    Get numeric custom field value.
  • FUNCTION GET_VC_VISUAL_CODE
    Get addresses visual code by ID.
  • PROCEDURE GENERATE_ACCOUNT_NO
    Generate a new account number.
  • FUNCTION GET_ACCOUNT_CODE
    Get account code.
  • FUNCTION GET_ACCOUNT_TYPE
    Get account type.
  • FUNCTION GET_PROVIDER_CODE
    Get code of a provider (deterministic).
  • FUNCTION GET_SUBJECT_BY_AUTH_DATA
    Get subject by its network service credentials. Used in HID.
  • FUNCTION GET_SUBJ_VALUE_TYPE_NAME
    Get custom field name.
  • FUNCTION IS_LOGIN_AND_PASS_CORRECT
    Check login and password.
  • FUNCTION GET_ACCOUNT_BANK
    Get bank of a specified account.
  • FUNCTION GET_ACCOUNT_NO
    Get account number.
  • FUNCTION GET_GROUPS_IN_STR
    Get subject groups as a string joined with commas.
  • FUNCTION GET_ID_BY_CODE_AND_TYPE
    Get subject by code and type
  • FUNCTION GET_MAIN_GRP_N_SUBJ_SUBJECT_ID
    Get primary subject-to-group bind of a specified subject.
  • FUNCTION GET_OPF_BY_CODE
    Get legal form by code.
  • FUNCTION GET_SUBJ_VALUE
    Get subject custom field value.
  • FUNCTION GET_SUBJ_VALUE_ROW
    Get custom field value record.
  • FUNCTION GET_VC_CODE
    Get subject code.
  • PROCEDURE CHECK_ADD_VALUES
    Check custom field value of a specified subject.
  • FUNCTION GET_ACCOUNT_BY_VALUE
    Get account ID by its number.
  • FUNCTION GET_ACCOUNT_NAME
    Get account name.
  • FUNCTION GET_GROUP_SUBJ_TYPE
    Get type of subject for a group.
  • FUNCTION GET_ID_BY_CODE
    Get subject ID by code. Returns NULL when no such subject found.
  • FUNCTION GET_N_REGION_ID
    Get subject region.
  • FUNCTION GET_SUBJECT_VALUE
    Get subject record.
  • FUNCTION GET_SUBJ_CL_VALUE_BY_CODE
    Get clob custom value.
  • FUNCTION GET_SUBJ_D_VALUE_BY_CODE
    Get date custom value.
  • FUNCTION GET_SUBJ_N_VALUE_BY_CODE
    Get number custom value.
  • FUNCTION GET_SUBJ_VALUE_TYPE_ID
    Get custom field type by its code and subject type.
  • FUNCTION IS_DB_USER_EXIST
    Check if DB user with a specified name exists.
  • FUNCTION GET_ACCOUNT_VALUE
    Get a record of an account.
  • FUNCTION GET_MAIN_GROUP_ID
    Get primary group of a subject.
  • FUNCTION GET_PERSON_FULL_NAME
    Get full name of an individual.
  • FUNCTION GET_SUBJ_ACCOUNT
    Get subject account.
  • FUNCTION GET_SUBJ_C_FL_VALUE_BY_CODE
    Get flag custom value.
  • FUNCTION GET_SUBJ_C_VALUE_BY_CODE
    Get char custom value.
  • FUNCTION GET_SUBJ_VC_VALUE_BY_CODE
    Get string custom field value by custom field type code. Does not support multiple custom fields.
  • FUNCTION IS_EXIST_SUBJECT_CODE
    Check if a subject with a specified code exists. Allows ignoring a specified ID.
  • FUNCTION IS_PASSWORD_STRONG
    Check the strength of a password. Minimum strength is set up in the network service, application or in division parameters. If the minimum strength is not specified for the network service or application, the function will check division parameters. If the minimum strength is not specified anywhere, the password is considered strong enough.
  • FUNCTION GET_SUBJ_C_FL_VALUE
    Get boolean custom field value.
  • FUNCTION GET_SUBJ_D_VALUE
    Get date custom field value.
  • FUNCTION GET_SUBJ_STATE_ID
    Get subject state.
  • FUNCTION GET_SUBJ_VC_VALUE
    Get string custom field value.
  • FUNCTION IS_EXIST_ACCOUNT_NO
    Check if an account with a specified number exists.
  • FUNCTION IS_EXIST_N_SUBJECT_ID
    Check if a subject with a specified ID exists.

SI_SUBSCRIPTIONS_PKG

Service subscriptions management

  • PROCEDURE CLOSE_CHILD_SUBSCRIPTION
    Close child subscription.
  • PROCEDURE SI_SUBSCRIPTIONS_PUT
    Create or update a service subscription.
  • FUNCTION SUSPEND_ACCOUNT_SERVICES
    Suspend services by account and contract.
  • FUNCTION UNLOCK_USER_GOOD
    Stop suspension and create charge logs by regular subscriptions.
  • FUNCTION ADD_ONE_OFF_SUBSCRIPTION
    Add one off service subscription. Child services are supported (uses ADD_CHILD_SUBSCRIPTION internally). Service fee can be charged if dt_D_BEGIN is in past. Raises an exception if service fee cannot be charged!
  • FUNCTION SUSPEND_SERVICE
    Create a subscription to a temporary suspension service (wrapper function).
  • FUNCTION UNSUSPEND_ACCOUNT
    Stop suspension by account.
  • PROCEDURE SI_SUBSCRIPTIONS_DEL
    Delete a subscription.
  • PROCEDURE SI_USER_GOOD_UNLOCK
    Stop suspension and create charge logs by regular subscriptions.
  • PROCEDURE CLOSE_SUBSCRIPTION
    Close service subscription.
  • PROCEDURE SI_USER_GOOD_LOCK
    Create a subscription to a temporary suspension service.
  • FUNCTION ADD_CHILD_SUBSCRIPTION
    Add child service subscription. You must provide num_N_PAR_SUBSCRIPTION_ID or num_N_CHARGE_LOG_ID. If you pass num_N_CHARGE_LOG_ID then new service WILL be included in actual charge log. Otherwise use b_IncludeInCurChargeLog argument for including or not including.
  • PROCEDURE PUT_CHILD_SUBSCRIPTION
    Calls ADD_CHILD_SUBSCRIPTION but does not return ID.

SI_SUBSCRIPTIONS_PKG_S

Service subscriptions management

  • TYPE AVAILABLE_SERVICES_TBL PL/SQL TABLE
  • TYPE CUSTOMER_SUBSCRIPTIONS_TBL PL/SQL TABLE
  • TYPE GOOD_STATES_TBL_TYPE PL/SQL TABLE
  • TYPE SUBSCRIPTION_STATES_TBL_TYPE PL/SQL TABLE
  • FUNCTION FIND_PREV_SUBSCRIPTION
    Find previous subscription by subscription details.
  • FUNCTION FIND_PREV_SUBSCRIPTION
    Find previous subscription by subscription details.
  • FUNCTION GET_AVAILABLE_SERVICE
    Get available service. Returns first row of GET_AVAILABLE_SERVICES result with passed service.
  • FUNCTION GET_GOOD_STATE_ID
  • FUNCTION GET_PREV_SUBSCRIPTION
    Get previous subscription for existing one.
  • FUNCTION GET_SUSPENSION_SUBSCRIPTION
    Get current suspension for a subscription.
  • FUNCTION IS_CONN_DISCONN_ALLOWED
    Determine if service connection/disconnection allowed.
  • FUNCTION GET_CUSTOMER_SUBSCRIPTIONS
    Get a list of customer subscriptions (returns collection).
  • FUNCTION GET_SUBSCRIPTION_FOR_UPDATE
    Get subscription row and lock it.
  • FUNCTION GET_SUBSCRIPTION_STATES
    Get service subscriptions state.
  • FUNCTION GET_SUSPENSIONS_FOR_ACCOUNT
    Find available suspension services.
  • FUNCTION GET_SUSPENSIONS_FOR_ACCOUNT_P
    Find available suspension services.
  • PROCEDURE CHECK_SUBSCR_SERVS_DUPLICATE
    Check whether the same equipment is used to provide the same traffic service by different contracts. This may make rating and charging some of traffic services ambiguous. The procedure raises an exception if the check has failed. Attention: call this procedure AFTER the subscription is saved.
  • FUNCTION GET_AVAILABLE_SERVICES
    Get available services.
  • FUNCTION GET_DESCRIPTION
    Get string with subscription description.
  • FUNCTION GET_DISCOUNT_REF_ID
    Get discount reference id.
  • FUNCTION GET_USER_GOODS_STATES
    DEPRECATED in v5.1! Get subscription list with service provision statuses. You should use GET_SUBSCRIPTION_STATES instead if you can.
  • FUNCTION GET_AVAILABLE_SERVICES_P
    Get available services. GET_AVAILABLE_SERVICES pipelined variant.
  • FUNCTION FIND_SERVICE_FOR_ACCOUNT
    Find available service for account (checks all customer contracts returns first).
  • FUNCTION GET_FULL_CHARGE_SUM
    Get total charge amount for a subscription.
  • FUNCTION GET_SERVICE_STATE
    Get service subscription state (from register).
  • FUNCTION HAS_COMMITMENTS
    Check if a subscription has a contract commitment.
  • FUNCTION GET_CUSTOMER_SUBSCRIPTIONS_P
    Get list of customer subscriptions.
  • FUNCTION GET_SUBSCRIPTION
    Get subscription row.
  • PROCEDURE RATE_ORDER
    Rate services list.
  • FUNCTION CHECK_EQUIP_SERVICE_DUPLICATE
    Check if the price plan has the same traffic services that are already being provisioned on the same equipment. Attention: the function does not consider time intervals.
  • FUNCTION FIND_SUBSCRIPTION
    Search for service subscription.

SI_USERS_PKG

Customers management.

  • TYPE GOOD_SPEC_LIST PL/SQL TABLE
    Table type for a specification (i.e., a list of object component types).
  • PROCEDURE CHANGE_INVOICE_PERIOD
    Change a charge log end date.
  • PROCEDURE SET_PRIVATE_OFFICE_ACCESS
    Grant access to the Customer Self-Care Portal.
  • PROCEDURE SI_USER_GOODS_PUT
    Create or update a subscription to a service.
  • PROCEDURE FILL_DETAILED_SERV_STAT_A
    Fill the temporary table TT_V_USER_OFFICE_SRVS_C with detailed data on consumed services (in an autonomous transaction).
  • PROCEDURE TT_V_ONE_TIME_SERV_C_PUT
    Fill the temporary table TT_V_ONE_TIME_SERV_C with data on one-off services.
  • PROCEDURE ACCESS_SERV_CHG_STATE
    Enable or disable an access service.
  • PROCEDURE CHANGE_BASE_SUBJECT
    Change a customer's basic subject.
  • PROCEDURE CREATE_NET_SERVICE_COMPONENT
    Create a network service component for a customer.
  • PROCEDURE TT_V_ONE_TIME_SERV_C_DEL
    Delete a record about a one-off service from the temporary table TT_V_ONE_TIME_SERV_C.
  • FUNCTION CHANGE_TARIFF
    Change a price plan within a subscription. If there are no charge logs for the subscription yet and a start date for a new price plan is a past or current date, the existing subscription is modified. Otherwise, an end date is set for the current subscription and a new one is created. If a new service is a suspension one, a separate simultaneous subscription is created for it, and the current subscription remains unclosed. If b_CloseCurrentInvoice = CONST.b_TRUE, then: 1) when closing the current subscription a charge log in force issued for it also closes with the same date, 2) if the new service is a suspension one, charge logs for all affected subscriptions are closed, not only the current subscription, 3) a charge log for the new subscription is issued.
  • PROCEDURE CHANGE_TARIFF
  • PROCEDURE CREATE_PASSIVE_EQUIP
    Create passive equipment.
  • PROCEDURE GET_PASSWORD
    Retrieve a password from a subscription to a network service.
  • PROCEDURE SI_USER_GOODS_CLOSE
    Close a subscription to a service.
  • PROCEDURE CREATE_NET_DEVICE
    Create customer equipment with components according to specification.
  • PROCEDURE FILL_DETAILED_SERV_STAT
    Fill the temporary table TT_V_USER_OFFICE_SRVS_C with detailed data on consumed services.
  • PROCEDURE FILL_TT_V_USER_RECOMMENDED_PAY
    DEPRECATED: please use SD_PAYMENT_REQUESTS_PKG.GET_RECOMMENDED_PAYMENT_C or SI_USERS_PKG_S.GET_RECOMMENDED_PAYMENT_LIST_C instead. Fill the temporary table TT_V_USER_RECOMMENDED_PAY with recommended payment data.
  • PROCEDURE SI_USER_GOODS_DEL
    Delete a subscription to a service.
  • PROCEDURE ADD_GOOD_TO_INVOICE
    Activate a service within a price plan under a charge log that is either in force or prepared.
  • PROCEDURE CHECK_USER_APP_BINDS
    Check whether a customer who has access to an application is bound to a division.
  • PROCEDURE CREATE_ACCOUNT
    Create a customer account.
  • PROCEDURE SI_USERS_PUT
    Create or update a customer.
  • PROCEDURE CREATE_CONTRACT
    Create a service contract.
  • PROCEDURE REMOVE_GOOD_FROM_INVOICE
    Deactivate a service within a price plan under a charge log that is either in force or prepared.
  • FUNCTION STOP_BLOCKING
    Deactivate a non-payment or temporary suspension. When a subscription to a temporary suspension is passed, the function deactivates this suspension. Otherwise, a non-payment suspension is considered: if a customer account has sufficient funds to issue charge logs for suspended subscriptions, the suspension is deactivated and the customer becomes active.
  • PROCEDURE TT_V_ONE_TIME_SERV_C_INVOICE
    Issue charge logs for one-off services.
  • PROCEDURE USER_ACCOUNT_PUT
    DEPRECATED: please use SI_ACCOUNTS_PKG.CUSTOMER_ACCOUNT_PUT instead. Create or update a customer account.

SI_USERS_PKG_S

Retrieving data on customers, accounts, equipment, subscriptions and services.

  • TYPE ACCOUNTS_DEPLETION_DATES_LIST PL/SQL TABLE
    Table type for dates when accounts funds run out.
  • TYPE ACCOUNT_DEPLETION_DATE PL/SQL RECORD
    Date when account funds run out.
  • TYPE ACCOUNT_RESERVED_LIST PL/SQL RECORD
    Account reserved funds.
  • TYPE ACCOUNT_RESERVED_LIST_TBL_TYPE PL/SQL TABLE
    Table type for account reserved funds.
  • TYPE ADDITIONAL_SERVICE PL/SQL RECORD
    Details on an additional service within a price plan.
  • TYPE ADDITIONAL_SERVICES_TABLE_TYPE PL/SQL TABLE
    Table type for details on additional services within price plans.
  • TYPE ADDRESS_LIST_TBL_TYPE PL/SQL TABLE
    Table type for equipment addresses.
  • TYPE AV_SERVS_LIST PL/SQL RECORD
    Available antivirus service.
  • TYPE AV_SERVS_LIST_TABLE_TYPE PL/SQL TABLE
    Table type for available antivirus services.
  • TYPE BILLED_SERVS_LIST PL/SQL RECORD
    Details on a current or provided service.
  • TYPE BILLED_SERVS_LIST_TABLE_TYPE PL/SQL TABLE
    Table type for details on current and provided servises.
  • TYPE CUR_SERVICE_SUMS_TBL_TYPE PL/SQL TABLE
    Table type for subscriptions to services.
  • TYPE DETALIZATION_LIST PL/SQL RECORD
    Details on a charge, payment or credit limit.
  • TYPE DETALIZATION_LIST_TABLE_TYPE PL/SQL TABLE
    Table type for details on charges, payments and provided services.
  • TYPE INVOICE_SERVS_LIST PL/SQL RECORD
    Available service within a price plan under a current charge log.
  • TYPE INVOICE_SERVS_LIST_TABLE_TYPE PL/SQL TABLE
    Table type for available services.
  • TYPE LAST_PAYMENT_TBL PL/SQL TABLE
    Table type for last payments.
  • TYPE RECOMMENDED_PAYMENT_LIST PL/SQL TABLE
    Table type for recommended payments.
  • TYPE SCHEDULED_CHARGES_LIST PL/SQL TABLE
    Table type for scheduled charges.
  • TYPE SERV_DETALIZATION PL/SQL RECORD
    Details on data services.
  • TYPE SERV_DETALIZATION_LIST PL/SQL TABLE
    Table type for details on data services.
  • TYPE SERV_DET_PARAMS PL/SQL RECORD
    Whether a price plan contains any data or voice services.
  • TYPE USER_ACCOUNTS_LIST PL/SQL RECORD
    Customer account.
  • TYPE USER_ACCOUNTS_TBL_TYPE PL/SQL TABLE
    Table type for customer accounts.
  • TYPE USER_DEVICES_LIST PL/SQL RECORD
    Customer equipment (CPE).
  • TYPE USER_DEVICES_LIST_TBL_TYPE PL/SQL TABLE
    Table type for customer equipment.
  • TYPE USER_GOOD_ENDING_LIST PL/SQL RECORD
    Predicted date of a service deactivation based on reserved funds in a charge log.
  • TYPE USER_GOOD_ENDING_LIST_TBL_TYPE PL/SQL TABLE
    Table type for predicted dates of services deactivation based on reserved funds in charge logs.
  • TYPE VOICE_DETALIZATION PL/SQL RECORD
    Details on a phone call.
  • TYPE VOICE_DETALIZATION_TBL_TYPE PL/SQL TABLE
    Table type for details on phone calls.
  • FUNCTION GET_SERV_DET_PARAMS
    Check whether a price plan in a price specification contains any data or voice services.
  • FUNCTION GET_USER_DOC_LIST
    Get a list of contracts for a customer, separated by commas.
  • FUNCTION SI_SUBJ_SERVICES_AUTHORS
    Get a list of users who created subscriptions to network services for a customer.
  • FUNCTION USERS_ACC_DETALIZATION
    Get a list of charges, payments and credit limits.
  • FUNCTION ANY_TRAFFIC_IN_CHARGE_LOG
    Check whether a charge log contains any data traffic.
  • FUNCTION GET_RECOMMENDED_PAYMENT
    Get a recommended payment amount.
  • FUNCTION GET_USERS_DOC_BINDS_LIST
    Get a list of documents related to a customer (except for payment documents).
  • FUNCTION USERS_AVAILABLE_AV_SERVS_LIST
    Get a list of available antivirus services.
  • FUNCTION CHARGE_LOG_ID_FOR_DETAILS
    Get a value of the global constant gnum_N_CHARGE_LOG_FOR_DETAIL.
  • PROCEDURE GET_ACCOUNT_CREDIT
    Get a current credit limit.
  • FUNCTION GET_USER_SERV_ADDRESSES
    Get a list of service addresses for a customer, separated by semi-colons.
  • FUNCTION IS_USER_CONTEXT
    Check if the Customer Self-Care Portal context is set.
  • FUNCTION ANY_ADDSERVS_IN_CHARGE_LOG
    Check whether a charge log contains any additional services.
  • FUNCTION GET_ACCOUNT_SUM_FREE
    Get available funds on a customer account. The function is used by the HID agent.
  • FUNCTION GET_ACC_RESERVED_LIST
    Get a list of account reserved funds.
  • PROCEDURE GET_LAST_GOOD_PACK
    Get a last used price plan and an end date of a charge log issued for it.
  • FUNCTION GET_USER_ACCOUNT_LIST
    Get a list of accounts for a customer, separated by commas.
  • FUNCTION GET_USER_ACC_DEPLETION_DATES
    Get a list of dates when available funds on a customer's account run out and current charge logs become executed.
  • FUNCTION GET_USER_DEVICES
    Get a list of CPE.
  • FUNCTION IS_CUSTOMER_BOUND
    Check whether a customer is bound to a division.
  • FUNCTION SUBJ_SERVICES_HISTORY
    Get a list of changes in subscriptions to network services for a customer.
  • FUNCTION GET_USER_CURRENT_GOODS
    Get a list of current subscriptions to services for a customer account.
  • FUNCTION GET_ACCOUNT_BALANCE_SUM
    Get customer account balance.
  • FUNCTION GET_RECOMMENDED_PAYMENT_LIST_C
    Get a list of recommended payments. The function calls SD_PAYMENT_REQUESTS_PKG.GET_RECOMMENDED_PAYMENT_C, use the latter if you can.
  • FUNCTION USER_HISTORY
    Get a list of changes in parameters of a customer.
  • FUNCTION USER_VOICE_DETALIZATION
    Get details on phone calls.
  • FUNCTION GET_ACCOUNT_SCHEDULED_CHARGES
    Get a list of scheduled charges for an account (including credit limits expirations).
  • FUNCTION GET_ADDITIONAL_SERV_DETAILS
    Get a list of additional services within a price plan under a charge log.
  • FUNCTION GET_DETAILED_SERV_STAT
    Get details on data services.
  • FUNCTION GET_RECOMMENDED_PAYMENT_LIST
    Get a list of recommended payments.
  • PROCEDURE GET_USER_BY_SERV_LOGIN
    Get a customer and a CPE by his or her login in a subscription to a network service (NULLs if not found).
  • FUNCTION GET_USER_GOODS_ENDING
    Get dates of services deactivation based on reserved funds in charge logs.
  • FUNCTION USERS_BILLED_SERVS_LIST
    Get a list of services provided to a customer.
  • FUNCTION USERS_CURRENT_SERVS_LIST
    Get a list of current services for a customer.
  • PROCEDURE GET_ACCOUNT_BALANCE
    Get customer account parameters on a specific date: balance, available and reserved funds. The procedure is used by the HPD agent.
  • FUNCTION GET_INVOICE_SERVS_LIST
    Get a list of available services within a price plan under a current charge log.
  • FUNCTION GET_LAST_PAYMENT
    Get last a payment to an account.
  • FUNCTION GET_N_GOOD_ID_FOR_DETALIZATION
    Get a service from a detailed list of services by a charge log, price plan and column number.
  • FUNCTION GET_USER_ACCOUNTS
    Get a list of accounts for a customer.
  • FUNCTION GET_USER_RECOMMENDED_PAY
    Get a recommended payment amount.
  • FUNCTION IS_ACTUAL_SERV_DOC
    Сheck whether a customer can be provided with services under a specified document.
  • FUNCTION IS_USER_ACTUALIZE
    DEPRECATED: do not use. Check whether a customer is up to date.

SP_COMMANDS_PKG

  • PROCEDURE GENERATE_COMMANDS
    Generate and send commands.
  • PROCEDURE GENERATE_FOR_PROV_ATTRIBUTE
    Generate commands for provider attribute
  • FUNCTION GET_COMMAND_TYPE
    Get current type of command
  • PROCEDURE GENERATE_FOR_SUBSCRIPTION
    Generate commands for subscription
  • PROCEDURE GENERATE_FOR_TEMPLATE
    Generate commands for configuration template
  • PROCEDURE GENERATE_FOR_ACCOUNT
    Generate commands for account
  • PROCEDURE GENERATE_FOR_CUST_EQUIPMENT
    Generate commands for customer equipment
  • PROCEDURE GENERATE_BY_BASE_VERSION
    Generate commands for all versions with specified base version.
  • PROCEDURE GENERATE_FOR_PROV_ATTRIBUTES
    Generate commands for provider attributes
  • PROCEDURE GENERATE_FOR_PROV_EQUIPMENT
    Generate commands for provider equipment
  • PROCEDURE SEND_COMMANDS
    Send commands into queue.

SR_GOODS_PKG

The product catalog management.

  • PROCEDURE SR_GOODS_COPY
    Copy a catalog entry.
  • PROCEDURE SR_GOODS_PUT
    Create or update a product catalog entry.
  • PROCEDURE SR_GOOD_VALUES_TYPE_DEL
    Delete a custom field of a catalog entry.
  • PROCEDURE SR_GOOD_VALUES_TYPE_PUT
    Create or update a custom field of a catalog entry.
  • PROCEDURE CREATE_CATALOG_VERSIONS
    Update versions of catalog entries and their custom field values for all divisions.
  • PROCEDURE LR_GOOD_VALUES_TYPE_PUT
    Add or update a field name translation into a specified language.
  • PROCEDURE SR_GOOD_VALUES_PUT
    Add or update a custom field value.
  • FUNCTION COPY
    Copy a catalog entry.
  • PROCEDURE PUT_GOOD_VALUE
    Add a value of a catalog entry custom field.
  • PROCEDURE SR_GOOD_GOODS_BINDS_PUT
    Create or update a binding between catalog entries, for example, between a service (or a price plan) and an object type.
  • PROCEDURE SR_GOOD_NAMES_DEL
    Delete a service name used in documents.
  • PROCEDURE SR_GOODS_DEL
    Detele a catalog entry.
  • PROCEDURE SR_GOOD_GOODS_PUT
    Create or update a binding between catalog entries. Warning: the procedure doesn't validate input data.
  • PROCEDURE SR_GOOD_VALUES_DEL
    Delete a custom field value.
  • PROCEDURE SR_GOOD_NAMES_PUT
    Add or update a service (or a price plan) name used in documents of a specified type.
  • PROCEDURE SR_GOOD_GOODS_DEL
    Delete a binding between catalog entries.
  • PROCEDURE TAG
    Tag a catalog entry.

SR_GOODS_PKG_S

Retrieving data on catalog entries (including equipment types, services and price plans), their custom fields and bindings.

  • TYPE GOOD_BINDS PL/SQL RECORD
    Binding between catalog entries, for example, between a service (or a price plan) and an object type.
  • TYPE GOOD_BINDS_TABLE PL/SQL TABLE
    Table type for bindings between catalog entries.
  • TYPE GOOD_VALUE_TYPE PL/SQL RECORD
    Custom field of a product catalog entry, a type of specification items or a specification item.
  • TYPE GOOD_VALUE_TYPE_TABLE PL/SQL TABLE
    Table type for custom fields.
  • TYPE INTARRAY PL/SQL TABLE
    Table type for an array of numbers.
  • TYPE SERVICE_PERMITTED_CACHE_TYPE PL/SQL TABLE
    Table type for caching equipment types and services with results of checking if the services are allowed to be provided on such equipment.
  • FUNCTION GET_CHARGES_COUNT
    Calculate a number of service charging periods within a specified period.
  • FUNCTION GET_GOOD_D_VALUE
    Get a date value of a custom field.
  • FUNCTION GET_GOOD_N_REF_ID
    Get a value of a drop-down list (a reference value).
  • FUNCTION GET_GOOD_VALUE
    Get a record with a value of a custom field.
  • FUNCTION GET_GOOD_VALUE_TYPE_ID
    Get a custom field by its code.
  • FUNCTION GET_PRECISION_BY_UNIT
    Get a number of decimal places for a measuring unit.
  • FUNCTION IS_EXISTS_PARENT
    Check whether a catalog entry is among children of the other entry.
  • FUNCTION GET_GOOD_SPEC_VALUE_TYPES_LIST
    Get a list of custom fields for a specification item.
  • FUNCTION GET_GOOD_VALUE_TYPES_LIST
    Get a list of custom fields for a catalog entry sorted by inheritance depth.
  • FUNCTION GET_ID_BY_CODE
    Get a catalog entry by its code. The function is used by the HID agent.
  • FUNCTION GET_N_PARENT_GOOD_ID
    Get a parent of a catalog entry.
  • FUNCTION GET_VC_GOOD_KIND_NAME
    Get a name of an object type.
  • FUNCTION IS_BASE_TRAFFIC_SERV
    Check whether a service is a basic traffic service.
  • FUNCTION GET_GOOD_C_VALUE
    Get a char value of a custom field.
  • FUNCTION GET_GOOD_VC_VALUE
    Get a string value of a custom field.
  • PROCEDURE ENABLE_SERV_PERMITTED_CACHE
    Enable the cache with equipment types and allowed/forbidden services.
  • FUNCTION EXISTS_CUSTOMER_EQUIPMENT
    Сheck whether a customer-owned equipment of a specified type exists.
  • FUNCTION GET_CODE_BY_ID
    Get a catalog entry code. The function is used by the HID agent.
  • FUNCTION GET_NAME_BY_DOCTYPE
    Get a service (or a price plan) name used in documents of a specified type.
  • FUNCTION GET_N_GOOD_GROUP_ID
    Get a type of a catalog entry.
  • FUNCTION IS_SERVICE_PERMITTED
    Check whether a service can be provided on equipment of a specified type. Warning: please use the function only when bindings of the type CONST.GOOD_BIND_TYPE_PermittedGood are specified for the equipment type.
  • FUNCTION ADJUST_D_END
    Adjust an end date of a service providing period. If the input end date increased by one second (dt_D_END + 1 s) equals an input start date increased by an integer number of charging periods (dt_D_BEGIN + N charging periods), the function returns the increased end date, otherwise, the initial end date.
  • PROCEDURE DISABLE_SERV_PERMITTED_CACHE
    Disable the cache with equipment types and allowed/forbidden services.
  • FUNCTION GET_NAME_BY_ID
    Get a catalog entry name. The function is used by the HID agent.
  • FUNCTION GET_N_GOOD_BRANCH_ID
    Get a product catalog branch an entry belongs to.
  • FUNCTION GET_UNIT_BY_GOOD
    Get a catalog entry measuring unit.
  • FUNCTION GET_UNIT_TYPE_BY_GOOD
    Get a type of a catalog entry measuring unit.
  • FUNCTION CATALOG_ITEM_INHERITED_TAGS
    Get catalog entry tags including inherited ones.
  • FUNCTION FIND_N_GOOD_BRANCH_ID
    Find a product catalog branch for an entry.
  • FUNCTION GET_GOOD_VALUE_TYPE_NAME
    Get a name of a custom field.
  • FUNCTION GET_N_BASE_GOOD_ID
    Get a basic service for a detailed traffic service or a type for a specification item.
  • FUNCTION GET_TAGS
    Get catalog entry tags.
  • FUNCTION IS_TRAFFIC_SERV
    Check whether a service is a detailed traffic service.
  • FUNCTION GET_GOOD_BINDS_LIST
    Get a list of bindings by a bound catalog entry.
  • FUNCTION GET_GOOD_C_FL_VALUE
    Get a value of a check box custom field.
  • FUNCTION GET_N_GOOD_SERV_TYPE_ID
    Get a type of a service.
  • FUNCTION GET_N_HIGH_GOOD_GROUP_ID
    Get a category of a service — a top group of a catalog section the service belongs to.
  • FUNCTION GET_VALUE
    Get a catalog entry record.
  • FUNCTION HAS_INDEPENDENT_CHARGE_RULE
    Check whether there is an activation rule for a service that requires no sufficient account balance.
  • FUNCTION GET_DETAILED_SERVICE_ID
    Get a detailed traffic service by its basic service and direction.
  • FUNCTION GET_GOOD_N_VALUE
    Get a numerical value of a custom field.
  • FUNCTION GET_N_GOOD_TYPE_ID
    Get a product catalog section an entry belongs to.
  • FUNCTION GET_SERV_SCHEMES_VALUE
    Get a record with a service providing scheme for a service or a price plan.
  • PROCEDURE INCLUDE_CHILD_SERVICES
    Add child services to services that are aready in a table.

SR_REGIONS_PKG

Registry of regions management

  • PROCEDURE CREATE_REGION
    Sophisticated procedure for creating a region (or several if needed).
  • PROCEDURE SR_REGIONS_PUT
    Create or replace a region.
  • PROCEDURE UPDATE_VISUAL_CODES
    Generate new VISUAL_CODE and SEARCH_CODE for a region.
  • PROCEDURE SR_REGIONS_DEL
    Delete a region.
  • PROCEDURE UPDATE_SEARCH_INDEX
    Syncronize OracleText index.

SR_REGIONS_PKG_S

Registry of regions management

  • TYPE FOUND_REGION_ROW PL/SQL RECORD
    Regions with full name to put out as search results.
  • TYPE REGION_ID PL/SQL RECORD
    Child region record with level.
  • TYPE REGION_IDS PL/SQL TABLE
    Table type for region ID and level.
  • TYPE REGION_LIST PL/SQL TABLE
    Table type for regions with full names.
  • FUNCTION GET_FEDERAL_NODE
    Get nearest node of federal hierarchy.
  • FUNCTION GET_REGION_TYPE_BY_SHORT_NAME
    Get region type reference record by short name (SI_REF.VC_VALUE).
  • FUNCTION GET_ROOT_REGION_NAME_BY_ID
    Get root level region (country).
  • FUNCTION GET_CODE_BY_ID
    Get region code by id.
  • PROCEDURE GET_ADDR_PARAMS_BY_REGION
    Geat address parameters by region.
  • FUNCTION GET_HIERARCHY_TYPE
    Get hierarchy type of a region.
  • FUNCTION GET_REALTY_OBJECT_ID
    Get real estate object by region.
  • FUNCTION GET_REGION_LIST
    Search regions. Used in HID.
  • FUNCTION PARSE_BUILDING_STRING
    Parse building name (house, pavilion, structure, property).
  • FUNCTION GET_REGION_TYPE_ID
    Get region type.
  • FUNCTION GET_CHILDREN_REGION_LIST
    Get list of all child regions.
  • FUNCTION GET_ID_BY_CODE
    Get region by code and type.
  • FUNCTION GET_NAME_EX
    Generate a full name of a region (including parent regions).
  • FUNCTION GET_REALTY_GOOD_ID
    Get real estate product catalog entry by region.
  • FUNCTION GET_SEARCH_CODE
    Get region name stored in VC_SEARCH_CODE column.
  • FUNCTION GET_NEAREST_FIRM_BY_REGION
    Get nearest division by region.
  • FUNCTION GET_UPPER_REGION_ID
    Get parent id for a region by id and type.
  • FUNCTION GET_UPPER_REGION_NAME
    Get name of parent region of a specified type.
  • FUNCTION GET_VISUAL_CODE
    Get full name stored in VC_VISUAL_CODE column.
  • FUNCTION GET_NAME_BY_ID
    Get region name by id.
  • FUNCTION GET_REGION
    Get region by id.
  • FUNCTION GET_UPPER_REGION_CODE
    Get parent region code for a region by id and type.
  • FUNCTION GET_PLACE_BY_REGION_ID
    Get full address up to country level.
  • FUNCTION GET_UPPER_REGION
    Get parent record for a region by id and type.

SS_AUTHENTICATION_PKG

Authentication management

  • PROCEDURE SET_ACTIVE_FIRM
    Change current division.
  • FUNCTION LOGIN_AND_GET_TOKEN
    Main authentication function. See documentation for details.
  • PROCEDURE SET_PROGRAM_NAME
    Calls DBMS_APPLICATION_INFO.SET_CLIENT_INFO.
  • PROCEDURE SET_CURRENT_MODULE
    Calls DBMS_APPLICATION_INFO.SET_MODULE.
  • PROCEDURE LOGIN
    Procedure wrapper for the login function.
  • PROCEDURE CLOSE_SESSION
    Close current session.
  • PROCEDURE CLOSE_SESSION
    Close a session by client session ID.
  • FUNCTION IS_LOGGED_IN
    Is currently logged in?
  • PROCEDURE SET_CURRENT_ACTION
    Calls DBMS_APPLICATION_INFO.SET_ACTION.
  • PROCEDURE CLEAR_CONTEXT
    Clear current session context.
  • PROCEDURE SWITCH_CONTEXT
    Switch context by client session ID. Procedure will look up opened sessions.

SS_FILES_PKG

Procedures for working with files Author: Leonid Bugaev

  • PROCEDURE DUMP_TT_TO_FILE
    Save temporary table contents in a file. Procedure will select only rows from a given section. If there is no such section, entire TT_VALUES will be saved. In this case the list of columns is mandatory.
  • PROCEDURE SS_FILES_PUT
    Create or replace file.
  • PROCEDURE SS_FILES_PUT_EX
    Create or replace file.
  • PROCEDURE SS_FILES_DEL
    Delete file.

STR_UTILS_PKG_S

Работа с символьными строками

  • TYPE ASSOC_ARRAY_TYPE PL/SQL TABLE
    Ассоциативный массив
  • TYPE ASSOC_ARRAY_TYPE PL/SQL TABLE
    Ассоциативный массив
  • TYPE FIELD_ROW PL/SQL RECORD
    Строка таблицы (для CSV и подобных форматов).
  • TYPE INTARRAY PL/SQL TABLE
  • TYPE SHORT_STRING_TABLE PL/SQL TABLE
    Таблица коротких строк с числовым индексом
  • TYPE STR_TABLE PL/SQL RECORD
    Массив слов с нумерацией.
  • TYPE STR_TABLE_TYPE PL/SQL TABLE
    Таблица строк со словами и порядковыми номерами
  • TYPE SUBST_TABLE PL/SQL RECORD
    Запись для обработки подстановок.
  • TYPE SUBST_TABLE_TYPE PL/SQL TABLE
    Таблица подстановок
  • TYPE TT_TYPE PL/SQL TABLE
    Массив строк
  • TYPE USER_ADDRESS PL/SQL RECORD
    Запись для разобранного адреса.
  • TYPE VARCHAR2_TABLE PL/SQL TABLE
    Таблица строк
  • TYPE VARCHAR_TBL PL/SQL TABLE
    Таблица строк (128)
  • FUNCTION INT_TO_STR_IN_WORDS
    Число прописью.
  • PROCEDURE REPLACE_SUBST_WITH_VALUE
    Заменить подстановку в строке шаблона на ее значение.
  • FUNCTION TRUNC_VARIABLE_PREFIX
    Отрезать стандартный префикс в наименовании переменной.
  • FUNCTION DATE_PERIOD_TO_STR
    Преобразовать период в строку.
  • FUNCTION FLATTEN_ERROR_STACK
    Получение текстовой строки из стека ошибки.
  • FUNCTION HIGHLIGHT_INDEXED_CLOB
    Подсветка запроса в результате поиска (CLOB) с использованиеv индекса.
  • FUNCTION HIGHLIGHT_INDEXED_STRING
    Подсветка запроса в результате поиска (VARCHAR2) с использование индекса.
  • FUNCTION PARSE_ADDRESS
    Парсер одной строки адреса.
  • PROCEDURE WRAP_CALL_AS_PLSQL
    Wrap procedure call or whichever plsql in begin-end
  • FUNCTION CALC_PASS_STRENGTH
    Вычислить стойкость пароля, возвратить число, оценивающее стойкость.
  • FUNCTION FORMAT_T
    Wrapper for FORMAT with list of parameters
  • FUNCTION PARSE_SUBSTS
    Выделить из строки возможные подстановки и выдать их в виде pipelined-таблицы.
  • FUNCTION BLOB_TO_CLOB
    Convert BLOB в CLOB.
  • FUNCTION FETCH_TT_TO_CSV
    Создать CSV-объект на основе содержимого указанной секции временной таблицы.
  • FUNCTION GET_DIFF_CHAR_QUANT
    Возвратить количество различных символов в строке.
  • FUNCTION GET_MONTH_NAME
    Возвратить название месяца по числовому коду.
  • FUNCTION GET_MONTH_NAME_ABBR
    Возвратить сокращенное названия месяца по числовому коду
  • FUNCTION GET_NAME_IN_CASE
    Возвратить существительное в правильном падеже в зависимости от числа.
  • PROCEDURE CONVERT_CLOB_TO_BLOB
    Конвертировать BLOB в CLOB.
  • FUNCTION CSV_TO_TT
    Загрузка таблицы из формата CSV.
  • FUNCTION EXTEND_COLUMN_NAME
    Возвратить имя столбца с префиксом переменной.
  • FUNCTION HIGHLIGHT_STRING
    Функция для подсветки строки.
  • FUNCTION NUMBER_TO_STR_IN_WORDS
    Сумма прописью, с учетом копеек, валюты, и падежей
  • FUNCTION NUMBER_TO_STR_IN_WORDS
    Сумма прописью по заданной валюте.
  • PROCEDURE ADD_CONDITION
    Приклеивает условие к запросу с равенством, если значение не NULL, или проверкой IS NULL.
  • FUNCTION CONVERT_NUMBERS_TO_VARCHARS
    Convert NUMBER_TABLE to VARCHAR_TABLE
  • FUNCTION FORMAT
    Format string (printf analog) "%"["-"][width]["." prec]type "-" - left alignement width - minimal value width prec - calue precision type - value data type s - string d - integer (prec for minimal number of decimal digits) x - integer in hex representation (prec for minimal number of hex digits)
  • FUNCTION GET_CLOB_FROM_VARCHAR_TABLE
    Get CLOB value from table of strings.
  • FUNCTION HTML_ENTITIES_DECODE
    Декодирование строки от HTML Entities.
  • FUNCTION HTML_ENTITIES_ENCODE
    Кодирование строки с помощью HTML Entities.
  • FUNCTION LOB_REPLACE
    Replace text in CLOB.
  • FUNCTION PARSE_WORDS
    Поделить строку на слова. Максимум 1000 слов или 4096 байт в строке.
  • PROCEDURE PARSE_WORDS
    Поделить строку на два слова по первому разделителю.
  • FUNCTION STR_TO_KEY_VALUE_LIST
    Deserialize string as list of keys and values separated by character.
  • FUNCTION TRANSLIT
    Транслитерировать кириллический текст в латинский без возможности обратной транслитерации (мягкие и твердые знаки пропадают).
  • PROCEDURE CLOB_PREPEND
    Prepend LOB with string.
  • FUNCTION GET_RANDOM_PASS
    Получение случайным образом сгенерированного пароля.
  • FUNCTION GET_UNIQ_SESSION_ID
    Generate new session identifier.
  • FUNCTION PARSE_SEARCH_STRING
    Токенайзер для OracleText.
  • PROCEDURE READ_LINE_FROM_CLOB
    Высчитать из CLOB строку, начинающуюся с указанного символа, и возвратить позицию начала следующей строки.
  • FUNCTION SHOW_ADDRESSES
    Stringify addresses from ADDRESS_AND_CODE_TBL.
  • FUNCTION SHOW_NUMBER_ARRAY
    Stringify array of numbers.
  • PROCEDURE CONVERT_BLOB_TO_CLOB
    Конвертировать BLOB в CLOB.
  • FUNCTION PARSE_ASSOC_ARRAY
    Разбор строки, содержащей параметры вида "key1":"value1","key2":"value2".
  • FUNCTION PARSE_QUICK_SEARCH_STRING
    Угадывающий токенайзер для быстрого поиска.
  • FUNCTION PARSE_WORDS
    Поделить строку на слова. Максимум 1000 слов или 4096 байт в строке.
  • PROCEDURE PARSE_WORDS
    Поделить строку на два слова по первому разделителю.
  • FUNCTION PARSE_WORDS_TO_VARCHAR_TABLE
    Поделить строку на слова и вернуть коллекцию. Максимум 1000 слов или 4096 байт в строке.
  • FUNCTION STR_TO_NUMBER_TABLE
    Parse string as list of integers.
  • FUNCTION TABLE_TO_DLM_STRING
    Преобразование массива строк в одну строку с заданными разделителями между элементами.

UTILS_PKG_S

Utility functions and procedures

  • TYPE DATE_PERIOD PL/SQL RECORD
    Date range.
  • TYPE DATE_PERIODS PL/SQL TABLE
    Date range table.
  • TYPE DBMS_OUTPUT_LINE PL/SQL RECORD
    DBMS_OUTPUT line.
  • TYPE DBMS_OUTPUT_LINE_TABLE_TYPE PL/SQL TABLE
  • TYPE LONGOP_DESCR PL/SQL RECORD
    Long operations line.
  • TYPE NUMBER_TBL PL/SQL TABLE
    Indexed table of numbers.
  • PROCEDURE ASSERT
    Standard assertion. Raises exception when input is FALSE. NULL and FALSE are equivalent.
  • PROCEDURE CALC_TAX_BY_PRICE_WO_TAX
    Calculate amounts by price excluding taxes. Sequence: quantity * price excluding taxes => Amount excluding taxes => Taxes => Amount including taxes = Amount excluding taxes + Taxes.
  • FUNCTION GENERATE_MONTHS
    Generate a set of N months counting backwards starting from dt_D_OPER.
  • FUNCTION GET_COLUMN_SIZE
    Get varchar column size.
  • FUNCTION GET_END_DATE_INTERSECT
    DEPRECATED in v5.1! Get end date of two date ranges intersecting.
  • FUNCTION GET_ONE
    Returns NULL for N_UNIT_ID = Unknown.
  • FUNCTION GET_TS_DIFF_IN_SEC
    Get timestamp difference in seconds with milliseconds.
  • FUNCTION IS_NUM_VALUE_IN_TABLE
    Check if value in coolection of NUMBER_TABLE type.
  • FUNCTION BIT_OR
    Bit OR.
  • FUNCTION BOOLEAN_TO_NUM_BOOL
    Convert boolean to CONST.BOOL subtype.
  • PROCEDURE CLOSE_CURSOR
    Close cursor if necessary.
  • FUNCTION DATE_TO_STR
    Convert date to string representation. Currently uses DD.MM.YYYY format for dates and DD.MM.YYYY HH24:MI:SS for datetime
  • FUNCTION GET_BEGIN_DATE_INTERSECT
    DEPRECATED in v5.1! Get start date of two date ranges intersecting.
  • FUNCTION GET_DBMS_OUTPUT_LINES
    Get DBMS_OUTPUT lines.
  • FUNCTION GET_LOCAL_CONTEXT
    Get local context.
  • FUNCTION GET_PROFILING
    DEPRECATED in v5.1 Get profiling results.
  • FUNCTION GET_QUANT_FROM_UNIT
    Convert quantity from one unit to another.
  • FUNCTION GET_XML_CL_VALUE
    Get value from XML using XPath.
  • FUNCTION TO_UNIX_TIMESTAMP
    Get datetime in UNIX timestamp.
  • FUNCTION ZERO_NULL
    Translate 0 into NULL or return input value.
  • FUNCTION CALC_SUM_WO_TAX_BY_SUM
    Calculate amount excluding taxes by amount including taxes.
  • PROCEDURE CALC_TAX_BY_PRICE
    Calculate amounts by price including taxes. Sequence: quantity * price including taxes => Amount including taxes => Taxes => Amount excluding taxes = Amount including taxes - Taxes.
  • FUNCTION GET_C_PERIOD
    Get period code.
  • FUNCTION GET_LOOKUP_VISUAL_VALUE
    Get visual value for lookup.
  • FUNCTION GET_NEXT_N_LINE_NO
    Get a next line number (N_LINE_NO).
  • FUNCTION GET_VC_LINE_NO
    Convert line number to string.
  • PROCEDURE HASH_PASSWORD
    Hash password string.
  • FUNCTION IS_PROC_EXISTS
    Check if a procedure exists.
  • PROCEDURE PROFILE_POINT
    DEPRECATED in v5.1 Profile stage.
  • PROCEDURE START_PROFILING
    DEPRECATED in v5.1 Start profiling.
  • PROCEDURE WRITE_TO_FILE
    Write binary data to file.
  • FUNCTION ALL_ACTIVE
    Returns Y if all passed arguments equal Y, N otherwise.
  • FUNCTION GET_N_MAJOR_LINE_NO
    DEPRECATED in v5.1! Get major digits of a line number.
  • FUNCTION GET_TIME_UNIT_RATIO
    Get ratio of two time units.
  • PROCEDURE INFINITE_LOOP_GUARD
    Protection from inifinite loop. Raises an exception when max iteration count exceeded.
  • FUNCTION BIT_NOT
    Bit NOT.
  • FUNCTION CALC_PRICE
    Calculate price including taxes by price excluding taxes.
  • PROCEDURE CALC_TAX_BY_SUM_WO_TAX
    Calculate taxes and amount including taxes by amount excluding taxes.
  • FUNCTION FROM_EPOCH_MS_TIME_TO_TS
    Convert milliseconds from the beginning of Unix epoch time to Oracle timestamp.
  • FUNCTION GET_FIBONACCI_NUMBER
    DEPRECATED in v5.1! Get Fibonacci number by position.
  • FUNCTION GET_PARENT_N_LINE_NO
    DEPRECATED in v5.1! Get N_LINE_NO of a parent line.
  • FUNCTION GET_PK_COLUMN_NAME
    Get primary key column name.
  • FUNCTION IS_DATES_INTERSECT
    Check if two date ranges intersect. NULL is considered an open end.
  • FUNCTION IS_ENTIRE_PERIOD
    Does date period match time unit and value? Considers one second subtraction. Return value will be rounded up by days if num_N_PERIOD_UNIT_ID is equal UNIT_Month or UNIT_Year.
  • PROCEDURE METER_TIME_AND_WAIT
    Calculate avg time (sec) and compare to max avg time (sec) for current iteration.
  • PROCEDURE REFRESH_MATERIALIZED_VIEW
    Refresh materialized view.
  • FUNCTION TO_ORA_BOOL
    Convert CONST.BOOL/MAIN.BOOL to BOOLEAN. When NULL is passed as value, returned value will be NULL.
  • FUNCTION UNIX_TIMESTAMP_TO_DATE
    Convert Unix timestamp to Oracle DATE.
  • FUNCTION ADD_TIME_PERIOD
    Add period to date.
  • FUNCTION CALC_PRICE_WO_TAX
    Calculate price excluding taxes by price including taxes.
  • PROCEDURE CALC_TAX_BY_SUM
    Calculate taxes and amount excluding taxes by amount including taxes.
  • FUNCTION COLLECT_LOCAL_CONTEXT
    Collect local context.
  • PROCEDURE DATE_INTERSECT
    DEPRECATED in v5.1! Get intersection of two date ranges.
  • FUNCTION DATE_IN_DBTIMEZONE
    Get datetime in DB time zone. dt_D_OPER Date
  • PROCEDURE GET_CALLER_UNIT_INFO
    Returns caller unit info. I.e. unit name and line no.
  • FUNCTION GET_DATE_DIFF
    Get difference between two dates in specified time units.
  • FUNCTION GET_PERIOD_FACTOR
    Get fraction of period.
  • FUNCTION IS_UNLOCK_HASH_VALID
    Check unlock hash validity.
  • FUNCTION GET_CHECKSUM
    Get checksum.
  • FUNCTION GET_ISO_WEEK_DAY
    Get weekday number by date. Unlike TO_CHAR(dt_DATE, 'D') assumes Monday as the first day regardless of NLS_TERRITORY.
  • FUNCTION GET_TABLE_COLUMNS_LIST
    Get delimited list of table columns.
  • PROCEDURE HTTP_REQUEST
    Perform HTTP request.
  • FUNCTION NUM_BOOL_TO_FLAG
    Convert CONST.BOOL subtype to flag. When NULL is passed as value, returned value will be NULL.
  • PROCEDURE SET_LONGOP_STATUS
    Set long operation status.
  • FUNCTION TO_CHAR_FIN
    Convert amount to string in financial format (min 2 decimal digits).
  • FUNCTION BIT_AND
    Bit AND.
  • FUNCTION FLAG_TO_NUM_BOOL
    Convert flag to CONST.BOOL subtype. When NULL is passed as value, returned value will be NULL.
  • FUNCTION GET_AP_VISUAL_VALUE
    Get visual representation of a custom field value.
  • FUNCTION GET_HASHED_STRING
    Get hashed password string.
  • FUNCTION GET_NLS
    Get value of specified nls parameter.
  • FUNCTION GET_N_MINOR_LINE_NO
    DEPRECATED in v5.1! Get minor digits of a line number.
  • PROCEDURE LOG_CALL
    Log procedure call. Writes a line to TT_VALUES in autonomous transaction. Can be useful to count procedure calls in queries.
  • FUNCTION TO_NUMBER_UNI
    Convert string to number. Accepts both ',' and '.' as decimal point regardless of NLS parameters.