Package BANINST1.fb_chart_of

Package BANINST1.fb_chart_of_accounts

Common Business interface for chart of accounts information (FB_CHART_OF_ACCOUNTS).

Program units

f_current_version	Returns the current version number.
f_exists	Checks to see if a record exists without checking for active status.
f_exists_active	Checks to see if an active record exists.
f_query_all	Selects all chart records.
f_query_one	Selects one record using unique columns.

Types

coas_rec	Chart of accounts record type
coas_ref	Chart of accounts reference cursor
coas_tab	Chart of accounts table type

coas_rec

TYPE coas_rec IS RECORD (
   COAS_CODE                       FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
   EFF_DATE                        FTVCOAS.FTVCOAS_EFF_DATE%TYPE,
   ACTIVITY_DATE                   FTVCOAS.FTVCOAS_ACTIVITY_DATE%TYPE,
   USER_ID                         FTVCOAS.FTVCOAS_USER_ID%TYPE,
   NCHG_DATE                       FTVCOAS.FTVCOAS_NCHG_DATE%TYPE,
   TITLE                           FTVCOAS.FTVCOAS_TITLE%TYPE,
   STATUS_IND                      FTVCOAS.FTVCOAS_STATUS_IND%TYPE,
   CAL_START_MONTH                 FTVCOAS.FTVCOAS_CAL_START_MONTH%TYPE,
   CAL_START_DAY                   FTVCOAS.FTVCOAS_CAL_START_DAY%TYPE,
   CAL_END_MONTH                   FTVCOAS.FTVCOAS_CAL_END_MONTH%TYPE,
   CAL_END_DAY                     FTVCOAS.FTVCOAS_CAL_END_DAY%TYPE,
   METH_OF_ACCTG                   FTVCOAS.FTVCOAS_METH_OF_ACCTG%TYPE,
   BAVL_KEY_FUND                   FTVCOAS.FTVCOAS_BAVL_KEY_FUND%TYPE,
   BAVL_KEY_ORGN                   FTVCOAS.FTVCOAS_BAVL_KEY_ORGN%TYPE,
   BAVL_KEY_ACCT                   FTVCOAS.FTVCOAS_BAVL_KEY_ACCT%TYPE,
   BAVL_KEY_PROG                   FTVCOAS.FTVCOAS_BAVL_KEY_PROG%TYPE,
   BAVL_PERIOD                     FTVCOAS.FTVCOAS_BAVL_PERIOD%TYPE,
   BAVL_SEVERITY                   FTVCOAS.FTVCOAS_BAVL_SEVERITY%TYPE,
   RUCL_CODE_ROLL_ENC              FTVCOAS.FTVCOAS_RUCL_CODE_ROLL_ENC%TYPE,
   COMMIT_TYPE                     FTVCOAS.FTVCOAS_COMMIT_TYPE%TYPE,
   BUDGET_ROLL                     FTVCOAS.FTVCOAS_BUDGET_ROLL%TYPE,
   BUDGET_DISPOSITION              FTVCOAS.FTVCOAS_BUDGET_DISPOSITION%TYPE,
   BUDGET_ROLL_PERCENT             FTVCOAS.FTVCOAS_BUDGET_ROLL_PERCENT%TYPE,
   RUCL_CODE_BUDG_CF               FTVCOAS.FTVCOAS_RUCL_CODE_BUDG_CF%TYPE,
   BUDG_CF_TYPE                    FTVCOAS.FTVCOAS_BUDG_CF_TYPE%TYPE,
   BUDG_CLASSIFICATION             FTVCOAS.FTVCOAS_BUDG_CLASSIFICATION%TYPE,
   BUDG_CF_PERCENT                 FTVCOAS.FTVCOAS_BUDG_CF_PERCENT%TYPE,
   RUCL_CODE_CLOSE_OP              FTVCOAS.FTVCOAS_RUCL_CODE_CLOSE_OP%TYPE,
   ROLL_ENC_IND                    FTVCOAS.FTVCOAS_ROLL_ENC_IND%TYPE,
   ROLL_PO_IND                     FTVCOAS.FTVCOAS_ROLL_PO_IND%TYPE,
   ROLL_MEMO_RES_IND               FTVCOAS.FTVCOAS_ROLL_MEMO_RES_IND%TYPE,
   ROLL_REQ_IND                    FTVCOAS.FTVCOAS_ROLL_REQ_IND%TYPE,
   ROLL_LABOR_ENC_IND              FTVCOAS.FTVCOAS_ROLL_LABOR_ENC_IND%TYPE,
   ROLL_WO_IND                     FTVCOAS.FTVCOAS_ROLL_WO_IND%TYPE,
   TERM_DATE                       FTVCOAS.FTVCOAS_TERM_DATE%TYPE,
   ACCT_CODE_FUND_DUE_TO           FTVCOAS.FTVCOAS_ACCT_CODE_FUND_DUE_TO%TYPE,
   ACCT_CODE_FUND_DUE_FRM          FTVCOAS.FTVCOAS_ACCT_CODE_FUND_DUE_FRM%TYPE,
   ACCT_CODE_FUND_BAL              FTVCOAS.FTVCOAS_ACCT_CODE_FUND_BAL%TYPE,
   ACCT_CODE_ACCRUAL_AP            FTVCOAS.FTVCOAS_ACCT_CODE_ACCRUAL_AP%TYPE,
   ACCT_CODE_ACCRUAL_AR            FTVCOAS.FTVCOAS_ACCT_CODE_ACCRUAL_AR%TYPE,
   CURRENT_YEAR_INCOME             FTVCOAS.FTVCOAS_CURRENT_YEAR_INCOME%TYPE,
   ACCT_CODE_TRF_INCOME            FTVCOAS.FTVCOAS_ACCT_CODE_TRF_INCOME%TYPE,
   ORGN_CODE_TRF_INCOME            FTVCOAS.FTVCOAS_ORGN_CODE_TRF_INCOME%TYPE,
   PROG_CODE_TRF_INCOME            FTVCOAS.FTVCOAS_PROG_CODE_TRF_INCOME%TYPE,
   PY_RETAINED_INCOME              FTVCOAS.FTVCOAS_PY_RETAINED_INCOME%TYPE,
   ACCT_CODE_TRF_RI_PY             FTVCOAS.FTVCOAS_ACCT_CODE_TRF_RI_PY%TYPE,
   ORGN_CODE_TRF_RI_PY             FTVCOAS.FTVCOAS_ORGN_CODE_TRF_RI_PY%TYPE,
   PROG_CODE_TRF_RI_PY             FTVCOAS.FTVCOAS_PROG_CODE_TRF_RI_PY%TYPE,
   REAL_GL                         FTVCOAS.FTVCOAS_REAL_GL%TYPE,
   ACCT_CODE_TRF_RGL               FTVCOAS.FTVCOAS_ACCT_CODE_TRF_RGL%TYPE,
   ORGN_CODE_TRF_RGL               FTVCOAS.FTVCOAS_ORGN_CODE_TRF_RGL%TYPE,
   PROG_CODE_TRF_RGL               FTVCOAS.FTVCOAS_PROG_CODE_TRF_RGL%TYPE,
   REAL_GL_PY                      FTVCOAS.FTVCOAS_REAL_GL_PY%TYPE,
   ACCT_CODE_TRF_RGL_PY            FTVCOAS.FTVCOAS_ACCT_CODE_TRF_RGL_PY%TYPE,
   ORGN_CODE_TRF_RGL_PY            FTVCOAS.FTVCOAS_ORGN_CODE_TRF_RGL_PY%TYPE,
   PROG_CODE_TRF_RGL_PY            FTVCOAS.FTVCOAS_PROG_CODE_TRF_RGL_PY%TYPE,
   FUND_ATTRIBUTE_IND              FTVCOAS.FTVCOAS_FUND_ATTRIBUTE_IND%TYPE,
   ORGN_ATTRIBUTE_IND              FTVCOAS.FTVCOAS_ORGN_ATTRIBUTE_IND%TYPE,
   ACCT_ATTRIBUTE_IND              FTVCOAS.FTVCOAS_ACCT_ATTRIBUTE_IND%TYPE,
   PROG_ATTRIBUTE_IND              FTVCOAS.FTVCOAS_PROG_ATTRIBUTE_IND%TYPE,
   ACTV_ATTRIBUTE_IND              FTVCOAS.FTVCOAS_ACTV_ATTRIBUTE_IND%TYPE,
   LOCN_ATTRIBUTE_IND              FTVCOAS.FTVCOAS_LOCN_ATTRIBUTE_IND%TYPE,
   INTERNAL_RECORD_ID              VARCHAR2(18));

Chart of accounts record type

coas_ref

TYPE coas_ref IS REF CURSOR RETURN coas_rec;

Chart of accounts reference cursor

coas_tab

TYPE coas_tab IS TABLE OF coas_rec INDEX BY BINARY_INTEGER;

Chart of accounts table type

f_current_version

Function f_current_version RETURN VARCHAR2

Returns the current version number.

Returns

Version of the API signature. Changes only when the signature changes.

f_exists

Function f_exists(p_code     FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                  p_eff_date FTVCOAS.FTVCOAS_EFF_DATE%TYPE DEFAULT SYSDATE)
  RETURN BOOLEAN

Checks to see if a record exists without checking for active status.

Parameters

	p_code	The chart of accounts code. VARCHAR2(1) Required.
	p_eff_date	The effective date of the chart. Date.

Returns

TRUE if found, otherwise FALSE.

f_exists_active

Function f_exists_active(p_code     FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                         p_eff_date FTVCOAS.FTVCOAS_EFF_DATE%TYPE DEFAULT SYSDATE)
  RETURN BOOLEAN

Checks to see if an active record exists.

Parameters

	p_code	The chart of accounts code. VARCHAR2(1) Required.
	p_eff_date	The effective date of the chart. Date.

Returns

TRUE if found, otherwise FALSE.

f_query_all

Function f_query_all(p_eff_date FTVCOAS.FTVCOAS_EFF_DATE%TYPE DEFAULT SYSDATE,
                     p_status   VARCHAR2 DEFAULT 'A') RETURN coas_ref

Selects all chart records.

Parameters

	p_eff_date	The effective date. Date.
	p_status	The status indicator. p_status can be 'A' for Active, 'I' for Inactive and 'ALL' for either status.VARCHAR2.

Returns

A cursor variable that will fetch the set of records.

f_query_one

Function f_query_one(p_code     FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                     p_eff_date FTVCOAS.FTVCOAS_EFF_DATE%TYPE DEFAULT SYSDATE)
  RETURN coas_ref

Selects one record using unique columns.

Parameters

	p_code	The chart of accounts code. VARCHAR2(1) Required.
	p_eff_date	The effective date of the chart. Date.

Returns

A cursor variable that will fetch exactly one record.