APPS.OKL_OPTION_RULES_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 75: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

71: , p5_a0 NUMBER := 0-1962.0724
72: , p5_a1 NUMBER := 0-1962.0724
73: , p5_a2 NUMBER := 0-1962.0724
74: , p5_a3 NUMBER := 0-1962.0724
75: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a6 NUMBER := 0-1962.0724
78: , p5_a7 NUMBER := 0-1962.0724
79: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 76: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

72: , p5_a1 NUMBER := 0-1962.0724
73: , p5_a2 NUMBER := 0-1962.0724
74: , p5_a3 NUMBER := 0-1962.0724
75: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a6 NUMBER := 0-1962.0724
78: , p5_a7 NUMBER := 0-1962.0724
79: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a9 NUMBER := 0-1962.0724

Line 79: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

75: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a6 NUMBER := 0-1962.0724
78: , p5_a7 NUMBER := 0-1962.0724
79: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a9 NUMBER := 0-1962.0724
81: , p5_a10 DATE := fnd_api.g_miss_date
82: , p5_a11 NUMBER := 0-1962.0724
83: , p5_a12 DATE := fnd_api.g_miss_date

Line 81: , p5_a10 DATE := fnd_api.g_miss_date

77: , p5_a6 NUMBER := 0-1962.0724
78: , p5_a7 NUMBER := 0-1962.0724
79: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a9 NUMBER := 0-1962.0724
81: , p5_a10 DATE := fnd_api.g_miss_date
82: , p5_a11 NUMBER := 0-1962.0724
83: , p5_a12 DATE := fnd_api.g_miss_date
84: , p5_a13 NUMBER := 0-1962.0724
85: )

Line 83: , p5_a12 DATE := fnd_api.g_miss_date

79: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a9 NUMBER := 0-1962.0724
81: , p5_a10 DATE := fnd_api.g_miss_date
82: , p5_a11 NUMBER := 0-1962.0724
83: , p5_a12 DATE := fnd_api.g_miss_date
84: , p5_a13 NUMBER := 0-1962.0724
85: )
86:
87: as

Line 240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

236: , p5_a0 NUMBER := 0-1962.0724
237: , p5_a1 NUMBER := 0-1962.0724
238: , p5_a2 NUMBER := 0-1962.0724
239: , p5_a3 NUMBER := 0-1962.0724
240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a6 NUMBER := 0-1962.0724
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 241: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

237: , p5_a1 NUMBER := 0-1962.0724
238: , p5_a2 NUMBER := 0-1962.0724
239: , p5_a3 NUMBER := 0-1962.0724
240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a6 NUMBER := 0-1962.0724
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a9 NUMBER := 0-1962.0724

Line 244: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

240: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a6 NUMBER := 0-1962.0724
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a9 NUMBER := 0-1962.0724
246: , p5_a10 DATE := fnd_api.g_miss_date
247: , p5_a11 NUMBER := 0-1962.0724
248: , p5_a12 DATE := fnd_api.g_miss_date

Line 246: , p5_a10 DATE := fnd_api.g_miss_date

242: , p5_a6 NUMBER := 0-1962.0724
243: , p5_a7 NUMBER := 0-1962.0724
244: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a9 NUMBER := 0-1962.0724
246: , p5_a10 DATE := fnd_api.g_miss_date
247: , p5_a11 NUMBER := 0-1962.0724
248: , p5_a12 DATE := fnd_api.g_miss_date
249: , p5_a13 NUMBER := 0-1962.0724
250: )

Line 248: , p5_a12 DATE := fnd_api.g_miss_date

244: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a9 NUMBER := 0-1962.0724
246: , p5_a10 DATE := fnd_api.g_miss_date
247: , p5_a11 NUMBER := 0-1962.0724
248: , p5_a12 DATE := fnd_api.g_miss_date
249: , p5_a13 NUMBER := 0-1962.0724
250: )
251:
252: as

Line 376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

372: , p5_a0 NUMBER := 0-1962.0724
373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 NUMBER := 0-1962.0724
375: , p5_a3 NUMBER := 0-1962.0724
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a6 NUMBER := 0-1962.0724
379: , p5_a7 NUMBER := 0-1962.0724
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 377: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 NUMBER := 0-1962.0724
375: , p5_a3 NUMBER := 0-1962.0724
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a6 NUMBER := 0-1962.0724
379: , p5_a7 NUMBER := 0-1962.0724
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 NUMBER := 0-1962.0724

Line 380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a6 NUMBER := 0-1962.0724
379: , p5_a7 NUMBER := 0-1962.0724
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 NUMBER := 0-1962.0724
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 NUMBER := 0-1962.0724
384: , p5_a12 DATE := fnd_api.g_miss_date

Line 382: , p5_a10 DATE := fnd_api.g_miss_date

378: , p5_a6 NUMBER := 0-1962.0724
379: , p5_a7 NUMBER := 0-1962.0724
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 NUMBER := 0-1962.0724
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 NUMBER := 0-1962.0724
384: , p5_a12 DATE := fnd_api.g_miss_date
385: , p5_a13 NUMBER := 0-1962.0724
386: )

Line 384: , p5_a12 DATE := fnd_api.g_miss_date

380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 NUMBER := 0-1962.0724
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 NUMBER := 0-1962.0724
384: , p5_a12 DATE := fnd_api.g_miss_date
385: , p5_a13 NUMBER := 0-1962.0724
386: )
387:
388: as

Line 570: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

566: , p5_a0 NUMBER := 0-1962.0724
567: , p5_a1 NUMBER := 0-1962.0724
568: , p5_a2 NUMBER := 0-1962.0724
569: , p5_a3 NUMBER := 0-1962.0724
570: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a6 NUMBER := 0-1962.0724
573: , p5_a7 NUMBER := 0-1962.0724
574: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 571: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

567: , p5_a1 NUMBER := 0-1962.0724
568: , p5_a2 NUMBER := 0-1962.0724
569: , p5_a3 NUMBER := 0-1962.0724
570: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a6 NUMBER := 0-1962.0724
573: , p5_a7 NUMBER := 0-1962.0724
574: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a9 NUMBER := 0-1962.0724

Line 574: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

570: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a6 NUMBER := 0-1962.0724
573: , p5_a7 NUMBER := 0-1962.0724
574: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a9 NUMBER := 0-1962.0724
576: , p5_a10 DATE := fnd_api.g_miss_date
577: , p5_a11 NUMBER := 0-1962.0724
578: , p5_a12 DATE := fnd_api.g_miss_date

Line 576: , p5_a10 DATE := fnd_api.g_miss_date

572: , p5_a6 NUMBER := 0-1962.0724
573: , p5_a7 NUMBER := 0-1962.0724
574: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a9 NUMBER := 0-1962.0724
576: , p5_a10 DATE := fnd_api.g_miss_date
577: , p5_a11 NUMBER := 0-1962.0724
578: , p5_a12 DATE := fnd_api.g_miss_date
579: , p5_a13 NUMBER := 0-1962.0724
580: )

Line 578: , p5_a12 DATE := fnd_api.g_miss_date

574: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
575: , p5_a9 NUMBER := 0-1962.0724
576: , p5_a10 DATE := fnd_api.g_miss_date
577: , p5_a11 NUMBER := 0-1962.0724
578: , p5_a12 DATE := fnd_api.g_miss_date
579: , p5_a13 NUMBER := 0-1962.0724
580: )
581:
582: as

Line 715: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

711: , p5_a0 NUMBER := 0-1962.0724
712: , p5_a1 NUMBER := 0-1962.0724
713: , p5_a2 NUMBER := 0-1962.0724
714: , p5_a3 NUMBER := 0-1962.0724
715: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a6 NUMBER := 0-1962.0724
718: , p5_a7 NUMBER := 0-1962.0724
719: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 716: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

712: , p5_a1 NUMBER := 0-1962.0724
713: , p5_a2 NUMBER := 0-1962.0724
714: , p5_a3 NUMBER := 0-1962.0724
715: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a6 NUMBER := 0-1962.0724
718: , p5_a7 NUMBER := 0-1962.0724
719: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a9 NUMBER := 0-1962.0724

Line 719: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

715: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a6 NUMBER := 0-1962.0724
718: , p5_a7 NUMBER := 0-1962.0724
719: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a9 NUMBER := 0-1962.0724
721: , p5_a10 DATE := fnd_api.g_miss_date
722: , p5_a11 NUMBER := 0-1962.0724
723: , p5_a12 DATE := fnd_api.g_miss_date

Line 721: , p5_a10 DATE := fnd_api.g_miss_date

717: , p5_a6 NUMBER := 0-1962.0724
718: , p5_a7 NUMBER := 0-1962.0724
719: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a9 NUMBER := 0-1962.0724
721: , p5_a10 DATE := fnd_api.g_miss_date
722: , p5_a11 NUMBER := 0-1962.0724
723: , p5_a12 DATE := fnd_api.g_miss_date
724: , p5_a13 NUMBER := 0-1962.0724
725: )

Line 723: , p5_a12 DATE := fnd_api.g_miss_date

719: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a9 NUMBER := 0-1962.0724
721: , p5_a10 DATE := fnd_api.g_miss_date
722: , p5_a11 NUMBER := 0-1962.0724
723: , p5_a12 DATE := fnd_api.g_miss_date
724: , p5_a13 NUMBER := 0-1962.0724
725: )
726:
727: as

Line 889: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

885: , p5_a0 NUMBER := 0-1962.0724
886: , p5_a1 NUMBER := 0-1962.0724
887: , p5_a2 NUMBER := 0-1962.0724
888: , p5_a3 NUMBER := 0-1962.0724
889: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
890: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a6 NUMBER := 0-1962.0724
892: , p5_a7 NUMBER := 0-1962.0724
893: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 890: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

886: , p5_a1 NUMBER := 0-1962.0724
887: , p5_a2 NUMBER := 0-1962.0724
888: , p5_a3 NUMBER := 0-1962.0724
889: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
890: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a6 NUMBER := 0-1962.0724
892: , p5_a7 NUMBER := 0-1962.0724
893: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a9 NUMBER := 0-1962.0724

Line 893: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

889: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
890: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a6 NUMBER := 0-1962.0724
892: , p5_a7 NUMBER := 0-1962.0724
893: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a9 NUMBER := 0-1962.0724
895: , p5_a10 DATE := fnd_api.g_miss_date
896: , p5_a11 NUMBER := 0-1962.0724
897: , p5_a12 DATE := fnd_api.g_miss_date

Line 895: , p5_a10 DATE := fnd_api.g_miss_date

891: , p5_a6 NUMBER := 0-1962.0724
892: , p5_a7 NUMBER := 0-1962.0724
893: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a9 NUMBER := 0-1962.0724
895: , p5_a10 DATE := fnd_api.g_miss_date
896: , p5_a11 NUMBER := 0-1962.0724
897: , p5_a12 DATE := fnd_api.g_miss_date
898: , p5_a13 NUMBER := 0-1962.0724
899: )

Line 897: , p5_a12 DATE := fnd_api.g_miss_date

893: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a9 NUMBER := 0-1962.0724
895: , p5_a10 DATE := fnd_api.g_miss_date
896: , p5_a11 NUMBER := 0-1962.0724
897: , p5_a12 DATE := fnd_api.g_miss_date
898: , p5_a13 NUMBER := 0-1962.0724
899: )
900:
901: as

Line 1034: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

1030: , p5_a0 NUMBER := 0-1962.0724
1031: , p5_a1 NUMBER := 0-1962.0724
1032: , p5_a2 NUMBER := 0-1962.0724
1033: , p5_a3 NUMBER := 0-1962.0724
1034: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a6 NUMBER := 0-1962.0724
1037: , p5_a7 NUMBER := 0-1962.0724
1038: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 1035: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1031: , p5_a1 NUMBER := 0-1962.0724
1032: , p5_a2 NUMBER := 0-1962.0724
1033: , p5_a3 NUMBER := 0-1962.0724
1034: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a6 NUMBER := 0-1962.0724
1037: , p5_a7 NUMBER := 0-1962.0724
1038: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a9 NUMBER := 0-1962.0724

Line 1038: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

1034: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a6 NUMBER := 0-1962.0724
1037: , p5_a7 NUMBER := 0-1962.0724
1038: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a9 NUMBER := 0-1962.0724
1040: , p5_a10 DATE := fnd_api.g_miss_date
1041: , p5_a11 NUMBER := 0-1962.0724
1042: , p5_a12 DATE := fnd_api.g_miss_date

Line 1040: , p5_a10 DATE := fnd_api.g_miss_date

1036: , p5_a6 NUMBER := 0-1962.0724
1037: , p5_a7 NUMBER := 0-1962.0724
1038: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a9 NUMBER := 0-1962.0724
1040: , p5_a10 DATE := fnd_api.g_miss_date
1041: , p5_a11 NUMBER := 0-1962.0724
1042: , p5_a12 DATE := fnd_api.g_miss_date
1043: , p5_a13 NUMBER := 0-1962.0724
1044: )

Line 1042: , p5_a12 DATE := fnd_api.g_miss_date

1038: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a9 NUMBER := 0-1962.0724
1040: , p5_a10 DATE := fnd_api.g_miss_date
1041: , p5_a11 NUMBER := 0-1962.0724
1042: , p5_a12 DATE := fnd_api.g_miss_date
1043: , p5_a13 NUMBER := 0-1962.0724
1044: )
1045:
1046: as

Line 1161: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

1157: , p5_a0 NUMBER := 0-1962.0724
1158: , p5_a1 NUMBER := 0-1962.0724
1159: , p5_a2 NUMBER := 0-1962.0724
1160: , p5_a3 NUMBER := 0-1962.0724
1161: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a6 NUMBER := 0-1962.0724
1164: , p5_a7 NUMBER := 0-1962.0724
1165: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 1162: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1158: , p5_a1 NUMBER := 0-1962.0724
1159: , p5_a2 NUMBER := 0-1962.0724
1160: , p5_a3 NUMBER := 0-1962.0724
1161: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a6 NUMBER := 0-1962.0724
1164: , p5_a7 NUMBER := 0-1962.0724
1165: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a9 NUMBER := 0-1962.0724

Line 1165: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

1161: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a6 NUMBER := 0-1962.0724
1164: , p5_a7 NUMBER := 0-1962.0724
1165: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a9 NUMBER := 0-1962.0724
1167: , p5_a10 DATE := fnd_api.g_miss_date
1168: , p5_a11 NUMBER := 0-1962.0724
1169: , p5_a12 DATE := fnd_api.g_miss_date

Line 1167: , p5_a10 DATE := fnd_api.g_miss_date

1163: , p5_a6 NUMBER := 0-1962.0724
1164: , p5_a7 NUMBER := 0-1962.0724
1165: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a9 NUMBER := 0-1962.0724
1167: , p5_a10 DATE := fnd_api.g_miss_date
1168: , p5_a11 NUMBER := 0-1962.0724
1169: , p5_a12 DATE := fnd_api.g_miss_date
1170: , p5_a13 NUMBER := 0-1962.0724
1171: )

Line 1169: , p5_a12 DATE := fnd_api.g_miss_date

1165: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a9 NUMBER := 0-1962.0724
1167: , p5_a10 DATE := fnd_api.g_miss_date
1168: , p5_a11 NUMBER := 0-1962.0724
1169: , p5_a12 DATE := fnd_api.g_miss_date
1170: , p5_a13 NUMBER := 0-1962.0724
1171: )
1172:
1173: as

Line 1337: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1333: , p6_a12 out nocopy NUMBER
1334: , p6_a13 out nocopy DATE
1335: , p6_a14 out nocopy NUMBER
1336: , p5_a0 NUMBER := 0-1962.0724
1337: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a2 NUMBER := 0-1962.0724
1339: , p5_a3 NUMBER := 0-1962.0724
1340: , p5_a4 NUMBER := 0-1962.0724
1341: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1341: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1337: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a2 NUMBER := 0-1962.0724
1339: , p5_a3 NUMBER := 0-1962.0724
1340: , p5_a4 NUMBER := 0-1962.0724
1341: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a7 NUMBER := 0-1962.0724
1344: , p5_a8 NUMBER := 0-1962.0724
1345: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1342: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1338: , p5_a2 NUMBER := 0-1962.0724
1339: , p5_a3 NUMBER := 0-1962.0724
1340: , p5_a4 NUMBER := 0-1962.0724
1341: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a7 NUMBER := 0-1962.0724
1344: , p5_a8 NUMBER := 0-1962.0724
1345: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a10 NUMBER := 0-1962.0724

Line 1345: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1341: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a7 NUMBER := 0-1962.0724
1344: , p5_a8 NUMBER := 0-1962.0724
1345: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a10 NUMBER := 0-1962.0724
1347: , p5_a11 DATE := fnd_api.g_miss_date
1348: , p5_a12 NUMBER := 0-1962.0724
1349: , p5_a13 DATE := fnd_api.g_miss_date

Line 1347: , p5_a11 DATE := fnd_api.g_miss_date

1343: , p5_a7 NUMBER := 0-1962.0724
1344: , p5_a8 NUMBER := 0-1962.0724
1345: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a10 NUMBER := 0-1962.0724
1347: , p5_a11 DATE := fnd_api.g_miss_date
1348: , p5_a12 NUMBER := 0-1962.0724
1349: , p5_a13 DATE := fnd_api.g_miss_date
1350: , p5_a14 NUMBER := 0-1962.0724
1351: )

Line 1349: , p5_a13 DATE := fnd_api.g_miss_date

1345: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a10 NUMBER := 0-1962.0724
1347: , p5_a11 DATE := fnd_api.g_miss_date
1348: , p5_a12 NUMBER := 0-1962.0724
1349: , p5_a13 DATE := fnd_api.g_miss_date
1350: , p5_a14 NUMBER := 0-1962.0724
1351: )
1352:
1353: as

Line 1487: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1483: , x_return_status out nocopy VARCHAR2
1484: , x_msg_count out nocopy NUMBER
1485: , x_msg_data out nocopy VARCHAR2
1486: , p5_a0 NUMBER := 0-1962.0724
1487: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a2 NUMBER := 0-1962.0724
1489: , p5_a3 NUMBER := 0-1962.0724
1490: , p5_a4 NUMBER := 0-1962.0724
1491: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1491: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1487: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1488: , p5_a2 NUMBER := 0-1962.0724
1489: , p5_a3 NUMBER := 0-1962.0724
1490: , p5_a4 NUMBER := 0-1962.0724
1491: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a7 NUMBER := 0-1962.0724
1494: , p5_a8 NUMBER := 0-1962.0724
1495: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1492: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1488: , p5_a2 NUMBER := 0-1962.0724
1489: , p5_a3 NUMBER := 0-1962.0724
1490: , p5_a4 NUMBER := 0-1962.0724
1491: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a7 NUMBER := 0-1962.0724
1494: , p5_a8 NUMBER := 0-1962.0724
1495: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a10 NUMBER := 0-1962.0724

Line 1495: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1491: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1493: , p5_a7 NUMBER := 0-1962.0724
1494: , p5_a8 NUMBER := 0-1962.0724
1495: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a10 NUMBER := 0-1962.0724
1497: , p5_a11 DATE := fnd_api.g_miss_date
1498: , p5_a12 NUMBER := 0-1962.0724
1499: , p5_a13 DATE := fnd_api.g_miss_date

Line 1497: , p5_a11 DATE := fnd_api.g_miss_date

1493: , p5_a7 NUMBER := 0-1962.0724
1494: , p5_a8 NUMBER := 0-1962.0724
1495: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a10 NUMBER := 0-1962.0724
1497: , p5_a11 DATE := fnd_api.g_miss_date
1498: , p5_a12 NUMBER := 0-1962.0724
1499: , p5_a13 DATE := fnd_api.g_miss_date
1500: , p5_a14 NUMBER := 0-1962.0724
1501: )

Line 1499: , p5_a13 DATE := fnd_api.g_miss_date

1495: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1496: , p5_a10 NUMBER := 0-1962.0724
1497: , p5_a11 DATE := fnd_api.g_miss_date
1498: , p5_a12 NUMBER := 0-1962.0724
1499: , p5_a13 DATE := fnd_api.g_miss_date
1500: , p5_a14 NUMBER := 0-1962.0724
1501: )
1502:
1503: as

Line 1668: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1664: , p6_a12 out nocopy NUMBER
1665: , p6_a13 out nocopy DATE
1666: , p6_a14 out nocopy NUMBER
1667: , p5_a0 NUMBER := 0-1962.0724
1668: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a2 NUMBER := 0-1962.0724
1670: , p5_a3 NUMBER := 0-1962.0724
1671: , p5_a4 NUMBER := 0-1962.0724
1672: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1672: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1668: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a2 NUMBER := 0-1962.0724
1670: , p5_a3 NUMBER := 0-1962.0724
1671: , p5_a4 NUMBER := 0-1962.0724
1672: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a7 NUMBER := 0-1962.0724
1675: , p5_a8 NUMBER := 0-1962.0724
1676: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1673: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1669: , p5_a2 NUMBER := 0-1962.0724
1670: , p5_a3 NUMBER := 0-1962.0724
1671: , p5_a4 NUMBER := 0-1962.0724
1672: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a7 NUMBER := 0-1962.0724
1675: , p5_a8 NUMBER := 0-1962.0724
1676: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1677: , p5_a10 NUMBER := 0-1962.0724

Line 1676: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1672: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a7 NUMBER := 0-1962.0724
1675: , p5_a8 NUMBER := 0-1962.0724
1676: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1677: , p5_a10 NUMBER := 0-1962.0724
1678: , p5_a11 DATE := fnd_api.g_miss_date
1679: , p5_a12 NUMBER := 0-1962.0724
1680: , p5_a13 DATE := fnd_api.g_miss_date

Line 1678: , p5_a11 DATE := fnd_api.g_miss_date

1674: , p5_a7 NUMBER := 0-1962.0724
1675: , p5_a8 NUMBER := 0-1962.0724
1676: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1677: , p5_a10 NUMBER := 0-1962.0724
1678: , p5_a11 DATE := fnd_api.g_miss_date
1679: , p5_a12 NUMBER := 0-1962.0724
1680: , p5_a13 DATE := fnd_api.g_miss_date
1681: , p5_a14 NUMBER := 0-1962.0724
1682: )

Line 1680: , p5_a13 DATE := fnd_api.g_miss_date

1676: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1677: , p5_a10 NUMBER := 0-1962.0724
1678: , p5_a11 DATE := fnd_api.g_miss_date
1679: , p5_a12 NUMBER := 0-1962.0724
1680: , p5_a13 DATE := fnd_api.g_miss_date
1681: , p5_a14 NUMBER := 0-1962.0724
1682: )
1683:
1684: as

Line 1818: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1814: , x_return_status out nocopy VARCHAR2
1815: , x_msg_count out nocopy NUMBER
1816: , x_msg_data out nocopy VARCHAR2
1817: , p5_a0 NUMBER := 0-1962.0724
1818: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1819: , p5_a2 NUMBER := 0-1962.0724
1820: , p5_a3 NUMBER := 0-1962.0724
1821: , p5_a4 NUMBER := 0-1962.0724
1822: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1822: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1818: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1819: , p5_a2 NUMBER := 0-1962.0724
1820: , p5_a3 NUMBER := 0-1962.0724
1821: , p5_a4 NUMBER := 0-1962.0724
1822: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a7 NUMBER := 0-1962.0724
1825: , p5_a8 NUMBER := 0-1962.0724
1826: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1823: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1819: , p5_a2 NUMBER := 0-1962.0724
1820: , p5_a3 NUMBER := 0-1962.0724
1821: , p5_a4 NUMBER := 0-1962.0724
1822: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a7 NUMBER := 0-1962.0724
1825: , p5_a8 NUMBER := 0-1962.0724
1826: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a10 NUMBER := 0-1962.0724

Line 1826: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1822: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1823: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1824: , p5_a7 NUMBER := 0-1962.0724
1825: , p5_a8 NUMBER := 0-1962.0724
1826: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a10 NUMBER := 0-1962.0724
1828: , p5_a11 DATE := fnd_api.g_miss_date
1829: , p5_a12 NUMBER := 0-1962.0724
1830: , p5_a13 DATE := fnd_api.g_miss_date

Line 1828: , p5_a11 DATE := fnd_api.g_miss_date

1824: , p5_a7 NUMBER := 0-1962.0724
1825: , p5_a8 NUMBER := 0-1962.0724
1826: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a10 NUMBER := 0-1962.0724
1828: , p5_a11 DATE := fnd_api.g_miss_date
1829: , p5_a12 NUMBER := 0-1962.0724
1830: , p5_a13 DATE := fnd_api.g_miss_date
1831: , p5_a14 NUMBER := 0-1962.0724
1832: )

Line 1830: , p5_a13 DATE := fnd_api.g_miss_date

1826: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1827: , p5_a10 NUMBER := 0-1962.0724
1828: , p5_a11 DATE := fnd_api.g_miss_date
1829: , p5_a12 NUMBER := 0-1962.0724
1830: , p5_a13 DATE := fnd_api.g_miss_date
1831: , p5_a14 NUMBER := 0-1962.0724
1832: )
1833:
1834: as

Line 1949: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1945: , x_return_status out nocopy VARCHAR2
1946: , x_msg_count out nocopy NUMBER
1947: , x_msg_data out nocopy VARCHAR2
1948: , p5_a0 NUMBER := 0-1962.0724
1949: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a2 NUMBER := 0-1962.0724
1951: , p5_a3 NUMBER := 0-1962.0724
1952: , p5_a4 NUMBER := 0-1962.0724
1953: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1953: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1949: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a2 NUMBER := 0-1962.0724
1951: , p5_a3 NUMBER := 0-1962.0724
1952: , p5_a4 NUMBER := 0-1962.0724
1953: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1954: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a7 NUMBER := 0-1962.0724
1956: , p5_a8 NUMBER := 0-1962.0724
1957: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1954: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1950: , p5_a2 NUMBER := 0-1962.0724
1951: , p5_a3 NUMBER := 0-1962.0724
1952: , p5_a4 NUMBER := 0-1962.0724
1953: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1954: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a7 NUMBER := 0-1962.0724
1956: , p5_a8 NUMBER := 0-1962.0724
1957: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a10 NUMBER := 0-1962.0724

Line 1957: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1953: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1954: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a7 NUMBER := 0-1962.0724
1956: , p5_a8 NUMBER := 0-1962.0724
1957: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a10 NUMBER := 0-1962.0724
1959: , p5_a11 DATE := fnd_api.g_miss_date
1960: , p5_a12 NUMBER := 0-1962.0724
1961: , p5_a13 DATE := fnd_api.g_miss_date

Line 1959: , p5_a11 DATE := fnd_api.g_miss_date

1955: , p5_a7 NUMBER := 0-1962.0724
1956: , p5_a8 NUMBER := 0-1962.0724
1957: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a10 NUMBER := 0-1962.0724
1959: , p5_a11 DATE := fnd_api.g_miss_date
1960: , p5_a12 NUMBER := 0-1962.0724
1961: , p5_a13 DATE := fnd_api.g_miss_date
1962: , p5_a14 NUMBER := 0-1962.0724
1963: )

Line 1961: , p5_a13 DATE := fnd_api.g_miss_date

1957: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a10 NUMBER := 0-1962.0724
1959: , p5_a11 DATE := fnd_api.g_miss_date
1960: , p5_a12 NUMBER := 0-1962.0724
1961: , p5_a13 DATE := fnd_api.g_miss_date
1962: , p5_a14 NUMBER := 0-1962.0724
1963: )
1964:
1965: as