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_trx_types_pub.tryv_rec_type;
281: , x_msg_count out nocopy NUMBER
282: , x_msg_data out nocopy VARCHAR2
283: , p5_a0 NUMBER := 0-1962.0724
284: , p5_a1 NUMBER := 0-1962.0724
285: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a4 NUMBER := 0-1962.0724
288: , p5_a5 NUMBER := 0-1962.0724
289: , p5_a6 NUMBER := 0-1962.0724
282: , x_msg_data out nocopy VARCHAR2
283: , p5_a0 NUMBER := 0-1962.0724
284: , p5_a1 NUMBER := 0-1962.0724
285: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a4 NUMBER := 0-1962.0724
288: , p5_a5 NUMBER := 0-1962.0724
289: , p5_a6 NUMBER := 0-1962.0724
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a4 NUMBER := 0-1962.0724
288: , p5_a5 NUMBER := 0-1962.0724
289: , p5_a6 NUMBER := 0-1962.0724
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a4 NUMBER := 0-1962.0724
288: , p5_a5 NUMBER := 0-1962.0724
289: , p5_a6 NUMBER := 0-1962.0724
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 NUMBER := 0-1962.0724
288: , p5_a5 NUMBER := 0-1962.0724
289: , p5_a6 NUMBER := 0-1962.0724
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 NUMBER := 0-1962.0724
296: , p5_a13 NUMBER := 0-1962.0724
289: , p5_a6 NUMBER := 0-1962.0724
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 NUMBER := 0-1962.0724
296: , p5_a13 NUMBER := 0-1962.0724
297: , p5_a14 DATE := fnd_api.g_miss_date
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
292: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 NUMBER := 0-1962.0724
296: , p5_a13 NUMBER := 0-1962.0724
297: , p5_a14 DATE := fnd_api.g_miss_date
298: , p5_a15 NUMBER := 0-1962.0724
293: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 NUMBER := 0-1962.0724
296: , p5_a13 NUMBER := 0-1962.0724
297: , p5_a14 DATE := fnd_api.g_miss_date
298: , p5_a15 NUMBER := 0-1962.0724
299: , p5_a16 DATE := fnd_api.g_miss_date
300: , p5_a17 NUMBER := 0-1962.0724
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 NUMBER := 0-1962.0724
296: , p5_a13 NUMBER := 0-1962.0724
297: , p5_a14 DATE := fnd_api.g_miss_date
298: , p5_a15 NUMBER := 0-1962.0724
299: , p5_a16 DATE := fnd_api.g_miss_date
300: , p5_a17 NUMBER := 0-1962.0724
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 DATE := fnd_api.g_miss_date
298: , p5_a15 NUMBER := 0-1962.0724
299: , p5_a16 DATE := fnd_api.g_miss_date
300: , p5_a17 NUMBER := 0-1962.0724
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
305: )
298: , p5_a15 NUMBER := 0-1962.0724
299: , p5_a16 DATE := fnd_api.g_miss_date
300: , p5_a17 NUMBER := 0-1962.0724
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
305: )
306:
299: , p5_a16 DATE := fnd_api.g_miss_date
300: , p5_a17 NUMBER := 0-1962.0724
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
305: )
306:
307: as
300: , p5_a17 NUMBER := 0-1962.0724
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
305: )
306:
307: as
308: ddp_tryv_rec okl_trx_types_pub.tryv_rec_type;
462: , p6_a20 out nocopy VARCHAR2
463: , p6_a21 out nocopy VARCHAR2
464: , p5_a0 NUMBER := 0-1962.0724
465: , p5_a1 NUMBER := 0-1962.0724
466: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a4 NUMBER := 0-1962.0724
469: , p5_a5 NUMBER := 0-1962.0724
470: , p5_a6 NUMBER := 0-1962.0724
463: , p6_a21 out nocopy VARCHAR2
464: , p5_a0 NUMBER := 0-1962.0724
465: , p5_a1 NUMBER := 0-1962.0724
466: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a4 NUMBER := 0-1962.0724
469: , p5_a5 NUMBER := 0-1962.0724
470: , p5_a6 NUMBER := 0-1962.0724
471: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a4 NUMBER := 0-1962.0724
469: , p5_a5 NUMBER := 0-1962.0724
470: , p5_a6 NUMBER := 0-1962.0724
471: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a4 NUMBER := 0-1962.0724
469: , p5_a5 NUMBER := 0-1962.0724
470: , p5_a6 NUMBER := 0-1962.0724
471: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a12 NUMBER := 0-1962.0724
469: , p5_a5 NUMBER := 0-1962.0724
470: , p5_a6 NUMBER := 0-1962.0724
471: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a12 NUMBER := 0-1962.0724
477: , p5_a13 NUMBER := 0-1962.0724
470: , p5_a6 NUMBER := 0-1962.0724
471: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a12 NUMBER := 0-1962.0724
477: , p5_a13 NUMBER := 0-1962.0724
478: , p5_a14 DATE := fnd_api.g_miss_date
471: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
473: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
474: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a12 NUMBER := 0-1962.0724
477: , p5_a13 NUMBER := 0-1962.0724
478: , p5_a14 DATE := fnd_api.g_miss_date
479: , p5_a15 NUMBER := 0-1962.0724
474: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a12 NUMBER := 0-1962.0724
477: , p5_a13 NUMBER := 0-1962.0724
478: , p5_a14 DATE := fnd_api.g_miss_date
479: , p5_a15 NUMBER := 0-1962.0724
480: , p5_a16 DATE := fnd_api.g_miss_date
481: , p5_a17 NUMBER := 0-1962.0724
482: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a12 NUMBER := 0-1962.0724
477: , p5_a13 NUMBER := 0-1962.0724
478: , p5_a14 DATE := fnd_api.g_miss_date
479: , p5_a15 NUMBER := 0-1962.0724
480: , p5_a16 DATE := fnd_api.g_miss_date
481: , p5_a17 NUMBER := 0-1962.0724
482: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a14 DATE := fnd_api.g_miss_date
479: , p5_a15 NUMBER := 0-1962.0724
480: , p5_a16 DATE := fnd_api.g_miss_date
481: , p5_a17 NUMBER := 0-1962.0724
482: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
486: )
479: , p5_a15 NUMBER := 0-1962.0724
480: , p5_a16 DATE := fnd_api.g_miss_date
481: , p5_a17 NUMBER := 0-1962.0724
482: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
486: )
487:
480: , p5_a16 DATE := fnd_api.g_miss_date
481: , p5_a17 NUMBER := 0-1962.0724
482: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
486: )
487:
488: as
481: , p5_a17 NUMBER := 0-1962.0724
482: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
486: )
487:
488: as
489: ddp_tryv_rec okl_trx_types_pub.tryv_rec_type;
696: , x_msg_count out nocopy NUMBER
697: , x_msg_data out nocopy VARCHAR2
698: , p5_a0 NUMBER := 0-1962.0724
699: , p5_a1 NUMBER := 0-1962.0724
700: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
701: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a4 NUMBER := 0-1962.0724
703: , p5_a5 NUMBER := 0-1962.0724
704: , p5_a6 NUMBER := 0-1962.0724
697: , x_msg_data out nocopy VARCHAR2
698: , p5_a0 NUMBER := 0-1962.0724
699: , p5_a1 NUMBER := 0-1962.0724
700: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
701: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a4 NUMBER := 0-1962.0724
703: , p5_a5 NUMBER := 0-1962.0724
704: , p5_a6 NUMBER := 0-1962.0724
705: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
701: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a4 NUMBER := 0-1962.0724
703: , p5_a5 NUMBER := 0-1962.0724
704: , p5_a6 NUMBER := 0-1962.0724
705: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a4 NUMBER := 0-1962.0724
703: , p5_a5 NUMBER := 0-1962.0724
704: , p5_a6 NUMBER := 0-1962.0724
705: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a12 NUMBER := 0-1962.0724
703: , p5_a5 NUMBER := 0-1962.0724
704: , p5_a6 NUMBER := 0-1962.0724
705: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a12 NUMBER := 0-1962.0724
711: , p5_a13 NUMBER := 0-1962.0724
704: , p5_a6 NUMBER := 0-1962.0724
705: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a12 NUMBER := 0-1962.0724
711: , p5_a13 NUMBER := 0-1962.0724
712: , p5_a14 DATE := fnd_api.g_miss_date
705: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a12 NUMBER := 0-1962.0724
711: , p5_a13 NUMBER := 0-1962.0724
712: , p5_a14 DATE := fnd_api.g_miss_date
713: , p5_a15 NUMBER := 0-1962.0724
708: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a12 NUMBER := 0-1962.0724
711: , p5_a13 NUMBER := 0-1962.0724
712: , p5_a14 DATE := fnd_api.g_miss_date
713: , p5_a15 NUMBER := 0-1962.0724
714: , p5_a16 DATE := fnd_api.g_miss_date
715: , p5_a17 NUMBER := 0-1962.0724
716: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a12 NUMBER := 0-1962.0724
711: , p5_a13 NUMBER := 0-1962.0724
712: , p5_a14 DATE := fnd_api.g_miss_date
713: , p5_a15 NUMBER := 0-1962.0724
714: , p5_a16 DATE := fnd_api.g_miss_date
715: , p5_a17 NUMBER := 0-1962.0724
716: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a14 DATE := fnd_api.g_miss_date
713: , p5_a15 NUMBER := 0-1962.0724
714: , p5_a16 DATE := fnd_api.g_miss_date
715: , p5_a17 NUMBER := 0-1962.0724
716: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
720: )
713: , p5_a15 NUMBER := 0-1962.0724
714: , p5_a16 DATE := fnd_api.g_miss_date
715: , p5_a17 NUMBER := 0-1962.0724
716: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
720: )
721:
714: , p5_a16 DATE := fnd_api.g_miss_date
715: , p5_a17 NUMBER := 0-1962.0724
716: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
720: )
721:
722: as
715: , p5_a17 NUMBER := 0-1962.0724
716: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
720: )
721:
722: as
723: ddp_tryv_rec okl_trx_types_pub.tryv_rec_type;
855: , x_msg_count out nocopy NUMBER
856: , x_msg_data out nocopy VARCHAR2
857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 NUMBER := 0-1962.0724
859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 NUMBER := 0-1962.0724
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
856: , x_msg_data out nocopy VARCHAR2
857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 NUMBER := 0-1962.0724
859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 NUMBER := 0-1962.0724
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 NUMBER := 0-1962.0724
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 NUMBER := 0-1962.0724
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a12 NUMBER := 0-1962.0724
862: , p5_a5 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a12 NUMBER := 0-1962.0724
870: , p5_a13 NUMBER := 0-1962.0724
863: , p5_a6 NUMBER := 0-1962.0724
864: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a12 NUMBER := 0-1962.0724
870: , p5_a13 NUMBER := 0-1962.0724
871: , p5_a14 DATE := fnd_api.g_miss_date
864: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a12 NUMBER := 0-1962.0724
870: , p5_a13 NUMBER := 0-1962.0724
871: , p5_a14 DATE := fnd_api.g_miss_date
872: , p5_a15 NUMBER := 0-1962.0724
867: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a12 NUMBER := 0-1962.0724
870: , p5_a13 NUMBER := 0-1962.0724
871: , p5_a14 DATE := fnd_api.g_miss_date
872: , p5_a15 NUMBER := 0-1962.0724
873: , p5_a16 DATE := fnd_api.g_miss_date
874: , p5_a17 NUMBER := 0-1962.0724
875: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a12 NUMBER := 0-1962.0724
870: , p5_a13 NUMBER := 0-1962.0724
871: , p5_a14 DATE := fnd_api.g_miss_date
872: , p5_a15 NUMBER := 0-1962.0724
873: , p5_a16 DATE := fnd_api.g_miss_date
874: , p5_a17 NUMBER := 0-1962.0724
875: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a14 DATE := fnd_api.g_miss_date
872: , p5_a15 NUMBER := 0-1962.0724
873: , p5_a16 DATE := fnd_api.g_miss_date
874: , p5_a17 NUMBER := 0-1962.0724
875: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
879: )
872: , p5_a15 NUMBER := 0-1962.0724
873: , p5_a16 DATE := fnd_api.g_miss_date
874: , p5_a17 NUMBER := 0-1962.0724
875: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
879: )
880:
873: , p5_a16 DATE := fnd_api.g_miss_date
874: , p5_a17 NUMBER := 0-1962.0724
875: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
879: )
880:
881: as
874: , p5_a17 NUMBER := 0-1962.0724
875: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
876: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
877: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
879: )
880:
881: as
882: ddp_tryv_rec okl_trx_types_pub.tryv_rec_type;