|
Package BANINST1.fb_requisition Common Business interface for requisition (FB_REQUISITION). |
| Program units |
| f_current_version | Returns the current version number. |
| f_exists_header | Checks to see if a requisition header record exists. |
| f_query_one_header | Selects one record using unique column. |
| p_lock_header | Locks a requisition header record for update. |
| p_delete_header | Deletes a requisition header record. |
| p_create_header | Creates a requisition header record. |
| p_update_header | Updates a requisition header record. |
| p_update_header_status | Updates requisition header status. |
| p_validate_header | Validates a requisition header record. |
| f_exists_item | Checks to see if a requisition item record exists. |
| f_query_one_item | Selects one item record using unique columns. |
| f_query_all_item | Selects all the item records for the requisition. |
| p_lock_item | Locks an item record for update. |
| p_delete_item | Deletes an item record. |
| p_create_item | Creates an item record. |
| p_update_item | Updates an item record. |
| p_validate_item | Validates an item record. |
| f_exists_accounting | Checks to see if a requisition accounting record exists. |
| f_query_one_accounting | Selects one accounting record using unique columns. |
| f_query_all_accounting | Selects all the records for the requisition accounting item. |
| p_lock_accounting | Locks an accounting record for update. |
| p_delete_accounting | Deletes an accounting record. |
| p_create_accounting | Creates an accounting record. |
| p_update_accounting | Updates an accounting record. |
| p_validate_accounting | Validates an accounting record. |
| f_complete_req | Wrap up logic for document completion. |
| f_get_tax_amts_and_budg_auth | Wrap up logic to perform completion logic and get tax amounts |
| f_req_posted | Checks to see if a requisition is posted. |
| f_req_status | Checks the requisition status. |
| f_is_eproc_req | Checks to see if the requisition is an e-Procurement requisition. |
| f_doc_ref_code_exists | Checks to see if a requisition reference code exists. |
| f_document_ref_code_exists | Checks to see if a requisition reference code exists. |
| f_get_doc_ref_code | Selects a requisition reference code. |
| f_get_doc_code | Selects a requisition code. |
| f_get_cancel_mesg | Selects a requisition cancellation message. |
| f_get_status_code | Selects a requisition status code. |
| Types |
| req_header_rec | Requisition header record type |
| req_header_ref | Requisition header reference cursor |
| req_header_tab | Requisition header table type |
| reqn_item_rec | Requisition item record type |
| reqn_item_ref | Requisition item reference cursor |
| reqn_item_tab | Requisition item table type |
| reqn_accounting_rec | Requisition accounting record type |
| reqn_accounting_ref | Requisition accounting reference cursor |
| reqn_accounting_tab | Requisition accounting table type |
| Constants |
| PENDING | Pending indicator |
| CANCELLED | Cancelled indicator |
| POSTED | Posted indicator |
| CANCEL_MESG | Cancellation message |
| CANCEL_CODE | Cancellation code |
PENDING
PENDING CONSTANT VARCHAR2(1) := 'P';
Pending indicator
CANCELLED
CANCELLED CONSTANT VARCHAR2(1) := 'C';
Cancelled indicator
POSTED
POSTED CONSTANT VARCHAR2(1) := 'D';
Posted indicator
CANCEL_MESG
CANCEL_MESG CONSTANT VARCHAR2(100) :=
G$_NLS.Get('FPKB_REQN0-0000', 'SQL','This Document will be cancelled since it has originated from an external E-Procurement system.') ;
Cancellation message
CANCEL_CODE
CANCEL_CODE CONSTANT VARCHAR2(4) := 'EPCN';
Cancellation code
req_header_rec
TYPE req_header_rec IS RECORD (
code FPBREQH.FPBREQH_CODE%TYPE,
activity_date FPBREQH.FPBREQH_ACTIVITY_DATE%TYPE ,
user_id FPBREQH.FPBREQH_USER_ID%TYPE ,
reqh_date FPBREQH.FPBREQH_REQH_DATE%TYPE ,
trans_date FPBREQH.FPBREQH_TRANS_DATE%TYPE ,
name FPBREQH.FPBREQH_NAME%TYPE ,
phone_area FPBREQH.FPBREQH_PHONE_AREA%TYPE ,
phone_num FPBREQH.FPBREQH_PHONE_NUM%TYPE ,
phone_ext FPBREQH.FPBREQH_PHONE_EXT%TYPE ,
vend_pidm FPBREQH.FPBREQH_VEND_PIDM%TYPE ,
atyp_code FPBREQH.FPBREQH_ATYP_CODE%TYPE ,
atyp_seq_num FPBREQH.FPBREQH_ATYP_SEQ_NUM%TYPE ,
coas_code FPBREQH.FPBREQH_COAS_CODE%TYPE ,
orgn_code FPBREQH.FPBREQH_ORGN_CODE%TYPE ,
reqd_date FPBREQH.FPBREQH_REQD_DATE%TYPE ,
complete_ind FPBREQH.FPBREQH_COMPLETE_IND%TYPE ,
print_ind FPBREQH.FPBREQH_PRINT_IND%TYPE ,
encumb_ind FPBREQH.FPBREQH_ENCUMB_IND%TYPE ,
susp_ind FPBREQH.FPBREQH_SUSP_IND%TYPE ,
cancel_ind FPBREQH.FPBREQH_CANCEL_IND%TYPE ,
cancel_date FPBREQH.FPBREQH_CANCEL_DATE%TYPE ,
post_date FPBREQH.FPBREQH_POST_DATE%TYPE ,
appr_ind FPBREQH.FPBREQH_APPR_IND%TYPE ,
text_ind FPBREQH.FPBREQH_TEXT_IND%TYPE ,
edit_defer_ind FPBREQH.FPBREQH_EDIT_DEFER_IND%TYPE ,
recomm_vend_name FPBREQH.FPBREQH_RECOMM_VEND_NAME%TYPE ,
curr_code FPBREQH.FPBREQH_CURR_CODE%TYPE ,
nsf_on_off_ind FPBREQH.FPBREQH_NSF_ON_OFF_IND%TYPE ,
single_acctg_ind FPBREQH.FPBREQH_SINGLE_ACCTG_IND%TYPE ,
closed_ind FPBREQH.FPBREQH_CLOSED_IND%TYPE ,
ship_code FPBREQH.FPBREQH_SHIP_CODE%TYPE ,
rqst_type_ind FPBREQH.FPBREQH_RQST_TYPE_IND%TYPE ,
inventory_req_ind FPBREQH.FPBREQH_INVENTORY_REQ_IND%TYPE ,
crsn_code FPBREQH.FPBREQH_CRSN_CODE%TYPE ,
delivery_comment FPBREQH.FPBREQH_DELIVERY_COMMENT%TYPE ,
email_addr FPBREQH.FPBREQH_EMAIL_ADDR%TYPE ,
fax_area FPBREQH.FPBREQH_FAX_AREA%TYPE ,
fax_number FPBREQH.FPBREQH_FAX_NUMBER%TYPE ,
fax_ext FPBREQH.FPBREQH_FAX_EXT%TYPE ,
attention_to FPBREQH.FPBREQH_ATTENTION_TO%TYPE ,
vendor_contact FPBREQH.FPBREQH_VENDOR_CONTACT%TYPE ,
disc_code FPBREQH.FPBREQH_DISC_CODE%TYPE ,
vend_email_addr FPBREQH.FPBREQH_VEND_EMAIL_ADDR%TYPE ,
copied_from FPBREQH.FPBREQH_COPIED_FROM%TYPE ,
tgrp_code FPBREQH.FPBREQH_TGRP_CODE%TYPE ,
req_print_date FPBREQH.FPBREQH_REQ_PRINT_DATE%TYPE ,
closed_date FPBREQH.FPBREQH_CLOSED_DATE%TYPE ,
match_required FPBREQH.FPBREQH_MATCH_REQUIRED%TYPE ,
origin_code FPBREQH.FPBREQH_ORIGIN_CODE%TYPE ,
doc_ref_code FPBREQH.FPBREQH_DOC_REF_CODE%TYPE,
status VARCHAR2(1),
ctry_code_phone fpbreqh.fpbreqh_ctry_code_phone%TYPE,
ctry_code_fax fpbreqh.fpbreqh_ctry_code_fax%TYPE,
internal_record_id VARCHAR2(18)
);
Requisition header record type
req_header_ref
TYPE req_header_ref IS REF CURSOR RETURN REQ_HEADER_REC;
Requisition header reference cursor
req_header_tab
TYPE req_header_tab IS TABLE OF REQ_HEADER_REC INDEX BY BINARY_INTEGER;
Requisition header 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_header
Function f_exists_header(p_code FPBREQH.FPBREQH_CODE%TYPE) RETURN BOOLEAN
Checks to see if a requisition header record exists.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. |
| Returns |
|
TRUE if found, otherwise FALSE. |
f_query_one_header
Function f_query_one_header(p_code FPBREQH.FPBREQH_CODE%TYPE) RETURN req_header_REF
Selects one record using unique column.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. |
| Returns |
|
a cursor variable that will fetch exactly one record. |
p_lock_header
Procedure p_lock_header(p_code FPBREQH.FPBREQH_CODE%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
Locks a requisition header record for update.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. | |
| p_rowid |
Rowid of the requisition header recocrd. VARCHAR2. |
p_delete_header
Procedure p_delete_header(p_code FPBREQH.FPBREQH_CODE%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
Deletes a requisition header record.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. | |
| p_rowid |
Rowid of the requisition header recocrd. VARCHAR2. |
p_create_header
Procedure p_create_header(p_code IN OUT FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_activity_date FPBREQH.FPBREQH_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPBREQH.FPBREQH_USER_ID%TYPE default USER,
p_reqh_date FPBREQH.FPBREQH_REQH_DATE%TYPE default sysdate,
p_trans_date FPBREQH.FPBREQH_TRANS_DATE%TYPE default sysdate,
p_name FPBREQH.FPBREQH_NAME%TYPE default NULL,
p_phone_area FPBREQH.FPBREQH_PHONE_AREA%TYPE default NULL,
p_phone_num FPBREQH.FPBREQH_PHONE_NUM%TYPE default NULL,
p_phone_ext FPBREQH.FPBREQH_PHONE_EXT%TYPE default NULL,
-- p_vendor_id SPRIDEN.SPRIDEN_ID%TYPE default NULL,
p_vend_pidm FPBREQH.FPBREQH_VEND_PIDM%TYPE default NULL,
p_atyp_code FPBREQH.FPBREQH_ATYP_CODE%TYPE default NULL,
p_atyp_seq_num FPBREQH.FPBREQH_ATYP_SEQ_NUM%TYPE default NULL,
p_coas_code FPBREQH.FPBREQH_COAS_CODE%TYPE default NULL,
p_orgn_code FPBREQH.FPBREQH_ORGN_CODE%TYPE default NULL,
p_reqd_date FPBREQH.FPBREQH_REQD_DATE%TYPE default NULL,
p_complete_ind FPBREQH.FPBREQH_COMPLETE_IND%TYPE default NULL,
p_print_ind FPBREQH.FPBREQH_PRINT_IND%TYPE default NULL,
p_encumb_ind FPBREQH.FPBREQH_ENCUMB_IND%TYPE default NULL,
p_susp_ind FPBREQH.FPBREQH_SUSP_IND%TYPE default NULL,
p_cancel_ind FPBREQH.FPBREQH_CANCEL_IND%TYPE default NULL,
p_cancel_date FPBREQH.FPBREQH_CANCEL_DATE%TYPE default NULL,
p_post_date FPBREQH.FPBREQH_POST_DATE%TYPE default NULL,
p_appr_ind FPBREQH.FPBREQH_APPR_IND%TYPE default NULL,
p_text_ind FPBREQH.FPBREQH_TEXT_IND%TYPE default NULL,
p_edit_defer_ind FPBREQH.FPBREQH_EDIT_DEFER_IND%TYPE default NULL,
p_recomm_vend_name FPBREQH.FPBREQH_RECOMM_VEND_NAME%TYPE default NULL,
p_curr_code FPBREQH.FPBREQH_CURR_CODE%TYPE default NULL,
p_nsf_on_off_ind FPBREQH.FPBREQH_NSF_ON_OFF_IND%TYPE default NULL,
p_single_acctg_ind FPBREQH.FPBREQH_SINGLE_ACCTG_IND%TYPE default NULL,
p_closed_ind FPBREQH.FPBREQH_CLOSED_IND%TYPE default NULL,
p_ship_code FPBREQH.FPBREQH_SHIP_CODE%TYPE default NULL,
p_rqst_type_ind FPBREQH.FPBREQH_RQST_TYPE_IND%TYPE default NULL,
p_inventory_req_ind FPBREQH.FPBREQH_INVENTORY_REQ_IND%TYPE default NULL,
p_crsn_code FPBREQH.FPBREQH_CRSN_CODE%TYPE default NULL,
p_delivery_comment FPBREQH.FPBREQH_DELIVERY_COMMENT%TYPE default NULL,
p_email_addr FPBREQH.FPBREQH_EMAIL_ADDR%TYPE default NULL,
p_fax_area FPBREQH.FPBREQH_FAX_AREA%TYPE default NULL,
p_fax_number FPBREQH.FPBREQH_FAX_NUMBER%TYPE default NULL,
p_fax_ext FPBREQH.FPBREQH_FAX_EXT%TYPE default NULL,
p_attention_to FPBREQH.FPBREQH_ATTENTION_TO%TYPE default NULL,
p_vendor_contact FPBREQH.FPBREQH_VENDOR_CONTACT%TYPE default NULL,
p_disc_code FPBREQH.FPBREQH_DISC_CODE%TYPE default NULL,
p_vend_email_addr FPBREQH.FPBREQH_VEND_EMAIL_ADDR%TYPE default NULL,
p_copied_from FPBREQH.FPBREQH_COPIED_FROM%TYPE default NULL,
p_tgrp_code FPBREQH.FPBREQH_TGRP_CODE%TYPE default NULL,
p_req_print_date FPBREQH.FPBREQH_REQ_PRINT_DATE%TYPE default NULL,
p_closed_date FPBREQH.FPBREQH_CLOSED_DATE%TYPE default NULL,
p_match_required FPBREQH.FPBREQH_MATCH_REQUIRED%TYPE default 'U',
p_origin_code FPBREQH.FPBREQH_ORIGIN_CODE%TYPE default 'BANNER',
p_doc_ref_code FPBREQH.FPBREQH_DOC_REF_CODE%TYPE default NULL,
p_print_text VARCHAR2,
p_noprint_text VARCHAR2,
p_ctry_code_phone fpbreqh.fpbreqh_ctry_code_phone%TYPE default NULL,
p_ctry_code_fax fpbreqh.fpbreqh_ctry_code_fax%TYPE default NULL,
p_rowid OUT VARCHAR2)
Creates a requisition header record.
p_update_header
Procedure p_update_header(p_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_activity_date FPBREQH.FPBREQH_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPBREQH.FPBREQH_USER_ID%TYPE default USER,
p_reqh_date FPBREQH.FPBREQH_REQH_DATE%TYPE default sysdate,
p_trans_date FPBREQH.FPBREQH_TRANS_DATE%TYPE default sysdate,
p_name FPBREQH.FPBREQH_NAME%TYPE default NULL,
p_phone_area FPBREQH.FPBREQH_PHONE_AREA%TYPE default NULL,
p_phone_num FPBREQH.FPBREQH_PHONE_NUM%TYPE default NULL,
p_phone_ext FPBREQH.FPBREQH_PHONE_EXT%TYPE default NULL,
-- p_vend_id SPRIDEN.SPRIDEN_ID%TYPE default NULL,
p_vend_pidm FPBREQH.FPBREQH_VEND_PIDM%TYPE default NULL,
p_atyp_code FPBREQH.FPBREQH_ATYP_CODE%TYPE default NULL,
p_atyp_seq_num FPBREQH.FPBREQH_ATYP_SEQ_NUM%TYPE default NULL,
p_coas_code FPBREQH.FPBREQH_COAS_CODE%TYPE default NULL,
p_orgn_code FPBREQH.FPBREQH_ORGN_CODE%TYPE default NULL,
p_reqd_date FPBREQH.FPBREQH_REQD_DATE%TYPE default NULL,
p_complete_ind FPBREQH.FPBREQH_COMPLETE_IND%TYPE default NULL,
p_print_ind FPBREQH.FPBREQH_PRINT_IND%TYPE default NULL,
p_encumb_ind FPBREQH.FPBREQH_ENCUMB_IND%TYPE default NULL,
p_susp_ind FPBREQH.FPBREQH_SUSP_IND%TYPE default NULL,
p_cancel_ind FPBREQH.FPBREQH_CANCEL_IND%TYPE default NULL,
p_cancel_date FPBREQH.FPBREQH_CANCEL_DATE%TYPE default NULL,
p_post_date FPBREQH.FPBREQH_POST_DATE%TYPE default NULL,
p_appr_ind FPBREQH.FPBREQH_APPR_IND%TYPE default NULL,
p_text_ind FPBREQH.FPBREQH_TEXT_IND%TYPE default NULL,
p_edit_defer_ind FPBREQH.FPBREQH_EDIT_DEFER_IND%TYPE default NULL,
p_recomm_vend_name FPBREQH.FPBREQH_RECOMM_VEND_NAME%TYPE default NULL,
p_curr_code FPBREQH.FPBREQH_CURR_CODE%TYPE default NULL,
p_nsf_on_off_ind FPBREQH.FPBREQH_NSF_ON_OFF_IND%TYPE default NULL,
p_single_acctg_ind FPBREQH.FPBREQH_SINGLE_ACCTG_IND%TYPE default NULL,
p_closed_ind FPBREQH.FPBREQH_CLOSED_IND%TYPE default NULL,
p_ship_code FPBREQH.FPBREQH_SHIP_CODE%TYPE default NULL,
p_rqst_type_ind FPBREQH.FPBREQH_RQST_TYPE_IND%TYPE default NULL,
p_inventory_req_ind FPBREQH.FPBREQH_INVENTORY_REQ_IND%TYPE default NULL,
p_crsn_code FPBREQH.FPBREQH_CRSN_CODE%TYPE default NULL,
p_delivery_comment FPBREQH.FPBREQH_DELIVERY_COMMENT%TYPE default NULL,
p_email_addr FPBREQH.FPBREQH_EMAIL_ADDR%TYPE default NULL,
p_fax_area FPBREQH.FPBREQH_FAX_AREA%TYPE default NULL,
p_fax_number FPBREQH.FPBREQH_FAX_NUMBER%TYPE default NULL,
p_fax_ext FPBREQH.FPBREQH_FAX_EXT%TYPE default NULL,
p_attention_to FPBREQH.FPBREQH_ATTENTION_TO%TYPE default NULL,
p_vendor_contact FPBREQH.FPBREQH_VENDOR_CONTACT%TYPE default NULL,
p_disc_code FPBREQH.FPBREQH_DISC_CODE%TYPE default NULL,
p_vend_email_addr FPBREQH.FPBREQH_VEND_EMAIL_ADDR%TYPE default NULL,
p_copied_from FPBREQH.FPBREQH_COPIED_FROM%TYPE default NULL,
p_tgrp_code FPBREQH.FPBREQH_TGRP_CODE%TYPE default NULL,
p_req_print_date FPBREQH.FPBREQH_REQ_PRINT_DATE%TYPE default NULL,
p_closed_date FPBREQH.FPBREQH_CLOSED_DATE%TYPE default NULL,
p_match_required FPBREQH.FPBREQH_MATCH_REQUIRED%TYPE default 'U',
p_origin_code FPBREQH.FPBREQH_ORIGIN_CODE%TYPE default 'BANNER',
p_doc_ref_code FPBREQH.FPBREQH_DOC_REF_CODE%TYPE default NULL,
p_status varchar2 DEFAULT Null,
p_status_message varchar2 default Null,
p_ctry_code_phone fpbreqh.fpbreqh_ctry_code_phone%TYPE default NULL,
p_ctry_code_fax fpbreqh.fpbreqh_ctry_code_fax%TYPE default NULL,
p_rowid VARCHAR2 default NULL)
Updates a requisition header record.
p_update_header_status
Procedure p_update_header_status(p_code FPBREQH.FPBREQH_CODE%TYPE,
p_status varchar2 DEFAULT Null,
p_status_message varchar2 Default Null)
Updates requisition header status.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. | |
| p_status |
Requisition status. VARCHAR2 | |
| p_status_message |
Requisition status message. VARCHAR2 |
p_validate_header
Procedure p_validate_header(p_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_activity_date FPBREQH.FPBREQH_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPBREQH.FPBREQH_USER_ID%TYPE default USER,
p_reqh_date FPBREQH.FPBREQH_REQH_DATE%TYPE default sysdate,
p_trans_date FPBREQH.FPBREQH_TRANS_DATE%TYPE default sysdate,
p_name FPBREQH.FPBREQH_NAME%TYPE default NULL,
p_phone_area FPBREQH.FPBREQH_PHONE_AREA%TYPE default NULL,
p_phone_num FPBREQH.FPBREQH_PHONE_NUM%TYPE default NULL,
p_phone_ext FPBREQH.FPBREQH_PHONE_EXT%TYPE default NULL,
-- p_vend_id SPRIDEN.SPRIDEN_ID%TYPE default NULL,
p_vend_pidm FPBREQH.FPBREQH_VEND_PIDM%TYPE default NULL,
p_atyp_code FPBREQH.FPBREQH_ATYP_CODE%TYPE default NULL,
p_atyp_seq_num FPBREQH.FPBREQH_ATYP_SEQ_NUM%TYPE default NULL,
p_coas_code FPBREQH.FPBREQH_COAS_CODE%TYPE default NULL,
p_orgn_code FPBREQH.FPBREQH_ORGN_CODE%TYPE default NULL,
p_reqd_date FPBREQH.FPBREQH_REQD_DATE%TYPE default NULL,
p_complete_ind FPBREQH.FPBREQH_COMPLETE_IND%TYPE default NULL,
p_print_ind FPBREQH.FPBREQH_PRINT_IND%TYPE default NULL,
p_encumb_ind FPBREQH.FPBREQH_ENCUMB_IND%TYPE default NULL,
p_susp_ind FPBREQH.FPBREQH_SUSP_IND%TYPE default NULL,
p_cancel_ind FPBREQH.FPBREQH_CANCEL_IND%TYPE default NULL,
p_cancel_date FPBREQH.FPBREQH_CANCEL_DATE%TYPE default NULL,
p_post_date FPBREQH.FPBREQH_POST_DATE%TYPE default NULL,
p_appr_ind FPBREQH.FPBREQH_APPR_IND%TYPE default NULL,
p_text_ind FPBREQH.FPBREQH_TEXT_IND%TYPE default NULL,
p_edit_defer_ind FPBREQH.FPBREQH_EDIT_DEFER_IND%TYPE default NULL,
p_recomm_vend_name FPBREQH.FPBREQH_RECOMM_VEND_NAME%TYPE default NULL,
p_curr_code FPBREQH.FPBREQH_CURR_CODE%TYPE default NULL,
p_nsf_on_off_ind FPBREQH.FPBREQH_NSF_ON_OFF_IND%TYPE default NULL,
p_single_acctg_ind FPBREQH.FPBREQH_SINGLE_ACCTG_IND%TYPE default NULL,
p_closed_ind FPBREQH.FPBREQH_CLOSED_IND%TYPE default NULL,
p_ship_code FPBREQH.FPBREQH_SHIP_CODE%TYPE default NULL,
p_rqst_type_ind FPBREQH.FPBREQH_RQST_TYPE_IND%TYPE default NULL,
p_inventory_req_ind FPBREQH.FPBREQH_INVENTORY_REQ_IND%TYPE default NULL,
p_crsn_code FPBREQH.FPBREQH_CRSN_CODE%TYPE default NULL,
p_delivery_comment FPBREQH.FPBREQH_DELIVERY_COMMENT%TYPE default NULL,
p_email_addr FPBREQH.FPBREQH_EMAIL_ADDR%TYPE default NULL,
p_fax_area FPBREQH.FPBREQH_FAX_AREA%TYPE default NULL,
p_fax_number FPBREQH.FPBREQH_FAX_NUMBER%TYPE default NULL,
p_fax_ext FPBREQH.FPBREQH_FAX_EXT%TYPE default NULL,
p_attention_to FPBREQH.FPBREQH_ATTENTION_TO%TYPE default NULL,
p_vendor_contact FPBREQH.FPBREQH_VENDOR_CONTACT%TYPE default NULL,
p_disc_code FPBREQH.FPBREQH_DISC_CODE%TYPE default NULL,
p_vend_email_addr FPBREQH.FPBREQH_VEND_EMAIL_ADDR%TYPE default NULL,
p_copied_from FPBREQH.FPBREQH_COPIED_FROM%TYPE default NULL,
p_tgrp_code FPBREQH.FPBREQH_TGRP_CODE%TYPE default NULL,
p_req_print_date FPBREQH.FPBREQH_REQ_PRINT_DATE%TYPE default NULL,
p_closed_date FPBREQH.FPBREQH_CLOSED_DATE%TYPE default NULL,
p_match_required FPBREQH.FPBREQH_MATCH_REQUIRED%TYPE default 'U',
p_origin_code FPBREQH.FPBREQH_ORIGIN_CODE%TYPE default 'BANNER',
p_doc_ref_code FPBREQH.FPBREQH_DOC_REF_CODE%TYPE default NULL,
p_status varchar2,
p_ctry_code_phone fpbreqh.fpbreqh_ctry_code_phone%TYPE default NULL,
p_ctry_code_fax fpbreqh.fpbreqh_ctry_code_fax%TYPE default NULL)
Validates a requisition header record.
reqn_item_rec
TYPE reqn_item_rec IS RECORD (
reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE ,
item FPRREQD.FPRREQD_ITEM%TYPE ,
activity_date FPRREQD.FPRREQD_ACTIVITY_DATE%TYPE ,
user_id FPRREQD.FPRREQD_USER_ID%TYPE ,
comm_code FPRREQD.FPRREQD_COMM_CODE%TYPE ,
comm_desc FPRREQD.FPRREQD_COMM_DESC%TYPE ,
coas_code FPRREQD.FPRREQD_COAS_CODE%TYPE ,
orgn_code FPRREQD.FPRREQD_ORGN_CODE%TYPE ,
buyr_code FPRREQD.FPRREQD_BUYR_CODE%TYPE ,
qty FPRREQD.FPRREQD_QTY%TYPE ,
uoms_code FPRREQD.FPRREQD_UOMS_CODE%TYPE ,
unit_price FPRREQD.FPRREQD_UNIT_PRICE%TYPE ,
agre_code FPRREQD.FPRREQD_AGRE_CODE%TYPE ,
reqd_date FPRREQD.FPRREQD_REQD_DATE%TYPE ,
ship_code FPRREQD.FPRREQD_SHIP_CODE%TYPE ,
vend_pidm FPRREQD.FPRREQD_VEND_PIDM%TYPE ,
vend_ref_num FPRREQD.FPRREQD_VEND_REF_NUM%TYPE ,
proj_code FPRREQD.FPRREQD_PROJ_CODE%TYPE ,
pohd_code FPRREQD.FPRREQD_POHD_CODE%TYPE ,
pohd_item FPRREQD.FPRREQD_POHD_ITEM%TYPE ,
bids_code FPRREQD.FPRREQD_BIDS_CODE%TYPE ,
complete_ind FPRREQD.FPRREQD_COMPLETE_IND%TYPE ,
susp_ind FPRREQD.FPRREQD_SUSP_IND%TYPE ,
cancel_ind FPRREQD.FPRREQD_CANCEL_IND%TYPE ,
cancel_date FPRREQD.FPRREQD_CANCEL_DATE%TYPE ,
closed_ind FPRREQD.FPRREQD_CLOSED_IND%TYPE ,
post_date FPRREQD.FPRREQD_POST_DATE%TYPE ,
text_usage FPRREQD.FPRREQD_TEXT_USAGE%TYPE ,
atyp_code FPRREQD.FPRREQD_ATYP_CODE%TYPE ,
atyp_seq_num FPRREQD.FPRREQD_ATYP_SEQ_NUM%TYPE ,
recomm_vend_name FPRREQD.FPRREQD_RECOMM_VEND_NAME%TYPE ,
curr_code FPRREQD.FPRREQD_CURR_CODE%TYPE ,
converted_unit_price FPRREQD.FPRREQD_CONVERTED_UNIT_PRICE%TYPE ,
disc_amt FPRREQD.FPRREQD_DISC_AMT%TYPE ,
tax_amt FPRREQD.FPRREQD_TAX_AMT%TYPE ,
addl_chrg_amt FPRREQD.FPRREQD_ADDL_CHRG_AMT%TYPE ,
convert_disc_amt FPRREQD.FPRREQD_CONVERT_DISC_AMT%TYPE ,
convert_tax_amt FPRREQD.FPRREQD_CONVERT_TAX_AMT%TYPE ,
convert_addl_chrg_amt FPRREQD.FPRREQD_CONVERT_ADDL_CHRG_AMT%TYPE ,
tgrp_code FPRREQD.FPRREQD_TGRP_CODE%TYPE ,
amt FPRREQD.FPRREQD_AMT%TYPE,
desc_chge_ind FPRREQD.FPRREQD_DESC_CHGE_IND%TYPE default NULL,
internal_record_id VARCHAR2(18) );
Requisition item record type
reqn_item_ref
TYPE reqn_item_ref IS REF CURSOR RETURN REQN_ITEM_REC;
Requisition item reference cursor
reqn_item_tab
TYPE reqn_item_tab IS TABLE OF REQN_ITEM_REC INDEX BY BINARY_INTEGER;
Requisition item table type
f_exists_item
Function f_exists_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_item FPRREQD.FPRREQD_ITEM%TYPE)
RETURN BOOLEAN
Checks to see if a requisition item record exists.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition item number. NUMBER(4) Required. |
| Returns |
|
TRUE if found, otherwise FALSE. |
f_query_one_item
Function f_query_one_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_item FPRREQD.FPRREQD_ITEM%TYPE)
RETURN reqn_item_ref
Selects one item record using unique columns.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition item number. NUMBER(4) Required. |
| Returns |
|
a cursor variable that will fetch exactly one record. |
f_query_all_item
Function f_query_all_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE) RETURN reqn_item_ref
Selects all the item records for the requisition.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. |
| Returns |
|
a cursor variable that will fetch the set of records. |
p_lock_item
Procedure p_lock_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_item FPRREQD.FPRREQD_ITEM%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
Locks an item record for update.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition item number. NUMBER(4) Required. | |
| p_rowid |
Rowid of the item recocrd. VARCHAR2. |
p_delete_item
Procedure p_delete_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_item FPRREQD.FPRREQD_ITEM%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
Deletes an item record.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition item number. NUMBER(4) Required. | |
| p_rowid |
Rowid of the item recocrd. VARCHAR2. |
p_create_item
Procedure p_create_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_item FPRREQD.FPRREQD_ITEM%TYPE default NULL,
p_activity_date FPRREQD.FPRREQD_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPRREQD.FPRREQD_USER_ID%TYPE default USER,
p_comm_code FPRREQD.FPRREQD_COMM_CODE%TYPE default NULL,
p_comm_desc FPRREQD.FPRREQD_COMM_DESC%TYPE default NULL,
p_coas_code FPRREQD.FPRREQD_COAS_CODE%TYPE default NULL,
p_orgn_code FPRREQD.FPRREQD_ORGN_CODE%TYPE default NULL,
p_buyr_code FPRREQD.FPRREQD_BUYR_CODE%TYPE default NULL,
p_qty FPRREQD.FPRREQD_QTY%TYPE default NULL,
p_uoms_code FPRREQD.FPRREQD_UOMS_CODE%TYPE default NULL,
p_unit_price FPRREQD.FPRREQD_UNIT_PRICE%TYPE default NULL,
p_agre_code FPRREQD.FPRREQD_AGRE_CODE%TYPE default NULL,
p_reqd_date FPRREQD.FPRREQD_REQD_DATE%TYPE default NULL,
p_ship_code FPRREQD.FPRREQD_SHIP_CODE%TYPE default NULL,
p_vend_pidm FPRREQD.FPRREQD_VEND_PIDM%TYPE default NULL,
p_vend_ref_num FPRREQD.FPRREQD_VEND_REF_NUM%TYPE default NULL,
p_proj_code FPRREQD.FPRREQD_PROJ_CODE%TYPE default NULL,
p_pohd_code FPRREQD.FPRREQD_POHD_CODE%TYPE default NULL,
p_pohd_item FPRREQD.FPRREQD_POHD_ITEM%TYPE default NULL,
p_bids_code FPRREQD.FPRREQD_BIDS_CODE%TYPE default NULL,
p_complete_ind FPRREQD.FPRREQD_COMPLETE_IND%TYPE default NULL,
p_susp_ind FPRREQD.FPRREQD_SUSP_IND%TYPE default NULL,
p_cancel_ind FPRREQD.FPRREQD_CANCEL_IND%TYPE default NULL,
p_cancel_date FPRREQD.FPRREQD_CANCEL_DATE%TYPE default NULL,
p_closed_ind FPRREQD.FPRREQD_CLOSED_IND%TYPE default NULL,
p_post_date FPRREQD.FPRREQD_POST_DATE%TYPE default NULL,
p_text_usage FPRREQD.FPRREQD_TEXT_USAGE%TYPE default NULL,
p_atyp_code FPRREQD.FPRREQD_ATYP_CODE%TYPE default NULL,
p_atyp_seq_num FPRREQD.FPRREQD_ATYP_SEQ_NUM%TYPE default NULL,
p_recomm_vend_name FPRREQD.FPRREQD_RECOMM_VEND_NAME%TYPE default NULL,
p_curr_code FPRREQD.FPRREQD_CURR_CODE%TYPE default NULL,
p_converted_unit_price FPRREQD.FPRREQD_CONVERTED_UNIT_PRICE%TYPE default NULL,
p_disc_amt FPRREQD.FPRREQD_DISC_AMT%TYPE default NULL,
p_tax_amt FPRREQD.FPRREQD_TAX_AMT%TYPE default NULL,
p_addl_chrg_amt FPRREQD.FPRREQD_ADDL_CHRG_AMT%TYPE default NULL,
p_convert_disc_amt FPRREQD.FPRREQD_CONVERT_DISC_AMT%TYPE default NULL,
p_convert_tax_amt FPRREQD.FPRREQD_CONVERT_TAX_AMT%TYPE default NULL,
p_convert_addl_chrg_amt FPRREQD.FPRREQD_CONVERT_ADDL_CHRG_AMT%TYPE default NULL,
p_tgrp_code FPRREQD.FPRREQD_TGRP_CODE%TYPE default NULL,
p_amt FPRREQD.FPRREQD_AMT%TYPE default NULL,
p_desc_chge_ind FPRREQD.FPRREQD_DESC_CHGE_IND%TYPE default NULL,
p_print_text VARCHAR2,
p_noprint_text VARCHAR2,
p_rowid OUT VARCHAR2)
Creates an item record.
p_update_item
Procedure p_update_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_item FPRREQD.FPRREQD_ITEM%TYPE default NULL,
p_activity_date FPRREQD.FPRREQD_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPRREQD.FPRREQD_USER_ID%TYPE default USER,
p_comm_code FPRREQD.FPRREQD_COMM_CODE%TYPE default NULL,
p_comm_desc FPRREQD.FPRREQD_COMM_DESC%TYPE default NULL,
p_coas_code FPRREQD.FPRREQD_COAS_CODE%TYPE default NULL,
p_orgn_code FPRREQD.FPRREQD_ORGN_CODE%TYPE default NULL,
p_buyr_code FPRREQD.FPRREQD_BUYR_CODE%TYPE default NULL,
p_qty FPRREQD.FPRREQD_QTY%TYPE default NULL,
p_uoms_code FPRREQD.FPRREQD_UOMS_CODE%TYPE default NULL,
p_unit_price FPRREQD.FPRREQD_UNIT_PRICE%TYPE default NULL,
p_agre_code FPRREQD.FPRREQD_AGRE_CODE%TYPE default NULL,
p_reqd_date FPRREQD.FPRREQD_REQD_DATE%TYPE default NULL,
p_ship_code FPRREQD.FPRREQD_SHIP_CODE%TYPE default NULL,
p_vend_pidm FPRREQD.FPRREQD_VEND_PIDM%TYPE default NULL,
p_vend_ref_num FPRREQD.FPRREQD_VEND_REF_NUM%TYPE default NULL,
p_proj_code FPRREQD.FPRREQD_PROJ_CODE%TYPE default NULL,
p_pohd_code FPRREQD.FPRREQD_POHD_CODE%TYPE default NULL,
p_pohd_item FPRREQD.FPRREQD_POHD_ITEM%TYPE default NULL,
p_bids_code FPRREQD.FPRREQD_BIDS_CODE%TYPE default NULL,
p_complete_ind FPRREQD.FPRREQD_COMPLETE_IND%TYPE default NULL,
p_susp_ind FPRREQD.FPRREQD_SUSP_IND%TYPE default NULL,
p_cancel_ind FPRREQD.FPRREQD_CANCEL_IND%TYPE default NULL,
p_cancel_date FPRREQD.FPRREQD_CANCEL_DATE%TYPE default NULL,
p_closed_ind FPRREQD.FPRREQD_CLOSED_IND%TYPE default NULL,
p_post_date FPRREQD.FPRREQD_POST_DATE%TYPE default NULL,
p_text_usage FPRREQD.FPRREQD_TEXT_USAGE%TYPE default NULL,
p_atyp_code FPRREQD.FPRREQD_ATYP_CODE%TYPE default NULL,
p_atyp_seq_num FPRREQD.FPRREQD_ATYP_SEQ_NUM%TYPE default NULL,
p_recomm_vend_name FPRREQD.FPRREQD_RECOMM_VEND_NAME%TYPE default NULL,
p_curr_code FPRREQD.FPRREQD_CURR_CODE%TYPE default NULL,
p_converted_unit_price FPRREQD.FPRREQD_CONVERTED_UNIT_PRICE%TYPE default NULL,
p_disc_amt FPRREQD.FPRREQD_DISC_AMT%TYPE default NULL,
p_tax_amt FPRREQD.FPRREQD_TAX_AMT%TYPE default NULL,
p_addl_chrg_amt FPRREQD.FPRREQD_ADDL_CHRG_AMT%TYPE default NULL,
p_convert_disc_amt FPRREQD.FPRREQD_CONVERT_DISC_AMT%TYPE default NULL,
p_convert_tax_amt FPRREQD.FPRREQD_CONVERT_TAX_AMT%TYPE default NULL,
p_convert_addl_chrg_amt FPRREQD.FPRREQD_CONVERT_ADDL_CHRG_AMT%TYPE default NULL,
p_tgrp_code FPRREQD.FPRREQD_TGRP_CODE%TYPE default NULL,
p_amt FPRREQD.FPRREQD_AMT%TYPE default NULL,
p_desc_chge_ind FPRREQD.FPRREQD_DESC_CHGE_IND%TYPE default NULL,
p_rowid VARCHAR2 default NULL)
Updates an item record.
p_validate_item
Procedure p_validate_item(p_reqh_code FPRREQD.FPRREQD_REQH_CODE%TYPE,
p_item FPRREQD.FPRREQD_ITEM%TYPE default NULL,
p_activity_date FPRREQD.FPRREQD_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPRREQD.FPRREQD_USER_ID%TYPE default USER,
p_comm_code FPRREQD.FPRREQD_COMM_CODE%TYPE default NULL,
p_comm_desc FPRREQD.FPRREQD_COMM_DESC%TYPE default NULL,
p_coas_code FPRREQD.FPRREQD_COAS_CODE%TYPE default NULL,
p_orgn_code FPRREQD.FPRREQD_ORGN_CODE%TYPE default NULL,
p_buyr_code FPRREQD.FPRREQD_BUYR_CODE%TYPE default NULL,
p_qty FPRREQD.FPRREQD_QTY%TYPE default NULL,
p_uoms_code FPRREQD.FPRREQD_UOMS_CODE%TYPE default NULL,
p_unit_price FPRREQD.FPRREQD_UNIT_PRICE%TYPE default NULL,
p_agre_code FPRREQD.FPRREQD_AGRE_CODE%TYPE default NULL,
p_reqd_date FPRREQD.FPRREQD_REQD_DATE%TYPE default NULL,
p_ship_code FPRREQD.FPRREQD_SHIP_CODE%TYPE default NULL,
p_vend_pidm FPRREQD.FPRREQD_VEND_PIDM%TYPE default NULL,
p_vend_ref_num FPRREQD.FPRREQD_VEND_REF_NUM%TYPE default NULL,
p_proj_code FPRREQD.FPRREQD_PROJ_CODE%TYPE default NULL,
p_pohd_code FPRREQD.FPRREQD_POHD_CODE%TYPE default NULL,
p_pohd_item FPRREQD.FPRREQD_POHD_ITEM%TYPE default NULL,
p_bids_code FPRREQD.FPRREQD_BIDS_CODE%TYPE default NULL,
p_complete_ind FPRREQD.FPRREQD_COMPLETE_IND%TYPE default NULL,
p_susp_ind FPRREQD.FPRREQD_SUSP_IND%TYPE default NULL,
p_cancel_ind FPRREQD.FPRREQD_CANCEL_IND%TYPE default NULL,
p_cancel_date FPRREQD.FPRREQD_CANCEL_DATE%TYPE default NULL,
p_closed_ind FPRREQD.FPRREQD_CLOSED_IND%TYPE default NULL,
p_post_date FPRREQD.FPRREQD_POST_DATE%TYPE default NULL,
p_text_usage FPRREQD.FPRREQD_TEXT_USAGE%TYPE default NULL,
p_atyp_code FPRREQD.FPRREQD_ATYP_CODE%TYPE default NULL,
p_atyp_seq_num FPRREQD.FPRREQD_ATYP_SEQ_NUM%TYPE default NULL,
p_recomm_vend_name FPRREQD.FPRREQD_RECOMM_VEND_NAME%TYPE default NULL,
p_curr_code FPRREQD.FPRREQD_CURR_CODE%TYPE default NULL,
p_converted_unit_price FPRREQD.FPRREQD_CONVERTED_UNIT_PRICE%TYPE default NULL,
p_disc_amt FPRREQD.FPRREQD_DISC_AMT%TYPE default NULL,
p_tax_amt FPRREQD.FPRREQD_TAX_AMT%TYPE default NULL,
p_addl_chrg_amt FPRREQD.FPRREQD_ADDL_CHRG_AMT%TYPE default NULL,
p_convert_disc_amt FPRREQD.FPRREQD_CONVERT_DISC_AMT%TYPE default NULL,
p_convert_tax_amt FPRREQD.FPRREQD_CONVERT_TAX_AMT%TYPE default NULL,
p_convert_addl_chrg_amt FPRREQD.FPRREQD_CONVERT_ADDL_CHRG_AMT%TYPE default NULL,
p_tgrp_code FPRREQD.FPRREQD_TGRP_CODE%TYPE default NULL,
p_amt FPRREQD.FPRREQD_AMT%TYPE default NULL,
p_desc_chge_ind FPRREQD.FPRREQD_DESC_CHGE_IND%TYPE default NULL)
Validates an item record.
reqn_accounting_rec
TYPE reqn_accounting_rec IS RECORD (
reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE ,
item FPRREQA.FPRREQA_ITEM%TYPE ,
seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE ,
activity_date FPRREQA.FPRREQA_ACTIVITY_DATE%TYPE ,
user_id FPRREQA.FPRREQA_USER_ID%TYPE ,
pct FPRREQA.FPRREQA_PCT%TYPE ,
amt FPRREQA.FPRREQA_AMT%TYPE ,
fsyr_code FPRREQA.FPRREQA_FSYR_CODE%TYPE ,
period FPRREQA.FPRREQA_PERIOD%TYPE ,
rucl_code FPRREQA.FPRREQA_RUCL_CODE%TYPE ,
coas_code FPRREQA.FPRREQA_COAS_CODE%TYPE ,
acci_code FPRREQA.FPRREQA_ACCI_CODE%TYPE ,
fund_code FPRREQA.FPRREQA_FUND_CODE%TYPE ,
orgn_code FPRREQA.FPRREQA_ORGN_CODE%TYPE ,
acct_code FPRREQA.FPRREQA_ACCT_CODE%TYPE ,
prog_code FPRREQA.FPRREQA_PROG_CODE%TYPE ,
actv_code FPRREQA.FPRREQA_ACTV_CODE%TYPE ,
locn_code FPRREQA.FPRREQA_LOCN_CODE%TYPE ,
susp_ind FPRREQA.FPRREQA_SUSP_IND%TYPE ,
nsf_susp_ind FPRREQA.FPRREQA_NSF_SUSP_IND%TYPE ,
cancel_ind FPRREQA.FPRREQA_CANCEL_IND%TYPE ,
cancel_date FPRREQA.FPRREQA_CANCEL_DATE%TYPE ,
proj_code FPRREQA.FPRREQA_PROJ_CODE%TYPE ,
appr_ind FPRREQA.FPRREQA_APPR_IND%TYPE ,
nsf_override_ind FPRREQA.FPRREQA_NSF_OVERRIDE_IND%TYPE ,
abal_ind FPRREQA.FPRREQA_ABAL_IND%TYPE ,
converted_amt FPRREQA.FPRREQA_CONVERTED_AMT%TYPE ,
closed_ind FPRREQA.FPRREQA_CLOSED_IND%TYPE ,
disc_amt FPRREQA.FPRREQA_DISC_AMT%TYPE ,
tax_amt FPRREQA.FPRREQA_TAX_AMT%TYPE ,
addl_chrg_amt FPRREQA.FPRREQA_ADDL_CHRG_AMT%TYPE ,
convert_disc_amt FPRREQA.FPRREQA_CONVERT_DISC_AMT%TYPE ,
convert_tax_amt FPRREQA.FPRREQA_CONVERT_TAX_AMT%TYPE ,
convert_addl_chrg_amt FPRREQA.FPRREQA_CONVERT_ADDL_CHRG_AMT%TYPE ,
disc_amt_pct FPRREQA.FPRREQA_DISC_AMT_PCT%TYPE ,
addl_amt_pct FPRREQA.FPRREQA_ADDL_AMT_PCT%TYPE ,
tax_amt_pct FPRREQA.FPRREQA_TAX_AMT_PCT%TYPE ,
disc_rucl_code FPRREQA.FPRREQA_DISC_RUCL_CODE%TYPE ,
tax_rucl_code FPRREQA.FPRREQA_TAX_RUCL_CODE%TYPE ,
addl_rucl_code FPRREQA.FPRREQA_ADDL_RUCL_CODE%TYPE ,
rucl_code_liq FPRREQA.FPRREQA_RUCL_CODE_LIQ%TYPE ,
internal_record_id VARCHAR2(18)
);
Requisition accounting record type
reqn_accounting_ref
TYPE reqn_accounting_ref IS REF CURSOR RETURN REQN_ACCOUNTING_REC;
Requisition accounting reference cursor
reqn_accounting_tab
TYPE reqn_accounting_tab IS TABLE OF REQN_ACCOUNTING_REC INDEX BY BINARY_INTEGER;
Requisition accounting table type
f_exists_accounting
Function f_exists_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE,
p_seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE)
RETURN BOOLEAN
Checks to see if a requisition accounting record exists.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition item number. NUMBER(4) Required. | |
| p_seq_num |
The requisition accounting sequence number. NUMBER(4) Required. |
| Returns |
|
TRUE if found, otherwise FALSE. |
f_query_one_accounting
Function f_query_one_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE,
p_seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE)
RETURN reqn_accounting_ref
Selects one accounting record using unique columns.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition item number. NUMBER(4) Required. |
| Returns |
|
a cursor variable that will fetch exactly one record. |
f_query_all_accounting
Function f_query_all_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE default NULL)
RETURN reqn_accounting_ref
Selects all the records for the requisition accounting item.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition accounting item number. NUMBER(4) Required. |
| Returns |
|
a cursor variable that will fetch the set of records. |
p_lock_accounting
Procedure p_lock_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE,
p_seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
Locks an accounting record for update.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition accounting item number. NUMBER(4) Required. | |
| p_seq_num |
The requisition accounting sequence number. NUMBER(4) Required. | |
| p_rowid |
Rowid of the accounting recocrd. VARCHAR2. |
p_delete_accounting
Procedure p_delete_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE,
p_seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
Deletes an accounting record.
| Parameters |
| p_reqh_code |
The requisition code. VARCHAR2(8) Required. | |
| p_item |
The requisition item number. NUMBER(4) Required. | |
| p_seq_num |
The requisition accounting sequence number. NUMBER(4) Required. | |
| p_rowid |
Rowid of the accounting recocrd. VARCHAR2. |
p_create_accounting
Procedure p_create_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE default NULL,
p_seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE default NULL,
p_activity_date FPRREQA.FPRREQA_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPRREQA.FPRREQA_USER_ID%TYPE default USER,
p_pct FPRREQA.FPRREQA_PCT%TYPE default NULL,
p_amt FPRREQA.FPRREQA_AMT%TYPE default NULL,
p_fsyr_code FPRREQA.FPRREQA_FSYR_CODE%TYPE default NULL,
p_period FPRREQA.FPRREQA_PERIOD%TYPE default NULL,
p_rucl_code FPRREQA.FPRREQA_RUCL_CODE%TYPE default NULL,
p_coas_code FPRREQA.FPRREQA_COAS_CODE%TYPE default NULL,
p_acci_code FPRREQA.FPRREQA_ACCI_CODE%TYPE default NULL,
p_fund_code FPRREQA.FPRREQA_FUND_CODE%TYPE default NULL,
p_orgn_code FPRREQA.FPRREQA_ORGN_CODE%TYPE default NULL,
p_acct_code FPRREQA.FPRREQA_ACCT_CODE%TYPE default NULL,
p_prog_code FPRREQA.FPRREQA_PROG_CODE%TYPE default NULL,
p_actv_code FPRREQA.FPRREQA_ACTV_CODE%TYPE default NULL,
p_locn_code FPRREQA.FPRREQA_LOCN_CODE%TYPE default NULL,
p_susp_ind FPRREQA.FPRREQA_SUSP_IND%TYPE default NULL,
p_nsf_susp_ind FPRREQA.FPRREQA_NSF_SUSP_IND%TYPE default NULL,
p_cancel_ind FPRREQA.FPRREQA_CANCEL_IND%TYPE default NULL,
p_cancel_date FPRREQA.FPRREQA_CANCEL_DATE%TYPE default NULL,
p_proj_code FPRREQA.FPRREQA_PROJ_CODE%TYPE default NULL,
p_appr_ind FPRREQA.FPRREQA_APPR_IND%TYPE default NULL,
p_nsf_override_ind FPRREQA.FPRREQA_NSF_OVERRIDE_IND%TYPE default NULL,
p_abal_ind FPRREQA.FPRREQA_ABAL_IND%TYPE default NULL,
p_converted_amt FPRREQA.FPRREQA_CONVERTED_AMT%TYPE default NULL,
p_closed_ind FPRREQA.FPRREQA_CLOSED_IND%TYPE default NULL,
p_disc_amt FPRREQA.FPRREQA_DISC_AMT%TYPE default NULL,
p_tax_amt FPRREQA.FPRREQA_TAX_AMT%TYPE default NULL,
p_addl_chrg_amt FPRREQA.FPRREQA_ADDL_CHRG_AMT%TYPE default NULL,
p_convert_disc_amt FPRREQA.FPRREQA_CONVERT_DISC_AMT%TYPE default NULL,
p_convert_tax_amt FPRREQA.FPRREQA_CONVERT_TAX_AMT%TYPE default NULL,
p_convert_addl_chrg_amt FPRREQA.FPRREQA_CONVERT_ADDL_CHRG_AMT%TYPE default NULL,
p_disc_amt_pct FPRREQA.FPRREQA_DISC_AMT_PCT%TYPE default NULL,
p_addl_amt_pct FPRREQA.FPRREQA_ADDL_AMT_PCT%TYPE default NULL,
p_tax_amt_pct FPRREQA.FPRREQA_TAX_AMT_PCT%TYPE default NULL,
p_disc_rucl_code FPRREQA.FPRREQA_DISC_RUCL_CODE%TYPE default NULL,
p_tax_rucl_code FPRREQA.FPRREQA_TAX_RUCL_CODE%TYPE default NULL,
p_addl_rucl_code FPRREQA.FPRREQA_ADDL_RUCL_CODE%TYPE default NULL,
p_rucl_code_liq FPRREQA.FPRREQA_RUCL_CODE_LIQ%TYPE default NULL,
p_rowid OUT VARCHAR2)
Creates an accounting record.
p_update_accounting
Procedure p_update_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE default NULL,
p_seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE default NULL,
p_activity_date FPRREQA.FPRREQA_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPRREQA.FPRREQA_USER_ID%TYPE default USER,
p_pct FPRREQA.FPRREQA_PCT%TYPE default NULL,
p_amt FPRREQA.FPRREQA_AMT%TYPE default NULL,
p_fsyr_code FPRREQA.FPRREQA_FSYR_CODE%TYPE default NULL,
p_period FPRREQA.FPRREQA_PERIOD%TYPE default NULL,
p_rucl_code FPRREQA.FPRREQA_RUCL_CODE%TYPE default NULL,
p_coas_code FPRREQA.FPRREQA_COAS_CODE%TYPE default NULL,
p_acci_code FPRREQA.FPRREQA_ACCI_CODE%TYPE default NULL,
p_fund_code FPRREQA.FPRREQA_FUND_CODE%TYPE default NULL,
p_orgn_code FPRREQA.FPRREQA_ORGN_CODE%TYPE default NULL,
p_acct_code FPRREQA.FPRREQA_ACCT_CODE%TYPE default NULL,
p_prog_code FPRREQA.FPRREQA_PROG_CODE%TYPE default NULL,
p_actv_code FPRREQA.FPRREQA_ACTV_CODE%TYPE default NULL,
p_locn_code FPRREQA.FPRREQA_LOCN_CODE%TYPE default NULL,
p_susp_ind FPRREQA.FPRREQA_SUSP_IND%TYPE default NULL,
p_nsf_susp_ind FPRREQA.FPRREQA_NSF_SUSP_IND%TYPE default NULL,
p_cancel_ind FPRREQA.FPRREQA_CANCEL_IND%TYPE default NULL,
p_cancel_date FPRREQA.FPRREQA_CANCEL_DATE%TYPE default NULL,
p_proj_code FPRREQA.FPRREQA_PROJ_CODE%TYPE default NULL,
p_appr_ind FPRREQA.FPRREQA_APPR_IND%TYPE default NULL,
p_nsf_override_ind FPRREQA.FPRREQA_NSF_OVERRIDE_IND%TYPE default NULL,
p_abal_ind FPRREQA.FPRREQA_ABAL_IND%TYPE default NULL,
p_converted_amt FPRREQA.FPRREQA_CONVERTED_AMT%TYPE default NULL,
p_closed_ind FPRREQA.FPRREQA_CLOSED_IND%TYPE default NULL,
p_disc_amt FPRREQA.FPRREQA_DISC_AMT%TYPE default NULL,
p_tax_amt FPRREQA.FPRREQA_TAX_AMT%TYPE default NULL,
p_addl_chrg_amt FPRREQA.FPRREQA_ADDL_CHRG_AMT%TYPE default NULL,
p_convert_disc_amt FPRREQA.FPRREQA_CONVERT_DISC_AMT%TYPE default NULL,
p_convert_tax_amt FPRREQA.FPRREQA_CONVERT_TAX_AMT%TYPE default NULL,
p_convert_addl_chrg_amt FPRREQA.FPRREQA_CONVERT_ADDL_CHRG_AMT%TYPE default NULL,
p_disc_amt_pct FPRREQA.FPRREQA_DISC_AMT_PCT%TYPE default NULL,
p_addl_amt_pct FPRREQA.FPRREQA_ADDL_AMT_PCT%TYPE default NULL,
p_tax_amt_pct FPRREQA.FPRREQA_TAX_AMT_PCT%TYPE default NULL,
p_disc_rucl_code FPRREQA.FPRREQA_DISC_RUCL_CODE%TYPE default NULL,
p_tax_rucl_code FPRREQA.FPRREQA_TAX_RUCL_CODE%TYPE default NULL,
p_addl_rucl_code FPRREQA.FPRREQA_ADDL_RUCL_CODE%TYPE default NULL,
p_rucl_code_liq FPRREQA.FPRREQA_RUCL_CODE_LIQ%TYPE default NULL,
p_rowid VARCHAR2 default NULL)
Updates an accounting record.
p_validate_accounting
Procedure p_validate_accounting(p_reqh_code FPRREQA.FPRREQA_REQH_CODE%TYPE,
p_item FPRREQA.FPRREQA_ITEM%TYPE default NULL,
p_seq_num FPRREQA.FPRREQA_SEQ_NUM%TYPE default NULL,
p_activity_date FPRREQA.FPRREQA_ACTIVITY_DATE%TYPE default sysdate,
p_user_id FPRREQA.FPRREQA_USER_ID%TYPE default USER,
p_pct FPRREQA.FPRREQA_PCT%TYPE default NULL,
p_amt FPRREQA.FPRREQA_AMT%TYPE default NULL,
p_fsyr_code FPRREQA.FPRREQA_FSYR_CODE%TYPE default NULL,
p_period FPRREQA.FPRREQA_PERIOD%TYPE default NULL,
p_rucl_code FPRREQA.FPRREQA_RUCL_CODE%TYPE default NULL,
p_coas_code FPRREQA.FPRREQA_COAS_CODE%TYPE default NULL,
p_acci_code FPRREQA.FPRREQA_ACCI_CODE%TYPE default NULL,
p_fund_code FPRREQA.FPRREQA_FUND_CODE%TYPE default NULL,
p_orgn_code FPRREQA.FPRREQA_ORGN_CODE%TYPE default NULL,
p_acct_code FPRREQA.FPRREQA_ACCT_CODE%TYPE default NULL,
p_prog_code FPRREQA.FPRREQA_PROG_CODE%TYPE default NULL,
p_actv_code FPRREQA.FPRREQA_ACTV_CODE%TYPE default NULL,
p_locn_code FPRREQA.FPRREQA_LOCN_CODE%TYPE default NULL,
p_susp_ind FPRREQA.FPRREQA_SUSP_IND%TYPE default NULL,
p_nsf_susp_ind FPRREQA.FPRREQA_NSF_SUSP_IND%TYPE default NULL,
p_cancel_ind FPRREQA.FPRREQA_CANCEL_IND%TYPE default NULL,
p_cancel_date FPRREQA.FPRREQA_CANCEL_DATE%TYPE default NULL,
p_proj_code FPRREQA.FPRREQA_PROJ_CODE%TYPE default NULL,
p_appr_ind FPRREQA.FPRREQA_APPR_IND%TYPE default NULL,
p_nsf_override_ind FPRREQA.FPRREQA_NSF_OVERRIDE_IND%TYPE default NULL,
p_abal_ind FPRREQA.FPRREQA_ABAL_IND%TYPE default NULL,
p_converted_amt FPRREQA.FPRREQA_CONVERTED_AMT%TYPE default NULL,
p_closed_ind FPRREQA.FPRREQA_CLOSED_IND%TYPE default NULL,
p_disc_amt FPRREQA.FPRREQA_DISC_AMT%TYPE default NULL,
p_tax_amt FPRREQA.FPRREQA_TAX_AMT%TYPE default NULL,
p_addl_chrg_amt FPRREQA.FPRREQA_ADDL_CHRG_AMT%TYPE default NULL,
p_convert_disc_amt FPRREQA.FPRREQA_CONVERT_DISC_AMT%TYPE default NULL,
p_convert_tax_amt FPRREQA.FPRREQA_CONVERT_TAX_AMT%TYPE default NULL,
p_convert_addl_chrg_amt FPRREQA.FPRREQA_CONVERT_ADDL_CHRG_AMT%TYPE default NULL,
p_disc_amt_pct FPRREQA.FPRREQA_DISC_AMT_PCT%TYPE default NULL,
p_addl_amt_pct FPRREQA.FPRREQA_ADDL_AMT_PCT%TYPE default NULL,
p_tax_amt_pct FPRREQA.FPRREQA_TAX_AMT_PCT%TYPE default NULL,
p_disc_rucl_code FPRREQA.FPRREQA_DISC_RUCL_CODE%TYPE default NULL,
p_tax_rucl_code FPRREQA.FPRREQA_TAX_RUCL_CODE%TYPE default NULL,
p_addl_rucl_code FPRREQA.FPRREQA_ADDL_RUCL_CODE%TYPE default NULL,
p_rucl_code_liq FPRREQA.FPRREQA_RUCL_CODE_LIQ%TYPE default NULL)
Validates an accounting record.
f_complete_req
Function f_complete_req(p_code FPBREQH.FPBREQH_CODE%TYPE) RETURN string_nt
Wrap up logic for document completion.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. |
| Returns |
|
messages generated during the completion process. |
f_get_tax_amts_and_budg_auth
Function f_get_tax_amts_and_budg_auth(p_code fpbreqh.fpbreqh_code%TYPE,
p_change_seq_num NUMBER DEFAULT NULL)
RETURN foksels.ref_cursortype
Wrap up logic to perform completion logic and get tax amounts
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. | |
| p_change_seq_num |
The change sequence number. NUMBER. |
| Returns |
|
a cursor variable that will fetch the set of records of item tax and accounting tax. |
f_req_posted
Function f_req_posted(p_code FPBREQH.FPBREQH_CODE%TYPE) RETURN BOOLEAN
Checks to see if a requisition is posted.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. |
| Returns |
|
TRUE if posted, otherwise FALSE. |
f_req_status
Function f_req_status(p_code fpbreqh.fpbreqh_code%type default null,
p_doc_ref_Code fpbreqh.fpbreqh_doc_ref_code%type default null,
reqh_rec fpbreqh%rowtype default NULL)
return varchar2
Checks the requisition status.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8). | |
| p_doc_ref_code |
Requisition reference code. VARCHAR2(20). | |
| reqh_rec |
The requisition header record. fpbreqh%ROWTYPE. |
| Returns |
|
the status as CANCELLED, DISPATCHED or PENDING. |
f_is_eproc_req
Function f_is_eproc_req(p_code fpbreqh.fpbreqh_code%type,
action varchar2 default null) return varchar2
Checks to see if the requisition is an e-Procurement requisition.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8). | |
| action |
The CREATE, UPDATE or DELETE action for the requisition record. VARCHAR2. |
| Returns |
|
Y if it is, otherwise N. |
f_doc_ref_code_exists
Function f_doc_ref_code_exists(p_doc_ref_code varchar2) RETURN BOOLEAN
Checks to see if a requisition reference code exists.
| Parameters |
| p_doc_ref_code |
Requisition reference code. VARCHAR2(20) Required.. |
| Returns |
|
TRUE if exists, otherwise FALSE. |
f_document_ref_code_exists
Function f_document_ref_code_exists(p_doc_ref_code varchar2) RETURN VARCHAR2
Checks to see if a requisition reference code exists.
| Parameters |
| p_doc_ref_code |
Requisition reference code. VARCHAR2(20) Required.. |
| Returns |
|
TRUE as VARCHAR2 data type if exists, otherwise FALSE as VARCHAR2 data type. |
f_get_doc_ref_code
Function f_get_doc_ref_code(p_code FPBREQH.FPBREQH_CODE%TYPE) RETURN VARCHAR2
Selects a requisition reference code.
| Parameters |
| p_code |
The requisition code. VARCHAR2(8) Required. | |
| p_change_seq_num |
The requisition change sequence number. NUMBER(3). |
| Returns |
|
requisition reference code. |
f_get_doc_code
Function f_get_doc_code(p_doc_ref_code varchar2) RETURN VARCHAR2
Selects a requisition code.
| Parameters |
| p_doc_ref_code |
Requisition reference code. VARCHAR2(20) Required.. |
| Returns |
|
requisition code. |
f_get_cancel_mesg
Function f_get_cancel_mesg RETURN varchar2
Selects a requisition cancellation message.
| Returns |
|
cancellation message. |
f_get_status_code
Function f_get_status_code(which_status varchar2) RETURN varchar2
Selects a requisition status code.
| Returns |
|
requisition status code. |