DBA Data[Home] [Help]

APPS.OKL_DF_CTGY_RMK_TMS_PUB_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

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;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; 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

Line 138: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 139: , p5_a6 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

Line 142: , p5_a9 DATE := fnd_api.g_miss_date

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: )

Line 144: , p5_a11 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: )
147:
148: as

Line 278: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 279: , p5_a6 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

Line 282: , p5_a9 DATE := fnd_api.g_miss_date

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: )

Line 284: , p5_a11 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: )
287:
288: as

Line 445: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 446: , p5_a6 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

Line 449: , p5_a9 DATE := fnd_api.g_miss_date

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: )

Line 451: , p5_a11 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: )
454:
455: as

Line 585: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 586: , p5_a6 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

Line 589: , p5_a9 DATE := fnd_api.g_miss_date

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: )

Line 591: , p5_a11 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: )
594:
595: as

Line 708: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 709: , p5_a6 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

Line 712: , p5_a9 DATE := fnd_api.g_miss_date

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: )

Line 714: , p5_a11 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: )
717:
718: as