DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PUB dependencies on WSH_DEL_DETAILS_INTERFACE

Line 19: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,

15: -- PUBLIC VARS
16: --===================
17:
18: TYPE Shipment_Details_Rec_Type IS RECORD (
19: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
20: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,

Line 20: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,

16: --===================
17:
18: TYPE Shipment_Details_Rec_Type IS RECORD (
19: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
20: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,

Line 21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,

17:
18: TYPE Shipment_Details_Rec_Type IS RECORD (
19: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
20: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,

Line 22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,

18: TYPE Shipment_Details_Rec_Type IS RECORD (
19: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
20: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,

Line 23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,

19: delivery_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE,
20: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,

Line 24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,

20: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,

Line 25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,

21: item_number WSH_DEL_DETAILS_INTERFACE.item_number%TYPE,
22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,

Line 26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,

22: inventory_item_id WSH_DEL_DETAILS_INTERFACE.inventory_item_id%TYPE,
23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,

Line 27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,

23: item_description WSH_DEL_DETAILS_INTERFACE.item_description%TYPE,
24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,

Line 28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,

24: requested_quantity WSH_DEL_DETAILS_INTERFACE.requested_quantity%TYPE,
25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,

Line 29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,

25: requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.requested_quantity_uom%TYPE,
26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,

Line 30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,

26: customer_item_number WSH_DEL_DETAILS_INTERFACE.customer_item_number%TYPE,
27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,

Line 31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,

27: customer_item_id WSH_DEL_DETAILS_INTERFACE.customer_item_id%TYPE,
28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,

Line 32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,

28: date_requested WSH_DEL_DETAILS_INTERFACE.date_requested%TYPE,
29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,

Line 33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,

29: date_scheduled WSH_DEL_DETAILS_INTERFACE.date_scheduled%TYPE,
30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,

Line 34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,

30: ship_tolerance_above WSH_DEL_DETAILS_INTERFACE.ship_tolerance_above%TYPE,
31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,

Line 35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,

31: ship_tolerance_below WSH_DEL_DETAILS_INTERFACE.ship_tolerance_below%TYPE,
32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,

Line 36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,

32: packing_instructions WSH_DEL_DETAILS_INTERFACE.packing_instructions%TYPE,
33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,

Line 37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,

33: shipping_instructions WSH_DEL_DETAILS_INTERFACE.shipping_instructions%TYPE,
34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,

Line 38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,

34: shipment_priority_code WSH_DEL_DETAILS_INTERFACE.shipment_priority_code%TYPE,
35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,

Line 39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,

35: ship_set_name WSH_DEL_DETAILS_INTERFACE.ship_set_name%TYPE,
36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,

Line 40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,

36: subinventory WSH_DEL_DETAILS_INTERFACE.subinventory%TYPE,
37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,

Line 41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,

37: revision WSH_DEL_DETAILS_INTERFACE.revision%TYPE,
38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,

Line 42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,

38: locator_code WSH_DEL_DETAILS_INTERFACE.locator_code%TYPE,
39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,

Line 43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,

39: locator_id WSH_DEL_DETAILS_INTERFACE.locator_id%TYPE,
40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,

Line 44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,

40: lot_number WSH_DEL_DETAILS_INTERFACE.lot_number%TYPE,
41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,

Line 45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,

41: unit_selling_price WSH_DEL_DETAILS_INTERFACE.unit_selling_price%TYPE,
42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,

Line 46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,

42: currency_code WSH_DEL_DETAILS_INTERFACE.currency_code%TYPE,
43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
50: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,

Line 47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,

43: earliest_pickup_date WSH_DEL_DETAILS_INTERFACE.earliest_pickup_date%TYPE,
44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
50: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
51: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE);

Line 48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,

44: latest_pickup_date WSH_DEL_DETAILS_INTERFACE.latest_pickup_date%TYPE,
45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
50: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
51: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE);
52:

Line 49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,

45: earliest_dropoff_date WSH_DEL_DETAILS_INTERFACE.earliest_dropoff_date%TYPE,
46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
50: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
51: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE);
52:
53: TYPE Shipment_Details_Rec_Tab IS TABLE OF Shipment_Details_Rec_Type index by binary_integer;

Line 50: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,

46: latest_dropoff_date WSH_DEL_DETAILS_INTERFACE.latest_dropoff_date%TYPE,
47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
50: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
51: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE);
52:
53: TYPE Shipment_Details_Rec_Tab IS TABLE OF Shipment_Details_Rec_Type index by binary_integer;
54:

Line 51: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE);

47: cust_po_number WSH_DEL_DETAILS_INTERFACE.cust_po_number%TYPE,
48: source_header_number WSH_DEL_DETAILS_INTERFACE.source_header_number%TYPE,
49: source_line_number WSH_DEL_DETAILS_INTERFACE.source_line_number%TYPE,
50: src_requested_quantity WSH_DEL_DETAILS_INTERFACE.src_requested_quantity%TYPE,
51: src_requested_quantity_uom WSH_DEL_DETAILS_INTERFACE.src_requested_quantity_uom%TYPE);
52:
53: TYPE Shipment_Details_Rec_Tab IS TABLE OF Shipment_Details_Rec_Type index by binary_integer;
54:
55: TYPE Shipment_Request_Rec_Type IS RECORD (

Line 130: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,

126:
127: TYPE Interface_Errors_Rec_Type IS RECORD (
128: document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE,
129: document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE,
130: line_number WSH_DEL_DETAILS_INTERFACE.line_number%TYPE,
131: error_message WSH_INTERFACE_ERRORS.error_message%TYPE);
132:
133:
134: