4: --
5: --
6:
7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;
5: --
6:
7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;
13:
6:
7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;
13:
14: --
7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;
13:
14: --
15: --Procedure: Ship_Confirm_A_Trip_Stop