3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;
14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure insert_df_ctgy_rmk_tms(p_api_version NUMBER
134: , p5_a1 NUMBER := 0-1962.0724
135: , p5_a2 NUMBER := 0-1962.0724
136: , p5_a3 NUMBER := 0-1962.0724
137: , p5_a4 NUMBER := 0-1962.0724
138: , p5_a5 DATE := fnd_api.g_miss_date
139: , p5_a6 DATE := fnd_api.g_miss_date
140: , p5_a7 NUMBER := 0-1962.0724
141: , p5_a8 NUMBER := 0-1962.0724
142: , p5_a9 DATE := fnd_api.g_miss_date
135: , p5_a2 NUMBER := 0-1962.0724
136: , p5_a3 NUMBER := 0-1962.0724
137: , p5_a4 NUMBER := 0-1962.0724
138: , p5_a5 DATE := fnd_api.g_miss_date
139: , p5_a6 DATE := fnd_api.g_miss_date
140: , p5_a7 NUMBER := 0-1962.0724
141: , p5_a8 NUMBER := 0-1962.0724
142: , p5_a9 DATE := fnd_api.g_miss_date
143: , p5_a10 NUMBER := 0-1962.0724
138: , p5_a5 DATE := fnd_api.g_miss_date
139: , p5_a6 DATE := fnd_api.g_miss_date
140: , p5_a7 NUMBER := 0-1962.0724
141: , p5_a8 NUMBER := 0-1962.0724
142: , p5_a9 DATE := fnd_api.g_miss_date
143: , p5_a10 NUMBER := 0-1962.0724
144: , p5_a11 DATE := fnd_api.g_miss_date
145: , p5_a12 NUMBER := 0-1962.0724
146: )
140: , p5_a7 NUMBER := 0-1962.0724
141: , p5_a8 NUMBER := 0-1962.0724
142: , p5_a9 DATE := fnd_api.g_miss_date
143: , p5_a10 NUMBER := 0-1962.0724
144: , p5_a11 DATE := fnd_api.g_miss_date
145: , p5_a12 NUMBER := 0-1962.0724
146: )
147:
148: as
274: , p5_a1 NUMBER := 0-1962.0724
275: , p5_a2 NUMBER := 0-1962.0724
276: , p5_a3 NUMBER := 0-1962.0724
277: , p5_a4 NUMBER := 0-1962.0724
278: , p5_a5 DATE := fnd_api.g_miss_date
279: , p5_a6 DATE := fnd_api.g_miss_date
280: , p5_a7 NUMBER := 0-1962.0724
281: , p5_a8 NUMBER := 0-1962.0724
282: , p5_a9 DATE := fnd_api.g_miss_date
275: , p5_a2 NUMBER := 0-1962.0724
276: , p5_a3 NUMBER := 0-1962.0724
277: , p5_a4 NUMBER := 0-1962.0724
278: , p5_a5 DATE := fnd_api.g_miss_date
279: , p5_a6 DATE := fnd_api.g_miss_date
280: , p5_a7 NUMBER := 0-1962.0724
281: , p5_a8 NUMBER := 0-1962.0724
282: , p5_a9 DATE := fnd_api.g_miss_date
283: , p5_a10 NUMBER := 0-1962.0724
278: , p5_a5 DATE := fnd_api.g_miss_date
279: , p5_a6 DATE := fnd_api.g_miss_date
280: , p5_a7 NUMBER := 0-1962.0724
281: , p5_a8 NUMBER := 0-1962.0724
282: , p5_a9 DATE := fnd_api.g_miss_date
283: , p5_a10 NUMBER := 0-1962.0724
284: , p5_a11 DATE := fnd_api.g_miss_date
285: , p5_a12 NUMBER := 0-1962.0724
286: )
280: , p5_a7 NUMBER := 0-1962.0724
281: , p5_a8 NUMBER := 0-1962.0724
282: , p5_a9 DATE := fnd_api.g_miss_date
283: , p5_a10 NUMBER := 0-1962.0724
284: , p5_a11 DATE := fnd_api.g_miss_date
285: , p5_a12 NUMBER := 0-1962.0724
286: )
287:
288: as
441: , p5_a1 NUMBER := 0-1962.0724
442: , p5_a2 NUMBER := 0-1962.0724
443: , p5_a3 NUMBER := 0-1962.0724
444: , p5_a4 NUMBER := 0-1962.0724
445: , p5_a5 DATE := fnd_api.g_miss_date
446: , p5_a6 DATE := fnd_api.g_miss_date
447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 DATE := fnd_api.g_miss_date
442: , p5_a2 NUMBER := 0-1962.0724
443: , p5_a3 NUMBER := 0-1962.0724
444: , p5_a4 NUMBER := 0-1962.0724
445: , p5_a5 DATE := fnd_api.g_miss_date
446: , p5_a6 DATE := fnd_api.g_miss_date
447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 DATE := fnd_api.g_miss_date
450: , p5_a10 NUMBER := 0-1962.0724
445: , p5_a5 DATE := fnd_api.g_miss_date
446: , p5_a6 DATE := fnd_api.g_miss_date
447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 DATE := fnd_api.g_miss_date
450: , p5_a10 NUMBER := 0-1962.0724
451: , p5_a11 DATE := fnd_api.g_miss_date
452: , p5_a12 NUMBER := 0-1962.0724
453: )
447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 DATE := fnd_api.g_miss_date
450: , p5_a10 NUMBER := 0-1962.0724
451: , p5_a11 DATE := fnd_api.g_miss_date
452: , p5_a12 NUMBER := 0-1962.0724
453: )
454:
455: as
581: , p5_a1 NUMBER := 0-1962.0724
582: , p5_a2 NUMBER := 0-1962.0724
583: , p5_a3 NUMBER := 0-1962.0724
584: , p5_a4 NUMBER := 0-1962.0724
585: , p5_a5 DATE := fnd_api.g_miss_date
586: , p5_a6 DATE := fnd_api.g_miss_date
587: , p5_a7 NUMBER := 0-1962.0724
588: , p5_a8 NUMBER := 0-1962.0724
589: , p5_a9 DATE := fnd_api.g_miss_date
582: , p5_a2 NUMBER := 0-1962.0724
583: , p5_a3 NUMBER := 0-1962.0724
584: , p5_a4 NUMBER := 0-1962.0724
585: , p5_a5 DATE := fnd_api.g_miss_date
586: , p5_a6 DATE := fnd_api.g_miss_date
587: , p5_a7 NUMBER := 0-1962.0724
588: , p5_a8 NUMBER := 0-1962.0724
589: , p5_a9 DATE := fnd_api.g_miss_date
590: , p5_a10 NUMBER := 0-1962.0724
585: , p5_a5 DATE := fnd_api.g_miss_date
586: , p5_a6 DATE := fnd_api.g_miss_date
587: , p5_a7 NUMBER := 0-1962.0724
588: , p5_a8 NUMBER := 0-1962.0724
589: , p5_a9 DATE := fnd_api.g_miss_date
590: , p5_a10 NUMBER := 0-1962.0724
591: , p5_a11 DATE := fnd_api.g_miss_date
592: , p5_a12 NUMBER := 0-1962.0724
593: )
587: , p5_a7 NUMBER := 0-1962.0724
588: , p5_a8 NUMBER := 0-1962.0724
589: , p5_a9 DATE := fnd_api.g_miss_date
590: , p5_a10 NUMBER := 0-1962.0724
591: , p5_a11 DATE := fnd_api.g_miss_date
592: , p5_a12 NUMBER := 0-1962.0724
593: )
594:
595: as
704: , p5_a1 NUMBER := 0-1962.0724
705: , p5_a2 NUMBER := 0-1962.0724
706: , p5_a3 NUMBER := 0-1962.0724
707: , p5_a4 NUMBER := 0-1962.0724
708: , p5_a5 DATE := fnd_api.g_miss_date
709: , p5_a6 DATE := fnd_api.g_miss_date
710: , p5_a7 NUMBER := 0-1962.0724
711: , p5_a8 NUMBER := 0-1962.0724
712: , p5_a9 DATE := fnd_api.g_miss_date
705: , p5_a2 NUMBER := 0-1962.0724
706: , p5_a3 NUMBER := 0-1962.0724
707: , p5_a4 NUMBER := 0-1962.0724
708: , p5_a5 DATE := fnd_api.g_miss_date
709: , p5_a6 DATE := fnd_api.g_miss_date
710: , p5_a7 NUMBER := 0-1962.0724
711: , p5_a8 NUMBER := 0-1962.0724
712: , p5_a9 DATE := fnd_api.g_miss_date
713: , p5_a10 NUMBER := 0-1962.0724
708: , p5_a5 DATE := fnd_api.g_miss_date
709: , p5_a6 DATE := fnd_api.g_miss_date
710: , p5_a7 NUMBER := 0-1962.0724
711: , p5_a8 NUMBER := 0-1962.0724
712: , p5_a9 DATE := fnd_api.g_miss_date
713: , p5_a10 NUMBER := 0-1962.0724
714: , p5_a11 DATE := fnd_api.g_miss_date
715: , p5_a12 NUMBER := 0-1962.0724
716: )
710: , p5_a7 NUMBER := 0-1962.0724
711: , p5_a8 NUMBER := 0-1962.0724
712: , p5_a9 DATE := fnd_api.g_miss_date
713: , p5_a10 NUMBER := 0-1962.0724
714: , p5_a11 DATE := fnd_api.g_miss_date
715: , p5_a12 NUMBER := 0-1962.0724
716: )
717:
718: as