index

Package BANINST1.fb_jv_detail_rules

Support subprograms for JV_DETAIL.
 
Note that the p_register_entity procedures commonly found in the API Rules package are not included, as Event Registration for Journal Vouchers occurs only at the document level through fp_journal_voucher.

Program units
p_process_edit_rulp   Procedure to process Rule Class editing.
p_valid_create   Validates data entered, sets defaults, and processes edits and security for insert.
p_valid_update   Validates data entered, and processes edits for update.

p_process_edit_rulp 

Procedure p_process_edit_rulp(p_rucl_code              fgbjvcd.fgbjvcd_rucl_code%TYPE,
                              p_trans_date             fgbjvch.fgbjvch_trans_date%TYPE,
                              p_doc_num                fgbjvcd.fgbjvcd_doc_num%TYPE,
                              p_submission_number      fgbjvcd.fgbjvcd_submission_number%TYPE,
                              p_seq_num                fgbjvcd.fgbjvcd_seq_num%TYPE,
                              p_user_id                fgbjvcd.fgbjvcd_user_id%TYPE,
                              p_auto_jrnl_id           fgbjvch.fgbjvch_auto_jrnl_id%TYPE,
                              p_reversal_ind           fgbjvch.fgbjvch_reversal_ind%TYPE,
                              p_fsyr_code_in_out       IN OUT fgbjvcd.fgbjvcd_fsyr_code%TYPE,
                              p_trans_amt_in_out       IN OUT fgbjvcd.fgbjvcd_trans_amt%TYPE,
                              p_trans_desc_in_out      IN OUT fgbjvcd.fgbjvcd_trans_desc%TYPE,
                              p_dr_cr_ind_in_out       IN OUT fgbjvcd.fgbjvcd_dr_cr_ind%TYPE,
                              p_acci_code_in_out       IN OUT fgbjvcd.fgbjvcd_acci_code%TYPE,
                              p_coas_code_in_out       IN OUT fgbjvcd.fgbjvcd_coas_code%TYPE,
                              p_fund_code_in_out       IN OUT fgbjvcd.fgbjvcd_fund_code%TYPE,
                              p_orgn_code_in_out       IN OUT fgbjvcd.fgbjvcd_orgn_code%TYPE,
                              p_acct_code_in_out       IN OUT fgbjvcd.fgbjvcd_acct_code%TYPE,
                              p_prog_code_in_out       IN OUT fgbjvcd.fgbjvcd_prog_code%TYPE,
                              p_actv_code_in_out       IN OUT fgbjvcd.fgbjvcd_actv_code%TYPE,
                              p_locn_code_in_out       IN OUT fgbjvcd.fgbjvcd_locn_code%TYPE,
                              p_bank_code_in_out       IN OUT fgbjvcd.fgbjvcd_bank_code%TYPE,
                              p_doc_ref_num_in_out     IN OUT fgbjvcd.fgbjvcd_doc_ref_num%TYPE,
                              p_vendor_pidm_in_out     IN OUT fgbjvcd.fgbjvcd_vendor_pidm%TYPE,
                              p_encb_num_in_out        IN OUT fgbjvcd.fgbjvcd_encb_num%TYPE,
                              p_encd_item_num_in_out   IN OUT fgbjvcd.fgbjvcd_encd_item_num%TYPE,
                              p_encd_seq_num_in_out    IN OUT fgbjvcd.fgbjvcd_encd_seq_num%TYPE,
                              p_encb_type_in_out       IN OUT fgbjvcd.fgbjvcd_encb_type%TYPE,
                              p_bud_dispn_in_out       IN OUT fgbjvcd.fgbjvcd_bud_dispn%TYPE,
                              p_bud_id_in_out          IN OUT fgbjvcd.fgbjvcd_bud_id%TYPE,
                              p_cmt_type_in_out        IN OUT fgbjvcd.fgbjvcd_cmt_type%TYPE,
                              p_cmt_pct_in_out         IN OUT fgbjvcd.fgbjvcd_cmt_pct%TYPE,
                              p_dep_num_in_out         IN OUT fgbjvcd.fgbjvcd_dep_num%TYPE,
                              p_encb_action_ind_in_out IN OUT fgbjvcd.fgbjvcd_encb_action_ind%TYPE,
                              p_prjd_code_in_out       IN OUT fgbjvcd.fgbjvcd_prjd_code%TYPE,
                              p_dist_pct_in_out        IN OUT fgbjvcd.fgbjvcd_dist_pct%TYPE,
                              p_posting_period_in_out  IN OUT fgbjvcd.fgbjvcd_posting_period%TYPE,
                              p_budget_period_in_out   IN OUT fgbjvcd.fgbjvcd_budget_period%TYPE,
                              p_accrual_ind_in_out     IN OUT fgbjvcd.fgbjvcd_accrual_ind%TYPE,
                              p_curr_code_in_out       IN OUT fgbjvcd.fgbjvcd_curr_code%TYPE,
                              p_err_tab_in_out         IN OUT fb_common.err_tabtype)

Procedure to process Rule Class editing.
 
Transactions are reviewed according to user defined edits in the Rule Class Edit table (FTVEDIT) and system defined edits for the associated processes in the Rule Class Validation table (FTVRULP).
 
Defaulted values may be returned from the Rule Class Edits where defined.

Parameters
p_rucl_code   The user-entered rule class (as defined in table FTVRUCL) for the journal voucher sequence. VARCHAR2(4)
p_trans_date   The date the journal voucher document will be recorded in the ledgers. DATE
p_doc_num   The unique identifier of a journal voucher document. VARCHAR2(8)
p_submission_number   The submission number associated with the journal voucher document. NUMBER(2)
p_seq_num   A one-up sequence number associated with each line of a journal voucher document. NUMBER(4)
p_fsyr_code   The fiscal year code (as defined in table FTVFSYR) to be used when posting the transaction to the ledgers. VARCHAR2(2)
p_user_id   The identification code of the user who last updated the journal voucher sequence. VARCHAR2(30)
p_auto_jrnl_id   The value that identifies the jounal voucher as automatic or recurring. VARCHAR2(3)
p_reversal_ind   An indicator which displays a value of "R" if the automatic journal voucher was reversed. VARCHAR2(1)
p_trans_amt_in_out   The amount of the journal voucher sequence. NUMBER(17,2)
p_trans_desc_in_out   The reason or purpose for the journal voucher sequence. VARCHAR2(35)
p_dr_cr_ind_in_out   The sign associated with the journal voucher sequence. VARCHAR2(1)
p_acci_code_in_out   The Index Code (as defined in table FTVACCI) that may be entered to default various accounting elements. VARCHAR2(6)
p_coas_code_in_out   The Chart of Accounts code (as defined in table FTVCOAS) referenced by the journal voucher sequence. VARCHAR2(1)
p_fund_code_in_out   The Fund Code (as defined in table FTVFUND) referenced by the journal voucher sequence. VARCHAR2(6)
p_orgn_code_in_out   The Organization Code (as defined in table FTVORGN) referenced by the journal voucher sequence. VARCHAR2(6)
p_acct_code_in_out   The Account Code (as defined in table FTVACCT) referenced by the journal voucher sequence. VARCHAR2(6)
p_prog_code_in_out   The Program Code (as defined in table FTVPROG) referenced by the journal voucher sequence. VARCHAR2(6)
p_actv_code_in_out   The Activity Code (as defined in table FTVACTV) referenced by the journal voucher sequence. VARCHAR2(6)
p_locn_code_in_out   The Location Code (as defined in table FTVLOCN) referenced by the journal voucher sequence. VARCHAR2(6)
p_bank_code_in_out   The Bank Code (as defined in table GXVBANK) referenced by the journal voucher sequence. VARCHAR2(2)
p_doc_ref_num_in_out   The user-defined value that may provide further information on the journal voucher sequence. VARCHAR2(8)
p_vendor_pidm_in_out   The personal identification master record (PIDM) associated with the vendor referenced on the journal voucher sequence. NUMBER(8)
p_encb_num_in_out   The encumbrance number, if the journal voucher sequence references an existing encumbrance, such as a liquidation or an adjustment entry. VARCHAR2(8)
p_encd_item_num_in_out   The encumbrance item number, if the journal voucher sequence references an existing encumbrance. NUMBER(4)
p_encd_seq_num_in_out   The sequence number associated with an encumbrance item number. NUMBER(4)
p_encb_type_in_out   The type of encumbrance referenced by the journal voucher sequence. VARCHAR2(1).
p_bud_dispn_in_out   The budget disposition carried forward on the rolled encumbrance. VARCHAR2(1).
p_bud_id_in_out   The Budget ID, if this journal is updating the ledgers as well as budget development. VARCHAR2(6)
p_cmt_type_in_out   The commitment value associated with an encumbrance that has been rolled from a prior fiscal year. VARCHAR2(1).
p_cmt_pct_in_out   The percent of budget carried forward on the rolled encumbrance. NUMBER(6,3)
p_dep_num_in_out   A user-valued deposit number assigned to the journal voucher sequence. VARCHAR2(8)
p_encb_action_ind_in_out   Indicates the action to be taken on the encumbrance number, item, and sequence number specified on the journal voucher sequence. VARCHAR2(1)
p_prjd_code_in_out   The Project Code (as defined in table FTVPROJ) referenced by the journal voucher sequence. VARCHAR2(8)
p_dist_pct_in_out   The percentage of the transaction amount assigned to the journal voucher sequence. NUMBER(6,3)
p_posting_period_in_out   The fiscal period (as defined in table FTVFSPD) to be used when posting the transaction to the ledgers. VARCHAR2(2)
p_budget_period_in_out   The budget period affected by the journal voucher sequence. VARCHAR2(2)
p_accrual_ind_in_out   Accrual Period posting indicator. VARCHAR2(1)
p_curr_code_in_out   The currency (as defined in table GTVCURR) to be used for the processing of the journal voucher. VARCHAR2(4)
p_err_tab_in_out   A collection of error messages resulting from the editing of the transaction. fb_common.err_tabtype

p_valid_create 

Procedure p_valid_create(p_detail_rec_in     fb_jv_detail.jv_detail_rec,
                         p_detail_rec_out    OUT fb_jv_detail.jv_detail_rec,
                         p_err_tab_out       OUT fb_common.err_tabtype,
                         p_warning_out       OUT gb_common_strings.err_type,
                         p_abal_severity_out OUT VARCHAR2)

Validates data entered, sets defaults, and processes edits and security for insert.

Parameters
p_detail_rec_in   Journal Voucher Record Type created from the parameters requesting Create. fb_jv_detail.jv_detail_rec Required
p_detail_rec_out   Journal Voucher Record Type with additional values from calculations or defaults. fb_jv_detail.jv_detail_rec Required
p_err_tab_out   A collection of error messages resulting from the editing of the transaction. fb_common.err_tabtype Required
p_warning_out   Returns the message from available balance checking. VARCHAR2(4000) Required
p_abal_severity_out   Returns severity level from available balance checking. VARCHAR2(1) Required
Y   Sufficient funds are available
N   Funds are not available, and journal voucher sequence may not be set to P (ready to post)
W   Funds are not available (informational warning)
E   Validation or other errors encountered while checking available balance


p_valid_update 

Procedure p_valid_update(p_detail_rec_in     fb_jv_detail.jv_detail_rec,
                         p_detail_rec_out    OUT fb_jv_detail.jv_detail_rec,
                         p_err_tab_out       OUT fb_common.err_tabtype,
                         p_warning_out       OUT gb_common_strings.err_type,
                         p_abal_severity_out OUT VARCHAR2,
                         p_old_pct           NUMBER,
                         p_new_amt           NUMBER)

Validates data entered, and processes edits for update.

Parameters
p_detail_rec_in   Journal Voucher Record Type created from the existing record overlaid by the parameters requesting Update. fb_jv_detail.jv_detail_rec Required
p_detail_rec_out   Journal Voucher Record Type with additional values from calculations or defaults. fb_jv_detail.jv_detail_rec Required
p_err_tab_out   A collection of error messages resulting from the editing of the transaction. fb_common.err_tabtype Required
p_warning_out   Returns the message from available balance checking. VARCHAR2(4000) Required
p_abal_severity_out   Returns severity level from available balance checking. VARCHAR2(1) Required
Y   Sufficient funds are available
N   Funds are not available, and journal voucher sequence may not be set to P (ready to post)
W   Funds are not available (informational warning)
E   Validation or other errors encountered while checking available balance

p_old_pct   Distribution Percent in existing record. NUMBER
p_new_amt   Transaction Amount proposed for update. NUMBER