index

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.