|
Package baninst1.ffkfoap Common procedures to validate foapal elements (FFKFOAP). |
| Program units |
| p_edit_table_status | Tests if a status is active. |
| p_edit_table_entry | Tests if data entry is allowed. |
| p_edit_coas_code | Checks if a chart of accounts is valid and has active status. |
| p_edit_fund_code | Checks to if a fund is valid, has active status and is allowed for data entry. |
| p_edit_orgn_code | Checks if an organization is valid, has active status and is allowed for data entry. |
| f_get_intern_atyp | Tests if an account type matches an internal account type. |
| p_edit_acct_code | Checks if a fund is valid, has active status, is allowed for data entry and match a given account type. |
| p_edit_prog_code | Checks if a program is valid, has active status and is allowed for data entry. |
| p_edit_locn_code | Checks if a location is valid and has active status. |
| p_edit_actv_code | Checks if an activity is valid and has active status. |
| p_edit_proj_code | Checks if a project is valid, has been completed or posted. |
| p_edit_bank_code | Checks if a bank is valid, has active status, matches a given chart and retrieves the bank account name. |
| p_edit_rucl_code | Checks if a rule class code is valid, active and if the user has authority to post it. |
| p_edit_acci_code | Checks if an index is valid, active and retrieves its defaulting foapal elements and their override indicators. |
| p_validate_Coas | Validates a chart of accounts code and checks if its status is active. |
| p_validate_acci | This procedure calls p_get_default_foapal to perform complex foapal defaulting logic. |
| p_validate_fund | Validates a fund, checks if it is active, allowed for data entry and if the user has authority to post beyond its termination date.. |
| p_validate_orgn | Validates an organization, checks if it is active and allowed for data entry. |
| p_validate_acct | Validates an account, checks if it is active, allowed for data entry and has an internal account type. |
| p_validate_prog | Validates a program, checks if it is active and allowed for data entry. |
| p_validate_actv | Validates an activity, checks if it is active. |
| p_validate_locn | Validates a location, checks if it is active. |
| p_get_default_foapal | Gets the defaults from the account index code and the fund and org codes if they are present. |
| p_validate_foapal | Validates the passed in foapal elements and get defaulting foapal elements from the passed in values. |
| p_validate_accounting | Validates the accounting elements. |
p_edit_table_status
Procedure p_edit_table_status(code varchar2,
test_status_ind varchar2,
mess in out varchar2,
foapal_id in varchar2 default null)
Tests if a status is active.
p_edit_table_entry
Procedure p_edit_table_entry(code varchar2,
test_data_entry_ind varchar2,
mess in out varchar2)
Tests if data entry is allowed.
p_edit_coas_code
Procedure p_edit_coas_code(effdate_eff_date_time varchar2,
coas_code varchar2,
mess in out varchar2)
Checks if a chart of accounts is valid and has active status.
p_edit_fund_code
Procedure p_edit_fund_code(effdate_eff_date_time varchar2,
fund_code varchar2,
coas_code varchar2,
mess in out varchar2,
fund_title varchar2)
Checks to if a fund is valid, has active status and is allowed for data entry.
p_edit_orgn_code
Procedure p_edit_orgn_code(effdate_eff_date_time varchar2,
orgn_code varchar2,
coas_code varchar2,
mess in out varchar2,
orgn_title varchar2,
check_orgn_null_ind varchar2)
Checks if an organization is valid, has active status and is allowed for data entry.
f_get_intern_atyp
Function f_get_intern_atyp(atyp_code varchar2,
int_atyp_code varchar2,
coas_code varchar2 default NULL)
return boolean
Tests if an account type matches an internal account type.
p_edit_acct_code
Procedure p_edit_acct_code(effdate_eff_date_time varchar2,
acct_code varchar2,
coas_code varchar2,
mess in out varchar2,
acct_title varchar2,
int_atyp_code varchar2)
Checks if a fund is valid, has active status, is allowed for data entry and match a given account type.
p_edit_prog_code
Procedure p_edit_prog_code(effdate_eff_date_time varchar2,
prog_code varchar2,
coas_code varchar2,
mess in out varchar2,
prog_title varchar2,
check_prog_null_ind varchar2)
Checks if a program is valid, has active status and is allowed for data entry.
p_edit_locn_code
Procedure p_edit_locn_code(effdate_eff_date_time varchar2,
locn_code varchar2,
coas_code varchar2,
mess in out varchar2,
locn_title varchar2)
Checks if a location is valid and has active status.
p_edit_actv_code
Procedure p_edit_actv_code(effdate_eff_date_time varchar2,
actv_code varchar2,
coas_code varchar2,
mess in out varchar2,
actv_title varchar2)
Checks if an activity is valid and has active status.
p_edit_proj_code
Procedure p_edit_proj_code(effdate_eff_date_time varchar2,
proj_code varchar2,
coas_code varchar2,
mess in out varchar2,
proj_title varchar2)
Checks if a project is valid, has been completed or posted.
p_edit_bank_code
Procedure p_edit_bank_code(effdate_eff_date_time varchar2,
bank_code varchar2,
coas_code varchar2,
mess in out varchar2,
check_bank_null_ind varchar2,
acct_name out varchar2)
Checks if a bank is valid, has active status, matches a given chart and retrieves the bank account name.
p_edit_rucl_code
Procedure p_edit_rucl_code(effdate_eff_date_time varchar2,
rucl_code varchar2,
global_rucl_sec_ind varchar2,
current_form varchar2,
current_user varchar2,
mess in out varchar2,
class_type out varchar2)
Checks if a rule class code is valid, active and if the user has authority to post it. Also retrieves the class type.
p_edit_acci_code
Procedure p_edit_acci_code(effdate_eff_date_time varchar2,
acci_code varchar2,
coas_code varchar2,
hold_fund_code in out varchar2,
hold_orgn_code in out varchar2,
hold_acct_code in out varchar2,
hold_prog_code in out varchar2,
hold_actv_code in out varchar2,
hold_locn_code in out varchar2,
fund_override in out varchar2,
orgn_override in out varchar2,
acct_override in out varchar2,
prog_override in out varchar2,
actv_override in out varchar2,
locn_override in out varchar2,
mess in out varchar2)
Checks if an index is valid, active and retrieves its defaulting foapal elements and their override indicators.
p_validate_Coas
Procedure p_validate_Coas(transdate DATE,
coas VARCHAR2,
mess IN OUT VARCHAR2,
check_status VARCHAR2 DEFAULT 'Y')
Validates a chart of accounts code and checks if its status is active.
p_validate_acci
Procedure p_validate_acci(transdate DATE,
coas VARCHAR2,
acci VARCHAR2,
hold_fund IN OUT VARCHAR2,
hold_orgn IN OUT VARCHAR2,
hold_acct IN OUT VARCHAR2,
hold_prog IN OUT VARCHAR2,
hold_actv IN OUT VARCHAR2,
hold_locn IN OUT VARCHAR2,
mess IN OUT VARCHAR2,
err_prefix_reqd VARCHAR2 default 'Y',
default_if_null VARCHAR2 default 'Y')
This procedure calls p_get_default_foapal to perform complex foapal defaulting logic.
p_validate_fund
Procedure p_validate_fund(transdate DATE,
coas VARCHAR2,
fund VARCHAR2,
mess IN OUT VARCHAR2,
check_status VARCHAR2 DEFAULT 'Y',
check_dataentry VARCHAR2 DEFAULT 'Y',
user_id VARCHAR2 DEFAULT gb_common.f_sct_user,
check_user_auth VARCHAR2 DEFAULT 'Y')
Validates a fund, checks if it is active, allowed for data entry and if the user has authority to post beyond its termination date..
p_validate_orgn
Procedure p_validate_orgn(transdate DATE,
coas VARCHAR2,
orgn VARCHAR2,
mess IN OUT VARCHAR2,
check_status VARCHAR2 DEFAULT 'Y',
check_dataentry VARCHAR2 DEFAULT 'Y')
Validates an organization, checks if it is active and allowed for data entry.
p_validate_acct
Procedure p_validate_acct(transdate DATE,
coas VARCHAR2,
acct VARCHAR2,
mess IN OUT VARCHAR2,
check_status VARCHAR2 DEFAULT 'Y',
check_dataentry VARCHAR2 DEFAULT 'Y')
Validates an account, checks if it is active, allowed for data entry and has an internal account type.
p_validate_prog
Procedure p_validate_prog(transdate DATE,
coas VARCHAR2,
prog VARCHAR2,
mess IN OUT VARCHAR2,
check_status VARCHAR2 DEFAULT 'Y',
check_dataentry VARCHAR2 DEFAULT 'Y')
Validates a program, checks if it is active and allowed for data entry.
p_validate_actv
Procedure p_validate_actv(transdate DATE,
coas VARCHAR2,
actv VARCHAR2,
mess IN OUT VARCHAR2,
check_status VARCHAR2 DEFAULT 'Y')
Validates an activity, checks if it is active.
p_validate_locn
Procedure p_validate_locn(transdate DATE,
coas VARCHAR2,
locn VARCHAR2,
mess IN OUT VARCHAR2,
check_status VARCHAR2 DEFAULT 'Y')
Validates a location, checks if it is active.
p_get_default_foapal
Procedure p_get_default_foapal(chart_code varchar2,
trans_date date,
acci_code varchar2,
fund_code in out varchar2,
orgn_code in out varchar2,
acct_code in out varchar2,
prog_code in out varchar2,
actv_code in out varchar2,
locn_code in out varchar2,
err_prefix_reqd varchar2 default 'Y',
default_if_null varchar2 default 'Y',
stop_at_acci varchar2 default 'N',
error_mesg out varchar2)
Gets the defaults from the account index code and the fund and org codes if they are present. For eg. when an organization code is passed, the fund, program and activity defaults from the organization codes are selected and passed out. The logic is the same as that executed by the transaction interface process (FGRTRNI)
p_validate_foapal
Procedure p_validate_foapal(coas VARCHAR2,
acci VARCHAR2,
fund IN OUT VARCHAR2,
orgn IN OUT VARCHAR2,
acct IN OUT VARCHAR2,
prog IN OUT VARCHAR2,
actv IN OUT VARCHAR2,
locn IN OUT VARCHAR2,
transdate DATE,
valid_ind IN OUT VARCHAR2,
message IN OUT VARCHAR2,
err_prefix_reqd varchar2 default 'Y',
default_if_null varchar2 default 'Y',
jv_ind varchar2 default 'N',
user_id IN VARCHAR2 DEFAULT gb_common.f_sct_user,
check_user_auth IN VARCHAR2 DEFAULT 'Y')
Validates the passed in foapal elements and get defaulting foapal elements from the passed in values.
p_validate_accounting
Procedure p_validate_accounting(p_coas_in VARCHAR2,
p_acci_in VARCHAR2,
p_fund_inout IN OUT VARCHAR2,
p_orgn_inout IN OUT VARCHAR2,
p_acct_inout IN OUT VARCHAR2,
p_prog_inout IN OUT VARCHAR2,
p_actv_inout IN OUT VARCHAR2,
p_locn_inout IN OUT VARCHAR2,
p_transdate_in DATE,
p_rucl_code_in VARCHAR2,
p_rucl_type_in VARCHAR2 default NULL,
p_curr_form_in VARCHAR2 default NULL,
p_user_id_in VARCHAR2 default USER,
p_add_err_prefix VARCHAR2 default 'N',
p_default_if_null VARCHAR2 default 'N',
p_valid_ind_out OUT VARCHAR2,
p_err_message_out OUT VARCHAR2,
p_jv_ind VARCHAR2 default 'N',
p_check_user_auth VARCHAR2 DEFAULT 'Y')
Validates the accounting elements.
Validate rule class and security.
Check fund/orgn security.
Rule class and Fund/Orgn security are not imposed on Interface Documents, and user authority for expenditure end date is not checked.