APPS.OKL_CONTEXT_GROUPS_PUB_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

35: , p6_a8 out nocopy DATE
36: , p6_a9 out nocopy NUMBER
37: , p5_a0 NUMBER := 0-1962.0724
38: , p5_a1 NUMBER := 0-1962.0724
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 DATE := fnd_api.g_miss_date

Line 40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

36: , p6_a9 out nocopy NUMBER
37: , p5_a0 NUMBER := 0-1962.0724
38: , p5_a1 NUMBER := 0-1962.0724
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 DATE := fnd_api.g_miss_date
44: , p5_a7 NUMBER := 0-1962.0724

Line 41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

37: , p5_a0 NUMBER := 0-1962.0724
38: , p5_a1 NUMBER := 0-1962.0724
39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 DATE := fnd_api.g_miss_date
44: , p5_a7 NUMBER := 0-1962.0724
45: , p5_a8 DATE := fnd_api.g_miss_date

Line 43: , p5_a6 DATE := fnd_api.g_miss_date

39: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 DATE := fnd_api.g_miss_date
44: , p5_a7 NUMBER := 0-1962.0724
45: , p5_a8 DATE := fnd_api.g_miss_date
46: , p5_a9 NUMBER := 0-1962.0724
47: )

Line 45: , p5_a8 DATE := fnd_api.g_miss_date

41: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a5 NUMBER := 0-1962.0724
43: , p5_a6 DATE := fnd_api.g_miss_date
44: , p5_a7 NUMBER := 0-1962.0724
45: , p5_a8 DATE := fnd_api.g_miss_date
46: , p5_a9 NUMBER := 0-1962.0724
47: )
48:
49: as

Line 189: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

185: , x_msg_count out nocopy NUMBER
186: , x_msg_data out nocopy VARCHAR2
187: , p5_a0 NUMBER := 0-1962.0724
188: , p5_a1 NUMBER := 0-1962.0724
189: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
190: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a5 NUMBER := 0-1962.0724
193: , p5_a6 DATE := fnd_api.g_miss_date

Line 190: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

186: , x_msg_data out nocopy VARCHAR2
187: , p5_a0 NUMBER := 0-1962.0724
188: , p5_a1 NUMBER := 0-1962.0724
189: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
190: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a5 NUMBER := 0-1962.0724
193: , p5_a6 DATE := fnd_api.g_miss_date
194: , p5_a7 NUMBER := 0-1962.0724

Line 191: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

187: , p5_a0 NUMBER := 0-1962.0724
188: , p5_a1 NUMBER := 0-1962.0724
189: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
190: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a5 NUMBER := 0-1962.0724
193: , p5_a6 DATE := fnd_api.g_miss_date
194: , p5_a7 NUMBER := 0-1962.0724
195: , p5_a8 DATE := fnd_api.g_miss_date

Line 193: , p5_a6 DATE := fnd_api.g_miss_date

189: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
190: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a5 NUMBER := 0-1962.0724
193: , p5_a6 DATE := fnd_api.g_miss_date
194: , p5_a7 NUMBER := 0-1962.0724
195: , p5_a8 DATE := fnd_api.g_miss_date
196: , p5_a9 NUMBER := 0-1962.0724
197: )

Line 195: , p5_a8 DATE := fnd_api.g_miss_date

191: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
192: , p5_a5 NUMBER := 0-1962.0724
193: , p5_a6 DATE := fnd_api.g_miss_date
194: , p5_a7 NUMBER := 0-1962.0724
195: , p5_a8 DATE := fnd_api.g_miss_date
196: , p5_a9 NUMBER := 0-1962.0724
197: )
198:
199: as

Line 310: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

306: , p6_a8 out nocopy DATE
307: , p6_a9 out nocopy NUMBER
308: , p5_a0 NUMBER := 0-1962.0724
309: , p5_a1 NUMBER := 0-1962.0724
310: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
311: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a5 NUMBER := 0-1962.0724
314: , p5_a6 DATE := fnd_api.g_miss_date

Line 311: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

307: , p6_a9 out nocopy NUMBER
308: , p5_a0 NUMBER := 0-1962.0724
309: , p5_a1 NUMBER := 0-1962.0724
310: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
311: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a5 NUMBER := 0-1962.0724
314: , p5_a6 DATE := fnd_api.g_miss_date
315: , p5_a7 NUMBER := 0-1962.0724

Line 312: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

308: , p5_a0 NUMBER := 0-1962.0724
309: , p5_a1 NUMBER := 0-1962.0724
310: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
311: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a5 NUMBER := 0-1962.0724
314: , p5_a6 DATE := fnd_api.g_miss_date
315: , p5_a7 NUMBER := 0-1962.0724
316: , p5_a8 DATE := fnd_api.g_miss_date

Line 314: , p5_a6 DATE := fnd_api.g_miss_date

310: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
311: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a5 NUMBER := 0-1962.0724
314: , p5_a6 DATE := fnd_api.g_miss_date
315: , p5_a7 NUMBER := 0-1962.0724
316: , p5_a8 DATE := fnd_api.g_miss_date
317: , p5_a9 NUMBER := 0-1962.0724
318: )

Line 316: , p5_a8 DATE := fnd_api.g_miss_date

312: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a5 NUMBER := 0-1962.0724
314: , p5_a6 DATE := fnd_api.g_miss_date
315: , p5_a7 NUMBER := 0-1962.0724
316: , p5_a8 DATE := fnd_api.g_miss_date
317: , p5_a9 NUMBER := 0-1962.0724
318: )
319:
320: as

Line 460: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

456: , x_msg_count out nocopy NUMBER
457: , x_msg_data out nocopy VARCHAR2
458: , p5_a0 NUMBER := 0-1962.0724
459: , p5_a1 NUMBER := 0-1962.0724
460: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a5 NUMBER := 0-1962.0724
464: , p5_a6 DATE := fnd_api.g_miss_date

Line 461: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

457: , x_msg_data out nocopy VARCHAR2
458: , p5_a0 NUMBER := 0-1962.0724
459: , p5_a1 NUMBER := 0-1962.0724
460: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a5 NUMBER := 0-1962.0724
464: , p5_a6 DATE := fnd_api.g_miss_date
465: , p5_a7 NUMBER := 0-1962.0724

Line 462: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

458: , p5_a0 NUMBER := 0-1962.0724
459: , p5_a1 NUMBER := 0-1962.0724
460: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a5 NUMBER := 0-1962.0724
464: , p5_a6 DATE := fnd_api.g_miss_date
465: , p5_a7 NUMBER := 0-1962.0724
466: , p5_a8 DATE := fnd_api.g_miss_date

Line 464: , p5_a6 DATE := fnd_api.g_miss_date

460: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a5 NUMBER := 0-1962.0724
464: , p5_a6 DATE := fnd_api.g_miss_date
465: , p5_a7 NUMBER := 0-1962.0724
466: , p5_a8 DATE := fnd_api.g_miss_date
467: , p5_a9 NUMBER := 0-1962.0724
468: )

Line 466: , p5_a8 DATE := fnd_api.g_miss_date

462: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a5 NUMBER := 0-1962.0724
464: , p5_a6 DATE := fnd_api.g_miss_date
465: , p5_a7 NUMBER := 0-1962.0724
466: , p5_a8 DATE := fnd_api.g_miss_date
467: , p5_a9 NUMBER := 0-1962.0724
468: )
469:
470: as

Line 571: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

567: , x_msg_count out nocopy NUMBER
568: , x_msg_data out nocopy VARCHAR2
569: , p5_a0 NUMBER := 0-1962.0724
570: , p5_a1 NUMBER := 0-1962.0724
571: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 DATE := fnd_api.g_miss_date

Line 572: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

568: , x_msg_data out nocopy VARCHAR2
569: , p5_a0 NUMBER := 0-1962.0724
570: , p5_a1 NUMBER := 0-1962.0724
571: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 DATE := fnd_api.g_miss_date
576: , p5_a7 NUMBER := 0-1962.0724

Line 573: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

569: , p5_a0 NUMBER := 0-1962.0724
570: , p5_a1 NUMBER := 0-1962.0724
571: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 DATE := fnd_api.g_miss_date
576: , p5_a7 NUMBER := 0-1962.0724
577: , p5_a8 DATE := fnd_api.g_miss_date

Line 575: , p5_a6 DATE := fnd_api.g_miss_date

571: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
573: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 DATE := fnd_api.g_miss_date
576: , p5_a7 NUMBER := 0-1962.0724
577: , p5_a8 DATE := fnd_api.g_miss_date
578: , p5_a9 NUMBER := 0-1962.0724
579: )

Line 577: , p5_a8 DATE := fnd_api.g_miss_date

573: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a5 NUMBER := 0-1962.0724
575: , p5_a6 DATE := fnd_api.g_miss_date
576: , p5_a7 NUMBER := 0-1962.0724
577: , p5_a8 DATE := fnd_api.g_miss_date
578: , p5_a9 NUMBER := 0-1962.0724
579: )
580:
581: as