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_thpv_rec okl_trx_assets_pub.thpv_rec_type;
424: , p6_a34 out nocopy DATE
425: , p5_a0 NUMBER := 0-1962.0724
426: , p5_a1 NUMBER := 0-1962.0724
427: , p5_a2 NUMBER := 0-1962.0724
428: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a0 NUMBER := 0-1962.0724
426: , p5_a1 NUMBER := 0-1962.0724
427: , p5_a2 NUMBER := 0-1962.0724
428: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a1 NUMBER := 0-1962.0724
427: , p5_a2 NUMBER := 0-1962.0724
428: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a2 NUMBER := 0-1962.0724
428: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
435: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
436: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
437: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 NUMBER := 0-1962.0724
438: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 NUMBER := 0-1962.0724
446: , p5_a21 DATE := fnd_api.g_miss_date
439: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 NUMBER := 0-1962.0724
446: , p5_a21 DATE := fnd_api.g_miss_date
447: , p5_a22 NUMBER := 0-1962.0724
440: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
441: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 NUMBER := 0-1962.0724
446: , p5_a21 DATE := fnd_api.g_miss_date
447: , p5_a22 NUMBER := 0-1962.0724
448: , p5_a23 DATE := fnd_api.g_miss_date
442: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 NUMBER := 0-1962.0724
446: , p5_a21 DATE := fnd_api.g_miss_date
447: , p5_a22 NUMBER := 0-1962.0724
448: , p5_a23 DATE := fnd_api.g_miss_date
449: , p5_a24 NUMBER := 0-1962.0724
450: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 NUMBER := 0-1962.0724
446: , p5_a21 DATE := fnd_api.g_miss_date
447: , p5_a22 NUMBER := 0-1962.0724
448: , p5_a23 DATE := fnd_api.g_miss_date
449: , p5_a24 NUMBER := 0-1962.0724
450: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a26 NUMBER := 0-1962.0724
452: , p5_a27 DATE := fnd_api.g_miss_date
446: , p5_a21 DATE := fnd_api.g_miss_date
447: , p5_a22 NUMBER := 0-1962.0724
448: , p5_a23 DATE := fnd_api.g_miss_date
449: , p5_a24 NUMBER := 0-1962.0724
450: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a26 NUMBER := 0-1962.0724
452: , p5_a27 DATE := fnd_api.g_miss_date
453: , p5_a28 NUMBER := 0-1962.0724
454: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a23 DATE := fnd_api.g_miss_date
449: , p5_a24 NUMBER := 0-1962.0724
450: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a26 NUMBER := 0-1962.0724
452: , p5_a27 DATE := fnd_api.g_miss_date
453: , p5_a28 NUMBER := 0-1962.0724
454: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a30 NUMBER := 0-1962.0724
456: , p5_a31 NUMBER := 0-1962.0724
450: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a26 NUMBER := 0-1962.0724
452: , p5_a27 DATE := fnd_api.g_miss_date
453: , p5_a28 NUMBER := 0-1962.0724
454: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a30 NUMBER := 0-1962.0724
456: , p5_a31 NUMBER := 0-1962.0724
457: , p5_a32 NUMBER := 0-1962.0724
458: , p5_a33 NUMBER := 0-1962.0724
455: , p5_a30 NUMBER := 0-1962.0724
456: , p5_a31 NUMBER := 0-1962.0724
457: , p5_a32 NUMBER := 0-1962.0724
458: , p5_a33 NUMBER := 0-1962.0724
459: , p5_a34 DATE := fnd_api.g_miss_date
460: )
461:
462: as
463: ddp_thpv_rec okl_trx_assets_pub.thpv_rec_type;
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 NUMBER := 0-1962.0724
751: , p5_a1 NUMBER := 0-1962.0724
752: , p5_a2 NUMBER := 0-1962.0724
753: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a0 NUMBER := 0-1962.0724
751: , p5_a1 NUMBER := 0-1962.0724
752: , p5_a2 NUMBER := 0-1962.0724
753: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a1 NUMBER := 0-1962.0724
752: , p5_a2 NUMBER := 0-1962.0724
753: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a2 NUMBER := 0-1962.0724
753: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
754: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
755: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
756: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
757: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
758: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
759: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
760: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
761: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
762: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a20 NUMBER := 0-1962.0724
763: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a20 NUMBER := 0-1962.0724
771: , p5_a21 DATE := fnd_api.g_miss_date
764: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a20 NUMBER := 0-1962.0724
771: , p5_a21 DATE := fnd_api.g_miss_date
772: , p5_a22 NUMBER := 0-1962.0724
765: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a20 NUMBER := 0-1962.0724
771: , p5_a21 DATE := fnd_api.g_miss_date
772: , p5_a22 NUMBER := 0-1962.0724
773: , p5_a23 DATE := fnd_api.g_miss_date
767: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a20 NUMBER := 0-1962.0724
771: , p5_a21 DATE := fnd_api.g_miss_date
772: , p5_a22 NUMBER := 0-1962.0724
773: , p5_a23 DATE := fnd_api.g_miss_date
774: , p5_a24 NUMBER := 0-1962.0724
775: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a20 NUMBER := 0-1962.0724
771: , p5_a21 DATE := fnd_api.g_miss_date
772: , p5_a22 NUMBER := 0-1962.0724
773: , p5_a23 DATE := fnd_api.g_miss_date
774: , p5_a24 NUMBER := 0-1962.0724
775: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a26 NUMBER := 0-1962.0724
777: , p5_a27 DATE := fnd_api.g_miss_date
771: , p5_a21 DATE := fnd_api.g_miss_date
772: , p5_a22 NUMBER := 0-1962.0724
773: , p5_a23 DATE := fnd_api.g_miss_date
774: , p5_a24 NUMBER := 0-1962.0724
775: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a26 NUMBER := 0-1962.0724
777: , p5_a27 DATE := fnd_api.g_miss_date
778: , p5_a28 NUMBER := 0-1962.0724
779: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a23 DATE := fnd_api.g_miss_date
774: , p5_a24 NUMBER := 0-1962.0724
775: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a26 NUMBER := 0-1962.0724
777: , p5_a27 DATE := fnd_api.g_miss_date
778: , p5_a28 NUMBER := 0-1962.0724
779: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a30 NUMBER := 0-1962.0724
781: , p5_a31 NUMBER := 0-1962.0724
775: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a26 NUMBER := 0-1962.0724
777: , p5_a27 DATE := fnd_api.g_miss_date
778: , p5_a28 NUMBER := 0-1962.0724
779: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a30 NUMBER := 0-1962.0724
781: , p5_a31 NUMBER := 0-1962.0724
782: , p5_a32 NUMBER := 0-1962.0724
783: , p5_a33 NUMBER := 0-1962.0724
780: , p5_a30 NUMBER := 0-1962.0724
781: , p5_a31 NUMBER := 0-1962.0724
782: , p5_a32 NUMBER := 0-1962.0724
783: , p5_a33 NUMBER := 0-1962.0724
784: , p5_a34 DATE := fnd_api.g_miss_date
785: )
786:
787: as
788: ddp_thpv_rec okl_trx_assets_pub.thpv_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_thpv_rec okl_trx_assets_pub.thpv_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_thpv_rec okl_trx_assets_pub.thpv_rec_type;