|
Package BANINST1.Fpkpurr Common routines for purchase order (FPKPURR). |
| Program units |
| f_fpbpohd_ref | Selects purchase order header record. |
| f_fprpodt_ref | Selects purchase order item records. |
| f_fprpoda_ref | Selects purchase order accounting records. |
| p_create_po | Creates a complete set of purchase order records. |
| p_complete_po | Performs a full set of validations to complete a purchase order. |
| p_change_order_in_process | |
| p_scrub_header | Scrubs the purchase order header values. |
| p_validate_header | Validates the purchase order header data. |
| p_create_header | Creates purchase order header record using passed in po_headentry_rectype. |
| p_create_header | Creates purchase order header record using passed in pohd_headentry_rectype. |
| p_delete_header | Cancels purchase order header record using passed in pohd_headentry_rectype. |
| p_scrub_item | Scrubs the purchase order item values. |
| p_validate_item | Validates purchase order item data. |
| p_create_item | Creates purchase order item record using passed in podt_itemsentry_rectype. |
| p_create_item | Creates purchase order item record using passed in po_itemsentry_rectype. |
| p_delete_item | Cancels purchase order item record using passed in po_itemsentry_rectype. |
| p_update_item | Updates purchase order item record using passed in po_itemsentry_rectype. |
| p_scrub_acctg | Scrubs the purchase order accounting values. |
| p_validate_acctg | Validates purchase order accounting data. |
| p_create_acctg | Creates purchase order accounting record using passed in po_acctgentry_rectype. |
| p_create_acctg | Creates purchase order accounting record using passed in poda_acctgentry_rectype. |
| p_delete_acctg | Cancels purchase order accounting record using passed in poda_acctgentry_rectype. |
| p_update_acctg | Updates purchase order accounting record using passed in poda_acctgentry_rectype. |
| p_check_vendor_po_hold | Checks if the purchase order vendor is on hold and if the user is authorized to override this hold. |
| p_po_close_req | Closes the requisition header, item and accounting records for a completed inventory purchase order referencing this requisition. |
| p_po_open_req | Opens the requisition header, item and accounting records for a canceled inventory purchase order referencing this requisition. |
| p_req_open_close | This procedure calls p_po_close_req to close a requisition or calls p_po_open_req to open a requisition depending on the value of the passed in parameter op_type, which can be C(lose) or O(pen). |
| Types |
| po_headentry_rectype | Purchase order header data entry record type |
| po_itemsentry_rectype | Purchase order item data entry record type |
| po_acctgentry_rectype | Purchase order accounting data entry record type |
| po_itemsentry_tabtype | Purchase order item data entry table type |
| po_acctgentry_tabtype | Purchase order accounting data entry table type |
| pohd_headentry_rectype | Purchase order header record type |
| podt_itemsentry_rectype | Purchase order item record type |
| poda_acctgentry_rectype | Purchase order accounting record type |
| podt_itemsentry_tabtype | Purchase order item table type for podt_itemsentry_rectype |
| poda_acctgentry_tabtype | Purchase order accounting table type for poda_acctgentry_rectype |
| fprpodt_tabletype | Purchase order item table type for rowtype |
| fprpoda_tabletype | Purchase order accounting table type for rowtype |
po_headentry_rectype
TYPE po_headentry_rectype IS RECORD (
po_code FPKUTIL.MAX_DATA_ENTRY ,
po_change_seq_num FPKUTIL.MAX_DATA_ENTRY,
po_userid FPKUTIL.MAX_DATA_ENTRY,
po_order_date FPKUTIL.MAX_DATA_ENTRY,
po_trans_date FPKUTIL.MAX_DATA_ENTRY,
po_vend_id FPKUTIL.MAX_DATA_ENTRY,
po_addr_type FPKUTIL.MAX_DATA_ENTRY,
po_addr_seq_no FPKUTIL.MAX_DATA_ENTRY,
po_buyr_code FPKUTIL.MAX_DATA_ENTRY,
po_deliv_date FPKUTIL.MAX_DATA_ENTRY,
po_coas FPKUTIL.MAX_DATA_ENTRY,
po_orgn FPKUTIL.MAX_DATA_ENTRY,
po_ship_code FPKUTIL.MAX_DATA_ENTRY,
po_disc_code FPKUTIL.MAX_DATA_ENTRY,
po_print_text FOTTEXT.FOTTEXT_TEXT%TYPE,
po_noprint_text FOTTEXT.FOTTEXT_TEXT%TYPE,
po_tgrp_code FPKUTIL.MAX_DATA_ENTRY,
po_curr_code FPKUTIL.MAX_DATA_ENTRY,
po_acctg_type FPKUTIL.MAX_DATA_ENTRY,
po_email_addr FPKUTIL.MAX_DATA_ENTRY,
po_fax_area FPKUTIL.MAX_DATA_ENTRY,
po_fax_number FPKUTIL.MAX_DATA_ENTRY,
po_fax_ext FPKUTIL.MAX_DATA_ENTRY,
po_attn_to FPKUTIL.MAX_DATA_ENTRY,
po_vend_contact FPKUTIL.MAX_DATA_ENTRY,
po_deliv_comment FPKUTIL.MAX_DATA_ENTRY,
po_vend_email FPKUTIL.MAX_DATA_ENTRY,
po_requestor FPKUTIL.MAX_DATA_ENTRY,
po_phone_area FPKUTIL.MAX_DATA_ENTRY,
po_phone_num FPKUTIL.MAX_DATA_ENTRY,
po_phone_ext FPKUTIL.MAX_DATA_ENTRY,
po_edi_ind FPKUTIL.MAX_DATA_ENTRY,
po_ftrm_code FPKUTIL.MAX_DATA_ENTRY,
po_origin FPKUTIL.MAX_DATA_ENTRY,
po_type FPKUTIL.MAX_DATA_ENTRY,
po_doc_ref FPKUTIL.MAX_DATA_ENTRY,
po_ctry_code_phone FPKUTIL.MAX_DATA_ENTRY,
po_ctry_code_fax FPKUTIL.MAX_DATA_ENTRY
);
Purchase order header data entry record type
po_itemsentry_rectype
TYPE po_itemsentry_rectype IS RECORD ( po_code FPKUTIL.MAX_DATA_ENTRY, po_change_seq_num FPKUTIL.MAX_DATA_ENTRY, po_itemnum FPKUTIL.MAX_DATA_ENTRY, po_comm_code FPKUTIL.MAX_DATA_ENTRY, po_comm_desc FPKUTIL.MAX_DATA_ENTRY, po_uom FPKUTIL.MAX_DATA_ENTRY, po_unit_price FPKUTIL.MAX_DATA_ENTRY, po_quantity FPKUTIL.MAX_DATA_ENTRY, po_disc_amt FPKUTIL.MAX_DATA_ENTRY, po_addl_amt FPKUTIL.MAX_DATA_ENTRY, po_tax_amt FPKUTIL.MAX_DATA_ENTRY, po_tgrp_code FPKUTIL.MAX_DATA_ENTRY, po_ship_code FPKUTIL.MAX_DATA_ENTRY, po_deliv_date FPKUTIL.MAX_DATA_ENTRY, po_print_text FOTTEXT.FOTTEXT_TEXT%TYPE, po_noprint_text FOTTEXT.FOTTEXT_TEXT%TYPE );
Purchase order item data entry record type
po_acctgentry_rectype
TYPE po_acctgentry_rectype IS RECORD ( po_code FPKUTIL.MAX_DATA_ENTRY, po_change_seq_num FPKUTIL.MAX_DATA_ENTRY, po_seqitem FPKUTIL.MAX_DATA_ENTRY, po_seqnum FPKUTIL.MAX_DATA_ENTRY, po_acctg_amt FPKUTIL.MAX_DATA_ENTRY, po_disc_amt FPKUTIL.MAX_DATA_ENTRY, po_tax_amt FPKUTIL.MAX_DATA_ENTRY, po_addl_amt FPKUTIL.MAX_DATA_ENTRY, po_coas FPKUTIL.MAX_DATA_ENTRY, po_acci FPKUTIL.MAX_DATA_ENTRY, po_fund FPKUTIL.MAX_DATA_ENTRY, po_orgn FPKUTIL.MAX_DATA_ENTRY, po_acct FPKUTIL.MAX_DATA_ENTRY, po_prog FPKUTIL.MAX_DATA_ENTRY, po_actv FPKUTIL.MAX_DATA_ENTRY, po_locn FPKUTIL.MAX_DATA_ENTRY, po_nsf_override FPKUTIL.MAX_DATA_ENTRY, po_percent_dist FPKUTIL.MAX_DATA_ENTRY );
Purchase order accounting data entry record type
po_itemsentry_tabtype
TYPE po_itemsentry_tabtype IS TABLE OF po_itemsentry_rectype ;
Purchase order item data entry table type
po_acctgentry_tabtype
TYPE po_acctgentry_tabtype IS TABLE OF po_acctgentry_rectype;
Purchase order accounting data entry table type
pohd_headentry_rectype
TYPE pohd_headentry_rectype IS RECORD (
p_code FPBPOHD.FPBPOHD_CODE%TYPE ,
p_change_seq_num FPBPOHD.FPBPOHD_CHANGE_SEQ_NUM%TYPE,
p_user_id FPBPOHD.FPBPOHD_USER_ID%TYPE DEFAULT USER,
p_po_date FPBPOHD.FPBPOHD_PO_DATE%TYPE DEFAULT SYSDATE,
p_trans_date FPBPOHD.FPBPOHD_TRANS_DATE%TYPE DEFAULT SYSDATE,
p_vendor_id SPRIDEN.SPRIDEN_ID%TYPE ,
p_atyp_code FPBPOHD.FPBPOHD_ATYP_CODE%TYPE ,
p_atyp_seq_num FPBPOHD.FPBPOHD_ATYP_SEQ_NUM%TYPE ,
p_buyr_code FPBPOHD.FPBPOHD_BUYR_CODE%TYPE ,
p_reqd_date FPBPOHD.FPBPOHD_REQD_DATE%TYPE ,
p_coas_code FPBPOHD.FPBPOHD_COAS_CODE%TYPE ,
p_orgn_code FPBPOHD.FPBPOHD_ORGN_CODE%TYPE ,
p_ship_code FPBPOHD.FPBPOHD_SHIP_CODE%TYPE ,
p_disc_code FPBPOHD.FPBPOHD_DISC_CODE%TYPE ,
p_print_text FOTTEXT.FOTTEXT_TEXT%TYPE,
p_noprint_text FOTTEXT.FOTTEXT_TEXT%TYPE,
p_tgrp_code FPBPOHD.FPBPOHD_TGRP_CODE%TYPE ,
p_curr_code FPBPOHD.FPBPOHD_CURR_CODE%TYPE ,
p_single_acctg_ind FPBPOHD.FPBPOHD_SINGLE_ACCTG_IND%TYPE ,
p_email_addr FPBPOHD.FPBPOHD_EMAIL_ADDR%TYPE ,
p_fax_area FPBPOHD.FPBPOHD_FAX_AREA%TYPE ,
p_fax_number FPBPOHD.FPBPOHD_FAX_NUMBER%TYPE ,
p_fax_ext FPBPOHD.FPBPOHD_FAX_EXT%TYPE ,
p_attention_to FPBPOHD.FPBPOHD_ATTENTION_TO%TYPE ,
p_vendor_contact FPBPOHD.FPBPOHD_VENDOR_CONTACT%TYPE ,
p_delivery_comment FPBPOHD.FPBPOHD_DELIVERY_COMMENT%TYPE ,
p_vend_email_addr FPBPOHD.FPBPOHD_VEND_EMAIL_ADDR%TYPE ,
p_name FPBPOHD.FPBPOHD_NAME%TYPE ,
p_phone_area FPBPOHD.FPBPOHD_PHONE_AREA%TYPE ,
p_phone_num FPBPOHD.FPBPOHD_PHONE_NUM%TYPE ,
p_phone_ext FPBPOHD.FPBPOHD_PHONE_EXT%TYPE ,
p_edi_ind FPBPOHD.FPBPOHD_EDI_IND%TYPE ,
p_ftrm_code FPBPOHD.FPBPOHD_FTRM_CODE%TYPE,
p_origin_code FPBPOHD.FPBPOHD_ORIGIN_CODE%TYPE DEFAULT 'BANNER',
p_po_type_ind FPBPOHD.FPBPOHD_PO_TYPE_IND%TYPE DEFAULT 'R',
p_doc_ref_code FPBPOHD.FPBPOHD_DOC_REF_CODE%TYPE,
p_ctry_code_phone FPBPOHD.FPBPOHD_CTRY_CODE_PHONE%TYPE,
p_CTRY_CODE_FAX FPBPOHD.FPBPOHD_CTRY_CODE_FAX%TYPE,
p_closed_ind FPBPOHD.FPBPOHD_CLOSED_IND%TYPE,
p_complete_ind FPBPOHD.FPBPOHD_COMPLETE_IND%TYPE,
p_cancel_ind FPBPOHD.FPBPOHD_CANCEL_IND%TYPE,
p_appr_ind FPBPOHD.FPBPOHD_APPR_IND%TYPE,
p_vend_pidm FPBPOHD.FPBPOHD_VEND_PIDM%TYPE
);
Purchase order header record type
podt_itemsentry_rectype
TYPE podt_itemsentry_rectype IS RECORD (
p_code FPRPODT.FPRPODT_POHD_CODE%TYPE,
p_change_seq_num FPRPODT.FPRPODT_CHANGE_SEQ_NUM%TYPE,
p_item FPRPODT.FPRPODT_ITEM%TYPE ,
p_comm_code FPRPODT.FPRPODT_COMM_CODE%TYPE ,
p_comm_desc FPRPODT.FPRPODT_COMM_DESC%TYPE ,
p_uoms_code FPRPODT.FPRPODT_UOMS_CODE%TYPE ,
p_unit_price FPRPODT.FPRPODT_UNIT_PRICE%TYPE ,
p_qty FPRPODT.FPRPODT_QTY%TYPE ,
p_disc_amt FPRPODT.FPRPODT_DISC_AMT%TYPE ,
p_addl_chrg_amt FPRPODT.FPRPODT_ADDL_CHRG_AMT%TYPE ,
p_tax_amt FPRPODT.FPRPODT_TAX_AMT%TYPE ,
p_tgrp_code FPRPODT.FPRPODT_TGRP_CODE%TYPE ,
p_ship_code FPRPODT.FPRPODT_SHIP_CODE%TYPE ,
p_reqd_date FPRPODT.FPRPODT_REQD_DATE%TYPE ,
p_print_text FOTTEXT.FOTTEXT_TEXT%TYPE,
p_noprint_text fottext.fottext_text%TYPE,
p_vend_ref_num FPRPODT.FPRPODT_VEND_REF_NUM%TYPE
);
Purchase order item record type
poda_acctgentry_rectype
TYPE poda_acctgentry_rectype IS RECORD ( p_code FPRPODA.FPRPODA_POHD_CODE%TYPE , p_change_seq_num FPRPODA.FPRPODA_CHANGE_SEQ_NUM%TYPE, p_item FPRPODA.FPRPODA_ITEM%TYPE , p_seq_num FPRPODA.FPRPODA_SEQ_NUM%TYPE , p_amt FPRPODA.FPRPODA_AMT%TYPE , p_disc_amt FPRPODA.FPRPODA_DISC_AMT%TYPE , p_tax_amt FPRPODA.FPRPODA_TAX_AMT%TYPE , p_addl_chrg_amt FPRPODA.FPRPODA_ADDL_CHRG_AMT%TYPE , p_coas_code FPRPODA.FPRPODA_COAS_CODE%TYPE , p_acci_code FPRPODA.FPRPODA_ACCI_CODE%TYPE , p_fund_code FPRPODA.FPRPODA_FUND_CODE%TYPE , p_orgn_code FPRPODA.FPRPODA_ORGN_CODE%TYPE , p_acct_code FPRPODA.FPRPODA_ACCT_CODE%TYPE , p_prog_code FPRPODA.FPRPODA_PROG_CODE%TYPE , p_actv_code FPRPODA.FPRPODA_ACTV_CODE%TYPE , p_locn_code FPRPODA.FPRPODA_LOCN_CODE%TYPE , p_proj_code FPRPODA.FPRPODA_PROJ_CODE%TYPE , p_nsf_override_ind FPRPODA.FPRPODA_NSF_OVERRIDE_IND%TYPE , p_appr_amt_pct FPRPODA.FPRPODA_APPR_AMT_PCT%TYPE , p_disc_amt_pct FPRPODA.FPRPODA_DISC_AMT_PCT%TYPE , p_addl_amt_pct FPRPODA.FPRPODA_ADDL_AMT_PCT%TYPE , p_TAX_AMT_PCT FPRPODA.FPRPODA_TAX_AMT_PCT%TYPE );
Purchase order accounting record type
podt_itemsentry_tabtype
TYPE podt_itemsentry_tabtype IS TABLE OF podt_itemsentry_rectype;
Purchase order item table type for podt_itemsentry_rectype
poda_acctgentry_tabtype
TYPE poda_acctgentry_tabtype IS TABLE OF poda_acctgentry_rectype;
Purchase order accounting table type for poda_acctgentry_rectype
fprpodt_tabletype
TYPE fprpodt_tabletype IS TABLE OF fprpodt%ROWTYPE;
Purchase order item table type for rowtype
fprpoda_tabletype
TYPE fprpoda_tabletype IS TABLE OF fprpoda%ROWTYPE;
Purchase order accounting table type for rowtype
f_fpbpohd_ref
Function f_fpbpohd_ref(po_code FPBPOHD.FPBPOHD_CODE%TYPE,
po_change_seq_num NUMBER DEFAULT NULL)
RETURN foksels.ref_cursortype
Selects purchase order header record.
f_fprpodt_ref
Function f_fprpodt_ref(po_code FPRPODT.FPRPODT_POHD_CODE%TYPE,
po_change_seq_num NUMBER DEFAULT NULL,
po_item_num FPRPODT.FPRPODT_ITEM%TYPE DEFAULT NULL)
RETURN foksels.ref_cursortype
Selects purchase order item records.
f_fprpoda_ref
Function f_fprpoda_ref(po_code FPRPODA.FPRPODA_POHD_CODE%TYPE,
po_change_seq_num NUMBER DEFAULT NULL,
po_item_num FPRPODA.FPRPODA_ITEM%TYPE DEFAULT NULL,
po_seq_num FPRPODA.FPRPODA_SEQ_NUM%TYPE DEFAULT NULL)
RETURN foksels.ref_cursortype
Selects purchase order accounting records.
p_create_po
Procedure p_create_po(po_headentry_rec PO_HEADENTRY_RECTYPE DEFAULT NULL,
po_itemsentry_table PO_ITEMSENTRY_TABTYPE DEFAULT NULL,
po_acctgentry_table PO_ACCTGENTRY_TABTYPE DEFAULT NULL,
Error_mesg_table IN OUT FPKUTIL.ERROR_MESG_TABTYPE,
success_message IN OUT VARCHAR2)
Creates a complete set of purchase order records.
p_complete_po
Procedure p_complete_po(po_code fpbpohd.fpbpohd_code%type,
po_change_seq_num fpbpohd.fpbpohd_change_seq_num%type,
error_mesg in out fpkutil.error_mesg_tabtype,
success_mesg in out varchar2,
final_po_code out fpbpohd.fpbpohd_code%type,
gen_seqn_for_eproc boolean DEFAULT TRUE)
Performs a full set of validations to complete a purchase order.
p_change_order_in_process
Procedure p_change_order_in_process(po_code fpbpohd.fpbpohd_code%type,
failure_mesg in out varchar2)
p_scrub_header
Procedure p_scrub_header(in_po_headrec PO_HEADENTRY_RECTYPE,
out_pohd_headrec IN OUT POHD_HEADENTRY_RECTYPE,
error_mesg IN OUT FPKUTIL.ERROR_MESG_TABTYPE)
Scrubs the purchase order header values.
p_validate_header
Procedure p_validate_header(pohd_header_data pohd_headentry_rectype default NULL,
fpbpohd_data in out fpbpohd%rowtype,
error_mesg in out fpkutil.error_mesg_tabtype,
p_change_seq_num fpbpohd.fpbpohd_change_seq_num%type)
Validates the purchase order header data.
p_create_header
Procedure p_create_header(po_head_entry po_headentry_rectype,
error_mesg IN OUT Fpkutil.error_mesg_tabtype,
po_doc_code IN OUT fpbpohd.fpbpohd_code%type,
po_change_seq_num IN OUT fpbpohd.fpbpohd_change_seq_num%type)
Creates purchase order header record using passed in po_headentry_rectype.
p_create_header
Procedure p_create_header(pohd_head_entry pohd_headentry_rectype,
error_mesg IN OUT Fpkutil.error_mesg_tabtype,
po_doc_code IN OUT fpbpohd.fpbpohd_code%type,
po_change_seq_num IN OUT fpbpohd.fpbpohd_change_seq_num%type)
Creates purchase order header record using passed in pohd_headentry_rectype.
p_delete_header
Procedure p_delete_header(pohd_head_entry fpbpohd%rowtype,
error_mesg IN OUT Fpkutil.error_mesg_tabtype)
Cancels purchase order header record using passed in pohd_headentry_rectype.
p_scrub_item
Procedure p_scrub_item(in_po_item_rec PO_ITEMSENTRY_RECTYPE,
out_podt_rec IN OUT PODT_ITEMSENTRY_RECTYPE,
error_mesg IN OUT FPKUTIL.ERROR_MESG_TABTYPE)
Scrubs the purchase order item values.
p_validate_item
Procedure p_validate_item(podt_entry_rec IN PODT_ITEMSENTRY_RECTYPE,
fprpodt_rec IN OUT FPRPODT%ROWTYPE,
error_mesg IN OUT FPKUTIL.ERROR_MESG_TABTYPE,
doc_code IN FPBPOHD.FPBPOHD_CODE%TYPE DEFAULT NULL,
p_change_seq_num IN FPRPODT.FPRPODT_CHANGE_SEQ_NUM%TYPE /*CR-000103517*/)
Validates purchase order item data.
p_create_item
Procedure p_create_item(podt_item_entry podt_itemsentry_rectype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type,
po_change_seq_num fprpodt.fprpodt_change_seq_num%type,
po_data_changed varchar2 default null)
Creates purchase order item record using passed in podt_itemsentry_rectype.
p_create_item
Procedure p_create_item(po_item_entry po_itemsentry_rectype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type,
po_change_seq_num fprpodt.fprpodt_change_seq_num%type,
po_data_changed varchar2 default null)
Creates purchase order item record using passed in po_itemsentry_rectype.
p_delete_item
Procedure p_delete_item(po_item_entry fprpodt%rowtype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type)
Cancels purchase order item record using passed in po_itemsentry_rectype.
p_update_item
Procedure p_update_item(po_item_entry fprpodt%rowtype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type)
Updates purchase order item record using passed in po_itemsentry_rectype.
p_scrub_acctg
Procedure p_scrub_acctg(in_po_acctg_rec PO_ACCTGENTRY_RECTYPE,
out_poda_rec IN OUT PODA_ACCTGENTRY_RECTYPE,
error_mesg IN OUT FPKUTIL.ERROR_MESG_TABTYPE)
Scrubs the purchase order accounting values.
p_validate_acctg
Procedure p_validate_acctg(poda_entry_rec in poda_acctgentry_rectype,
fprpoda_rec in out fprpoda%rowtype,
error_mesg in out fpkutil.error_mesg_tabtype,
doc_code in fpbpohd.fpbpohd_code%type default null,
p_change_seq_num in fprpoda.fprpoda_change_seq_num%type)
Validates purchase order accounting data.
p_create_acctg
Procedure p_create_acctg(po_acctg_entry po_acctgentry_rectype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type,
po_change_seq_num fprpoda.fprpoda_change_seq_num%type,
po_data_changed varchar2 default null)
Creates purchase order accounting record using passed in po_acctgentry_rectype.
p_create_acctg
Procedure p_create_acctg(poda_acctg_entry poda_acctgentry_rectype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type,
po_change_seq_num fprpoda.fprpoda_change_seq_num%type,
po_data_changed varchar2 default null)
Creates purchase order accounting record using passed in poda_acctgentry_rectype.
p_delete_acctg
Procedure p_delete_acctg(poda_acctg_entry fprpoda%rowtype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type)
Cancels purchase order accounting record using passed in poda_acctgentry_rectype.
p_update_acctg
Procedure p_update_acctg(poda_acctg_entry fprpoda%rowtype,
error_mesg in out fpkutil.error_mesg_tabtype,
po_doc_code fpbpohd.fpbpohd_code%type)
Updates purchase order accounting record using passed in poda_acctgentry_rectype.
p_check_vendor_po_hold
Procedure p_check_vendor_po_hold(p_vend_pidm FPBPOHD.FPBPOHD_VEND_PIDM%TYPE,
p_user_id FOBPROF.FOBPROF_USER_ID%TYPE,
p_eff_date DATE,
p_in_out_err_type IN OUT VARCHAR2,
p_in_out_err_msg IN OUT FPKUTIL.ERROR_MESG_TYPE)
Checks if the purchase order vendor is on hold and if the user is authorized to override this hold.
p_po_close_req
Procedure p_po_close_req(req_code IN FPBREQH.FPBREQH_CODE%TYPE,
req_item_num IN FPRREQD.FPRREQD_ITEM%TYPE,
req_seq_num IN FPRREQA.FPRREQA_SEQ_NUM%TYPE,
fpbpohd_single_acctg_ind IN FPBPOHD.FPBPOHD_SINGLE_ACCTG_IND%TYPE,
pohd_code IN FPRREQD.FPRREQD_POHD_CODE%TYPE,
error_mesg IN OUT VARCHAR2)
Closes the requisition header, item and accounting records for a completed inventory purchase order referencing this requisition.
p_po_open_req
Procedure p_po_open_req(req_code IN FPBREQH.FPBREQH_CODE%TYPE,
req_item_num IN FPRREQD.FPRREQD_ITEM%TYPE,
req_seq_num IN FPRREQA.FPRREQA_SEQ_NUM%TYPE,
fpbpohd_single_acctg_ind IN FPBPOHD.FPBPOHD_SINGLE_ACCTG_IND%TYPE,
pohd_code IN FPRREQD.FPRREQD_POHD_CODE%TYPE,
error_mesg IN OUT VARCHAR2)
Opens the requisition header, item and accounting records for a canceled inventory purchase order referencing this requisition.
p_req_open_close
Procedure p_req_open_close(fpbpohd_single_acctg_ind IN FPBPOHD.FPBPOHD_SINGLE_ACCTG_IND%TYPE,
pohd_code IN FPRREQD.FPRREQD_POHD_CODE%TYPE,
error_mesg IN OUT VARCHAR2,
op_type IN VARCHAR2)
This procedure calls p_po_close_req to close a requisition or calls p_po_open_req to open a requisition depending on the value of the passed in parameter op_type, which can be C(lose) or O(pen).