9: -- Package types
10: -------------------------------------------------------------------------------
11: -- Header record type
12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
10: -------------------------------------------------------------------------------
11: -- Header record type
12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
11: -- Header record type
12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
12: TYPE Header_Rec_Type IS RECORD
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE
13: ( org_id PO_HEADERS.org_id%TYPE
14: , p_order_header_id PO_HEADERS.po_header_id%TYPE
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE
21: -- New Attributes for Receiving
15: , supplier_id PO_HEADERS.vendor_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE
21: -- New Attributes for Receiving
22: --
23: , shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
16: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
17: , creation_date PO_HEADERS.creation_date%TYPE
18: , order_type VARCHAR2(20) -- REQUISITION/PO
19: , ship_to_location_id PO_HEADERS.ship_to_location_id%TYPE
20: , ship_to_org_id PO_HEADERS.org_id%TYPE
21: -- New Attributes for Receiving
22: --
23: , shipment_header_id RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
24: , hazard_class RCV_SHIPMENT_HEADERS.hazard_class%TYPE
39:
40: -- Line record type
41: TYPE Line_Rec_Type IS RECORD
42: ( order_line_id PO_LINES.po_line_id%TYPE
43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
40: -- Line record type
41: TYPE Line_Rec_Type IS RECORD
42: ( order_line_id PO_LINES.po_line_id%TYPE
43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
48: , ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE
42: ( order_line_id PO_LINES.po_line_id%TYPE
43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
48: , ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE
49: , ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE
50: , supplier_item_num PO_LINES.vendor_product_num%TYPE
43: , agreement_type PO_HEADERS.type_lookup_code%TYPE
44: , agreement_id PO_HEADERS.po_header_id%TYPE
45: , agreement_line_id PO_LINES.po_line_id%TYPE --
46: , supplier_id PO_HEADERS.vendor_id%TYPE
47: , supplier_site_id PO_HEADERS.vendor_site_id%TYPE
48: , ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE
49: , ship_to_org_id PO_LINE_LOCATIONS.ship_to_organization_id%TYPE
50: , supplier_item_num PO_LINES.vendor_product_num%TYPE
51: , item_revision PO_LINES.item_revision%TYPE
50: , supplier_item_num PO_LINES.vendor_product_num%TYPE
51: , item_revision PO_LINES.item_revision%TYPE
52: , item_id PO_LINES.item_id%TYPE
53: , category_id PO_LINES.category_id%TYPE
54: , rate PO_HEADERS.rate%TYPE
55: , rate_type PO_HEADERS.rate_type%TYPE
56: , currency_code PO_HEADERS.currency_code%TYPE
57: , need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE
58: --
51: , item_revision PO_LINES.item_revision%TYPE
52: , item_id PO_LINES.item_id%TYPE
53: , category_id PO_LINES.category_id%TYPE
54: , rate PO_HEADERS.rate%TYPE
55: , rate_type PO_HEADERS.rate_type%TYPE
56: , currency_code PO_HEADERS.currency_code%TYPE
57: , need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE
58: --
59: -- New Attributes for Receiving
52: , item_id PO_LINES.item_id%TYPE
53: , category_id PO_LINES.category_id%TYPE
54: , rate PO_HEADERS.rate%TYPE
55: , rate_type PO_HEADERS.rate_type%TYPE
56: , currency_code PO_HEADERS.currency_code%TYPE
57: , need_by_date PO_LINE_LOCATIONS.need_by_date%TYPE
58: --
59: -- New Attributes for Receiving
60: , shipment_line_id RCV_SHIPMENT_LINES.shipment_line_id%TYPE