Package BANINST1.fb_purchase_order

Package BANINST1.fb_purchase_order_rules

Support subprograms for purchase order API (FB_PURCHASE_ORDER_RULES).

Program units

p_register_header_entity	Registers the purchase order header attribute value pairs to the message cache.
p_register_item_entity	Registers the purchase order item attribute value pairs to the message cache.
p_register_acctg_entity	Registers the purchase order accounting attribute value pairs to the message cache.
p_register_po	Registers the purchase order attribute value pairs to the message cache.
p_register_po	Registers the purchase order attribute value pairs to the message cache.
p_register_header_entity	Registers the purchase order header attribute value pairs to the message cache.
p_register_item_entity	Registers the purchase order item attribute value pairs to the message cache.
p_register_acctg_entity	Registers the purchase order accounting attribute value pairs to the message cache.

Constants

M_HDR_OBJECT_NAME	Purchase order header name
M_HDR_CODE	Purchase order header code
M_CHANGE_SEQ_NUM	purchase order header change sequence number
M_ACTIVITY_DATE	Activity date
M_USER_ID	User ID
M_PO_DATE	Purchase order date
M_TRANS_DATE	Transaction date
M_BLANKET_CODE	Blanket code
M_BLANKET_IND	Blanket indicator
M_BLANKET_TERM_DATE	Blanket termination date
M_CLOSED_IND	Closed indicator
M_COMPLETE_IND	Completion indicator
M_PRINT_IND	Print indicator
M_PO_PRINTED_DATE	Purchase order printed date
M_VEND_PIDM	Vendor PIDM
M_ATYP_CODE	Vendor address type code
M_ATYP_SEQ_NUM	Vendor address code sequence number
M_BUYR_CODE	Buyer code
M_REQD_DATE	Required delivery date
M_HDR_COAS_CODE	Chart of accounts code
M_HDR_ORGN_CODE	Organization code
M_SHIP_CODE	Ship code
M_TRAT_CODE	Tax rate code
M_FOB_CODE	Free on board code
M_DISC_CODE	Discount code
M_TEXT_IND	Text indicator
M_CLAUSE_IND	Clause indicator
M_CARRIER_PIDM	Carrier PIDM
M_TRSK_CODE	Transit risk code
M_PMNT_CODE	Payment code
M_PRT_ACK	Print acknowledgement
M_ACK_DATE	Acknowledgement date
M_APPR_IND	Approval indicator
M_RUSH_IND	Rush indicator
M_REXP_DATE	Required expiration date
M_HDR_ADDL_CHRG_AMT	Additional charge amount
M_RUSH_AMT	Rush purchase order amount
M_SUSP_IND	Suspense indicator
M_SUSP_IND_ADDL	Additional suspense indicator
M_CANCEL_IND	Cancellation indicator
M_CANCEL_DATE	Cancellation date
M_POST_DATE	Post date
M_REQ_BID_IND	Requisition bid indicator
M_EDIT_DEFER_IND	Defer edit indicator
M_PCLS_CODE	Purchase order classification
M_TGRP_CODE	Tax group code
M_RECOMM_VEND_NAME	Recommended vendor name
M_CURR_CODE	Currency code
M_DISB_AGENT_IND	Disbursing agent indicator
M_NSF_ON_OFF_IND	NSF on off indicator
M_INVENTORY_PO_IND	Inventory purchase order indicator
M_SINGLE_ACCTG_IND	Single distribution accounting indicator
M_DOC_CNTRL_IND	Document control indicator
M_TELE_CODE	Telephone code
M_CRSN_CODE	Cancel reason code
M_DELIVERY_COMMENT	Delivery comment
M_EMAIL_ADDR	Email address
M_FAX_AREA	Fax area
M_FAX_NUMBER	Fax number
M_FAX_EXT	Fax extension
M_ATTENTION_TO	Attention to
M_VENDOR_CONTACT	Vendor contact
M_PO_TYPE_IND	Purchase order type indicator
M_VEND_EMAIL_ADDR	Vendor email address
M_NAME	Name of the person creating the purchase order
M_PHONE_AREA	Telephone area code
M_PHONE_NUM	Telephone number
M_PHONE_EXT	Telephone extension
M_COPIED_FROM	Copied from
M_CLOSED_DATE	Closed date
M_FTRM_CODE	Freight Terms Code
M_EDI_IND	EDI indicator
M_MATCH_REQUIRED	Match required
M_ORIGIN_CODE	Origination code
M_DOC_REF_CODE	Document reference code
M_STATUS	Status
M_STATUS_MESSAGE	Status message
M_VENDOR_ID	Vendor ID
M_VENDOR_NAME	Vendor name
M_CTRY_CODE_PHONE	Telephone country code
M_CTRY_CODE_FAX	Fax country code
M_ITEM_OBJECT_NAME	Item object name
M_ITEM_POHD_CODE	Purchase order code
M_ITEM_CHANGE_SEQ_NUM	Purchase order change sequence number
M_ITEM_ACTIVITY_DATE	Item activity date
M_ITEM_USER_ID	Item user ID
M_ITEM	Item
M_COMM_CODE	Commodity code
M_COMM_DESC	Commodity description
M_UOMS_CODE	Unit of measure code
M_UNIT_PRICE	Unit price
M_LIQ_AMT	Liquidation amount
M_QTY	Quantity
M_ITEM_DISC_AMT	Item discount amount
M_ITEM_TAX_AMT	Item tax amount
M_VEND_REF_NUM	Vendor reference number
M_AGRE_CODE	Agreement code
M_ITEM_SUSP_IND	Item suspense indicator
M_ITEM_CLOSED_IND	Item closed indicator
M_ITEM_CANCEL_IND	Item cancellation indicator
M_ITEM_CANCEL_DATE	Item cancellation date
M_TTAG_NUM	Temporary tag number
M_TEXT_USAGE	Text Usage
M_ITEM_ADDL_CHRG_AMT	Item additional charge amount
M_CONVERT_UNIT_PRICE	Item convert unit price
M_ITEM_CONVERT_DISC_AMT	Item convert discount amount
M_ITEM_CONVERT_TAX_AMT	Item convert tax amount
M_ITEM_CONVERT_ADDL_CHRG_AMT	Item convert additional charge amount
M_ITEM_TGRP_CODE	Tax group code
M_EXT_AMT	Extension amount
M_BO_REMAIN_BAL	Blanket order remaining balance amount
M_DESC_CHGE_IND	Description changed indicator
M_ITEM_SHIP_CODE	Ship code
M_ITEM_REQD_DATE	Required delivery date
M_ACCT_OBJECT_NAME	Accounting object name
M_PODA_POHD_CODE	Purchase order code
M_ACCT_CHANGE_SEQ_NUM	Purchase order change sequence number
M_ACCT_ITEM	Accounting item number
M_SEQ_NUM	Accounting sequence number
M_ACCT_ACTIVITY_DATE	Accounting activity date
M_ACCT_USER_ID	Accounting user ID
M_AMT	Accounting approved amount
M_DISC_AMT	Accounting discount amount
M_TAX_AMT	Accounting tax amount
M_ADDL_CHRG_AMT	Accounting additional charge amount
M_FSYR_CODE	Fiscal year code
M_PERIOD	Fiscal period
M_RUCL_CODE_PO	PO rule class code
M_DISC_RUCL_CODE	Discount rule class code
M_TAX_RUCL_CODE	Tax rule class code
M_ADDL_RUCL_CODE	Additional charge rule class code
M_RUCL_CODE_LIQ	Liquidation rule class code
M_COAS_CODE	Chart of accounts code
M_ACCI_CODE	Index code
M_FUND_CODE	Fund code
M_ORGN_CODE	Organization code
M_ACCT_CODE	Account code
M_PROG_CODE	Program code
M_ACTV_CODE	Activity code
M_LOCN_CODE	Location code
M_PROJ_CODE	Project code
M_ACCT_SUSP_IND	Account suspense indicator
M_NSF_SUSP_IND	NSF suspense indicator
M_ACCT_POST_DATE	Post date
M_ACCT_APPR_IND	Approval indicator
M_NSF_OVERRIDE_IND	NSF override indicator
M_ACCT_CLOSED_IND	Account closed indicator
M_CONVERT_AMT	Convert approved amount
M_CONVERT_DISC_AMT	Convert discount amount
M_CONVERT_TAX_AMT	Convert tax amount
M_CONVERT_ADDL_CHRG_AMT	Convert additional charge amount
M_APPR_AMT_PCT	Approved amount percentage
M_DISC_AMT_PCT	Discount amount percentage
M_ADDL_AMT_PCT	Additional charge amount percentage
M_TAX_AMT_PCT	Tax amount percentage

M_HDR_OBJECT_NAME

M_HDR_OBJECT_NAME         CONSTANT VARCHAR2(25)  := 'PURCHASE_ORDER_HEADER';

Purchase order header name

M_HDR_CODE

M_HDR_CODE                CONSTANT VARCHAR2(12)  := 'FPBPOHD_CODE';

Purchase order header code

M_CHANGE_SEQ_NUM

M_CHANGE_SEQ_NUM          CONSTANT VARCHAR2(22)  := 'FPBPOHD_CHANGE_SEQ_NUM';

purchase order header change sequence number

M_ACTIVITY_DATE

M_ACTIVITY_DATE           CONSTANT VARCHAR2(21)  := 'FPBPOHD_ACTIVITY_DATE';

Activity date

M_USER_ID

M_USER_ID                 CONSTANT VARCHAR2(15)  := 'FPBPOHD_USER_ID';

User ID

M_PO_DATE

M_PO_DATE                 CONSTANT VARCHAR2(15)  := 'FPBPOHD_PO_DATE';

Purchase order date

M_TRANS_DATE

M_TRANS_DATE              CONSTANT VARCHAR2(18)  := 'FPBPOHD_TRANS_DATE';

Transaction date

M_BLANKET_CODE

M_BLANKET_CODE            CONSTANT VARCHAR2(20)  := 'FPBPOHD_BLANKET_CODE';

Blanket code

M_BLANKET_IND

M_BLANKET_IND             CONSTANT VARCHAR2(19)  := 'FPBPOHD_BLANKET_IND';

Blanket indicator

M_BLANKET_TERM_DATE

M_BLANKET_TERM_DATE       CONSTANT VARCHAR2(25)  := 'FPBPOHD_BLANKET_TERM_DATE';

Blanket termination date

M_CLOSED_IND

M_CLOSED_IND              CONSTANT VARCHAR2(18)  := 'FPBPOHD_CLOSED_IND';

Closed indicator

M_COMPLETE_IND

M_COMPLETE_IND            CONSTANT VARCHAR2(20)  := 'FPBPOHD_COMPLETE_IND';

Completion indicator

M_PRINT_IND

M_PRINT_IND               CONSTANT VARCHAR2(17)  := 'FPBPOHD_PRINT_IND';

Print indicator

M_PO_PRINTED_DATE

M_PO_PRINTED_DATE         CONSTANT VARCHAR2(23)  := 'FPBPOHD_PO_PRINTED_DATE';

Purchase order printed date

M_VEND_PIDM

M_VEND_PIDM               CONSTANT VARCHAR2(17)  := 'FPBPOHD_VEND_PIDM';

Vendor PIDM

M_ATYP_CODE

M_ATYP_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_ATYP_CODE';

Vendor address type code

M_ATYP_SEQ_NUM

M_ATYP_SEQ_NUM            CONSTANT VARCHAR2(20)  := 'FPBPOHD_ATYP_SEQ_NUM';

Vendor address code sequence number

M_BUYR_CODE

M_BUYR_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_BUYR_CODE';

Buyer code

M_REQD_DATE

M_REQD_DATE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_REQD_DATE';

Required delivery date

M_HDR_COAS_CODE

M_HDR_COAS_CODE           CONSTANT VARCHAR2(17)  := 'FPBPOHD_COAS_CODE';

Chart of accounts code

M_HDR_ORGN_CODE

M_HDR_ORGN_CODE           CONSTANT VARCHAR2(17)  := 'FPBPOHD_ORGN_CODE';

Organization code

M_SHIP_CODE

M_SHIP_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_SHIP_CODE';

Ship code

M_TRAT_CODE

M_TRAT_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_TRAT_CODE';

Tax rate code

M_FOB_CODE

M_FOB_CODE                CONSTANT VARCHAR2(16)  := 'FPBPOHD_FOB_CODE';

Free on board code

M_DISC_CODE

M_DISC_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_DISC_CODE';

Discount code

M_TEXT_IND

M_TEXT_IND                CONSTANT VARCHAR2(16)  := 'FPBPOHD_TEXT_IND';

Text indicator

M_CLAUSE_IND

M_CLAUSE_IND              CONSTANT VARCHAR2(18)  := 'FPBPOHD_CLAUSE_IND';

Clause indicator

M_CARRIER_PIDM

M_CARRIER_PIDM            CONSTANT VARCHAR2(20)  := 'FPBPOHD_CARRIER_PIDM';

Carrier PIDM

M_TRSK_CODE

M_TRSK_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_TRSK_CODE';

Transit risk code

M_PMNT_CODE

M_PMNT_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_PMNT_CODE';

Payment code

M_PRT_ACK

M_PRT_ACK                 CONSTANT VARCHAR2(15)  := 'FPBPOHD_PRT_ACK';

Print acknowledgement

M_ACK_DATE

M_ACK_DATE                CONSTANT VARCHAR2(16)  := 'FPBPOHD_ACK_DATE';

Acknowledgement date

M_APPR_IND

M_APPR_IND                CONSTANT VARCHAR2(16)  := 'FPBPOHD_APPR_IND';

Approval indicator

M_RUSH_IND

M_RUSH_IND                CONSTANT VARCHAR2(16)  := 'FPBPOHD_RUSH_IND';

Rush indicator

M_REXP_DATE

M_REXP_DATE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_REXP_DATE';

Required expiration date

M_HDR_ADDL_CHRG_AMT

M_HDR_ADDL_CHRG_AMT       CONSTANT VARCHAR2(21)  := 'FPBPOHD_ADDL_CHRG_AMT';

Additional charge amount

M_RUSH_AMT

M_RUSH_AMT                CONSTANT VARCHAR2(16)  := 'FPBPOHD_RUSH_AMT';

Rush purchase order amount

M_SUSP_IND

M_SUSP_IND                CONSTANT VARCHAR2(16)  := 'FPBPOHD_SUSP_IND';

Suspense indicator

M_SUSP_IND_ADDL

M_SUSP_IND_ADDL           CONSTANT VARCHAR2(21)  := 'FPBPOHD_SUSP_IND_ADDL';

Additional suspense indicator

M_CANCEL_IND

M_CANCEL_IND              CONSTANT VARCHAR2(18)  := 'FPBPOHD_CANCEL_IND';

Cancellation indicator

M_CANCEL_DATE

M_CANCEL_DATE             CONSTANT VARCHAR2(19)  := 'FPBPOHD_CANCEL_DATE';

Cancellation date

M_POST_DATE

M_POST_DATE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_POST_DATE';

Post date

M_REQ_BID_IND

M_REQ_BID_IND             CONSTANT VARCHAR2(19)  := 'FPBPOHD_REQ_BID_IND';

Requisition bid indicator

M_EDIT_DEFER_IND

M_EDIT_DEFER_IND          CONSTANT VARCHAR2(22)  := 'FPBPOHD_EDIT_DEFER_IND';

Defer edit indicator

M_PCLS_CODE

M_PCLS_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_PCLS_CODE';

Purchase order classification

M_TGRP_CODE

M_TGRP_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_TGRP_CODE';

Tax group code

M_RECOMM_VEND_NAME

M_RECOMM_VEND_NAME        CONSTANT VARCHAR2(24)  := 'FPBPOHD_RECOMM_VEND_NAME';

Recommended vendor name

M_CURR_CODE

M_CURR_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_CURR_CODE';

Currency code

M_DISB_AGENT_IND

M_DISB_AGENT_IND          CONSTANT VARCHAR2(22)  := 'FPBPOHD_DISB_AGENT_IND';

Disbursing agent indicator

M_NSF_ON_OFF_IND

M_NSF_ON_OFF_IND          CONSTANT VARCHAR2(22)  := 'FPBPOHD_NSF_ON_OFF_IND';

NSF on off indicator

M_INVENTORY_PO_IND

M_INVENTORY_PO_IND        CONSTANT VARCHAR2(24)  := 'FPBPOHD_INVENTORY_PO_IND';

Inventory purchase order indicator

M_SINGLE_ACCTG_IND

M_SINGLE_ACCTG_IND        CONSTANT VARCHAR2(24)  := 'FPBPOHD_SINGLE_ACCTG_IND';

Single distribution accounting indicator

M_DOC_CNTRL_IND

M_DOC_CNTRL_IND           CONSTANT VARCHAR2(21)  := 'FPBPOHD_DOC_CNTRL_IND';

Document control indicator

M_TELE_CODE

M_TELE_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_TELE_CODE';

Telephone code

M_CRSN_CODE

M_CRSN_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_CRSN_CODE';

Cancel reason code

M_DELIVERY_COMMENT

M_DELIVERY_COMMENT        CONSTANT VARCHAR2(24)  := 'FPBPOHD_DELIVERY_COMMENT';

Delivery comment

M_EMAIL_ADDR

M_EMAIL_ADDR              CONSTANT VARCHAR2(18)  := 'FPBPOHD_EMAIL_ADDR';

Email address

M_FAX_AREA

M_FAX_AREA                CONSTANT VARCHAR2(16)  := 'FPBPOHD_FAX_AREA';

Fax area

M_FAX_NUMBER

M_FAX_NUMBER              CONSTANT VARCHAR2(18)  := 'FPBPOHD_FAX_NUMBER';

Fax number

M_FAX_EXT

M_FAX_EXT                 CONSTANT VARCHAR2(15)  := 'FPBPOHD_FAX_EXT';

Fax extension

M_ATTENTION_TO

M_ATTENTION_TO            CONSTANT VARCHAR2(20)  := 'FPBPOHD_ATTENTION_TO';

Attention to

M_VENDOR_CONTACT

M_VENDOR_CONTACT          CONSTANT VARCHAR2(22)  := 'FPBPOHD_VENDOR_CONTACT';

Vendor contact

M_PO_TYPE_IND

M_PO_TYPE_IND             CONSTANT VARCHAR2(19)  := 'FPBPOHD_PO_TYPE_IND';

Purchase order type indicator

M_VEND_EMAIL_ADDR

M_VEND_EMAIL_ADDR         CONSTANT VARCHAR2(23)  := 'FPBPOHD_VEND_EMAIL_ADDR';

Vendor email address

M_NAME

M_NAME                    CONSTANT VARCHAR2(12)  := 'FPBPOHD_NAME';

Name of the person creating the purchase order

M_PHONE_AREA

M_PHONE_AREA              CONSTANT VARCHAR2(18)  := 'FPBPOHD_PHONE_AREA';

Telephone area code

M_PHONE_NUM

M_PHONE_NUM               CONSTANT VARCHAR2(17)  := 'FPBPOHD_PHONE_NUM';

Telephone number

M_PHONE_EXT

M_PHONE_EXT               CONSTANT VARCHAR2(17)  := 'FPBPOHD_PHONE_EXT';

Telephone extension

M_COPIED_FROM

M_COPIED_FROM             CONSTANT VARCHAR2(19)  := 'FPBPOHD_COPIED_FROM';

Copied from

M_CLOSED_DATE

M_CLOSED_DATE             CONSTANT VARCHAR2(19)  := 'FPBPOHD_CLOSED_DATE';

Closed date

M_FTRM_CODE

M_FTRM_CODE               CONSTANT VARCHAR2(17)  := 'FPBPOHD_FTRM_CODE';

Freight Terms Code

M_EDI_IND

M_EDI_IND                 CONSTANT VARCHAR2(15)  := 'FPBPOHD_EDI_IND';

EDI indicator

M_MATCH_REQUIRED

M_MATCH_REQUIRED          CONSTANT VARCHAR2(22)  := 'FPBPOHD_MATCH_REQUIRED';

Match required

M_ORIGIN_CODE

M_ORIGIN_CODE             CONSTANT VARCHAR2(19)  := 'FPBPOHD_ORIGIN_CODE';

Origination code

M_DOC_REF_CODE

M_DOC_REF_CODE            CONSTANT VARCHAR2(20)  := 'FPBPOHD_DOC_REF_CODE';

Document reference code

M_STATUS

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

Status

M_STATUS_MESSAGE

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

Status message

M_VENDOR_ID

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

Vendor ID

M_VENDOR_NAME

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

Vendor name

M_CTRY_CODE_PHONE

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

Telephone country code

M_CTRY_CODE_FAX

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

Fax country code

M_ITEM_OBJECT_NAME

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

Item object name

M_ITEM_POHD_CODE

M_ITEM_POHD_CODE          CONSTANT VARCHAR2(17)  := 'FPRPODT_POHD_CODE';

Purchase order code

M_ITEM_CHANGE_SEQ_NUM

M_ITEM_CHANGE_SEQ_NUM     CONSTANT VARCHAR2(22)  := 'FPRPODT_CHANGE_SEQ_NUM';

Purchase order change sequence number

M_ITEM_ACTIVITY_DATE

M_ITEM_ACTIVITY_DATE      CONSTANT VARCHAR2(21)  := 'FPRPODT_ACTIVITY_DATE';

Item activity date

M_ITEM_USER_ID

M_ITEM_USER_ID            CONSTANT VARCHAR2(15)  := 'FPRPODT_USER_ID';

Item user ID

M_ITEM

M_ITEM                    CONSTANT VARCHAR2(12)  := 'FPRPODT_ITEM';

Item

M_COMM_CODE

M_COMM_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODT_COMM_CODE';

Commodity code

M_COMM_DESC

M_COMM_DESC               CONSTANT VARCHAR2(17)  := 'FPRPODT_COMM_DESC';

Commodity description

M_UOMS_CODE

M_UOMS_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODT_UOMS_CODE';

Unit of measure code

M_UNIT_PRICE

M_UNIT_PRICE              CONSTANT VARCHAR2(18)  := 'FPRPODT_UNIT_PRICE';

Unit price

M_LIQ_AMT

M_LIQ_AMT                 CONSTANT VARCHAR2(15)  := 'FPRPODT_LIQ_AMT';

Liquidation amount

M_QTY

M_QTY                     CONSTANT VARCHAR2(11)  := 'FPRPODT_QTY';

Quantity

M_ITEM_DISC_AMT

M_ITEM_DISC_AMT           CONSTANT VARCHAR2(16)  := 'FPRPODT_DISC_AMT';

Item discount amount

M_ITEM_TAX_AMT

M_ITEM_TAX_AMT            CONSTANT VARCHAR2(15)  := 'FPRPODT_TAX_AMT';

Item tax amount

M_VEND_REF_NUM

M_VEND_REF_NUM            CONSTANT VARCHAR2(20)  := 'FPRPODT_VEND_REF_NUM';

Vendor reference number

M_AGRE_CODE

M_AGRE_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODT_AGRE_CODE';

Agreement code

M_ITEM_SUSP_IND

M_ITEM_SUSP_IND           CONSTANT VARCHAR2(16)  := 'FPRPODT_SUSP_IND';

Item suspense indicator

M_ITEM_CLOSED_IND

M_ITEM_CLOSED_IND         CONSTANT VARCHAR2(18)  := 'FPRPODT_CLOSED_IND';

Item closed indicator

M_ITEM_CANCEL_IND

M_ITEM_CANCEL_IND         CONSTANT VARCHAR2(18)  := 'FPRPODT_CANCEL_IND';

Item cancellation indicator

M_ITEM_CANCEL_DATE

M_ITEM_CANCEL_DATE        CONSTANT VARCHAR2(19)  := 'FPRPODT_CANCEL_DATE';

Item cancellation date

M_TTAG_NUM

M_TTAG_NUM                CONSTANT VARCHAR2(16)  := 'FPRPODT_TTAG_NUM';

Temporary tag number

M_TEXT_USAGE

M_TEXT_USAGE              CONSTANT VARCHAR2(18)  := 'FPRPODT_TEXT_USAGE';

Text Usage

M_ITEM_ADDL_CHRG_AMT

M_ITEM_ADDL_CHRG_AMT      CONSTANT VARCHAR2(21)  := 'FPRPODT_ADDL_CHRG_AMT';

Item additional charge amount

M_CONVERT_UNIT_PRICE

M_CONVERT_UNIT_PRICE      CONSTANT VARCHAR2(26)  := 'FPRPODT_CONVERT_UNIT_PRICE';

Item convert unit price

M_ITEM_CONVERT_DISC_AMT

M_ITEM_CONVERT_DISC_AMT   CONSTANT VARCHAR2(24)  := 'FPRPODT_CONVERT_DISC_AMT';

Item convert discount amount

M_ITEM_CONVERT_TAX_AMT

M_ITEM_CONVERT_TAX_AMT    CONSTANT VARCHAR2(23)  := 'FPRPODT_CONVERT_TAX_AMT';

Item convert tax amount

M_ITEM_CONVERT_ADDL_CHRG_AMT

M_ITEM_CONVERT_ADDL_CHRG_AMT   CONSTANT VARCHAR2(29)  := 'FPRPODT_CONVERT_ADDL_CHRG_AMT';

Item convert additional charge amount

M_ITEM_TGRP_CODE

M_ITEM_TGRP_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODT_TGRP_CODE';

Tax group code

M_EXT_AMT

M_EXT_AMT                 CONSTANT VARCHAR2(15)  := 'FPRPODT_EXT_AMT';

Extension amount

M_BO_REMAIN_BAL

M_BO_REMAIN_BAL           CONSTANT VARCHAR2(21)  := 'FPRPODT_BO_REMAIN_BAL';

Blanket order remaining balance amount

M_DESC_CHGE_IND

M_DESC_CHGE_IND           CONSTANT VARCHAR2(21)  := 'FPRPODT_DESC_CHGE_IND';

Description changed indicator

M_ITEM_SHIP_CODE

M_ITEM_SHIP_CODE          CONSTANT VARCHAR2(17)  := 'FPRPODT_SHIP_CODE';

Ship code

M_ITEM_REQD_DATE

M_ITEM_REQD_DATE          CONSTANT VARCHAR2(17)  := 'FPRPODT_REQD_DATE';

Required delivery date

M_ACCT_OBJECT_NAME

M_ACCT_OBJECT_NAME        CONSTANT VARCHAR2(30)  := 'PURCHASE_ORDER_ACCOUNTING';

Accounting object name

M_PODA_POHD_CODE

M_PODA_POHD_CODE          CONSTANT VARCHAR2(17)  := 'FPRPODA_POHD_CODE';

Purchase order code

M_ACCT_CHANGE_SEQ_NUM

M_ACCT_CHANGE_SEQ_NUM     CONSTANT VARCHAR2(22)  := 'FPRPODA_CHANGE_SEQ_NUM';

Purchase order change sequence number

M_ACCT_ITEM

M_ACCT_ITEM               CONSTANT VARCHAR2(12)  := 'FPRPODA_ITEM';

Accounting item number

M_SEQ_NUM

M_SEQ_NUM                 CONSTANT VARCHAR2(15)  := 'FPRPODA_SEQ_NUM';

Accounting sequence number

M_ACCT_ACTIVITY_DATE

M_ACCT_ACTIVITY_DATE      CONSTANT VARCHAR2(21)  := 'FPRPODA_ACTIVITY_DATE';

Accounting activity date

M_ACCT_USER_ID

M_ACCT_USER_ID            CONSTANT VARCHAR2(15)  := 'FPRPODA_USER_ID';

Accounting user ID

M_AMT

M_AMT                     CONSTANT VARCHAR2(11)  := 'FPRPODA_AMT';

Accounting approved amount

M_DISC_AMT

M_DISC_AMT                CONSTANT VARCHAR2(16)  := 'FPRPODA_DISC_AMT';

Accounting discount amount

M_TAX_AMT

M_TAX_AMT                 CONSTANT VARCHAR2(15)  := 'FPRPODA_TAX_AMT';

Accounting tax amount

M_ADDL_CHRG_AMT

M_ADDL_CHRG_AMT           CONSTANT VARCHAR2(21)  := 'FPRPODA_ADDL_CHRG_AMT';

Accounting additional charge amount

M_FSYR_CODE

M_FSYR_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_FSYR_CODE';

Fiscal year code

M_PERIOD

M_PERIOD                  CONSTANT VARCHAR2(14)  := 'FPRPODA_PERIOD';

Fiscal period

M_RUCL_CODE_PO

M_RUCL_CODE_PO            CONSTANT VARCHAR2(20)  := 'FPRPODA_RUCL_CODE_PO';

PO rule class code

M_DISC_RUCL_CODE

M_DISC_RUCL_CODE          CONSTANT VARCHAR2(22)  := 'FPRPODA_DISC_RUCL_CODE';

Discount rule class code

M_TAX_RUCL_CODE

M_TAX_RUCL_CODE           CONSTANT VARCHAR2(21)  := 'FPRPODA_TAX_RUCL_CODE';

Tax rule class code

M_ADDL_RUCL_CODE

M_ADDL_RUCL_CODE          CONSTANT VARCHAR2(22)  := 'FPRPODA_ADDL_RUCL_CODE';

Additional charge rule class code

M_RUCL_CODE_LIQ

M_RUCL_CODE_LIQ           CONSTANT VARCHAR2(21)  := 'FPRPODA_RUCL_CODE_LIQ';

Liquidation rule class code

M_COAS_CODE

M_COAS_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_COAS_CODE';

Chart of accounts code

M_ACCI_CODE

M_ACCI_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_ACCI_CODE';

Index code

M_FUND_CODE

M_FUND_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_FUND_CODE';

Fund code

M_ORGN_CODE

M_ORGN_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_ORGN_CODE';

Organization code

M_ACCT_CODE

M_ACCT_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_ACCT_CODE';

Account code

M_PROG_CODE

M_PROG_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_PROG_CODE';

Program code

M_ACTV_CODE

M_ACTV_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_ACTV_CODE';

Activity code

M_LOCN_CODE

M_LOCN_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_LOCN_CODE';

Location code

M_PROJ_CODE

M_PROJ_CODE               CONSTANT VARCHAR2(17)  := 'FPRPODA_PROJ_CODE';

Project code

M_ACCT_SUSP_IND

M_ACCT_SUSP_IND           CONSTANT VARCHAR2(16)  := 'FPRPODA_SUSP_IND';

Account suspense indicator

M_NSF_SUSP_IND

M_NSF_SUSP_IND            CONSTANT VARCHAR2(20)  := 'FPRPODA_NSF_SUSP_IND';

NSF suspense indicator

M_ACCT_POST_DATE

M_ACCT_POST_DATE          CONSTANT VARCHAR2(17)  := 'FPRPODA_POST_DATE';

Post date

M_ACCT_APPR_IND

M_ACCT_APPR_IND           CONSTANT VARCHAR2(16)  := 'FPRPODA_APPR_IND';

Approval indicator

M_NSF_OVERRIDE_IND

M_NSF_OVERRIDE_IND        CONSTANT VARCHAR2(24)  := 'FPRPODA_NSF_OVERRIDE_IND';

NSF override indicator

M_ACCT_CLOSED_IND

M_ACCT_CLOSED_IND         CONSTANT VARCHAR2(18)  := 'FPRPODA_CLOSED_IND';

Account closed indicator

M_CONVERT_AMT

M_CONVERT_AMT             CONSTANT VARCHAR2(19)  := 'FPRPODA_CONVERT_AMT';

Convert approved amount

M_CONVERT_DISC_AMT

M_CONVERT_DISC_AMT        CONSTANT VARCHAR2(24)  := 'FPRPODA_CONVERT_DISC_AMT';

Convert discount amount

M_CONVERT_TAX_AMT

M_CONVERT_TAX_AMT         CONSTANT VARCHAR2(23)  := 'FPRPODA_CONVERT_TAX_AMT';

Convert tax amount

M_CONVERT_ADDL_CHRG_AMT

M_CONVERT_ADDL_CHRG_AMT   CONSTANT VARCHAR2(29)  := 'FPRPODA_CONVERT_ADDL_CHRG_AMT';

Convert additional charge amount

M_APPR_AMT_PCT

M_APPR_AMT_PCT            CONSTANT VARCHAR2(20)  := 'FPRPODA_APPR_AMT_PCT';

Approved amount percentage

M_DISC_AMT_PCT

M_DISC_AMT_PCT            CONSTANT VARCHAR2(20)  := 'FPRPODA_DISC_AMT_PCT';

Discount amount percentage

M_ADDL_AMT_PCT

M_ADDL_AMT_PCT            CONSTANT VARCHAR2(20)  := 'FPRPODA_ADDL_AMT_PCT';

Additional charge amount percentage

M_TAX_AMT_PCT

M_TAX_AMT_PCT             CONSTANT VARCHAR2(19)  := 'FPRPODA_TAX_AMT_PCT';

Tax amount percentage

p_register_header_entity

Procedure p_register_header_entity(p_operation_id   NUMBER,
                                   p_code           varchar2,
                                   p_doc_ref_code   varchar2 default NULL,
                                   p_change_seq_num FPBPOHD.FPBPOHD_CHANGE_SEQ_NUM%TYPE default NULL)

Registers the purchase order header attribute value pairs to the message cache.

Parameters

	p_operation_id	The ID of DML operation: create,update,delete. NUMBER Required.
	p_code	The purchase order code. VARCHAR2(8) Required.
	p_doc_ref_code	Purchase order reference code. VARCHAR2(20).
	p_change_seq_num	The purchase order change sequence number. NUMBER(3).

p_register_item_entity

Procedure p_register_item_entity(p_operation_id   NUMBER,
                                 p_code           varchar2,
                                 p_change_seq_num FPBPOHD.FPBPOHD_CHANGE_SEQ_NUM%TYPE default NULL,
                                 p_item           fprpodt.fprpodt_item%type default null)

Registers the purchase order item attribute value pairs to the message cache.

Parameters

	p_operation_id	The ID of DML operation: create,update,delete. NUMBER Required.
	p_code	The purchase order code. VARCHAR2(8) Required.
	p_change_seq_num	The purchase order change sequence number. NUMBER(3).
	p_item	Purchase order item number. NUMBER(3).

p_register_acctg_entity

Procedure p_register_acctg_entity(p_operation_id   NUMBER,
                                  p_code           varchar2,
                                  p_change_seq_num FPBPOHD.FPBPOHD_CHANGE_SEQ_NUM%TYPE default NULL,
                                  p_item           fprpoda.fprpoda_item%type default null,
                                  p_seq_num        fprpoda.fprpoda_seq_num%type default null)

Registers the purchase order accounting attribute value pairs to the message cache.

Parameters

	p_operation_id	The ID of DML operation: create,update,delete. NUMBER Required.
	p_code	The purchase order code. VARCHAR2(8) Required.
	p_change_seq_num	The purchase order change sequence number. NUMBER(3).
	p_item	Purchase order item number. NUMBER(3).
	p_seq_num	Purchase order sequence number. NUMBER(3).

p_register_po

Procedure p_register_po(po_code    fpbpohd.fpbpohd_code%type default null,
                        po_doc_ref fpbpohd.fpbpohd_doc_ref_code%type default null,
                        po_chg_seq number default null,
                        action     varchar2 default null)

Registers the purchase order attribute value pairs to the message cache.

Parameters

	po_code	The purchase order code. VARCHAR2(8).
	po_doc_ref	Purchase order reference code. VARCHAR2(20).
	po_chg_seq	The purchase order change sequence number. NUMBER.
	action	Action indicator with values as CREATE, UPDATE or DELETE. VARCHAR2.

p_register_po

Procedure p_register_po(fpbpohd_cursor foksels.ref_cursortype,
                        fprpodt_cursor foksels.ref_cursortype,
                        fprpoda_cursor foksels.ref_cursortype,
                        action         varchar2)

Registers the purchase order attribute value pairs to the message cache.

Parameters

	fpbpohd_cursor	Cursor variable holding purchase order header record. foksels.ref_cursortype
	fprpodt_cursor	Cursor variable holding purchase order item record. foksels.ref_cursortype
	fprpoda_cursor	Cursor variable holding purchase order accounting record. foksels.ref_cursortype
	action	Action indicator with values as CREATE, UPDATE or DELETE. VARCHAR2.

p_register_header_entity

Procedure p_register_header_entity(p_operation_id      NUMBER,
                                   p_code              varchar2,
                                   p_change_seq_num    FPBPOHD.FPBPOHD_CHANGE_SEQ_NUM%TYPE default NULL,
                                   p_activity_date     FPBPOHD.FPBPOHD_ACTIVITY_DATE%TYPE default NULL,
                                   p_user_id           FPBPOHD.FPBPOHD_USER_ID%TYPE default NULL,
                                   p_po_date           FPBPOHD.FPBPOHD_PO_DATE%TYPE default NULL,
                                   p_trans_date        FPBPOHD.FPBPOHD_TRANS_DATE%TYPE default NULL,
                                   p_blanket_code      FPBPOHD.FPBPOHD_BLANKET_CODE%TYPE default NULL,
                                   p_blanket_ind       FPBPOHD.FPBPOHD_BLANKET_IND%TYPE default NULL,
                                   p_blanket_term_date FPBPOHD.FPBPOHD_BLANKET_TERM_DATE%TYPE default NULL,
                                   p_closed_ind        FPBPOHD.FPBPOHD_CLOSED_IND%TYPE default NULL,
                                   p_complete_ind      FPBPOHD.FPBPOHD_COMPLETE_IND%TYPE default NULL,
                                   p_print_ind         FPBPOHD.FPBPOHD_PRINT_IND%TYPE default NULL,
                                   p_po_printed_date   FPBPOHD.FPBPOHD_PO_PRINTED_DATE%TYPE default NULL,
                                   p_vend_pidm         FPBPOHD.FPBPOHD_VEND_PIDM%TYPE default NULL,
                                   p_atyp_code         FPBPOHD.FPBPOHD_ATYP_CODE%TYPE default NULL,
                                   p_atyp_seq_num      FPBPOHD.FPBPOHD_ATYP_SEQ_NUM%TYPE default NULL,
                                   p_buyr_code         FPBPOHD.FPBPOHD_BUYR_CODE%TYPE default NULL,
                                   p_reqd_date         FPBPOHD.FPBPOHD_REQD_DATE%TYPE default NULL,
                                   p_coas_code         FPBPOHD.FPBPOHD_COAS_CODE%TYPE default NULL,
                                   p_orgn_code         FPBPOHD.FPBPOHD_ORGN_CODE%TYPE default NULL,
                                   p_ship_code         FPBPOHD.FPBPOHD_SHIP_CODE%TYPE default NULL,
                                   p_trat_code         FPBPOHD.FPBPOHD_TRAT_CODE%TYPE default NULL,
                                   p_fob_code          FPBPOHD.FPBPOHD_FOB_CODE%TYPE default NULL,
                                   p_disc_code         FPBPOHD.FPBPOHD_DISC_CODE%TYPE default NULL,
                                   p_text_ind          FPBPOHD.FPBPOHD_TEXT_IND%TYPE default NULL,
                                   p_clause_ind        FPBPOHD.FPBPOHD_CLAUSE_IND%TYPE default NULL,
                                   p_carrier_pidm      FPBPOHD.FPBPOHD_CARRIER_PIDM%TYPE default NULL,
                                   p_trsk_code         FPBPOHD.FPBPOHD_TRSK_CODE%TYPE default NULL,
                                   p_pmnt_code         FPBPOHD.FPBPOHD_PMNT_CODE%TYPE default NULL,
                                   p_prt_ack           FPBPOHD.FPBPOHD_PRT_ACK%TYPE default NULL,
                                   p_ack_date          FPBPOHD.FPBPOHD_ACK_DATE%TYPE default NULL,
                                   p_appr_ind          FPBPOHD.FPBPOHD_APPR_IND%TYPE default NULL,
                                   p_rush_ind          FPBPOHD.FPBPOHD_RUSH_IND%TYPE default NULL,
                                   p_rexp_date         FPBPOHD.FPBPOHD_REXP_DATE%TYPE default NULL,
                                   p_addl_chrg_amt     FPBPOHD.FPBPOHD_ADDL_CHRG_AMT%TYPE default NULL,
                                   p_rush_amt          FPBPOHD.FPBPOHD_RUSH_AMT%TYPE default NULL,
                                   p_susp_ind          FPBPOHD.FPBPOHD_SUSP_IND%TYPE default NULL,
                                   p_susp_ind_addl     FPBPOHD.FPBPOHD_SUSP_IND_ADDL%TYPE default NULL,
                                   p_cancel_ind        FPBPOHD.FPBPOHD_CANCEL_IND%TYPE default NULL,
                                   p_cancel_date       FPBPOHD.FPBPOHD_CANCEL_DATE%TYPE default NULL,
                                   p_post_date         FPBPOHD.FPBPOHD_POST_DATE%TYPE default NULL,
                                   p_req_bid_ind       FPBPOHD.FPBPOHD_REQ_BID_IND%TYPE default NULL,
                                   p_edit_defer_ind    FPBPOHD.FPBPOHD_EDIT_DEFER_IND%TYPE default NULL,
                                   p_pcls_code         FPBPOHD.FPBPOHD_PCLS_CODE%TYPE default NULL,
                                   p_tgrp_code         FPBPOHD.FPBPOHD_TGRP_CODE%TYPE default NULL,
                                   p_recomm_vend_name  FPBPOHD.FPBPOHD_RECOMM_VEND_NAME%TYPE default NULL,
                                   p_curr_code         FPBPOHD.FPBPOHD_CURR_CODE%TYPE default NULL,
                                   p_disb_agent_ind    FPBPOHD.FPBPOHD_DISB_AGENT_IND%TYPE default NULL,
                                   p_nsf_on_off_ind    FPBPOHD.FPBPOHD_NSF_ON_OFF_IND%TYPE default NULL,
                                   p_inventory_po_ind  FPBPOHD.FPBPOHD_INVENTORY_PO_IND%TYPE default NULL,
                                   p_single_acctg_ind  FPBPOHD.FPBPOHD_SINGLE_ACCTG_IND%TYPE default NULL,
                                   p_doc_cntrl_ind     FPBPOHD.FPBPOHD_DOC_CNTRL_IND%TYPE default NULL,
                                   p_tele_code         FPBPOHD.FPBPOHD_TELE_CODE%TYPE default NULL,
                                   p_crsn_code         FPBPOHD.FPBPOHD_CRSN_CODE%TYPE default NULL,
                                   p_delivery_comment  FPBPOHD.FPBPOHD_DELIVERY_COMMENT%TYPE default NULL,
                                   p_email_addr        FPBPOHD.FPBPOHD_EMAIL_ADDR%TYPE default NULL,
                                   p_fax_area          FPBPOHD.FPBPOHD_FAX_AREA%TYPE default NULL,
                                   p_fax_number        FPBPOHD.FPBPOHD_FAX_NUMBER%TYPE default NULL,
                                   p_fax_ext           FPBPOHD.FPBPOHD_FAX_EXT%TYPE default NULL,
                                   p_attention_to      FPBPOHD.FPBPOHD_ATTENTION_TO%TYPE default NULL,
                                   p_vendor_contact    FPBPOHD.FPBPOHD_VENDOR_CONTACT%TYPE default NULL,
                                   p_po_type_ind       FPBPOHD.FPBPOHD_PO_TYPE_IND%TYPE default NULL,
                                   p_vend_email_addr   FPBPOHD.FPBPOHD_VEND_EMAIL_ADDR%TYPE default NULL,
                                   p_name              FPBPOHD.FPBPOHD_NAME%TYPE default NULL,
                                   p_phone_area        FPBPOHD.FPBPOHD_PHONE_AREA%TYPE default NULL,
                                   p_phone_num         FPBPOHD.FPBPOHD_PHONE_NUM%TYPE default NULL,
                                   p_phone_ext         FPBPOHD.FPBPOHD_PHONE_EXT%TYPE default NULL,
                                   p_copied_from       FPBPOHD.FPBPOHD_COPIED_FROM%TYPE default NULL,
                                   p_closed_date       FPBPOHD.FPBPOHD_CLOSED_DATE%TYPE default NULL,
                                   p_ftrm_code         FPBPOHD.FPBPOHD_FTRM_CODE%TYPE default NULL,
                                   p_edi_ind           FPBPOHD.FPBPOHD_EDI_IND%TYPE default NULL,
                                   p_match_required    FPBPOHD.FPBPOHD_MATCH_REQUIRED%TYPE default NULL,
                                   p_origin_code       FPBPOHD.FPBPOHD_ORIGIN_CODE%TYPE default NULL,
                                   p_doc_ref_code      FPBPOHD.FPBPOHD_DOC_REF_CODE%TYPE default NULL,
                                   p_po_status         varchar2 default null,
                                   p_status_message    varchar2 default null,
                                   p_ctry_code_phone   fpbpohd.fpbpohd_ctry_code_phone%TYPE DEFAULT NULL,
                                   p_ctry_code_fax     fpbpohd.fpbpohd_ctry_code_fax%TYPE DEFAULT NULL)

Registers the purchase order header attribute value pairs to the message cache.

p_register_item_entity

Procedure p_register_item_entity(p_operation_id          NUMBER,
                                 p_pohd_code             varchar2,
                                 p_change_seq_num        FPRPODT.FPRPODT_CHANGE_SEQ_NUM%TYPE,
                                 p_activity_date         FPRPODT.FPRPODT_ACTIVITY_DATE%TYPE,
                                 p_user_id               FPRPODT.FPRPODT_USER_ID%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_liq_amt               FPRPODT.FPRPODT_LIQ_AMT%TYPE,
                                 p_qty                   FPRPODT.FPRPODT_QTY%TYPE,
                                 p_disc_amt              FPRPODT.FPRPODT_DISC_AMT%TYPE,
                                 p_tax_amt               FPRPODT.FPRPODT_TAX_AMT%TYPE,
                                 p_vend_ref_num          FPRPODT.FPRPODT_VEND_REF_NUM%TYPE,
                                 p_agre_code             FPRPODT.FPRPODT_AGRE_CODE%TYPE,
                                 p_susp_ind              FPRPODT.FPRPODT_SUSP_IND%TYPE,
                                 p_closed_ind            FPRPODT.FPRPODT_CLOSED_IND%TYPE,
                                 p_cancel_ind            FPRPODT.FPRPODT_CANCEL_IND%TYPE,
                                 p_cancel_date           FPRPODT.FPRPODT_CANCEL_DATE%TYPE,
                                 p_ttag_num              FPRPODT.FPRPODT_TTAG_NUM%TYPE,
                                 p_text_usage            FPRPODT.FPRPODT_TEXT_USAGE%TYPE,
                                 p_addl_chrg_amt         FPRPODT.FPRPODT_ADDL_CHRG_AMT%TYPE,
                                 p_convert_unit_price    FPRPODT.FPRPODT_CONVERT_UNIT_PRICE%TYPE,
                                 p_convert_disc_amt      FPRPODT.FPRPODT_CONVERT_DISC_AMT%TYPE,
                                 p_convert_tax_amt       FPRPODT.FPRPODT_CONVERT_TAX_AMT%TYPE,
                                 p_convert_addl_chrg_amt FPRPODT.FPRPODT_CONVERT_ADDL_CHRG_AMT%TYPE,
                                 p_tgrp_code             FPRPODT.FPRPODT_TGRP_code%TYPE,
                                 p_ext_amt               FPRPODT.FPRPODT_EXT_AMT%TYPE,
                                 p_bo_remain_bal         FPRPODT.FPRPODT_BO_REMAIN_BAL%TYPE,
                                 p_desc_chge_ind         FPRPODT.FPRPODT_DESC_CHGE_IND%TYPE,
                                 p_ship_code             FPRPODT.FPRPODT_SHIp_code%TYPE,
                                 p_reqd_date             FPRPODT.FPRPODT_REQD_DATE%TYPE)

Registers the purchase order item attribute value pairs to the message cache.

p_register_acctg_entity

Procedure p_register_acctg_entity(p_operation_id          NUMBER,
                                  p_pohd_code             varchar2,
                                  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_activity_date         FPRPODA.FPRPODA_ACTIVITY_DATE%TYPE,
                                  p_user_id               FPRPODA.FPRPODA_USER_ID%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_fsyr_code             FPRPODA.FPRPODA_FSYR_CODE%TYPE,
                                  p_period                FPRPODA.FPRPODA_PERIOD%TYPE,
                                  p_rucl_code_po          FPRPODA.FPRPODA_RUCL_CODE_PO%TYPE,
                                  p_disc_rucl_code        FPRPODA.FPRPODA_DISC_RUCL_CODE%TYPE,
                                  p_tax_rucl_code         FPRPODA.FPRPODA_TAX_RUCL_CODE%TYPE,
                                  p_addl_rucl_code        FPRPODA.FPRPODA_ADDL_RUCL_CODE%TYPE,
                                  p_rucl_code_liq         FPRPODA.FPRPODA_RUCL_CODE_LIQ%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_susp_ind              FPRPODA.FPRPODA_SUSP_IND%TYPE,
                                  p_nsf_susp_ind          FPRPODA.FPRPODA_NSF_SUSP_IND%TYPE,
                                  p_post_date             FPRPODA.FPRPODA_POST_DATE%TYPE,
                                  p_appr_ind              FPRPODA.FPRPODA_APPR_IND%TYPE,
                                  p_nsf_override_ind      FPRPODA.FPRPODA_NSF_OVERRIDE_IND%TYPE,
                                  p_closed_ind            FPRPODA.FPRPODA_CLOSED_IND%TYPE,
                                  p_convert_amt           FPRPODA.FPRPODA_CONVERT_AMT%TYPE,
                                  p_convert_disc_amt      FPRPODA.FPRPODA_CONVERT_DISC_AMT%TYPE,
                                  p_convert_tax_amt       FPRPODA.FPRPODA_CONVERT_TAX_AMT%TYPE,
                                  p_convert_addl_chrg_amt FPRPODA.FPRPODA_CONVERT_ADDL_CHRG_AMT%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)

Registers the purchase order accounting attribute value pairs to the message cache.