24:
25: TYPE t_Cursor_ref IS REF CURSOR;
26:
27: TYPE t_ItemAttribsRec IS RECORD (
28: ship_from_ext RLM_INTERFACE_LINES.cust_ship_from_org_ext%TYPE,
29: ship_to_ext RLM_INTERFACE_LINES.cust_ship_to_ext%TYPE,
30: bill_to_ext RLM_INTERFACE_LINES.cust_bill_to_ext%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
25: TYPE t_Cursor_ref IS REF CURSOR;
26:
27: TYPE t_ItemAttribsRec IS RECORD (
28: ship_from_ext RLM_INTERFACE_LINES.cust_ship_from_org_ext%TYPE,
29: ship_to_ext RLM_INTERFACE_LINES.cust_ship_to_ext%TYPE,
30: bill_to_ext RLM_INTERFACE_LINES.cust_bill_to_ext%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
26:
27: TYPE t_ItemAttribsRec IS RECORD (
28: ship_from_ext RLM_INTERFACE_LINES.cust_ship_from_org_ext%TYPE,
29: ship_to_ext RLM_INTERFACE_LINES.cust_ship_to_ext%TYPE,
30: bill_to_ext RLM_INTERFACE_LINES.cust_bill_to_ext%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
27: TYPE t_ItemAttribsRec IS RECORD (
28: ship_from_ext RLM_INTERFACE_LINES.cust_ship_from_org_ext%TYPE,
29: ship_to_ext RLM_INTERFACE_LINES.cust_ship_to_ext%TYPE,
30: bill_to_ext RLM_INTERFACE_LINES.cust_bill_to_ext%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
28: ship_from_ext RLM_INTERFACE_LINES.cust_ship_from_org_ext%TYPE,
29: ship_to_ext RLM_INTERFACE_LINES.cust_ship_to_ext%TYPE,
30: bill_to_ext RLM_INTERFACE_LINES.cust_bill_to_ext%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
29: ship_to_ext RLM_INTERFACE_LINES.cust_ship_to_ext%TYPE,
30: bill_to_ext RLM_INTERFACE_LINES.cust_bill_to_ext%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
30: bill_to_ext RLM_INTERFACE_LINES.cust_bill_to_ext%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
31: cust_item_ext RLM_INTERFACE_LINES.customer_item_ext%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
32: item_desc_ext RLM_INTERFACE_LINES.item_description_ext%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
40: cust_po_date RLM_INTERFACE_LINES.cust_po_date%TYPE,
33: cust_dock_code RLM_INTERFACE_LINES.customer_dock_code%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
40: cust_po_date RLM_INTERFACE_LINES.cust_po_date%TYPE,
41: commodity_ext RLM_INTERFACE_LINES.commodity_ext%TYPE,
34: hazrd_code_ext RLM_INTERFACE_LINES.hazard_code_ext%TYPE,
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
40: cust_po_date RLM_INTERFACE_LINES.cust_po_date%TYPE,
41: commodity_ext RLM_INTERFACE_LINES.commodity_ext%TYPE,
42: sup_item_ext RLM_INTERFACE_LINES.supplier_item_ext%TYPE);
35: cust_item_rev RLM_INTERFACE_LINES.customer_item_revision%TYPE,
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
40: cust_po_date RLM_INTERFACE_LINES.cust_po_date%TYPE,
41: commodity_ext RLM_INTERFACE_LINES.commodity_ext%TYPE,
42: sup_item_ext RLM_INTERFACE_LINES.supplier_item_ext%TYPE);
43:
36: item_note_text RLM_INTERFACE_LINES.item_note_text%TYPE,
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
40: cust_po_date RLM_INTERFACE_LINES.cust_po_date%TYPE,
41: commodity_ext RLM_INTERFACE_LINES.commodity_ext%TYPE,
42: sup_item_ext RLM_INTERFACE_LINES.supplier_item_ext%TYPE);
43:
44:
37: cust_po_num RLM_INTERFACE_LINES.cust_po_number%TYPE,
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
40: cust_po_date RLM_INTERFACE_LINES.cust_po_date%TYPE,
41: commodity_ext RLM_INTERFACE_LINES.commodity_ext%TYPE,
42: sup_item_ext RLM_INTERFACE_LINES.supplier_item_ext%TYPE);
43:
44:
45: TYPE t_SchdItemAttribs IS TABLE OF t_ItemAttribsRec
38: cust_po_linnum RLM_INTERFACE_LINES.cust_po_line_num%TYPE,
39: cust_po_relnum RLM_INTERFACE_LINES.cust_po_release_num%TYPE,
40: cust_po_date RLM_INTERFACE_LINES.cust_po_date%TYPE,
41: commodity_ext RLM_INTERFACE_LINES.commodity_ext%TYPE,
42: sup_item_ext RLM_INTERFACE_LINES.supplier_item_ext%TYPE);
43:
44:
45: TYPE t_SchdItemAttribs IS TABLE OF t_ItemAttribsRec
46: INDEX BY BINARY_INTEGER;