Oracle API diff 6.1 and 6.2

Legend: added, changed, deleted.

Objects

EX_LOADINGS_PKG
EX_PAYMENTS_PKG_S
SD_DOCUMENTS_PKG_S
SD_REQUESTS_PKG
SI_ADDRESSES_PKG
SI_SUBJECTS_PKG
SI_SUBJECTS_PKG_S
SI_SUBSCRIPTIONS_PKG_S
SI_USERS_PKG
SR_REGIONS_PKG_S
SS_AUTHENTICATION_PKG
STR_UTILS_PKG_S
RP_V_ALL_PROFILES
RP_V_PROFILES
SS_V_USERS_APP_BINDS

Packages

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
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_S

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

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_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

SD_REQUESTS_PKG

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

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_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_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_ADDRESSES_PKG

Addresses management

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

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

SI_SUBJECTS_PKG

Subjects management

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

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

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 BIND_USERS_ROLES

Argument	Direction	Reference type	Type	Default value	Description
num_N_USER_ID	IN	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER
tbl_N_ROLES_IDS	IN	NUMBER_TABLE	TABLE

PROCEDURE FIND_OR_CREATE_USER

Argument	Direction	Reference type	Type	Default value
vch_VC_CODE	IN	SI_SUBJECTS.VC_CODE%TYPE	VARCHAR2
num_N_BASE_SUBJECT_ID	IN	SI_SUBJECTS.N_BASE_SUBJECT_ID%TYPE	NUMBER
num_N_SUBJ_GROUP_ID	IN	SS_SUBJ_AUTONUMS.N_SUBJ_GROUP_ID%TYPE	NUMBER
num_N_FIRM_ID	IN	SI_SUBJECTS.N_FIRM_ID%TYPE	NUMBER
vch_VC_BASE_SUBJECT_FIRST_NAME	IN	SI_SUBJECTS.VC_NAME%TYPE	VARCHAR2
tbl_N_ROLES_IDS	IN	NUMBER_TABLE	TABLE	NULL
num_N_USER_ID	OUT	SI_SUBJECTS.N_SUBJECT_ID%TYPE	NUMBER

PROCEDURE FIND_OR_CREATE_SSO_USER

SR_REGIONS_PKG_S

Registry of regions management

FUNCTION GET_UPPER_REGION_CODE

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

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

SS_AUTHENTICATION_PKG

Authentication management

PROCEDURE CREATE_SESSION

Procedure for creating SSO session.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_IP	IN	SS_SESSION_LOGS.VC_CLIENT_IP%TYPE	VARCHAR2		Client IP
vch_VC_APP_CODE	IN	SS_SESSION_LOGS.VC_PROGRAM%TYPE	VARCHAR2	NULL	Application code
vch_VC_CLN_SESSIONID	IN	SS_SESSION_LOGS.VC_CLN_SESSIONID%TYPE	VARCHAR2	NULL	Client session ID
num_N_USER_ID	IN	SS_SESSION_LOGS.N_USER_ID%TYPE	NUMBER	NULL	User for logging on
vch_VC_JTI	IN	SS_SESSION_LOGS.VC_JTI%TYPE	VARCHAR2	NULL	JWT ID

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.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_VALUE	IN	VARCHAR2	VARCHAR2		XML data to be encoded
RETURN VARCHAR2	Escaped XML data

FUNCTION HTML_ENTITIES_DECODE

Convert an XML data into an unescaped XML data.

Argument	Direction	Reference type	Type	Default value	Description
vch_VC_VALUE	IN	VARCHAR2	VARCHAR2		XML data to be decoded
RETURN VARCHAR2	Unescaped XML data

Views

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

SS_V_USERS_APP_BINDS

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

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	Шаблон для проверки пароля