index

Package BANINST1.fb_accounting_element_rules

Support subprograms for IFOAPAL information API (FB_ACCOUNTING_ELEMENT_RULES).

Program units
P_REGISTER_ENTITY   Registers the attribute value pairs to the message cache.

Constants
M_OBJECT_NAME   Object Name
M_ELEMENT_TYPE   Element Type
M_CHART_CODE   Chart of Accounts Code
M_ELEMENT_CODE   Element Code
M_ELEMENT_TITLE   Element Title
M_CHART_TITLE   Chart of Accounts Title
M_EFF_DATE   Effective Date
M_TERM_DATE   Termination date
M_STATUS   Inactive status

M_OBJECT_NAME 

M_OBJECT_NAME        CONSTANT VARCHAR2(25) := 'ACCOUNTING_ELEMENT';

Object Name

M_ELEMENT_TYPE 

M_ELEMENT_TYPE       CONSTANT VARCHAR2(15) := 'ELEMENT_TYPE';

Element Type

M_CHART_CODE 

M_CHART_CODE         CONSTANT VARCHAR2(10) := 'CHART_CODE';

Chart of Accounts Code

M_ELEMENT_CODE 

M_ELEMENT_CODE       CONSTANT VARCHAR2(12) := 'ELEMENT_CODE';

Element Code

M_ELEMENT_TITLE 

M_ELEMENT_TITLE      CONSTANT VARCHAR2(20) := 'ELEMENT_TITLE';

Element Title

M_CHART_TITLE 

M_CHART_TITLE        CONSTANT VARCHAR2(20) := 'CHART_TITLE';

Chart of Accounts Title

M_EFF_DATE 

M_EFF_DATE           CONSTANT VARCHAR2(20) := 'EFFECTIVE_DATE';

Effective Date

M_TERM_DATE 

M_TERM_DATE          CONSTANT VARCHAR2(20) := 'TERMINATION_DATE';

Termination date

M_STATUS 

M_STATUS             CONSTANT VARCHAR2(20) := 'INACTIVE_STATUS';

Inactive status

P_REGISTER_ENTITY 

Procedure P_REGISTER_ENTITY(p_operation_id NUMBER,
                            p_element_type varchar2,
                            p_chart_Code   varchar2,
                            p_element_code varchar2,
                            p_title        varchar2 default NULL,
                            p_eff_date     date default NULL,
                            p_term_date    date default NULL,
                            p_status       varchar2 default NULL)

Registers the attribute value pairs to the message cache.

Parameters
p_operation_id   The ID of DML operation: create, update, delete.  NUMBER Required.
p_element_type   Type of element.  VARCHAR2 required.
p_chart_Code   The chart of accounts code. VARCHAR2(1) Required.
p_element_code   The code of foapal element.  VARCHAR2 required.
p_title   The title of the foapal element.  VARCHAR2.
p_eff_date   The effective date of the foapal element.  Date.
p_term_date   The termination date of the foapal element.  Date.
p_status   The status of the foapal element.  VARCHAR2.