APPS.OKL_QLS_PVT_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 265: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

261: , p6_a8 out nocopy NUMBER
262: , p6_a9 out nocopy DATE
263: , p6_a10 out nocopy NUMBER
264: , p5_a0 NUMBER := 0-1962.0724
265: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
266: , p5_a2 NUMBER := 0-1962.0724
267: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a4 NUMBER := 0-1962.0724
269: , p5_a5 NUMBER := 0-1962.0724

Line 267: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

263: , p6_a10 out nocopy NUMBER
264: , p5_a0 NUMBER := 0-1962.0724
265: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
266: , p5_a2 NUMBER := 0-1962.0724
267: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a4 NUMBER := 0-1962.0724
269: , p5_a5 NUMBER := 0-1962.0724
270: , p5_a6 NUMBER := 0-1962.0724
271: , p5_a7 DATE := fnd_api.g_miss_date

Line 271: , p5_a7 DATE := fnd_api.g_miss_date

267: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a4 NUMBER := 0-1962.0724
269: , p5_a5 NUMBER := 0-1962.0724
270: , p5_a6 NUMBER := 0-1962.0724
271: , p5_a7 DATE := fnd_api.g_miss_date
272: , p5_a8 NUMBER := 0-1962.0724
273: , p5_a9 DATE := fnd_api.g_miss_date
274: , p5_a10 NUMBER := 0-1962.0724
275: )

Line 273: , p5_a9 DATE := fnd_api.g_miss_date

269: , p5_a5 NUMBER := 0-1962.0724
270: , p5_a6 NUMBER := 0-1962.0724
271: , p5_a7 DATE := fnd_api.g_miss_date
272: , p5_a8 NUMBER := 0-1962.0724
273: , p5_a9 DATE := fnd_api.g_miss_date
274: , p5_a10 NUMBER := 0-1962.0724
275: )
276:
277: as

Line 534: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

530: , x_return_status out nocopy VARCHAR2
531: , x_msg_count out nocopy NUMBER
532: , x_msg_data out nocopy VARCHAR2
533: , p5_a0 NUMBER := 0-1962.0724
534: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a2 NUMBER := 0-1962.0724
536: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a4 NUMBER := 0-1962.0724
538: , p5_a5 NUMBER := 0-1962.0724

Line 536: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

532: , x_msg_data out nocopy VARCHAR2
533: , p5_a0 NUMBER := 0-1962.0724
534: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a2 NUMBER := 0-1962.0724
536: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a4 NUMBER := 0-1962.0724
538: , p5_a5 NUMBER := 0-1962.0724
539: , p5_a6 NUMBER := 0-1962.0724
540: , p5_a7 DATE := fnd_api.g_miss_date

Line 540: , p5_a7 DATE := fnd_api.g_miss_date

536: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a4 NUMBER := 0-1962.0724
538: , p5_a5 NUMBER := 0-1962.0724
539: , p5_a6 NUMBER := 0-1962.0724
540: , p5_a7 DATE := fnd_api.g_miss_date
541: , p5_a8 NUMBER := 0-1962.0724
542: , p5_a9 DATE := fnd_api.g_miss_date
543: , p5_a10 NUMBER := 0-1962.0724
544: )

Line 542: , p5_a9 DATE := fnd_api.g_miss_date

538: , p5_a5 NUMBER := 0-1962.0724
539: , p5_a6 NUMBER := 0-1962.0724
540: , p5_a7 DATE := fnd_api.g_miss_date
541: , p5_a8 NUMBER := 0-1962.0724
542: , p5_a9 DATE := fnd_api.g_miss_date
543: , p5_a10 NUMBER := 0-1962.0724
544: )
545:
546: as

Line 745: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

741: , p6_a8 out nocopy NUMBER
742: , p6_a9 out nocopy DATE
743: , p6_a10 out nocopy NUMBER
744: , p5_a0 NUMBER := 0-1962.0724
745: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a2 NUMBER := 0-1962.0724
747: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a4 NUMBER := 0-1962.0724
749: , p5_a5 NUMBER := 0-1962.0724

Line 747: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

743: , p6_a10 out nocopy NUMBER
744: , p5_a0 NUMBER := 0-1962.0724
745: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a2 NUMBER := 0-1962.0724
747: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a4 NUMBER := 0-1962.0724
749: , p5_a5 NUMBER := 0-1962.0724
750: , p5_a6 NUMBER := 0-1962.0724
751: , p5_a7 DATE := fnd_api.g_miss_date

Line 751: , p5_a7 DATE := fnd_api.g_miss_date

747: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a4 NUMBER := 0-1962.0724
749: , p5_a5 NUMBER := 0-1962.0724
750: , p5_a6 NUMBER := 0-1962.0724
751: , p5_a7 DATE := fnd_api.g_miss_date
752: , p5_a8 NUMBER := 0-1962.0724
753: , p5_a9 DATE := fnd_api.g_miss_date
754: , p5_a10 NUMBER := 0-1962.0724
755: )

Line 753: , p5_a9 DATE := fnd_api.g_miss_date

749: , p5_a5 NUMBER := 0-1962.0724
750: , p5_a6 NUMBER := 0-1962.0724
751: , p5_a7 DATE := fnd_api.g_miss_date
752: , p5_a8 NUMBER := 0-1962.0724
753: , p5_a9 DATE := fnd_api.g_miss_date
754: , p5_a10 NUMBER := 0-1962.0724
755: )
756:
757: as

Line 1014: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1010: , x_return_status out nocopy VARCHAR2
1011: , x_msg_count out nocopy NUMBER
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 NUMBER := 0-1962.0724
1014: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a2 NUMBER := 0-1962.0724
1016: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a4 NUMBER := 0-1962.0724
1018: , p5_a5 NUMBER := 0-1962.0724

Line 1016: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 NUMBER := 0-1962.0724
1014: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a2 NUMBER := 0-1962.0724
1016: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a4 NUMBER := 0-1962.0724
1018: , p5_a5 NUMBER := 0-1962.0724
1019: , p5_a6 NUMBER := 0-1962.0724
1020: , p5_a7 DATE := fnd_api.g_miss_date

Line 1020: , p5_a7 DATE := fnd_api.g_miss_date

1016: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a4 NUMBER := 0-1962.0724
1018: , p5_a5 NUMBER := 0-1962.0724
1019: , p5_a6 NUMBER := 0-1962.0724
1020: , p5_a7 DATE := fnd_api.g_miss_date
1021: , p5_a8 NUMBER := 0-1962.0724
1022: , p5_a9 DATE := fnd_api.g_miss_date
1023: , p5_a10 NUMBER := 0-1962.0724
1024: )

Line 1022: , p5_a9 DATE := fnd_api.g_miss_date

1018: , p5_a5 NUMBER := 0-1962.0724
1019: , p5_a6 NUMBER := 0-1962.0724
1020: , p5_a7 DATE := fnd_api.g_miss_date
1021: , p5_a8 NUMBER := 0-1962.0724
1022: , p5_a9 DATE := fnd_api.g_miss_date
1023: , p5_a10 NUMBER := 0-1962.0724
1024: )
1025:
1026: as

Line 1214: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1210: , x_return_status out nocopy VARCHAR2
1211: , x_msg_count out nocopy NUMBER
1212: , x_msg_data out nocopy VARCHAR2
1213: , p5_a0 NUMBER := 0-1962.0724
1214: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a2 NUMBER := 0-1962.0724
1216: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a4 NUMBER := 0-1962.0724
1218: , p5_a5 NUMBER := 0-1962.0724

Line 1216: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1212: , x_msg_data out nocopy VARCHAR2
1213: , p5_a0 NUMBER := 0-1962.0724
1214: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a2 NUMBER := 0-1962.0724
1216: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a4 NUMBER := 0-1962.0724
1218: , p5_a5 NUMBER := 0-1962.0724
1219: , p5_a6 NUMBER := 0-1962.0724
1220: , p5_a7 DATE := fnd_api.g_miss_date

Line 1220: , p5_a7 DATE := fnd_api.g_miss_date

1216: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a4 NUMBER := 0-1962.0724
1218: , p5_a5 NUMBER := 0-1962.0724
1219: , p5_a6 NUMBER := 0-1962.0724
1220: , p5_a7 DATE := fnd_api.g_miss_date
1221: , p5_a8 NUMBER := 0-1962.0724
1222: , p5_a9 DATE := fnd_api.g_miss_date
1223: , p5_a10 NUMBER := 0-1962.0724
1224: )

Line 1222: , p5_a9 DATE := fnd_api.g_miss_date

1218: , p5_a5 NUMBER := 0-1962.0724
1219: , p5_a6 NUMBER := 0-1962.0724
1220: , p5_a7 DATE := fnd_api.g_miss_date
1221: , p5_a8 NUMBER := 0-1962.0724
1222: , p5_a9 DATE := fnd_api.g_miss_date
1223: , p5_a10 NUMBER := 0-1962.0724
1224: )
1225:
1226: as