DBA Data[Home] [Help]

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

120: , p6_a8 out nocopy NUMBER
121: , p6_a9 out nocopy DATE
122: , p6_a10 out nocopy NUMBER
123: , p5_a0 NUMBER := 0-1962.0724
124: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a2 NUMBER := 0-1962.0724
126: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a4 NUMBER := 0-1962.0724
128: , p5_a5 NUMBER := 0-1962.0724

Line 126: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

122: , p6_a10 out nocopy NUMBER
123: , p5_a0 NUMBER := 0-1962.0724
124: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a2 NUMBER := 0-1962.0724
126: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a4 NUMBER := 0-1962.0724
128: , p5_a5 NUMBER := 0-1962.0724
129: , p5_a6 NUMBER := 0-1962.0724
130: , p5_a7 DATE := fnd_api.g_miss_date

Line 130: , p5_a7 DATE := fnd_api.g_miss_date

126: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a4 NUMBER := 0-1962.0724
128: , p5_a5 NUMBER := 0-1962.0724
129: , p5_a6 NUMBER := 0-1962.0724
130: , p5_a7 DATE := fnd_api.g_miss_date
131: , p5_a8 NUMBER := 0-1962.0724
132: , p5_a9 DATE := fnd_api.g_miss_date
133: , p5_a10 NUMBER := 0-1962.0724
134: )

Line 132: , p5_a9 DATE := fnd_api.g_miss_date

128: , p5_a5 NUMBER := 0-1962.0724
129: , p5_a6 NUMBER := 0-1962.0724
130: , p5_a7 DATE := fnd_api.g_miss_date
131: , p5_a8 NUMBER := 0-1962.0724
132: , p5_a9 DATE := fnd_api.g_miss_date
133: , p5_a10 NUMBER := 0-1962.0724
134: )
135:
136: as

Line 254: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

250: , x_return_status out nocopy VARCHAR2
251: , x_msg_count out nocopy NUMBER
252: , x_msg_data out nocopy VARCHAR2
253: , p5_a0 NUMBER := 0-1962.0724
254: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a2 NUMBER := 0-1962.0724
256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a4 NUMBER := 0-1962.0724
258: , p5_a5 NUMBER := 0-1962.0724

Line 256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

252: , x_msg_data out nocopy VARCHAR2
253: , p5_a0 NUMBER := 0-1962.0724
254: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a2 NUMBER := 0-1962.0724
256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a4 NUMBER := 0-1962.0724
258: , p5_a5 NUMBER := 0-1962.0724
259: , p5_a6 NUMBER := 0-1962.0724
260: , p5_a7 DATE := fnd_api.g_miss_date

Line 260: , p5_a7 DATE := fnd_api.g_miss_date

256: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a4 NUMBER := 0-1962.0724
258: , p5_a5 NUMBER := 0-1962.0724
259: , p5_a6 NUMBER := 0-1962.0724
260: , p5_a7 DATE := fnd_api.g_miss_date
261: , p5_a8 NUMBER := 0-1962.0724
262: , p5_a9 DATE := fnd_api.g_miss_date
263: , p5_a10 NUMBER := 0-1962.0724
264: )

Line 262: , p5_a9 DATE := fnd_api.g_miss_date

258: , p5_a5 NUMBER := 0-1962.0724
259: , p5_a6 NUMBER := 0-1962.0724
260: , p5_a7 DATE := fnd_api.g_miss_date
261: , p5_a8 NUMBER := 0-1962.0724
262: , p5_a9 DATE := fnd_api.g_miss_date
263: , p5_a10 NUMBER := 0-1962.0724
264: )
265:
266: as

Line 407: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

403: , p6_a8 out nocopy NUMBER
404: , p6_a9 out nocopy DATE
405: , p6_a10 out nocopy NUMBER
406: , p5_a0 NUMBER := 0-1962.0724
407: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a2 NUMBER := 0-1962.0724
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 NUMBER := 0-1962.0724
411: , p5_a5 NUMBER := 0-1962.0724

Line 409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

405: , p6_a10 out nocopy NUMBER
406: , p5_a0 NUMBER := 0-1962.0724
407: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a2 NUMBER := 0-1962.0724
409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 NUMBER := 0-1962.0724
411: , p5_a5 NUMBER := 0-1962.0724
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date

Line 413: , p5_a7 DATE := fnd_api.g_miss_date

409: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a4 NUMBER := 0-1962.0724
411: , p5_a5 NUMBER := 0-1962.0724
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724
415: , p5_a9 DATE := fnd_api.g_miss_date
416: , p5_a10 NUMBER := 0-1962.0724
417: )

Line 415: , p5_a9 DATE := fnd_api.g_miss_date

411: , p5_a5 NUMBER := 0-1962.0724
412: , p5_a6 NUMBER := 0-1962.0724
413: , p5_a7 DATE := fnd_api.g_miss_date
414: , p5_a8 NUMBER := 0-1962.0724
415: , p5_a9 DATE := fnd_api.g_miss_date
416: , p5_a10 NUMBER := 0-1962.0724
417: )
418:
419: as

Line 537: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

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

Line 539: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 543: , p5_a7 DATE := fnd_api.g_miss_date

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

Line 545: , p5_a9 DATE := fnd_api.g_miss_date

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

Line 652: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

648: , x_return_status out nocopy VARCHAR2
649: , x_msg_count out nocopy NUMBER
650: , x_msg_data out nocopy VARCHAR2
651: , p5_a0 NUMBER := 0-1962.0724
652: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a2 NUMBER := 0-1962.0724
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 NUMBER := 0-1962.0724
656: , p5_a5 NUMBER := 0-1962.0724

Line 654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

650: , x_msg_data out nocopy VARCHAR2
651: , p5_a0 NUMBER := 0-1962.0724
652: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a2 NUMBER := 0-1962.0724
654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 NUMBER := 0-1962.0724
656: , p5_a5 NUMBER := 0-1962.0724
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date

Line 658: , p5_a7 DATE := fnd_api.g_miss_date

654: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a4 NUMBER := 0-1962.0724
656: , p5_a5 NUMBER := 0-1962.0724
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724
660: , p5_a9 DATE := fnd_api.g_miss_date
661: , p5_a10 NUMBER := 0-1962.0724
662: )

Line 660: , p5_a9 DATE := fnd_api.g_miss_date

656: , p5_a5 NUMBER := 0-1962.0724
657: , p5_a6 NUMBER := 0-1962.0724
658: , p5_a7 DATE := fnd_api.g_miss_date
659: , p5_a8 NUMBER := 0-1962.0724
660: , p5_a9 DATE := fnd_api.g_miss_date
661: , p5_a10 NUMBER := 0-1962.0724
662: )
663:
664: as