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