1 PACKAGE WMS_SHIPPING_LOVS AUTHID CURRENT_USER AS
2 /* $Header: WMSSHPLS.pls 120.0.12010000.2 2009/07/31 12:52:31 pbonthu ship $ */
3 --
4 TYPE t_genref IS REF CURSOR;
5
6 -- Start of comments
7 -- API name: Get_LPN_Order_LOV
8 -- Type : Private
9 -- Pre-reqs: None.
10 -- Function: Returns a list of sales order associated to
11 -- a given LPN. The LPN is identified by it's
12 -- delivery_detail_id in WSH_DELIVERY_DETAILS
13 -- Parameters:
14 -- IN: p_organization_id IN NUMBER Required
15 -- Organization ID of the salse order line and LPN
16 -- p_parent_delivery_detail_id IN NUMBER Required
17 -- Delivery detail ID of the LPN which contains
18 -- the sales orders
19 -- p_order IN VARCHAR2 Required
20 -- Partial string value to limit search results
21 -- OUT: x_order_lov OUT NOCOPY T_GENREF
22 -- Standard LOV out parameter
23 -- Version : Current version 1.0
24 -- End of comments
25
26 PROCEDURE Get_LPN_Order_LOV(
27 x_order_lov OUT NOCOPY t_genref
28 , p_organization_id IN NUMBER
29 , p_parent_delivery_detail_id IN NUMBER
30 , p_order IN VARCHAR2);
31
32 -- Start of comments
33 -- API name: Get_LPN_Orderline_LOV
34 -- Type : Private
35 -- Pre-reqs: None.
36 -- Function: Returns a list of sales order associated to
37 -- a given LPN. The LPN is identified by it's
38 -- delivery_detail_id in WSH_DELIVERY_DETAILS
39 -- Parameters:
40 -- IN: p_organization_id IN NUMBER Required
41 -- Organization ID of the salse order line and LPN
42 -- p_source_header_id IN NUMBER Required
43 -- Header ID of the sales order that the salse order
44 -- p_parent_delivery_detail_id IN NUMBER Required
45 -- Delivery detail ID of the LPN which contains
46 -- the sales orderline
47 -- p_order_line IN VARCHAR2 Required
48 -- Partial string value to limit search results
49 -- OUT: x_order_lov OUT NOCOPY T_GENREF
50 -- Standard LOV out parameter
51 -- Version : Current version 1.0
52 -- End of comments
53
54 PROCEDURE Get_LPN_Orderline_LOV(
55 x_orderline_lov OUT NOCOPY T_GENREF
56 , p_organization_id IN NUMBER
57 , p_source_header_id IN NUMBER
58 , p_parent_delivery_detail_id IN NUMBER
59 , p_order_line IN VARCHAR2);
60
61
62 --Added for Case Picking Project start
63
64 PROCEDURE Get_Manifest_Pickslip_LOV( x_pickslip_lov OUT NOCOPY T_GENREF ,
65 p_organization_id IN NUMBER ,
66 p_pick_slip_number IN VARCHAR2 ,
67 p_equipment_id IN NUMBER := NULL,
68 p_sign_on_emp_id IN NUMBER,
69 p_zone IN VARCHAR2 := NULL );
70
71 PROCEDURE Get_Manifest_Order_LOV( x_orderline_lov OUT NOCOPY T_GENREF ,
72 p_organization_id IN NUMBER ,
73 p_order_number IN VARCHAR2,
74 p_equipment_id IN NUMBER := NULL,
75 p_sign_on_emp_id IN NUMBER,
76 p_zone IN VARCHAR2 := NULL );
77
78 --Added for Case Picking Project end
79
80 END WMS_SHIPPING_LOVS;