1 PACKAGE WMS_SHIPPING_LOVS AUTHID CURRENT_USER AS
2 /* $Header: WMSSHPLS.pls 115.2 2003/10/30 01:09:53 jsheu noship $ */
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 END WMS_SHIPPING_LOVS;
[Home] [Help]