1 PACKAGE CST_PendingTxnsReport_PVT AS
2 /* $Header: CSTVPTRS.pls 120.1.12010000.2 2008/11/10 14:34:15 mpuranik ship $ */
3
4 -- Start of comments
5 -- API name : generateXML
6 -- Type : Private
7 -- Function : Generate XML data for Period Close Pending transactions
8 -- Report.
9 -- Pre-reqs : None
10 -- Parameters :
11 -- IN : p_org_id IN NUMBER Required
12 -- p_period_id IN NUMBER Required
13 -- p_resolution_type IN NUMBER Required
14 -- p_transaction_type IN NUMBER Required
15 --
16 -- OUT : errcode OUT NOCOPY VARCHAR2
17 -- errno OUT NOCOPY NUMBER
18 --
19 -- Version : Current version 1.0
20 -- Initial Creation
21 --
22 -- Notes : This Procedure is called by the Period Close Pending
23 -- Transactions report. This is the wrapper procedure that
24 -- calls the other procedures to generate XML data
25 -- according to report parameters.
26 -- End of comments
27 PROCEDURE generateXML
28 (errcode OUT NOCOPY VARCHAR2,
29 errno OUT NOCOPY NUMBER,
30 p_org_id IN NUMBER,
31 p_period_id IN NUMBER,
32 p_resolution_type IN NUMBER,
33 p_transaction_type IN NUMBER);
34
35 -- Start of comments
36 -- API name : add_parameters
37 -- Type : Private
38 -- Function : Generate XML data for Parameters and append it to output
39 -- Pre-reqs : None
40 -- Parameters :
41 -- IN : p_api_version NUMBER Required
42 -- p_init_msg_list VARCHAR2 Required
43 -- p_validation_level NUMBER Required
44 -- i_org_id NUMBER Required
45 -- i_period_id NUMBER Required
46 -- i_resolution_type NUMBER Required
47 -- i_transaction_type NUMBER Required
48 -- x_xml_doc CLOB Required
49 --
50 -- OUT : x_return_status VARCHAR2
51 -- x_msg_count NUMBER
52 -- x_xml_doc CLOB
53 -- x_msg_data VARCHAR2
54 --
55 -- Version : Current version 1.0
56 -- Initial Creation
57 --
58 -- Notes : This Procedure is called by generateXML procedure.
59 -- The procedure generates XML data for the report parameters
60 -- and appends it to the report output
61 -- End of comments
62 PROCEDURE add_parameters
63 (p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 p_validation_level IN NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 i_org_id IN NUMBER,
70 i_period_id IN NUMBER,
71 i_resolution_type IN NUMBER,
72 i_transaction_type IN NUMBER,
73 x_xml_doc IN OUT NOCOPY CLOB);
74
75 -- Start of comments
76 -- API name : unprocessed_mtl_trx
77 -- Type : Private
78 -- Function : Generate XML data for unprocessed material transactions
79 -- and append it to report output
80 -- Pre-reqs : None
81 -- Parameters :
82 -- IN : p_api_version NUMBER Required
83 -- p_init_msg_list VARCHAR2 Required
84 -- p_validation_level NUMBER Required
85 -- i_period_end_date DATE Required
86 -- i_org_id NUMBER Required
87 -- x_xml_doc CLOB Required
88 --
89 -- OUT : x_return_status VARCHAR2
90 -- x_msg_count NUMBER
91 -- x_xml_doc CLOB
92 -- x_msg_data VARCHAR2
93 --
94 -- Version : Current version 1.0
95 -- Initial Creation
96 --
97 -- Notes : This Procedure is called by generateXML procedure.
98 -- The procedure generates XML data for unprocessed
99 -- material transactions (MTL_MATERIAL_TRANSACTIONS_TEMP)
100 -- and appends it to the report output
101 -- End of comments
102 PROCEDURE unprocessed_mtl_trx
103 (p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2,
105 p_validation_level IN NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 i_period_end_date IN DATE,
110 i_org_id IN NUMBER,
111 x_record_count OUT NOCOPY NUMBER,
112 x_xml_doc IN OUT NOCOPY CLOB);
113
114 -- Start of comments
115 -- API name : uncosted_mtl_trx
116 -- Type : Private
117 -- Function : Generate XML data for uncosted material transactions
118 -- and append it to report output
119 -- Pre-reqs : None
120 -- Parameters :
121 -- IN : p_api_version NUMBER Required
122 -- p_init_msg_list VARCHAR2 Required
123 -- p_validation_level NUMBER Required
124 -- i_period_end_date DATE Required
125 -- i_org_id NUMBER Required
126 -- x_xml_doc CLOB Required
127 --
128 -- OUT : x_return_status VARCHAR2
129 -- x_msg_count NUMBER
130 -- x_record_count NUMBER
131 -- x_xml_doc CLOB
132 -- x_msg_data VARCHAR2
133 --
134 -- Version : Current version 1.0
135 -- Initial Creation
136 --
137 -- Notes : This Procedure is called by generateXML procedure.
138 -- The procedure generates XML data for uncosted
139 -- material transactions (MTL_MATERIAL_TRANSACTIONS)
140 -- and appends it to the report output
141 -- End of comments
142 PROCEDURE uncosted_mtl_trx
143 (p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2,
145 p_validation_level IN NUMBER,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 i_period_end_date IN DATE,
150 i_org_id IN NUMBER,
151 x_record_count OUT NOCOPY NUMBER,
152 x_xml_doc IN OUT NOCOPY CLOB);
153
154 -- Start of comments
155 -- API name : uncosted_wip_trx
156 -- Type : Private
157 -- Function : Generate XML data for uncosted wip transactions
158 -- and append it to report output
159 -- Pre-reqs : None
160 -- Parameters :
161 -- IN : p_api_version NUMBER Required
162 -- p_init_msg_list VARCHAR2 Required
163 -- p_validation_level NUMBER Required
164 -- i_period_end_date DATE Required
165 -- i_org_id NUMBER Required
166 -- x_xml_doc CLOB Required
167 --
168 -- OUT : x_return_status VARCHAR2
169 -- x_msg_count NUMBER
170 -- x_record_count NUMBER
171 -- x_xml_doc CLOB
172 -- x_msg_data VARCHAR2
173 --
174 -- Version : Current version 1.0
175 -- Initial Creation
176 --
177 -- Notes : This Procedure is called by generateXML procedure.
178 -- The procedure generates XML data for uncosted
179 -- wip transactions (WIP_COST_TXN_INTERFACE)
180 -- and appends it to the report output
181 -- End of comments
182 PROCEDURE uncosted_wip_trx
183 (p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 p_validation_level IN NUMBER,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 i_period_end_date IN DATE,
190 i_org_id IN NUMBER,
191 x_record_count OUT NOCOPY NUMBER,
192 x_xml_doc IN OUT NOCOPY CLOB);
193
194 -- Start of comments
195 -- API name : pending_wsm_trx
196 -- Type : Private
197 -- Function : Generate XML data for pending WSM interface transactions
198 -- and append it to report output
199 -- Pre-reqs : None
200 -- Parameters :
201 -- IN : p_api_version NUMBER Required
202 -- p_init_msg_list VARCHAR2 Required
203 -- p_validation_level NUMBER Required
204 -- i_period_end_date DATE Required
205 -- i_org_id NUMBER Required
206 -- x_xml_doc CLOB Required
207 --
208 -- OUT : x_return_status VARCHAR2
209 -- x_msg_count NUMBER
210 -- x_record_count NUMBER
211 -- x_xml_doc CLOB
212 -- x_msg_data VARCHAR2
213 --
214 -- Version : Current version 1.0
215 -- Initial Creation
216 --
217 -- Notes : This Procedure is called by generateXML procedure.
218 -- The procedure generates XML data for pending WSM
219 -- interface transactions (WSM_SPLIT_MERGE_TXN_INTERFACE,
220 -- WSM_LOT_MOVE_TXN_INTERFACE, WSM_LOT_SPLIT_MERGES_INTERFACE)
221 -- and appends it to the report output
222 -- End of comments
223 PROCEDURE pending_wsm_trx
224 (p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2,
226 p_validation_level IN NUMBER,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 i_period_end_date IN DATE,
231 i_org_id IN NUMBER,
232 x_record_count OUT NOCOPY NUMBER,
233 x_xml_doc IN OUT NOCOPY CLOB);
234
235 -- Start of comments
236 -- API name : pending_mtl_interface_trx
237 -- Type : Private
238 -- Function : Generate XML data for pending material interface transactions
239 -- and append it to report output
240 -- Pre-reqs : None
241 -- Parameters :
242 -- IN : p_api_version NUMBER Required
243 -- p_init_msg_list VARCHAR2 Required
244 -- p_validation_level NUMBER Required
245 -- i_period_end_date DATE Required
246 -- i_org_id NUMBER Required
247 -- x_xml_doc CLOB Required
248 --
249 -- OUT : x_return_status VARCHAR2
250 -- x_msg_count NUMBER
251 -- x_record_count NUMBER
252 -- x_xml_doc CLOB
253 -- x_msg_data VARCHAR2
254 --
255 -- Version : Current version 1.0
256 -- Initial Creation
257 --
258 -- Notes : This Procedure is called by generateXML procedure.
259 -- The procedure generates XML data for pending material
260 -- interface transactions (MTL_TRANSACTIONS_INTERFACE_V)
261 -- and appends it to the report output
262 -- End of comments
263 PROCEDURE pending_mtl_interface_trx
264 (p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2,
266 p_validation_level IN NUMBER,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 i_period_end_date IN DATE,
271 i_org_id IN NUMBER,
272 x_record_count OUT NOCOPY NUMBER,
273 x_xml_doc IN OUT NOCOPY CLOB);
274
275 -- Start of comments
276 -- API name : pending_rcv_trx
277 -- Type : Private
278 -- Function : Generate XML data for pending receiving transactions
279 -- and append it to report output
280 -- Pre-reqs : None
281 -- Parameters :
282 -- IN : p_api_version NUMBER Required
283 -- p_init_msg_list VARCHAR2 Required
284 -- p_validation_level NUMBER Required
285 -- i_period_end_date DATE Required
286 -- i_org_id NUMBER Required
287 -- x_xml_doc CLOB Required
288 --
289 -- OUT : x_return_status VARCHAR2
290 -- x_msg_count NUMBER
291 -- x_record_count NUMBER
292 -- x_xml_doc CLOB
293 -- x_msg_data VARCHAR2
294 --
295 -- Version : Current version 1.0
296 -- Initial Creation
297 --
298 -- Notes : This Procedure is called by generateXML procedure.
299 -- The procedure generates XML data for pending receiving
300 -- transactions (RCV_TRANSACTIONS_INTERFACE)and appends
301 -- it to the report output
302 -- End of comments
303 PROCEDURE pending_rcv_trx
304 (p_api_version IN NUMBER,
305 p_init_msg_list IN VARCHAR2,
306 p_validation_level IN NUMBER,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2,
310 i_period_end_date IN DATE,
311 i_org_id IN NUMBER,
312 x_record_count OUT NOCOPY NUMBER,
313 x_xml_doc IN OUT NOCOPY CLOB);
314
315 -- Start of comments
316 -- API name : pending_wip_move_trx
317 -- Type : Private
318 -- Function : Generate XML data for pending wip move transactions
319 -- and append it to report output
320 -- Pre-reqs : None
321 -- Parameters :
322 -- IN : p_api_version NUMBER Required
323 -- p_init_msg_list VARCHAR2 Required
324 -- p_validation_level NUMBER Required
325 -- i_period_end_date DATE Required
326 -- i_org_id NUMBER Required
327 -- x_xml_doc CLOB Required
328 --
329 -- OUT : x_return_status VARCHAR2
330 -- x_msg_count NUMBER
331 -- x_record_count NUMBER
332 -- x_xml_doc CLOB
333 -- x_msg_data VARCHAR2
334 --
335 -- Version : Current version 1.0
336 -- Initial Creation
337 --
338 -- Notes : This Procedure is called by generateXML procedure.
339 -- The procedure generates XML data for pending wip move
340 -- material (WIP_MOVE_TXN_INTERFACE)and appends it to the
341 -- report output
342 -- End of comments
343 PROCEDURE pending_wip_move_trx
344 (p_api_version IN NUMBER,
345 p_init_msg_list IN VARCHAR2,
346 p_validation_level IN NUMBER,
347 x_return_status OUT NOCOPY VARCHAR2,
348 x_msg_count OUT NOCOPY NUMBER,
349 x_msg_data OUT NOCOPY VARCHAR2,
350 i_period_end_date IN DATE,
351 i_org_id IN NUMBER,
352 x_record_count OUT NOCOPY NUMBER,
353 x_xml_doc IN OUT NOCOPY CLOB);
354
355 -- Start of comments
356 -- API name : pending_shipping_trx
357 -- Type : Private
358 -- Function : Generate XML data for pending shipping transactions
359 -- and append it to report output
360 -- Pre-reqs : None
361 -- Parameters :
362 -- IN : p_api_version NUMBER Required
363 -- p_init_msg_list VARCHAR2 Required
364 -- p_validation_level NUMBER Required
365 -- i_period_start_date DATE Required
366 -- i_period_end_date DATE Required
367 -- i_org_id NUMBER Required
368 -- x_xml_doc CLOB Required
369 --
370 -- OUT : x_return_status VARCHAR2
371 -- x_msg_count NUMBER
372 -- x_record_count NUMBER
373 -- x_xml_doc CLOB
374 -- x_msg_data VARCHAR2
375 --
376 -- Version : Current version 1.0
377 -- Initial Creation
378 --
379 -- Notes : This Procedure is called by generateXML procedure.
380 -- The procedure generates XML data for pending shipping
381 -- transactions (WSH_DELIVERY_DETAILS) and appends it to
382 -- the report output
383 -- End of comments
384 PROCEDURE pending_shipping_trx
385 (p_api_version IN NUMBER,
386 p_init_msg_list IN VARCHAR2,
387 p_validation_level IN NUMBER,
388 x_return_status OUT NOCOPY VARCHAR2,
389 x_msg_count OUT NOCOPY NUMBER,
390 x_msg_data OUT NOCOPY VARCHAR2,
391 i_period_start_date IN DATE,
392 i_period_end_date IN DATE,
393 i_org_id IN NUMBER,
394 x_record_count OUT NOCOPY NUMBER,
395 x_xml_doc IN OUT NOCOPY CLOB);
396
397 -- Start of comments
398 -- API name : incomplete_eam_wo
399 -- Type : Private
400 -- Function : Generate XML data for incomplete eam workorders
401 -- and append it to report output
402 -- Pre-reqs : None
403 -- Parameters :
404 -- IN : p_api_version NUMBER Required
405 -- p_init_msg_list VARCHAR2 Required
406 -- p_validation_level NUMBER Required
407 -- i_period_end_date DATE Required
408 -- i_org_id NUMBER Required
409 -- x_xml_doc CLOB Required
410 --
411 -- OUT : x_return_status VARCHAR2
412 -- x_msg_count NUMBER
413 -- x_record_count NUMBER
414 -- x_xml_doc CLOB
415 -- x_msg_data VARCHAR2
416 --
417 -- Version : Current version 1.0
418 -- Initial Creation
419 --
420 -- Notes : This Procedure is called by generateXML procedure.
421 -- The procedure generates XML data for incomplete eam
422 -- workorders (EAM_WORK_ORDERS_V) and appends it to
423 -- the report output
424 -- End of comments
425 PROCEDURE incomplete_eam_wo
426 (p_api_version IN NUMBER,
427 p_init_msg_list IN VARCHAR2,
428 p_validation_level IN NUMBER,
429 x_return_status OUT NOCOPY VARCHAR2,
430 x_msg_count OUT NOCOPY NUMBER,
431 x_msg_data OUT NOCOPY VARCHAR2,
432 i_period_end_date IN DATE,
433 i_org_id IN NUMBER,
434 x_record_count OUT NOCOPY NUMBER,
435 x_xml_doc IN OUT NOCOPY CLOB);
436
437 -- Start of comments
438 -- API name : pending_lcm_trx
439 -- Type : Private
440 -- Function : Generate XML data for unprocessed lcm transactions
441 -- and append it to report output
442 -- Pre-reqs : None
443 -- Parameters :
444 -- IN : p_api_version NUMBER Required
445 -- p_init_msg_list VARCHAR2 Required
446 -- p_validation_level NUMBER Required
447 -- i_period_end_date DATE Required
448 -- i_org_id NUMBER Required
449 -- x_xml_doc CLOB Required
450 --
451 -- OUT : x_return_status VARCHAR2
452 -- x_msg_count NUMBER
453 -- x_record_count NUMBER
454 -- x_xml_doc CLOB
455 -- x_msg_data VARCHAR2
456 --
457 -- Version : Current version 1.0
458 -- Initial Creation
459 --
460 -- Notes : This Procedure is called by generateXML procedure.
461 -- The procedure generates XML data for unprocessed lcm
462 -- transactions (CST_LC_ADJ_INTERFACE) and appends it to
463 -- the report output
464 -- End of comments
465 PROCEDURE pending_lcm_trx
466 (p_api_version IN NUMBER,
467 p_init_msg_list IN VARCHAR2,
468 p_validation_level IN NUMBER,
469 x_return_status OUT NOCOPY VARCHAR2,
470 x_msg_count OUT NOCOPY NUMBER,
471 x_msg_data OUT NOCOPY VARCHAR2,
472 i_period_end_date IN DATE,
473 i_org_id IN NUMBER,
474 x_record_count OUT NOCOPY NUMBER,
475 x_xml_doc IN OUT NOCOPY CLOB);
476
477 END CST_PendingTxnsReport_PVT;
478