Package BANINST1.fb_chart_of_accounts

Package BANINST1.fb_chart_of_accounts_rules

Support subprograms for chart of accounts API (FB_CHART_OF_ACCOUNTS_RULES).

Program units

p_publish_sync	Procedure to publish the synchronized data.
p_publish_sync	Procedure to publish the synchronized data.
p_populate_globals	Procedure to populate global variables.
p_set_globals_null	Procedure to assign null values to global variables.
p_register_entity	Registers the attribute value pairs to the message cache.
p_validate	Placeholder procedure that does nothing currently.

Variables

NEW_COAS	Global variable to hold the new value of COAS record
OLD_COAS	Global variable to hold the old value of COAS record

Constants

M_OBJECT_NAME	Object name
M_COAS_CODE	Chart of accounts code
M_EFF_DATE	Effective date
M_ACTIVITY_DATE	Activity date
M_USER_ID	User ID
M_NCHG_DATE	Next change date
M_TITLE	Chart title
M_STATUS_IND	Chart status indicator
M_CAL_START_MONTH	Fiscal year start month
M_CAL_START_DAY	Fiscal year start day
M_CAL_END_MONTH	Fiscal year end month
M_CAL_END_DAY	Fiscal year end day
M_METH_OF_ACCTG	Method of accounting
M_BAVL_KEY_FUND	Fund budget key
M_BAVL_KEY_ORGN	Organization budget key
M_BAVL_KEY_ACCT	Account budget key
M_BAVL_KEY_PROG	Program budget key budget key
M_BAVL_PERIOD	Budget control period
M_BAVL_SEVERITY	Budget control severity
M_RUCL_CODE_ROLL_ENC	Roll encumbrances rule class
M_COMMIT_TYPE	Commitment type
M_BUDGET_ROLL	Budget roll
M_BUDGET_DISPOSITION	Buddget disposition
M_BUDGET_ROLL_PERCENT	Encumbrance budget roll percentage
M_RUCL_CODE_BUDG_CF	Budget roll rule code
M_BUDG_CF_TYPE	Budget type indicator
M_BUDG_CLASSIFICATION	Buddget classification
M_BUDG_CF_PERCENT	Budget percentage to be carried forward
M_RUCL_CODE_CLOSE_OP	Close operating ledger rule class
M_ROLL_ENC_IND	Roll encumbrance indicator
M_ROLL_PO_IND	Roll purchase order indicator
M_ROLL_MEMO_RES_IND	Roll memo reservation indicator
M_ROLL_REQ_IND	Roll requisition indicator
M_ROLL_LABOR_ENC_IND	Roll labor encumbrance indicator
M_ROLL_WO_IND	Roll work order indicator
M_TERM_DATE	Chart termination date
M_ACCT_CODE_FUND_DUE_TO	Due to account code
M_ACCT_CODE_FUND_DUE_FRM	From account code
M_ACCT_CODE_FUND_BAL	Fund balance account code
M_ACCT_CODE_ACCRUAL_AP	Accounts payable accrual account code
M_ACCT_CODE_ACCRUAL_AR	Accounts reveivable accrual account code
M_CURRENT_YEAR_INCOME	Current year income
M_ACCT_CODE_TRF_INCOME	Current year income transfer account
M_ORGN_CODE_TRF_INCOME	Current year income transfer organization
M_PROG_CODE_TRF_INCOME	Current year income transfer program
M_PY_RETAINED_INCOME	Prior year retained income
M_ACCT_CODE_TRF_RI_PY	Prior year retained income transfer account
M_ORGN_CODE_TRF_RI_PY	Prior year retained income transfer organization
M_PROG_CODE_TRF_RI_PY	Prior year retained income transfer program
M_REAL_GL	Realized gains/loss
M_ACCT_CODE_TRF_RGL	Realized gains/loss transfer account
M_ORGN_CODE_TRF_RGL	Realized gains/loss transfer organization
M_PROG_CODE_TRF_RGL	Realized gains/loss transfer program
M_REAL_GL_PY	Prior year realized gains/loss
M_ACCT_CODE_TRF_RGL_PY	Prior year realized gains/loss transfer account
M_ORGN_CODE_TRF_RGL_PY	Prior year realized gains/loss transfer organization
M_PROG_CODE_TRF_RGL_PY	Prior year realized gains/loss transfer program
M_FUND_ATTRIBUTE_IND	Fund attribute indicator
M_ORGN_ATTRIBUTE_IND	Organization attribute indicator
M_ACCT_ATTRIBUTE_IND	Account attribute indicator
M_PROG_ATTRIBUTE_IND	Program attribute indicator
M_ACTV_ATTRIBUTE_IND	Activity attribute indicator
M_LOCN_ATTRIBUTE_IND	Location attribute indicator

M_OBJECT_NAME

M_OBJECT_NAME                 CONSTANT VARCHAR2(17)  := 'CHART_OF_ACCOUNTS';

Object name

M_COAS_CODE

M_COAS_CODE                     CONSTANT VARCHAR2(17)  := 'FTVCOAS_COAS_CODE';

Chart of accounts code

M_EFF_DATE

M_EFF_DATE                      CONSTANT VARCHAR2(16)  := 'FTVCOAS_EFF_DATE';

Effective date

M_ACTIVITY_DATE

M_ACTIVITY_DATE                 CONSTANT VARCHAR2(21)  := 'FTVCOAS_ACTIVITY_DATE';

Activity date

M_USER_ID

M_USER_ID                       CONSTANT VARCHAR2(15)  := 'FTVCOAS_USER_ID';

User ID

M_NCHG_DATE

M_NCHG_DATE                     CONSTANT VARCHAR2(17)  := 'FTVCOAS_NCHG_DATE';

Next change date

M_TITLE

M_TITLE                         CONSTANT VARCHAR2(13)  := 'FTVCOAS_TITLE';

Chart title

M_STATUS_IND

M_STATUS_IND                    CONSTANT VARCHAR2(18) := 'FTVCOAS_STATUS_IND';

Chart status indicator

M_CAL_START_MONTH

M_CAL_START_MONTH               CONSTANT VARCHAR2(23) := 'FTVCOAS_CAL_START_MONTH';

Fiscal year start month

M_CAL_START_DAY

M_CAL_START_DAY                 CONSTANT VARCHAR2(21) := 'FTVCOAS_CAL_START_DAY';

Fiscal year start day

M_CAL_END_MONTH

M_CAL_END_MONTH                 CONSTANT VARCHAR2(21) := 'FTVCOAS_CAL_END_MONTH';

Fiscal year end month

M_CAL_END_DAY

M_CAL_END_DAY                   CONSTANT VARCHAR2(19) := 'FTVCOAS_CAL_END_DAY';

Fiscal year end day

M_METH_OF_ACCTG

M_METH_OF_ACCTG                 CONSTANT VARCHAR2(21) := 'FTVCOAS_METH_OF_ACCTG';

Method of accounting

M_BAVL_KEY_FUND

M_BAVL_KEY_FUND                 CONSTANT VARCHAR2(21) := 'FTVCOAS_BAVL_KEY_FUND';

Fund budget key

M_BAVL_KEY_ORGN

M_BAVL_KEY_ORGN                 CONSTANT VARCHAR2(21) := 'FTVCOAS_BAVL_KEY_ORGN';

Organization budget key

M_BAVL_KEY_ACCT

M_BAVL_KEY_ACCT                 CONSTANT VARCHAR2(21) := 'FTVCOAS_BAVL_KEY_ACCT';

Account budget key

M_BAVL_KEY_PROG

M_BAVL_KEY_PROG                 CONSTANT VARCHAR2(21) := 'FTVCOAS_BAVL_KEY_PROG';

Program budget key budget key

M_BAVL_PERIOD

M_BAVL_PERIOD                   CONSTANT VARCHAR2(19) := 'FTVCOAS_BAVL_PERIOD';

Budget control period

M_BAVL_SEVERITY

M_BAVL_SEVERITY                 CONSTANT VARCHAR2(21) := 'FTVCOAS_BAVL_SEVERITY';

Budget control severity

M_RUCL_CODE_ROLL_ENC

M_RUCL_CODE_ROLL_ENC            CONSTANT VARCHAR2(26) := 'FTVCOAS_RUCL_CODE_ROLL_ENC';

Roll encumbrances rule class

M_COMMIT_TYPE

M_COMMIT_TYPE                   CONSTANT VARCHAR2(19) := 'FTVCOAS_COMMIT_TYPE';

Commitment type

M_BUDGET_ROLL

M_BUDGET_ROLL                   CONSTANT VARCHAR2(19) := 'FTVCOAS_BUDGET_ROLL';

Budget roll

M_BUDGET_DISPOSITION

M_BUDGET_DISPOSITION            CONSTANT VARCHAR2(26) := 'FTVCOAS_BUDGET_DISPOSITION';

Buddget disposition

M_BUDGET_ROLL_PERCENT

M_BUDGET_ROLL_PERCENT           CONSTANT VARCHAR2(27) := 'FTVCOAS_BUDGET_ROLL_PERCENT';

Encumbrance budget roll percentage

M_RUCL_CODE_BUDG_CF

M_RUCL_CODE_BUDG_CF             CONSTANT VARCHAR2(25) := 'FTVCOAS_RUCL_CODE_BUDG_CF';

Budget roll rule code

M_BUDG_CF_TYPE

M_BUDG_CF_TYPE                  CONSTANT VARCHAR2(20) := 'FTVCOAS_BUDG_CF_TYPE';

Budget type indicator

M_BUDG_CLASSIFICATION

M_BUDG_CLASSIFICATION           CONSTANT VARCHAR2(27) := 'FTVCOAS_BUDG_CLASSIFICATION';

Buddget classification

M_BUDG_CF_PERCENT

M_BUDG_CF_PERCENT               CONSTANT VARCHAR2(23) := 'FTVCOAS_BUDG_CF_PERCENT';

Budget percentage to be carried forward

M_RUCL_CODE_CLOSE_OP

M_RUCL_CODE_CLOSE_OP            CONSTANT VARCHAR2(26) := 'FTVCOAS_RUCL_CODE_CLOSE_OP';

Close operating ledger rule class

M_ROLL_ENC_IND

M_ROLL_ENC_IND                  CONSTANT VARCHAR2(20) := 'FTVCOAS_ROLL_ENC_IND';

Roll encumbrance indicator

M_ROLL_PO_IND

M_ROLL_PO_IND                   CONSTANT VARCHAR2(19) := 'FTVCOAS_ROLL_PO_IND';

Roll purchase order indicator

M_ROLL_MEMO_RES_IND

M_ROLL_MEMO_RES_IND             CONSTANT VARCHAR2(25) := 'FTVCOAS_ROLL_MEMO_RES_IND';

Roll memo reservation indicator

M_ROLL_REQ_IND

M_ROLL_REQ_IND                  CONSTANT VARCHAR2(20) := 'FTVCOAS_ROLL_REQ_IND';

Roll requisition indicator

M_ROLL_LABOR_ENC_IND

M_ROLL_LABOR_ENC_IND            CONSTANT VARCHAR2(26) := 'FTVCOAS_ROLL_LABOR_ENC_IND';

Roll labor encumbrance indicator

M_ROLL_WO_IND

M_ROLL_WO_IND                   CONSTANT VARCHAR2(19) := 'FTVCOAS_ROLL_WO_IND';

Roll work order indicator

M_TERM_DATE

M_TERM_DATE                     CONSTANT VARCHAR2(17) := 'FTVCOAS_TERM_DATE';

Chart termination date

M_ACCT_CODE_FUND_DUE_TO

M_ACCT_CODE_FUND_DUE_TO         CONSTANT VARCHAR2(29) := 'FTVCOAS_ACCT_CODE_FUND_DUE_TO';

Due to account code

M_ACCT_CODE_FUND_DUE_FRM

M_ACCT_CODE_FUND_DUE_FRM        CONSTANT VARCHAR2(30) := 'FTVCOAS_ACCT_CODE_FUND_DUE_FRM';

From account code

M_ACCT_CODE_FUND_BAL

M_ACCT_CODE_FUND_BAL            CONSTANT VARCHAR2(27) := 'FTVCOAS_ACCT_CODE_FUND_BAL';

Fund balance account code

M_ACCT_CODE_ACCRUAL_AP

M_ACCT_CODE_ACCRUAL_AP          CONSTANT VARCHAR2(28) := 'FTVCOAS_ACCT_CODE_ACCRUAL_AP';

Accounts payable accrual account code

M_ACCT_CODE_ACCRUAL_AR

M_ACCT_CODE_ACCRUAL_AR          CONSTANT VARCHAR2(28) := 'FTVCOAS_ACCT_CODE_ACCRUAL_AR';

Accounts reveivable accrual account code

M_CURRENT_YEAR_INCOME

M_CURRENT_YEAR_INCOME           CONSTANT VARCHAR2(27) := 'FTVCOAS_CURRENT_YEAR_INCOME';

Current year income

M_ACCT_CODE_TRF_INCOME

M_ACCT_CODE_TRF_INCOME          CONSTANT VARCHAR2(28) := 'FTVCOAS_ACCT_CODE_TRF_INCOME';

Current year income transfer account

M_ORGN_CODE_TRF_INCOME

M_ORGN_CODE_TRF_INCOME          CONSTANT VARCHAR2(28) := 'FTVCOAS_ORGN_CODE_TRF_INCOME';

Current year income transfer organization

M_PROG_CODE_TRF_INCOME

M_PROG_CODE_TRF_INCOME          CONSTANT VARCHAR2(28) := 'FTVCOAS_PROG_CODE_TRF_INCOME';

Current year income transfer program

M_PY_RETAINED_INCOME

M_PY_RETAINED_INCOME            CONSTANT VARCHAR2(26) := 'FTVCOAS_PY_RETAINED_INCOME';

Prior year retained income

M_ACCT_CODE_TRF_RI_PY

M_ACCT_CODE_TRF_RI_PY           CONSTANT VARCHAR2(27) := 'FTVCOAS_ACCT_CODE_TRF_RI_PY';

Prior year retained income transfer account

M_ORGN_CODE_TRF_RI_PY

M_ORGN_CODE_TRF_RI_PY           CONSTANT VARCHAR2(27) := 'FTVCOAS_ORGN_CODE_TRF_RI_PY';

Prior year retained income transfer organization

M_PROG_CODE_TRF_RI_PY

M_PROG_CODE_TRF_RI_PY           CONSTANT VARCHAR2(27) := 'FTVCOAS_PROG_CODE_TRF_RI_PY';

Prior year retained income transfer program

M_REAL_GL

M_REAL_GL                       CONSTANT VARCHAR2(15) := 'FTVCOAS_REAL_GL';

Realized gains/loss

M_ACCT_CODE_TRF_RGL

M_ACCT_CODE_TRF_RGL             CONSTANT VARCHAR2(25) := 'FTVCOAS_ACCT_CODE_TRF_RGL';

Realized gains/loss transfer account

M_ORGN_CODE_TRF_RGL

M_ORGN_CODE_TRF_RGL             CONSTANT VARCHAR2(25) := 'FTVCOAS_ORGN_CODE_TRF_RGL';

Realized gains/loss transfer organization

M_PROG_CODE_TRF_RGL

M_PROG_CODE_TRF_RGL             CONSTANT VARCHAR2(25) := 'FTVCOAS_PROG_CODE_TRF_RGL';

Realized gains/loss transfer program

M_REAL_GL_PY

M_REAL_GL_PY                    CONSTANT VARCHAR2(18) := 'FTVCOAS_REAL_GL_PY';

Prior year realized gains/loss

M_ACCT_CODE_TRF_RGL_PY

M_ACCT_CODE_TRF_RGL_PY          CONSTANT VARCHAR2(28) := 'FTVCOAS_ACCT_CODE_TRF_RGL_PY';

Prior year realized gains/loss transfer account

M_ORGN_CODE_TRF_RGL_PY

M_ORGN_CODE_TRF_RGL_PY          CONSTANT VARCHAR2(28) := 'FTVCOAS_ORGN_CODE_TRF_RGL_PY';

Prior year realized gains/loss transfer organization

M_PROG_CODE_TRF_RGL_PY

M_PROG_CODE_TRF_RGL_PY          CONSTANT VARCHAR2(28) := 'FTVCOAS_PROG_CODE_TRF_RGL_PY';

Prior year realized gains/loss transfer program

M_FUND_ATTRIBUTE_IND

M_FUND_ATTRIBUTE_IND            CONSTANT VARCHAR2(26) := 'FTVCOAS_FUND_ATTRIBUTE_IND';

Fund attribute indicator

M_ORGN_ATTRIBUTE_IND

M_ORGN_ATTRIBUTE_IND            CONSTANT VARCHAR2(26) := 'FTVCOAS_ORGN_ATTRIBUTE_IND';

Organization attribute indicator

M_ACCT_ATTRIBUTE_IND

M_ACCT_ATTRIBUTE_IND            CONSTANT VARCHAR2(26) := 'FTVCOAS_ACCT_ATTRIBUTE_IND';

Account attribute indicator

M_PROG_ATTRIBUTE_IND

M_PROG_ATTRIBUTE_IND            CONSTANT VARCHAR2(26) := 'FTVCOAS_PROG_ATTRIBUTE_IND';

Program attribute indicator

M_ACTV_ATTRIBUTE_IND

M_ACTV_ATTRIBUTE_IND            CONSTANT VARCHAR2(26) := 'FTVCOAS_ACTV_ATTRIBUTE_IND';

Activity attribute indicator

M_LOCN_ATTRIBUTE_IND

M_LOCN_ATTRIBUTE_IND            CONSTANT VARCHAR2(26) := 'FTVCOAS_LOCN_ATTRIBUTE_IND';

Location attribute indicator

NEW_COAS

NEW_COAS      Fb_Chart_Of_Accounts.COAS_REC;

Global variable to hold the new value of COAS record

OLD_COAS

OLD_COAS      Fb_Chart_Of_Accounts.COAS_REC;

Global variable to hold the old value of COAS record

p_publish_sync

Procedure p_publish_sync(p_operation_type VARCHAR2,
                         p_coas_code      FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                         p_title          FTVCOAS.FTVCOAS_TITLE%TYPE,
                         p_eff_date       FTVCOAS.FTVCOAS_EFF_DATE%TYPE,
                         p_status_ind     FTVCOAS.FTVCOAS_STATUS_IND%TYPE,
                         p_message_exists OUT VARCHAR2)

Procedure to publish the synchronized data.

Parameters

	p_operation_type	The operation type. Valid values are INSERT, UPDATE and DELETE. VARCHAR2 Required.
	p_coas_code	The code of chart of accounts. VARCHAR2(1) Required.
	p_title	The title of chart of accounts. VARCHAR2(35) Required.
	p_eff_date	The chart effective date. Date Required.
	p_status_ind	The chart status indicator. VARCHAR2(1) Required.
	message_exists	Indicating message exists or not. Valid values are Y and N. VARCHAR2 Required.

p_publish_sync

Procedure p_publish_sync(p_operation_type VARCHAR2,
                         p_message_exists OUT VARCHAR2)

Procedure to publish the synchronized data.

Parameters

	p_operation_type	The operation type. Valid values are INSERT, UPDATE and DELETE. VARCHAR2 Required.
	message_exists	Indicating message exists or not. Valid values are Y and N. VARCHAR2 Required.

p_populate_globals

Procedure p_populate_globals(p_rowid VARCHAR2, new_or_old VARCHAR2)

Procedure to populate global variables.

Parameters

	p_rowid	Rowid of chart of accounts record. VARCHAR2 Required.
	new_or_old	Indicator for fetcing chart of accounts record into new or old record. VARCHAR2 Required.

p_set_globals_null

Procedure p_set_globals_null

Procedure to assign null values to global variables.

p_register_entity

Procedure p_register_entity(p_operation_type         NUMBER,
                            p_coas_code              FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                            p_title                  FTVCOAS.FTVCOAS_TITLE%TYPE,
                            p_eff_date               FTVCOAS.FTVCOAS_EFF_DATE%TYPE,
                            p_status_ind             FTVCOAS.FTVCOAS_STATUS_IND%TYPE,
                            p_activity_date          FTVCOAS.FTVCOAS_ACTIVITY_DATE%TYPE DEFAULT SYSDATE,
                            p_user_id                FTVCOAS.FTVCOAS_USER_ID%TYPE DEFAULT gb_common.f_sct_user,
                            p_nchg_date              FTVCOAS.FTVCOAS_NCHG_DATE%TYPE DEFAULT NULL,
                            p_cal_start_month        FTVCOAS.FTVCOAS_CAL_START_MONTH%TYPE DEFAULT NULL,
                            p_cal_start_day          FTVCOAS.FTVCOAS_CAL_START_DAY%TYPE DEFAULT NULL,
                            p_cal_end_month          FTVCOAS.FTVCOAS_CAL_END_MONTH%TYPE DEFAULT NULL,
                            p_cal_end_day            FTVCOAS.FTVCOAS_CAL_END_DAY%TYPE DEFAULT NULL,
                            p_meth_of_acctg          FTVCOAS.FTVCOAS_METH_OF_ACCTG%TYPE DEFAULT NULL,
                            p_bavl_key_fund          FTVCOAS.FTVCOAS_BAVL_KEY_FUND%TYPE DEFAULT NULL,
                            p_bavl_key_orgn          FTVCOAS.FTVCOAS_BAVL_KEY_ORGN%TYPE DEFAULT NULL,
                            p_bavl_key_acct          FTVCOAS.FTVCOAS_BAVL_KEY_ACCT%TYPE DEFAULT NULL,
                            p_bavl_key_prog          FTVCOAS.FTVCOAS_BAVL_KEY_PROG%TYPE DEFAULT NULL,
                            p_bavl_period            FTVCOAS.FTVCOAS_BAVL_PERIOD%TYPE DEFAULT NULL,
                            p_bavl_severity          FTVCOAS.FTVCOAS_BAVL_SEVERITY%TYPE DEFAULT NULL,
                            p_rucl_code_roll_enc     FTVCOAS.FTVCOAS_RUCL_CODE_ROLL_ENC%TYPE DEFAULT NULL,
                            p_commit_type            FTVCOAS.FTVCOAS_COMMIT_TYPE%TYPE DEFAULT NULL,
                            p_budget_roll            FTVCOAS.FTVCOAS_BUDGET_ROLL%TYPE DEFAULT NULL,
                            p_budget_disposition     FTVCOAS.FTVCOAS_BUDGET_DISPOSITION%TYPE DEFAULT NULL,
                            p_budget_roll_percent    FTVCOAS.FTVCOAS_BUDGET_ROLL_PERCENT%TYPE DEFAULT NULL,
                            p_rucl_code_budg_cf      FTVCOAS.FTVCOAS_RUCL_CODE_BUDG_CF%TYPE DEFAULT NULL,
                            p_budg_cf_type           FTVCOAS.FTVCOAS_BUDG_CF_TYPE%TYPE DEFAULT NULL,
                            p_budg_classification    FTVCOAS.FTVCOAS_BUDG_CLASSIFICATION%TYPE DEFAULT NULL,
                            p_budg_cf_percent        FTVCOAS.FTVCOAS_BUDG_CF_PERCENT%TYPE DEFAULT NULL,
                            p_rucl_code_close_op     FTVCOAS.FTVCOAS_RUCL_CODE_CLOSE_OP%TYPE DEFAULT NULL,
                            p_roll_enc_ind           FTVCOAS.FTVCOAS_ROLL_ENC_IND%TYPE DEFAULT NULL,
                            p_roll_po_ind            FTVCOAS.FTVCOAS_ROLL_PO_IND%TYPE DEFAULT NULL,
                            p_roll_memo_res_ind      FTVCOAS.FTVCOAS_ROLL_MEMO_RES_IND%TYPE DEFAULT NULL,
                            p_roll_req_ind           FTVCOAS.FTVCOAS_ROLL_REQ_IND%TYPE DEFAULT NULL,
                            p_roll_labor_enc_ind     FTVCOAS.FTVCOAS_ROLL_LABOR_ENC_IND%TYPE DEFAULT NULL,
                            p_roll_wo_ind            FTVCOAS.FTVCOAS_ROLL_WO_IND%TYPE DEFAULT NULL,
                            p_term_date              FTVCOAS.FTVCOAS_TERM_DATE%TYPE DEFAULT NULL,
                            p_acct_code_fund_due_to  FTVCOAS.FTVCOAS_ACCT_CODE_FUND_DUE_TO%TYPE DEFAULT NULL,
                            p_acct_code_fund_due_frm FTVCOAS.FTVCOAS_ACCT_CODE_FUND_DUE_FRM%TYPE DEFAULT NULL,
                            p_acct_code_fund_bal     FTVCOAS.FTVCOAS_ACCT_CODE_FUND_BAL%TYPE DEFAULT NULL,
                            p_acct_code_accrual_ap   FTVCOAS.FTVCOAS_ACCT_CODE_ACCRUAL_AP%TYPE DEFAULT NULL,
                            p_acct_code_accrual_ar   FTVCOAS.FTVCOAS_ACCT_CODE_ACCRUAL_AR%TYPE DEFAULT NULL,
                            p_current_year_income    FTVCOAS.FTVCOAS_CURRENT_YEAR_INCOME%TYPE DEFAULT NULL,
                            p_acct_code_trf_income   FTVCOAS.FTVCOAS_ACCT_CODE_TRF_INCOME%TYPE DEFAULT NULL,
                            p_orgn_code_trf_income   FTVCOAS.FTVCOAS_ORGN_CODE_TRF_INCOME%TYPE DEFAULT NULL,
                            p_prog_code_trf_income   FTVCOAS.FTVCOAS_PROG_CODE_TRF_INCOME%TYPE DEFAULT NULL,
                            p_py_retained_income     FTVCOAS.FTVCOAS_PY_RETAINED_INCOME%TYPE DEFAULT NULL,
                            p_acct_code_trf_ri_py    FTVCOAS.FTVCOAS_ACCT_CODE_TRF_RI_PY%TYPE DEFAULT NULL,
                            p_orgn_code_trf_ri_py    FTVCOAS.FTVCOAS_ORGN_CODE_TRF_RI_PY%TYPE DEFAULT NULL,
                            p_prog_code_trf_ri_py    FTVCOAS.FTVCOAS_PROG_CODE_TRF_RI_PY%TYPE DEFAULT NULL,
                            p_real_gl                FTVCOAS.FTVCOAS_REAL_GL%TYPE DEFAULT NULL,
                            p_acct_code_trf_rgl      FTVCOAS.FTVCOAS_ACCT_CODE_TRF_RGL%TYPE DEFAULT NULL,
                            p_orgn_code_trf_rgl      FTVCOAS.FTVCOAS_ORGN_CODE_TRF_RGL%TYPE DEFAULT NULL,
                            p_prog_code_trf_rgl      FTVCOAS.FTVCOAS_PROG_CODE_TRF_RGL%TYPE DEFAULT NULL,
                            p_real_gl_py             FTVCOAS.FTVCOAS_REAL_GL_PY%TYPE DEFAULT NULL,
                            p_acct_code_trf_rgl_py   FTVCOAS.FTVCOAS_ACCT_CODE_TRF_RGL_PY%TYPE DEFAULT NULL,
                            p_orgn_code_trf_rgl_py   FTVCOAS.FTVCOAS_ORGN_CODE_TRF_RGL_PY%TYPE DEFAULT NULL,
                            p_prog_code_trf_rgl_py   FTVCOAS.FTVCOAS_PROG_CODE_TRF_RGL_PY%TYPE DEFAULT NULL,
                            p_fund_attribute_ind     FTVCOAS.FTVCOAS_FUND_ATTRIBUTE_IND%TYPE DEFAULT NULL,
                            p_orgn_attribute_ind     FTVCOAS.FTVCOAS_ORGN_ATTRIBUTE_IND%TYPE DEFAULT NULL,
                            p_acct_attribute_ind     FTVCOAS.FTVCOAS_ACCT_ATTRIBUTE_IND%TYPE DEFAULT NULL,
                            p_prog_attribute_ind     FTVCOAS.FTVCOAS_PROG_ATTRIBUTE_IND%TYPE DEFAULT NULL,
                            p_actv_attribute_ind     FTVCOAS.FTVCOAS_ACTV_ATTRIBUTE_IND%TYPE DEFAULT NULL,
                            p_locn_attribute_ind     FTVCOAS.FTVCOAS_LOCN_ATTRIBUTE_IND%TYPE DEFAULT NULL
                            
                            )

Registers the attribute value pairs to the message cache.

Parameters

	p_operation_type	The operation type. VARCHAR2 Required.
	p_coas_code	Chart of accounts code. VARCHAR2(1) Required.
	p_title	Chart title. VARCHAR2(35) Required.
	p_eff_date	Chart effective date. Date Required.
	p_status_ind	Chart status indicater. VARCHAR2(1) Required.
	p_activity_date	Chart activity date. Date.
	p_user_id	User ID. VARCHAR2(30).
	p_nchg_date	Next change date. Date.
	p_cal_start_month	Fiscal year start month. VARCHAR2(2).
	p_cal_start_day	Fiscal year start day. VARCHAR2(2).
	p_cal_end_month	Fiscal year end month. VARCHAR2(2).
	p_cal_end_day	Fiscal year end day. VARCHAR2(2).
	p_meth_of_acctg	Method of accounting. VARCHAR2(1).
	p_bavl_key_fund	Fund budget key. VARCHAR2(1).
	p_bavl_key_orgn	Organization budget key. VARCHAR2(1).
	p_bavl_key_acct	Account budget key. VARCHAR2(1).
	p_bavl_key_prog	Program budget key. VARCHAR2(1).
	p_bavl_period	Budget control period. VARCHAR2(1).
	p_bavl_severity	Budget control severity VARCHAR2(1).
	p_rucl_code_roll_enc	Roll encumbrances rule class. VARCHAR2(4).
	p_commit_type	Commitment type. VARCHAR2(1).
	p_budget_roll	Budget roll. VARCHAR2(1).
	p_budget_disposition	Buddget disposition. VARCHAR2(1).
	p_budget_roll_percent	Encumbrance budget roll percentage. NUMBER(6,3).
	p_rucl_code_budg_cf	Budget roll rule code. VARCHAR2(4).
	p_budg_cf_type	Budget type indicator VARCHAR2(1).
	p_budg_classification	Buddget classification. VARCHAR2(1).
	p_budg_cf_percent	Budget percentage to be carried forward NUMBER(6,3).
	p_rucl_code_close_op	Close operating ledger rule class. VARCHAR2(4).
	p_roll_enc_ind	Roll encumbrance indicator. VARCHAR2(1).
	p_roll_po_ind	Roll purchase order indicator. VARCHAR2(1).
	p_roll_memo_res_ind	Roll memo reservation indicator. VARCHAR2(1).
	p_roll_req_ind	Roll requisition indicator. VARCHAR2(1).
	p_roll_labor_enc_ind	Roll labor encumbrance indicator. VARCHAR2(1).
	p_roll_wo_ind	Roll work order indicator. VARCHAR2(1).
	p_term_date	Termination date. Date.
	p_acct_code_fund_due_to	Due to account code. VARCHAR2(6).
	p_acct_code_fund_due_frm	From account code. VARCHAR2(6).
	p_acct_code_fund_bal	Fund balance account code. VARCHAR2(6).
	p_acct_code_accrual_ap	Accounts payable accrual account code. VARCHAR2(6).
	p_acct_code_accrual_ar	Accounts receivable accrual account code. VARCHAR2(6).
	p_current_year_income	Current year income. NUMBER(1).
	p_acct_code_trf_income	Current year income transfer account. VARCHAR2(6).
	p_orgn_code_trf_income	Current year income transfer organization. VARCHAR2(6).
	p_prog_code_trf_income	Current year income transfer program. VARCHAR2(6).
	p_py_retained_income	Prior year retained income. NUMBER(1).
	p_acct_code_trf_ri_py	rior year retained income transfer account. VARCHAR2(6).
	p_orgn_code_trf_ri_py	rior year retained income transfer organization. VARCHAR2(6).
	p_prog_code_trf_ri_py	rior year retained income transfer program. VARCHAR2(6).
	p_real_gl	Realized gains/loss. NUMBER(1).
	p_acct_code_trf_rgl	Realized gains/loss transfer account. VARCHAR2(6).
	p_orgn_code_trf_rgl	Realized gains/loss transfer organization. VARCHAR2(6).
	p_prog_code_trf_rgl	Realized gains/loss transfer program. VARCHAR2(6).
	p_real_gl_py	Prior year realized gains/loss. NUMBER(1).
	p_acct_code_trf_rgl_py	Prior year realized gains/loss transfer account. VARCHAR2(6).
	p_orgn_code_trf_rgl_py	Prior year realized gains/loss transfer organization. VARCHAR2(6).
	p_prog_code_trf_rgl_py	Prior year realized gains/loss transfer program. VARCHAR2(6).
	p_fund_attribute_ind	Fund attribute indicator. VARCHAR2(1).
	p_orgn_attribute_ind	Organization attribute indicator. VARCHAR2(1).
	p_acct_attribute_ind	Account attribute indicator. VARCHAR2(1).
	p_prog_attribute_ind	Program attribute indicator. VARCHAR2(1).
	p_actv_attribute_ind	Activity attribute indicator. VARCHAR2(1).
	p_locn_attribute_ind	Location attribute indicator. VARCHAR2(1).

p_validate

Procedure p_validate

Placeholder procedure that does nothing currently.