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
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;
47: , p6_a20 out nocopy VARCHAR2
48: , p6_a21 out nocopy VARCHAR2
49: , p5_a0 NUMBER := 0-1962.0724
50: , p5_a1 NUMBER := 0-1962.0724
51: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 NUMBER := 0-1962.0724
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 NUMBER := 0-1962.0724
48: , p6_a21 out nocopy VARCHAR2
49: , p5_a0 NUMBER := 0-1962.0724
50: , p5_a1 NUMBER := 0-1962.0724
51: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 NUMBER := 0-1962.0724
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 NUMBER := 0-1962.0724
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 NUMBER := 0-1962.0724
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 NUMBER := 0-1962.0724
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
53: , p5_a4 NUMBER := 0-1962.0724
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 NUMBER := 0-1962.0724
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a12 NUMBER := 0-1962.0724
54: , p5_a5 NUMBER := 0-1962.0724
55: , p5_a6 NUMBER := 0-1962.0724
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
55: , p5_a6 NUMBER := 0-1962.0724
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date
56: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date
64: , p5_a15 NUMBER := 0-1962.0724
59: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date
64: , p5_a15 NUMBER := 0-1962.0724
65: , p5_a16 DATE := fnd_api.g_miss_date
66: , p5_a17 NUMBER := 0-1962.0724
67: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a12 NUMBER := 0-1962.0724
62: , p5_a13 NUMBER := 0-1962.0724
63: , p5_a14 DATE := fnd_api.g_miss_date
64: , p5_a15 NUMBER := 0-1962.0724
65: , p5_a16 DATE := fnd_api.g_miss_date
66: , p5_a17 NUMBER := 0-1962.0724
67: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a14 DATE := fnd_api.g_miss_date
64: , p5_a15 NUMBER := 0-1962.0724
65: , p5_a16 DATE := fnd_api.g_miss_date
66: , p5_a17 NUMBER := 0-1962.0724
67: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
71: )
64: , p5_a15 NUMBER := 0-1962.0724
65: , p5_a16 DATE := fnd_api.g_miss_date
66: , p5_a17 NUMBER := 0-1962.0724
67: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
71: )
72:
65: , p5_a16 DATE := fnd_api.g_miss_date
66: , p5_a17 NUMBER := 0-1962.0724
67: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
71: )
72:
73: as
66: , p5_a17 NUMBER := 0-1962.0724
67: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
71: )
72:
73: as
74: ddp_tryv_rec okl_process_trx_types_pvt.tryv_rec_type;
303: , p6_a20 out nocopy VARCHAR2
304: , p6_a21 out nocopy VARCHAR2
305: , p5_a0 NUMBER := 0-1962.0724
306: , p5_a1 NUMBER := 0-1962.0724
307: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
309: , p5_a4 NUMBER := 0-1962.0724
310: , p5_a5 NUMBER := 0-1962.0724
311: , p5_a6 NUMBER := 0-1962.0724
304: , p6_a21 out nocopy VARCHAR2
305: , p5_a0 NUMBER := 0-1962.0724
306: , p5_a1 NUMBER := 0-1962.0724
307: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
309: , p5_a4 NUMBER := 0-1962.0724
310: , p5_a5 NUMBER := 0-1962.0724
311: , p5_a6 NUMBER := 0-1962.0724
312: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
309: , p5_a4 NUMBER := 0-1962.0724
310: , p5_a5 NUMBER := 0-1962.0724
311: , p5_a6 NUMBER := 0-1962.0724
312: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
315: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
309: , p5_a4 NUMBER := 0-1962.0724
310: , p5_a5 NUMBER := 0-1962.0724
311: , p5_a6 NUMBER := 0-1962.0724
312: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
315: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
317: , p5_a12 NUMBER := 0-1962.0724
310: , p5_a5 NUMBER := 0-1962.0724
311: , p5_a6 NUMBER := 0-1962.0724
312: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
315: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
317: , p5_a12 NUMBER := 0-1962.0724
318: , p5_a13 NUMBER := 0-1962.0724
311: , p5_a6 NUMBER := 0-1962.0724
312: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
315: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
317: , p5_a12 NUMBER := 0-1962.0724
318: , p5_a13 NUMBER := 0-1962.0724
319: , p5_a14 DATE := fnd_api.g_miss_date
312: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
315: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
317: , p5_a12 NUMBER := 0-1962.0724
318: , p5_a13 NUMBER := 0-1962.0724
319: , p5_a14 DATE := fnd_api.g_miss_date
320: , p5_a15 NUMBER := 0-1962.0724
315: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
316: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
317: , p5_a12 NUMBER := 0-1962.0724
318: , p5_a13 NUMBER := 0-1962.0724
319: , p5_a14 DATE := fnd_api.g_miss_date
320: , p5_a15 NUMBER := 0-1962.0724
321: , p5_a16 DATE := fnd_api.g_miss_date
322: , p5_a17 NUMBER := 0-1962.0724
323: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
317: , p5_a12 NUMBER := 0-1962.0724
318: , p5_a13 NUMBER := 0-1962.0724
319: , p5_a14 DATE := fnd_api.g_miss_date
320: , p5_a15 NUMBER := 0-1962.0724
321: , p5_a16 DATE := fnd_api.g_miss_date
322: , p5_a17 NUMBER := 0-1962.0724
323: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
324: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
325: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
319: , p5_a14 DATE := fnd_api.g_miss_date
320: , p5_a15 NUMBER := 0-1962.0724
321: , p5_a16 DATE := fnd_api.g_miss_date
322: , p5_a17 NUMBER := 0-1962.0724
323: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
324: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
325: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
326: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
327: )
320: , p5_a15 NUMBER := 0-1962.0724
321: , p5_a16 DATE := fnd_api.g_miss_date
322: , p5_a17 NUMBER := 0-1962.0724
323: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
324: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
325: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
326: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
327: )
328:
321: , p5_a16 DATE := fnd_api.g_miss_date
322: , p5_a17 NUMBER := 0-1962.0724
323: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
324: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
325: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
326: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
327: )
328:
329: as
322: , p5_a17 NUMBER := 0-1962.0724
323: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
324: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
325: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
326: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
327: )
328:
329: as
330: ddp_tryv_rec okl_process_trx_types_pvt.tryv_rec_type;
537: , x_msg_count out nocopy NUMBER
538: , x_msg_data out nocopy VARCHAR2
539: , p5_a0 NUMBER := 0-1962.0724
540: , p5_a1 NUMBER := 0-1962.0724
541: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a4 NUMBER := 0-1962.0724
544: , p5_a5 NUMBER := 0-1962.0724
545: , p5_a6 NUMBER := 0-1962.0724
538: , x_msg_data out nocopy VARCHAR2
539: , p5_a0 NUMBER := 0-1962.0724
540: , p5_a1 NUMBER := 0-1962.0724
541: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a4 NUMBER := 0-1962.0724
544: , p5_a5 NUMBER := 0-1962.0724
545: , p5_a6 NUMBER := 0-1962.0724
546: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a4 NUMBER := 0-1962.0724
544: , p5_a5 NUMBER := 0-1962.0724
545: , p5_a6 NUMBER := 0-1962.0724
546: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a4 NUMBER := 0-1962.0724
544: , p5_a5 NUMBER := 0-1962.0724
545: , p5_a6 NUMBER := 0-1962.0724
546: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a12 NUMBER := 0-1962.0724
544: , p5_a5 NUMBER := 0-1962.0724
545: , p5_a6 NUMBER := 0-1962.0724
546: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a12 NUMBER := 0-1962.0724
552: , p5_a13 NUMBER := 0-1962.0724
545: , p5_a6 NUMBER := 0-1962.0724
546: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a12 NUMBER := 0-1962.0724
552: , p5_a13 NUMBER := 0-1962.0724
553: , p5_a14 DATE := fnd_api.g_miss_date
546: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a12 NUMBER := 0-1962.0724
552: , p5_a13 NUMBER := 0-1962.0724
553: , p5_a14 DATE := fnd_api.g_miss_date
554: , p5_a15 NUMBER := 0-1962.0724
549: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a12 NUMBER := 0-1962.0724
552: , p5_a13 NUMBER := 0-1962.0724
553: , p5_a14 DATE := fnd_api.g_miss_date
554: , p5_a15 NUMBER := 0-1962.0724
555: , p5_a16 DATE := fnd_api.g_miss_date
556: , p5_a17 NUMBER := 0-1962.0724
557: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a12 NUMBER := 0-1962.0724
552: , p5_a13 NUMBER := 0-1962.0724
553: , p5_a14 DATE := fnd_api.g_miss_date
554: , p5_a15 NUMBER := 0-1962.0724
555: , p5_a16 DATE := fnd_api.g_miss_date
556: , p5_a17 NUMBER := 0-1962.0724
557: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a14 DATE := fnd_api.g_miss_date
554: , p5_a15 NUMBER := 0-1962.0724
555: , p5_a16 DATE := fnd_api.g_miss_date
556: , p5_a17 NUMBER := 0-1962.0724
557: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
561: )
554: , p5_a15 NUMBER := 0-1962.0724
555: , p5_a16 DATE := fnd_api.g_miss_date
556: , p5_a17 NUMBER := 0-1962.0724
557: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
561: )
562:
555: , p5_a16 DATE := fnd_api.g_miss_date
556: , p5_a17 NUMBER := 0-1962.0724
557: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
561: )
562:
563: as
556: , p5_a17 NUMBER := 0-1962.0724
557: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
559: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
560: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
561: )
562:
563: as
564: ddp_tryv_rec okl_process_trx_types_pvt.tryv_rec_type;