1 PACKAGE ddr_fact_webservices_pub AUTHID CURRENT_USER AS
2 /* $Header: ddrpfwss.pls 120.1 2008/02/16 03:49:18 vbhave noship $ */
3
4 -- Start of comments
5 -- API name : getSalesReturnItem
6 -- Type: Public
7 -- Pre-reqs: None.
8 -- Function: to get aggregate data from DDR RETAIL SALE RETURN ITEM DAY facts
9 -- Parameters:
10 -- IN:p_api_version IN NUMBERRequired
11 -- p_mfg_org_cd IN VARCHAR2Required
12 -- Manufaturer organization code
13 -- p_org_dim_lvl_cd IN VARCHAR2
14 -- Identifies the organization hierarchy level code
15 -- p_org_lvl_val IN VARCHAR2
16 -- Organization hierarchy level code value
17 -- p_exp_org_level IN VARCHAR2
18 -- expected aggregation level of organization hierarchy
19 -- p_loc_dim_lvl_cd IN VARCHAR2
20 -- Identifies the location hierarchy level code
21 -- p_loc_lvl_val IN VARCHAR2
22 -- Location hierarchy level code
23 -- p_exp_loc_level IN VARCHAR2
24 -- Expected aggregation level of location hierarchy
25 -- p_item_dim_lvl_cd IN VARCHAR2
26 -- p_item_lvl_val IN VARCHAR2
27 -- p_exp_item_level IN VARCHAR2
28 -- p_time_dim_lvl_cd IN VARCHAR2
29 -- p_time_lvl_valIN VARCHAR2
30 -- p_exp_time_level IN VARCHAR2
31 -- p_fact_codeIN VARCHAR2
32 -- p_attribute1 IN VARCHAR2
33 -- p_attribute2 IN VARCHAR2
34 -- p_attribute3 IN VARCHAR2
35 -- p_attribute4 IN VARCHAR2
36 -- p_attribute5 IN VARCHAR2
37 -- x_file_path OUT VARCHAR2
38 -- Version: Current version1.0
39 -- Initial version 1.0
40 -- End of comments
41
42 PROCEDURE getAgrSalesReturnItem(p_api_version IN NUMBER,
43 p_mfg_org_cd IN VARCHAR2,
44 p_org_cd IN VARCHAR2,
45 p_org_dim_lvl_cd IN VARCHAR2,
46 p_org_lvl_val IN VARCHAR2,
47 p_exp_org_level IN VARCHAR2,
48 p_loc_dim_lvl_cd IN VARCHAR2,
49 p_loc_lvl_val IN VARCHAR2,
50 p_exp_loc_level IN VARCHAR2,
51 p_item_dim_lvl_cd IN VARCHAR2,
52 p_item_lvl_val IN VARCHAR2,
53 p_exp_item_level IN VARCHAR2,
54 p_time_dim_lvl_cd IN VARCHAR2,
55 p_time_lvl_val IN VARCHAR2,
56 p_exp_time_level IN VARCHAR2,
57 p_attribute1 IN VARCHAR2,
58 p_attribute2 IN VARCHAR2,
59 p_attribute3 IN VARCHAR2,
60 p_attribute4 IN VARCHAR2,
61 p_attribute5 IN VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 x_job_id OUT NOCOPY VARCHAR2);
66
67 -- Start of comments
68 -- API name : getAgrMrktItemSales
69 -- Type: Public
70 -- Pre-reqs: None.
71 -- Function: to get aggregate data from DDR MARKET ITEM SALES DAY facts
72 -- Parameters:
73 -- IN:p_api_version IN NUMBERRequired
74 -- p_mfg_org_cd IN VARCHAR2Required
75 -- Manufaturer organization code
76 -- p_org_dim_lvl_cd IN VARCHAR2
77 -- Identifies the organization hierarchy level code
78 -- p_org_lvl_val IN VARCHAR2
79 -- Organization hierarchy level code value
80 -- p_exp_org_level IN VARCHAR2
81 -- expected aggregation level of organization hierarchy
82 -- p_loc_dim_lvl_cd IN VARCHAR2
83 -- Identifies the location hierarchy level code
84 -- p_loc_lvl_val IN VARCHAR2
85 -- Location hierarchy level code
86 -- p_exp_loc_level IN VARCHAR2
87 -- Expected aggregation level of location hierarchy
88 -- p_item_dim_lvl_cd IN VARCHAR2
89 -- p_item_lvl_val IN VARCHAR2
90 -- p_exp_item_level IN VARCHAR2
91 -- p_time_dim_lvl_cd IN VARCHAR2
92 -- p_time_lvl_val IN VARCHAR2
93 -- p_exp_time_level IN VARCHAR2
94 -- p_fact_code IN VARCHAR2
95 -- p_attribute1 IN VARCHAR2
96 -- p_attribute2 IN VARCHAR2
97 -- p_attribute3 IN VARCHAR2
98 -- p_attribute4 IN VARCHAR2
99 -- p_attribute5 IN VARCHAR2
100 -- x_file_path OUT VARCHAR2
101 -- Version: Current version1.0
102 -- Initial version 1.0
103 -- End of comments
104
105
106 PROCEDURE getAgrMrktItemSales(p_api_version IN NUMBER,
107 p_mfg_org_cd IN VARCHAR2,
108 p_org_cd IN VARCHAR2,
109 p_org_dim_lvl_cd IN VARCHAR2,
110 p_org_lvl_val IN VARCHAR2,
111 p_exp_org_level IN VARCHAR2,
112 p_loc_dim_lvl_cd IN VARCHAR2,
113 p_loc_lvl_val IN VARCHAR2,
114 p_exp_loc_level IN VARCHAR2,
115 p_item_dim_lvl_cd IN VARCHAR2,
116 p_item_lvl_val IN VARCHAR2,
117 p_exp_item_level IN VARCHAR2,
118 p_time_dim_lvl_cd IN VARCHAR2,
119 p_time_lvl_val IN VARCHAR2,
120 p_exp_time_level IN VARCHAR2,
121 p_attribute1 IN VARCHAR2,
122 p_attribute2 IN VARCHAR2,
123 p_attribute3 IN VARCHAR2,
124 p_attribute4 IN VARCHAR2,
125 p_attribute5 IN VARCHAR2,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 x_job_id OUT NOCOPY VARCHAR2);
130
131 -- Start of comments
132 -- API name : getAgrPrmtinPlan
133 -- Type: Public
134 -- Pre-reqs: None.
135 -- Function: to get aggregate data from DDR PROMOTION PLAN facts
136 -- Parameters:
137 -- IN:p_api_version IN NUMBERRequired
138 -- p_mfg_org_cd IN VARCHAR2Required
139 -- Manufaturer organization code
140 -- p_org_dim_lvl_cd IN VARCHAR2
141 -- Identifies the organization hierarchy level code
142 -- p_org_lvl_val IN VARCHAR2
143 -- Organization hierarchy level code value
144 -- p_exp_org_level IN VARCHAR2
145 -- expected aggregation level of organization hierarchy
146 -- p_loc_dim_lvl_cd IN VARCHAR2
147 -- Identifies the location hierarchy level code
148 -- p_loc_lvl_val IN VARCHAR2
149 -- Location hierarchy level code
150 -- p_exp_loc_level IN VARCHAR2
151 -- Expected aggregation level of location hierarchy
152 -- p_item_dim_lvl_cd IN VARCHAR2
153 -- p_item_lvl_val IN VARCHAR2
154 -- p_exp_item_level IN VARCHAR2
155 -- p_time_dim_lvl_cd IN VARCHAR2
156 -- p_time_lvl_val IN VARCHAR2
157 -- p_exp_time_level IN VARCHAR2
158 -- p_fact_code IN VARCHAR2
159 -- p_attribute1 IN VARCHAR2
160 -- p_attribute2 IN VARCHAR2
161 -- p_attribute3 IN VARCHAR2
162 -- p_attribute4 IN VARCHAR2
163 -- p_attribute5 IN VARCHAR2
164 -- x_file_path OUT VARCHAR2
165 -- Version: Current version1.0
166 -- Initial version 1.0
167 -- End of comments
168
169
170 PROCEDURE getAgrPrmtinPlan(p_api_version IN NUMBER,
171 p_mfg_org_cd IN VARCHAR2,
172 p_org_cd IN VARCHAR2,
173 p_org_dim_lvl_cd IN VARCHAR2,
174 p_org_lvl_val IN VARCHAR2,
175 p_exp_org_level IN VARCHAR2,
176 p_loc_dim_lvl_cd IN VARCHAR2,
177 p_loc_lvl_val IN VARCHAR2,
178 p_exp_loc_level IN VARCHAR2,
179 p_item_dim_lvl_cd IN VARCHAR2,
180 p_item_lvl_val IN VARCHAR2,
181 p_exp_item_level IN VARCHAR2,
182 p_time_dim_lvl_cd IN VARCHAR2,
183 p_time_lvl_val IN VARCHAR2,
184 p_exp_time_level IN VARCHAR2,
185 p_attribute1 IN VARCHAR2,
186 p_attribute2 IN VARCHAR2,
187 p_attribute3 IN VARCHAR2,
188 p_attribute4 IN VARCHAR2,
189 p_attribute5 IN VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 x_job_id OUT NOCOPY VARCHAR2);
194
195 -- Start of comments
196 -- API name : getAgrRtlInvItmDat
197 -- Type: Public
198 -- Pre-reqs: None.
199 -- Function: to get aggregate data from DDR INVENTORY ITEM STATE facts
200 -- Parameters:
201 -- IN:p_api_version IN NUMBERRequired
202 -- p_mfg_org_cd IN VARCHAR2Required
203 -- Manufaturer organization code
204 -- p_org_dim_lvl_cd IN VARCHAR2
205 -- Identifies the organization hierarchy level code
206 -- p_org_lvl_val IN VARCHAR2
207 -- Organization hierarchy level code value
208 -- p_exp_org_level IN VARCHAR2
209 -- expected aggregation level of organization hierarchy
210 -- p_loc_dim_lvl_cd IN VARCHAR2
211 -- Identifies the location hierarchy level code
212 -- p_loc_lvl_val IN VARCHAR2
213 -- Location hierarchy level code
214 -- p_exp_loc_level IN VARCHAR2
215 -- Expected aggregation level of location hierarchy
216 -- p_item_dim_lvl_cd IN VARCHAR2
217 -- p_item_lvl_val IN VARCHAR2
218 -- p_exp_item_level IN VARCHAR2
219 -- p_time_dim_lvl_cd IN VARCHAR2
220 -- p_time_lvl_val IN VARCHAR2
221 -- p_exp_time_level IN VARCHAR2
222 -- p_fact_code IN VARCHAR2
223 -- p_attribute1 IN VARCHAR2
224 -- p_attribute2 IN VARCHAR2
225 -- p_attribute3 IN VARCHAR2
226 -- p_attribute4 IN VARCHAR2
227 -- p_attribute5 IN VARCHAR2
228 -- x_file_path OUT NOCOPY VARCHAR2
229 -- Version: Current version1.0
230 -- Initial version 1.0
231 -- End of comments
232
233 PROCEDURE getAgrRtlInvItmDat (p_api_version IN NUMBER,
234 p_mfg_org_cd IN VARCHAR2,
235 p_org_cd IN VARCHAR2,
236 p_org_dim_lvl_cd IN VARCHAR2,
237 p_org_lvl_val IN VARCHAR2,
238 p_exp_org_level IN VARCHAR2,
239 p_loc_dim_lvl_cd IN VARCHAR2,
240 p_loc_lvl_val IN VARCHAR2,
241 p_exp_loc_level IN VARCHAR2,
242 p_item_dim_lvl_cd IN VARCHAR2,
243 p_item_lvl_val IN VARCHAR2,
244 p_exp_item_level IN VARCHAR2,
245 p_time_dim_lvl_cd IN VARCHAR2,
246 p_time_lvl_val IN VARCHAR2,
247 p_exp_time_level IN VARCHAR2,
248 p_attribute1 IN VARCHAR2,
249 p_attribute2 IN VARCHAR2,
250 p_attribute3 IN VARCHAR2,
251 p_attribute4 IN VARCHAR2,
252 p_attribute5 IN VARCHAR2,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 x_job_id OUT NOCOPY VARCHAR2);
257
258
259 -- Start of comments
260 -- API name : getAgrRetailerOrderItm
261 -- Type: Public
262 -- Pre-reqs: None.
263 -- Function: to get aggregate data from DDR RETAILER ORDER ITEM DAY facts
264 -- Parameters:
265 -- IN:p_api_version IN NUMBERRequired
266 -- p_mfg_org_cd IN VARCHAR2Required
267 -- Manufaturer organization code
268 -- p_org_dim_lvl_cd IN VARCHAR2
269 -- Identifies the organization hierarchy level code
270 -- p_org_lvl_val IN VARCHAR2
271 -- Organization hierarchy level code value
272 -- p_exp_org_level IN VARCHAR2
273 -- expected aggregation level of organization hierarchy
274 -- p_loc_dim_lvl_cd IN VARCHAR2
275 -- Identifies the location hierarchy level code
276 -- p_loc_lvl_val IN VARCHAR2
277 -- Location hierarchy level code
278 -- p_exp_loc_level IN VARCHAR2
279 -- Expected aggregation level of location hierarchy
280 -- p_item_dim_lvl_cd IN VARCHAR2
281 -- p_item_lvl_val IN VARCHAR2
282 -- p_exp_item_level IN VARCHAR2
283 -- p_time_dim_lvl_cd IN VARCHAR2
284 -- p_time_lvl_val IN VARCHAR2
285 -- p_exp_time_level IN VARCHAR2
286 -- p_fact_code IN VARCHAR2
287 -- p_attribute1 IN VARCHAR2
288 -- p_attribute2 IN VARCHAR2
289 -- p_attribute3 IN VARCHAR2
290 -- p_attribute4 IN VARCHAR2
291 -- p_attribute5 IN VARCHAR2
292 -- x_file_path OUT NOCOPY VARCHAR2
293 -- Version: Current version1.0
297 PROCEDURE getAgrRetailerOrderItm(p_api_version IN NUMBER,
294 -- Initial version 1.0
295 -- End of comments
296
298 p_mfg_org_cd IN VARCHAR2,
299 p_org_cd IN VARCHAR2,
300 p_org_dim_lvl_cd IN VARCHAR2,
301 p_org_lvl_val IN VARCHAR2,
302 p_exp_org_level IN VARCHAR2,
303 p_loc_dim_lvl_cd IN VARCHAR2,
304 p_loc_lvl_val IN VARCHAR2,
305 p_exp_loc_level IN VARCHAR2,
306 p_item_dim_lvl_cd IN VARCHAR2,
307 p_item_lvl_val IN VARCHAR2,
308 p_exp_item_level IN VARCHAR2,
309 p_time_dim_lvl_cd IN VARCHAR2,
310 p_time_lvl_val IN VARCHAR2,
311 p_exp_time_level IN VARCHAR2,
312 p_attribute1 IN VARCHAR2,
313 p_attribute2 IN VARCHAR2,
314 p_attribute3 IN VARCHAR2,
315 p_attribute4 IN VARCHAR2,
316 p_attribute5 IN VARCHAR2,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_count OUT NOCOPY NUMBER,
319 x_msg_data OUT NOCOPY VARCHAR2,
320 x_job_id OUT NOCOPY VARCHAR2);
321
322 -- Start of comments
323 -- API name : getAgrSaleFrecastItm
324 -- Type: Public
325 -- Pre-reqs: None.
326 -- Function: to get aggregate data from DDR SALE FORECAST ITEM BY DAY facts
327 -- Parameters:
328 -- IN:p_api_version IN NUMBERRequired
329 -- p_mfg_org_cd IN VARCHAR2Required
330 -- Manufaturer organization code
331 -- p_org_dim_lvl_cd IN VARCHAR2
332 -- Identifies the organization hierarchy level code
333 -- p_org_lvl_val IN VARCHAR2
334 -- Organization hierarchy level code value
335 -- p_exp_org_level IN VARCHAR2
336 -- expected aggregation level of organization hierarchy
337 -- p_loc_dim_lvl_cd IN VARCHAR2
338 -- Identifies the location hierarchy level code
339 -- p_loc_lvl_val IN VARCHAR2
340 -- Location hierarchy level code
341 -- p_exp_loc_level IN VARCHAR2
342 -- Expected aggregation level of location hierarchy
343 -- p_item_dim_lvl_cd IN VARCHAR2
344 -- p_item_lvl_val IN VARCHAR2
345 -- p_exp_item_level IN VARCHAR2
346 -- p_time_dim_lvl_cd IN VARCHAR2
347 -- p_time_lvl_val IN VARCHAR2
348 -- p_exp_time_level IN VARCHAR2
349 -- p_fact_code IN VARCHAR2
350 -- p_attribute1 IN VARCHAR2
351 -- p_attribute2 IN VARCHAR2
352 -- p_attribute3 IN VARCHAR2
353 -- p_attribute4 IN VARCHAR2
354 -- p_attribute5 IN VARCHAR2
355 -- x_file_path OUT NOCOPY VARCHAR2
356 -- Version: Current version1.0
357 -- Initial version 1.0
358 -- End of comments
359
363 p_org_dim_lvl_cd IN VARCHAR2,
360 PROCEDURE getAgrSaleFrecastItm(p_api_version IN NUMBER,
361 p_mfg_org_cd IN VARCHAR2,
362 p_org_cd IN VARCHAR2,
364 p_org_lvl_val IN VARCHAR2,
365 p_exp_org_level IN VARCHAR2,
366 p_loc_dim_lvl_cd IN VARCHAR2,
367 p_loc_lvl_val IN VARCHAR2,
368 p_exp_loc_level IN VARCHAR2,
369 p_item_dim_lvl_cd IN VARCHAR2,
370 p_item_lvl_val IN VARCHAR2,
371 p_exp_item_level IN VARCHAR2,
372 p_time_dim_lvl_cd IN VARCHAR2,
373 p_time_lvl_val IN VARCHAR2,
374 p_exp_time_level IN VARCHAR2,
375 p_attribute1 IN VARCHAR2,
376 p_attribute2 IN VARCHAR2,
377 p_attribute3 IN VARCHAR2,
378 p_attribute4 IN VARCHAR2,
379 p_attribute5 IN VARCHAR2,
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_count OUT NOCOPY NUMBER,
382 x_msg_data OUT NOCOPY VARCHAR2,
383 x_job_id OUT NOCOPY VARCHAR2);
384
385
386 -- Start of comments
387 -- API name : getAgrRetailerShipItem
388 -- Type: Public
389 -- Pre-reqs: None.
390 -- Function: to get aggregate data from DDR RETAILER SHIP ITEM DAY facts
391 -- Parameters:
392 -- IN:p_api_version IN NUMBERRequired
393 -- p_mfg_org_cd IN VARCHAR2Required
394 -- Manufaturer organization code
395 -- p_org_dim_lvl_cd IN VARCHAR2
396 -- Identifies the organization hierarchy level code
397 -- p_org_lvl_val IN VARCHAR2
398 -- Organization hierarchy level code value
399 -- p_exp_org_level IN VARCHAR2
400 -- expected aggregation level of organization hierarchy
401 -- p_loc_dim_lvl_cd IN VARCHAR2
402 -- Identifies the location hierarchy level code
403 -- p_loc_lvl_val IN VARCHAR2
404 -- Location hierarchy level code
405 -- p_exp_loc_level IN VARCHAR2
406 -- Expected aggregation level of location hierarchy
407 -- p_item_dim_lvl_cd IN VARCHAR2
408 -- p_item_lvl_val IN VARCHAR2
409 -- p_exp_item_level IN VARCHAR2
410 -- p_time_dim_lvl_cd IN VARCHAR2
411 -- p_time_lvl_val IN VARCHAR2
412 -- p_exp_time_level IN VARCHAR2
413 -- p_fact_code IN VARCHAR2
414 -- p_attribute1 IN VARCHAR2
415 -- p_attribute2 IN VARCHAR2
416 -- p_attribute3 IN VARCHAR2
417 -- p_attribute4 IN VARCHAR2
418 -- p_attribute5 IN VARCHAR2
419 -- x_file_path OUT NOCOPY VARCHAR2
420 -- Version: Current version1.0
421 -- Initial version 1.0
422 -- End of comments
423
424 PROCEDURE getAgrRetailerShipItem(p_api_version IN NUMBER,
425 p_mfg_org_cd IN VARCHAR2,
426 p_org_cd IN VARCHAR2,
427 p_org_dim_lvl_cd IN VARCHAR2,
428 p_org_lvl_val IN VARCHAR2,
429 p_exp_org_level IN VARCHAR2,
430 p_loc_dim_lvl_cd IN VARCHAR2,
431 p_loc_lvl_val IN VARCHAR2,
432 p_exp_loc_level IN VARCHAR2,
433 p_item_dim_lvl_cd IN VARCHAR2,
434 p_item_lvl_val IN VARCHAR2,
435 p_exp_item_level IN VARCHAR2,
436 p_time_dim_lvl_cd IN VARCHAR2,
437 p_time_lvl_val IN VARCHAR2,
438 p_exp_time_level IN VARCHAR2,
439 p_attribute1 IN VARCHAR2,
440 p_attribute2 IN VARCHAR2,
441 p_attribute3 IN VARCHAR2,
442 p_attribute4 IN VARCHAR2,
443 p_attribute5 IN VARCHAR2,
444 x_return_status OUT NOCOPY VARCHAR2,
445 x_msg_count OUT NOCOPY NUMBER,
446 x_msg_data OUT NOCOPY VARCHAR2,
450 -- API name : getSalesReturnItem
447 x_job_id OUT NOCOPY VARCHAR2);
448
449 -- Start of comments
451 -- Type: Public
452 -- Pre-reqs: None.
453 -- Function: to get detailed data from DSR facts
454 -- Parameters:
455 -- IN:p_api_version IN NUMBERRequired
456 -- p_mfg_org_cd IN VARCHAR2Required
457 -- Manufaturer organization code
458 -- p_org_dim_lvl_cd IN VARCHAR2
459 -- Identifies the organization hierarchy level code
460 -- p_org_lvl_val IN VARCHAR2
461 -- Organization hierarchy level code value
462 -- p_exp_org_level IN VARCHAR2
463 -- expected aggregation level of organization hierarchy
464 -- p_loc_dim_lvl_cd IN VARCHAR2
465 -- Identifies the location hierarchy level code
466 -- p_loc_lvl_val IN VARCHAR2
467 -- Location hierarchy level code
468 -- p_exp_loc_level IN VARCHAR2
469 -- Expected aggregation level of location hierarchy
470 -- p_item_dim_lvl_cd IN VARCHAR2
471 -- p_item_lvl_val IN VARCHAR2
472 -- p_exp_item_level IN VARCHAR2
473 -- p_time_dim_lvl_cd IN VARCHAR2
474 -- p_time_lvl_val IN VARCHAR2
475 -- p_exp_time_level IN VARCHAR2
476 -- p_fact_code IN VARCHAR2
477 -- p_attribute1 IN VARCHAR2
478 -- p_attribute2 IN VARCHAR2
479 -- p_attribute3 IN VARCHAR2
480 -- p_attribute4 IN VARCHAR2
481 -- p_attribute5 IN VARCHAR2
482 -- x_file_path OUT NOCOPY VARCHAR2
483 -- Version: Current version1.0
484 -- Initial version 1.0
485 -- End of comments
486
487 PROCEDURE getSalesReturnItem(p_api_version IN NUMBER,
488 p_mfg_org_cd IN VARCHAR2,
489 p_org_cd IN VARCHAR2,
490 p_org_dim_lvl_cd IN VARCHAR2,
491 p_org_lvl_val IN VARCHAR2,
492 p_loc_dim_lvl_cd IN VARCHAR2,
493 p_loc_lvl_val IN VARCHAR2,
494 p_item_dim_lvl_cd IN VARCHAR2,
495 p_item_lvl_val IN VARCHAR2,
496 p_time_dim_lvl_cd IN VARCHAR2,
497 p_time_lvl_val IN VARCHAR2,
498 p_attribute1 IN VARCHAR2,
499 p_attribute2 IN VARCHAR2,
500 p_attribute3 IN VARCHAR2,
501 p_attribute4 IN VARCHAR2,
502 p_attribute5 IN VARCHAR2,
503 x_return_status OUT NOCOPY VARCHAR2,
504 x_msg_count OUT NOCOPY NUMBER,
505 x_msg_data OUT NOCOPY VARCHAR2,
506 x_job_id OUT NOCOPY VARCHAR2);
507
508 -- Start of comments
509 -- API name : getMrktItemSales
510 -- Type: Public
511 -- Pre-reqs: None.
512 -- Function: to get detailed data from DSR MARKET ITEM SALES DAY facts
513 -- Parameters:
514 -- IN:p_api_version IN NUMBERRequired
515 -- p_mfg_org_cd IN VARCHAR2Required
516 -- Manufaturer organization code
517 -- p_org_dim_lvl_cd IN VARCHAR2
518 -- Identifies the organization hierarchy level code
519 -- p_org_lvl_val IN VARCHAR2
520 -- Organization hierarchy level code value
521 -- p_exp_org_level IN VARCHAR2
522 -- expected aggregation level of organization hierarchy
523 -- p_loc_dim_lvl_cd IN VARCHAR2
524 -- Identifies the location hierarchy level code
525 -- p_loc_lvl_val IN VARCHAR2
526 -- Location hierarchy level code
527 -- p_exp_loc_level IN VARCHAR2
528 -- Expected aggregation level of location hierarchy
529 -- p_item_dim_lvl_cd IN VARCHAR2
530 -- p_item_lvl_val IN VARCHAR2
531 -- p_exp_item_level IN VARCHAR2
532 -- p_time_dim_lvl_cd IN VARCHAR2
533 -- p_time_lvl_val IN VARCHAR2
534 -- p_exp_time_level IN VARCHAR2
535 -- p_fact_code IN VARCHAR2
536 -- p_attribute1 IN VARCHAR2
537 -- p_attribute2 IN VARCHAR2
538 -- p_attribute3 IN VARCHAR2
539 -- p_attribute4 IN VARCHAR2
540 -- p_attribute5 IN VARCHAR2
541 -- x_file_path OUT NOCOPY VARCHAR2
542 -- Version: Current version1.0
543 -- Initial version 1.0
544 -- End of comments
545
546 PROCEDURE getMrktItemSales(p_api_version IN NUMBER,
547 p_mfg_org_cd IN VARCHAR2,
548 p_org_cd IN VARCHAR2,
549 p_org_dim_lvl_cd IN VARCHAR2,
550 p_org_lvl_val IN VARCHAR2,
551 p_loc_dim_lvl_cd IN VARCHAR2,
552 p_loc_lvl_val IN VARCHAR2,
553 p_item_dim_lvl_cd IN VARCHAR2,
554 p_item_lvl_val IN VARCHAR2,
555 p_time_dim_lvl_cd IN VARCHAR2,
556 p_time_lvl_val IN VARCHAR2,
557 p_attribute1 IN VARCHAR2,
561 p_attribute5 IN VARCHAR2,
558 p_attribute2 IN VARCHAR2,
559 p_attribute3 IN VARCHAR2,
560 p_attribute4 IN VARCHAR2,
562 x_return_status OUT NOCOPY VARCHAR2,
563 x_msg_count OUT NOCOPY NUMBER,
564 x_msg_data OUT NOCOPY VARCHAR2,
565 x_job_id OUT NOCOPY VARCHAR2);
566
567 -- Start of comments
568 -- API name : getPrmtinPlan
569 -- Type: Public
570 -- Pre-reqs: None.
571 -- Function: to get detailed data from DSR PROMOTION PLAN facts
572 -- Parameters:
573 -- IN:p_api_version IN NUMBERRequired
574 -- p_mfg_org_cd IN VARCHAR2Required
575 -- Manufaturer organization code
576 -- p_org_dim_lvl_cd IN VARCHAR2
577 -- Identifies the organization hierarchy level code
578 -- p_org_lvl_val IN VARCHAR2
579 -- Organization hierarchy level code value
580 -- p_exp_org_level IN VARCHAR2
581 -- expected aggregation level of organization hierarchy
582 -- p_loc_dim_lvl_cd IN VARCHAR2
583 -- Identifies the location hierarchy level code
584 -- p_loc_lvl_val IN VARCHAR2
585 -- Location hierarchy level code
586 -- p_exp_loc_level IN VARCHAR2
587 -- Expected aggregation level of location hierarchy
588 -- p_item_dim_lvl_cd IN VARCHAR2
589 -- p_item_lvl_val IN VARCHAR2
590 -- p_exp_item_level IN VARCHAR2
591 -- p_time_dim_lvl_cd IN VARCHAR2
592 -- p_time_lvl_val IN VARCHAR2
593 -- p_exp_time_level IN VARCHAR2
594 -- p_fact_code IN VARCHAR2
595 -- p_attribute1 IN VARCHAR2
596 -- p_attribute2 IN VARCHAR2
597 -- p_attribute3 IN VARCHAR2
598 -- p_attribute4 IN VARCHAR2
599 -- p_attribute5 IN VARCHAR2
600 -- x_file_path OUT NOCOPY VARCHAR2
601 -- Version: Current version1.0
602 -- Initial version 1.0
603 -- End of comments
604
605 PROCEDURE getPrmtinPlan(p_api_version IN NUMBER,
606 p_mfg_org_cd IN VARCHAR2,
607 p_org_cd IN VARCHAR2,
608 p_org_dim_lvl_cd IN VARCHAR2,
609 p_org_lvl_val IN VARCHAR2,
610 p_loc_dim_lvl_cd IN VARCHAR2,
611 p_loc_lvl_val IN VARCHAR2,
612 p_item_dim_lvl_cd IN VARCHAR2,
613 p_item_lvl_val IN VARCHAR2,
614 p_time_dim_lvl_cd IN VARCHAR2,
615 p_time_lvl_val IN VARCHAR2,
616 p_attribute1 IN VARCHAR2,
617 p_attribute2 IN VARCHAR2,
618 p_attribute3 IN VARCHAR2,
619 p_attribute4 IN VARCHAR2,
620 p_attribute5 IN VARCHAR2,
621 x_return_status OUT NOCOPY VARCHAR2,
622 x_msg_count OUT NOCOPY NUMBER,
623 x_msg_data OUT NOCOPY VARCHAR2,
624 x_job_id OUT NOCOPY VARCHAR2);
625
626 -- Start of comments
627 -- API name : getRtlInvItmDat
628 -- Type: Public
629 -- Pre-reqs: None.
630 -- Function: to get detailed data from DSR RETAIL INVENTORY ITEM DAY facts
631 -- Parameters:
632 -- IN:p_api_version IN NUMBERRequired
633 -- p_mfg_org_cd IN VARCHAR2Required
634 -- Manufaturer organization code
635 -- p_org_dim_lvl_cd IN VARCHAR2
636 -- Identifies the organization hierarchy level code
637 -- p_org_lvl_val IN VARCHAR2
638 -- Organization hierarchy level code value
639 -- p_exp_org_level IN VARCHAR2
640 -- expected aggregation level of organization hierarchy
641 -- p_loc_dim_lvl_cd IN VARCHAR2
642 -- Identifies the location hierarchy level code
643 -- p_loc_lvl_val IN VARCHAR2
644 -- Location hierarchy level code
645 -- p_exp_loc_level IN VARCHAR2
646 -- Expected aggregation level of location hierarchy
647 -- p_item_dim_lvl_cd IN VARCHAR2
648 -- p_item_lvl_val IN VARCHAR2
649 -- p_exp_item_level IN VARCHAR2
650 -- p_time_dim_lvl_cd IN VARCHAR2
651 -- p_time_lvl_val IN VARCHAR2
652 -- p_exp_time_level IN VARCHAR2
653 -- p_fact_code IN VARCHAR2
654 -- p_attribute1 IN VARCHAR2
655 -- p_attribute2 IN VARCHAR2
656 -- p_attribute3 IN VARCHAR2
657 -- p_attribute4 IN VARCHAR2
658 -- p_attribute5 IN VARCHAR2
659 -- x_file_path OUT NOCOPY VARCHAR2
660 -- Version: Current version1.0
661 -- Initial version 1.0
662 -- End of comments
663
664 PROCEDURE getRtlInvItmDat(p_api_version IN NUMBER,
665 p_mfg_org_cd IN VARCHAR2,
666 p_org_cd IN VARCHAR2,
667 p_org_dim_lvl_cd IN VARCHAR2,
668 p_org_lvl_val IN VARCHAR2,
669 p_loc_dim_lvl_cd IN VARCHAR2,
670 p_loc_lvl_val IN VARCHAR2,
674 p_time_lvl_val IN VARCHAR2,
671 p_item_dim_lvl_cd IN VARCHAR2,
672 p_item_lvl_val IN VARCHAR2,
673 p_time_dim_lvl_cd IN VARCHAR2,
675 p_attribute1 IN VARCHAR2,
676 p_attribute2 IN VARCHAR2,
677 p_attribute3 IN VARCHAR2,
678 p_attribute4 IN VARCHAR2,
679 p_attribute5 IN VARCHAR2,
680 x_return_status OUT NOCOPY VARCHAR2,
681 x_msg_count OUT NOCOPY NUMBER,
682 x_msg_data OUT NOCOPY VARCHAR2,
683 x_job_id OUT NOCOPY VARCHAR2);
684
685 -- Start of comments
686 -- API name : getRetailerOrderItm
687 -- Type: Public
688 -- Pre-reqs: None.
689 -- Function: to get detailed data from DSR RETAILER ORDER ITEM DAY facts
690 -- Parameters:
691 -- IN:p_api_version IN NUMBERRequired
692 -- p_mfg_org_cd IN VARCHAR2Required
693 -- Manufaturer organization code
694 -- p_org_dim_lvl_cd IN VARCHAR2
695 -- Identifies the organization hierarchy level code
696 -- p_org_lvl_val IN VARCHAR2
697 -- Organization hierarchy level code value
698 -- p_exp_org_level IN VARCHAR2
699 -- expected aggregation level of organization hierarchy
700 -- p_loc_dim_lvl_cd IN VARCHAR2
701 -- Identifies the location hierarchy level code
702 -- p_loc_lvl_val IN VARCHAR2
703 -- Location hierarchy level code
704 -- p_exp_loc_level IN VARCHAR2
705 -- Expected aggregation level of location hierarchy
706 -- p_item_dim_lvl_cd IN VARCHAR2
707 -- p_item_lvl_val IN VARCHAR2
708 -- p_exp_item_level IN VARCHAR2
709 -- p_time_dim_lvl_cd IN VARCHAR2
710 -- p_time_lvl_val IN VARRCHAR2
711 -- p_exp_time_level IN VARCHAR2
712 -- p_fact_code IN VARCHAR2
713 -- p_attribute1 IN VARCHAR2
714 -- p_attribute2 IN VARCHAR2
715 -- p_attribute3 IN VARCHAR2
716 -- p_attribute4 IN VARCHAR2
717 -- p_attribute5 IN VARCHAR2
718 -- x_file_path OUT NOCOPY VARCHAR2
719 -- Version: Current version1.0
720 -- Initial version 1.0
721 -- End of comments
722
723 PROCEDURE getRetailerOrderItm(p_api_version IN NUMBER,
724 p_mfg_org_cd IN VARCHAR2,
725 p_org_cd IN VARCHAR2,
726 p_org_dim_lvl_cd IN VARCHAR2,
727 p_org_lvl_val IN VARCHAR2,
728 p_loc_dim_lvl_cd IN VARCHAR2,
729 p_loc_lvl_val IN VARCHAR2,
730 p_item_dim_lvl_cd IN VARCHAR2,
731 p_item_lvl_val IN VARCHAR2,
732 p_time_dim_lvl_cd IN VARCHAR2,
733 p_time_lvl_val IN VARCHAR2,
734 p_attribute1 IN VARCHAR2,
735 p_attribute2 IN VARCHAR2,
736 p_attribute3 IN VARCHAR2,
737 p_attribute4 IN VARCHAR2,
738 p_attribute5 IN VARCHAR2,
739 x_return_status OUT NOCOPY VARCHAR2,
740 x_msg_count OUT NOCOPY NUMBER,
741 x_msg_data OUT NOCOPY VARCHAR2,
742 x_job_id OUT NOCOPY VARCHAR2);
743
744 -- Start of comments
745 -- API name : getSaleFrecastItm
746 -- Type: Public
747 -- Pre-reqs: None.
748 -- Function: to get detailed data from DSR facts
749 -- Parameters:
750 -- IN:p_api_version IN NUMBERRequired
751 -- p_mfg_org_cd IN VARCHAR2Required
752 -- Manufaturer organization code
753 -- p_org_dim_lvl_cd IN VARCHAR2
754 -- Identifies the organization hierarchy level code
755 -- p_org_lvl_val IN VARCHAR2
756 -- Organization hierarchy level code value
757 -- p_exp_org_level IN VARCHAR2
758 -- expected aggregation level of organization hierarchy
759 -- p_loc_dim_lvl_cd IN VARCHAR2
760 -- Identifies the location hierarchy level code
761 -- p_loc_lvl_val IN VARCHAR2
762 -- Location hierarchy level code
763 -- p_exp_loc_level IN VARCHAR2
764 -- Expected aggregation level of location hierarchy
765 -- p_item_dim_lvl_cd IN VARCHAR2
766 -- p_item_lvl_val IN VARCHAR2
767 -- p_exp_item_level IN VARCHAR2
768 -- p_time_dim_lvl_cd IN VARCHAR2
769 -- p_time_lvl_val IN VARCHAR2
770 -- p_exp_time_level IN VARCHAR2
771 -- p_fact_code IN VARCHAR2
772 -- p_attribute1 IN VARCHAR2
773 -- p_attribute2 IN VARCHAR2
774 -- p_attribute3 IN VARCHAR2
775 -- p_attribute4 IN VARCHAR2
776 -- p_attribute5 IN VARCHAR2
777 -- x_file_path OUT NOCOPY VARCHAR2
778 -- Version: Current version1.0
779 -- Initial version 1.0
780 -- End of comments
781
782 PROCEDURE getSaleFrecastItm(p_api_version IN NUMBER,
783 p_mfg_org_cd IN VARCHAR2,
784 p_org_cd IN VARCHAR2,
785 p_org_dim_lvl_cd IN VARCHAR2,
786 p_org_lvl_val IN VARCHAR2,
787 p_loc_dim_lvl_cd IN VARCHAR2,
788 p_loc_lvl_val IN VARCHAR2,
789 p_item_dim_lvl_cd IN VARCHAR2,
790 p_item_lvl_val IN VARCHAR2,
791 p_time_dim_lvl_cd IN VARCHAR2,
792 p_time_lvl_val IN VARCHAR2,
793 p_attribute1 IN VARCHAR2,
794 p_attribute2 IN VARCHAR2,
795 p_attribute3 IN VARCHAR2,
796 p_attribute4 IN VARCHAR2,
797 p_attribute5 IN VARCHAR2,
798 x_return_status OUT NOCOPY VARCHAR2,
799 x_msg_count OUT NOCOPY NUMBER,
800 x_msg_data OUT NOCOPY VARCHAR2,
801 x_job_id OUT NOCOPY VARCHAR2);
802
803 -- Start of comments
804 -- API name : getRetailerShipItem
805 -- Type: Public
806 -- Pre-reqs: None.
807 -- Function: to get detailed data from DSR facts
808 -- Parameters:
809 -- IN:p_api_version IN NUMBERRequired
810 -- p_mfg_org_cd IN VARCHAR2Required
811 -- Manufaturer organization code
812 -- p_org_dim_lvl_cd IN VARCHAR2
818 -- p_loc_dim_lvl_cd IN VARCHAR2
813 -- Identifies the organization hierarchy level code
814 -- p_org_lvl_val IN VARCHAR2
815 -- Organization hierarchy level code value
816 -- p_exp_org_level IN VARCHAR2
817 -- expected aggregation level of organization hierarchy
819 -- Identifies the location hierarchy level code
820 -- p_loc_lvl_val IN VARCHAR2
821 -- Location hierarchy level code
822 -- p_exp_loc_level IN VARCHAR2
823 -- Expected aggregation level of location hierarchy
824 -- p_item_dim_lvl_cd IN VARCHAR2
825 -- p_item_lvl_val IN VARCHAR2
826 -- p_exp_item_level IN VARCHAR2
827 -- p_time_dim_lvl_cd IN VARCHAR2
828 -- p_time_lvl_val IN VARCHAR2
829 -- p_exp_time_level IN VARCHAR2
830 -- p_fact_code IN VARCHAR2
831 -- p_attribute1 IN VARCHAR2
832 -- p_attribute2 IN VARCHAR2
833 -- p_attribute3 IN VARCHAR2
834 -- p_attribute4 IN VARCHAR2
835 -- p_attribute5 IN VARCHAR2
836 -- x_file_path OUT NOCOPY VARCHAR2
837 -- Version: Current version1.0
838 -- Initial version 1.0
839 -- End of comments
840
841 PROCEDURE getRetailerShipItem(p_api_version IN NUMBER,
842 p_mfg_org_cd IN VARCHAR2,
843 p_org_cd IN VARCHAR2,
844 p_org_dim_lvl_cd IN VARCHAR2,
845 p_org_lvl_val IN VARCHAR2,
846 p_loc_dim_lvl_cd IN VARCHAR2,
847 p_loc_lvl_val IN VARCHAR2,
848 p_item_dim_lvl_cd IN VARCHAR2,
849 p_item_lvl_val IN VARCHAR2,
850 p_time_dim_lvl_cd IN VARCHAR2,
851 p_time_lvl_val IN VARCHAR2,
852 p_attribute1 IN VARCHAR2,
853 p_attribute2 IN VARCHAR2,
854 p_attribute3 IN VARCHAR2,
855 p_attribute4 IN VARCHAR2,
856 p_attribute5 IN VARCHAR2,
857 x_return_status OUT NOCOPY VARCHAR2,
858 x_msg_count OUT NOCOPY NUMBER,
859 x_msg_data OUT NOCOPY VARCHAR2,
860 x_job_id OUT NOCOPY VARCHAR2);
861
862 -- Start of comments
863 -- API name : getFileName
864 -- Type: Public
865 -- Pre-reqs: None.
866 -- Function: to get file names based on the input job id
867 -- Parameters:
868 -- IN :
869 -- p_api_version IN NUMBERRequired
870 -- p_api_version IN VARCHAR2
871 -- p_api_version IN VARCHAR2
872 -- OUT : x_job_id OUT NOCOPY VARCHAR2
873 -- Version: Current version1.0
874 -- Initial version 1.0
875 -- End of comments
876 PROCEDURE getFileName(p_api_version IN NUMBER,
877 x_job_id IN VARCHAR2,
878 p_mfg_org_cd IN VARCHAR2,
879 x_return_status OUT NOCOPY VARCHAR2,
880 x_msg_count OUT NOCOPY NUMBER,
881 x_msg_data OUT NOCOPY VARCHAR2,
882 x_file_path OUT NOCOPY VARCHAR2);
883
884 END;