7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
85: , p9_a27 out nocopy DATE
86: , p9_a28 out nocopy NUMBER
87: , p5_a0 NUMBER := 0-1962.0724
88: , p5_a1 NUMBER := 0-1962.0724
89: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
86: , p9_a28 out nocopy NUMBER
87: , p5_a0 NUMBER := 0-1962.0724
88: , p5_a1 NUMBER := 0-1962.0724
89: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a0 NUMBER := 0-1962.0724
88: , p5_a1 NUMBER := 0-1962.0724
89: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a8 NUMBER := 0-1962.0724
88: , p5_a1 NUMBER := 0-1962.0724
89: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a8 NUMBER := 0-1962.0724
96: , p5_a9 NUMBER := 0-1962.0724
89: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a8 NUMBER := 0-1962.0724
96: , p5_a9 NUMBER := 0-1962.0724
97: , p5_a10 DATE := fnd_api.g_miss_date
90: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a8 NUMBER := 0-1962.0724
96: , p5_a9 NUMBER := 0-1962.0724
97: , p5_a10 DATE := fnd_api.g_miss_date
98: , p5_a11 NUMBER := 0-1962.0724
93: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a8 NUMBER := 0-1962.0724
96: , p5_a9 NUMBER := 0-1962.0724
97: , p5_a10 DATE := fnd_api.g_miss_date
98: , p5_a11 NUMBER := 0-1962.0724
99: , p5_a12 DATE := fnd_api.g_miss_date
100: , p5_a13 NUMBER := 0-1962.0724
101: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a8 NUMBER := 0-1962.0724
96: , p5_a9 NUMBER := 0-1962.0724
97: , p5_a10 DATE := fnd_api.g_miss_date
98: , p5_a11 NUMBER := 0-1962.0724
99: , p5_a12 DATE := fnd_api.g_miss_date
100: , p5_a13 NUMBER := 0-1962.0724
101: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a10 DATE := fnd_api.g_miss_date
98: , p5_a11 NUMBER := 0-1962.0724
99: , p5_a12 DATE := fnd_api.g_miss_date
100: , p5_a13 NUMBER := 0-1962.0724
101: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a11 NUMBER := 0-1962.0724
99: , p5_a12 DATE := fnd_api.g_miss_date
100: , p5_a13 NUMBER := 0-1962.0724
101: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a0 NUMBER := 0-1962.0724
99: , p5_a12 DATE := fnd_api.g_miss_date
100: , p5_a13 NUMBER := 0-1962.0724
101: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a0 NUMBER := 0-1962.0724
107: , p6_a1 NUMBER := 0-1962.0724
100: , p5_a13 NUMBER := 0-1962.0724
101: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a0 NUMBER := 0-1962.0724
107: , p6_a1 NUMBER := 0-1962.0724
108: , p6_a2 NUMBER := 0-1962.0724
101: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a0 NUMBER := 0-1962.0724
107: , p6_a1 NUMBER := 0-1962.0724
108: , p6_a2 NUMBER := 0-1962.0724
109: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a0 NUMBER := 0-1962.0724
107: , p6_a1 NUMBER := 0-1962.0724
108: , p6_a2 NUMBER := 0-1962.0724
109: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
110: , p6_a4 DATE := fnd_api.g_miss_date
111: , p6_a5 DATE := fnd_api.g_miss_date
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a0 NUMBER := 0-1962.0724
107: , p6_a1 NUMBER := 0-1962.0724
108: , p6_a2 NUMBER := 0-1962.0724
109: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
110: , p6_a4 DATE := fnd_api.g_miss_date
111: , p6_a5 DATE := fnd_api.g_miss_date
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
107: , p6_a1 NUMBER := 0-1962.0724
108: , p6_a2 NUMBER := 0-1962.0724
109: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
110: , p6_a4 DATE := fnd_api.g_miss_date
111: , p6_a5 DATE := fnd_api.g_miss_date
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
108: , p6_a2 NUMBER := 0-1962.0724
109: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
110: , p6_a4 DATE := fnd_api.g_miss_date
111: , p6_a5 DATE := fnd_api.g_miss_date
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
109: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
110: , p6_a4 DATE := fnd_api.g_miss_date
111: , p6_a5 DATE := fnd_api.g_miss_date
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
110: , p6_a4 DATE := fnd_api.g_miss_date
111: , p6_a5 DATE := fnd_api.g_miss_date
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
111: , p6_a5 DATE := fnd_api.g_miss_date
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
112: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
113: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
114: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
115: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
116: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
118: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
126: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
119: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
126: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
127: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
120: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
126: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
127: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
128: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
121: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
126: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
127: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
128: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
129: , p6_a23 NUMBER := 0-1962.0724
122: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
126: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
127: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
128: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
129: , p6_a23 NUMBER := 0-1962.0724
130: , p6_a24 NUMBER := 0-1962.0724
123: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
126: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
127: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
128: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
129: , p6_a23 NUMBER := 0-1962.0724
130: , p6_a24 NUMBER := 0-1962.0724
131: , p6_a25 DATE := fnd_api.g_miss_date
124: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
125: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
126: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
127: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
128: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
129: , p6_a23 NUMBER := 0-1962.0724
130: , p6_a24 NUMBER := 0-1962.0724
131: , p6_a25 DATE := fnd_api.g_miss_date
132: , p6_a26 NUMBER := 0-1962.0724
127: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
128: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
129: , p6_a23 NUMBER := 0-1962.0724
130: , p6_a24 NUMBER := 0-1962.0724
131: , p6_a25 DATE := fnd_api.g_miss_date
132: , p6_a26 NUMBER := 0-1962.0724
133: , p6_a27 DATE := fnd_api.g_miss_date
134: , p6_a28 NUMBER := 0-1962.0724
135: )
129: , p6_a23 NUMBER := 0-1962.0724
130: , p6_a24 NUMBER := 0-1962.0724
131: , p6_a25 DATE := fnd_api.g_miss_date
132: , p6_a26 NUMBER := 0-1962.0724
133: , p6_a27 DATE := fnd_api.g_miss_date
134: , p6_a28 NUMBER := 0-1962.0724
135: )
136:
137: as
348: , p9_a27 out nocopy DATE
349: , p9_a28 out nocopy NUMBER
350: , p5_a0 NUMBER := 0-1962.0724
351: , p5_a1 NUMBER := 0-1962.0724
352: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
349: , p9_a28 out nocopy NUMBER
350: , p5_a0 NUMBER := 0-1962.0724
351: , p5_a1 NUMBER := 0-1962.0724
352: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
350: , p5_a0 NUMBER := 0-1962.0724
351: , p5_a1 NUMBER := 0-1962.0724
352: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a8 NUMBER := 0-1962.0724
351: , p5_a1 NUMBER := 0-1962.0724
352: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a8 NUMBER := 0-1962.0724
359: , p5_a9 NUMBER := 0-1962.0724
352: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a8 NUMBER := 0-1962.0724
359: , p5_a9 NUMBER := 0-1962.0724
360: , p5_a10 DATE := fnd_api.g_miss_date
353: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
354: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
355: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
356: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a8 NUMBER := 0-1962.0724
359: , p5_a9 NUMBER := 0-1962.0724
360: , p5_a10 DATE := fnd_api.g_miss_date
361: , p5_a11 NUMBER := 0-1962.0724
356: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
357: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a8 NUMBER := 0-1962.0724
359: , p5_a9 NUMBER := 0-1962.0724
360: , p5_a10 DATE := fnd_api.g_miss_date
361: , p5_a11 NUMBER := 0-1962.0724
362: , p5_a12 DATE := fnd_api.g_miss_date
363: , p5_a13 NUMBER := 0-1962.0724
364: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a8 NUMBER := 0-1962.0724
359: , p5_a9 NUMBER := 0-1962.0724
360: , p5_a10 DATE := fnd_api.g_miss_date
361: , p5_a11 NUMBER := 0-1962.0724
362: , p5_a12 DATE := fnd_api.g_miss_date
363: , p5_a13 NUMBER := 0-1962.0724
364: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
360: , p5_a10 DATE := fnd_api.g_miss_date
361: , p5_a11 NUMBER := 0-1962.0724
362: , p5_a12 DATE := fnd_api.g_miss_date
363: , p5_a13 NUMBER := 0-1962.0724
364: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a11 NUMBER := 0-1962.0724
362: , p5_a12 DATE := fnd_api.g_miss_date
363: , p5_a13 NUMBER := 0-1962.0724
364: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
369: , p6_a0 NUMBER := 0-1962.0724
362: , p5_a12 DATE := fnd_api.g_miss_date
363: , p5_a13 NUMBER := 0-1962.0724
364: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
369: , p6_a0 NUMBER := 0-1962.0724
370: , p6_a1 NUMBER := 0-1962.0724
363: , p5_a13 NUMBER := 0-1962.0724
364: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
369: , p6_a0 NUMBER := 0-1962.0724
370: , p6_a1 NUMBER := 0-1962.0724
371: , p6_a2 NUMBER := 0-1962.0724
364: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
367: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
369: , p6_a0 NUMBER := 0-1962.0724
370: , p6_a1 NUMBER := 0-1962.0724
371: , p6_a2 NUMBER := 0-1962.0724
372: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
368: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
369: , p6_a0 NUMBER := 0-1962.0724
370: , p6_a1 NUMBER := 0-1962.0724
371: , p6_a2 NUMBER := 0-1962.0724
372: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p6_a4 DATE := fnd_api.g_miss_date
374: , p6_a5 DATE := fnd_api.g_miss_date
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
369: , p6_a0 NUMBER := 0-1962.0724
370: , p6_a1 NUMBER := 0-1962.0724
371: , p6_a2 NUMBER := 0-1962.0724
372: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p6_a4 DATE := fnd_api.g_miss_date
374: , p6_a5 DATE := fnd_api.g_miss_date
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
370: , p6_a1 NUMBER := 0-1962.0724
371: , p6_a2 NUMBER := 0-1962.0724
372: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p6_a4 DATE := fnd_api.g_miss_date
374: , p6_a5 DATE := fnd_api.g_miss_date
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
371: , p6_a2 NUMBER := 0-1962.0724
372: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p6_a4 DATE := fnd_api.g_miss_date
374: , p6_a5 DATE := fnd_api.g_miss_date
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
372: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p6_a4 DATE := fnd_api.g_miss_date
374: , p6_a5 DATE := fnd_api.g_miss_date
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
373: , p6_a4 DATE := fnd_api.g_miss_date
374: , p6_a5 DATE := fnd_api.g_miss_date
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
374: , p6_a5 DATE := fnd_api.g_miss_date
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
375: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
376: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
377: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
378: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
379: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
380: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
381: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
389: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
382: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
389: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
390: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
383: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
389: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
390: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
391: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
384: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
389: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
390: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
391: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
392: , p6_a23 NUMBER := 0-1962.0724
385: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
389: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
390: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
391: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
392: , p6_a23 NUMBER := 0-1962.0724
393: , p6_a24 NUMBER := 0-1962.0724
386: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
389: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
390: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
391: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
392: , p6_a23 NUMBER := 0-1962.0724
393: , p6_a24 NUMBER := 0-1962.0724
394: , p6_a25 DATE := fnd_api.g_miss_date
387: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
388: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
389: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
390: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
391: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
392: , p6_a23 NUMBER := 0-1962.0724
393: , p6_a24 NUMBER := 0-1962.0724
394: , p6_a25 DATE := fnd_api.g_miss_date
395: , p6_a26 NUMBER := 0-1962.0724
390: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
391: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
392: , p6_a23 NUMBER := 0-1962.0724
393: , p6_a24 NUMBER := 0-1962.0724
394: , p6_a25 DATE := fnd_api.g_miss_date
395: , p6_a26 NUMBER := 0-1962.0724
396: , p6_a27 DATE := fnd_api.g_miss_date
397: , p6_a28 NUMBER := 0-1962.0724
398: )
392: , p6_a23 NUMBER := 0-1962.0724
393: , p6_a24 NUMBER := 0-1962.0724
394: , p6_a25 DATE := fnd_api.g_miss_date
395: , p6_a26 NUMBER := 0-1962.0724
396: , p6_a27 DATE := fnd_api.g_miss_date
397: , p6_a28 NUMBER := 0-1962.0724
398: )
399:
400: as
1115: , p11_a28 out nocopy NUMBER
1116: , x_pri_purpose_list out nocopy VARCHAR2
1117: , p5_a0 NUMBER := 0-1962.0724
1118: , p5_a1 NUMBER := 0-1962.0724
1119: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1116: , x_pri_purpose_list out nocopy VARCHAR2
1117: , p5_a0 NUMBER := 0-1962.0724
1118: , p5_a1 NUMBER := 0-1962.0724
1119: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a0 NUMBER := 0-1962.0724
1118: , p5_a1 NUMBER := 0-1962.0724
1119: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a8 NUMBER := 0-1962.0724
1118: , p5_a1 NUMBER := 0-1962.0724
1119: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a8 NUMBER := 0-1962.0724
1126: , p5_a9 NUMBER := 0-1962.0724
1119: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a8 NUMBER := 0-1962.0724
1126: , p5_a9 NUMBER := 0-1962.0724
1127: , p5_a10 DATE := fnd_api.g_miss_date
1120: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a8 NUMBER := 0-1962.0724
1126: , p5_a9 NUMBER := 0-1962.0724
1127: , p5_a10 DATE := fnd_api.g_miss_date
1128: , p5_a11 NUMBER := 0-1962.0724
1123: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a8 NUMBER := 0-1962.0724
1126: , p5_a9 NUMBER := 0-1962.0724
1127: , p5_a10 DATE := fnd_api.g_miss_date
1128: , p5_a11 NUMBER := 0-1962.0724
1129: , p5_a12 DATE := fnd_api.g_miss_date
1130: , p5_a13 NUMBER := 0-1962.0724
1131: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a8 NUMBER := 0-1962.0724
1126: , p5_a9 NUMBER := 0-1962.0724
1127: , p5_a10 DATE := fnd_api.g_miss_date
1128: , p5_a11 NUMBER := 0-1962.0724
1129: , p5_a12 DATE := fnd_api.g_miss_date
1130: , p5_a13 NUMBER := 0-1962.0724
1131: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a10 DATE := fnd_api.g_miss_date
1128: , p5_a11 NUMBER := 0-1962.0724
1129: , p5_a12 DATE := fnd_api.g_miss_date
1130: , p5_a13 NUMBER := 0-1962.0724
1131: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a11 NUMBER := 0-1962.0724
1129: , p5_a12 DATE := fnd_api.g_miss_date
1130: , p5_a13 NUMBER := 0-1962.0724
1131: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1136: , p6_a0 NUMBER := 0-1962.0724
1129: , p5_a12 DATE := fnd_api.g_miss_date
1130: , p5_a13 NUMBER := 0-1962.0724
1131: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1136: , p6_a0 NUMBER := 0-1962.0724
1137: , p6_a1 NUMBER := 0-1962.0724
1130: , p5_a13 NUMBER := 0-1962.0724
1131: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1136: , p6_a0 NUMBER := 0-1962.0724
1137: , p6_a1 NUMBER := 0-1962.0724
1138: , p6_a2 NUMBER := 0-1962.0724
1131: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1136: , p6_a0 NUMBER := 0-1962.0724
1137: , p6_a1 NUMBER := 0-1962.0724
1138: , p6_a2 NUMBER := 0-1962.0724
1139: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1136: , p6_a0 NUMBER := 0-1962.0724
1137: , p6_a1 NUMBER := 0-1962.0724
1138: , p6_a2 NUMBER := 0-1962.0724
1139: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1140: , p6_a4 DATE := fnd_api.g_miss_date
1141: , p6_a5 DATE := fnd_api.g_miss_date
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1136: , p6_a0 NUMBER := 0-1962.0724
1137: , p6_a1 NUMBER := 0-1962.0724
1138: , p6_a2 NUMBER := 0-1962.0724
1139: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1140: , p6_a4 DATE := fnd_api.g_miss_date
1141: , p6_a5 DATE := fnd_api.g_miss_date
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1137: , p6_a1 NUMBER := 0-1962.0724
1138: , p6_a2 NUMBER := 0-1962.0724
1139: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1140: , p6_a4 DATE := fnd_api.g_miss_date
1141: , p6_a5 DATE := fnd_api.g_miss_date
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1138: , p6_a2 NUMBER := 0-1962.0724
1139: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1140: , p6_a4 DATE := fnd_api.g_miss_date
1141: , p6_a5 DATE := fnd_api.g_miss_date
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1139: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
1140: , p6_a4 DATE := fnd_api.g_miss_date
1141: , p6_a5 DATE := fnd_api.g_miss_date
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1140: , p6_a4 DATE := fnd_api.g_miss_date
1141: , p6_a5 DATE := fnd_api.g_miss_date
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1141: , p6_a5 DATE := fnd_api.g_miss_date
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1142: , p6_a6 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1143: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1144: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1145: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1146: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1147: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1148: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1156: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1149: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1156: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1157: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1150: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1156: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1157: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1158: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1151: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1156: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1157: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1158: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1159: , p6_a23 NUMBER := 0-1962.0724
1152: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1156: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1157: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1158: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1159: , p6_a23 NUMBER := 0-1962.0724
1160: , p6_a24 NUMBER := 0-1962.0724
1153: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1156: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1157: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1158: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1159: , p6_a23 NUMBER := 0-1962.0724
1160: , p6_a24 NUMBER := 0-1962.0724
1161: , p6_a25 DATE := fnd_api.g_miss_date
1154: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1155: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1156: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
1157: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1158: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1159: , p6_a23 NUMBER := 0-1962.0724
1160: , p6_a24 NUMBER := 0-1962.0724
1161: , p6_a25 DATE := fnd_api.g_miss_date
1162: , p6_a26 NUMBER := 0-1962.0724
1157: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1158: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1159: , p6_a23 NUMBER := 0-1962.0724
1160: , p6_a24 NUMBER := 0-1962.0724
1161: , p6_a25 DATE := fnd_api.g_miss_date
1162: , p6_a26 NUMBER := 0-1962.0724
1163: , p6_a27 DATE := fnd_api.g_miss_date
1164: , p6_a28 NUMBER := 0-1962.0724
1165: )
1159: , p6_a23 NUMBER := 0-1962.0724
1160: , p6_a24 NUMBER := 0-1962.0724
1161: , p6_a25 DATE := fnd_api.g_miss_date
1162: , p6_a26 NUMBER := 0-1962.0724
1163: , p6_a27 DATE := fnd_api.g_miss_date
1164: , p6_a28 NUMBER := 0-1962.0724
1165: )
1166:
1167: as