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;
65: , p6_a38 out nocopy VARCHAR2
66: , p6_a39 out nocopy NUMBER
67: , p5_a0 NUMBER := 0-1962.0724
68: , p5_a1 NUMBER := 0-1962.0724
69: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
66: , p6_a39 out nocopy NUMBER
67: , p5_a0 NUMBER := 0-1962.0724
68: , p5_a1 NUMBER := 0-1962.0724
69: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
67: , p5_a0 NUMBER := 0-1962.0724
68: , p5_a1 NUMBER := 0-1962.0724
69: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a1 NUMBER := 0-1962.0724
69: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a6 DATE := fnd_api.g_miss_date
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a7 DATE := fnd_api.g_miss_date
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a25 NUMBER := 0-1962.0724
85: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a25 NUMBER := 0-1962.0724
93: , p5_a26 NUMBER := 0-1962.0724
86: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a25 NUMBER := 0-1962.0724
93: , p5_a26 NUMBER := 0-1962.0724
94: , p5_a27 NUMBER := 0-1962.0724
87: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a25 NUMBER := 0-1962.0724
93: , p5_a26 NUMBER := 0-1962.0724
94: , p5_a27 NUMBER := 0-1962.0724
95: , p5_a28 NUMBER := 0-1962.0724
92: , p5_a25 NUMBER := 0-1962.0724
93: , p5_a26 NUMBER := 0-1962.0724
94: , p5_a27 NUMBER := 0-1962.0724
95: , p5_a28 NUMBER := 0-1962.0724
96: , p5_a29 DATE := fnd_api.g_miss_date
97: , p5_a30 NUMBER := 0-1962.0724
98: , p5_a31 DATE := fnd_api.g_miss_date
99: , p5_a32 NUMBER := 0-1962.0724
100: , p5_a33 DATE := fnd_api.g_miss_date
94: , p5_a27 NUMBER := 0-1962.0724
95: , p5_a28 NUMBER := 0-1962.0724
96: , p5_a29 DATE := fnd_api.g_miss_date
97: , p5_a30 NUMBER := 0-1962.0724
98: , p5_a31 DATE := fnd_api.g_miss_date
99: , p5_a32 NUMBER := 0-1962.0724
100: , p5_a33 DATE := fnd_api.g_miss_date
101: , p5_a34 NUMBER := 0-1962.0724
102: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a29 DATE := fnd_api.g_miss_date
97: , p5_a30 NUMBER := 0-1962.0724
98: , p5_a31 DATE := fnd_api.g_miss_date
99: , p5_a32 NUMBER := 0-1962.0724
100: , p5_a33 DATE := fnd_api.g_miss_date
101: , p5_a34 NUMBER := 0-1962.0724
102: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a36 DATE := fnd_api.g_miss_date
104: , p5_a37 NUMBER := 0-1962.0724
98: , p5_a31 DATE := fnd_api.g_miss_date
99: , p5_a32 NUMBER := 0-1962.0724
100: , p5_a33 DATE := fnd_api.g_miss_date
101: , p5_a34 NUMBER := 0-1962.0724
102: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a36 DATE := fnd_api.g_miss_date
104: , p5_a37 NUMBER := 0-1962.0724
105: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a39 NUMBER := 0-1962.0724
99: , p5_a32 NUMBER := 0-1962.0724
100: , p5_a33 DATE := fnd_api.g_miss_date
101: , p5_a34 NUMBER := 0-1962.0724
102: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a36 DATE := fnd_api.g_miss_date
104: , p5_a37 NUMBER := 0-1962.0724
105: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a39 NUMBER := 0-1962.0724
107: )
101: , p5_a34 NUMBER := 0-1962.0724
102: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a36 DATE := fnd_api.g_miss_date
104: , p5_a37 NUMBER := 0-1962.0724
105: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a39 NUMBER := 0-1962.0724
107: )
108:
109: as
264: , p6_a38 out nocopy VARCHAR2
265: , p6_a39 out nocopy NUMBER
266: , p5_a0 NUMBER := 0-1962.0724
267: , p5_a1 NUMBER := 0-1962.0724
268: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
265: , p6_a39 out nocopy NUMBER
266: , p5_a0 NUMBER := 0-1962.0724
267: , p5_a1 NUMBER := 0-1962.0724
268: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
266: , p5_a0 NUMBER := 0-1962.0724
267: , p5_a1 NUMBER := 0-1962.0724
268: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a1 NUMBER := 0-1962.0724
268: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a6 DATE := fnd_api.g_miss_date
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a7 DATE := fnd_api.g_miss_date
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a25 NUMBER := 0-1962.0724
284: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a25 NUMBER := 0-1962.0724
292: , p5_a26 NUMBER := 0-1962.0724
285: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a25 NUMBER := 0-1962.0724
292: , p5_a26 NUMBER := 0-1962.0724
293: , p5_a27 NUMBER := 0-1962.0724
286: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
290: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a25 NUMBER := 0-1962.0724
292: , p5_a26 NUMBER := 0-1962.0724
293: , p5_a27 NUMBER := 0-1962.0724
294: , p5_a28 NUMBER := 0-1962.0724
291: , p5_a25 NUMBER := 0-1962.0724
292: , p5_a26 NUMBER := 0-1962.0724
293: , p5_a27 NUMBER := 0-1962.0724
294: , p5_a28 NUMBER := 0-1962.0724
295: , p5_a29 DATE := fnd_api.g_miss_date
296: , p5_a30 NUMBER := 0-1962.0724
297: , p5_a31 DATE := fnd_api.g_miss_date
298: , p5_a32 NUMBER := 0-1962.0724
299: , p5_a33 DATE := fnd_api.g_miss_date
293: , p5_a27 NUMBER := 0-1962.0724
294: , p5_a28 NUMBER := 0-1962.0724
295: , p5_a29 DATE := fnd_api.g_miss_date
296: , p5_a30 NUMBER := 0-1962.0724
297: , p5_a31 DATE := fnd_api.g_miss_date
298: , p5_a32 NUMBER := 0-1962.0724
299: , p5_a33 DATE := fnd_api.g_miss_date
300: , p5_a34 NUMBER := 0-1962.0724
301: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a29 DATE := fnd_api.g_miss_date
296: , p5_a30 NUMBER := 0-1962.0724
297: , p5_a31 DATE := fnd_api.g_miss_date
298: , p5_a32 NUMBER := 0-1962.0724
299: , p5_a33 DATE := fnd_api.g_miss_date
300: , p5_a34 NUMBER := 0-1962.0724
301: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a36 DATE := fnd_api.g_miss_date
303: , p5_a37 NUMBER := 0-1962.0724
297: , p5_a31 DATE := fnd_api.g_miss_date
298: , p5_a32 NUMBER := 0-1962.0724
299: , p5_a33 DATE := fnd_api.g_miss_date
300: , p5_a34 NUMBER := 0-1962.0724
301: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a36 DATE := fnd_api.g_miss_date
303: , p5_a37 NUMBER := 0-1962.0724
304: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a39 NUMBER := 0-1962.0724
298: , p5_a32 NUMBER := 0-1962.0724
299: , p5_a33 DATE := fnd_api.g_miss_date
300: , p5_a34 NUMBER := 0-1962.0724
301: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a36 DATE := fnd_api.g_miss_date
303: , p5_a37 NUMBER := 0-1962.0724
304: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a39 NUMBER := 0-1962.0724
306: )
300: , p5_a34 NUMBER := 0-1962.0724
301: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a36 DATE := fnd_api.g_miss_date
303: , p5_a37 NUMBER := 0-1962.0724
304: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a39 NUMBER := 0-1962.0724
306: )
307:
308: as
423: , x_msg_count out nocopy NUMBER
424: , x_msg_data out nocopy VARCHAR2
425: , p5_a0 NUMBER := 0-1962.0724
426: , p5_a1 NUMBER := 0-1962.0724
427: , p5_a2 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 DATE := fnd_api.g_miss_date
424: , x_msg_data out nocopy VARCHAR2
425: , p5_a0 NUMBER := 0-1962.0724
426: , p5_a1 NUMBER := 0-1962.0724
427: , p5_a2 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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
425: , p5_a0 NUMBER := 0-1962.0724
426: , p5_a1 NUMBER := 0-1962.0724
427: , p5_a2 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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a1 NUMBER := 0-1962.0724
427: , p5_a2 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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
433: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
434: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a2 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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
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 DATE := fnd_api.g_miss_date
432: , p5_a7 DATE := fnd_api.g_miss_date
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 DATE := fnd_api.g_miss_date
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 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 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 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 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a22 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 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a23 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 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a24 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 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a25 NUMBER := 0-1962.0724
443: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a25 NUMBER := 0-1962.0724
451: , p5_a26 NUMBER := 0-1962.0724
444: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a25 NUMBER := 0-1962.0724
451: , p5_a26 NUMBER := 0-1962.0724
452: , p5_a27 NUMBER := 0-1962.0724
445: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
449: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a25 NUMBER := 0-1962.0724
451: , p5_a26 NUMBER := 0-1962.0724
452: , p5_a27 NUMBER := 0-1962.0724
453: , p5_a28 NUMBER := 0-1962.0724
450: , p5_a25 NUMBER := 0-1962.0724
451: , p5_a26 NUMBER := 0-1962.0724
452: , p5_a27 NUMBER := 0-1962.0724
453: , p5_a28 NUMBER := 0-1962.0724
454: , p5_a29 DATE := fnd_api.g_miss_date
455: , p5_a30 NUMBER := 0-1962.0724
456: , p5_a31 DATE := fnd_api.g_miss_date
457: , p5_a32 NUMBER := 0-1962.0724
458: , p5_a33 DATE := fnd_api.g_miss_date
452: , p5_a27 NUMBER := 0-1962.0724
453: , p5_a28 NUMBER := 0-1962.0724
454: , p5_a29 DATE := fnd_api.g_miss_date
455: , p5_a30 NUMBER := 0-1962.0724
456: , p5_a31 DATE := fnd_api.g_miss_date
457: , p5_a32 NUMBER := 0-1962.0724
458: , p5_a33 DATE := fnd_api.g_miss_date
459: , p5_a34 NUMBER := 0-1962.0724
460: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a29 DATE := fnd_api.g_miss_date
455: , p5_a30 NUMBER := 0-1962.0724
456: , p5_a31 DATE := fnd_api.g_miss_date
457: , p5_a32 NUMBER := 0-1962.0724
458: , p5_a33 DATE := fnd_api.g_miss_date
459: , p5_a34 NUMBER := 0-1962.0724
460: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a36 DATE := fnd_api.g_miss_date
462: , p5_a37 NUMBER := 0-1962.0724
456: , p5_a31 DATE := fnd_api.g_miss_date
457: , p5_a32 NUMBER := 0-1962.0724
458: , p5_a33 DATE := fnd_api.g_miss_date
459: , p5_a34 NUMBER := 0-1962.0724
460: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a36 DATE := fnd_api.g_miss_date
462: , p5_a37 NUMBER := 0-1962.0724
463: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a39 NUMBER := 0-1962.0724
457: , p5_a32 NUMBER := 0-1962.0724
458: , p5_a33 DATE := fnd_api.g_miss_date
459: , p5_a34 NUMBER := 0-1962.0724
460: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a36 DATE := fnd_api.g_miss_date
462: , p5_a37 NUMBER := 0-1962.0724
463: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a39 NUMBER := 0-1962.0724
465: )
459: , p5_a34 NUMBER := 0-1962.0724
460: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a36 DATE := fnd_api.g_miss_date
462: , p5_a37 NUMBER := 0-1962.0724
463: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a39 NUMBER := 0-1962.0724
465: )
466:
467: as
1096: , p6_a38 out nocopy VARCHAR2
1097: , p6_a39 out nocopy NUMBER
1098: , p5_a0 NUMBER := 0-1962.0724
1099: , p5_a1 NUMBER := 0-1962.0724
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1097: , p6_a39 out nocopy NUMBER
1098: , p5_a0 NUMBER := 0-1962.0724
1099: , p5_a1 NUMBER := 0-1962.0724
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1098: , p5_a0 NUMBER := 0-1962.0724
1099: , p5_a1 NUMBER := 0-1962.0724
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a1 NUMBER := 0-1962.0724
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 DATE := fnd_api.g_miss_date
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 DATE := fnd_api.g_miss_date
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a25 NUMBER := 0-1962.0724
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a25 NUMBER := 0-1962.0724
1124: , p5_a26 NUMBER := 0-1962.0724
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a25 NUMBER := 0-1962.0724
1124: , p5_a26 NUMBER := 0-1962.0724
1125: , p5_a27 NUMBER := 0-1962.0724
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a25 NUMBER := 0-1962.0724
1124: , p5_a26 NUMBER := 0-1962.0724
1125: , p5_a27 NUMBER := 0-1962.0724
1126: , p5_a28 NUMBER := 0-1962.0724
1123: , p5_a25 NUMBER := 0-1962.0724
1124: , p5_a26 NUMBER := 0-1962.0724
1125: , p5_a27 NUMBER := 0-1962.0724
1126: , p5_a28 NUMBER := 0-1962.0724
1127: , p5_a29 DATE := fnd_api.g_miss_date
1128: , p5_a30 NUMBER := 0-1962.0724
1129: , p5_a31 DATE := fnd_api.g_miss_date
1130: , p5_a32 NUMBER := 0-1962.0724
1131: , p5_a33 DATE := fnd_api.g_miss_date
1125: , p5_a27 NUMBER := 0-1962.0724
1126: , p5_a28 NUMBER := 0-1962.0724
1127: , p5_a29 DATE := fnd_api.g_miss_date
1128: , p5_a30 NUMBER := 0-1962.0724
1129: , p5_a31 DATE := fnd_api.g_miss_date
1130: , p5_a32 NUMBER := 0-1962.0724
1131: , p5_a33 DATE := fnd_api.g_miss_date
1132: , p5_a34 NUMBER := 0-1962.0724
1133: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a29 DATE := fnd_api.g_miss_date
1128: , p5_a30 NUMBER := 0-1962.0724
1129: , p5_a31 DATE := fnd_api.g_miss_date
1130: , p5_a32 NUMBER := 0-1962.0724
1131: , p5_a33 DATE := fnd_api.g_miss_date
1132: , p5_a34 NUMBER := 0-1962.0724
1133: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a36 DATE := fnd_api.g_miss_date
1135: , p5_a37 NUMBER := 0-1962.0724
1129: , p5_a31 DATE := fnd_api.g_miss_date
1130: , p5_a32 NUMBER := 0-1962.0724
1131: , p5_a33 DATE := fnd_api.g_miss_date
1132: , p5_a34 NUMBER := 0-1962.0724
1133: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a36 DATE := fnd_api.g_miss_date
1135: , p5_a37 NUMBER := 0-1962.0724
1136: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a39 NUMBER := 0-1962.0724
1130: , p5_a32 NUMBER := 0-1962.0724
1131: , p5_a33 DATE := fnd_api.g_miss_date
1132: , p5_a34 NUMBER := 0-1962.0724
1133: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a36 DATE := fnd_api.g_miss_date
1135: , p5_a37 NUMBER := 0-1962.0724
1136: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a39 NUMBER := 0-1962.0724
1138: )
1132: , p5_a34 NUMBER := 0-1962.0724
1133: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a36 DATE := fnd_api.g_miss_date
1135: , p5_a37 NUMBER := 0-1962.0724
1136: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a39 NUMBER := 0-1962.0724
1138: )
1139:
1140: as
1295: , p6_a38 out nocopy VARCHAR2
1296: , p6_a39 out nocopy NUMBER
1297: , p5_a0 NUMBER := 0-1962.0724
1298: , p5_a1 NUMBER := 0-1962.0724
1299: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1296: , p6_a39 out nocopy NUMBER
1297: , p5_a0 NUMBER := 0-1962.0724
1298: , p5_a1 NUMBER := 0-1962.0724
1299: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1297: , p5_a0 NUMBER := 0-1962.0724
1298: , p5_a1 NUMBER := 0-1962.0724
1299: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a1 NUMBER := 0-1962.0724
1299: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a6 DATE := fnd_api.g_miss_date
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a7 DATE := fnd_api.g_miss_date
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1305: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1306: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1307: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1308: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1309: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1310: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1311: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1312: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1313: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1314: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1322: , p5_a25 NUMBER := 0-1962.0724
1315: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1322: , p5_a25 NUMBER := 0-1962.0724
1323: , p5_a26 NUMBER := 0-1962.0724
1316: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1322: , p5_a25 NUMBER := 0-1962.0724
1323: , p5_a26 NUMBER := 0-1962.0724
1324: , p5_a27 NUMBER := 0-1962.0724
1317: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1318: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1319: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1320: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1321: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1322: , p5_a25 NUMBER := 0-1962.0724
1323: , p5_a26 NUMBER := 0-1962.0724
1324: , p5_a27 NUMBER := 0-1962.0724
1325: , p5_a28 NUMBER := 0-1962.0724
1322: , p5_a25 NUMBER := 0-1962.0724
1323: , p5_a26 NUMBER := 0-1962.0724
1324: , p5_a27 NUMBER := 0-1962.0724
1325: , p5_a28 NUMBER := 0-1962.0724
1326: , p5_a29 DATE := fnd_api.g_miss_date
1327: , p5_a30 NUMBER := 0-1962.0724
1328: , p5_a31 DATE := fnd_api.g_miss_date
1329: , p5_a32 NUMBER := 0-1962.0724
1330: , p5_a33 DATE := fnd_api.g_miss_date
1324: , p5_a27 NUMBER := 0-1962.0724
1325: , p5_a28 NUMBER := 0-1962.0724
1326: , p5_a29 DATE := fnd_api.g_miss_date
1327: , p5_a30 NUMBER := 0-1962.0724
1328: , p5_a31 DATE := fnd_api.g_miss_date
1329: , p5_a32 NUMBER := 0-1962.0724
1330: , p5_a33 DATE := fnd_api.g_miss_date
1331: , p5_a34 NUMBER := 0-1962.0724
1332: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1326: , p5_a29 DATE := fnd_api.g_miss_date
1327: , p5_a30 NUMBER := 0-1962.0724
1328: , p5_a31 DATE := fnd_api.g_miss_date
1329: , p5_a32 NUMBER := 0-1962.0724
1330: , p5_a33 DATE := fnd_api.g_miss_date
1331: , p5_a34 NUMBER := 0-1962.0724
1332: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a36 DATE := fnd_api.g_miss_date
1334: , p5_a37 NUMBER := 0-1962.0724
1328: , p5_a31 DATE := fnd_api.g_miss_date
1329: , p5_a32 NUMBER := 0-1962.0724
1330: , p5_a33 DATE := fnd_api.g_miss_date
1331: , p5_a34 NUMBER := 0-1962.0724
1332: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a36 DATE := fnd_api.g_miss_date
1334: , p5_a37 NUMBER := 0-1962.0724
1335: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a39 NUMBER := 0-1962.0724
1329: , p5_a32 NUMBER := 0-1962.0724
1330: , p5_a33 DATE := fnd_api.g_miss_date
1331: , p5_a34 NUMBER := 0-1962.0724
1332: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a36 DATE := fnd_api.g_miss_date
1334: , p5_a37 NUMBER := 0-1962.0724
1335: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a39 NUMBER := 0-1962.0724
1337: )
1331: , p5_a34 NUMBER := 0-1962.0724
1332: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a36 DATE := fnd_api.g_miss_date
1334: , p5_a37 NUMBER := 0-1962.0724
1335: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a39 NUMBER := 0-1962.0724
1337: )
1338:
1339: as
1454: , x_msg_count out nocopy NUMBER
1455: , x_msg_data out nocopy VARCHAR2
1456: , p5_a0 NUMBER := 0-1962.0724
1457: , p5_a1 NUMBER := 0-1962.0724
1458: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1455: , x_msg_data out nocopy VARCHAR2
1456: , p5_a0 NUMBER := 0-1962.0724
1457: , p5_a1 NUMBER := 0-1962.0724
1458: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1456: , p5_a0 NUMBER := 0-1962.0724
1457: , p5_a1 NUMBER := 0-1962.0724
1458: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a1 NUMBER := 0-1962.0724
1458: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a6 DATE := fnd_api.g_miss_date
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a7 DATE := fnd_api.g_miss_date
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a25 NUMBER := 0-1962.0724
1474: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a25 NUMBER := 0-1962.0724
1482: , p5_a26 NUMBER := 0-1962.0724
1475: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a25 NUMBER := 0-1962.0724
1482: , p5_a26 NUMBER := 0-1962.0724
1483: , p5_a27 NUMBER := 0-1962.0724
1476: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a25 NUMBER := 0-1962.0724
1482: , p5_a26 NUMBER := 0-1962.0724
1483: , p5_a27 NUMBER := 0-1962.0724
1484: , p5_a28 NUMBER := 0-1962.0724
1481: , p5_a25 NUMBER := 0-1962.0724
1482: , p5_a26 NUMBER := 0-1962.0724
1483: , p5_a27 NUMBER := 0-1962.0724
1484: , p5_a28 NUMBER := 0-1962.0724
1485: , p5_a29 DATE := fnd_api.g_miss_date
1486: , p5_a30 NUMBER := 0-1962.0724
1487: , p5_a31 DATE := fnd_api.g_miss_date
1488: , p5_a32 NUMBER := 0-1962.0724
1489: , p5_a33 DATE := fnd_api.g_miss_date
1483: , p5_a27 NUMBER := 0-1962.0724
1484: , p5_a28 NUMBER := 0-1962.0724
1485: , p5_a29 DATE := fnd_api.g_miss_date
1486: , p5_a30 NUMBER := 0-1962.0724
1487: , p5_a31 DATE := fnd_api.g_miss_date
1488: , p5_a32 NUMBER := 0-1962.0724
1489: , p5_a33 DATE := fnd_api.g_miss_date
1490: , p5_a34 NUMBER := 0-1962.0724
1491: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a29 DATE := fnd_api.g_miss_date
1486: , p5_a30 NUMBER := 0-1962.0724
1487: , p5_a31 DATE := fnd_api.g_miss_date
1488: , p5_a32 NUMBER := 0-1962.0724
1489: , p5_a33 DATE := fnd_api.g_miss_date
1490: , p5_a34 NUMBER := 0-1962.0724
1491: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a36 DATE := fnd_api.g_miss_date
1493: , p5_a37 NUMBER := 0-1962.0724
1487: , p5_a31 DATE := fnd_api.g_miss_date
1488: , p5_a32 NUMBER := 0-1962.0724
1489: , p5_a33 DATE := fnd_api.g_miss_date
1490: , p5_a34 NUMBER := 0-1962.0724
1491: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a36 DATE := fnd_api.g_miss_date
1493: , p5_a37 NUMBER := 0-1962.0724
1494: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a39 NUMBER := 0-1962.0724
1488: , p5_a32 NUMBER := 0-1962.0724
1489: , p5_a33 DATE := fnd_api.g_miss_date
1490: , p5_a34 NUMBER := 0-1962.0724
1491: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a36 DATE := fnd_api.g_miss_date
1493: , p5_a37 NUMBER := 0-1962.0724
1494: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a39 NUMBER := 0-1962.0724
1496: )
1490: , p5_a34 NUMBER := 0-1962.0724
1491: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1492: , p5_a36 DATE := fnd_api.g_miss_date
1493: , p5_a37 NUMBER := 0-1962.0724
1494: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1495: , p5_a39 NUMBER := 0-1962.0724
1496: )
1497:
1498: as