eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_INV dependencies on WSH_DELIVERY_DETAILS

Line 1: PACKAGE WSH_DELIVERY_DETAILS_INV as

1: PACKAGE WSH_DELIVERY_DETAILS_INV as
2: /* $Header: WSHDDICS.pls 120.4 2008/01/14 14:49:13 skanduku ship $ */
3:
4: /*
5: -----------------------------------------------------------------------------

Line 15: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,

11: */
12:
13:
14: TYPE line_inv_info IS RECORD (
15: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
16: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
17: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
19: ser_qty NUMBER,

Line 16: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,

12:
13:
14: TYPE line_inv_info IS RECORD (
15: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
16: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
17: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
19: ser_qty NUMBER,
20: revision WSH_DELIVERY_DETAILS.revision%TYPE,

Line 17: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,

13:
14: TYPE line_inv_info IS RECORD (
15: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
16: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
17: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
19: ser_qty NUMBER,
20: revision WSH_DELIVERY_DETAILS.revision%TYPE,
21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,

Line 18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,

14: TYPE line_inv_info IS RECORD (
15: delivery_detail_id WSH_DELIVERY_DETAILS.delivery_detail_id%TYPE,
16: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
17: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
19: ser_qty NUMBER,
20: revision WSH_DELIVERY_DETAILS.revision%TYPE,
21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
22: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,

Line 20: revision WSH_DELIVERY_DETAILS.revision%TYPE,

16: inventory_item_id WSH_DELIVERY_DETAILS.inventory_item_id%TYPE,
17: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
19: ser_qty NUMBER,
20: revision WSH_DELIVERY_DETAILS.revision%TYPE,
21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
22: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
23: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
24: locator_control_code NUMBER,

Line 21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,

17: shp_qty WSH_DELIVERY_DETAILS.shipped_quantity%TYPE,
18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
19: ser_qty NUMBER,
20: revision WSH_DELIVERY_DETAILS.revision%TYPE,
21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
22: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
23: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
24: locator_control_code NUMBER,
25: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

Line 22: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,

18: req_qty WSH_DELIVERY_DETAILS.requested_quantity%TYPE,
19: ser_qty NUMBER,
20: revision WSH_DELIVERY_DETAILS.revision%TYPE,
21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
22: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
23: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
24: locator_control_code NUMBER,
25: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
26: serial_number_control_code NUMBER,

Line 23: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,

19: ser_qty NUMBER,
20: revision WSH_DELIVERY_DETAILS.revision%TYPE,
21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
22: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
23: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
24: locator_control_code NUMBER,
25: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
26: serial_number_control_code NUMBER,
27: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

Line 25: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,

21: subinventory WSH_DELIVERY_DETAILS.subinventory%TYPE,
22: lot_number WSH_DELIVERY_DETAILS.lot_number%TYPE,
23: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
24: locator_control_code NUMBER,
25: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
26: serial_number_control_code NUMBER,
27: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
28: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
29: picked_quantity NUMBER,

Line 27: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,

23: locator_id WSH_DELIVERY_DETAILS.locator_id%TYPE,
24: locator_control_code NUMBER,
25: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
26: serial_number_control_code NUMBER,
27: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
28: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
29: picked_quantity NUMBER,
30: picked_quantity2 NUMBER,
31: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,

Line 28: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,

24: locator_control_code NUMBER,
25: serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE,
26: serial_number_control_code NUMBER,
27: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
28: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
29: picked_quantity NUMBER,
30: picked_quantity2 NUMBER,
31: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,

Line 31: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,

27: transaction_temp_id WSH_DELIVERY_DETAILS.transaction_temp_id%TYPE,
28: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
29: picked_quantity NUMBER,
30: picked_quantity2 NUMBER,
31: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: source_line_id NUMBER,
34: source_header_id NUMBER,
35: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,

Line 32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,

28: organization_id WSH_DELIVERY_DETAILS.organization_id%TYPE,
29: picked_quantity NUMBER,
30: picked_quantity2 NUMBER,
31: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: source_line_id NUMBER,
34: source_header_id NUMBER,
35: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
36: line_direction WSH_DELIVERY_DETAILS.source_code%TYPE);

Line 35: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,

31: requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE,
32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: source_line_id NUMBER,
34: source_header_id NUMBER,
35: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
36: line_direction WSH_DELIVERY_DETAILS.source_code%TYPE);
37:
38:
39: TYPE inv_control_flag_rec IS RECORD (

Line 36: line_direction WSH_DELIVERY_DETAILS.source_code%TYPE);

32: requested_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE,
33: source_line_id NUMBER,
34: source_header_id NUMBER,
35: source_code WSH_DELIVERY_DETAILS.source_code%TYPE,
36: line_direction WSH_DELIVERY_DETAILS.source_code%TYPE);
37:
38:
39: TYPE inv_control_flag_rec IS RECORD (
40: rev_flag VARCHAR2(3),

Line 95: WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec type containing

91: p_organization_id - organization_id to which inventory_item
92: belongs.
93: p_subinventory - subinventory to which the item belongs
94: x_inv_controls_rec - output record of
95: WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec type containing
96: all inv control flags for the item and organization.
97: x_return_status - return status of the API.
98: DESCRIPTION : This procedure takes a delivery detail id or alternatively the
99: inventory item id and organization id and determines whether

Line 115: x_inv_controls_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec,

111: p_delivery_detail_id IN NUMBER DEFAULT NULL,
112: p_inventory_item_id IN NUMBER,
113: p_organization_id IN NUMBER,
114: p_subinventory IN VARCHAR2,
115: x_inv_controls_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec,
116: x_return_status OUT NOCOPY VARCHAR2);
117:
118:
119: /*

Line 122: PARAMETERS : p_line_inv_rec - WSH_DELIVERY_DETAILS_INV.line_inv_info type

118:
119: /*
120: -----------------------------------------------------------------------------
121: PROCEDURE : Details_Required
122: PARAMETERS : p_line_inv_rec - WSH_DELIVERY_DETAILS_INV.line_inv_info type
123: that contains information about all the inventory control
124: values on the form for the delivery detail id.
125: p_set_default - boolean variable that indicates whether
126: to retrieve the default values for controls if the

Line 128: x_line_inv_rec - WSH_DELIVERY_DETAILS_INV.line_inv_info type

124: values on the form for the delivery detail id.
125: p_set_default - boolean variable that indicates whether
126: to retrieve the default values for controls if the
127: attributes are missing.
128: x_line_inv_rec - WSH_DELIVERY_DETAILS_INV.line_inv_info type
129: containing default values in the case where set_default is TRUE
130: DESCRIPTION : This procedure takes a WSH_DELIVERY_DETAILS_INV.line_inv_info
131: type with inventory control attributes for the delivery detail
132: id from the form and determines whether additional inventory

Line 130: DESCRIPTION : This procedure takes a WSH_DELIVERY_DETAILS_INV.line_inv_info

126: to retrieve the default values for controls if the
127: attributes are missing.
128: x_line_inv_rec - WSH_DELIVERY_DETAILS_INV.line_inv_info type
129: containing default values in the case where set_default is TRUE
130: DESCRIPTION : This procedure takes a WSH_DELIVERY_DETAILS_INV.line_inv_info
131: type with inventory control attributes for the delivery detail
132: id from the form and determines whether additional inventory
133: control information needs to be entered or not. If additional
134: control information is needed then the functions returns a

Line 145: p_line_inv_rec IN WSH_DELIVERY_DETAILS_INV.line_inv_info,

141: */
142:
143:
144: PROCEDURE Details_Required (
145: p_line_inv_rec IN WSH_DELIVERY_DETAILS_INV.line_inv_info,
146: p_set_default IN BOOLEAN DEFAULT FALSE,
147: x_line_inv_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.line_inv_info,
148: x_details_required OUT NOCOPY BOOLEAN,
149: x_return_status OUT NOCOPY VARCHAR2);

Line 147: x_line_inv_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.line_inv_info,

143:
144: PROCEDURE Details_Required (
145: p_line_inv_rec IN WSH_DELIVERY_DETAILS_INV.line_inv_info,
146: p_set_default IN BOOLEAN DEFAULT FALSE,
147: x_line_inv_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.line_inv_info,
148: x_details_required OUT NOCOPY BOOLEAN,
149: x_return_status OUT NOCOPY VARCHAR2);
150:
151:

Line 575: PROCEDURE Check_Default_Catch_Weights(p_line_inv_rec IN WSH_DELIVERY_DETAILS_INV.line_inv_info,

571: p_quantity IN NUMBER,
572: x_prefix OUT NOCOPY VARCHAR2,
573: x_return_status OUT NOCOPY VARCHAR2);
574:
575: PROCEDURE Check_Default_Catch_Weights(p_line_inv_rec IN WSH_DELIVERY_DETAILS_INV.line_inv_info,
576: x_return_status OUT NOCOPY VARCHAR2);
577:
578: -- HW OPMCONV - New procedure to get item information
579: /*

Line 597: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec

593: */
594: PROCEDURE Get_item_information (
595: p_organization_id IN NUMBER
596: , p_inventory_item_id IN NUMBER
597: , x_mtl_system_items_rec OUT NOCOPY WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec
598: , x_return_status OUT NOCOPY VARCHAR2
599: );
600:
601:

Line 645: END WSH_DELIVERY_DETAILS_INV;

641: p_source_code IN VARCHAR2,
642: x_transaction_type_id OUT NOCOPY NUMBER,
643: x_return_status OUT NOCOPY VARCHAR2 );
644:
645: END WSH_DELIVERY_DETAILS_INV;