Oracle API diff 6.0 and 6.2

Legend: added, changed, deleted.

Objects

ACC_1C_PKG
ACC_INVOICES_PKG
AP_USER_OFFICE_PKG
EX_LOADINGS_PKG
EX_PAYMENTS_PKG
EX_PAYMENTS_PKG_S
SD_BALANCE_ADJUSTMENTS_PKG
SD_CHARGE_LOGS_PKG
SD_CONTRACTS_PKG
SD_DOCUMENTS_PKG_S
SD_OVERDRAFTS_PKG_S
SD_PAYMENTS_PKG
SD_PAYMENT_REQUESTS_PKG
SD_REQUESTS_PKG
SI_ACCOUNTS_PKG
SI_ADDRESSES_PKG
SI_SUBJECTS_PKG
SI_SUBJECTS_PKG_S
SI_SUBSCRIPTIONS_PKG
SI_SUBSCRIPTIONS_PKG_S
SI_USERS_PKG
SI_USERS_PKG_S
SR_REGIONS_PKG_S
SS_AUTHENTICATION_PKG
STR_UTILS_PKG_S
UTILS_PKG_S
AP_V_AUTO_TOP_UPS
AP_V_OFFICE_PAYS
RG_V_SERV_STATUS
RPT_V_CDR
RPT_V_CDR_ARCH
RPT_V_PAY_DOCS
RPT_V_USERS
RP_V_ALL_PROFILES
RP_V_CURRENT_PROFILES
RP_V_PROFILES
SD_V_CHARGE_LOGS_JR
SD_V_CONTRACTS
SD_V_INVOICES_JR
SD_V_PAYMENTS_C
SD_V_PRICE_ORDERS_T
SD_V_REFUNDS
SD_V_TIME_INTERVALS_T
SI_V_AUTO_TOP_UPS
SI_V_OBJ_VALUES
SI_V_REF
SI_V_SUBJ_ACCOUNTS
SI_V_USER_ADDSERVS
SI_V_USER_DEVICES_SIMPLE
SS_V_CDR_DETAILS
SS_V_JOBS
SS_V_USERS_APP_BINDS
EX_V_SUBJ_SERVICE

Packages

ACC_1C_PKG

Accounting data collection package for 1C software

PROCEDURE COLLECT_ACCOUNTING_DATA

Collect accounting data in temporary table TT_V_ACC_LINES.

PROCEDURE REMOVE_TEMP_ACC_DATA

Delete accounting data from temporary table TT_VALUES

Argument	Direction	Reference type	Type	Default value	Description
tbl_N_FIRM_IDS	IN	NUMBER_TABLE	TABLE	NUMBER_TABLE(MAIN.GET_N_FIRM_ID)	Divisions
tbl_N_SUBJ_GROUP_IDS	IN	NUMBER_TABLE	TABLE	NULL	Customer groups
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()	Tags
dt_D_BEGIN	IN	DATE	DATE	NULL	Collect period beginning date
dt_D_END	IN	DATE	DATE	NULL	Collect period end date
num_N_FORMAT_VER_ID	IN	SI_REF.N_REF_ID%TYPE	NUMBER	CONST.ACC_UNLOAD_VERSION_1c8	1C version {} CONST.ACC_UNLOAD_VERSION_1c77 — version 7.7 {} CONST.ACC_UNLOAD_VERSION_1c8 — version 8
b_UseDocCreatedDate	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Filter invoices by document creation date {} CONST.b_TRUE — filter by document creation date {} CONST.b_FALSE — filter by document begin/end date
tbl_N_ACC_SECTION_IDS	IN	NUMBER_TABLE	TABLE	NUMBER_TABLE()	List of accounting sectors for collecting as constants May contain: - CONST.ACC_SECTION_Bills - CONST.ACC_SECTION_Payments

ACC_INVOICES_PKG

Invoice export for accounting software

PROCEDURE UNLOAD_DOCUMENTS

Export invoices.

Argument	Direction	Reference type	Type	Default value	Description
tbl_N_FIRM_IDS	IN	NUMBER_TABLE	TABLE		Divisions
tbl_N_SUBJ_GROUP_IDS	IN	NUMBER_TABLE	TABLE		Customer groups
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()
dt_D_BEGIN	IN	SD_DOCUMENTS.D_BEGIN%TYPE	DATE		Export period beginning date
dt_D_END	IN	SD_DOCUMENTS.D_END%TYPE	DATE		Export period end date
b_UseDocCreatedDate	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Filter invoices by document creation date {} CONST.b_TRUE — filter by document creation date {} CONST.b_FALSE — filter by document begin/end date

AP_USER_OFFICE_PKG

Customer care portal package

TYPE USER_DETALIZATION_ROWS PL/SQL TABLE

FUNCTION USERS_ACC_DETALIZATION

Get payments, charges and credit limits details.

Argument	Direction	Reference type	Type	Default value	Description
dt_D_BEGIN	IN	DATE	DATE		Lookup period begin date
dt_D_END	IN	DATE	DATE		Lookup period end date
num_N_ACCOUNT_ID	IN	NUMBER	NUMBER		Account
b_Payment	IN	MA.BOOL	NUMBER	MAIN.b_FALSE	Include payments?
b_WriteOff	IN	MA.BOOL	NUMBER	MAIN.b_FALSE	Include charges?
b_Overdraft	IN	MA.BOOL	NUMBER	MAIN.b_FALSE	Include credit limits?
vch_VC_CUSTOM_FIELD_CODE	IN	SD_DOC_VALUES_TYPE.VC_CODE%TYPE	VARCHAR2	NULL
RETURN USER_DETALIZATION_ROWS	Details line
PIPELINED

PROCEDURE PUT_CUSTOMER_CUSTOM_VALUE

Set customer additional parameter.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_CUSTOM_VALUE_CODE	IN	SI_SUBJ_VALUES_TYPE.VC_CODE%TYPE	VARCHAR2		Custom value code
num_N_VALUE	IN	SI_SUBJ_VALUES.N_VALUE%TYPE	NUMBER		Value

EX_LOADINGS_PKG

External data bulk loading

PROCEDURE LOAD_CHARGE_LOGS_FROM_CSV

Load actual charge logs.

Argument	Direction	Reference type	Type	Default value	Description
clb_CL_DATA	IN	CLOB	CLOB		Data to load
dt_D_OPER	IN	DATE	DATE	NULL	Date the billing period will be open
num_ErrorsLimit	IN	NUMBER	NUMBER	10	Maximum number of errors tolerated
vch_VC_FIELD_SEPARATOR	IN	VARCHAR2	VARCHAR2	';'	CSV field separator

PROCEDURE LOAD_PROV_EQUIP_FROM_CSV

Load provider equipment.

Argument	Direction	Reference type	Type	Default value	Description
clb_CL_DATA	IN	CLOB	CLOB		Data to load
num_N_OWNER_ID	IN	SI_SUBJECTS.N_OWNER_ID%TYPE	NUMBER		Owner
num_N_SERVICE_ID	IN	SI_SUBJ_SERVICES.N_SERVICE_ID%TYPE	NUMBER		Network service
num_N_CHAPTER_ID	IN	EX_MAPPINGS.N_CHAPTER_ID%TYPE	NUMBER		Mapping chapter reference entry
num_N_DEFAULT_REGION_ID	IN	SR_REGIONS.N_REGION_ID%TYPE	NUMBER	MAIN.GET_N_REGION_ID	Default region
num_N_MANAGE_SPEC_ID	IN	SR_GOODS.N_BASE_GOOD_ID%TYPE	NUMBER		CPU port specification entry
b_InitializeContent	IN	MAIN.BOOL	NUMBER		Initialize ports?
num_ErrorsLimit	IN	NUMBER	NUMBER	10	Maximum number of errors tolerated
vch_VC_FIELD_SEPARATOR	IN	VARCHAR2	VARCHAR2	';'	CSV field separator

EX_PAYMENTS_PKG

Loading and processing payments from external systems.

PROCEDURE CREATE_AUTO_TOP_UP

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

Argument	Direction	Reference type	Type	Default value	Description
num_N_AUTO_TOP_UP_ID	OUT	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE	NUMBER		Subscription to auto top-up
num_N_DOC_ID	IN	EX_PAYMENTS.N_DOC_ID%TYPE	NUMBER		Payment order for an initial payment
num_N_RULE_ID	IN	SI_AUTO_TOP_UPS.N_RULE_ID%TYPE	NUMBER		Autopayment creation rule
num_N_AUTO_TOP_UP_TYPE_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_TYPE_ID%TYPE	NUMBER	CONST.ATU_TYPE_CreditCard	Subscription type (REF_TYPE_ATUType reference data)
num_N_AUTO_TOP_UP_STATE_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_STATE_ID%TYPE	NUMBER	CONST.ATU_STATE_Unverified	Subscription status (REF_TYPE_ATUState reference data)
num_N_TOP_UP_SUM	IN	SI_AUTO_TOP_UPS.N_TOP_UP_SUM%TYPE	NUMBER	NULL	Autopayment amount
num_N_MIN_SUM	IN	SI_AUTO_TOP_UPS.N_MIN_SUM%TYPE	NUMBER	NULL	Minimum autopayment amount
num_N_MAX_SUM	IN	SI_AUTO_TOP_UPS.N_MAX_SUM%TYPE	NUMBER	NULL	Maximum autopayment amount
num_N_MAX_SUM_MONTHLY	IN	SI_AUTO_TOP_UPS.N_MAX_SUM_MONTHLY%TYPE	NUMBER	NULL	Maximum total amount of autopayments per month
num_N_MAX_TXNS_MONTHLY	IN	SI_AUTO_TOP_UPS.N_MAX_TXNS_MONTHLY%TYPE	NUMBER	NULL	Maximum number of autopayments per month
num_N_LOW_BALANCE_LIMIT	IN	SI_AUTO_TOP_UPS.N_LOW_BALANCE_LIMIT%TYPE	NUMBER	NULL	Account balance limit
dt_D_TERMS_ACCEPTED	IN	SI_AUTO_TOP_UPS.D_TERMS_ACCEPTED%TYPE	DATE	NULL	Date when a customer accepted terms of service
vch_VC_TOKEN	IN	SI_AUTO_TOP_UPS.VC_TOKEN%TYPE	VARCHAR2	NULL	Payment token
vch_VC_CARD_TYPE	IN	SI_AUTO_TOP_UPS.VC_CARD_TYPE%TYPE	VARCHAR2	NULL	Card type
vch_VC_TRUNCATED_PAN	IN	SI_AUTO_TOP_UPS.VC_TRUNCATED_PAN%TYPE	VARCHAR2	NULL	Truncated PAN
dt_D_VALID_UNTIL	IN	SI_AUTO_TOP_UPS.D_VALID_UNTIL%TYPE	DATE	NULL	Subscription expiration date
vch_VC_EMAIL	IN	SI_AUTO_TOP_UPS.VC_EMAIL%TYPE	VARCHAR2	NULL	Payer's email
vch_VC_PHONE	IN	SI_AUTO_TOP_UPS.VC_PHONE%TYPE	VARCHAR2	NULL	Payer's phone number
vch_VC_CARDHOLDER_NAME	IN	SI_AUTO_TOP_UPS.VC_CARDHOLDER_NAME%TYPE	VARCHAR2	NULL	Cardholder name
num_N_CHARGING_DAY	IN	SI_AUTO_TOP_UPS.N_CHARGING_DAY%TYPE	NUMBER	NULL	Charging day of month

PROCEDURE CREATE_ATU_SUBSCRIPTION

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

Argument	Direction	Reference type	Type	Default value	Description
num_N_AUTO_TOP_UP_ID	OUT	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE	NUMBER		Subscription to auto top-up
num_N_DOC_ID	IN	EX_PAYMENTS.N_DOC_ID%TYPE	NUMBER		Payment order
num_N_RULE_ID	IN	SI_AUTO_TOP_UPS.N_RULE_ID%TYPE	NUMBER		Autopayment creation rule
num_N_ACCOUNT_ID	IN	SI_AUTO_TOP_UPS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_AUTO_TOP_UP_TYPE_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_TYPE_ID%TYPE	NUMBER	CONST.ATU_TYPE_CreditCard	Subscription type (REF_TYPE_ATUType reference data)
num_N_AUTO_TOP_UP_STATE_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_STATE_ID%TYPE	NUMBER	CONST.ATU_STATE_Unverified	Subscription status (REF_TYPE_ATUState reference data)
dt_D_TERMS_ACCEPTED	IN	SI_AUTO_TOP_UPS.D_TERMS_ACCEPTED%TYPE	DATE	NULL	Date when a customer accepted terms of service
vch_VC_EMAIL	IN	SI_AUTO_TOP_UPS.VC_EMAIL%TYPE	VARCHAR2	NULL	Payer's email
vch_VC_PHONE	IN	SI_AUTO_TOP_UPS.VC_PHONE%TYPE	VARCHAR2	NULL	Payer's phone number
num_N_CHARGING_DAY	IN	SI_AUTO_TOP_UPS.N_CHARGING_DAY%TYPE	NUMBER	NULL	Charging day of month
num_N_TOP_UP_SUM	IN	SI_AUTO_TOP_UPS.N_TOP_UP_SUM%TYPE	NUMBER	NULL	Top up amount

FUNCTION NOT_REFUNDED_PAYMENTS_LIST_P

Get not refunded payments list in date range.

Argument	Direction	Reference type	Type	Description
vch_VC_BANK_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE	VARCHAR2	Provider account number
dt_D_START	IN	EX_PAYMENTS.D_LOAD%TYPE	DATE	Range start date
dt_D_END	IN	EX_PAYMENTS.D_LOAD%TYPE	DATE	Range end date
RETURN EX_PAYMENTS_PKG_S.LIST_ACCOUNT_PAYMENTS_TBL	Table with payments
PIPELINED

FUNCTION GET_AUTO_TOP_UP_BY_ACCOUNT

Get auto top up by account.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_AUTO_TOP_UPS.N_ACCOUNT_ID%TYPE	NUMBER		Account ID
RETURN SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE	Auto top up row

PROCEDURE PUT_CUSTOMER_CUSTOM_VALUE

Set custom value to customer.

Argument	Direction	Reference type	Type	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER	Customer account
vch_VC_CUSTOM_VALUE_CODE	IN	SI_SUBJ_VALUES_TYPE.VC_CODE%TYPE	VARCHAR2	Custom value code
num_N_VALUE	IN	SI_SUBJ_VALUES.N_VALUE%TYPE	NUMBER	Value

PROCEDURE REFUND_PAYMENT

Refund payment.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Invoice

FUNCTION REVERSAL_PAYMENT_ORDER_EXISTS

Get reversal payment order.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Payment order id
RETURN CONST.BOOL

PROCEDURE UPDATE_AUTO_TOP_UP_BY_ACCOUNT

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

Argument	Direction	Reference type	Type	Description
num_N_AUTO_TOP_UP_ID	OUT	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE	NUMBER	Account ID
num_N_TOP_UP_SUM	IN	SI_AUTO_TOP_UPS.N_TOP_UP_SUM%TYPE	NUMBER	Autopayment amount
num_N_CHARGING_DAY	IN	SI_AUTO_TOP_UPS.N_CHARGING_DAY%TYPE	NUMBER	Charging day of month
num_N_ACCOUNT_ID	IN	SI_AUTO_TOP_UPS.N_ACCOUNT_ID%TYPE	NUMBER

EX_PAYMENTS_PKG_S

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

FUNCTION GET_ACCOUNT_DETAILS_P

Get details on a customer account.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Customer account
b_EvalRecommendedPayment	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Evaluate recommended payment
RETURN ACCOUNT_DETAILS_TBL	Table with account details
PIPELINED

PROCEDURE GET_ACCOUNT_AND_BANK_BY_FIRM

Get account and bank by firm base subject.

Argument	Direction	Reference type	Type	Description
num_N_FIRM_ID	IN	SI_SUBJECTS.N_FIRM_ID%TYPE	NUMBER	Firm
vch_VC_TO_BANK	IN	EX_PAYMENTS.VC_TO_BANK%TYPE	VARCHAR2	Bank code
num_N_ACCOUNT_ID	OUT	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER	Account
num_N_BANK_ID	OUT	SI_SUBJ_ACCOUNTS.N_BANK_ID%TYPE	NUMBER	Bank

SD_BALANCE_ADJUSTMENTS_PKG

PROCEDURE CHARGE_ADJUSTMENT

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

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_CONTRACT_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Contract
num_N_OBJECT_ID	IN	SI_OBJECTS.N_OBJECT_ID%TYPE	NUMBER		Object
num_N_SERVICE_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER		Adjustment service
num_N_SUM	IN	SD_CHARGE_LOGS_C.N_SUM%TYPE	NUMBER	NULL	Amount
num_N_SUM_WO_TAX	IN	SD_CHARGE_LOGS_C.N_SUM_WO_TAX%TYPE	NUMBER	NULL	Amount without tax
dt_D_OPER	IN	SD_CHARGE_LOGS_C.D_OPER%TYPE	DATE	NULL	Operation date
vch_VC_REM	IN	SD_DOCUMENTS.VC_REM%TYPE	VARCHAR2	NULL	Remark
num_N_CHARGE_LOG_ID	OUT	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Created charge log

SD_CHARGE_LOGS_PKG

Charge log management

PROCEDURE SD_CHARGE_LOGS_C_PUT

Create or replace a charge log content line.

Argument	Direction	Reference type	Type	Default value	Description
num_N_LINE_ID	IN/OUT	SD_CHARGE_LOGS_C.N_LINE_ID%TYPE	NUMBER		Line ID
num_N_DOC_ID	IN	SD_CHARGE_LOGS_C.N_DOC_ID%TYPE	NUMBER		Document
num_N_GOOD_ID	IN	SD_CHARGE_LOGS_C.N_GOOD_ID%TYPE	NUMBER	NULL	Service
num_N_MOVE_TYPE_ID	IN	SD_CHARGE_LOGS_C.N_MOVE_TYPE_ID%TYPE	NUMBER	NULL	Transaction type (REF_TYPE_ChargeState reference)
num_N_PAR_LINE_ID	IN	SD_CHARGE_LOGS_C.N_PAR_LINE_ID%TYPE	NUMBER	NULL	Parent line (price plan)
num_N_UNIT_ID	IN	SD_CHARGE_LOGS_C.N_UNIT_ID%TYPE	NUMBER	NULL	Unit (REF_TYPE_Measure_Unit, REF_TYPE_Unit_Time_Type, REF_TYPE_Unit_Data_Type, REF_TYPE_Unit_DataSpeed_Type references)
num_N_QUANT	IN	SD_CHARGE_LOGS_C.N_QUANT%TYPE	NUMBER	NULL	Quantity
num_N_UNIT_BASE_ID	IN	SD_CHARGE_LOGS_C.N_UNIT_BASE_ID%TYPE	NUMBER	NULL	Basic units (REF_TYPE_Measure_Unit, REF_TYPE_Unit_Time_Type, REF_TYPE_Unit_Data_Type, REF_TYPE_Unit_DataSpeed_Type references)
num_N_QUANT_BASE	IN	SD_CHARGE_LOGS_C.N_QUANT_BASE%TYPE	NUMBER	NULL	Quantity in basic units
num_N_TAX_RATE_ID	IN	SD_CHARGE_LOGS_C.N_TAX_RATE_ID%TYPE	NUMBER	NULL	Tax rate (REF_TYPE_TAX_Rates reference)
num_N_CURRENCY_ID	IN	SD_CHARGE_LOGS_C.N_CURRENCY_ID%TYPE	NUMBER	NULL	Currency (REF_TYPE_Currency reference)
num_N_PRICE	IN	SD_CHARGE_LOGS_C.N_PRICE%TYPE	NUMBER	NULL	Price including taxes
num_N_PRICE_WO_TAX	IN	SD_CHARGE_LOGS_C.N_PRICE_WO_TAX%TYPE	NUMBER	NULL	Price excluding taxes
num_N_BASE_SUM	IN	SD_CHARGE_LOGS_C.N_BASE_SUM%TYPE	NUMBER	NULL	Pre-discount amount
num_N_BASE_SUM_WO_TAX	IN	SD_CHARGE_LOGS_C.N_BASE_SUM_WO_TAX%TYPE	NUMBER	NULL	Pre-discount amount excluding taxes
num_N_DISCOUNT_CERT_LINE_ID	IN	SD_CHARGE_LOGS_C.N_DISCOUNT_CERT_LINE_ID%TYPE	NUMBER	NULL	Discount certificate line
num_N_SUM_WO_TAX	IN	SD_CHARGE_LOGS_C.N_SUM_WO_TAX%TYPE	NUMBER	NULL	Amount excluding taxes
num_N_SUM_TAX	IN	SD_CHARGE_LOGS_C.N_SUM_TAX%TYPE	NUMBER	NULL	Taxes
num_N_SUM	IN	SD_CHARGE_LOGS_C.N_SUM%TYPE	NUMBER	NULL	Amount including taxes
num_N_OBJECT_ID	IN	SD_CHARGE_LOGS_C.N_OBJECT_ID%TYPE	NUMBER	NULL	Equipment
num_N_LINE_NO	IN	SD_CHARGE_LOGS_C.N_LINE_NO%TYPE	NUMBER	NULL	Line number
dt_D_BEGIN	IN	SD_CHARGE_LOGS_C.D_BEGIN%TYPE	DATE	NULL	Start date
dt_D_END	IN	SD_CHARGE_LOGS_C.D_END%TYPE	DATE	NULL	End date
dt_D_OPER	IN	SD_CHARGE_LOGS_C.D_OPER%TYPE	DATE	NULL	Operation date (charge date)
vch_VC_REM	IN	SD_CHARGE_LOGS_C.VC_REM%TYPE	VARCHAR2	NULL	Remark
num_N_PRICE_LINE_ID	IN	SD_CHARGE_LOGS_C.N_PRICE_LINE_ID%TYPE	NUMBER	NULL	Price specification line
num_N_ADDRESS_ID	IN	SD_CHARGE_LOGS_C.N_ADDRESS_ID%TYPE	NUMBER	NULL	Address
num_N_PROVIDER_ID	IN	SD_CHARGE_LOGS_C.N_PROVIDER_ID%TYPE	NUMBER	NULL	Address provider
num_N_BASE_LINE_ID	IN	SD_GOOD_MOVES.N_BASE_LINE_ID%TYPE	NUMBER	NULL	Basic line
num_N_SUBJ_GOOD_ID	IN	SD_CHARGE_LOGS_C.N_SUBJ_GOOD_ID%TYPE	NUMBER	NULL	Service subscription
num_N_PROVISION_RULE_ID	IN	SR_PROVISION_RULES.N_PROVISION_RULE_ID%TYPE	NUMBER	NULL
dt_D_PROVISION_BEGIN	IN	SD_CHARGE_LOGS_C.D_PROVISION_BEGIN%TYPE	DATE	NULL	Service provisioning start date

SD_CONTRACTS_PKG

Customer contract management

PROCEDURE SD_CONTRACTS_PUT

Create or replace a customer contract.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN/OUT	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Document
num_N_DOC_TYPE_ID	IN	SD_DOCUMENTS.N_DOC_TYPE_ID%TYPE	NUMBER		Document type (REF_TYPE_Document_Type reference)
num_N_PARENT_DOC_ID	IN	SD_DOCUMENTS.N_PARENT_DOC_ID%TYPE	NUMBER	NULL	Basic contract
num_N_REASON_DOC_ID	IN	SD_DOCUMENTS.N_REASON_DOC_ID%TYPE	NUMBER	NULL	Reason contract
dt_D_DOC	IN	SD_DOCUMENTS.D_DOC%TYPE	DATE	TRUNC(SYSDATE)	Document date
dt_D_TIME	IN	SD_DOCUMENTS.D_TIME%TYPE	DATE	NULL	Document date and time
vch_VC_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Document number
vch_VC_REM	IN	SD_DOCUMENTS.VC_REM%TYPE	VARCHAR2	NULL	Remark
dt_D_BEGIN	IN	SD_DOCUMENTS.D_BEGIN%TYPE	DATE	NULL	Start date
dt_D_END	IN	SD_DOCUMENTS.D_END%TYPE	DATE	NULL	End date
num_N_WORKFLOW_ID	IN	SD_DOCUMENTS.N_WORKFLOW_ID%TYPE	NUMBER	NULL	Workflow
num_N_SUBDOC_WORKFLOW_ID	IN	SD_CONTRACTS.N_SUBDOC_WORKFLOW_ID%TYPE	NUMBER	NULL	Workflow for subdocuments
num_N_INVOICING_SCHEME_ID	IN	SD_CONTRACTS.N_INVOICING_SCHEME_ID%TYPE	NUMBER	NULL	Invoicing scheme
num_N_FIRM_ID	IN	SD_DOCUMENTS.N_FIRM_ID%TYPE	NUMBER	SYS_CONTEXT('MAIN' 'N_FIRM_ID')	Division
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()
num_N_TIME_INTERVALS_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER	NULL	Time intervals specification
b_RefreshMViews	IN	CONST.BOOL	NUMBER	CONST.b_TRUE

PROCEDURE SD_CONTRACTS_DEL

Delete subscriber contract / contract attachment / additional agreement when document is in draft state.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Document

SD_DOCUMENTS_PKG_S

Retrieving data on documents and their custom fields.

FUNCTION GET_ADDR_VALUE_BY_ROLE

Get a record for a binding between an address and a document.

Argument	Direction	Reference type	Type	Default value	Description
RETURN SI_DOC_ADDRESSES%ROWTYPE	Binding record

FUNCTION GET_ADDR_BY_ROLE

Get an address by a role in a document.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SI_DOC_SUBJECTS.N_DOC_ID%TYPE	NUMBER		Document
num_N_DOC_ROLE_ID	IN	SI_DOC_SUBJECTS.N_DOC_ROLE_ID%TYPE	NUMBER		Address role (REF_TYPE_Addr_DocRoles reference data)
ch_C_ACTIVE	IN	SI_DOC_SUBJECTS.C_ACTIVE%TYPE	CHAR	'Y'	'Y' when searching among active bindings between addresses and the document, otherwise 'N'
RETURN SI_DOC_ADDRESSES.N_ADDRESS_ID%TYPE	Address in the role

FUNCTION DOCUMENT_GOODS_HISTORY

Get a list of changes in services bound to a document.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Document
num_N_PRIMARY_KEY_VALUE	IN	NUMBER	NUMBER	NULL	Primary key value (when searching for a specific binding)
dt_D_BEGIN	IN	DATE	DATE	ADD_MONTHS(SYSDATE -3)	Start date of a search period
dt_D_END	IN	DATE	DATE	SYSDATE	End date of the search period
RETURN SS_AUDIT_PKG_S.TABLE_HISTORY_LIST_TABLE_TYPE	Table with changes in services
PIPELINED

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.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Document
b_Errors	OUT	MAIN.BOOL	NUMBER		CONST.b_TRUE when there is a gap or intersection, otherwise CONST.b_FALSE
num_N_ERR_LEVEL	IN	NUMBER	NUMBER	SS_CONSTANTS_PKG_S.ERR_LEVEL_Warning	Error level for messages to be added to TT_MESSAGE_LOGS (CONST.ERR_LEVEL_Warning or CONST.ERR_LEVEL_Error)
ch_C_CHECK_WORKFLOW	IN	CHAR	CHAR	'N'	Search only among documents with the same workflow? {} 'Y' — search only among documents with the same workflow {} 'N' — ignore workflows

SD_OVERDRAFTS_PKG_S

Service functions for credit limit management

FUNCTION GET_TOTAL_CREDIT_LIMIT

Get total credit limit amount and the closest credit limit end date.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account
dt_D_OPER	IN	DATE	DATE	UTILS2_PKG_S.GET_SYSDATE	Date
RETURN TOTAL_CREDIT_LIMIT_ROWS	Total credit limit
PIPELINED

SD_PAYMENTS_PKG

Payment documents management

PROCEDURE SD_PAYMENTS_C_DEL

Delete payment document content line.

Argument	Direction	Reference type	Type	Default value	Description
num_N_LINE_ID	IN	SD_MONEY_MOVES.N_LINE_ID%TYPE	NUMBER		Line ID
num_N_DOC_ID	IN	SD_MONEY_MOVES.N_DOC_ID%TYPE	NUMBER

PROCEDURE SD_PAYMENTS_C_PUT

Create or replace payment document content line.

Argument	Direction	Reference type	Type	Default value	Description
num_N_LINE_ID	IN/OUT	SD_MONEY_MOVES.N_LINE_ID%TYPE	NUMBER		Line ID
num_N_DOC_ID	IN	SD_MONEY_MOVES.N_DOC_ID%TYPE	NUMBER		Document
num_N_PAY_TYPE_ID	IN	SD_MONEY_MOVES.N_PAY_TYPE_ID%TYPE	NUMBER	NULL	Payment type
num_N_TAX_RATE_ID	IN	SD_MONEY_MOVES.N_TAX_RATE_ID%TYPE	NUMBER	NULL	Tax rate
num_N_CURRENCY_ID	IN	SD_MONEY_MOVES.N_CURRENCY_ID%TYPE	NUMBER	NULL	Currency
num_N_SUM_TAX	IN	SD_MONEY_MOVES.N_SUM_TAX%TYPE	NUMBER	NULL	Taxes
num_N_SUM_WO_TAX	IN	SD_MONEY_MOVES.N_SUM_WO_TAX%TYPE	NUMBER	NULL	Amount excluding taxes
num_N_SUM	IN	SD_MONEY_MOVES.N_SUM%TYPE	NUMBER		Amount
dt_D_OPER	IN	SD_MONEY_MOVES.D_OPER%TYPE	DATE	NULL	Date
num_N_EXCH_RATE_ID	IN	SD_MONEY_MOVES.N_EXCH_RATE_ID%TYPE	NUMBER	NULL	Exchange rate line
num_N_LINE_NO	IN	SD_MONEY_MOVES.N_LINE_NO%TYPE	NUMBER	NULL	Line number

SD_PAYMENT_REQUESTS_PKG

Managing auto top-up requests and subscriptions.

FUNCTION GET_RECOMMENDED_PAYMENT_C

Get recommended payment rows. Function does not return a row with totals.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account ID
num_N_LOOKUP_DAYS_REQ	IN	SS_PARVALUES.N_VALUE%TYPE	NUMBER	NULL	Number of days for predicting service interruption
num_N_LOOKUP_DAYS_REC	IN	SS_PARVALUES.N_VALUE%TYPE	NUMBER	NULL	Number of days for forecasting charges for the payment
b_UseCreditLimits	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Use account credit limits, that is add them to the balance and use them for forecasting
b_UseAutonomousTransaction	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Use autonomous transaction
b_IgnoreSubjState	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Ignore subject state
b_LockAccount	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Lock account
RETURN RECOMMENDED_PAYMENT_TBL	Recommended payment explained in rows

PROCEDURE SI_AUTO_TOP_UPS_PUT

Create or update auto top up subscription.

Argument	Direction	Reference type	Type	Default value	Description
num_N_AUTO_TOP_UP_ID	IN/OUT	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_ID%TYPE	NUMBER		Subscription ID
num_N_AUTO_TOP_UP_TYPE_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_TYPE_ID%TYPE	NUMBER		Subscription type (recommended payment/recurrent top up/etc)
num_N_AUTO_TOP_UP_STATE_ID	IN	SI_AUTO_TOP_UPS.N_AUTO_TOP_UP_STATE_ID%TYPE	NUMBER		Subscription state
num_N_RULE_ID	IN	SI_AUTO_TOP_UPS.N_RULE_ID%TYPE	NUMBER		Top up rule
num_N_TOP_UP_SUM	IN	SI_AUTO_TOP_UPS.N_TOP_UP_SUM%TYPE	NUMBER	NULL	Amount (for recurrent top ups)
num_N_MIN_SUM	IN	SI_AUTO_TOP_UPS.N_MIN_SUM%TYPE	NUMBER	NULL	Minimal amount
num_N_MAX_SUM	IN	SI_AUTO_TOP_UPS.N_MAX_SUM%TYPE	NUMBER	NULL	Maximal amount
num_N_MAX_SUM_MONTHLY	IN	SI_AUTO_TOP_UPS.N_MAX_SUM_MONTHLY%TYPE	NUMBER	NULL	Maximal amount per calendar month
num_N_MAX_TXNS_MONTHLY	IN	SI_AUTO_TOP_UPS.N_MAX_TXNS_MONTHLY%TYPE	NUMBER	NULL	Maximal number of trapactions per calendar month
num_N_LOW_BALANCE_LIMIT	IN	SI_AUTO_TOP_UPS.N_LOW_BALANCE_LIMIT%TYPE	NUMBER	NULL	Low-balance trigger
num_N_ACCOUNT_ID	IN	SI_AUTO_TOP_UPS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_INITIAL_PAYMENT_ID	IN	SI_AUTO_TOP_UPS.N_INITIAL_PAYMENT_ID%TYPE	NUMBER		Initial subscription payment (usually card verification payment)
dt_D_TERMS_ACCEPTED	IN	SI_AUTO_TOP_UPS.D_TERMS_ACCEPTED%TYPE	DATE		When customer has accepted terms of service
vch_VC_TOKEN	IN	SI_AUTO_TOP_UPS.VC_TOKEN%TYPE	VARCHAR2	NULL	Recurrent payment token
vch_VC_CARD_TYPE	IN	SI_AUTO_TOP_UPS.VC_CARD_TYPE%TYPE	VARCHAR2	NULL	Card type
vch_VC_TRUNCATED_PAN	IN	SI_AUTO_TOP_UPS.VC_TRUNCATED_PAN%TYPE	VARCHAR2	NULL	Truncated PAN
dt_D_VALID_UNTIL	IN	SI_AUTO_TOP_UPS.D_VALID_UNTIL%TYPE	DATE	NULL	Subscription expiration date
vch_VC_EMAIL	IN	SI_AUTO_TOP_UPS.VC_EMAIL%TYPE	VARCHAR2	NULL	Payer e-mail
vch_VC_PHONE	IN	SI_AUTO_TOP_UPS.VC_PHONE%TYPE	VARCHAR2	NULL	Payer phone
vch_VC_CARDHOLDER_NAME	IN	SI_AUTO_TOP_UPS.VC_CARDHOLDER_NAME%TYPE	VARCHAR2	NULL	Cardholder name
num_N_CHARGING_DAY	IN	SI_AUTO_TOP_UPS.N_CHARGING_DAY%TYPE	NUMBER	NULL	Day of month

PROCEDURE CREATE_PAYMENT_REQUESTS

Create payment requests for firm.

Argument	Direction	Reference type	Type	Default value	Description
num_N_FIRM_ID	IN	SD_PAYMENT_REQUEST_RULES.N_FIRM_ID%TYPE	NUMBER		Firm
dt_D_OPER	IN	DATE	DATE	SYSDATE	Operation date
b_Commit	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Make commit every iteration
dt_D_LAST_SUCCESSFUL_START	IN	DATE	DATE	NULL	Last successful start

FUNCTION FILL_RECOMMENDED_PAYMENT_TT

Fill recommended payment temporary tables.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account ID
num_N_LOOKUP_DAYS_REQ	IN	SS_PARVALUES.N_VALUE%TYPE	NUMBER	NULL	Number of days for predicting service interruption
num_N_LOOKUP_DAYS_REC	IN	SS_PARVALUES.N_VALUE%TYPE	NUMBER	NULL	Number of days for forecasting charges for the payment
b_UseCreditLimits	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Use account credit limits, that is add them to the balance and use them for forecasting
b_IgnoreSubjState	IN	CONST.BOOL	NUMBER	CONST.b_FALSE
b_LockAccount	IN	CONST.BOOL	NUMBER	CONST.b_TRUE
RETURN TT_ACCOUNTS_FOR_PAY_REQUESTS.N_BATCH_NO%TYPE	Batch operation number

FUNCTION CREATE_PAYMENT_REQUEST

Create and fill payment request

Argument	Direction	Reference type	Type	Default value	Description
tbl_Content	IN	SD_PAYMENT_REQUESTS_PKG_S.PAYMENT_REQUEST_CONTENT	TABLE		Payment request content
RETURN SD_PAYMENT_REQUESTS_T.N_DOC_ID%TYPE	Document number

PROCEDURE FIND_RECOMMENDED_PAYMENT

Fill temporary table for top up requests.

Argument	Direction	Reference type	Type	Default value	Description
num_N_BATCH_NO	IN	TT_ACCOUNTS_FOR_PAY_REQUESTS.N_BATCH_NO%TYPE	NUMBER		Batch number
b_UseCreditLimits	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Use credit limits
b_IgnoreSubjState	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Ignore subjects state
b_ReturnDisabledSubscrs	IN	CONST.BOOL	NUMBER	CONST.b_FALSE	Fill rows for subscriptions with disabled charge log creating

SD_REQUESTS_PKG

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

PROCEDURE SD_REQUESTS_COPY

Копирование документа.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID_Old	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Старый документ
num_N_DOC_ID_New	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Новый документ
b_Storno	IN	MAIN.BOOL	NUMBER	MAIN.b_FALSE	Признак сторнирования

PROCEDURE SD_REQUESTS_EQUIP_DEL

Удаление записи об оборудовании.

Argument	Direction	Reference type	Type	Default value	Description
num_N_EQUIP_LINE_ID	IN	SD_REQUESTS_EQUIP.N_EQUIP_LINE_ID%TYPE	NUMBER		Строка таблицы с оборудованием в заявке

PROCEDURE SD_REQUESTS_GOODS_DEL

Удаление записи об услуге.

Argument	Direction	Reference type	Type	Default value	Description
num_N_GOOD_LINE_ID	IN	SD_REQUESTS_GOODS.N_GOOD_LINE_ID%TYPE	NUMBER		Строка таблицы услуг в заявке

PROCEDURE SD_REQUESTS_GOODS_PUT

Добавление или изменение записи об услуге, которая будет оказана абоненту.

Argument	Direction	Reference type	Type	Default value	Description
num_N_GOOD_LINE_ID	IN/OUT	SD_REQUESTS_GOODS.N_GOOD_LINE_ID%TYPE	NUMBER		Строка таблицы услуг в заявке
num_N_DOC_ID	IN	SD_REQUESTS_GOODS.N_DOC_ID%TYPE	NUMBER		Заявка
num_N_GOOD_ID	IN	SD_REQUESTS_GOODS.N_GOOD_ID%TYPE	NUMBER		Услуга
num_N_EQUIP_LINE_ID	IN	SD_REQUESTS_GOODS.N_EQUIP_LINE_ID%TYPE	NUMBER	NULL	Строка таблицы оборудования в заявке
num_N_GOOD_LINE_TYPE_ID	IN	SD_REQUESTS_GOODS.N_GOOD_LINE_TYPE_ID%TYPE	NUMBER		Тип оказания услуги (справочник REF_TYPE_Rendering_Type)
num_N_PAR_GOOD_LINE_ID	IN	SD_REQUESTS_GOODS.N_PAR_GOOD_LINE_ID%TYPE	NUMBER	NULL	Родительская строка
num_N_PAY_DAY	IN	SD_REQUESTS_GOODS.N_PAY_DAY%TYPE	NUMBER	NULL	Расчетный день
num_N_QUANT	IN	SD_REQUESTS_GOODS.N_QUANT%TYPE	NUMBER	NULL	Количество
num_N_UNIT_ID	IN	SD_REQUESTS_GOODS.N_UNIT_ID%TYPE	NUMBER	NULL	Единица измерения
dt_D_BEGIN	IN	SD_REQUESTS_GOODS.D_BEGIN%TYPE	DATE	NULL	Дата начала
dt_D_END	IN	SD_REQUESTS_GOODS.D_END%TYPE	DATE	NULL	Дата окончания
num_N_LINE_NO	IN	SD_REQUESTS_GOODS.N_LINE_NO%TYPE	NUMBER	NULL	Номер строки
num_N_PRICE	IN	SD_REQUESTS_GOODS.N_PRICE%TYPE	NUMBER	NULL	Цена
num_N_TAX_RATE_ID	IN	SD_REQUESTS_GOODS.N_TAX_RATE_ID%TYPE	NUMBER	NULL	Ставка налога
num_N_CURRENCY_ID	IN	SD_REQUESTS_GOODS.N_CURRENCY_ID%TYPE	NUMBER	NULL	Валюта
vch_VC_REM	IN	SD_REQUESTS_GOODS.VC_REM%TYPE	VARCHAR2	NULL	Комментарий

PROCEDURE SD_REQUESTS_EQUIP_PUT

Добавление или изменение записи об оборудовании.

Argument	Direction	Reference type	Type	Default value	Description
num_N_EQUIP_LINE_ID	IN/OUT	SD_REQUESTS_EQUIP.N_EQUIP_LINE_ID%TYPE	NUMBER		Строка таблицы с оборудованием в заявке
num_N_DOC_ID	IN	SD_REQUESTS_EQUIP.N_DOC_ID%TYPE	NUMBER		Заявка
num_N_GOOD_ID	IN	SD_REQUESTS_EQUIP.N_GOOD_ID%TYPE	NUMBER	NULL	Позиция номенклатуры
num_N_OBJECT_ID	IN	SD_REQUESTS_EQUIP.N_OBJECT_ID%TYPE	NUMBER	NULL	Объект учета
vch_VC_CODE	IN	SD_REQUESTS_EQUIP.VC_CODE%TYPE	VARCHAR2	NULL	Краткое наименование
vch_VC_NAME	IN	SD_REQUESTS_EQUIP.VC_NAME%TYPE	VARCHAR2	NULL	Полное наименование
num_N_PAR_EQUIP_LINE_ID	IN	SD_REQUESTS_EQUIP.N_PAR_EQUIP_LINE_ID%TYPE	NUMBER	NULL	Родительская строка
vch_VC_REM	IN	SD_REQUESTS_EQUIP.VC_REM%TYPE	VARCHAR2	NULL	Комментарий
num_N_LINE_NO	IN	SD_REQUESTS_EQUIP.N_LINE_NO%TYPE	NUMBER	NULL	Номер строки

PROCEDURE SD_REQUESTS_PUT

Добавление или изменение данных по заявке. Используется в HID.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ID	IN/OUT	SD_REQUESTS.N_DOC_ID%TYPE	NUMBER		Заявка
dt_D_DOC	IN	SD_DOCUMENTS.D_DOC%TYPE	DATE	TRUNC(SYSDATE)	Дата документа
dt_D_TIME	IN	SD_DOCUMENTS.D_TIME%TYPE	DATE	NULL	Время документа
vch_VC_DOC_NO	IN	SD_DOCUMENTS.VC_DOC_NO%TYPE	VARCHAR2	NULL	Номер документа
vch_VC_REM	IN	SD_DOCUMENTS.VC_REM%TYPE	VARCHAR2	NULL	Комментарий
dt_D_EXEC	IN	SD_REQUESTS.D_EXEC%TYPE	DATE	NULL	Первоначальная планируемая дата выполнения
dt_D_PLAN	IN	SD_REQUESTS.D_PLAN%TYPE	DATE	NULL	Текущая планируемая дата выполнения
dt_D_FACT	IN	SD_REQUESTS.D_FACT%TYPE	DATE	NULL	Фактическая дата выполнения
num_N_WORKFLOW_ID	IN	SD_DOCUMENTS.N_WORKFLOW_ID%TYPE	NUMBER	NULL	Схема документооборота
num_N_REASON_DOC_ID	IN	SD_DOCUMENTS.N_REASON_DOC_ID%TYPE	NUMBER	NULL	Документ-основание
num_N_FIRM_ID	IN	SD_DOCUMENTS.N_FIRM_ID%TYPE	NUMBER	SYS_CONTEXT('MAIN' 'N_FIRM_ID')	Фирма
tbl_T_TAGS	IN	TAGS	TABLE	TAGS()	Теги

SI_ACCOUNTS_PKG

PROCEDURE CUSTOMER_ACCOUNT_PUT

Add or change customer account record

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN/OUT	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account identifier
num_N_CUSTOMER_ID	IN	SI_SUBJ_ACCOUNTS.N_SUBJECT_ID%TYPE	NUMBER		Customer identifier
num_N_CURRENCY_ID	IN	SI_SUBJ_ACCOUNTS.N_CURRENCY_ID%TYPE	NUMBER		Currency identifier
vch_VC_NAME	IN	SI_SUBJ_ACCOUNTS.VC_NAME%TYPE	VARCHAR2	NULL	Full account name
vch_VC_CODE	IN	SI_SUBJ_ACCOUNTS.VC_CODE%TYPE	VARCHAR2	NULL	Short account name
vch_VC_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE	VARCHAR2	NULL	Account number
num_N_PERMANENT_OVERDRAFT	IN	SD_OVERDRAFTS.N_SUM%TYPE	NUMBER	NULL	Permanent credit limit amount
num_N_TEMPORAL_OVERDRAFT	IN	SD_OVERDRAFTS.N_SUM%TYPE	NUMBER	NULL	Temporary credit limit amount
dt_D_TEMP_OVERDRAFT_END	IN	SD_OVERDRAFTS.D_END%TYPE	DATE	NULL	Temporary credit limit end date
num_N_MAX_OVERDRAFT	IN	SI_SUBJ_ACCOUNTS.N_MAX_OVERDRAFT%TYPE	NUMBER	NULL	Maximum credit limit
vch_VC_REM	IN	SI_SUBJ_ACCOUNTS.VC_REM%TYPE	VARCHAR2	NULL	Comment
num_N_PAYMENT_MATCHING_CFG_ID	IN	SI_SUBJ_ACCOUNTS.N_PAYMENT_MATCHING_CFG_ID%TYPE	NUMBER	NULL	Payment matching config id

SI_ADDRESSES_PKG

Addresses management

PROCEDURE SI_DOC_ADDRESSES_PUT

Create or replace an address-to-document bind.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ADDRESS_ID	IN/OUT	SI_DOC_ADDRESSES.N_DOC_ADDRESS_ID%TYPE	NUMBER		Line ID
num_N_DOC_ID	IN	SI_DOC_ADDRESSES.N_DOC_ID%TYPE	NUMBER		Document
num_N_ADDRESS_ID	IN	SI_DOC_ADDRESSES.N_ADDRESS_ID%TYPE	NUMBER		Address
num_N_DOC_ROLE_ID	IN	SI_DOC_ADDRESSES.N_DOC_ROLE_ID%TYPE	NUMBER		Address role
vch_VC_NAME	IN	SI_DOC_ADDRESSES.VC_NAME%TYPE	VARCHAR2	NULL	Address name for the document
vch_VC_CODE	IN	SI_DOC_ADDRESSES.VC_CODE%TYPE	VARCHAR2	NULL	Address code for the document
num_N_LINE_NO	IN	SI_DOC_ADDRESSES.N_LINE_NO%TYPE	NUMBER	NULL	Line number

PROCEDURE SI_DOC_ADDRESSES_DEL

Delete an address-to-document bind.

Argument	Direction	Reference type	Type	Default value	Description
num_N_DOC_ADDRESS_ID	IN	SI_DOC_ADDRESSES.N_DOC_ADDRESS_ID%TYPE	NUMBER		Line ID

SI_SUBJECTS_PKG

Subjects management

PROCEDURE SI_SUBJ_SUBJECTS_PUT

Create or replace a subject-to-subject bind.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_SUBJECT_ID	IN/OUT	SI_SUBJ_SUBJECTS.N_SUBJ_SUBJECT_ID%TYPE	NUMBER		Bind ID
num_N_SUBJ_BIND_TYPE_ID	IN	SI_SUBJ_SUBJECTS.N_SUBJ_BIND_TYPE_ID%TYPE	NUMBER	NULL	Bind type
num_N_SUBJECT_ID	IN	SI_SUBJ_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER		Subject
num_N_SUBJECT_BIND_ID	IN	SI_SUBJ_SUBJECTS.N_SUBJECT_BIND_ID%TYPE	NUMBER		Bound subject
num_N_DIRECTORY_ID	IN	SI_SUBJ_SUBJECTS.N_DIRECTORY_ID%TYPE	NUMBER	NULL
num_N_EMP_POSITION_ID	IN	SI_REF.N_REF_ID%TYPE	NUMBER	NULL	Employee position
ch_C_FL_MAIN	IN	SI_SUBJ_SUBJECTS.C_FL_MAIN%TYPE	CHAR		Primary bind? [Y/N]

PROCEDURE SI_SUBJ_ACCOUNTS_PUT

Create or replace an account.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_ID	IN/OUT	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER		Account ID
num_N_SUBJECT_ID	IN	SI_SUBJ_ACCOUNTS.N_SUBJECT_ID%TYPE	NUMBER		Subject
num_N_ACCOUNT_TYPE_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_TYPE_ID%TYPE	NUMBER		Account type (REF_TYPE_Account_Type reference)
num_N_BANK_ID	IN	SI_SUBJ_ACCOUNTS.N_BANK_ID%TYPE	NUMBER	NULL	Bank (Provider)
num_N_CURRENCY_ID	IN	SI_SUBJ_ACCOUNTS.N_CURRENCY_ID%TYPE	NUMBER		Currency (REF_TYPE_Currency reference)
vch_VC_NAME	IN	SI_SUBJ_ACCOUNTS.VC_NAME%TYPE	VARCHAR2	NULL	Name
vch_VC_CODE	IN	SI_SUBJ_ACCOUNTS.VC_CODE%TYPE	VARCHAR2	NULL	Code
vch_VC_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE	VARCHAR2		Number
dt_D_OPEN	IN	SI_SUBJ_ACCOUNTS.D_OPEN%TYPE	DATE	NULL	Opening date
dt_D_CLOSE	IN	SI_SUBJ_ACCOUNTS.D_CLOSE%TYPE	DATE	NULL	Closing date
vch_VC_BANK	IN	SI_SUBJ_ACCOUNTS.VC_BANK%TYPE	VARCHAR2	NULL	Full name of a bank
num_N_MAX_OVERDRAFT	IN	SI_SUBJ_ACCOUNTS.N_MAX_OVERDRAFT%TYPE	NUMBER	NULL	Maximum amount of credit limits
vch_VC_REM	IN	SI_SUBJ_ACCOUNTS.VC_REM%TYPE	VARCHAR2	NULL	Remark
num_N_PAYMENT_MATCHING_CFG_ID	IN	SI_SUBJ_ACCOUNTS.N_PAYMENT_MATCHING_CFG_ID%TYPE	NUMBER	NULL	Payment matching config id

PROCEDURE SI_SUBJ_SERVICES_PUT

Create or replace a network service subscription or an equipment management record.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_SERV_ID	IN/OUT	SI_SUBJ_SERVICES.N_SUBJ_SERV_ID%TYPE	NUMBER		Network service subscription ID
num_N_SUBJ_SERV_TYPE_ID	IN	SI_SUBJ_SERVICES.N_SUBJ_SERV_TYPE_ID%TYPE	NUMBER		Network service subscription type
num_N_SUBJECT_ID	IN	SI_SUBJ_SERVICES.N_SUBJECT_ID%TYPE	NUMBER		Subject
num_N_SERVICE_ID	IN	SI_SUBJ_SERVICES.N_SERVICE_ID%TYPE	NUMBER		Network service
num_N_OBJECT_ID	IN	SI_SUBJ_SERVICES.N_OBJECT_ID%TYPE	NUMBER	NULL	Object
num_N_AUTH_TYPE_ID	IN	SI_SUBJ_SERVICES.N_AUTH_TYPE_ID%TYPE	NUMBER		Authentication type
num_N_DIRECTORY_ID	IN	SI_SUBJ_SERVICES.N_DIRECTORY_ID%TYPE	NUMBER	NULL
num_N_OBJ_ADDRESS_ID	IN	SI_SUBJ_SERVICES.N_OBJ_ADDRESS_ID%TYPE	NUMBER	NULL	Address of a management interface
num_N_PORT_NO	IN	SI_SUBJ_SERVICES.N_PORT_NO%TYPE	NUMBER	NULL	Port number
vch_VC_LOGIN	IN	SI_SUBJ_SERVICES.VC_LOGIN%TYPE	VARCHAR2	NULL	Login
vch_VC_VALUE	IN	SI_SUBJ_SERVICES.VC_VALUE%TYPE	VARCHAR2	NULL	String value
num_N_VALUE	IN	SI_SUBJ_SERVICES.N_VALUE%TYPE	NUMBER	NULL	Numeric value
num_N_LOCALE_ID	IN	SI_SUBJ_SERVICES.N_LOCALE_ID%TYPE	NUMBER	NULL	Locale
num_N_SCN	IN	SI_SUBJ_SERVICES.N_SCN%TYPE	NUMBER	NULL	Version
vch_VC_EXT_ID	IN	SI_SUBJ_SERVICES.VC_EXT_ID%TYPE	VARCHAR2	NULL	User identifier from an external identity provider

SI_SUBJECTS_PKG_S

Subjects management

FUNCTION GET_RANDOM_SUBJECT_ID

DEPRECATED in v5.1! Get random subject with specified parameters.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBJ_TYPE_ID	IN	SI_SUBJECTS.N_SUBJ_TYPE_ID%TYPE	NUMBER	CONST.SUBJ_TYPE_User	Subject type
num_N_GROUP_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER	NULL	Group
vch_VC_LOGIN_REGEXP	IN	VARCHAR2	VARCHAR2	NULL	Regexp for a subject code
RETURN SI_SUBJECTS.N_SUBJECT_ID%TYPE	Random subject

FUNCTION IS_EXIST_ACCOUNT_NO

Check if an account with a specified number exists.

Argument	Direction	Reference type	Type	Default value	Description
num_N_ACCOUNT_EXCLUDE_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_ID%TYPE	NUMBER	NULL	Account to ignore
vch_VC_ACCOUNT	IN	SI_SUBJ_ACCOUNTS.VC_ACCOUNT%TYPE	VARCHAR2		Account number
num_N_ACCOUNT_TYPE_ID	IN	SI_SUBJ_ACCOUNTS.N_ACCOUNT_TYPE_ID%TYPE	NUMBER	NULL	Account type
num_N_BANK_ID	IN	SI_SUBJ_ACCOUNTS.N_BANK_ID%TYPE	NUMBER	NULL	Bank
num_N_FIRM_ID	IN	SI_SUBJECTS.N_FIRM_ID%TYPE	NUMBER	MAIN.GET_N_FIRM_ID
RETURN SI_SUBJ_ACCOUNTS.N_SUBJECT_ID%TYPE	Subject if the account exists

SI_SUBSCRIPTIONS_PKG

Service subscriptions management

PROCEDURE SI_SUBSCRIPTIONS_PUT

Create or update a service subscription.

Argument	Direction	Reference type	Type	Default value	Description
num_N_SUBSCRIPTION_ID	IN/OUT	SI_SUBSCRIPTIONS.N_SUBSCRIPTION_ID%TYPE	NUMBER		Subscription ID
num_N_SERVICE_ID	IN	SI_SUBSCRIPTIONS.N_SERVICE_ID%TYPE	NUMBER		Service
num_N_CUSTOMER_ID	IN	SI_SUBSCRIPTIONS.N_SUBJECT_ID%TYPE	NUMBER		Customer
num_N_ACCOUNT_ID	IN	SI_SUBSCRIPTIONS.N_ACCOUNT_ID%TYPE	NUMBER		Account
num_N_OBJECT_ID	IN	SI_SUBSCRIPTIONS.N_OBJECT_ID%TYPE	NUMBER	NULL	Equipment
num_N_PAY_DAY	IN	SI_SUBSCRIPTIONS.N_BILLING_DAY%TYPE	NUMBER	NULL	Pay day
num_N_LINE_NO	IN	SI_SUBSCRIPTIONS.N_LINE_NO%TYPE	NUMBER	NULL	Customer subscriptions line number
num_N_QUANT	IN	SI_SUBSCRIPTIONS.N_QUANT%TYPE	NUMBER	NULL	Quantity
num_N_UNIT_ID	IN	SI_SUBSCRIPTIONS.N_UNIT_ID%TYPE	NUMBER	NULL	Measurement unit (SI_V_UNITS)
num_N_DOC_ID	IN	SI_SUBSCRIPTIONS.N_DOC_ID%TYPE	NUMBER		Contract
num_N_PAR_SUBSCRIPTION_ID	IN	SI_SUBSCRIPTIONS.N_PAR_SUBSCRIPTION_ID%TYPE	NUMBER	NULL	Parent subscription line
dt_D_BEGIN	IN	SI_SUBSCRIPTIONS.D_BEGIN%TYPE	DATE	NULL	Subscription begin date
dt_D_END	IN	SI_SUBSCRIPTIONS.D_END%TYPE	DATE	NULL	Subscription end date
dt_D_CHARGE_LOG_END	IN	SI_SUBSCRIPTIONS.D_CHARGE_LOG_END%TYPE	DATE	NULL	Next charge log end date
num_N_PREV_SUBSCRIPTION_ID	IN	SI_SUBSCRIPTIONS.N_PREV_SUBSCRIPTION_ID%TYPE	NUMBER	NULL	Previous subscription
num_N_CL_CREATING_STATE_ID	IN	SI_SUBSCRIPTIONS.N_CL_CREATING_STATE_ID%TYPE	NUMBER	CONST.CL_Creating_Allowed	State of creating charge logs
num_N_SERVICE_STATE_ID	IN	SI_SUBSCRIPTIONS.N_SERVICE_STATE_ID%TYPE	NUMBER	NULL	Service state
num_N_INVOICING_SCHEME_ID	IN	SI_SUBSCRIPTIONS.N_INVOICING_SCHEME_ID%TYPE	NUMBER	NULL	Invoicing scheme
b_EvaluateDiscounts	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Analyze and provide discounts?
b_FilterByContext	IN	CONST.BOOL	NUMBER	NULL	Use current user from context to restrict available services? By default: yes if context is not empty (N_USER_ID is not null)
b_RecreateOnUpdate	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Recreate subscription instead update?
b_UseMaterializedView	IN	CONST.BOOL	NUMBER	CONST.b_TRUE	Use materialized view?

SI_SUBSCRIPTIONS_PKG_S

Service subscriptions management

FUNCTION GET_AVAILABLE_SERVICES_FOR_CONTRACT

Get available services for base contract.

Argument	Direction	Reference type	Type	Default value	Description
num_N_CONTRACT_ID	IN	SD_DOCUMENTS.N_DOC_ID%TYPE	NUMBER		Base Contract
num_N_CURRENCY_ID	IN	SD_PRICE_ORDERS_C.N_CURRENCY_ID%TYPE	NUMBER		Currency
num_N_GOOD_ID	IN	SR_GOODS.N_GOOD_ID%TYPE	NUMBER	NULL	Catalog entry
dt_D_OPER	IN	DATE	DATE	UTILS2_PKG_S.GET_SYSDATE	Operation date
b_FilterByContext	IN	CONST.BOOL	NUMBER	NULL
b_ObtainContractTerms	IN	CONST.BOOL	NUMBER	NULL
b_Mview	IN	CONST.BOOL	NUMBER	NULL	Use materialized view to access contracts hierarchy?
RETURN AVAILABLE_SERVICES_TBL	Available service
PIPELINED

SI_USERS_PKG

Customers management.

PROCEDURE FIND_OR_CREATE_SSO_USER

SI_USERS_PKG_S

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

FUNCTION GET_RECOMMENDED_PAYMENT

Get a recommended payment amount.

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 GET_RECOMMENDED_PAYMENT_LIST

Get a list of recommended payments.

FUNCTION GET_USER_RECOMMENDED_PAY

Get a recommended payment amount.

SR_REGIONS_PKG_S

Registry of regions management

FUNCTION GET_UPPER_REGION_CODE

Get parent region code for a region by id and type.

FUNCTION GET_CHILDREN_REGION_LIST

Get list of all child regions.

SS_AUTHENTICATION_PKG

Authentication management

FUNCTION GET_N_SESSION_ID

Returns ID of current session

PROCEDURE INIT_SSO_USER_OFFICE_SESSION

Open a session for an SSO user impersonating a HUPO customer.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_EXT_ID	IN	SI_SUBJ_SERVICES.VC_EXT_ID%TYPE	VARCHAR2		User identifier from an external identity provider
vch_VC_LOGIN	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2		Authenticated user login
num_N_SUBJ_GROUP_ID	IN	SS_SUBJ_AUTONUMS.N_SUBJ_GROUP_ID%TYPE	NUMBER		Authenticated user group
num_N_AUTH_FIRM_ID	IN	SI_SUBJECTS.N_FIRM_ID%TYPE	NUMBER
vch_VC_FIRST_NAME	IN	SI_PERSONS.VC_NAME%TYPE	VARCHAR2		Base subject first name
vch_VC_LAST_NAME	IN	SI_PERSONS.VC_SURNAME%TYPE	VARCHAR2	NULL	Base subject last name
tbl_N_ROLE_IDS	IN	NUMBER_TABLE	TABLE	NULL	List of authenticated user roles
vch_VC_IP	IN	SS_SESSION_LOGS.VC_CLIENT_IP%TYPE	VARCHAR2		Client IP
vch_VC_CLN_SESSIONID	IN	SS_SESSION_LOGS.VC_CLN_SESSIONID%TYPE	VARCHAR2		Client session ID
vch_VC_CLN_APPID	IN	SS_SESSION_LOGS.VC_CLN_APPID%TYPE	VARCHAR2
vch_VC_JTI	IN	SS_SESSION_LOGS.VC_JTI%TYPE	VARCHAR2		JWT ID
num_N_IMPERSONATE_USER_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER		Identifier of User Office user to be impersonated

PROCEDURE INIT_SSO_USER_SESSION

Open session for SSO user.

STR_UTILS_PKG_S

String functions and procedures.

FUNCTION HTML_ENTITIES_ENCODE

Convert an XML data into an escaped XML data.

FUNCTION HTML_ENTITIES_DECODE

Convert an XML data into an unescaped XML data.

UTILS_PKG_S

Utility functions and procedures

PROCEDURE HTTP_REQUEST

Perform HTTP request.

Views

AP_V_AUTO_TOP_UPS

Подписки на автоплатеж

AP_V_OFFICE_PAYS

Отчёт по движению денежных средств за день

Field	Type	Description
N_DOC_ID	NUMBER
N_DOC_TYPE_ID	NUMBER
N_DOC_STATE_ID	NUMBER
N_PARENT_DOC_ID	NUMBER
N_REASON_DOC_ID	NUMBER
VC_REASON_DOC_CODE	VARCHAR2
N_REASON_DOC_TYPE_ID	NUMBER
N_FIRM_ID	NUMBER
D_DOC	DATE
D_TIME	DATE
VC_NAME	VARCHAR2
N_CREATOR_ID	NUMBER
D_CREATED	DATE
VC_REM	VARCHAR2
N_USER_ID	NUMBER
N_USER_ACC_ID	NUMBER
N_PROVIDER_ID	NUMBER
N_PROVIDER_ACC_ID	NUMBER
N_RECEIVER_ID	NUMBER
N_RECEIVER_ACC_ID	NUMBER
N_BASE_PROVIDER_ID	NUMBER
N_BASE_PRV_SUBJ_TYPE_ID	NUMBER
N_BASE_RECEIVER_ID	NUMBER
N_BASE_REC_SUBJ_TYPE_ID	NUMBER
N_MOVE_TYPE_ID	NUMBER
N_PAY_TYPE_ID	NUMBER
N_TAX_RATE_ID	NUMBER
N_CURRENCY_ID	NUMBER
N_SUM	NUMBER
N_SUM_TAX	NUMBER
N_SUM_WO_TAX	NUMBER
N_REASON_SUM	NUMBER
N_REASON_SUM_TAX	NUMBER
N_REASON_SUM_WO_TAX	NUMBER
D_OPER	DATE
N_LINE_ID	NUMBER

RG_V_SERV_STATUS

Представление регистра состояний услуг

Field	Type	Description
N_LINE_ID	NUMBER	Идентификатор записи
N_DOC_ID	NUMBER	Идент. документа
VC_DOC_NO	VARCHAR2	Номер документа
VC_DOC_CODE	VARCHAR2	Краткое наименование документа
N_SERVICE_ID	NUMBER	Идент. услуги
VC_SERVICE_CODE	VARCHAR2	Краткое наименование услуги
VC_SERVICE_NAME	VARCHAR2	Полное наименование услуги
N_PARENT_SERVICE_ID	NUMBER	Идент. вышестоящей услуги
N_ACCOUNT_ID	NUMBER	Идентификатор счёта клиента
VC_ACCOUNT	VARCHAR2	Код счёта
N_OBJECT_ID	NUMBER	Идент. объекта
VC_OBJ_CODE	VARCHAR2	Краткое наименование объекта
N_SUBSCRIPTION_ID	NUMBER	Ссылка на строку подписки
N_SUBJ_GOOD_ID	NUMBER	Ссылка на строку подписки
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
D_EXPIRATION	DATE	Дата следующей актуализации
D_NEXT_EXPIRATION	DATE	Дата послеследующей актуализации
N_CONTRACT_ID	NUMBER	Договор
N_SERVICE_STATE_ID	NUMBER	Состояние услуги
VC_SERVICE_STATE_CODE	VARCHAR2	Код состояния услуги
VC_SERVICE_STATE_NAME	VARCHAR2	Наименование состояния услуги
N_NEXT_SERVICE_STATE_ID	NUMBER	Следующее состояние услуги
VC_NEXT_SERVICE_STATE_CODE	VARCHAR2	Код следующего состояния услуги
VC_NEXT_SERVICE_STATE_NAME	VARCHAR2	Наименование следующего состояния услуги
D_OPER	DATE	Дата расчета
N_PAR_LINE_ID	NUMBER	Ссылка на основную строку регистра
N_QUANT	NUMBER	Количество
N_UNIT_ID	NUMBER	Единица измерения
N_LAST_DOC_ID	NUMBER	Последний акт начислений по услуге
N_SUSPENSION_LINE_ID	NUMBER	Услуга блокировки
N_PRICE_LINE_ID	NUMBER	Строка ПЦ
N_TIME_INTERVAL_ID	NUMBER	Временной интервал
N_TIME_INTERVAL_DOC_ID	NUMBER	Приказ по временным интервалам

RPT_V_CDR

CDR rating report

Field	Type	Description
N_CDR_ID	NUMBER	ID
VC_EXT_ID	VARCHAR2	External ID
N_RATING_TYPE_ID	NUMBER	Rating type
N_SERVICE_ID	NUMBER	Service
N_DIRECTION_ID	VARCHAR2	Direction
N_CDR_STATE_ID	NUMBER	CDR state
N_CDR_ACC_STATE_ID	NUMBER	Rating status
N_FAIL_REASON_ID	NUMBER	Reason for unsuccessful rating
N_USER_ID	NUMBER	Customer
D_BEGIN	DATE	Call start date
D_END	DATE	Call termination date
D_BEGIN_ACC	DATE	Rating date
N_DURATION_SEC	NUMBER	Call duration, s
N_CALL_TIME_LIMIT_SEC	NUMBER	Call limit
VC_TERMINATION_CAUSE	VARCHAR2	Termination cause
N_ACCOUNT_ID	NUMBER	Account
N_PROVIDER_A_ID	NUMBER	Provider A
N_EQUIP_A_ID	NUMBER	Equip A
N_OBJECT_ID	NUMBER
N_ADDRESS_A_ID	NUMBER	Area A
VC_ADDRESS_A_CODE	VARCHAR2	Area A code
N_PROV_ADDR_A_ID	NUMBER	Provider address A
VC_STATION_A	VARCHAR2	Address A
VC_ROUTE_A	VARCHAR2	Route from A
N_PROVIDER_B_ID	NUMBER	Provider B
N_EQUIP_B_ID	NUMBER	Equip B
N_ADDRESS_B_ID	NUMBER	Area B
VC_ADDRESS_B_CODE	VARCHAR2	Area B code
N_PROV_ADDR_B_ID	NUMBER	Provider address B
VC_STATION_B	VARCHAR2	Address B
VC_ROUTE_B	VARCHAR2	Route from B
N_AMOUNT	NUMBER	Amount
N_AMOUNT_WO_TAX	NUMBER	Amount excl. taxes
N_CURRENCY_ID	NUMBER	Currency
N_QUANT	NUMBER	Qty.
N_QUANT_BASE	NUMBER	Duration in basic units
N_UNIT_ID	NUMBER	Unit
N_TEL_ADDR_A_ID	NUMBER	Call prefix A(address)
N_TEL_ADDR_B_ID	NUMBER	Call prefix B(address)
VC_REM	VARCHAR2	Comment
D_LOG_CREATE	TIMESTAMP(6)	Created
VC_EXT_UNIQ_ID	VARCHAR2	Unique external ID
T_ATTRIBUTES	KEY_VALUE_TABLE	Attributes
N_CHARGE_LOG_ID	NUMBER	Charge log
N_TEL_CODE_A_ID	NUMBER	Call prefix A
N_TEL_CODE_B_ID	NUMBER	Call prefix B
N_CONTRACT_ID	NUMBER	Contract
N_BASE_USER_ID	NUMBER	Basic subject
N_PRICE	NUMBER	Price
N_PRICE_WO_TAX	NUMBER	Price excl. taxes
VC_FAIL_REASON	VARCHAR2	Reason for unsuccessful rating

RPT_V_CDR_ARCH

CDR rating report with archived data

Field	Type	Description
N_CDR_ID	NUMBER	ID
VC_EXT_ID	VARCHAR2	External ID
N_RATING_TYPE_ID	NUMBER	Rating type
N_SERVICE_ID	NUMBER	Service
N_DIRECTION_ID	VARCHAR2	Direction
N_CDR_STATE_ID	NUMBER	CDR state
N_CDR_ACC_STATE_ID	NUMBER	Rating status
N_FAIL_REASON_ID	NUMBER	Reason for unsuccessful rating
N_USER_ID	NUMBER	Customer
D_BEGIN	DATE	Call start date
D_END	DATE	Call termination date
D_BEGIN_ACC	DATE	Rating date
N_DURATION_SEC	NUMBER	Call duration, s
N_CALL_TIME_LIMIT_SEC	NUMBER	Call limit
VC_TERMINATION_CAUSE	VARCHAR2	Termination cause
N_ACCOUNT_ID	NUMBER	Account
N_PROVIDER_A_ID	NUMBER	Provider A
N_EQUIP_A_ID	NUMBER	Equip A
N_OBJECT_ID	NUMBER
N_ADDRESS_A_ID	NUMBER	Area A
VC_ADDRESS_A_CODE	VARCHAR2	Area A code
N_PROV_ADDR_A_ID	NUMBER	Provider address A
VC_STATION_A	VARCHAR2	Address A
VC_ROUTE_A	VARCHAR2	Route from A
N_PROVIDER_B_ID	NUMBER	Provider B
N_EQUIP_B_ID	NUMBER	Equip B
N_ADDRESS_B_ID	NUMBER	Area B
VC_ADDRESS_B_CODE	VARCHAR2	Area B code
N_PROV_ADDR_B_ID	NUMBER	Provider address B
VC_STATION_B	VARCHAR2	Address B
VC_ROUTE_B	VARCHAR2	Route from B
N_AMOUNT	NUMBER	Amount
N_AMOUNT_WO_TAX	NUMBER	Amount excl. taxes
N_CURRENCY_ID	NUMBER	Currency
N_QUANT	NUMBER	Qty.
N_QUANT_BASE	NUMBER	Duration in basic units
N_UNIT_ID	NUMBER	Unit
N_TEL_ADDR_A_ID	NUMBER	Call prefix A(address)
N_TEL_ADDR_B_ID	NUMBER	Call prefix B(address)
VC_REM	VARCHAR2	Comment
D_LOG_CREATE	TIMESTAMP(6)	Created
VC_EXT_UNIQ_ID	VARCHAR2	Unique external ID
T_ATTRIBUTES	KEY_VALUE_TABLE
N_CHARGE_LOG_ID	NUMBER	Charge log
N_TEL_CODE_A_ID	NUMBER	Call prefix A
N_TEL_CODE_B_ID	NUMBER	Call prefix B
N_CONTRACT_ID	NUMBER	Contract
N_BASE_USER_ID	NUMBER	Basic subject
N_PRICE	NUMBER	Price
N_PRICE_WO_TAX	NUMBER	Price excl. taxes
VC_FAIL_REASON	VARCHAR2	Reason for unsuccessful rating

RPT_V_PAY_DOCS

Отчёт по платежам

Field	Type	Description
N_DOC_ID	NUMBER
N_DOC_TYPE_ID	NUMBER
N_DOC_STATE_ID	NUMBER
N_PARENT_DOC_ID	NUMBER
N_REASON_DOC_ID	NUMBER
VC_REASON_DOC_CODE	VARCHAR2
N_REASON_DOC_TYPE_ID	NUMBER
N_FIRM_ID	NUMBER
D_DOC	DATE
D_TIME	DATE
VC_NAME	VARCHAR2
N_CREATOR_ID	NUMBER
D_CREATED	DATE
VC_REM	VARCHAR2
N_USER_ID	NUMBER
N_USER_ACC_ID	NUMBER
T_CUSTOMER_TAGS	TAGS
N_PROVIDER_ID	NUMBER
N_PROVIDER_ACC_ID	NUMBER
N_RECEIVER_ID	NUMBER
N_RECEIVER_ACC_ID	NUMBER
N_RECEIVER_RESELLER_ID	NUMBER
N_BASE_PROVIDER_ID	NUMBER
N_BASE_PRV_SUBJ_TYPE_ID	NUMBER
N_BASE_RECEIVER_ID	NUMBER
N_BASE_REC_SUBJ_TYPE_ID	NUMBER
N_MOVE_TYPE_ID	NUMBER
N_PAY_TYPE_ID	NUMBER
N_PAY_TYPE_REAL_ID	NUMBER
N_PAY_TYPE_VIRT_ID	NUMBER
N_TAX_RATE_ID	NUMBER
N_CURRENCY_ID	NUMBER
N_SUM	NUMBER
N_SUM_TAX	NUMBER
N_SUM_WO_TAX	NUMBER
N_REASON_SUM	NUMBER
N_REASON_SUM_TAX	NUMBER
N_REASON_SUM_WO_TAX	NUMBER
D_OPER	DATE
D_LOAD	DATE
VC_TRANSACTION_ID	VARCHAR2
VC_TRANSACTION_NO	VARCHAR2
VC_FORWHO	VARCHAR2
VC_FORWHO_ACCOUNT	VARCHAR2
VC_DOC_NO	VARCHAR2
N_LINE_ID	NUMBER

RPT_V_USERS

Customer report

Field	Type	Description
N_USER_ID	NUMBER	Customer
T_CUSTOMER_TAGS	TAGS	Customer tags
N_BASE_SUBJECT_ID	NUMBER	Customer basic subject
T_BASE_SUBJECT_TAGS	TAGS	Basic subject tags
N_SERV_STATE_ID	NUMBER
N_FIRM_ID	NUMBER	Division
N_USER_STATE_ID	NUMBER	Customer status
VC_USER_CODE	VARCHAR2	Customer code
D_CREATED	DATE	Creation date
N_RESELLER_ID	NUMBER	Dealer
N_OBJECT_ID	NUMBER
N_DEVICE_ID	NUMBER	CPE
N_DEVICE_STATE_ID	NUMBER	CPE status
VC_DEVICE	VARCHAR2	CPE name
N_REGION_ID	NUMBER	Region
N_ADDRESS_ID	NUMBER	Service address
VC_ENTRANCE_NO	VARCHAR2	Entrance
N_FLOOR_NO	NUMBER	Floor
VC_FLAT	VARCHAR2	Apartment
VC_VISUAL_ADDRESS	VARCHAR2	Full service address
N_OBJ_ADDR_STATE_ID	NUMBER	Service address status
D_OBJ_ADDRESS_BEGIN	DATE	Start date of the service address validity period
D_OBJ_ADDRESS_END	DATE	End date of the service address validity period
N_RESID_NUMBER	NUMBER	Number of residential premises
N_NONRESID_NUMBER	NUMBER	Number of non-residential premises
N_FLOORS_NUMBER	NUMBER	Number of floors
N_SECTIONS_NUMBER	NUMBER	Number of sections
N_CONTRACT_ID	NUMBER	Contract
N_CNTR_STATE_ID	NUMBER	Contract status
N_BASE_CNTR_ID	NUMBER	Basic contract
D_CNTR_DOC	DATE	Contract date
D_CNTR_BEGIN	DATE	Contract start date
D_CNTR_END	DATE	Contract end date
VC_CONTRACT_REM	VARCHAR2	Contract remark
N_GOOD_ID	NUMBER	Service
N_GOOD_TYPE_ID	NUMBER	Product catalog section the service belongs to
N_HIGH_GOOD_GROUP_ID	NUMBER	Top group of a catalog section the service belongs to
D_FIRST_CL_BEGIN	DATE	Start date of the first charge log
D_LAST_CL_END	DATE	End date of the last charge Log
N_ACCOUNT_ID	NUMBER	Customer account
VC_ACCOUNT_CODE	VARCHAR2	Account code
VC_ACCOUNT_NAME	VARCHAR2	Account name
VC_COMMENT	VARCHAR2	Last comment

RP_V_ALL_PROFILES

Профили

Field	Type	Description
N_PROFILE_ID	NUMBER	Профиль
N_TEMPLATE_ID	NUMBER	Шаблон профиля
VC_TEMPLATE	VARCHAR2	Наименование шаблон профиля
N_TEMPLATE_TYPE_ID	NUMBER	Тип шаблона
N_PAR_TEMPLATE_ID	NUMBER	Родительский шаблон
N_FIRM_ID	NUMBER	Фирма
VC_CONTEXT	VARCHAR2	Контекст профиля
VC_PAR_CONTEXT	VARCHAR2	Контекст родительского профиля
N_SUBSCRIPTION_ID	NUMBER	Подписка на услугу
N_ACCOUNT_ID	NUMBER	Лицевой счет
VC_ACCOUNT_NAME	VARCHAR2	Наименование лицевого счета
N_SERVICE_ID	NUMBER	Услуга
VC_SERVICE_NAME	VARCHAR2	Наименование услуги
N_CONTRACT_ID	NUMBER	Договор
VC_CONTRACT_NAME	VARCHAR2	Наименование договора
N_CHARGE_LOG_ID	NUMBER	Акт начислений
VC_CHARGE_LOG_NO	VARCHAR2	Номер акта начислений
T_ATTRIBUTES	PROFILE_ATTRS	Атрибуты профиля
N_TIME_INTERVAL_ID	NUMBER	Временной интервал
N_TIME_INTERVAL_DOC_ID	NUMBER	Приказ по временным интервалам
N_SCN	NUMBER	Версия
N_CREATED_SCN	NUMBER	Версия при создании
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
TS_CREATED	TIMESTAMP(9)
C_FL_CURRENT	VARCHAR2	Флаг текущего профиля
N_CURRENT_SERVICE_STATE_ID	NUMBER	Текущее состояние услуги
VC_CURRENT_SERVICE_STATE	VARCHAR2	Наименование текущего состояния услуги
N_EQUIPMENT_ID	NUMBER	Оборудование
C_FL_VALID	CHAR	Флаг валидности профиля
T_CHILD_PROFILE_IDS	NUMBER_TABLE
C_ACTIVE	CHAR	Признак активности
TS_CREATED	TIMESTAMP(6)

RP_V_CURRENT_PROFILES

Current profiles

RP_V_PROFILES

Активные профили

Field	Type	Description
N_PROFILE_ID	NUMBER	Профиль
N_TEMPLATE_ID	NUMBER	Шаблон профиля
VC_TEMPLATE	VARCHAR2	Наименование шаблон профиля
N_TEMPLATE_TYPE_ID	NUMBER	Тип шаблона
N_PAR_TEMPLATE_ID	NUMBER	Родительский шаблон
N_FIRM_ID	NUMBER	Фирма
VC_CONTEXT	VARCHAR2	Контекст профиля
VC_PAR_CONTEXT	VARCHAR2	Контекст родительского профиля
N_SUBSCRIPTION_ID	NUMBER	Подписка на услугу
N_ACCOUNT_ID	NUMBER	Лицевой счет
VC_ACCOUNT_NAME	VARCHAR2	Наименование лицевого счета
N_SERVICE_ID	NUMBER	Услуга
VC_SERVICE_NAME	VARCHAR2	Наименование услуги
N_CONTRACT_ID	NUMBER	Договор
VC_CONTRACT_NAME	VARCHAR2	Наименование договора
N_CHARGE_LOG_ID	NUMBER	Акт начислений
VC_CHARGE_LOG_NO	VARCHAR2	Номер акта начислений
T_ATTRIBUTES	PROFILE_ATTRS	Атрибуты профиля
N_TIME_INTERVAL_ID	NUMBER	Временной интервал
N_TIME_INTERVAL_DOC_ID	NUMBER	Приказ по временным интервалам
N_SCN	NUMBER	Версия
N_CREATED_SCN	NUMBER	Версия при создании
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
TS_CREATED	TIMESTAMP(9)
C_FL_CURRENT	VARCHAR2	Флаг текущего профиля
N_CURRENT_SERVICE_STATE_ID	NUMBER	Текущее состояние услуги
VC_CURRENT_SERVICE_STATE	VARCHAR2	Наименование текущего состояния услуги
N_EQUIPMENT_ID	NUMBER	Оборудование
C_FL_VALID	CHAR	Флаг валидности профиля
T_CHILD_PROFILE_IDS	NUMBER_TABLE
TS_CREATED	TIMESTAMP(6)

SD_V_CHARGE_LOGS_JR

Журнал актов начислений

Field	Type	Description
N_DOC_ID	NUMBER	Идентификатор акта начислений
N_DOC_TYPE_ID	NUMBER	Тип документа
VC_DOC_TYPE_NAME	VARCHAR2	Наименование типа документа
N_DOC_STATE_ID	NUMBER	Состояние документа
VC_DOC_STATE_NAME	VARCHAR2	Наименование состояния
N_PARENT_DOC_ID	NUMBER	Родительский документ
VC_PARENT_DOC	VARCHAR2	Наименование родительского документа
N_REASON_DOC_ID	NUMBER	Документ-основание
VC_REASON_DOC	VARCHAR2	Наименование документа-основания
N_PREV_DOC_ID	NUMBER	Предыдущий документ при копировании
VC_PREV_DOC	VARCHAR2	Наименование предыдущего документа при копировании
N_STORNO_DOC_ID	NUMBER	Сторнируемый документ
VC_STORNO_DOC	VARCHAR2	Наименование сторнируемого документа
N_WORKFLOW_ID	NUMBER	Схема документооборота
VC_WORKFLOW_NAME	VARCHAR2	Наименование схемы документооборота
D_DOC	DATE	Дата документа
D_TIME	DATE	Время документа
VC_DOC_NO	VARCHAR2	Номер документа
VC_NAME	VARCHAR2	Наименование
VC_CODE	VARCHAR2	Краткое наименование
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
N_CREATOR_ID	NUMBER	Создатель
D_CREATED	DATE	Дата создания
VC_CREATOR_NAME	VARCHAR2	Наименование СУ создателя
VC_CREATOR_CODE	VARCHAR2	Код СУ создателя
N_SUM	NUMBER	Сумма
N_WRITEOFF_SUM	NUMBER	Сумма за начисленные услуги
N_ADD_SERVS_SUM	NUMBER
N_CURRENCY_ID	NUMBER	Валюта
VC_CURRENCY	VARCHAR2	Наименование валюты
N_FIRM_ID	NUMBER	Фирма-владелец
VC_FIRM	VARCHAR2	Наименование фирмы-владельца
VC_REM	VARCHAR2	Примечание
T_TAGS	TAGS	Теги
VC_TAGS	VARCHAR2	Теги
C_FL_ARCHIVED	CHAR	Флаг архивного документа
N_PRICE_ORDER_ID	NUMBER	Идентификатор приказа по ценам

SD_V_CONTRACTS

Заголовок договоров на оказание услуг и базовых договоров

Field	Type	Description
N_DOC_ID	NUMBER	Документ
N_DOC_TYPE_ID	NUMBER	Тип документа
VC_DOC_TYPE_NAME	VARCHAR2	Наименование типа документа
N_DOC_STATE_ID	NUMBER	Состояние документа
VC_DOC_STATE_NAME	VARCHAR2	Наименование состояния документа
N_PARENT_DOC_ID	NUMBER	Родительский документ
VC_PARENT_DOC	VARCHAR2	Наименование родительского документа
N_REASON_DOC_ID	NUMBER	Документ-основание
N_PREV_DOC_ID	NUMBER	Предыдущий документ при копировании
VC_PREV_DOC	VARCHAR2	Наименование предыдущего документа при копировании
N_STORNO_DOC_ID	NUMBER	Сторнируемый документ
VC_STORNO_DOC	VARCHAR2	Наименование сторнируемого документа
N_WORKFLOW_ID	NUMBER	Схема документооборота
VC_WORKFLOW_NAME	VARCHAR2	Наименование схемы документооборота
N_SUBDOC_WORKFLOW_ID	NUMBER	Схема выставления счетов
N_INVOICING_SCHEME_ID	NUMBER
VC_SUBDOC_WORKFLOW_ID	VARCHAR2	Наименование схемы документооборота дочернего документа
D_DOC	DATE	Дата документа
D_TIME	DATE	Время документа
VC_DOC_NO	VARCHAR2	Номер документа
VC_NAME	VARCHAR2	Наименование
VC_CODE	VARCHAR2	Краткое наименование
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
N_CREATOR_ID	NUMBER	Идентификатор создателя
D_CREATED	DATE	Дата создания
VC_CREATOR_NAME	VARCHAR2	Наименование СУ создателя
VC_CREATOR_CODE	VARCHAR2	Код СУ создателя
N_FIRM_ID	NUMBER	Идентификатор фирмы-владельца
VC_FIRM	VARCHAR2	Наименование фирмы-владельца
VC_REM	VARCHAR2	Примечание
D_LOG_LAST_MOD_DOC	DATE
N_LOG_SESSION_DOC_ID	NUMBER
D_LOG_LAST_MOD_CONTR	DATE
N_LOG_SESSION_CONTR_ID	NUMBER
T_TAGS	TAGS
VC_TAGS	VARCHAR2
N_TIME_INTERVALS_DOC_ID	NUMBER

SD_V_INVOICES_JR

Журнал фактур

Field	Type	Description
N_DOC_ID	NUMBER	Идентификатор документа
N_DOC_TYPE_ID	NUMBER	Идентификатор типа документа
VC_DOC_TYPE_NAME	VARCHAR2	Наименование типа документа
N_DOC_STATE_ID	NUMBER	Идентификатор состояния документа
VC_DOC_STATE_NAME	VARCHAR2	Наименование состояния документа
N_PARENT_DOC_ID	NUMBER	Идентификатор родительского документа
VC_PARENT_DOC	VARCHAR2	Наименование родительского документа
N_REASON_DOC_ID	NUMBER	Идентификатор документа-основания
VC_REASON_DOC	VARCHAR2	Наименование документа-основания
N_PREV_DOC_ID	NUMBER	Идентификатор предыдущего документа при копировании
VC_PREV_DOC	VARCHAR2	Наименование предыдущего документа при копировании
N_STORNO_DOC_ID	NUMBER	Идентификатор сторнируемого документа
VC_STORNO_DOC	VARCHAR2	Наименование сторнируемого документа
N_WORKFLOW_ID	NUMBER	Идентификатор схемы документооборота
VC_WORKFLOW_NAME	VARCHAR2	Наименование схемы документооборота
D_DOC	DATE	Дата документа
D_TIME	DATE	Время документа
VC_DOC_NO	VARCHAR2	Номер документа
VC_NAME	VARCHAR2	Наименование
VC_CODE	VARCHAR2	Краткое наименование
D_BEGIN	DATE	Дата начала
D_END	DATE	Дата окончания
N_CREATOR_ID	NUMBER	Идентификатор создателя
D_CREATED	DATE	Дата создания
VC_CREATOR_NAME	VARCHAR2	Наименование СУ создателя
VC_CREATOR_CODE	VARCHAR2	Код СУ создателя
N_FIRM_ID	NUMBER	Идентификатор фирмы-владельца
VC_FIRM	VARCHAR2	Наименование фирмы-владельца
VC_REM	VARCHAR2	Примечание
VC_TAGS	VARCHAR2	Теги
T_TAGS	TAGS	Теги
N_AMOUNT	NUMBER	Сумма
N_AMOUNT_WO_TAX	NUMBER	Сумма без налогов
N_AMOUNT_TAX	NUMBER
N_BASE_AMOUNT	NUMBER
N_BASE_AMOUNT_WO_TAX	NUMBER
N_CURRENCY_ID	NUMBER	Идентификатор валюты
VC_CURRENCY	VARCHAR2	Наименование валюты
VC_CURRENCY_CODE	VARCHAR2
N_PROVIDER_SUBJECT_ID	NUMBER	Идентификатор СУ поставщика
VC_PROVIDER_NAME	VARCHAR2	Наименование СУ поставщика
VC_PROVIDER_CODE	VARCHAR2	Код СУ поставщика
N_RECEIVER_SUBJECT_ID	NUMBER	Идентификатор СУ получателя
VC_RECEIVER_NAME	VARCHAR2	Наименование СУ получателя
VC_RECEIVER_CODE	VARCHAR2	Код СУ получателя
N_FEDERAL_REGION_ID	NUMBER	Регион основного фактического адреса получателя
N_MUNICIPAL_PAR_REGION_ID	NUMBER	Родительский муниципальный регион основного фактического адреса получателя
D_LOG_LAST_MOD	DATE
N_LOG_SESSION_ID	NUMBER

SD_V_PAYMENTS_C

Состав платежного документа

Field	Type	Description
N_LINE_ID	NUMBER	Line
N_DOC_ID	NUMBER	Payment document
N_LINE_ID	NUMBER	Line
N_MOVE_TYPE_ID	NUMBER	Movement type
N_LINE_ID	NUMBER	Line
VC_MOVE_TYPE_NAME	VARCHAR2	Movement type name
N_LINE_ID	NUMBER	Line
N_PAY_TYPE_ID	NUMBER	Payment type
N_LINE_ID	NUMBER	Line
VC_PAY_TYPE_NAME	VARCHAR2	Payment type name
N_LINE_ID	NUMBER	Line
N_TAX_RATE_ID	NUMBER	Tax rate
N_LINE_ID	NUMBER	Line
VC_TAX_RATE_NAME	VARCHAR2	Tax rate name
N_LINE_ID	NUMBER	Line
N_CURRENCY_ID	NUMBER	Currency
N_LINE_ID	NUMBER	Line
VC_CURRENCY_NAME	VARCHAR2	Currency name
N_LINE_ID	NUMBER	Line
N_SUM	NUMBER	Amount
N_LINE_ID	NUMBER	Line
N_SUM_TAX	NUMBER	Tax amount
N_LINE_ID	NUMBER	Line
N_SUM_WO_TAX	NUMBER	Amount without tax
N_LINE_ID	NUMBER	Line
N_LINE_NO	NUMBER	Line number
N_LINE_ID	NUMBER	Line
D_OPER	DATE	Operation date
N_LINE_ID	NUMBER	Line
D_LOG_LAST_MOD	DATE	Last modification date
N_LINE_ID	NUMBER	Line
N_LOG_SESSION_ID	NUMBER	Session

SD_V_PRICE_ORDERS_T

Заголовок приказов по ценам

Field	Type	Description
N_DOC_ID	NUMBER	Document
N_DOC_TYPE_ID	NUMBER	Document type
VC_DOC_TYPE_NAME	VARCHAR2	Document type name
N_DOC_STATE_ID	NUMBER	Document state
VC_DOC_STATE_NAME	VARCHAR2	Document state name
N_PARENT_DOC_ID	NUMBER	Parent document
VC_PARENT_DOC	VARCHAR2	Parent document name
N_REASON_DOC_ID	NUMBER	Base document
N_PREV_DOC_ID	NUMBER	Previous document when copying
VC_PREV_DOC	VARCHAR2	Previous document name when copying
N_STORNO_DOC_ID	NUMBER	Reversed document
VC_STORNO_DOC	VARCHAR2	Reversed document name
N_WORKFLOW_ID	NUMBER	Workflow
VC_WORKFLOW_NAME	VARCHAR2	Workflow name
D_DOC	DATE	Document date
D_TIME	DATE	Document time
VC_DOC_NO	VARCHAR2	Document number
VC_NAME	VARCHAR2	Document name
VC_CODE	VARCHAR2	Short name of document
D_BEGIN	DATE	Begin date
D_END	DATE	End date
N_CREATOR_ID	NUMBER	Creator
D_CREATED	DATE	Document creation date
VC_CREATOR_NAME	VARCHAR2	Document creator name
VC_CREATOR_CODE	VARCHAR2	Document creator code
N_FIRM_ID	NUMBER	Firm
VC_FIRM	VARCHAR2	Firm name
VC_REM	VARCHAR2	Remark
T_TAGS	TAGS	Tags
VC_TAGS	VARCHAR2
C_FL_PURCHASING_PRICE	CHAR	Flag of purchasing price order
N_TAX_RATE_ID	NUMBER	Tax rate
VC_TAX_RATE_NAME	VARCHAR2	Tax rate name
N_CURRENCY_ID	NUMBER	Currency
VC_CURRENCY_NAME	VARCHAR2	Currency name
N_SUM_ROUNDING_ID	NUMBER	Amount rounding rule
VC_SUM_ROUNDING	VARCHAR2	Amount rounding rule name
N_CALC_DESIGN_PROC_ID	NUMBER	Tax calculation rule
VC_CALC_DESIGN_PROC	VARCHAR2	Tax calculation rule name
N_QUANT_ROUNDING_ID	NUMBER	Quantity rounding rule
VC_QUANT_ROUNDING	VARCHAR2	Quantity rounding rule name
N_DEFER_TYPE_ID	NUMBER	Charge log deferment type
N_SCHED_DEFER_TYPE_ID	NUMBER	Deferment type for scheduled services
N_SCHED_DEFER_PAY_DAYS	NUMBER	Deferment for scheduled services in days
N_UNSCHED_DEFER_PAY_DAYS	NUMBER	Deferment for unscheduled services in days
N_RATING_TYPE_ID	NUMBER	Rating type
N_DOC_AUTONUM_ID	NUMBER
N_TIME_INTERVALS_DOC_ID	NUMBER

SD_V_REFUNDS

Перерасчет по актам начислений

Field	Type	Description
N_LINE_NO	NUMBER	Строка
N_SUBJECT_ID	NUMBER	Абонент
N_LINE_NO	NUMBER	Строка
VC_SUBJECT_CODE	VARCHAR2	Код абонента
N_LINE_NO	NUMBER	Строка
N_ACCOUNT_ID	NUMBER	Лицевой счет
N_LINE_NO	NUMBER	Строка
VC_ACCOUNT_NAME	VARCHAR2	Код лицевого счета
N_LINE_NO	NUMBER	Строка
N_DOC_ID	NUMBER	Акт начислений
N_LINE_NO	NUMBER	Строка
VC_DOC_CODE	VARCHAR2	Код акта начислений
N_LINE_NO	NUMBER	Строка
N_SUM	NUMBER	Сумма перерасчета
N_LINE_NO	NUMBER	Строка
N_SUM_TAX	NUMBER	Сумма налогов
N_LINE_NO	NUMBER	Строка
N_SUM_WO_TAX	NUMBER	Сумма перерасчета без налогов
N_LINE_NO	NUMBER	Строка
N_CURRENCY_ID	NUMBER	Валюта
N_LINE_NO	NUMBER	Строка
VC_CURRENCY_NAME	VARCHAR2	Наименование валюты
N_LINE_NO	NUMBER	Строка
N_SERVICE_ID	NUMBER	Услуга
N_LINE_NO	NUMBER	Строка
VC_SERVICE_CODE	VARCHAR2	Код услуги

SD_V_TIME_INTERVALS_T

Заголовок приказов по интервалам времени

Field	Type	Description
N_DOC_ID	NUMBER
N_DOC_TYPE_ID	NUMBER
VC_DOC_TYPE_NAME	VARCHAR2
N_DOC_STATE_ID	NUMBER
VC_DOC_STATE_NAME	VARCHAR2
N_PARENT_DOC_ID	NUMBER
VC_PARENT_DOC	VARCHAR2
N_REASON_DOC_ID	NUMBER
N_PREV_DOC_ID	NUMBER
VC_PREV_DOC	VARCHAR2
N_STORNO_DOC_ID	NUMBER
VC_STORNO_DOC	VARCHAR2
N_WORKFLOW_ID	NUMBER
VC_WORKFLOW_NAME	VARCHAR2
D_DOC	DATE
D_TIME	DATE
VC_DOC_NO	VARCHAR2
VC_NAME	VARCHAR2
VC_CODE	VARCHAR2
D_BEGIN	DATE
D_END	DATE
N_CREATOR_ID	NUMBER
D_CREATED	DATE
VC_CREATOR_NAME	VARCHAR2
VC_CREATOR_CODE	VARCHAR2
N_FIRM_ID	NUMBER
VC_FIRM	VARCHAR2
VC_REM	VARCHAR2
T_TAGS	TAGS
VC_TAGS	VARCHAR2
N_DOC_AUTONUM_ID	NUMBER
N_DEFAULT_TIME_INTERVAL_ID	NUMBER

SI_V_AUTO_TOP_UPS

Подписки на автоплатеж

SI_V_OBJ_VALUES

Значения дополнительных свойств объектов учета

SI_V_REF

Представление справочных величин

Field	Type	Description
N_REF_ID	NUMBER	Идентификатор записи
N_PAR_REF_ID	NUMBER	Вышестоящий элемент
N_REF_TYPE_ID	NUMBER	Тип справочной величины
N_REF_BASE_ID	NUMBER	Базовый элемент
N_FIRM_ID	NUMBER	Фирма
VC_NAME	VARCHAR2	Полное наименование
VC_CODE	VARCHAR2	Краткое наименование
VC_VALUE	VARCHAR2	Строковое значение справочной величины
VC_VALUE_2	VARCHAR2	Строковое значение справочной величины
VC_VALUE_3	VARCHAR2	Строковое значение справочной величины
VC_VALUE_4	VARCHAR2	Строковое значение справочной величины
C_VALUE	CHAR	Символьное значение справочной величины
C_VALUE_2	CHAR	Символьное значение справочной величины
C_VALUE_3	CHAR	Символьное значение справочной величины
D_VALUE	DATE	Датавременное значение справочной величины
D_VALUE_2	DATE	Датавременное значение справочной величины
D_VALUE_3	DATE	Датавременное значение справочной величины
N_VALUE	NUMBER	Числовое значение справочной величины
N_VALUE_2	NUMBER	Числовое значение справочной величины
N_VALUE_3	NUMBER	Числовое значение справочной величины
N_REF_ID_1	NUMBER	Справочное значение величины
N_REF_ID_2	NUMBER	Справочное значение величины
N_REF_ID_3	NUMBER	Справочное значение величины
D_BEGIN	DATE	Дата начала действия
D_END	DATE	Дата окончания действия
C_ACTIVE	CHAR	Признак активности
C_FL_EDITABLE	CHAR	Флаг разрешения редактирования
C_FL_MANUAL	CHAR	Признак справочника, созданного вручную
N_LANG_ID	NUMBER	Язык

SI_V_SUBJ_ACCOUNTS

Счета СУ

Field	Type	Description
N_SUBJECT_ID	NUMBER	Идентификатор СУ
VC_SUBJ_CODE	VARCHAR2	Краткое наименование СУ
VC_SUBJ_NAME	VARCHAR2	Полное наименование СУ
N_SUBJ_STATE_ID	NUMBER	Состояние абонента
N_FIRM_ID	NUMBER	Идентификатор создавшей фирмы
N_ACCOUNT_ID	NUMBER	Идентификатор счета
N_ACCOUNT_TYPE_ID	NUMBER	Идентификатор типа счета
VC_ACCOUNT_TYPE_NAME	VARCHAR2	Наименование типа счета
N_BANK_ID	NUMBER	Идентификатор банка
VC_BANK_NAME	VARCHAR2	Наименование банка
N_CURRENCY_ID	NUMBER	Идентификатор валюты
VC_CURRENCY	VARCHAR2	Наименование валюты
VC_CURRENCY_CODE	VARCHAR2	Код валюты
VC_NAME	VARCHAR2	Наименование
VC_CODE	VARCHAR2	Код
VC_ACCOUNT	VARCHAR2	Номер
D_OPEN	DATE	Дата открытия
D_CLOSE	DATE	Дата закрытия
N_MAX_OVERDRAFT	NUMBER	Максимальный кредитный лимит
VC_BANK	VARCHAR2	Полное наименование филиала банка
VC_REM	VARCHAR2	Комментарий
VC_CODE_EX	VARCHAR2	Расширенный код счета
D_LOG_LAST_MOD	DATE
N_LOG_SESSION_ID	NUMBER
N_PAYMENT_MATCHING_CFG_ID	NUMBER	Конфигурация для автоматической разноски платежей

SI_V_USER_ADDSERVS

Additional services included in price plans

Field	Type	Description
N_DOC_ID	NUMBER	Charge log
N_GOOD_ID	NUMBER	Service
N_UNIT_ID	NUMBER	Measuring unit
N_QUANT	NUMBER	Quantity
N_UNIT_BASE_ID	NUMBER	Basic measuring unit
N_QUANT_BASE	NUMBER	Quantity in basic units
N_TAX_RATE_ID	NUMBER	Tax rate
N_OBJECT_ID	NUMBER	CPE
N_ADDRESS_ID	NUMBER	Address
N_CURRENCY_ID	NUMBER	Currency
N_PAR_LINE_ID	NUMBER	Charge log line for a price plan
N_PRICE_LINE_ID	NUMBER	Price specification line for the service
N_PRICE	NUMBER	Service price
N_PRICE_WO_TAX	NUMBER	Price excl. taxes
N_SUM	NUMBER	Amount
N_SUM_TAX	NUMBER	Taxes
N_SUM_WO_TAX	NUMBER	Amount excl. taxes
D_OPER	DATE	Operation date
D_BEGIN	DATE	Start date
D_END	DATE	End date
VC_REM	VARCHAR2	Remark
N_PARENT_GOOD_ID	NUMBER	Price plan
N_BASE_LINE_ID	NUMBER	Basic charge log line for a service

SI_V_USER_DEVICES_SIMPLE

CPE

Field	Type	Description
N_SUBJECT_ID	NUMBER	Customer
VC_SUBJ_CODE	VARCHAR2	Customer's code
N_USE_DEVICE_ID	NUMBER	CPE
VC_DEVICE_CODE	VARCHAR2	Code of the CPE or main equipment (if the CPE is a component)
VC_USE_DEVICE_CODE	VARCHAR2	CPE code or the main equipment code with the CPE name added (if the CPE is a component)
N_DEVICE_ID	NUMBER	CPE or the main equipment (if the CPE is a component)
N_DEVICE_GOOD_ID	NUMBER	CPE type
N_DEV_STATE_ID	NUMBER	CPE status
N_PORT_ID	NUMBER	CPE component or the CPE itself (if the CPE is a component)
VC_PORT_CODE	VARCHAR2	CPE component code or the CPE code (if the CPE is a component)
VC_PORT_NAME	VARCHAR2	CPE component name or the CPE name (if the CPE is a component)
N_PORT_NUM	NUMBER	CPE component number or the CPE number (if the CPE is a component)
N_PORT_STATE_ID	NUMBER	CPE component status or the CPE status (if the CPE is a component)
N_OWNER_OBJECT_ID	NUMBER	CPE
N_OBJ_KIND_ID	NUMBER	Product catalog branch the CPE type belongs to
N_GOOD_BRANCH_ID	NUMBER	Product catalog branch the CPE type belongs to
N_FIRM_ID	NUMBER	CPE division
N_USER_FIRM_ID	NUMBER	Customer's division

SS_V_CDR_DETAILS

Детализация CDR

Field	Type	Description
N_CDR_DETAIL_ID	NUMBER	Идентификатор записи
N_CDR_ID	NUMBER	CDR
N_RATING_TYPE_ID	NUMBER	Тип тарификации
VC_RATING_TYPE	VARCHAR2	Тип тарификации
N_LINE_NO	NUMBER	Номер строки
N_RATING_STATE_ID	NUMBER	Состояние тарификации
VC_ACC_STATE	VARCHAR2	Состояние тарификации
N_FAIL_REASON_ID	NUMBER	Причина неуспешной тарификации
VC_FAIL_REASON	VARCHAR2	Причина неуспешной тарификации
VC_RATING_ERROR	VARCHAR2	Ошибка тарификации
N_PROVIDER_ID	NUMBER	Поставщик
VC_PROVIDER	VARCHAR2	Поставщик
N_FIRM_ID	NUMBER	Фирма, для которой тарифицирована
N_ADDRESS_A_ID	NUMBER	Идентификатор адреса станции A
VC_ADDRESS_A	VARCHAR2
N_ADDRESS_B_ID	NUMBER	Идентификатор адреса станции B
VC_ADDRESS_B	VARCHAR2
N_OBJECT_ID	NUMBER	Абонентское оборудование
VC_OBJECT	VARCHAR2	Абонентское оборудование
N_CUSTOMER_ID	NUMBER	Абонент
VC_CUSTOMER	VARCHAR2	Абонент
N_ACCOUNT_ID	NUMBER	Лицевой счет абонента
VC_ACCOUNT	VARCHAR2	Наименование лицевого счета
VC_ACCOUNT_CODE	VARCHAR2	Код лицевого счета
N_SERVICE_ID	NUMBER	Услуга
VC_SERVICE	VARCHAR2	Услуга
N_CHARGE_LOG_ID	NUMBER	Акт начислений
N_CONTRACT_ID	NUMBER	Идентификатор договора
VC_CONTRACT	VARCHAR2	Договор
VC_CHARGE_LOG	VARCHAR2	Наименование акта начислений
VC_CHARGE_LOG_CODE	VARCHAR2	Код акта начислений
T_CHARGE_LOG_LINE_IDS	NUMBER_TABLE	Строки акта начислений
N_CURRENCY_ID	NUMBER	Валюта
VC_CURRENCY	VARCHAR2	Валюта
N_AMOUNT	NUMBER	Стоимость
N_AMOUNT_TAX	NUMBER	Сумма налога
N_AMOUNT_WO_TAX	NUMBER	Сумма без налогов
N_QUANT	NUMBER	Количество
N_QUANT_BASE	NUMBER	Количество в секундах
N_QUANT_MINUTES	NUMBER	Количество в минутах
N_UNIT_ID	NUMBER	Единица измерения
VC_VISUAL_UNIT	VARCHAR2	Единица измерения
N_TAX_RATE_ID	NUMBER	Ставка налога
VC_TAX_RATE	VARCHAR2	Ставка налога
D_OPER	DATE	Дата операции
T_TEL_CODE_A_IDS	NUMBER_ARRAY_SHORT	Идентификаторы кодов А
VC_TEL_CODES_A	VARCHAR2	Телефонные коды А
T_TEL_CODE_B_IDS	NUMBER_ARRAY_SHORT	Идентификаторы кодов Б
VC_TEL_CODES_B	VARCHAR2	Телефонные коды Б
VC_VISUAL_ADDRESS_A	VARCHAR2
VC_VISUAL_ADDRESS_B	VARCHAR2
N_PRICE_ORDER_ID	NUMBER
VC_PRICE_ORDER	VARCHAR2
VC_PRICE_ORDER_CODE	VARCHAR2
VC_EXT_UNIQ_ID	VARCHAR2
T_ATTRIBUTES	KEY_VALUE_TABLE	Атрибуты
VC_DIRECTION	VARCHAR2	Тип вызова
N_PRICE	NUMBER	Цена
N_GM_LINE_ID	NUMBER	Строка акта начислений

SS_V_JOBS

Задания

Field	Type	Description
N_JOB_ID	NUMBER
N_JOB_TYPE_ID	NUMBER
VC_JOB_TYPE	VARCHAR2
N_SUBJECT_ID	NUMBER
VC_SUBJ_CODE	VARCHAR2
N_SUBJ_TYPE_ID	NUMBER
N_OBJECT_ID	NUMBER
VC_OBJ_NAME	VARCHAR2
VC_JOB_NAME	VARCHAR2
VC_DIRECTION	VARCHAR2
C_DIRECTION	VARCHAR2
C_CAN_IMMEDIATELY	VARCHAR2
VC_PROCEDURE_NAME	VARCHAR2
D_FIRST_START	DATE
N_INTERVAL	NUMBER
C_FL_TO_BE_LOCKED	CHAR
C_FL_MANUAL_START	CHAR
N_JOB_STATE_ID	NUMBER
D_LAST_START	DATE
D_NEXT_START	DATE
N_FROM_HOUR	NUMBER
N_TO_HOUR	NUMBER
N_FIRM_ID	NUMBER
VC_FIRM	VARCHAR2
N_TEMPLATE_ID	NUMBER
N_LANG_ID	NUMBER
N_LOG_LEVEL_ID	NUMBER
VC_JOB_STATE	VARCHAR2
C_FL_BROKEN	CHAR

SS_V_USERS_APP_BINDS

Приложения, на которые подписан пользователь

EX_V_SUBJ_SERVICE

Network service subscriptions

Field	Type	Description
N_SUBJ_SERV_ID	NUMBER	Network service subscription
N_SUBJ_SERV_TYPE_ID	NUMBER	Type of subscription
N_SUBJECT_ID	NUMBER	Customer
N_SERVICE_ID	NUMBER	Network service
VC_SERVICE	VARCHAR2	Network service name
VC_USER_SERVICE_NAME	VARCHAR2	Network service name for customer
N_OBJECT_ID	NUMBER	Equipment
VC_OBJECT	VARCHAR2	Equipment code
N_OBJ_GOOD_ID	NUMBER	Equipment catalog item
VC_OBJ_GOOD	VARCHAR2	Equipment catalog item name
N_AUTH_TYPE_ID	NUMBER	Authentication type
VC_AUTH_TYPE	VARCHAR2	Authentication type name
N_OBJ_ADDRESS_ID	NUMBER	Equipment address
N_PORT_NO	NUMBER	Equipment port number
VC_LOGIN	VARCHAR2	Login
VC_LOGIN_REAL	VARCHAR2	Real login
VC_PASS	VARCHAR2	Password
C_FL_EMPTY_PASS	VARCHAR2	Is password empty
VC_VALUE	VARCHAR2	String value
N_VALUE	NUMBER	Number value
N_SERVICE_GOOD_ID	NUMBER	Network service catalog item

Argument	Direction	Reference type	Type	Description
num_N_REGION_ID	IN	SR_REGIONS.N_REGION_ID%TYPE	NUMBER	Region
num_N_REGION_TYPE_ID	IN	SR_REGIONS.N_REGION_TYPE_ID%TYPE	NUMBER	Parent region type
RETURN SR_REGIONS.VC_CODE%TYPE				Parent region code

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_URL	IN	VARCHAR2	VARCHAR2		URL
vch_VC_WALLET_PATH	IN	VARCHAR2	VARCHAR2	NULL	Certificates wallet path
vch_VC_WALLET_PASSWORD	IN	VARCHAR2	VARCHAR2	NULL	Wallet's password
vch_VC_BASIC_AUTH_USER	IN	VARCHAR2	VARCHAR2	NULL	Basic authentication username
vch_VC_BASIC_AUTH_PASSWORD	IN	VARCHAR2	VARCHAR2	NULL	Basic authentication password
vch_VC_PROXY_ADDRESS	IN	VARCHAR2	VARCHAR2	NULL	Proxy address
clb_CL_RESPONSE	OUT	CLOB	CLOB		Response
num_N_RESPONSE_CSID	IN	NUMBER	NUMBER	DBMS_LOB.DEFAULT_CSID	Response CSID

Field	Type	Description
N_AUTO_TOP_UP_ID	NUMBER
N_RULE_ID	NUMBER
N_AUTO_TOP_UP_TYPE_ID	NUMBER
N_AUTO_TOP_UP_STATE_ID	NUMBER
N_ACCOUNT_ID	NUMBER
VC_EXT_ATU_IDENTIFIER	VARCHAR2
D_VALID_UNTIL	DATE
N_TOP_UP_SUM	NUMBER
N_MIN_SUM	NUMBER
N_MAX_SUM	NUMBER
N_MAX_SUM_MONTHLY	NUMBER
N_MAX_TXNS_MONTHLY	NUMBER
N_LOW_BALANCE_LIMIT	NUMBER
VC_CARD_TYPE	VARCHAR2
C_FL_VALID	VARCHAR2
D_TERMS_ACCEPTED	DATE
N_CHARGING_DAY	NUMBER

Field	Type	Description
N_LINE_ID	NUMBER	ID of line in register
VC_CONTEXT	VARCHAR2	Context
N_TEMPLATE_ID	NUMBER	Template of profile
N_PROFILE_ID	NUMBER	Profile
T_CHILD_PROFILE_IDS	NUMBER_TABLE	IDs of child profiles as nested table
D_BEGIN	DATE	D_BEGIN of profile
D_END	DATE	D_END of profile
N_TIME_INTERVAL_ID	NUMBER	Time interval
N_TIME_INTERVAL_DOC_ID	NUMBER	Time interval specification
N_SCN	NUMBER	Version
N_FIRM_ID	NUMBER	Firm
N_EQUIPMENT_ID	NUMBER	Equipment

Field	Type	Description
N_OBJ_VALUE_ID	NUMBER	Идентификатор записи
N_OBJECT_ID	NUMBER	Идентификатор ОУ
N_CUSTOMER_EQUIPMENT_ID	NUMBER
N_PROVIDER_EQUIPMENT_ID	NUMBER
N_GOOD_ID	NUMBER
N_GOOD_VALUE_TYPE_ID	NUMBER	Идентификатор типа значения
N_REF_ID	NUMBER	Ссылка на справочное значение
D_VALUE	DATE	Датавременное значение
C_VALUE	CHAR	Символьное значение
VC_VALUE	VARCHAR2	Строковое значение
N_VALUE	NUMBER	Числовое значение
C_FL_VALUE	CHAR	Флаговое значение
CL_VALUE	CLOB	Текстовое значение
VC_VISUAL_VALUE	VARCHAR2

Field	Type	Description
N_SUBJ_SERV_ID	NUMBER	Идентификатор подписки на службу
N_SUBJ_SERV_TYPE_ID	NUMBER	Тип подписки
N_USER_ID	NUMBER	Абонент
N_SUBJECT_ID	NUMBER	Абонент
N_AUTH_TYPE_ID	NUMBER	Тип авторизации
N_APPLICATION_ID	NUMBER	Приложение
VC_APPLICATION	VARCHAR2	Приложение
N_SERVICE_ID	NUMBER	Служба
VC_LOGIN	VARCHAR2	Логин
VC_LOGIN_REAL	VARCHAR2
C_FL_EMPTY_PASS	VARCHAR2	Флаг не установленного пароля
N_HASH_TYPE_ID	NUMBER	Тип хэша пароля
N_GOOD_ID	NUMBER	Тип службы
VC_GOOD_NAME	VARCHAR2	Тип службы
N_LOCALE_ID	NUMBER
N_DIRECTORY_ID	NUMBER	Источник пользователей
VC_PASSWORD_PATTERN	VARCHAR2	Шаблон для проверки пароля

Oracle API diff 6.0 and 6.2

Objects

Packages

PROCEDURE COLLECT_ACCOUNTING_DATA

PROCEDURE REMOVE_TEMP_ACC_DATA

PROCEDURE UNLOAD_DOCUMENTS

TYPE USER_DETALIZATION_ROWS PL/SQL TABLE

FUNCTION USERS_ACC_DETALIZATION

PROCEDURE PUT_CUSTOMER_CUSTOM_VALUE

PROCEDURE LOAD_CHARGE_LOGS_FROM_CSV

PROCEDURE LOAD_PROV_EQUIP_FROM_CSV

PROCEDURE CREATE_AUTO_TOP_UP

PROCEDURE CREATE_ATU_SUBSCRIPTION

FUNCTION NOT_REFUNDED_PAYMENTS_LIST_P

FUNCTION GET_AUTO_TOP_UP_BY_ACCOUNT

PROCEDURE PUT_CUSTOMER_CUSTOM_VALUE

PROCEDURE REFUND_PAYMENT

FUNCTION REVERSAL_PAYMENT_ORDER_EXISTS

PROCEDURE UPDATE_AUTO_TOP_UP_BY_ACCOUNT

FUNCTION GET_ACCOUNT_DETAILS_P

PROCEDURE GET_ACCOUNT_AND_BANK_BY_FIRM

PROCEDURE CHARGE_ADJUSTMENT

PROCEDURE SD_CHARGE_LOGS_C_PUT

PROCEDURE SD_CONTRACTS_PUT

PROCEDURE SD_CONTRACTS_DEL

FUNCTION GET_ADDR_VALUE_BY_ROLE

FUNCTION GET_ADDR_BY_ROLE

FUNCTION DOCUMENT_GOODS_HISTORY

PROCEDURE CHECK_SINGLE_DOC_PERIOD

FUNCTION GET_TOTAL_CREDIT_LIMIT

PROCEDURE SD_PAYMENTS_C_DEL

PROCEDURE SD_PAYMENTS_C_PUT

FUNCTION GET_RECOMMENDED_PAYMENT_C

PROCEDURE SI_AUTO_TOP_UPS_PUT

PROCEDURE CREATE_PAYMENT_REQUESTS

FUNCTION FILL_RECOMMENDED_PAYMENT_TT

FUNCTION CREATE_PAYMENT_REQUEST

PROCEDURE FIND_RECOMMENDED_PAYMENT

PROCEDURE SD_REQUESTS_COPY

PROCEDURE SD_REQUESTS_EQUIP_DEL

PROCEDURE SD_REQUESTS_GOODS_DEL

PROCEDURE SD_REQUESTS_GOODS_PUT

PROCEDURE SD_REQUESTS_EQUIP_PUT

PROCEDURE SD_REQUESTS_PUT

PROCEDURE CUSTOMER_ACCOUNT_PUT

PROCEDURE SI_DOC_ADDRESSES_PUT

PROCEDURE SI_DOC_ADDRESSES_DEL

PROCEDURE SI_SUBJ_SUBJECTS_PUT

PROCEDURE SI_SUBJ_ACCOUNTS_PUT

PROCEDURE SI_SUBJ_SERVICES_PUT

FUNCTION GET_RANDOM_SUBJECT_ID

FUNCTION IS_EXIST_ACCOUNT_NO

PROCEDURE SI_SUBSCRIPTIONS_PUT

FUNCTION GET_AVAILABLE_SERVICES_FOR_CONTRACT

PROCEDURE FIND_OR_CREATE_SSO_USER

FUNCTION GET_RECOMMENDED_PAYMENT

FUNCTION GET_RECOMMENDED_PAYMENT_LIST_C

FUNCTION GET_RECOMMENDED_PAYMENT_LIST

FUNCTION GET_USER_RECOMMENDED_PAY

FUNCTION GET_UPPER_REGION_CODE

FUNCTION GET_CHILDREN_REGION_LIST

FUNCTION GET_N_SESSION_ID

PROCEDURE INIT_SSO_USER_OFFICE_SESSION

PROCEDURE INIT_SSO_USER_SESSION

FUNCTION HTML_ENTITIES_ENCODE

FUNCTION HTML_ENTITIES_DECODE

PROCEDURE HTTP_REQUEST

Views

AP_V_AUTO_TOP_UPS

AP_V_OFFICE_PAYS

RG_V_SERV_STATUS

RPT_V_CDR

RPT_V_CDR_ARCH

RPT_V_PAY_DOCS

RPT_V_USERS

RP_V_ALL_PROFILES

RP_V_CURRENT_PROFILES

RP_V_PROFILES

SD_V_CHARGE_LOGS_JR

SD_V_CONTRACTS