DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 22: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,

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,

Line 23: requested_quantity WSH_DELIVERY_DETAILS.requested_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,

Line 24: picked_quantity WSH_DELIVERY_DETAILS.picked_quantity%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,

Line 25: shipped_quantity WSH_DELIVERY_DETAILS.shipped_quantity%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,

Line 26: cycle_count_quantity WSH_DELIVERY_DETAILS.cycle_count_quantity%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,

Line 27: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%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,

Line 28: requested_quantity2 WSH_DELIVERY_DETAILS.requested_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,

Line 29: picked_quantity2 WSH_DELIVERY_DETAILS.picked_quantity2%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,

Line 30: shipped_quantity2 WSH_DELIVERY_DETAILS.shipped_quantity2%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,

Line 31: cycle_count_quantity2 WSH_DELIVERY_DETAILS.cycle_count_quantity2%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,

Line 32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%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,

Line 33: organization_id WSH_DELIVERY_DETAILS.organization_id%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,

Line 34: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%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,

Line 35: subinventory WSH_DELIVERY_DETAILS.subinventory%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,

Line 36: lot_number WSH_DELIVERY_DETAILS.lot_number%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,

Line 37: sublot_number WSH_DELIVERY_DETAILS.sublot_number%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,

Line 38: locator_id WSH_DELIVERY_DETAILS.locator_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,
42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%TYPE,

Line 39: source_line_id WSH_DELIVERY_DETAILS.source_line_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,
43: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

Line 40: net_weight WSH_DELIVERY_DETAILS.net_weight%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,

Line 41: cancelled_quantity WSH_DELIVERY_DETAILS.cancelled_quantity%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,

Line 42: cancelled_quantity2 WSH_DELIVERY_DETAILS.cancelled_quantity2%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,

Line 43: serial_number WSH_DELIVERY_DETAILS.serial_number%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,

Line 44: to_serial_number WSH_DELIVERY_DETAILS.to_serial_number%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,

Line 45: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_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

Line 46: container_flag WSH_DELIVERY_DETAILS.container_flag%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: );

Line 47: released_status WSH_DELIVERY_DETAILS.released_status%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: );
51: PROCEDURE GMI_CREATE_BACKORDER_TXN

Line 52: ( p_shipping_line IN wsh_delivery_details%ROWTYPE

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: );

Line 59: ( p_shipping_line IN wsh_delivery_details%ROWTYPE

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

Line 106: ( p_shipping_line IN wsh_delivery_details%ROWTYPE

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