1 PACKAGE CLN_WSH_SHIP_ORDER_OUT_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLNWSHSS.pls 115.1 2003/11/17 12:12:31 vumapath noship $ */
3 -- Package
4 -- CLN_WSH_SO_PKG
5 --
6 -- Purpose
7 -- Specification of package : CLN_WSH_SO_PKG
8 -- This package bunbles all the procedures
9 -- required for 3B12 Shipping implementation
10 --
11 -- History
12 -- Oct-6-2003 Viswanthan Umapathy Created
13
14
15 -- Name
16 -- CREATE_COLLABORATION
17 -- Purpose
18 -- creates a new collaboration in the collaboration history
19 -- Arguments
20 --
21 -- Notes
22 -- No specific notes
23
24 PROCEDURE CREATE_COLLABORATION(
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 p_delivery_number IN VARCHAR2,
28 p_tp_type IN VARCHAR2,
29 p_tp_id IN VARCHAR2,
30 p_tp_site_id IN VARCHAR2,
31 p_doc_dir IN VARCHAR2,
32 p_txn_type IN VARCHAR2,
33 p_txn_subtype IN VARCHAR2,
34 p_xmlg_doc_id IN VARCHAR2,
35 p_doc_creation_date IN DATE,
36 p_appl_ref_id IN VARCHAR2,
37 p_int_ctl_num IN VARCHAR2);
38
39
40 -- Name
41 -- UPDATE_COLLABORATION
42 -- Purpose
43 -- Updates the collaboration in the collaboration history
44 -- Arguments
45 --
46 -- Notes
47 -- No specific notes
48
49 PROCEDURE UPDATE_COLLABORATION(
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_delivery_number IN VARCHAR2,
53 p_tp_type IN VARCHAR2,
54 p_tp_id IN VARCHAR2,
55 p_tp_site_id IN VARCHAR2,
56 p_doc_dir IN VARCHAR2,
57 p_txn_type IN VARCHAR2,
58 p_txn_subtype IN VARCHAR2,
59 p_xmlg_doc_id IN VARCHAR2,
60 p_appl_ref_id IN VARCHAR2,
61 p_int_ctrl_num IN VARCHAR2);
62
63
64 -- Name
65 -- GET_FROM_ROLE_ORG_ID
66 -- Purpose
67 -- Gets the Organization ID for a given Delivery Document Number
68 -- Arguments
69 -- Delivery Document Number
70 -- Notes
71 -- No specific notes
72
73 FUNCTION GET_FROM_ROLE_ORG_ID
74 (P_DOCUMENT_NUMBER IN NUMBER)
75 RETURN NUMBER;
76
77
78 -- Name
79 -- GET_TO_ROLE_LOCATION_ID
80 -- Purpose
81 -- Gets the toRole Location ID for a given Delivery Document Number
82 -- Arguments
83 -- Delivery Document Number
84 -- Notes
85 -- No specific notes
86
87 FUNCTION GET_TO_ROLE_LOCATION_ID
88 (P_DOCUMENT_NUMBER IN NUMBER)
89 RETURN NUMBER;
90
91
92 -- Name
93 -- GET_DELIVERY_INFORMATION
94 -- Purpose
95 -- Gets the required additional delievry information
96 -- for a Delivery Document Number
97 -- Arguments
98 -- Delivery Document Number
99 -- Notes
100 -- No specific notes
101
102 PROCEDURE GET_DELIVERY_INFORMATION(
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_document_number IN VARCHAR2,
106 x_customer_po_number OUT NOCOPY VARCHAR2,
107 x_customer_id OUT NOCOPY NUMBER,
108 x_delivery_creation_date OUT NOCOPY DATE);
109
110
111 END CLN_WSH_SHIP_ORDER_OUT_PKG;