M_HDR_OBJECT_NAME

M_HDR_OBJECT_NAME         CONSTANT VARCHAR2(27)  := 'PURCHASE_REQUISITION_HEADER';

M_REQH_CODE

M_REQH_CODE               CONSTANT VARCHAR2(12)  := 'FPBREQH_CODE';

M_REQH_ACTIVITY_DATE

M_REQH_ACTIVITY_DATE      CONSTANT VARCHAR2(21)  := 'FPBREQH_ACTIVITY_DATE';

M_REQH_USER_ID

M_REQH_USER_ID            CONSTANT VARCHAR2(15)  := 'FPBREQH_USER_ID';

M_REQH_REQH_DATE

M_REQH_REQH_DATE          CONSTANT VARCHAR2(17)  := 'FPBREQH_REQH_DATE';

M_REQH_TRANS_DATE

M_REQH_TRANS_DATE         CONSTANT VARCHAR2(18)  := 'FPBREQH_TRANS_DATE';

M_REQH_NAME

M_REQH_NAME               CONSTANT VARCHAR2(12)  := 'FPBREQH_NAME';

M_REQH_PHONE_AREA

M_REQH_PHONE_AREA         CONSTANT VARCHAR2(18)  := 'FPBREQH_PHONE_AREA';

M_REQH_PHONE_NUM

M_REQH_PHONE_NUM          CONSTANT VARCHAR2(17)  := 'FPBREQH_PHONE_NUM';

M_REQH_PHONE_EXT

M_REQH_PHONE_EXT          CONSTANT VARCHAR2(17)  := 'FPBREQH_PHONE_EXT';

M_REQH_VEND_PIDM

M_REQH_VEND_PIDM          CONSTANT VARCHAR2(17)  := 'FPBREQH_VEND_PIDM';

M_REQH_ATYP_CODE

M_REQH_ATYP_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_ATYP_CODE';

M_REQH_ATYP_SEQ_NUM

M_REQH_ATYP_SEQ_NUM       CONSTANT VARCHAR2(20)  := 'FPBREQH_ATYP_SEQ_NUM';

M_REQH_COAS_CODE

M_REQH_COAS_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_COAS_CODE';

M_REQH_ORGN_CODE

M_REQH_ORGN_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_ORGN_CODE';

M_REQH_REQD_DATE

M_REQH_REQD_DATE          CONSTANT VARCHAR2(17)  := 'FPBREQH_REQD_DATE';

M_REQH_COMPLETE_IND

M_REQH_COMPLETE_IND       CONSTANT VARCHAR2(20)  := 'FPBREQH_COMPLETE_IND';

M_REQH_PRINT_IND

M_REQH_PRINT_IND          CONSTANT VARCHAR2(17)  := 'FPBREQH_PRINT_IND';

M_REQH_ENCUMB_IND

M_REQH_ENCUMB_IND         CONSTANT VARCHAR2(18)  := 'FPBREQH_ENCUMB_IND';

M_REQH_SUSP_IND

M_REQH_SUSP_IND           CONSTANT VARCHAR2(16)  := 'FPBREQH_SUSP_IND';

M_REQH_CANCEL_IND

M_REQH_CANCEL_IND         CONSTANT VARCHAR2(18)  := 'FPBREQH_CANCEL_IND';

M_REQH_CANCEL_DATE

M_REQH_CANCEL_DATE        CONSTANT VARCHAR2(19)  := 'FPBREQH_CANCEL_DATE';

M_REQH_POST_DATE

M_REQH_POST_DATE          CONSTANT VARCHAR2(17)  := 'FPBREQH_POST_DATE';

M_REQH_APPR_IND

M_REQH_APPR_IND           CONSTANT VARCHAR2(16)  := 'FPBREQH_APPR_IND';

M_REQH_TEXT_IND

M_REQH_TEXT_IND           CONSTANT VARCHAR2(16)  := 'FPBREQH_TEXT_IND';

M_REQH_EDIT_DEFER_IND

M_REQH_EDIT_DEFER_IND     CONSTANT VARCHAR2(22)  := 'FPBREQH_EDIT_DEFER_IND';

M_REQH_RECOMM_VEND_NAME

M_REQH_RECOMM_VEND_NAME   CONSTANT VARCHAR2(24)  := 'FPBREQH_RECOMM_VEND_NAME';

M_REQH_CURR_CODE

M_REQH_CURR_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_CURR_CODE';

M_REQH_NSF_ON_OFF_IND

M_REQH_NSF_ON_OFF_IND     CONSTANT VARCHAR2(22)  := 'FPBREQH_NSF_ON_OFF_IND';

M_REQH_SINGLE_ACCTG_IND

M_REQH_SINGLE_ACCTG_IND   CONSTANT VARCHAR2(24)  := 'FPBREQH_SINGLE_ACCTG_IND';

M_REQH_CLOSED_IND

M_REQH_CLOSED_IND         CONSTANT VARCHAR2(18)  := 'FPBREQH_CLOSED_IND';

M_REQH_SHIP_CODE

M_REQH_SHIP_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_SHIP_CODE';

M_REQH_RQST_TYPE_IND

M_REQH_RQST_TYPE_IND      CONSTANT VARCHAR2(21)  := 'FPBREQH_RQST_TYPE_IND';

M_REQH_INVENTORY_REQ_IND

M_REQH_INVENTORY_REQ_IND  CONSTANT VARCHAR2(25)  := 'FPBREQH_INVENTORY_REQ_IND';

M_REQH_CRSN_CODE

M_REQH_CRSN_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_CRSN_CODE';

M_REQH_DELIVERY_COMMENT

M_REQH_DELIVERY_COMMENT    CONSTANT VARCHAR2(24)  := 'FPBREQH_DELIVERY_COMMENT';

M_REQH_EMAIL_ADDR

M_REQH_EMAIL_ADDR         CONSTANT VARCHAR2(18)  := 'FPBREQH_EMAIL_ADDR';

M_REQH_FAX_AREA

M_REQH_FAX_AREA           CONSTANT VARCHAR2(16)  := 'FPBREQH_FAX_AREA';

M_REQH_FAX_NUMBER

M_REQH_FAX_NUMBER         CONSTANT VARCHAR2(18)  := 'FPBREQH_FAX_NUMBER';

M_REQH_FAX_EXT

M_REQH_FAX_EXT            CONSTANT VARCHAR2(15)  := 'FPBREQH_FAX_EXT';

M_REQH_ATTENTION_TO

M_REQH_ATTENTION_TO       CONSTANT VARCHAR2(20)  := 'FPBREQH_ATTENTION_TO';

M_REQH_VENDOR_CONTACT

M_REQH_VENDOR_CONTACT     CONSTANT VARCHAR2(22)  := 'FPBREQH_VENDOR_CONTACT';

M_REQH_DISC_CODE

M_REQH_DISC_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_DISC_CODE';

M_REQH_VEND_EMAIL_ADDR

M_REQH_VEND_EMAIL_ADDR    CONSTANT VARCHAR2(23)  := 'FPBREQH_VEND_EMAIL_ADDR';

M_REQH_COPIED_FROM

M_REQH_COPIED_FROM        CONSTANT VARCHAR2(19)  := 'FPBREQH_COPIED_FROM';

M_REQH_TGRP_CODE

M_REQH_TGRP_CODE          CONSTANT VARCHAR2(17)  := 'FPBREQH_TGRP_CODE';

M_REQH_REQ_PRINT_DATE

M_REQH_REQ_PRINT_DATE      CONSTANT VARCHAR2(22)  := 'FPBREQH_REQ_PRINT_DATE';

M_REQH_CLOSED_DATE

M_REQH_CLOSED_DATE        CONSTANT VARCHAR2(19)  := 'FPBREQH_CLOSED_DATE';

M_REQH_MATCH_REQUIRED

M_REQH_MATCH_REQUIRED     CONSTANT VARCHAR2(22)  := 'FPBREQH_MATCH_REQUIRED';

M_REQH_ORIGIN_CODE

M_REQH_ORIGIN_CODE        CONSTANT VARCHAR2(19)  := 'FPBREQH_ORIGIN_CODE';

M_REQH_DOC_REF_CODE

M_REQH_DOC_REF_CODE       CONSTANT VARCHAR2(20)  := 'FPBREQH_DOC_REF_CODE';

M_STATUS

M_STATUS                  CONSTANT VARCHAR2(15)  := 'STATUS';

M_STATUS_MESSAGE

M_STATUS_MESSAGE          CONSTANT VARCHAR2(15)  := 'STATUS_MESSAGE';

M_VENDOR_ID

M_VENDOR_ID               CONSTANT VARCHAR2(10)  := 'VENDOR_ID';

M_VENDOR_NAME

M_VENDOR_NAME             CONSTANT VARCHAR2(15)  := 'VENDOR_NAME';

M_CTRY_CODE_PHONE

M_CTRY_CODE_PHONE         CONSTANT VARCHAR2(30)  := 'FPBREQH_CTRY_CODE_PHONE';

M_CTRY_CODE_FAX

M_CTRY_CODE_FAX           CONSTANT VARCHAR2(30)  := 'FPBREQH_CTRY_CODE_FAX  ';

M_ITEM_OBJECT_NAME

M_ITEM_OBJECT_NAME         CONSTANT VARCHAR2(25)  := 'PURCHASE_REQUISITION_ITEM';

M_REQD_REQH_CODE

M_REQD_REQH_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_REQH_CODE';

M_REQD_ITEM

M_REQD_ITEM               CONSTANT VARCHAR2(12)  := 'FPRREQD_ITEM';

M_REQD_ACTIVITY_DATE

M_REQD_ACTIVITY_DATE      CONSTANT VARCHAR2(21)  := 'FPRREQD_ACTIVITY_DATE';

M_REQD_USER_ID

M_REQD_USER_ID            CONSTANT VARCHAR2(15)  := 'FPRREQD_USER_ID';

M_REQD_COMM_CODE

M_REQD_COMM_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_COMM_CODE';

M_REQD_COMM_DESC

M_REQD_COMM_DESC          CONSTANT VARCHAR2(17)  := 'FPRREQD_COMM_DESC';

M_REQD_COAS_CODE

M_REQD_COAS_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_COAS_CODE';

M_REQD_ORGN_CODE

M_REQD_ORGN_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_ORGN_CODE';

M_REQD_BUYR_CODE

M_REQD_BUYR_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_BUYR_CODE';

M_REQD_QTY

M_REQD_QTY                CONSTANT VARCHAR2(11)  := 'FPRREQD_QTY';

M_REQD_UOMS_CODE

M_REQD_UOMS_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_UOMS_CODE';

M_REQD_UNIT_PRICE

M_REQD_UNIT_PRICE         CONSTANT VARCHAR2(18)  := 'FPRREQD_UNIT_PRICE';

M_REQD_AGRE_CODE

M_REQD_AGRE_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_AGRE_CODE';

M_REQD_REQD_DATE

M_REQD_REQD_DATE          CONSTANT VARCHAR2(17)  := 'FPRREQD_REQD_DATE';

M_REQD_SHIP_CODE

M_REQD_SHIP_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_SHIP_CODE';

M_REQD_VEND_PIDM

M_REQD_VEND_PIDM          CONSTANT VARCHAR2(17)  := 'FPRREQD_VEND_PIDM';

M_REQD_VEND_REF_NUM

M_REQD_VEND_REF_NUM       CONSTANT VARCHAR2(20)  := 'FPRREQD_VEND_REF_NUM';

M_REQD_PROJ_CODE

M_REQD_PROJ_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_PROJ_CODE';

M_REQD_POHD_CODE

M_REQD_POHD_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_POHD_CODE';

M_REQD_POHD_ITEM

M_REQD_POHD_ITEM          CONSTANT VARCHAR2(17)  := 'FPRREQD_POHD_ITEM';

M_REQD_BIDS_CODE

M_REQD_BIDS_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_BIDS_CODE';

M_REQD_COMPLETE_IND

M_REQD_COMPLETE_IND       CONSTANT VARCHAR2(20)  := 'FPRREQD_COMPLETE_IND';

M_REQD_SUSP_IND

M_REQD_SUSP_IND           CONSTANT VARCHAR2(16)  := 'FPRREQD_SUSP_IND';

M_REQD_CANCEL_IND

M_REQD_CANCEL_IND         CONSTANT VARCHAR2(18)  := 'FPRREQD_CANCEL_IND';

M_REQD_CANCEL_DATE

M_REQD_CANCEL_DATE        CONSTANT VARCHAR2(19)  := 'FPRREQD_CANCEL_DATE';

M_REQD_CLOSED_IND

M_REQD_CLOSED_IND         CONSTANT VARCHAR2(18)  := 'FPRREQD_CLOSED_IND';

M_REQD_POST_DATE

M_REQD_POST_DATE          CONSTANT VARCHAR2(17)  := 'FPRREQD_POST_DATE';

M_REQD_TEXT_USAGE

M_REQD_TEXT_USAGE         CONSTANT VARCHAR2(18)  := 'FPRREQD_TEXT_USAGE';

M_REQD_ATYP_CODE

M_REQD_ATYP_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_ATYP_CODE';

M_REQD_ATYP_SEQ_NUM

M_REQD_ATYP_SEQ_NUM       CONSTANT VARCHAR2(20)  := 'FPRREQD_ATYP_SEQ_NUM';

M_REQD_RECOMM_VEND_NAME

M_REQD_RECOMM_VEND_NAME   CONSTANT VARCHAR2(24)  := 'FPRREQD_RECOMM_VEND_NAME';

M_REQD_CURR_CODE

M_REQD_CURR_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_CURR_CODE';

M_REQD_CONVERTED_UNIT_PRICE

M_REQD_CONVERTED_UNIT_PRICE   CONSTANT VARCHAR2(28)  := 'FPRREQD_CONVERTED_UNIT_PRICE';

M_REQD_DISC_AMT

M_REQD_DISC_AMT           CONSTANT VARCHAR2(16)  := 'FPRREQD_DISC_AMT';

M_REQD_TAX_AMT

M_REQD_TAX_AMT            CONSTANT VARCHAR2(15)  := 'FPRREQD_TAX_AMT';

M_REQD_ADDL_CHRG_AMT

M_REQD_ADDL_CHRG_AMT      CONSTANT VARCHAR2(21)  := 'FPRREQD_ADDL_CHRG_AMT';

M_REQD_CONVERT_DISC_AMT

M_REQD_CONVERT_DISC_AMT    CONSTANT VARCHAR2(24)  := 'FPRREQD_CONVERT_DISC_AMT';

M_REQD_CONVERT_TAX_AMT

M_REQD_CONVERT_TAX_AMT      CONSTANT VARCHAR2(23)  := 'FPRREQD_CONVERT_TAX_AMT';

M_REQD_CONVERT_ADDL_CHRG_AMT

M_REQD_CONVERT_ADDL_CHRG_AMT     CONSTANT VARCHAR2(29)  := 'FPRREQD_CONVERT_ADDL_CHRG_AMT';

M_REQD_TGRP_CODE

M_REQD_TGRP_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQD_TGRP_CODE';

M_REQD_AMT

M_REQD_AMT                CONSTANT VARCHAR2(11)  := 'FPRREQD_AMT';

M_REQD_DESC_CHGE_IND

M_REQD_DESC_CHGE_IND      CONSTANT VARCHAR2(21)  := 'FPRREQD_DESC_CHGE_IND';

M_ACCTG_OBJECT_NAME

M_ACCTG_OBJECT_NAME         CONSTANT VARCHAR2(31)  := 'PURCHASE_REQUISITION_ACCOUNTING';

M_REQA_REQH_CODE

M_REQA_REQH_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_REQH_CODE';

M_REQA_ITEM

M_REQA_ITEM               CONSTANT VARCHAR2(12)  := 'FPRREQA_ITEM';

M_REQA_SEQ_NUM

M_REQA_SEQ_NUM            CONSTANT VARCHAR2(15)  := 'FPRREQA_SEQ_NUM';

M_REQA_ACTIVITY_DATE

M_REQA_ACTIVITY_DATE      CONSTANT VARCHAR2(21)  := 'FPRREQA_ACTIVITY_DATE';

M_REQA_USER_ID

M_REQA_USER_ID            CONSTANT VARCHAR2(15)  := 'FPRREQA_USER_ID';

M_REQA_PCT

M_REQA_PCT                CONSTANT VARCHAR2(11)  := 'FPRREQA_PCT';

M_REQA_AMT

M_REQA_AMT                CONSTANT VARCHAR2(11)  := 'FPRREQA_AMT';

M_REQA_FSYR_CODE

M_REQA_FSYR_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_FSYR_CODE';

M_REQA_PERIOD

M_REQA_PERIOD             CONSTANT VARCHAR2(14)  := 'FPRREQA_PERIOD';

M_REQA_RUCL_CODE

M_REQA_RUCL_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_RUCL_CODE';

M_REQA_COAS_CODE

M_REQA_COAS_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_COAS_CODE';

M_REQA_ACCI_CODE

M_REQA_ACCI_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_ACCI_CODE';

M_REQA_FUND_CODE

M_REQA_FUND_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_FUND_CODE';

M_REQA_ORGN_CODE

M_REQA_ORGN_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_ORGN_CODE';

M_REQA_ACCT_CODE

M_REQA_ACCT_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_ACCT_CODE';

M_REQA_PROG_CODE

M_REQA_PROG_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_PROG_CODE';

M_REQA_ACTV_CODE

M_REQA_ACTV_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_ACTV_CODE';

M_REQA_LOCN_CODE

M_REQA_LOCN_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_LOCN_CODE';

M_REQA_SUSP_IND

M_REQA_SUSP_IND           CONSTANT VARCHAR2(16)  := 'FPRREQA_SUSP_IND';

M_REQA_NSF_SUSP_IND

M_REQA_NSF_SUSP_IND       CONSTANT VARCHAR2(20)  := 'FPRREQA_NSF_SUSP_IND';

M_REQA_CANCEL_IND

M_REQA_CANCEL_IND         CONSTANT VARCHAR2(18)  := 'FPRREQA_CANCEL_IND';

M_REQA_CANCEL_DATE

M_REQA_CANCEL_DATE        CONSTANT VARCHAR2(19)  := 'FPRREQA_CANCEL_DATE';

M_REQA_PROJ_CODE

M_REQA_PROJ_CODE          CONSTANT VARCHAR2(17)  := 'FPRREQA_PROJ_CODE';

M_REQA_APPR_IND

M_REQA_APPR_IND           CONSTANT VARCHAR2(16)  := 'FPRREQA_APPR_IND';

M_REQA_NSF_OVERRIDE_IND

M_REQA_NSF_OVERRIDE_IND    CONSTANT VARCHAR2(24)  := 'FPRREQA_NSF_OVERRIDE_IND';

M_REQA_ABAL_IND

M_REQA_ABAL_IND           CONSTANT VARCHAR2(16)  := 'FPRREQA_ABAL_IND';

M_REQA_CONVERTED_AMT

M_REQA_CONVERTED_AMT      CONSTANT VARCHAR2(21)  := 'FPRREQA_CONVERTED_AMT';

M_REQA_CLOSED_IND

M_REQA_CLOSED_IND         CONSTANT VARCHAR2(18)  := 'FPRREQA_CLOSED_IND';

M_REQA_DISC_AMT

M_REQA_DISC_AMT           CONSTANT VARCHAR2(16)  := 'FPRREQA_DISC_AMT';

M_REQA_TAX_AMT

M_REQA_TAX_AMT            CONSTANT VARCHAR2(15)  := 'FPRREQA_TAX_AMT';

M_REQA_ADDL_CHRG_AMT

M_REQA_ADDL_CHRG_AMT      CONSTANT VARCHAR2(21)  := 'FPRREQA_ADDL_CHRG_AMT';

M_REQA_CONVERT_DISC_AMT

M_REQA_CONVERT_DISC_AMT    CONSTANT VARCHAR2(24)  := 'FPRREQA_CONVERT_DISC_AMT';

M_REQA_CONVERT_TAX_AMT

M_REQA_CONVERT_TAX_AMT      CONSTANT VARCHAR2(23)  := 'FPRREQA_CONVERT_TAX_AMT';

M_REQA_CONVERT_ADDL_CHRG_AMT

M_REQA_CONVERT_ADDL_CHRG_AMT      CONSTANT VARCHAR2(29)  := 'FPRREQA_CONVERT_ADDL_CHRG_AMT';

M_REQA_DISC_AMT_PCT

M_REQA_DISC_AMT_PCT       CONSTANT VARCHAR2(20)  := 'FPRREQA_DISC_AMT_PCT';

M_REQA_ADDL_AMT_PCT

M_REQA_ADDL_AMT_PCT       CONSTANT VARCHAR2(20)  := 'FPRREQA_ADDL_AMT_PCT';

M_REQA_TAX_AMT_PCT

M_REQA_TAX_AMT_PCT        CONSTANT VARCHAR2(19)  := 'FPRREQA_TAX_AMT_PCT';

M_REQA_DISC_RUCL_CODE

M_REQA_DISC_RUCL_CODE      CONSTANT VARCHAR2(22)  := 'FPRREQA_DISC_RUCL_CODE';

M_REQA_TAX_RUCL_CODE

M_REQA_TAX_RUCL_CODE      CONSTANT VARCHAR2(21)  := 'FPRREQA_TAX_RUCL_CODE';

M_REQA_ADDL_RUCL_CODE

M_REQA_ADDL_RUCL_CODE      CONSTANT VARCHAR2(22)  := 'FPRREQA_ADDL_RUCL_CODE';

M_REQA_RUCL_CODE_LIQ

M_REQA_RUCL_CODE_LIQ      CONSTANT VARCHAR2(21)  := 'FPRREQA_RUCL_CODE_LIQ';

p_register_header_entity

Procedure p_register_header_entity(p_operation_id NUMBER,
                                   p_code         varchar2,
                                   p_doc_ref_code varchar2 default null)

Registers the requisition header attribute value pairs to the message cache.

p_register_reqn

Procedure p_register_reqn(req_code    FPBREQH.FPBREQH_code%type default null,
                          req_doc_ref FPBREQH.FPBREQH_doc_ref_code%type default null,
                          action      varchar2 default null)

Registers the requisition attribute value pairs to the message cache.

p_register_reqn

Procedure p_register_reqn(fpbreqh_cursor foksels.ref_cursortype,
                          fprreqd_cursor foksels.ref_cursortype,
                          fprreqa_cursor foksels.ref_cursortype,
                          action         varchar2)

Registers the requisition attribute value pairs to the message cache.

p_register_header_entity

Procedure p_register_header_entity(p_operation_id      NUMBER,
                                   p_code              FPBREQH.FPBREQH_CODE%TYPE,
                                   p_activity_date     FPBREQH.FPBREQH_ACTIVITY_DATE%TYPE default NULL,
                                   p_user_id           FPBREQH.FPBREQH_USER_ID%TYPE default NULL,
                                   p_reqh_date         FPBREQH.FPBREQH_REQH_DATE%TYPE default NULL,
                                   p_trans_date        FPBREQH.FPBREQH_TRANS_DATE%TYPE default NULL,
                                   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_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 NULL,
                                   p_origin_code       FPBREQH.FPBREQH_ORIGIN_CODE%TYPE default NULL,
                                   p_doc_ref_code      FPBREQH.FPBREQH_DOC_REF_CODE%TYPE default NULL,
                                   p_status            varchar2,
                                   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)

Registers the requisition header attribute value pairs to the message cache.

p_register_item_entity

Procedure p_register_item_entity(p_operation_id          NUMBER,
                                 p_reqh_code             VARCHAR2,
                                 p_item                  NUMBER,
                                 p_activity_date         FPRREQD.FPRREQD_ACTIVITY_DATE%TYPE default NULL,
                                 p_user_id               FPRREQD.FPRREQD_USER_ID%TYPE default NULL,
                                 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)

Registers the requisition item attribute value pairs to the message cache.

p_register_acctg_entity

Procedure p_register_acctg_entity(p_operation_id          NUMBER,
                                  p_reqh_code             VARCHAR2,
                                  p_item                  NUMBER,
                                  p_seq_num               NUMBER,
                                  p_activity_date         FPRREQA.FPRREQA_ACTIVITY_DATE%TYPE default NULL,
                                  p_user_id               FPRREQA.FPRREQA_USER_ID%TYPE default NULL,
                                  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)

Registers the requisition accounting attribute value pairs to the message cache.