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