1 PACKAGE wsh_opsm_asn_be_pkg AUTHID CURRENT_USER AS
2 /* $Header: wshopsmbes.pls 120.2 2011/02/16 18:49:34 skaradib noship $ */
3 PROCEDURE get_asn_data ( p_delivery_id IN NUMBER ,
4 p_delivery_detail_id IN NUMBER ,
5 p_out_delivery OUT NOCOPY wsh_opsm_asn_delivery_tbl ,
6 p_out_container OUT NOCOPY wsh_opsm_asn_containers_tbl ,
7 p_out_items OUT NOCOPY wsh_opsm_asn_items_tbl ,
8 p_out_itemdetails OUT NOCOPY wsh_opsm_asn_itemdetails_tbl ,
9 p_out_itemgenealogy OUT NOCOPY wsh_opsm_asn_itemgenealogy_tbl,
10 x_return_status OUT NOCOPY VARCHAR2 ,
11 x_msg_data OUT NOCOPY VARCHAR2);
12 ---------------------------------------------------------------------------------------
13 --
14 -- Procedure: get_asn_data
15 -- Parameters: p_delivery_id - DELIVERY_ID
16 -- p_out_delivery- It is wsh_opsm_asn_delivery_tbl Type
17 -- p_out_container - It is wsh_opsm_asn_containers_tbl Type
18 -- p_out_items-It is wsh_opsm_asn_items_tbl Type
19 -- p_out_itemdetails - It is wsh_opsm_asn_itemdetails_tbl Type
20 -- p_out_itemgenealogy - It is wsh_opsm_asn_itemgenealogy_tbl Type
21 -- x_return_status-return status of the API
22 -- x_msg_data -return Error Message of the API
23
24 -- Description: This Procedure takes delivery_id has input and
25 -- filters all the non OPSM Integrated data present in
26 -- that delivery id(delivery id consists of both OPSM and Non OPSM Items).
27 -- This Procedure also loads the delivery details, OPSM Integrated Items ,
28 -- its corresponding Items details container, order and genealogy
29 -- information to their respective table type objects and sends them
30 -- out in the form Out parameters.
31 --
32 ---------------------------------------------------------------------------------------
33 PROCEDURE get_asn_data ( p_delivery_id IN NUMBER ,
34 p_out_delivery OUT NOCOPY wsh_opsm_asn_delivery_tbl ,
35 p_out_container OUT NOCOPY wsh_opsm_asn_containers_tbl ,
36 p_out_items OUT NOCOPY wsh_opsm_asn_items_tbl ,
37 p_out_itemdetails OUT NOCOPY wsh_opsm_asn_itemdetails_tbl ,
38 p_out_itemgenealogy OUT NOCOPY wsh_opsm_asn_itemgenealogy_tbl,
39 x_return_status OUT NOCOPY VARCHAR2 ,
40 x_msg_data OUT NOCOPY VARCHAR2);
41 ---------------------------------------------------------------------------------------
42 -- Procedure: submit_request
43 -- Parameters: p_delivery_id - DELIVERY_ID
44 -- p_opsmexist- It returns 'Y' or 'N'
45 -- x_return_status-return status of the API
46 -- x_msg_data -return Error Message of the API
47 --
48 -- Description: This Function Returns 'Y' or 'N'after checking
49 -- the condition that the Input delivery id has at least one OPSM
50 -- enabled item or not.
51 ---------------------------------------------------------------------------------------
52 PROCEDURE submit_request( p_delivery_id IN VARCHAR2 ,
53 p_opsmexist OUT NOCOPY VARCHAR2 ,
54 x_return_status OUT NOCOPY VARCHAR2 ,
55 x_msg_data OUT NOCOPY VARCHAR2);
56
57 G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_OPSM_ASN_BE_PKG';
58 END wsh_opsm_asn_be_pkg;