1 PACKAGE CLN_PO_CHG_ORDER_STATUS AUTHID CURRENT_USER AS
2 /* $Header: CLNPOSSS.pls 115.0 2003/12/10 09:39:38 kkram noship $ */
3 -- Package
4 -- CLN_PO_CHG_ORDER_STATUS
5 --
6 -- Purpose
7 -- Specification of package specification: CLN_PO_CHG_ORDER_STATUS.
8 -- This package functions facilitate in updating the Purchase order
9 --
10 -- History
11 -- Aug-06-2002 Viswanthan Umapathy Created
12
13 -- Need to keep track of the line numbers
14 G_PO_LINE_NUMBER NUMBER;
15
16 -- Name
17 -- PROCESS_ORDER_HEADER
18 -- Purpose
19 -- Processes the order header details by creating and updating the collaboration history
20 -- Arguments
21 -- PO and SO details
22 -- Notes
23 -- No specific notes
24
25 PROCEDURE PROCESS_ORDER_HEADER(
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_app_ref_id IN VARCHAR2,
29 p_po_id IN VARCHAR2,
30 p_po_rel_num IN NUMBER,
31 p_po_rev_num IN NUMBER,
32 p_so_id IN VARCHAR2,
33 p_so_status IN VARCHAR2,
34 p_tp_id IN VARCHAR2,
35 p_int_ctl_num IN VARCHAR2);
36
37
38
39 -- Name
40 -- PROCESS_ORDER_LINE
41 -- Purpose
42 -- Processes the order line header details by updating the PO thru
43 -- 'Change PO' APIs and collaboration history. Line price gets modified
44 -- Arguments
45 -- PO and SO Line details
46 -- Notes
47 -- x_order_line_closed will be 'YES' if the SO Line Status is
48 -- equivalent to any of the one defined in the lookup
49 -- CLN_ORDER_LINE_CLOSE_STATUS
50
51 PROCEDURE PROCESS_ORDER_LINE(
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 x_order_line_closed OUT NOCOPY VARCHAR2,
55 p_po_id IN VARCHAR2,
56 p_po_rel_num IN NUMBER,
57 p_po_rev_num IN NUMBER,
58 p_po_line_num IN NUMBER,
59 p_so_price IN NUMBER,
60 p_price_currency IN VARCHAR2,
61 p_price_uom IN VARCHAR2,
62 p_supplier_part_num IN VARCHAR2,
63 p_so_id IN VARCHAR2,
64 p_so_line_num IN NUMBER,
65 p_so_line_status IN VARCHAR2,
66 p_reason IN VARCHAR2,
67 p_app_ref_id IN VARCHAR2,
68 p_tp_id IN VARCHAR2,
69 p_int_ctl_num IN VARCHAR2,
70 -- Supplier Doc and Line Reference added for new Change_PO API to
71 -- support split lines and cancellation at header and schedule level.
72 p_supp_doc_ref IN VARCHAR2 DEFAULT NULL,
73 p_supp_line_ref IN VARCHAR2 DEFAULT NULL);
74
75
76
77
78 -- Name
79 -- PROCESS_ORDER_LINE_SHIPMENT
80 -- Purpose
81 -- Processes the order line shipment by updating the PO thru 'Change PO' APIs
82 -- and collaboration history
83 -- Shipment Quantity and Promised date get modified
84 -- If it is a RELEASE PO, Line price also gets modified
85 -- Arguments
86 -- PO and SO Line details
87 -- Notes
88 -- No Specific Notes
89
90 PROCEDURE PROCESS_ORDER_LINE_SHIPMENT(
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 x_order_line_closed OUT NOCOPY VARCHAR2,
94 p_po_id IN VARCHAR2,
95 p_po_rel_num IN NUMBER,
96 p_po_rev_num IN NUMBER,
97 p_po_line_num IN NUMBER,
98 p_po_ship_num IN NUMBER,
99 p_po_quantity IN NUMBER,
100 p_po_quantity_uom IN VARCHAR2,
101 p_so_price IN NUMBER,
102 p_price_currency IN VARCHAR2,
103 p_price_uom IN VARCHAR2,
104 p_po_promised_date IN DATE,
105 p_supplier_part_num IN VARCHAR2,
106 p_so_id IN VARCHAR2,
107 p_so_line_num IN NUMBER,
108 p_so_line_status IN VARCHAR2,
109 p_reason IN VARCHAR2,
110 p_app_ref_id IN VARCHAR2,
111 p_tp_id IN VARCHAR2,
112 p_int_ctl_num IN VARCHAR2,
113 -- Additional parameters added for new Change_PO API to
114 -- support split lines and cancellation at header and schedule level.
115 p_supp_doc_ref IN VARCHAR2 DEFAULT NULL,
116 p_supp_line_ref IN VARCHAR2 DEFAULT NULL,
117 p_supplier_shipment_ref IN VARCHAR2 DEFAULT NULL,
118 p_parent_shipment_number IN VARCHAR2 DEFAULT NULL);
119
120
121 -- Name
122 -- LOAD_CHANGES
123 -- Purpose
124 -- Call Process Supplier Request of Update_PO API to
125 -- load all changes in to interface tables
126 -- Arguments
127 -- Internal Control Number
128 -- Notes
129 -- No Specific Notes
130
131 PROCEDURE LOAD_CHANGES(
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_app_ref_id IN VARCHAR2,
135 p_po_id IN VARCHAR2,
136 p_so_num IN VARCHAR2,
137 p_int_ctl_num IN VARCHAR2);
138
139 -- Name
140 -- GET_TRADING_PARTNER_DETAILS
141 -- Purpose
142 -- This procedure returns back the trading partner id
143 -- and trading partner site id based the header id
144 -- Arguments
145 -- Header ID
146 -- Notes
147 -- No specific notes.
148
149 PROCEDURE GET_TRADING_PARTNER_DETAILS(
150 x_tp_id OUT NOCOPY NUMBER,
151 x_tp_site_id OUT NOCOPY NUMBER,
152 p_tp_header_id IN NUMBER);
153
154
155
156 -- Name
157 -- RAISE_UPDATE_EVENT
158 -- Purpose
159 -- This procedure raises an event to update a collaboration.
160 --
161 -- Arguments
162 --
163 -- Notes
164 -- No specific notes.
165
166 PROCEDURE RAISE_UPDATE_COLLABORATION(
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_ref_id IN VARCHAR2,
170 p_doc_no IN VARCHAR2,
171 p_part_doc_no IN VARCHAR2,
172 p_msg_text IN VARCHAR2,
173 p_status_code IN NUMBER,
174 p_int_ctl_num IN VARCHAR2);
175
176
177
178 -- Name
179 -- RAISE_ADD_MSG_EVENT
180 -- Purpose
181 -- This procedure raises an event to add messages into collaboration history
182 --
183 -- Arguments
184 --
185 -- Notes
186 -- No specific notes.
187
188 PROCEDURE RAISE_ADD_MESSAGE(
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_ictrl_no IN NUMBER,
192 p_ref1 IN VARCHAR2,
193 p_ref2 IN VARCHAR2,
194 p_ref3 IN VARCHAR2,
195 p_ref4 IN VARCHAR2,
196 p_ref5 IN VARCHAR2,
197 p_dtl_msg IN VARCHAR2);
198
199
200
201
202 -- Name
203 -- CALL_TAKE_ACTIONS
204 -- Purpose
205 -- Invokes Notification Processor TAKE_ACTIONS according to the parameter.
206 -- Arguments
207 -- Status - S/E/U - Sucess, Error, Unexpected Error respectively
208 -- Description - Error message if the status if E/U, else 'SUCCESS'
209 -- Sales Order Status
210 -- Order Line Closed - YES/NO
211 -- Notes
212 -- No specific notes.
213
214 PROCEDURE CALL_TAKE_ACTIONS(
215 p_itemtype IN VARCHAR2,
216 p_itemkey IN VARCHAR2,
217 p_actid IN NUMBER,
218 p_funcmode IN VARCHAR2,
219 x_resultout IN OUT NOCOPY VARCHAR2);
220
221
222 END CLN_PO_CHG_ORDER_STATUS;