7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
64: , p6_a34 out nocopy DATE
65: , p5_a0 NUMBER := 0-1962.0724
66: , p5_a1 NUMBER := 0-1962.0724
67: , p5_a2 NUMBER := 0-1962.0724
68: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a0 NUMBER := 0-1962.0724
66: , p5_a1 NUMBER := 0-1962.0724
67: , p5_a2 NUMBER := 0-1962.0724
68: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a1 NUMBER := 0-1962.0724
67: , p5_a2 NUMBER := 0-1962.0724
68: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a2 NUMBER := 0-1962.0724
68: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a20 NUMBER := 0-1962.0724
78: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a20 NUMBER := 0-1962.0724
86: , p5_a21 DATE := fnd_api.g_miss_date
79: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a20 NUMBER := 0-1962.0724
86: , p5_a21 DATE := fnd_api.g_miss_date
87: , p5_a22 NUMBER := 0-1962.0724
80: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a20 NUMBER := 0-1962.0724
86: , p5_a21 DATE := fnd_api.g_miss_date
87: , p5_a22 NUMBER := 0-1962.0724
88: , p5_a23 DATE := fnd_api.g_miss_date
82: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a20 NUMBER := 0-1962.0724
86: , p5_a21 DATE := fnd_api.g_miss_date
87: , p5_a22 NUMBER := 0-1962.0724
88: , p5_a23 DATE := fnd_api.g_miss_date
89: , p5_a24 NUMBER := 0-1962.0724
90: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a20 NUMBER := 0-1962.0724
86: , p5_a21 DATE := fnd_api.g_miss_date
87: , p5_a22 NUMBER := 0-1962.0724
88: , p5_a23 DATE := fnd_api.g_miss_date
89: , p5_a24 NUMBER := 0-1962.0724
90: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a26 NUMBER := 0-1962.0724
92: , p5_a27 DATE := fnd_api.g_miss_date
86: , p5_a21 DATE := fnd_api.g_miss_date
87: , p5_a22 NUMBER := 0-1962.0724
88: , p5_a23 DATE := fnd_api.g_miss_date
89: , p5_a24 NUMBER := 0-1962.0724
90: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a26 NUMBER := 0-1962.0724
92: , p5_a27 DATE := fnd_api.g_miss_date
93: , p5_a28 NUMBER := 0-1962.0724
94: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a23 DATE := fnd_api.g_miss_date
89: , p5_a24 NUMBER := 0-1962.0724
90: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a26 NUMBER := 0-1962.0724
92: , p5_a27 DATE := fnd_api.g_miss_date
93: , p5_a28 NUMBER := 0-1962.0724
94: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a30 NUMBER := 0-1962.0724
96: , p5_a31 NUMBER := 0-1962.0724
90: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a26 NUMBER := 0-1962.0724
92: , p5_a27 DATE := fnd_api.g_miss_date
93: , p5_a28 NUMBER := 0-1962.0724
94: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a30 NUMBER := 0-1962.0724
96: , p5_a31 NUMBER := 0-1962.0724
97: , p5_a32 NUMBER := 0-1962.0724
98: , p5_a33 NUMBER := 0-1962.0724
95: , p5_a30 NUMBER := 0-1962.0724
96: , p5_a31 NUMBER := 0-1962.0724
97: , p5_a32 NUMBER := 0-1962.0724
98: , p5_a33 NUMBER := 0-1962.0724
99: , p5_a34 DATE := fnd_api.g_miss_date
100: )
101:
102: as
103: ddp_tasv_rec okl_trx_assets_pvt.tavv_rec_type;
389: , x_msg_data out nocopy VARCHAR2
390: , p5_a0 NUMBER := 0-1962.0724
391: , p5_a1 NUMBER := 0-1962.0724
392: , p5_a2 NUMBER := 0-1962.0724
393: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
390: , p5_a0 NUMBER := 0-1962.0724
391: , p5_a1 NUMBER := 0-1962.0724
392: , p5_a2 NUMBER := 0-1962.0724
393: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
391: , p5_a1 NUMBER := 0-1962.0724
392: , p5_a2 NUMBER := 0-1962.0724
393: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
392: , p5_a2 NUMBER := 0-1962.0724
393: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
393: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
394: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
395: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
396: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
397: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
399: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a20 NUMBER := 0-1962.0724
403: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a20 NUMBER := 0-1962.0724
411: , p5_a21 DATE := fnd_api.g_miss_date
404: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a20 NUMBER := 0-1962.0724
411: , p5_a21 DATE := fnd_api.g_miss_date
412: , p5_a22 NUMBER := 0-1962.0724
405: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a20 NUMBER := 0-1962.0724
411: , p5_a21 DATE := fnd_api.g_miss_date
412: , p5_a22 NUMBER := 0-1962.0724
413: , p5_a23 DATE := fnd_api.g_miss_date
407: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a20 NUMBER := 0-1962.0724
411: , p5_a21 DATE := fnd_api.g_miss_date
412: , p5_a22 NUMBER := 0-1962.0724
413: , p5_a23 DATE := fnd_api.g_miss_date
414: , p5_a24 NUMBER := 0-1962.0724
415: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a20 NUMBER := 0-1962.0724
411: , p5_a21 DATE := fnd_api.g_miss_date
412: , p5_a22 NUMBER := 0-1962.0724
413: , p5_a23 DATE := fnd_api.g_miss_date
414: , p5_a24 NUMBER := 0-1962.0724
415: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a26 NUMBER := 0-1962.0724
417: , p5_a27 DATE := fnd_api.g_miss_date
411: , p5_a21 DATE := fnd_api.g_miss_date
412: , p5_a22 NUMBER := 0-1962.0724
413: , p5_a23 DATE := fnd_api.g_miss_date
414: , p5_a24 NUMBER := 0-1962.0724
415: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a26 NUMBER := 0-1962.0724
417: , p5_a27 DATE := fnd_api.g_miss_date
418: , p5_a28 NUMBER := 0-1962.0724
419: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a23 DATE := fnd_api.g_miss_date
414: , p5_a24 NUMBER := 0-1962.0724
415: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a26 NUMBER := 0-1962.0724
417: , p5_a27 DATE := fnd_api.g_miss_date
418: , p5_a28 NUMBER := 0-1962.0724
419: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a30 NUMBER := 0-1962.0724
421: , p5_a31 NUMBER := 0-1962.0724
415: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a26 NUMBER := 0-1962.0724
417: , p5_a27 DATE := fnd_api.g_miss_date
418: , p5_a28 NUMBER := 0-1962.0724
419: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a30 NUMBER := 0-1962.0724
421: , p5_a31 NUMBER := 0-1962.0724
422: , p5_a32 NUMBER := 0-1962.0724
423: , p5_a33 NUMBER := 0-1962.0724
420: , p5_a30 NUMBER := 0-1962.0724
421: , p5_a31 NUMBER := 0-1962.0724
422: , p5_a32 NUMBER := 0-1962.0724
423: , p5_a33 NUMBER := 0-1962.0724
424: , p5_a34 DATE := fnd_api.g_miss_date
425: )
426:
427: as
428: ddp_tasv_rec okl_trx_assets_pvt.tavv_rec_type;
635: , p6_a34 out nocopy DATE
636: , p5_a0 NUMBER := 0-1962.0724
637: , p5_a1 NUMBER := 0-1962.0724
638: , p5_a2 NUMBER := 0-1962.0724
639: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a0 NUMBER := 0-1962.0724
637: , p5_a1 NUMBER := 0-1962.0724
638: , p5_a2 NUMBER := 0-1962.0724
639: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a1 NUMBER := 0-1962.0724
638: , p5_a2 NUMBER := 0-1962.0724
639: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a2 NUMBER := 0-1962.0724
639: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a20 NUMBER := 0-1962.0724
649: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a20 NUMBER := 0-1962.0724
657: , p5_a21 DATE := fnd_api.g_miss_date
650: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a20 NUMBER := 0-1962.0724
657: , p5_a21 DATE := fnd_api.g_miss_date
658: , p5_a22 NUMBER := 0-1962.0724
651: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a20 NUMBER := 0-1962.0724
657: , p5_a21 DATE := fnd_api.g_miss_date
658: , p5_a22 NUMBER := 0-1962.0724
659: , p5_a23 DATE := fnd_api.g_miss_date
653: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a20 NUMBER := 0-1962.0724
657: , p5_a21 DATE := fnd_api.g_miss_date
658: , p5_a22 NUMBER := 0-1962.0724
659: , p5_a23 DATE := fnd_api.g_miss_date
660: , p5_a24 NUMBER := 0-1962.0724
661: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a20 NUMBER := 0-1962.0724
657: , p5_a21 DATE := fnd_api.g_miss_date
658: , p5_a22 NUMBER := 0-1962.0724
659: , p5_a23 DATE := fnd_api.g_miss_date
660: , p5_a24 NUMBER := 0-1962.0724
661: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a26 NUMBER := 0-1962.0724
663: , p5_a27 DATE := fnd_api.g_miss_date
657: , p5_a21 DATE := fnd_api.g_miss_date
658: , p5_a22 NUMBER := 0-1962.0724
659: , p5_a23 DATE := fnd_api.g_miss_date
660: , p5_a24 NUMBER := 0-1962.0724
661: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a26 NUMBER := 0-1962.0724
663: , p5_a27 DATE := fnd_api.g_miss_date
664: , p5_a28 NUMBER := 0-1962.0724
665: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a23 DATE := fnd_api.g_miss_date
660: , p5_a24 NUMBER := 0-1962.0724
661: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a26 NUMBER := 0-1962.0724
663: , p5_a27 DATE := fnd_api.g_miss_date
664: , p5_a28 NUMBER := 0-1962.0724
665: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a30 NUMBER := 0-1962.0724
667: , p5_a31 NUMBER := 0-1962.0724
661: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a26 NUMBER := 0-1962.0724
663: , p5_a27 DATE := fnd_api.g_miss_date
664: , p5_a28 NUMBER := 0-1962.0724
665: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a30 NUMBER := 0-1962.0724
667: , p5_a31 NUMBER := 0-1962.0724
668: , p5_a32 NUMBER := 0-1962.0724
669: , p5_a33 NUMBER := 0-1962.0724
666: , p5_a30 NUMBER := 0-1962.0724
667: , p5_a31 NUMBER := 0-1962.0724
668: , p5_a32 NUMBER := 0-1962.0724
669: , p5_a33 NUMBER := 0-1962.0724
670: , p5_a34 DATE := fnd_api.g_miss_date
671: )
672:
673: as
674: ddp_tasv_rec okl_trx_assets_pvt.tavv_rec_type;
960: , x_msg_data out nocopy VARCHAR2
961: , p5_a0 NUMBER := 0-1962.0724
962: , p5_a1 NUMBER := 0-1962.0724
963: , p5_a2 NUMBER := 0-1962.0724
964: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a0 NUMBER := 0-1962.0724
962: , p5_a1 NUMBER := 0-1962.0724
963: , p5_a2 NUMBER := 0-1962.0724
964: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a1 NUMBER := 0-1962.0724
963: , p5_a2 NUMBER := 0-1962.0724
964: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a2 NUMBER := 0-1962.0724
964: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
964: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
965: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
966: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
967: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
968: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
969: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
970: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
971: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
972: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a20 NUMBER := 0-1962.0724
974: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a20 NUMBER := 0-1962.0724
982: , p5_a21 DATE := fnd_api.g_miss_date
975: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a20 NUMBER := 0-1962.0724
982: , p5_a21 DATE := fnd_api.g_miss_date
983: , p5_a22 NUMBER := 0-1962.0724
976: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a20 NUMBER := 0-1962.0724
982: , p5_a21 DATE := fnd_api.g_miss_date
983: , p5_a22 NUMBER := 0-1962.0724
984: , p5_a23 DATE := fnd_api.g_miss_date
978: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
979: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a20 NUMBER := 0-1962.0724
982: , p5_a21 DATE := fnd_api.g_miss_date
983: , p5_a22 NUMBER := 0-1962.0724
984: , p5_a23 DATE := fnd_api.g_miss_date
985: , p5_a24 NUMBER := 0-1962.0724
986: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a20 NUMBER := 0-1962.0724
982: , p5_a21 DATE := fnd_api.g_miss_date
983: , p5_a22 NUMBER := 0-1962.0724
984: , p5_a23 DATE := fnd_api.g_miss_date
985: , p5_a24 NUMBER := 0-1962.0724
986: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a26 NUMBER := 0-1962.0724
988: , p5_a27 DATE := fnd_api.g_miss_date
982: , p5_a21 DATE := fnd_api.g_miss_date
983: , p5_a22 NUMBER := 0-1962.0724
984: , p5_a23 DATE := fnd_api.g_miss_date
985: , p5_a24 NUMBER := 0-1962.0724
986: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a26 NUMBER := 0-1962.0724
988: , p5_a27 DATE := fnd_api.g_miss_date
989: , p5_a28 NUMBER := 0-1962.0724
990: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
984: , p5_a23 DATE := fnd_api.g_miss_date
985: , p5_a24 NUMBER := 0-1962.0724
986: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a26 NUMBER := 0-1962.0724
988: , p5_a27 DATE := fnd_api.g_miss_date
989: , p5_a28 NUMBER := 0-1962.0724
990: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a30 NUMBER := 0-1962.0724
992: , p5_a31 NUMBER := 0-1962.0724
986: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
987: , p5_a26 NUMBER := 0-1962.0724
988: , p5_a27 DATE := fnd_api.g_miss_date
989: , p5_a28 NUMBER := 0-1962.0724
990: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
991: , p5_a30 NUMBER := 0-1962.0724
992: , p5_a31 NUMBER := 0-1962.0724
993: , p5_a32 NUMBER := 0-1962.0724
994: , p5_a33 NUMBER := 0-1962.0724
991: , p5_a30 NUMBER := 0-1962.0724
992: , p5_a31 NUMBER := 0-1962.0724
993: , p5_a32 NUMBER := 0-1962.0724
994: , p5_a33 NUMBER := 0-1962.0724
995: , p5_a34 DATE := fnd_api.g_miss_date
996: )
997:
998: as
999: ddp_tasv_rec okl_trx_assets_pvt.tavv_rec_type;
1171: , x_msg_data out nocopy VARCHAR2
1172: , p5_a0 NUMBER := 0-1962.0724
1173: , p5_a1 NUMBER := 0-1962.0724
1174: , p5_a2 NUMBER := 0-1962.0724
1175: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a0 NUMBER := 0-1962.0724
1173: , p5_a1 NUMBER := 0-1962.0724
1174: , p5_a2 NUMBER := 0-1962.0724
1175: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a1 NUMBER := 0-1962.0724
1174: , p5_a2 NUMBER := 0-1962.0724
1175: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a2 NUMBER := 0-1962.0724
1175: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a20 NUMBER := 0-1962.0724
1185: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a20 NUMBER := 0-1962.0724
1193: , p5_a21 DATE := fnd_api.g_miss_date
1186: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a20 NUMBER := 0-1962.0724
1193: , p5_a21 DATE := fnd_api.g_miss_date
1194: , p5_a22 NUMBER := 0-1962.0724
1187: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a20 NUMBER := 0-1962.0724
1193: , p5_a21 DATE := fnd_api.g_miss_date
1194: , p5_a22 NUMBER := 0-1962.0724
1195: , p5_a23 DATE := fnd_api.g_miss_date
1189: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1190: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a20 NUMBER := 0-1962.0724
1193: , p5_a21 DATE := fnd_api.g_miss_date
1194: , p5_a22 NUMBER := 0-1962.0724
1195: , p5_a23 DATE := fnd_api.g_miss_date
1196: , p5_a24 NUMBER := 0-1962.0724
1197: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1191: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1192: , p5_a20 NUMBER := 0-1962.0724
1193: , p5_a21 DATE := fnd_api.g_miss_date
1194: , p5_a22 NUMBER := 0-1962.0724
1195: , p5_a23 DATE := fnd_api.g_miss_date
1196: , p5_a24 NUMBER := 0-1962.0724
1197: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a26 NUMBER := 0-1962.0724
1199: , p5_a27 DATE := fnd_api.g_miss_date
1193: , p5_a21 DATE := fnd_api.g_miss_date
1194: , p5_a22 NUMBER := 0-1962.0724
1195: , p5_a23 DATE := fnd_api.g_miss_date
1196: , p5_a24 NUMBER := 0-1962.0724
1197: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a26 NUMBER := 0-1962.0724
1199: , p5_a27 DATE := fnd_api.g_miss_date
1200: , p5_a28 NUMBER := 0-1962.0724
1201: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1195: , p5_a23 DATE := fnd_api.g_miss_date
1196: , p5_a24 NUMBER := 0-1962.0724
1197: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a26 NUMBER := 0-1962.0724
1199: , p5_a27 DATE := fnd_api.g_miss_date
1200: , p5_a28 NUMBER := 0-1962.0724
1201: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a30 NUMBER := 0-1962.0724
1203: , p5_a31 NUMBER := 0-1962.0724
1197: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1198: , p5_a26 NUMBER := 0-1962.0724
1199: , p5_a27 DATE := fnd_api.g_miss_date
1200: , p5_a28 NUMBER := 0-1962.0724
1201: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1202: , p5_a30 NUMBER := 0-1962.0724
1203: , p5_a31 NUMBER := 0-1962.0724
1204: , p5_a32 NUMBER := 0-1962.0724
1205: , p5_a33 NUMBER := 0-1962.0724
1202: , p5_a30 NUMBER := 0-1962.0724
1203: , p5_a31 NUMBER := 0-1962.0724
1204: , p5_a32 NUMBER := 0-1962.0724
1205: , p5_a33 NUMBER := 0-1962.0724
1206: , p5_a34 DATE := fnd_api.g_miss_date
1207: )
1208:
1209: as
1210: ddp_tasv_rec okl_trx_assets_pvt.tavv_rec_type;