index

Package BANINST1.fb_encumbrance_header_rules

Support subprograms for ENCUMBRANCE_HEADER.
 
Note that the p_register_entity procedures commonly found in the API Rules package are not included, as Event Registration for General Encumbrances occurs only at the document level through fp_encumbrance.

Program units
p_validate   Validates all data in the record.

p_validate 

Procedure p_validate(p_num            fgbench.fgbench_num%TYPE,
                     p_doc_change_num fgbench.fgbench_doc_change_num%TYPE DEFAULT NULL,
                     p_user_id        fgbench.fgbench_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_desc           fgbench.fgbench_desc%TYPE DEFAULT NULL,
                     p_change_desc    fgbench.fgbench_change_desc%TYPE DEFAULT NULL,
                     p_trans_date     fgbench.fgbench_trans_date%TYPE,
                     p_doc_ref_num    fgbench.fgbench_doc_ref_num%TYPE DEFAULT NULL,
                     p_doc_amt        fgbench.fgbench_doc_amt%TYPE DEFAULT NULL,
                     p_type           fgbench.fgbench_type%TYPE,
                     p_status_ind     fgbench.fgbench_status_ind%TYPE,
                     p_status         fgbench.fgbench_status%TYPE DEFAULT NULL,
                     p_edit_deferral  fgbench.fgbench_edit_deferral%TYPE DEFAULT NULL,
                     p_estab_date     fgbench.fgbench_estab_date%TYPE,
                     p_vendor_pidm    fgbench.fgbench_vendor_pidm%TYPE DEFAULT NULL,
                     p_source_ind     fgbench.fgbench_source_ind%TYPE DEFAULT NULL,
                     p_appr_ind       fgbench.fgbench_appr_ind%TYPE DEFAULT NULL,
                     p_nsf_on_off_ind fgbench.fgbench_nsf_on_off_ind%TYPE DEFAULT NULL,
                     p_create_date    fgbench.fgbench_create_date%TYPE DEFAULT NULL,
                     p_create_user    fgbench.fgbench_create_user%TYPE DEFAULT NULL,
                     p_data_origin    fgbench.fgbench_data_origin%TYPE DEFAULT NULL,
                     p_create_source  fgbench.fgbench_create_source%TYPE DEFAULT NULL,
                     p_context        VARCHAR2 DEFAULT NULL,
                     p_existing_rec   fb_encumbrance_header.encumbrance_header_rec DEFAULT NULL)

Validates all data in the record.

Parameters
p_num   The unique identifier of an Encumbrance document. VARCHAR2(8) Required Key
p_doc_change_num   The user-defined number identifies changes made to the original encumbrance.  This number is used as the document code to post the encumbrance change to the ledgers. VARCHAR2(8)
p_user_id   The unique identification code of the user who created or last updated the encumbrance document. VARCHAR2(30) Required
p_desc   The title or purpose of the Encumbrance. VARCHAR2(35)
p_change_desc   The title or a brief description of any change made to an existing encumbrance. VARCHAR2(35)
p_trans_date   The date the Encumbrance document will be recorded in the ledgers. DATE Required
p_doc_ref_num   The user-defined value providing additional identification for the encumbrance. VARCHAR2(8)
p_doc_amt   The total value of the encumbrance being recorded. NUMBER(17,2)
p_type   Indicates the type of encumbrance or the source of the encumbrance.  Values are General (E)ncumbrance,  (M)emo,  (L)abor, (R)equisition, and (P)urchase Order. VARCHAR2(1) Required
p_status_ind   The status of the encumbrance.  Values are (C)losed and (O)pen. VARCHAR2(1) Required
p_status   The status of the encumbrance document.  A (C)omplete indicates that the document has been completed.  An (I)ncomplete or null value indicates the document is awaiting completion. VARCHAR2(1)
p_edit_deferral   Indicates that document editing of the Encumbrance will be deferred until after completion. Valid values are "Y" and "N". VARCHAR2(1)
p_estab_date   The date the encumbrance was originally established. DATE Required
p_vendor_pidm   The personal identification master record (PIDM) associated with the vendor referenced on the Encumbrance. NUMBER(8)
p_source_ind   Indicates the actual document type source for the encumbrance. Values are (R)equisition,  (P)urchase Order, and null for other encumbrance documents. VARCHAR2(1)
p_appr_ind   Indicates if the document has been approved.  If "Y", the document has received final approval. VARCHAR2(1)
p_nsf_on_off_ind   Indicates when non-sufficient funds checking will be performed.  If "Y", checking will be performed at time of data entry.  Valid values are "Y", "N", and null. VARCHAR2(1)
p_create_date   The date on which the new record was created. DATE
p_create_user   The Banner User ID which created the new record. VARCHAR2(30)
p_data_origin   Source system that created or last updated the data. VARCHAR2(30)
p_create_source   Source system that created the new record. VARCHAR2(30)
p_context   Process context under which record is being created. VARCHAR2(50)
p_existing_rec   Current FGBENCH record, before updates.