1 PACKAGE CST_SLA_UPDATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSTPUPGS.pls 120.2.12010000.2 2009/07/23 12:34:00 smsasidh ship $ */
3
4 ------------------------------------------------------------------------------------
5 -- API name : CST_Upgrade_Wrapper
6 -- Type : Public
7 -- Function : Wrapper to support XLA Concurrent mode Upgrade
8 --
9 -- Pre-reqs :
10 -- Parameters :
11 -- IN : X_batch_size in number default 10000,
12 -- X_Num_Workers in number default 16,
13 -- X_Num_Workers in number default 16,
14 -- X_ledger_id in number default null,
15 -- X_Application_Id in number default null
16 --
17 -- OUT : X_errbuf out NOCOPY varchar2,
18 -- X_retcode out NOCOPY varchar2
19 --
20 -- Version : Initial version 1.0
21 -- Notes : Wrapper to support XLA Concurrent mode Upgrade
22 --
23 -- End of comments
24 -------------------------------------------------------------------------------------
25
26 PROCEDURE CST_Upgrade_Wrapper (
27 X_errbuf out NOCOPY varchar2,
28 X_retcode out NOCOPY varchar2,
29 X_batch_size in number default 10000,
30 X_Num_Workers in number default 16,
31 X_Ledger_Id in number default null,
32 X_Application_Id in number default null);
33
34 -------------------------------------------------------------------------------------
35 -- API name : Update_Proc_MGR
36 -- Type : Public
37 -- Function : Manager process to launch three managers that "Upgrade Inventory Sub
38 -- Ledger to SLA data model", "Upgrade WIP Sub Ledger to SLA data
39 -- model", and "Upgrade Receiving Sub Ledger to SLA data model"
40 -- Pre-reqs :
41 -- Parameters :
42 -- IN : X_api_version IN NUMBER,
43 -- X_init_msg_list IN VARCHAR2,
44 -- X_batch_size in number default 10000,
45 -- X_Num_Workers in number default 16,
46 -- X_Argument4 in varchar2 default null,
47 -- X_Argument5 in varchar2 default null,
48 -- X_Argument6 in varchar2 default null,
49 -- X_Argument7 in varchar2 default null,
50 -- X_Argument8 in varchar2 default null,
51 -- X_Argument9 in varchar2 default null,
52 -- X_Argument10 in varchar2 default null
53 --
54 -- OUT : X_errbuf out NOCOPY varchar2,
55 -- X_retcode out NOCOPY varchar2
56 -- Version : Initial version 1.0
57 -- Notes : The API is used for defining the "Upgrade Costing Subledgers to SLA"
58 -- manager Concurrent Executable and Concurrent Program.
59 --
60 -- End of comments
61 -------------------------------------------------------------------------------------
62 PROCEDURE Update_Proc_MGR (
63 X_errbuf out NOCOPY varchar2,
64 X_retcode out NOCOPY varchar2,
65 X_api_version IN NUMBER DEFAULT 1.0,
66 X_init_msg_list IN VARCHAR2 DEFAULT 'T',
67 X_batch_size in number default 10000,
68 X_Num_Workers in number default 16,
69 X_Argument4 in varchar2 default null,
70 X_Argument5 in varchar2 default null,
71 X_Argument6 in varchar2 default null,
72 X_Argument7 in varchar2 default null,
73 X_Argument8 in varchar2 default null,
74 X_Argument9 in varchar2 default null,
75 X_Argument10 in varchar2 default null);
76
77 -------------------------------------------------------------------------------------
78 -- API name : Update_Proc_INV_MGR
79 -- Type : Public
80 -- Function : Manager process to update Inventory Sub Ledger to SLA data model
81 -- Pre-reqs :
82 -- Parameters :
83 -- IN : X_api_version IN NUMBER,
84 -- X_init_msg_list IN VARCHAR2,
85 -- X_batch_size in number default 10000,
86 -- X_Num_Workers in number default 16,
87 -- X_Argument4 in varchar2 default null,
88 -- X_Argument5 in varchar2 default null,
89 -- X_Argument6 in varchar2 default null,
90 -- X_Argument7 in varchar2 default null,
91 -- X_Argument8 in varchar2 default null,
92 -- X_Argument9 in varchar2 default null,
93 -- X_Argument10 in varchar2 default null
94 --
95 -- OUT : X_errbuf out NOCOPY varchar2,
96 -- X_retcode out NOCOPY varchar2
97 -- Version : Initial version 1.0
98 -- Notes : The API is used for defining the "Upgrade Inventory Sub Ledger to SLA"
99 -- manager Concurrent Executable and Concurrent Program.
100 --
101 -- End of comments
102 -------------------------------------------------------------------------------------
103 PROCEDURE Update_Proc_INV_MGR (
104 X_errbuf out NOCOPY varchar2,
105 X_retcode out NOCOPY varchar2,
106 X_api_version IN NUMBER,
107 X_init_msg_list IN VARCHAR2,
108 X_batch_size in number default 10000,
109 X_Num_Workers in number default 16,
110 X_Ledger_Id in varchar2 default null,
111 X_Argument5 in varchar2 default null,
112 X_Argument6 in varchar2 default null,
113 X_Argument7 in varchar2 default null,
114 X_Argument8 in varchar2 default null,
115 X_Argument9 in varchar2 default null,
116 X_Argument10 in varchar2 default null);
117
118 -------------------------------------------------------------------------------------
119 -- API name : Update_Proc_WIP_MGR
120 -- Type : Public
121 -- Function : Manager process to update WIP Sub Ledger to SLA data model
122 -- Pre-reqs :
123 -- Parameters :
124 -- IN : X_api_version IN NUMBER,
125 -- X_init_msg_list IN VARCHAR2,
126 -- X_batch_size in number default 10000,
127 -- X_Num_Workers in number default 16,
128 -- X_Argument4 in varchar2 default null,
129 -- X_Argument5 in varchar2 default null,
130 -- X_Argument6 in varchar2 default null,
131 -- X_Argument7 in varchar2 default null,
132 -- X_Argument8 in varchar2 default null,
133 -- X_Argument9 in varchar2 default null,
134 -- X_Argument10 in varchar2 default null
135 --
136 -- OUT : X_errbuf out NOCOPY varchar2,
137 -- X_retcode out NOCOPY varchar2
138 -- Version : Initial version 1.0
139 -- Notes : The API is used for defining the "Upgrade WIP Sub Ledger to SLA"
140 -- manager Concurrent Executable and Concurrent Program.
141 --
142 -- End of comments
143 -------------------------------------------------------------------------------------
144 PROCEDURE Update_Proc_WIP_MGR (
145 X_errbuf out NOCOPY varchar2,
146 X_retcode out NOCOPY varchar2,
147 X_api_version IN NUMBER,
148 X_init_msg_list IN VARCHAR2,
149 X_batch_size in number default 10000,
150 X_Num_Workers in number default 16,
151 X_Ledger_Id in varchar2 default null,
152 X_Argument5 in varchar2 default null,
153 X_Argument6 in varchar2 default null,
154 X_Argument7 in varchar2 default null,
155 X_Argument8 in varchar2 default null,
156 X_Argument9 in varchar2 default null,
157 X_Argument10 in varchar2 default null);
158
159 -------------------------------------------------------------------------------------
160 -- API name : Update_Proc_RCV_MGR
161 -- Type : Public
162 -- Function : Manager process to update Receiving Sub Ledger to SLA data model
163 -- Pre-reqs :
164 -- Parameters :
165 -- IN : X_api_version IN NUMBER,
166 -- X_init_msg_list IN VARCHAR2,
167 -- X_batch_size in number default 10000,
168 -- X_Num_Workers in number default 16,
169 -- X_Argument4 in varchar2 default null,
170 -- X_Argument5 in varchar2 default null,
171 -- X_Argument6 in varchar2 default null,
172 -- X_Argument7 in varchar2 default null,
173 -- X_Argument8 in varchar2 default null,
174 -- X_Argument9 in varchar2 default null,
175 -- X_Argument10 in varchar2 default null
176 --
177 -- OUT : X_errbuf out NOCOPY varchar2,
178 -- X_retcode out NOCOPY varchar2
179 -- Version : Initial version 1.0
180 -- Notes : The API is used for defining the "Upgrade Receiving Sub Ledger to SLA"
181 -- manager Concurrent Executable and Concurrent Program.
182 --
183 -- End of comments
184 -------------------------------------------------------------------------------------
185 PROCEDURE Update_Proc_RCV_MGR (
186 X_errbuf out NOCOPY varchar2,
187 X_retcode out NOCOPY varchar2,
188 X_api_version IN NUMBER,
189 X_init_msg_list IN VARCHAR2,
190 X_batch_size in number default 10000,
191 X_Num_Workers in number default 16,
192 X_Ledger_Id in varchar2 default null,
193 X_Argument5 in varchar2 default null,
194 X_Argument6 in varchar2 default null,
195 X_Argument7 in varchar2 default null,
196 X_Argument8 in varchar2 default null,
197 X_Argument9 in varchar2 default null,
198 X_Argument10 in varchar2 default null);
199
200 -------------------------------------------------------------------------------------
201 -- API name : Update_Proc_INV_WKR
202 -- Type : Private
203 -- Function : Worker process to update Inventory Sub Ledger to SLA data model
204 -- Pre-reqs :
205 -- Parameters : X_Argument4 is used to pass minimum ID;
206 -- X_Argument5 is used to pass maximum ID.
207 -- IN : X_batch_size in number,
208 -- X_Worker_Id in number,
209 -- X_Num_Workers in number,
210 -- X_Argument4 in varchar2 default null,
211 -- X_Argument5 in varchar2 default null,
212 -- X_Argument6 in varchar2 default null,
213 -- X_Argument7 in varchar2 default null,
214 -- X_Argument8 in varchar2 default null,
215 -- X_Argument9 in varchar2 default null,
216 -- X_Argument10 in varchar2 default null
217 --
218 -- OUT : X_errbuf out NOCOPY varchar2,
219 -- X_retcode out NOCOPY varchar2
220 -- Version : Initial version 1.0
221 -- Notes : The API is used for defining the "Upgrade Inventory Subledger to SLA"
222 -- worker Concurrent Executable and Concurrent Program. It is called
223 -- from Update_Proc_INV_MGR by submitting multiple requests
224 -- via AD_CONC_UTILS_PKG.submit_subrequests. It is also used by the
225 -- downtime upgrade script cstmtaupg.sql.
226 --
227 -- End of comments
228 -------------------------------------------------------------------------------------
229 PROCEDURE Update_Proc_INV_WKR (
230 X_errbuf out NOCOPY varchar2,
231 X_retcode out NOCOPY varchar2,
232 X_batch_size in number,
233 X_Worker_Id in number,
234 X_Num_Workers in number,
235 X_Argument4 in varchar2 default null,
236 X_Argument5 in varchar2 default null,
237 X_Argument6 in varchar2 default null,
238 X_Argument7 in varchar2 default null,
239 X_Argument8 in varchar2 default null,
240 X_Argument9 in varchar2 default null,
241 X_Argument10 in varchar2 default null);
242
243 -------------------------------------------------------------------------------------
244 -- API name : Update_Proc_WIP_WKR
245 -- Type : Private
246 -- Function : Worker process to update WIP Sub Ledger to SLA data model
247 -- Pre-reqs :
248 -- Parameters : X_Argument4 is used to pass minimum ID;
249 -- X_Argument5 is used to pass maximum ID.
250 -- IN : X_batch_size in number,
251 -- X_Worker_Id in number,
252 -- X_Num_Workers in number,
253 -- X_Argument4 in varchar2 default null,
254 -- X_Argument5 in varchar2 default null,
255 -- X_Argument6 in varchar2 default null,
256 -- X_Argument7 in varchar2 default null,
257 -- X_Argument8 in varchar2 default null,
258 -- X_Argument9 in varchar2 default null,
259 -- X_Argument10 in varchar2 default null
260 --
261 -- OUT : X_errbuf out NOCOPY varchar2,
262 -- X_retcode out NOCOPY varchar2
263 -- Version : Initial version 1.0
264 -- Notes : The API is used for defining the "Upgrade WIP Subledger to SLA"
265 -- worker Concurrent Executable and Concurrent Program. It is called
266 -- from Update_Proc_WIP_MGR by submitting multiple requests
267 -- via AD_CONC_UTILS_PKG.submit_subrequests. It is also used by the
268 -- downtime upgrade script cstwtaupg.sql.
269 --
270 -- End of comments
271 -------------------------------------------------------------------------------------
272 PROCEDURE Update_Proc_WIP_WKR (
273 X_errbuf out NOCOPY varchar2,
274 X_retcode out NOCOPY varchar2,
275 X_batch_size in number,
276 X_Worker_Id in number,
277 X_Num_Workers in number,
278 X_Argument4 in varchar2 default null,
279 X_Argument5 in varchar2 default null,
280 X_Argument6 in varchar2 default null,
281 X_Argument7 in varchar2 default null,
282 X_Argument8 in varchar2 default null,
283 X_Argument9 in varchar2 default null,
284 X_Argument10 in varchar2 default null);
285
286 -------------------------------------------------------------------------------------
287 -- API name : Update_Proc_RCV_WKR
288 -- Type : Private
289 -- Function : Worker process to update RCV Sub Ledger to SLA data model
290 -- Pre-reqs :
291 -- Parameters : X_Argument4 is used to pass minimum ID;
292 -- X_Argument5 is used to pass maximum ID.
293 -- IN : X_batch_size in number,
294 -- X_Worker_Id in number,
295 -- X_Num_Workers in number,
296 -- X_Argument4 in varchar2 default null,
297 -- X_Argument5 in varchar2 default null,
298 -- X_Argument6 in varchar2 default null,
299 -- X_Argument7 in varchar2 default null,
300 -- X_Argument8 in varchar2 default null,
301 -- X_Argument9 in varchar2 default null,
302 -- X_Argument10 in varchar2 default null
303 --
304 -- OUT : X_errbuf out NOCOPY varchar2,
305 -- X_retcode out NOCOPY varchar2
306 -- Version : Initial version 1.0
307 -- Notes : The API is used for defining the "Upgrade Receiving Subledger to SLA"
308 -- worker Concurrent Executable and Concurrent Program. It is called
309 -- from Update_Proc_RCV_MGR by submitting multiple requests
310 -- via AD_CONC_UTILS_PKG.submit_subrequests. It is also used by the
311 -- downtime upgrade script cstrrsupg.sql.
312 --
313 -- End of comments
314 -------------------------------------------------------------------------------------
315 PROCEDURE Update_Proc_RCV_WKR (
316 X_errbuf out NOCOPY varchar2,
317 X_retcode out NOCOPY varchar2,
318 X_batch_size in number,
319 X_Worker_Id in number,
320 X_Num_Workers in number,
321 X_Argument4 in varchar2 default null,
322 X_Argument5 in varchar2 default null,
323 X_Argument6 in varchar2 default null,
324 X_Argument7 in varchar2 default null,
325 X_Argument8 in varchar2 default null,
326 X_Argument9 in varchar2 default null,
327 X_Argument10 in varchar2 default null);
328
329 -------------------------------------------------------------------------------------
330 -- API name : Update_Inventory_Subledger
331 -- Type : Private
332 -- Function : To update Inventory Sub Ledger to SLA data model from minimum
333 -- transaction ID to maximum transaction ID.
334 -- Pre-reqs :
335 -- Parameters :
336 -- IN : X_min_id in number,
337 -- X_max_id in number
338 --
339 -- OUT : X_errbuf out NOCOPY varchar2,
340 -- X_retcode out NOCOPY varchar2
341 --
342 -- Notes : The API is called from Update_Proc_INV_WKR.
343 --
344 --
345 -- End of comments
346 -------------------------------------------------------------------------------------
347 PROCEDURE Update_Inventory_Subledger (
348 X_errbuf out NOCOPY varchar2,
349 X_retcode out NOCOPY varchar2,
350 X_min_id in number,
351 X_max_id in number);
352
353 -------------------------------------------------------------------------------------
354 -- API name : Update_WIP_Subledger
355 -- Type : Private
356 -- Function : To update WIP Sub Ledger to SLA data model from minimum
357 -- transaction ID to maximum transaction ID.
358 -- Pre-reqs :
359 -- Parameters :
360 -- IN : X_min_id in number,
361 -- X_max_id in number
362 --
363 -- OUT : X_errbuf out NOCOPY varchar2,
364 -- X_retcode out NOCOPY varchar2
365 --
366 -- Notes : The API is called from Update_Proc_WIP_WKR.
367 --
368 -- End of comments
369 -------------------------------------------------------------------------------------
370 PROCEDURE Update_WIP_Subledger (
371 X_errbuf out NOCOPY varchar2,
372 X_retcode out NOCOPY varchar2,
373 X_min_id in number,
374 X_max_id in number);
375
376 -------------------------------------------------------------------------------------
377 -- API name : Update_RCV_Subledger
378 -- Type : Private
379 -- Function : To update Receiving Sub Ledger to SLA data model from minimum
380 -- transaction ID to maximum transaction ID.
381 -- Pre-reqs :
382 -- Parameters :
383 -- IN : X_min_id in number,
384 -- X_max_id in number
385 --
386 -- OUT : X_errbuf out NOCOPY varchar2,
387 -- X_retcode out NOCOPY varchar2
388 --
392 -------------------------------------------------------------------------------------
389 -- Notes : The API is called from Update_Proc_RCV_WKR.
390 --
391 -- End of comments
393 PROCEDURE Update_Receiving_Subledger (
394 X_errbuf out NOCOPY varchar2,
395 X_retcode out NOCOPY varchar2,
396 X_min_id in number,
397 X_max_id in number);
398
399
400 END;