18: /* NC - 11/02/01 Temperary declaration of this record type. Should be
19: deleted when OM changes are incorporated */
20:
21: TYPE SplitDetailRecType IS RECORD (
22: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
23: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
19: deleted when OM changes are incorporated */
20:
21: TYPE SplitDetailRecType IS RECORD (
22: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
23: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
20:
21: TYPE SplitDetailRecType IS RECORD (
22: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
23: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
21: TYPE SplitDetailRecType IS RECORD (
22: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
23: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
22: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
23: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
23: requested_quantity WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_quantity2%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
33: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
35: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
36: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
38: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
46: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
39: source_line_id WSH_DELIVERY_DETAILS.source_line_id%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
46: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
47: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
40: net_weight WSH_DELIVERY_DETAILS.net_weight%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
46: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
47: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
48: delivery_id WSH_DELIVERY_ASSIGNMENTS.delivery_id%TYPE,
41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%TYPE,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
46: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
47: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
48: delivery_id WSH_DELIVERY_ASSIGNMENTS.delivery_id%TYPE,
49: parent_delivery_detail_id WSH_DELIVERY_ASSIGNMENTS.parent_delivery_detail_id%TYPE
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
46: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
47: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
48: delivery_id WSH_DELIVERY_ASSIGNMENTS.delivery_id%TYPE,
49: parent_delivery_detail_id WSH_DELIVERY_ASSIGNMENTS.parent_delivery_detail_id%TYPE
50: );
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%TYPE,
45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
46: container_flag WSH_DELIVERY_DETAILS.container_flag%TYPE,
47: released_status WSH_DELIVERY_DETAILS.released_status%TYPE,
48: delivery_id WSH_DELIVERY_ASSIGNMENTS.delivery_id%TYPE,
49: parent_delivery_detail_id WSH_DELIVERY_ASSIGNMENTS.parent_delivery_detail_id%TYPE
50: );
51: PROCEDURE GMI_CREATE_BACKORDER_TXN
48: delivery_id WSH_DELIVERY_ASSIGNMENTS.delivery_id%TYPE,
49: parent_delivery_detail_id WSH_DELIVERY_ASSIGNMENTS.parent_delivery_detail_id%TYPE
50: );
51: PROCEDURE GMI_CREATE_BACKORDER_TXN
52: ( p_shipping_line IN wsh_delivery_details%ROWTYPE
53: , x_return_status OUT NOCOPY VARCHAR2
54: , x_msg_count OUT NOCOPY NUMBER
55: , x_msg_data OUT NOCOPY VARCHAR2
56: );
55: , x_msg_data OUT NOCOPY VARCHAR2
56: );
57:
58: PROCEDURE GMI_UPDATE_SHIPMENT_TXN
59: ( p_shipping_line IN wsh_delivery_details%ROWTYPE
60: , p_actual_ship_date IN Date
61: , x_return_status OUT NOCOPY VARCHAR2
62: , x_msg_count OUT NOCOPY NUMBER
63: , x_msg_data OUT NOCOPY VARCHAR2
102: , p_routine IN VARCHAR2
103: );
104:
105: PROCEDURE create_rcv_transaction
106: ( p_shipping_line IN wsh_delivery_details%ROWTYPE
107: , p_trip_stop_rec IN wsh_trip_stops%ROWTYPE
108: , p_group_id IN NUMBER
109: , x_return_status OUT NOCOPY VARCHAR2
110: , x_msg_count OUT NOCOPY NUMBER