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;
76: , p8_a10 out nocopy JTF_DATE_TABLE
77: , p8_a11 out nocopy JTF_NUMBER_TABLE
78: , p5_a0 NUMBER := 0-1962.0724
79: , p5_a1 NUMBER := 0-1962.0724
80: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a4 DATE := fnd_api.g_miss_date
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
77: , p8_a11 out nocopy JTF_NUMBER_TABLE
78: , p5_a0 NUMBER := 0-1962.0724
79: , p5_a1 NUMBER := 0-1962.0724
80: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a4 DATE := fnd_api.g_miss_date
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a0 NUMBER := 0-1962.0724
79: , p5_a1 NUMBER := 0-1962.0724
80: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a4 DATE := fnd_api.g_miss_date
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a1 NUMBER := 0-1962.0724
80: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a4 DATE := fnd_api.g_miss_date
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a4 DATE := fnd_api.g_miss_date
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a4 DATE := fnd_api.g_miss_date
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a4 DATE := fnd_api.g_miss_date
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a5 DATE := fnd_api.g_miss_date
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a22 NUMBER := 0-1962.0724
93: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a22 NUMBER := 0-1962.0724
101: , p5_a23 DATE := fnd_api.g_miss_date
94: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a22 NUMBER := 0-1962.0724
101: , p5_a23 DATE := fnd_api.g_miss_date
102: , p5_a24 NUMBER := 0-1962.0724
95: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a22 NUMBER := 0-1962.0724
101: , p5_a23 DATE := fnd_api.g_miss_date
102: , p5_a24 NUMBER := 0-1962.0724
103: , p5_a25 DATE := fnd_api.g_miss_date
97: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a22 NUMBER := 0-1962.0724
101: , p5_a23 DATE := fnd_api.g_miss_date
102: , p5_a24 NUMBER := 0-1962.0724
103: , p5_a25 DATE := fnd_api.g_miss_date
104: , p5_a26 NUMBER := 0-1962.0724
105: )
99: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a22 NUMBER := 0-1962.0724
101: , p5_a23 DATE := fnd_api.g_miss_date
102: , p5_a24 NUMBER := 0-1962.0724
103: , p5_a25 DATE := fnd_api.g_miss_date
104: , p5_a26 NUMBER := 0-1962.0724
105: )
106:
107: as
281: , p8_a10 out nocopy JTF_DATE_TABLE
282: , p8_a11 out nocopy JTF_NUMBER_TABLE
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 DATE := fnd_api.g_miss_date
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
282: , p8_a11 out nocopy JTF_NUMBER_TABLE
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 DATE := fnd_api.g_miss_date
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
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
285: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a4 DATE := fnd_api.g_miss_date
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
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
286: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a4 DATE := fnd_api.g_miss_date
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a5 DATE := fnd_api.g_miss_date
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 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 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 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 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 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 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
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
296: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
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
297: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
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: , p5_a22 NUMBER := 0-1962.0724
298: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
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: , p5_a22 NUMBER := 0-1962.0724
306: , p5_a23 DATE := fnd_api.g_miss_date
299: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
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: , p5_a22 NUMBER := 0-1962.0724
306: , p5_a23 DATE := fnd_api.g_miss_date
307: , p5_a24 NUMBER := 0-1962.0724
300: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
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: , p5_a22 NUMBER := 0-1962.0724
306: , p5_a23 DATE := fnd_api.g_miss_date
307: , p5_a24 NUMBER := 0-1962.0724
308: , p5_a25 DATE := fnd_api.g_miss_date
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: , p5_a22 NUMBER := 0-1962.0724
306: , p5_a23 DATE := fnd_api.g_miss_date
307: , p5_a24 NUMBER := 0-1962.0724
308: , p5_a25 DATE := fnd_api.g_miss_date
309: , p5_a26 NUMBER := 0-1962.0724
310: )
304: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a22 NUMBER := 0-1962.0724
306: , p5_a23 DATE := fnd_api.g_miss_date
307: , p5_a24 NUMBER := 0-1962.0724
308: , p5_a25 DATE := fnd_api.g_miss_date
309: , p5_a26 NUMBER := 0-1962.0724
310: )
311:
312: as
447: , p6_a10 JTF_DATE_TABLE
448: , p6_a11 JTF_NUMBER_TABLE
449: , p5_a0 NUMBER := 0-1962.0724
450: , p5_a1 NUMBER := 0-1962.0724
451: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a4 DATE := fnd_api.g_miss_date
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
448: , p6_a11 JTF_NUMBER_TABLE
449: , p5_a0 NUMBER := 0-1962.0724
450: , p5_a1 NUMBER := 0-1962.0724
451: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a4 DATE := fnd_api.g_miss_date
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a0 NUMBER := 0-1962.0724
450: , p5_a1 NUMBER := 0-1962.0724
451: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a4 DATE := fnd_api.g_miss_date
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a1 NUMBER := 0-1962.0724
451: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a4 DATE := fnd_api.g_miss_date
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a4 DATE := fnd_api.g_miss_date
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a4 DATE := fnd_api.g_miss_date
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a4 DATE := fnd_api.g_miss_date
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a5 DATE := fnd_api.g_miss_date
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a22 NUMBER := 0-1962.0724
464: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a22 NUMBER := 0-1962.0724
472: , p5_a23 DATE := fnd_api.g_miss_date
465: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a22 NUMBER := 0-1962.0724
472: , p5_a23 DATE := fnd_api.g_miss_date
473: , p5_a24 NUMBER := 0-1962.0724
466: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a22 NUMBER := 0-1962.0724
472: , p5_a23 DATE := fnd_api.g_miss_date
473: , p5_a24 NUMBER := 0-1962.0724
474: , p5_a25 DATE := fnd_api.g_miss_date
468: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a22 NUMBER := 0-1962.0724
472: , p5_a23 DATE := fnd_api.g_miss_date
473: , p5_a24 NUMBER := 0-1962.0724
474: , p5_a25 DATE := fnd_api.g_miss_date
475: , p5_a26 NUMBER := 0-1962.0724
476: )
470: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a22 NUMBER := 0-1962.0724
472: , p5_a23 DATE := fnd_api.g_miss_date
473: , p5_a24 NUMBER := 0-1962.0724
474: , p5_a25 DATE := fnd_api.g_miss_date
475: , p5_a26 NUMBER := 0-1962.0724
476: )
477:
478: as
729: , p6_a25 out nocopy DATE
730: , p6_a26 out nocopy NUMBER
731: , p5_a0 NUMBER := 0-1962.0724
732: , p5_a1 NUMBER := 0-1962.0724
733: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a4 DATE := fnd_api.g_miss_date
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
730: , p6_a26 out nocopy NUMBER
731: , p5_a0 NUMBER := 0-1962.0724
732: , p5_a1 NUMBER := 0-1962.0724
733: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a4 DATE := fnd_api.g_miss_date
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a0 NUMBER := 0-1962.0724
732: , p5_a1 NUMBER := 0-1962.0724
733: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a4 DATE := fnd_api.g_miss_date
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a1 NUMBER := 0-1962.0724
733: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a4 DATE := fnd_api.g_miss_date
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a4 DATE := fnd_api.g_miss_date
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a4 DATE := fnd_api.g_miss_date
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a4 DATE := fnd_api.g_miss_date
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a5 DATE := fnd_api.g_miss_date
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a22 NUMBER := 0-1962.0724
746: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a22 NUMBER := 0-1962.0724
754: , p5_a23 DATE := fnd_api.g_miss_date
747: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a22 NUMBER := 0-1962.0724
754: , p5_a23 DATE := fnd_api.g_miss_date
755: , p5_a24 NUMBER := 0-1962.0724
748: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a22 NUMBER := 0-1962.0724
754: , p5_a23 DATE := fnd_api.g_miss_date
755: , p5_a24 NUMBER := 0-1962.0724
756: , p5_a25 DATE := fnd_api.g_miss_date
750: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
751: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
752: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a22 NUMBER := 0-1962.0724
754: , p5_a23 DATE := fnd_api.g_miss_date
755: , p5_a24 NUMBER := 0-1962.0724
756: , p5_a25 DATE := fnd_api.g_miss_date
757: , p5_a26 NUMBER := 0-1962.0724
758: )
752: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
753: , p5_a22 NUMBER := 0-1962.0724
754: , p5_a23 DATE := fnd_api.g_miss_date
755: , p5_a24 NUMBER := 0-1962.0724
756: , p5_a25 DATE := fnd_api.g_miss_date
757: , p5_a26 NUMBER := 0-1962.0724
758: )
759:
760: as
939: , x_msg_count out nocopy NUMBER
940: , x_msg_data out nocopy VARCHAR2
941: , p5_a0 NUMBER := 0-1962.0724
942: , p5_a1 NUMBER := 0-1962.0724
943: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a4 DATE := fnd_api.g_miss_date
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
940: , x_msg_data out nocopy VARCHAR2
941: , p5_a0 NUMBER := 0-1962.0724
942: , p5_a1 NUMBER := 0-1962.0724
943: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a4 DATE := fnd_api.g_miss_date
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
941: , p5_a0 NUMBER := 0-1962.0724
942: , p5_a1 NUMBER := 0-1962.0724
943: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a4 DATE := fnd_api.g_miss_date
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
942: , p5_a1 NUMBER := 0-1962.0724
943: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a4 DATE := fnd_api.g_miss_date
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
943: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a4 DATE := fnd_api.g_miss_date
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
944: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a4 DATE := fnd_api.g_miss_date
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a4 DATE := fnd_api.g_miss_date
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a5 DATE := fnd_api.g_miss_date
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a22 NUMBER := 0-1962.0724
956: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a22 NUMBER := 0-1962.0724
964: , p5_a23 DATE := fnd_api.g_miss_date
957: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a22 NUMBER := 0-1962.0724
964: , p5_a23 DATE := fnd_api.g_miss_date
965: , p5_a24 NUMBER := 0-1962.0724
958: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
959: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a22 NUMBER := 0-1962.0724
964: , p5_a23 DATE := fnd_api.g_miss_date
965: , p5_a24 NUMBER := 0-1962.0724
966: , p5_a25 DATE := fnd_api.g_miss_date
960: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
961: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
962: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a22 NUMBER := 0-1962.0724
964: , p5_a23 DATE := fnd_api.g_miss_date
965: , p5_a24 NUMBER := 0-1962.0724
966: , p5_a25 DATE := fnd_api.g_miss_date
967: , p5_a26 NUMBER := 0-1962.0724
968: )
962: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
963: , p5_a22 NUMBER := 0-1962.0724
964: , p5_a23 DATE := fnd_api.g_miss_date
965: , p5_a24 NUMBER := 0-1962.0724
966: , p5_a25 DATE := fnd_api.g_miss_date
967: , p5_a26 NUMBER := 0-1962.0724
968: )
969:
970: as
1204: , p6_a25 out nocopy DATE
1205: , p6_a26 out nocopy NUMBER
1206: , p5_a0 NUMBER := 0-1962.0724
1207: , p5_a1 NUMBER := 0-1962.0724
1208: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a4 DATE := fnd_api.g_miss_date
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1205: , p6_a26 out nocopy NUMBER
1206: , p5_a0 NUMBER := 0-1962.0724
1207: , p5_a1 NUMBER := 0-1962.0724
1208: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a4 DATE := fnd_api.g_miss_date
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a0 NUMBER := 0-1962.0724
1207: , p5_a1 NUMBER := 0-1962.0724
1208: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a4 DATE := fnd_api.g_miss_date
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a1 NUMBER := 0-1962.0724
1208: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a4 DATE := fnd_api.g_miss_date
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a4 DATE := fnd_api.g_miss_date
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a4 DATE := fnd_api.g_miss_date
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a4 DATE := fnd_api.g_miss_date
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a5 DATE := fnd_api.g_miss_date
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a22 NUMBER := 0-1962.0724
1221: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a22 NUMBER := 0-1962.0724
1229: , p5_a23 DATE := fnd_api.g_miss_date
1222: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a22 NUMBER := 0-1962.0724
1229: , p5_a23 DATE := fnd_api.g_miss_date
1230: , p5_a24 NUMBER := 0-1962.0724
1223: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a22 NUMBER := 0-1962.0724
1229: , p5_a23 DATE := fnd_api.g_miss_date
1230: , p5_a24 NUMBER := 0-1962.0724
1231: , p5_a25 DATE := fnd_api.g_miss_date
1225: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a22 NUMBER := 0-1962.0724
1229: , p5_a23 DATE := fnd_api.g_miss_date
1230: , p5_a24 NUMBER := 0-1962.0724
1231: , p5_a25 DATE := fnd_api.g_miss_date
1232: , p5_a26 NUMBER := 0-1962.0724
1233: )
1227: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a22 NUMBER := 0-1962.0724
1229: , p5_a23 DATE := fnd_api.g_miss_date
1230: , p5_a24 NUMBER := 0-1962.0724
1231: , p5_a25 DATE := fnd_api.g_miss_date
1232: , p5_a26 NUMBER := 0-1962.0724
1233: )
1234:
1235: as
1414: , x_msg_count out nocopy NUMBER
1415: , x_msg_data out nocopy VARCHAR2
1416: , p5_a0 NUMBER := 0-1962.0724
1417: , p5_a1 NUMBER := 0-1962.0724
1418: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a4 DATE := fnd_api.g_miss_date
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1415: , x_msg_data out nocopy VARCHAR2
1416: , p5_a0 NUMBER := 0-1962.0724
1417: , p5_a1 NUMBER := 0-1962.0724
1418: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a4 DATE := fnd_api.g_miss_date
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1416: , p5_a0 NUMBER := 0-1962.0724
1417: , p5_a1 NUMBER := 0-1962.0724
1418: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a4 DATE := fnd_api.g_miss_date
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1417: , p5_a1 NUMBER := 0-1962.0724
1418: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a4 DATE := fnd_api.g_miss_date
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1418: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a4 DATE := fnd_api.g_miss_date
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1419: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a4 DATE := fnd_api.g_miss_date
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1420: , p5_a4 DATE := fnd_api.g_miss_date
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1421: , p5_a5 DATE := fnd_api.g_miss_date
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1422: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1424: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1427: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a22 NUMBER := 0-1962.0724
1431: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a22 NUMBER := 0-1962.0724
1439: , p5_a23 DATE := fnd_api.g_miss_date
1432: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a22 NUMBER := 0-1962.0724
1439: , p5_a23 DATE := fnd_api.g_miss_date
1440: , p5_a24 NUMBER := 0-1962.0724
1433: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a22 NUMBER := 0-1962.0724
1439: , p5_a23 DATE := fnd_api.g_miss_date
1440: , p5_a24 NUMBER := 0-1962.0724
1441: , p5_a25 DATE := fnd_api.g_miss_date
1435: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a22 NUMBER := 0-1962.0724
1439: , p5_a23 DATE := fnd_api.g_miss_date
1440: , p5_a24 NUMBER := 0-1962.0724
1441: , p5_a25 DATE := fnd_api.g_miss_date
1442: , p5_a26 NUMBER := 0-1962.0724
1443: )
1437: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a22 NUMBER := 0-1962.0724
1439: , p5_a23 DATE := fnd_api.g_miss_date
1440: , p5_a24 NUMBER := 0-1962.0724
1441: , p5_a25 DATE := fnd_api.g_miss_date
1442: , p5_a26 NUMBER := 0-1962.0724
1443: )
1444:
1445: as
1593: , x_msg_count out nocopy NUMBER
1594: , x_msg_data out nocopy VARCHAR2
1595: , p5_a0 NUMBER := 0-1962.0724
1596: , p5_a1 NUMBER := 0-1962.0724
1597: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a4 DATE := fnd_api.g_miss_date
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1594: , x_msg_data out nocopy VARCHAR2
1595: , p5_a0 NUMBER := 0-1962.0724
1596: , p5_a1 NUMBER := 0-1962.0724
1597: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a4 DATE := fnd_api.g_miss_date
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a0 NUMBER := 0-1962.0724
1596: , p5_a1 NUMBER := 0-1962.0724
1597: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a4 DATE := fnd_api.g_miss_date
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a1 NUMBER := 0-1962.0724
1597: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a4 DATE := fnd_api.g_miss_date
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a4 DATE := fnd_api.g_miss_date
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a4 DATE := fnd_api.g_miss_date
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a4 DATE := fnd_api.g_miss_date
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a5 DATE := fnd_api.g_miss_date
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1606: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1608: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1616: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1609: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1616: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1617: , p5_a22 NUMBER := 0-1962.0724
1610: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1616: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1617: , p5_a22 NUMBER := 0-1962.0724
1618: , p5_a23 DATE := fnd_api.g_miss_date
1611: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1616: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1617: , p5_a22 NUMBER := 0-1962.0724
1618: , p5_a23 DATE := fnd_api.g_miss_date
1619: , p5_a24 NUMBER := 0-1962.0724
1612: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1613: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1616: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1617: , p5_a22 NUMBER := 0-1962.0724
1618: , p5_a23 DATE := fnd_api.g_miss_date
1619: , p5_a24 NUMBER := 0-1962.0724
1620: , p5_a25 DATE := fnd_api.g_miss_date
1614: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1615: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1616: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1617: , p5_a22 NUMBER := 0-1962.0724
1618: , p5_a23 DATE := fnd_api.g_miss_date
1619: , p5_a24 NUMBER := 0-1962.0724
1620: , p5_a25 DATE := fnd_api.g_miss_date
1621: , p5_a26 NUMBER := 0-1962.0724
1622: )
1616: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1617: , p5_a22 NUMBER := 0-1962.0724
1618: , p5_a23 DATE := fnd_api.g_miss_date
1619: , p5_a24 NUMBER := 0-1962.0724
1620: , p5_a25 DATE := fnd_api.g_miss_date
1621: , p5_a26 NUMBER := 0-1962.0724
1622: )
1623:
1624: as
1784: , p6_a11 out nocopy NUMBER
1785: , p5_a0 NUMBER := 0-1962.0724
1786: , p5_a1 NUMBER := 0-1962.0724
1787: , p5_a2 NUMBER := 0-1962.0724
1788: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 DATE := fnd_api.g_miss_date
1791: , p5_a6 DATE := fnd_api.g_miss_date
1792: , p5_a7 NUMBER := 0-1962.0724
1785: , p5_a0 NUMBER := 0-1962.0724
1786: , p5_a1 NUMBER := 0-1962.0724
1787: , p5_a2 NUMBER := 0-1962.0724
1788: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 DATE := fnd_api.g_miss_date
1791: , p5_a6 DATE := fnd_api.g_miss_date
1792: , p5_a7 NUMBER := 0-1962.0724
1793: , p5_a8 DATE := fnd_api.g_miss_date
1786: , p5_a1 NUMBER := 0-1962.0724
1787: , p5_a2 NUMBER := 0-1962.0724
1788: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 DATE := fnd_api.g_miss_date
1791: , p5_a6 DATE := fnd_api.g_miss_date
1792: , p5_a7 NUMBER := 0-1962.0724
1793: , p5_a8 DATE := fnd_api.g_miss_date
1794: , p5_a9 NUMBER := 0-1962.0724
1787: , p5_a2 NUMBER := 0-1962.0724
1788: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 DATE := fnd_api.g_miss_date
1791: , p5_a6 DATE := fnd_api.g_miss_date
1792: , p5_a7 NUMBER := 0-1962.0724
1793: , p5_a8 DATE := fnd_api.g_miss_date
1794: , p5_a9 NUMBER := 0-1962.0724
1795: , p5_a10 DATE := fnd_api.g_miss_date
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 DATE := fnd_api.g_miss_date
1791: , p5_a6 DATE := fnd_api.g_miss_date
1792: , p5_a7 NUMBER := 0-1962.0724
1793: , p5_a8 DATE := fnd_api.g_miss_date
1794: , p5_a9 NUMBER := 0-1962.0724
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 NUMBER := 0-1962.0724
1797: )
1791: , p5_a6 DATE := fnd_api.g_miss_date
1792: , p5_a7 NUMBER := 0-1962.0724
1793: , p5_a8 DATE := fnd_api.g_miss_date
1794: , p5_a9 NUMBER := 0-1962.0724
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 NUMBER := 0-1962.0724
1797: )
1798:
1799: as
1919: , x_msg_data out nocopy VARCHAR2
1920: , p5_a0 NUMBER := 0-1962.0724
1921: , p5_a1 NUMBER := 0-1962.0724
1922: , p5_a2 NUMBER := 0-1962.0724
1923: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a5 DATE := fnd_api.g_miss_date
1926: , p5_a6 DATE := fnd_api.g_miss_date
1927: , p5_a7 NUMBER := 0-1962.0724
1920: , p5_a0 NUMBER := 0-1962.0724
1921: , p5_a1 NUMBER := 0-1962.0724
1922: , p5_a2 NUMBER := 0-1962.0724
1923: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a5 DATE := fnd_api.g_miss_date
1926: , p5_a6 DATE := fnd_api.g_miss_date
1927: , p5_a7 NUMBER := 0-1962.0724
1928: , p5_a8 DATE := fnd_api.g_miss_date
1921: , p5_a1 NUMBER := 0-1962.0724
1922: , p5_a2 NUMBER := 0-1962.0724
1923: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a5 DATE := fnd_api.g_miss_date
1926: , p5_a6 DATE := fnd_api.g_miss_date
1927: , p5_a7 NUMBER := 0-1962.0724
1928: , p5_a8 DATE := fnd_api.g_miss_date
1929: , p5_a9 NUMBER := 0-1962.0724
1922: , p5_a2 NUMBER := 0-1962.0724
1923: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a5 DATE := fnd_api.g_miss_date
1926: , p5_a6 DATE := fnd_api.g_miss_date
1927: , p5_a7 NUMBER := 0-1962.0724
1928: , p5_a8 DATE := fnd_api.g_miss_date
1929: , p5_a9 NUMBER := 0-1962.0724
1930: , p5_a10 DATE := fnd_api.g_miss_date
1924: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a5 DATE := fnd_api.g_miss_date
1926: , p5_a6 DATE := fnd_api.g_miss_date
1927: , p5_a7 NUMBER := 0-1962.0724
1928: , p5_a8 DATE := fnd_api.g_miss_date
1929: , p5_a9 NUMBER := 0-1962.0724
1930: , p5_a10 DATE := fnd_api.g_miss_date
1931: , p5_a11 NUMBER := 0-1962.0724
1932: )
1926: , p5_a6 DATE := fnd_api.g_miss_date
1927: , p5_a7 NUMBER := 0-1962.0724
1928: , p5_a8 DATE := fnd_api.g_miss_date
1929: , p5_a9 NUMBER := 0-1962.0724
1930: , p5_a10 DATE := fnd_api.g_miss_date
1931: , p5_a11 NUMBER := 0-1962.0724
1932: )
1933:
1934: as
2079: , p6_a11 out nocopy NUMBER
2080: , p5_a0 NUMBER := 0-1962.0724
2081: , p5_a1 NUMBER := 0-1962.0724
2082: , p5_a2 NUMBER := 0-1962.0724
2083: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2084: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2085: , p5_a5 DATE := fnd_api.g_miss_date
2086: , p5_a6 DATE := fnd_api.g_miss_date
2087: , p5_a7 NUMBER := 0-1962.0724
2080: , p5_a0 NUMBER := 0-1962.0724
2081: , p5_a1 NUMBER := 0-1962.0724
2082: , p5_a2 NUMBER := 0-1962.0724
2083: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2084: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2085: , p5_a5 DATE := fnd_api.g_miss_date
2086: , p5_a6 DATE := fnd_api.g_miss_date
2087: , p5_a7 NUMBER := 0-1962.0724
2088: , p5_a8 DATE := fnd_api.g_miss_date
2081: , p5_a1 NUMBER := 0-1962.0724
2082: , p5_a2 NUMBER := 0-1962.0724
2083: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2084: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2085: , p5_a5 DATE := fnd_api.g_miss_date
2086: , p5_a6 DATE := fnd_api.g_miss_date
2087: , p5_a7 NUMBER := 0-1962.0724
2088: , p5_a8 DATE := fnd_api.g_miss_date
2089: , p5_a9 NUMBER := 0-1962.0724
2082: , p5_a2 NUMBER := 0-1962.0724
2083: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2084: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2085: , p5_a5 DATE := fnd_api.g_miss_date
2086: , p5_a6 DATE := fnd_api.g_miss_date
2087: , p5_a7 NUMBER := 0-1962.0724
2088: , p5_a8 DATE := fnd_api.g_miss_date
2089: , p5_a9 NUMBER := 0-1962.0724
2090: , p5_a10 DATE := fnd_api.g_miss_date
2084: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2085: , p5_a5 DATE := fnd_api.g_miss_date
2086: , p5_a6 DATE := fnd_api.g_miss_date
2087: , p5_a7 NUMBER := 0-1962.0724
2088: , p5_a8 DATE := fnd_api.g_miss_date
2089: , p5_a9 NUMBER := 0-1962.0724
2090: , p5_a10 DATE := fnd_api.g_miss_date
2091: , p5_a11 NUMBER := 0-1962.0724
2092: )
2086: , p5_a6 DATE := fnd_api.g_miss_date
2087: , p5_a7 NUMBER := 0-1962.0724
2088: , p5_a8 DATE := fnd_api.g_miss_date
2089: , p5_a9 NUMBER := 0-1962.0724
2090: , p5_a10 DATE := fnd_api.g_miss_date
2091: , p5_a11 NUMBER := 0-1962.0724
2092: )
2093:
2094: as
2214: , x_msg_data out nocopy VARCHAR2
2215: , p5_a0 NUMBER := 0-1962.0724
2216: , p5_a1 NUMBER := 0-1962.0724
2217: , p5_a2 NUMBER := 0-1962.0724
2218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2220: , p5_a5 DATE := fnd_api.g_miss_date
2221: , p5_a6 DATE := fnd_api.g_miss_date
2222: , p5_a7 NUMBER := 0-1962.0724
2215: , p5_a0 NUMBER := 0-1962.0724
2216: , p5_a1 NUMBER := 0-1962.0724
2217: , p5_a2 NUMBER := 0-1962.0724
2218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2220: , p5_a5 DATE := fnd_api.g_miss_date
2221: , p5_a6 DATE := fnd_api.g_miss_date
2222: , p5_a7 NUMBER := 0-1962.0724
2223: , p5_a8 DATE := fnd_api.g_miss_date
2216: , p5_a1 NUMBER := 0-1962.0724
2217: , p5_a2 NUMBER := 0-1962.0724
2218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2220: , p5_a5 DATE := fnd_api.g_miss_date
2221: , p5_a6 DATE := fnd_api.g_miss_date
2222: , p5_a7 NUMBER := 0-1962.0724
2223: , p5_a8 DATE := fnd_api.g_miss_date
2224: , p5_a9 NUMBER := 0-1962.0724
2217: , p5_a2 NUMBER := 0-1962.0724
2218: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2220: , p5_a5 DATE := fnd_api.g_miss_date
2221: , p5_a6 DATE := fnd_api.g_miss_date
2222: , p5_a7 NUMBER := 0-1962.0724
2223: , p5_a8 DATE := fnd_api.g_miss_date
2224: , p5_a9 NUMBER := 0-1962.0724
2225: , p5_a10 DATE := fnd_api.g_miss_date
2219: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2220: , p5_a5 DATE := fnd_api.g_miss_date
2221: , p5_a6 DATE := fnd_api.g_miss_date
2222: , p5_a7 NUMBER := 0-1962.0724
2223: , p5_a8 DATE := fnd_api.g_miss_date
2224: , p5_a9 NUMBER := 0-1962.0724
2225: , p5_a10 DATE := fnd_api.g_miss_date
2226: , p5_a11 NUMBER := 0-1962.0724
2227: )
2221: , p5_a6 DATE := fnd_api.g_miss_date
2222: , p5_a7 NUMBER := 0-1962.0724
2223: , p5_a8 DATE := fnd_api.g_miss_date
2224: , p5_a9 NUMBER := 0-1962.0724
2225: , p5_a10 DATE := fnd_api.g_miss_date
2226: , p5_a11 NUMBER := 0-1962.0724
2227: )
2228:
2229: as
2333: , x_msg_data out nocopy VARCHAR2
2334: , p5_a0 NUMBER := 0-1962.0724
2335: , p5_a1 NUMBER := 0-1962.0724
2336: , p5_a2 NUMBER := 0-1962.0724
2337: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2339: , p5_a5 DATE := fnd_api.g_miss_date
2340: , p5_a6 DATE := fnd_api.g_miss_date
2341: , p5_a7 NUMBER := 0-1962.0724
2334: , p5_a0 NUMBER := 0-1962.0724
2335: , p5_a1 NUMBER := 0-1962.0724
2336: , p5_a2 NUMBER := 0-1962.0724
2337: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2339: , p5_a5 DATE := fnd_api.g_miss_date
2340: , p5_a6 DATE := fnd_api.g_miss_date
2341: , p5_a7 NUMBER := 0-1962.0724
2342: , p5_a8 DATE := fnd_api.g_miss_date
2335: , p5_a1 NUMBER := 0-1962.0724
2336: , p5_a2 NUMBER := 0-1962.0724
2337: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2339: , p5_a5 DATE := fnd_api.g_miss_date
2340: , p5_a6 DATE := fnd_api.g_miss_date
2341: , p5_a7 NUMBER := 0-1962.0724
2342: , p5_a8 DATE := fnd_api.g_miss_date
2343: , p5_a9 NUMBER := 0-1962.0724
2336: , p5_a2 NUMBER := 0-1962.0724
2337: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2339: , p5_a5 DATE := fnd_api.g_miss_date
2340: , p5_a6 DATE := fnd_api.g_miss_date
2341: , p5_a7 NUMBER := 0-1962.0724
2342: , p5_a8 DATE := fnd_api.g_miss_date
2343: , p5_a9 NUMBER := 0-1962.0724
2344: , p5_a10 DATE := fnd_api.g_miss_date
2338: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2339: , p5_a5 DATE := fnd_api.g_miss_date
2340: , p5_a6 DATE := fnd_api.g_miss_date
2341: , p5_a7 NUMBER := 0-1962.0724
2342: , p5_a8 DATE := fnd_api.g_miss_date
2343: , p5_a9 NUMBER := 0-1962.0724
2344: , p5_a10 DATE := fnd_api.g_miss_date
2345: , p5_a11 NUMBER := 0-1962.0724
2346: )
2340: , p5_a6 DATE := fnd_api.g_miss_date
2341: , p5_a7 NUMBER := 0-1962.0724
2342: , p5_a8 DATE := fnd_api.g_miss_date
2343: , p5_a9 NUMBER := 0-1962.0724
2344: , p5_a10 DATE := fnd_api.g_miss_date
2345: , p5_a11 NUMBER := 0-1962.0724
2346: )
2347:
2348: as