DBA Data[Home] [Help]

APPS.OKL_ACC_GROUP_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 63: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

59: , p8_a10 out nocopy JTF_NUMBER_TABLE
60: , p5_a0 NUMBER := 0-1962.0724
61: , p5_a1 NUMBER := 0-1962.0724
62: , p5_a2 NUMBER := 0-1962.0724
63: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a4 NUMBER := 0-1962.0724
65: , p5_a5 NUMBER := 0-1962.0724
66: , p5_a6 NUMBER := 0-1962.0724
67: , p5_a7 DATE := fnd_api.g_miss_date

Line 67: , p5_a7 DATE := fnd_api.g_miss_date

63: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a4 NUMBER := 0-1962.0724
65: , p5_a5 NUMBER := 0-1962.0724
66: , p5_a6 NUMBER := 0-1962.0724
67: , p5_a7 DATE := fnd_api.g_miss_date
68: , p5_a8 NUMBER := 0-1962.0724
69: , p5_a9 DATE := fnd_api.g_miss_date
70: , p5_a10 NUMBER := 0-1962.0724
71: )

Line 69: , p5_a9 DATE := fnd_api.g_miss_date

65: , p5_a5 NUMBER := 0-1962.0724
66: , p5_a6 NUMBER := 0-1962.0724
67: , p5_a7 DATE := fnd_api.g_miss_date
68: , p5_a8 NUMBER := 0-1962.0724
69: , p5_a9 DATE := fnd_api.g_miss_date
70: , p5_a10 NUMBER := 0-1962.0724
71: )
72:
73: as

Line 200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

196: , p8_a10 out nocopy JTF_NUMBER_TABLE
197: , p5_a0 NUMBER := 0-1962.0724
198: , p5_a1 NUMBER := 0-1962.0724
199: , p5_a2 NUMBER := 0-1962.0724
200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
201: , p5_a4 NUMBER := 0-1962.0724
202: , p5_a5 NUMBER := 0-1962.0724
203: , p5_a6 NUMBER := 0-1962.0724
204: , p5_a7 DATE := fnd_api.g_miss_date

Line 204: , p5_a7 DATE := fnd_api.g_miss_date

200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
201: , p5_a4 NUMBER := 0-1962.0724
202: , p5_a5 NUMBER := 0-1962.0724
203: , p5_a6 NUMBER := 0-1962.0724
204: , p5_a7 DATE := fnd_api.g_miss_date
205: , p5_a8 NUMBER := 0-1962.0724
206: , p5_a9 DATE := fnd_api.g_miss_date
207: , p5_a10 NUMBER := 0-1962.0724
208: )

Line 206: , p5_a9 DATE := fnd_api.g_miss_date

202: , p5_a5 NUMBER := 0-1962.0724
203: , p5_a6 NUMBER := 0-1962.0724
204: , p5_a7 DATE := fnd_api.g_miss_date
205: , p5_a8 NUMBER := 0-1962.0724
206: , p5_a9 DATE := fnd_api.g_miss_date
207: , p5_a10 NUMBER := 0-1962.0724
208: )
209:
210: as

Line 315: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

311: , p6_a10 JTF_NUMBER_TABLE
312: , p5_a0 NUMBER := 0-1962.0724
313: , p5_a1 NUMBER := 0-1962.0724
314: , p5_a2 NUMBER := 0-1962.0724
315: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a4 NUMBER := 0-1962.0724
317: , p5_a5 NUMBER := 0-1962.0724
318: , p5_a6 NUMBER := 0-1962.0724
319: , p5_a7 DATE := fnd_api.g_miss_date

Line 319: , p5_a7 DATE := fnd_api.g_miss_date

315: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a4 NUMBER := 0-1962.0724
317: , p5_a5 NUMBER := 0-1962.0724
318: , p5_a6 NUMBER := 0-1962.0724
319: , p5_a7 DATE := fnd_api.g_miss_date
320: , p5_a8 NUMBER := 0-1962.0724
321: , p5_a9 DATE := fnd_api.g_miss_date
322: , p5_a10 NUMBER := 0-1962.0724
323: )

Line 321: , p5_a9 DATE := fnd_api.g_miss_date

317: , p5_a5 NUMBER := 0-1962.0724
318: , p5_a6 NUMBER := 0-1962.0724
319: , p5_a7 DATE := fnd_api.g_miss_date
320: , p5_a8 NUMBER := 0-1962.0724
321: , p5_a9 DATE := fnd_api.g_miss_date
322: , p5_a10 NUMBER := 0-1962.0724
323: )
324:
325: as

Line 484: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

480: , p6_a10 out nocopy NUMBER
481: , p5_a0 NUMBER := 0-1962.0724
482: , p5_a1 NUMBER := 0-1962.0724
483: , p5_a2 NUMBER := 0-1962.0724
484: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a4 NUMBER := 0-1962.0724
486: , p5_a5 NUMBER := 0-1962.0724
487: , p5_a6 NUMBER := 0-1962.0724
488: , p5_a7 DATE := fnd_api.g_miss_date

Line 488: , p5_a7 DATE := fnd_api.g_miss_date

484: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a4 NUMBER := 0-1962.0724
486: , p5_a5 NUMBER := 0-1962.0724
487: , p5_a6 NUMBER := 0-1962.0724
488: , p5_a7 DATE := fnd_api.g_miss_date
489: , p5_a8 NUMBER := 0-1962.0724
490: , p5_a9 DATE := fnd_api.g_miss_date
491: , p5_a10 NUMBER := 0-1962.0724
492: )

Line 490: , p5_a9 DATE := fnd_api.g_miss_date

486: , p5_a5 NUMBER := 0-1962.0724
487: , p5_a6 NUMBER := 0-1962.0724
488: , p5_a7 DATE := fnd_api.g_miss_date
489: , p5_a8 NUMBER := 0-1962.0724
490: , p5_a9 DATE := fnd_api.g_miss_date
491: , p5_a10 NUMBER := 0-1962.0724
492: )
493:
494: as

Line 614: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

610: , x_msg_data out nocopy VARCHAR2
611: , p5_a0 NUMBER := 0-1962.0724
612: , p5_a1 NUMBER := 0-1962.0724
613: , p5_a2 NUMBER := 0-1962.0724
614: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 NUMBER := 0-1962.0724
617: , p5_a6 NUMBER := 0-1962.0724
618: , p5_a7 DATE := fnd_api.g_miss_date

Line 618: , p5_a7 DATE := fnd_api.g_miss_date

614: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 NUMBER := 0-1962.0724
617: , p5_a6 NUMBER := 0-1962.0724
618: , p5_a7 DATE := fnd_api.g_miss_date
619: , p5_a8 NUMBER := 0-1962.0724
620: , p5_a9 DATE := fnd_api.g_miss_date
621: , p5_a10 NUMBER := 0-1962.0724
622: )

Line 620: , p5_a9 DATE := fnd_api.g_miss_date

616: , p5_a5 NUMBER := 0-1962.0724
617: , p5_a6 NUMBER := 0-1962.0724
618: , p5_a7 DATE := fnd_api.g_miss_date
619: , p5_a8 NUMBER := 0-1962.0724
620: , p5_a9 DATE := fnd_api.g_miss_date
621: , p5_a10 NUMBER := 0-1962.0724
622: )
623:
624: as

Line 767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

763: , p6_a10 out nocopy NUMBER
764: , p5_a0 NUMBER := 0-1962.0724
765: , p5_a1 NUMBER := 0-1962.0724
766: , p5_a2 NUMBER := 0-1962.0724
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 NUMBER := 0-1962.0724
770: , p5_a6 NUMBER := 0-1962.0724
771: , p5_a7 DATE := fnd_api.g_miss_date

Line 771: , p5_a7 DATE := fnd_api.g_miss_date

767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 NUMBER := 0-1962.0724
770: , p5_a6 NUMBER := 0-1962.0724
771: , p5_a7 DATE := fnd_api.g_miss_date
772: , p5_a8 NUMBER := 0-1962.0724
773: , p5_a9 DATE := fnd_api.g_miss_date
774: , p5_a10 NUMBER := 0-1962.0724
775: )

Line 773: , p5_a9 DATE := fnd_api.g_miss_date

769: , p5_a5 NUMBER := 0-1962.0724
770: , p5_a6 NUMBER := 0-1962.0724
771: , p5_a7 DATE := fnd_api.g_miss_date
772: , p5_a8 NUMBER := 0-1962.0724
773: , p5_a9 DATE := fnd_api.g_miss_date
774: , p5_a10 NUMBER := 0-1962.0724
775: )
776:
777: as

Line 897: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

893: , x_msg_data out nocopy VARCHAR2
894: , p5_a0 NUMBER := 0-1962.0724
895: , p5_a1 NUMBER := 0-1962.0724
896: , p5_a2 NUMBER := 0-1962.0724
897: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a4 NUMBER := 0-1962.0724
899: , p5_a5 NUMBER := 0-1962.0724
900: , p5_a6 NUMBER := 0-1962.0724
901: , p5_a7 DATE := fnd_api.g_miss_date

Line 901: , p5_a7 DATE := fnd_api.g_miss_date

897: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a4 NUMBER := 0-1962.0724
899: , p5_a5 NUMBER := 0-1962.0724
900: , p5_a6 NUMBER := 0-1962.0724
901: , p5_a7 DATE := fnd_api.g_miss_date
902: , p5_a8 NUMBER := 0-1962.0724
903: , p5_a9 DATE := fnd_api.g_miss_date
904: , p5_a10 NUMBER := 0-1962.0724
905: )

Line 903: , p5_a9 DATE := fnd_api.g_miss_date

899: , p5_a5 NUMBER := 0-1962.0724
900: , p5_a6 NUMBER := 0-1962.0724
901: , p5_a7 DATE := fnd_api.g_miss_date
902: , p5_a8 NUMBER := 0-1962.0724
903: , p5_a9 DATE := fnd_api.g_miss_date
904: , p5_a10 NUMBER := 0-1962.0724
905: )
906:
907: as

Line 1012: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1008: , x_msg_data out nocopy VARCHAR2
1009: , p5_a0 NUMBER := 0-1962.0724
1010: , p5_a1 NUMBER := 0-1962.0724
1011: , p5_a2 NUMBER := 0-1962.0724
1012: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a4 NUMBER := 0-1962.0724
1014: , p5_a5 NUMBER := 0-1962.0724
1015: , p5_a6 NUMBER := 0-1962.0724
1016: , p5_a7 DATE := fnd_api.g_miss_date

Line 1016: , p5_a7 DATE := fnd_api.g_miss_date

1012: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a4 NUMBER := 0-1962.0724
1014: , p5_a5 NUMBER := 0-1962.0724
1015: , p5_a6 NUMBER := 0-1962.0724
1016: , p5_a7 DATE := fnd_api.g_miss_date
1017: , p5_a8 NUMBER := 0-1962.0724
1018: , p5_a9 DATE := fnd_api.g_miss_date
1019: , p5_a10 NUMBER := 0-1962.0724
1020: )

Line 1018: , p5_a9 DATE := fnd_api.g_miss_date

1014: , p5_a5 NUMBER := 0-1962.0724
1015: , p5_a6 NUMBER := 0-1962.0724
1016: , p5_a7 DATE := fnd_api.g_miss_date
1017: , p5_a8 NUMBER := 0-1962.0724
1018: , p5_a9 DATE := fnd_api.g_miss_date
1019: , p5_a10 NUMBER := 0-1962.0724
1020: )
1021:
1022: as

Line 1166: , p5_a4 DATE := fnd_api.g_miss_date

1162: , p5_a0 NUMBER := 0-1962.0724
1163: , p5_a1 NUMBER := 0-1962.0724
1164: , p5_a2 NUMBER := 0-1962.0724
1165: , p5_a3 NUMBER := 0-1962.0724
1166: , p5_a4 DATE := fnd_api.g_miss_date
1167: , p5_a5 NUMBER := 0-1962.0724
1168: , p5_a6 NUMBER := 0-1962.0724
1169: , p5_a7 DATE := fnd_api.g_miss_date
1170: , p5_a8 NUMBER := 0-1962.0724

Line 1169: , p5_a7 DATE := fnd_api.g_miss_date

1165: , p5_a3 NUMBER := 0-1962.0724
1166: , p5_a4 DATE := fnd_api.g_miss_date
1167: , p5_a5 NUMBER := 0-1962.0724
1168: , p5_a6 NUMBER := 0-1962.0724
1169: , p5_a7 DATE := fnd_api.g_miss_date
1170: , p5_a8 NUMBER := 0-1962.0724
1171: , p5_a9 DATE := fnd_api.g_miss_date
1172: , p5_a10 NUMBER := 0-1962.0724
1173: )

Line 1171: , p5_a9 DATE := fnd_api.g_miss_date

1167: , p5_a5 NUMBER := 0-1962.0724
1168: , p5_a6 NUMBER := 0-1962.0724
1169: , p5_a7 DATE := fnd_api.g_miss_date
1170: , p5_a8 NUMBER := 0-1962.0724
1171: , p5_a9 DATE := fnd_api.g_miss_date
1172: , p5_a10 NUMBER := 0-1962.0724
1173: )
1174:
1175: as

Line 1296: , p5_a4 DATE := fnd_api.g_miss_date

1292: , p5_a0 NUMBER := 0-1962.0724
1293: , p5_a1 NUMBER := 0-1962.0724
1294: , p5_a2 NUMBER := 0-1962.0724
1295: , p5_a3 NUMBER := 0-1962.0724
1296: , p5_a4 DATE := fnd_api.g_miss_date
1297: , p5_a5 NUMBER := 0-1962.0724
1298: , p5_a6 NUMBER := 0-1962.0724
1299: , p5_a7 DATE := fnd_api.g_miss_date
1300: , p5_a8 NUMBER := 0-1962.0724

Line 1299: , p5_a7 DATE := fnd_api.g_miss_date

1295: , p5_a3 NUMBER := 0-1962.0724
1296: , p5_a4 DATE := fnd_api.g_miss_date
1297: , p5_a5 NUMBER := 0-1962.0724
1298: , p5_a6 NUMBER := 0-1962.0724
1299: , p5_a7 DATE := fnd_api.g_miss_date
1300: , p5_a8 NUMBER := 0-1962.0724
1301: , p5_a9 DATE := fnd_api.g_miss_date
1302: , p5_a10 NUMBER := 0-1962.0724
1303: )

Line 1301: , p5_a9 DATE := fnd_api.g_miss_date

1297: , p5_a5 NUMBER := 0-1962.0724
1298: , p5_a6 NUMBER := 0-1962.0724
1299: , p5_a7 DATE := fnd_api.g_miss_date
1300: , p5_a8 NUMBER := 0-1962.0724
1301: , p5_a9 DATE := fnd_api.g_miss_date
1302: , p5_a10 NUMBER := 0-1962.0724
1303: )
1304:
1305: as

Line 1449: , p5_a4 DATE := fnd_api.g_miss_date

1445: , p5_a0 NUMBER := 0-1962.0724
1446: , p5_a1 NUMBER := 0-1962.0724
1447: , p5_a2 NUMBER := 0-1962.0724
1448: , p5_a3 NUMBER := 0-1962.0724
1449: , p5_a4 DATE := fnd_api.g_miss_date
1450: , p5_a5 NUMBER := 0-1962.0724
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 DATE := fnd_api.g_miss_date
1453: , p5_a8 NUMBER := 0-1962.0724

Line 1452: , p5_a7 DATE := fnd_api.g_miss_date

1448: , p5_a3 NUMBER := 0-1962.0724
1449: , p5_a4 DATE := fnd_api.g_miss_date
1450: , p5_a5 NUMBER := 0-1962.0724
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 DATE := fnd_api.g_miss_date
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 DATE := fnd_api.g_miss_date
1455: , p5_a10 NUMBER := 0-1962.0724
1456: )

Line 1454: , p5_a9 DATE := fnd_api.g_miss_date

1450: , p5_a5 NUMBER := 0-1962.0724
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 DATE := fnd_api.g_miss_date
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 DATE := fnd_api.g_miss_date
1455: , p5_a10 NUMBER := 0-1962.0724
1456: )
1457:
1458: as

Line 1579: , p5_a4 DATE := fnd_api.g_miss_date

1575: , p5_a0 NUMBER := 0-1962.0724
1576: , p5_a1 NUMBER := 0-1962.0724
1577: , p5_a2 NUMBER := 0-1962.0724
1578: , p5_a3 NUMBER := 0-1962.0724
1579: , p5_a4 DATE := fnd_api.g_miss_date
1580: , p5_a5 NUMBER := 0-1962.0724
1581: , p5_a6 NUMBER := 0-1962.0724
1582: , p5_a7 DATE := fnd_api.g_miss_date
1583: , p5_a8 NUMBER := 0-1962.0724

Line 1582: , p5_a7 DATE := fnd_api.g_miss_date

1578: , p5_a3 NUMBER := 0-1962.0724
1579: , p5_a4 DATE := fnd_api.g_miss_date
1580: , p5_a5 NUMBER := 0-1962.0724
1581: , p5_a6 NUMBER := 0-1962.0724
1582: , p5_a7 DATE := fnd_api.g_miss_date
1583: , p5_a8 NUMBER := 0-1962.0724
1584: , p5_a9 DATE := fnd_api.g_miss_date
1585: , p5_a10 NUMBER := 0-1962.0724
1586: )

Line 1584: , p5_a9 DATE := fnd_api.g_miss_date

1580: , p5_a5 NUMBER := 0-1962.0724
1581: , p5_a6 NUMBER := 0-1962.0724
1582: , p5_a7 DATE := fnd_api.g_miss_date
1583: , p5_a8 NUMBER := 0-1962.0724
1584: , p5_a9 DATE := fnd_api.g_miss_date
1585: , p5_a10 NUMBER := 0-1962.0724
1586: )
1587:
1588: as

Line 1694: , p5_a4 DATE := fnd_api.g_miss_date

1690: , p5_a0 NUMBER := 0-1962.0724
1691: , p5_a1 NUMBER := 0-1962.0724
1692: , p5_a2 NUMBER := 0-1962.0724
1693: , p5_a3 NUMBER := 0-1962.0724
1694: , p5_a4 DATE := fnd_api.g_miss_date
1695: , p5_a5 NUMBER := 0-1962.0724
1696: , p5_a6 NUMBER := 0-1962.0724
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 NUMBER := 0-1962.0724

Line 1697: , p5_a7 DATE := fnd_api.g_miss_date

1693: , p5_a3 NUMBER := 0-1962.0724
1694: , p5_a4 DATE := fnd_api.g_miss_date
1695: , p5_a5 NUMBER := 0-1962.0724
1696: , p5_a6 NUMBER := 0-1962.0724
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 NUMBER := 0-1962.0724
1699: , p5_a9 DATE := fnd_api.g_miss_date
1700: , p5_a10 NUMBER := 0-1962.0724
1701: )

Line 1699: , p5_a9 DATE := fnd_api.g_miss_date

1695: , p5_a5 NUMBER := 0-1962.0724
1696: , p5_a6 NUMBER := 0-1962.0724
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 NUMBER := 0-1962.0724
1699: , p5_a9 DATE := fnd_api.g_miss_date
1700: , p5_a10 NUMBER := 0-1962.0724
1701: )
1702:
1703: as