7: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9:
10: function rosetta_g_miss_num_map(n number) return number as
11: a number := fnd_api.g_miss_num;
12: b number := 0-1962.0724;
13: begin
14: if n=a then return b; end if;
15: if n=b then return a; end if;
18:
19: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
20: function rosetta_g_miss_date_in_map(d date) return date as
21: begin
22: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
23: return d;
24: end;
25:
26: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_xml_element_pvt.num_data_set_type_w, a0 JTF_NUMBER_TABLE) as
265: , p7_a1 NUMBER := 0-1962.0724
266: , p7_a2 NUMBER := 0-1962.0724
267: , p7_a3 NUMBER := 0-1962.0724
268: , p7_a4 NUMBER := 0-1962.0724
269: , p7_a5 DATE := fnd_api.g_miss_date
270: , p7_a6 DATE := fnd_api.g_miss_date
271: , p7_a7 NUMBER := 0-1962.0724
272: , p7_a8 NUMBER := 0-1962.0724
273: , p7_a9 NUMBER := 0-1962.0724
266: , p7_a2 NUMBER := 0-1962.0724
267: , p7_a3 NUMBER := 0-1962.0724
268: , p7_a4 NUMBER := 0-1962.0724
269: , p7_a5 DATE := fnd_api.g_miss_date
270: , p7_a6 DATE := fnd_api.g_miss_date
271: , p7_a7 NUMBER := 0-1962.0724
272: , p7_a8 NUMBER := 0-1962.0724
273: , p7_a9 NUMBER := 0-1962.0724
274: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
270: , p7_a6 DATE := fnd_api.g_miss_date
271: , p7_a7 NUMBER := 0-1962.0724
272: , p7_a8 NUMBER := 0-1962.0724
273: , p7_a9 NUMBER := 0-1962.0724
274: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
275: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a12 NUMBER := 0-1962.0724
277: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
278: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
271: , p7_a7 NUMBER := 0-1962.0724
272: , p7_a8 NUMBER := 0-1962.0724
273: , p7_a9 NUMBER := 0-1962.0724
274: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
275: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a12 NUMBER := 0-1962.0724
277: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
278: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
273: , p7_a9 NUMBER := 0-1962.0724
274: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
275: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a12 NUMBER := 0-1962.0724
277: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
278: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
280: )
281: as
274: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
275: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a12 NUMBER := 0-1962.0724
277: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
278: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
280: )
281: as
282: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
275: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a12 NUMBER := 0-1962.0724
277: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
278: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
280: )
281: as
282: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
283: ddindx binary_integer; indx binary_integer;
346: , p4_a1 NUMBER := 0-1962.0724
347: , p4_a2 NUMBER := 0-1962.0724
348: , p4_a3 NUMBER := 0-1962.0724
349: , p4_a4 NUMBER := 0-1962.0724
350: , p4_a5 DATE := fnd_api.g_miss_date
351: , p4_a6 DATE := fnd_api.g_miss_date
352: , p4_a7 NUMBER := 0-1962.0724
353: , p4_a8 NUMBER := 0-1962.0724
354: , p4_a9 NUMBER := 0-1962.0724
347: , p4_a2 NUMBER := 0-1962.0724
348: , p4_a3 NUMBER := 0-1962.0724
349: , p4_a4 NUMBER := 0-1962.0724
350: , p4_a5 DATE := fnd_api.g_miss_date
351: , p4_a6 DATE := fnd_api.g_miss_date
352: , p4_a7 NUMBER := 0-1962.0724
353: , p4_a8 NUMBER := 0-1962.0724
354: , p4_a9 NUMBER := 0-1962.0724
355: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
351: , p4_a6 DATE := fnd_api.g_miss_date
352: , p4_a7 NUMBER := 0-1962.0724
353: , p4_a8 NUMBER := 0-1962.0724
354: , p4_a9 NUMBER := 0-1962.0724
355: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
357: , p4_a12 NUMBER := 0-1962.0724
358: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
359: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
352: , p4_a7 NUMBER := 0-1962.0724
353: , p4_a8 NUMBER := 0-1962.0724
354: , p4_a9 NUMBER := 0-1962.0724
355: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
357: , p4_a12 NUMBER := 0-1962.0724
358: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
359: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p4_a9 NUMBER := 0-1962.0724
355: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
357: , p4_a12 NUMBER := 0-1962.0724
358: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
359: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
361: )
362: as
355: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
357: , p4_a12 NUMBER := 0-1962.0724
358: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
359: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
361: )
362: as
363: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
356: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
357: , p4_a12 NUMBER := 0-1962.0724
358: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
359: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
361: )
362: as
363: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
364: ddp_xml_element_ids ams_xml_element_pvt.num_data_set_type_w;
439: , p7_a1 NUMBER := 0-1962.0724
440: , p7_a2 NUMBER := 0-1962.0724
441: , p7_a3 NUMBER := 0-1962.0724
442: , p7_a4 NUMBER := 0-1962.0724
443: , p7_a5 DATE := fnd_api.g_miss_date
444: , p7_a6 DATE := fnd_api.g_miss_date
445: , p7_a7 NUMBER := 0-1962.0724
446: , p7_a8 NUMBER := 0-1962.0724
447: , p7_a9 NUMBER := 0-1962.0724
440: , p7_a2 NUMBER := 0-1962.0724
441: , p7_a3 NUMBER := 0-1962.0724
442: , p7_a4 NUMBER := 0-1962.0724
443: , p7_a5 DATE := fnd_api.g_miss_date
444: , p7_a6 DATE := fnd_api.g_miss_date
445: , p7_a7 NUMBER := 0-1962.0724
446: , p7_a8 NUMBER := 0-1962.0724
447: , p7_a9 NUMBER := 0-1962.0724
448: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
444: , p7_a6 DATE := fnd_api.g_miss_date
445: , p7_a7 NUMBER := 0-1962.0724
446: , p7_a8 NUMBER := 0-1962.0724
447: , p7_a9 NUMBER := 0-1962.0724
448: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
449: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
450: , p7_a12 NUMBER := 0-1962.0724
451: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
452: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
445: , p7_a7 NUMBER := 0-1962.0724
446: , p7_a8 NUMBER := 0-1962.0724
447: , p7_a9 NUMBER := 0-1962.0724
448: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
449: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
450: , p7_a12 NUMBER := 0-1962.0724
451: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
452: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
447: , p7_a9 NUMBER := 0-1962.0724
448: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
449: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
450: , p7_a12 NUMBER := 0-1962.0724
451: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
452: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
454: )
455: as
448: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
449: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
450: , p7_a12 NUMBER := 0-1962.0724
451: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
452: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
454: )
455: as
456: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
449: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
450: , p7_a12 NUMBER := 0-1962.0724
451: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
452: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
453: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
454: )
455: as
456: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
457: ddindx binary_integer; indx binary_integer;
516: , p3_a1 NUMBER := 0-1962.0724
517: , p3_a2 NUMBER := 0-1962.0724
518: , p3_a3 NUMBER := 0-1962.0724
519: , p3_a4 NUMBER := 0-1962.0724
520: , p3_a5 DATE := fnd_api.g_miss_date
521: , p3_a6 DATE := fnd_api.g_miss_date
522: , p3_a7 NUMBER := 0-1962.0724
523: , p3_a8 NUMBER := 0-1962.0724
524: , p3_a9 NUMBER := 0-1962.0724
517: , p3_a2 NUMBER := 0-1962.0724
518: , p3_a3 NUMBER := 0-1962.0724
519: , p3_a4 NUMBER := 0-1962.0724
520: , p3_a5 DATE := fnd_api.g_miss_date
521: , p3_a6 DATE := fnd_api.g_miss_date
522: , p3_a7 NUMBER := 0-1962.0724
523: , p3_a8 NUMBER := 0-1962.0724
524: , p3_a9 NUMBER := 0-1962.0724
525: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
521: , p3_a6 DATE := fnd_api.g_miss_date
522: , p3_a7 NUMBER := 0-1962.0724
523: , p3_a8 NUMBER := 0-1962.0724
524: , p3_a9 NUMBER := 0-1962.0724
525: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
527: , p3_a12 NUMBER := 0-1962.0724
528: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
529: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
522: , p3_a7 NUMBER := 0-1962.0724
523: , p3_a8 NUMBER := 0-1962.0724
524: , p3_a9 NUMBER := 0-1962.0724
525: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
527: , p3_a12 NUMBER := 0-1962.0724
528: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
529: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
530: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
524: , p3_a9 NUMBER := 0-1962.0724
525: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
527: , p3_a12 NUMBER := 0-1962.0724
528: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
529: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
530: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
531: )
532: as
525: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
527: , p3_a12 NUMBER := 0-1962.0724
528: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
529: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
530: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
531: )
532: as
533: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
526: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
527: , p3_a12 NUMBER := 0-1962.0724
528: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
529: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
530: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
531: )
532: as
533: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
534: ddindx binary_integer; indx binary_integer;
585: , p0_a1 NUMBER := 0-1962.0724
586: , p0_a2 NUMBER := 0-1962.0724
587: , p0_a3 NUMBER := 0-1962.0724
588: , p0_a4 NUMBER := 0-1962.0724
589: , p0_a5 DATE := fnd_api.g_miss_date
590: , p0_a6 DATE := fnd_api.g_miss_date
591: , p0_a7 NUMBER := 0-1962.0724
592: , p0_a8 NUMBER := 0-1962.0724
593: , p0_a9 NUMBER := 0-1962.0724
586: , p0_a2 NUMBER := 0-1962.0724
587: , p0_a3 NUMBER := 0-1962.0724
588: , p0_a4 NUMBER := 0-1962.0724
589: , p0_a5 DATE := fnd_api.g_miss_date
590: , p0_a6 DATE := fnd_api.g_miss_date
591: , p0_a7 NUMBER := 0-1962.0724
592: , p0_a8 NUMBER := 0-1962.0724
593: , p0_a9 NUMBER := 0-1962.0724
594: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
590: , p0_a6 DATE := fnd_api.g_miss_date
591: , p0_a7 NUMBER := 0-1962.0724
592: , p0_a8 NUMBER := 0-1962.0724
593: , p0_a9 NUMBER := 0-1962.0724
594: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
595: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
596: , p0_a12 NUMBER := 0-1962.0724
597: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
591: , p0_a7 NUMBER := 0-1962.0724
592: , p0_a8 NUMBER := 0-1962.0724
593: , p0_a9 NUMBER := 0-1962.0724
594: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
595: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
596: , p0_a12 NUMBER := 0-1962.0724
597: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
599: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
593: , p0_a9 NUMBER := 0-1962.0724
594: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
595: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
596: , p0_a12 NUMBER := 0-1962.0724
597: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
599: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
600: )
601: as
594: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
595: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
596: , p0_a12 NUMBER := 0-1962.0724
597: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
599: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
600: )
601: as
602: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
595: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
596: , p0_a12 NUMBER := 0-1962.0724
597: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
599: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
600: )
601: as
602: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
603: ddindx binary_integer; indx binary_integer;
642: , p5_a1 NUMBER := 0-1962.0724
643: , p5_a2 NUMBER := 0-1962.0724
644: , p5_a3 NUMBER := 0-1962.0724
645: , p5_a4 NUMBER := 0-1962.0724
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 NUMBER := 0-1962.0724
650: , p5_a9 NUMBER := 0-1962.0724
643: , p5_a2 NUMBER := 0-1962.0724
644: , p5_a3 NUMBER := 0-1962.0724
645: , p5_a4 NUMBER := 0-1962.0724
646: , p5_a5 DATE := fnd_api.g_miss_date
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 NUMBER := 0-1962.0724
650: , p5_a9 NUMBER := 0-1962.0724
651: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a6 DATE := fnd_api.g_miss_date
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 NUMBER := 0-1962.0724
650: , p5_a9 NUMBER := 0-1962.0724
651: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a12 NUMBER := 0-1962.0724
654: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a7 NUMBER := 0-1962.0724
649: , p5_a8 NUMBER := 0-1962.0724
650: , p5_a9 NUMBER := 0-1962.0724
651: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a12 NUMBER := 0-1962.0724
654: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a9 NUMBER := 0-1962.0724
651: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a12 NUMBER := 0-1962.0724
654: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
657: )
658: as
651: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a12 NUMBER := 0-1962.0724
654: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
657: )
658: as
659: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
652: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a12 NUMBER := 0-1962.0724
654: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
657: )
658: as
659: ddp_xml_element_rec ams_xml_element_pvt.xml_element_rec_type;
660: ddindx binary_integer; indx binary_integer;