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;
34: , p0_a0 NUMBER := 0-1962.0724
35: , p0_a1 NUMBER := 0-1962.0724
36: , p0_a2 NUMBER := 0-1962.0724
37: , p0_a3 NUMBER := 0-1962.0724
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
41: , p0_a7 NUMBER := 0-1962.0724
42: , p0_a8 DATE := fnd_api.g_miss_date
36: , p0_a2 NUMBER := 0-1962.0724
37: , p0_a3 NUMBER := 0-1962.0724
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
41: , p0_a7 NUMBER := 0-1962.0724
42: , p0_a8 DATE := fnd_api.g_miss_date
43: , p0_a9 NUMBER := 0-1962.0724
44: )
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
41: , p0_a7 NUMBER := 0-1962.0724
42: , p0_a8 DATE := fnd_api.g_miss_date
43: , p0_a9 NUMBER := 0-1962.0724
44: )
45:
46: as
109: , p7_a8 out nocopy DATE
110: , p7_a9 out nocopy NUMBER
111: , p5_a0 NUMBER := 0-1962.0724
112: , p5_a1 NUMBER := 0-1962.0724
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 NUMBER := 0-1962.0724
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a0 NUMBER := 0-1962.0724
112: , p5_a1 NUMBER := 0-1962.0724
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 NUMBER := 0-1962.0724
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
112: , p5_a1 NUMBER := 0-1962.0724
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 NUMBER := 0-1962.0724
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 NUMBER := 0-1962.0724
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
114: , p5_a3 NUMBER := 0-1962.0724
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
117: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
118: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
119: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
120: , p5_a9 DATE := fnd_api.g_miss_date
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a10 DATE := fnd_api.g_miss_date
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
123: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
126: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
127: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a27 NUMBER := 0-1962.0724
131: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a27 NUMBER := 0-1962.0724
139: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a27 NUMBER := 0-1962.0724
139: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a29 NUMBER := 0-1962.0724
133: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
134: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a27 NUMBER := 0-1962.0724
139: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a29 NUMBER := 0-1962.0724
141: , p5_a30 DATE := fnd_api.g_miss_date
135: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a27 NUMBER := 0-1962.0724
139: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a29 NUMBER := 0-1962.0724
141: , p5_a30 DATE := fnd_api.g_miss_date
142: , p5_a31 NUMBER := 0-1962.0724
143: , p5_a32 DATE := fnd_api.g_miss_date
137: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
138: , p5_a27 NUMBER := 0-1962.0724
139: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a29 NUMBER := 0-1962.0724
141: , p5_a30 DATE := fnd_api.g_miss_date
142: , p5_a31 NUMBER := 0-1962.0724
143: , p5_a32 DATE := fnd_api.g_miss_date
144: , p5_a33 NUMBER := 0-1962.0724
145: , p6_a0 NUMBER := 0-1962.0724
139: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a29 NUMBER := 0-1962.0724
141: , p5_a30 DATE := fnd_api.g_miss_date
142: , p5_a31 NUMBER := 0-1962.0724
143: , p5_a32 DATE := fnd_api.g_miss_date
144: , p5_a33 NUMBER := 0-1962.0724
145: , p6_a0 NUMBER := 0-1962.0724
146: , p6_a1 NUMBER := 0-1962.0724
147: , p6_a2 NUMBER := 0-1962.0724
145: , p6_a0 NUMBER := 0-1962.0724
146: , p6_a1 NUMBER := 0-1962.0724
147: , p6_a2 NUMBER := 0-1962.0724
148: , p6_a3 NUMBER := 0-1962.0724
149: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
150: , p6_a5 NUMBER := 0-1962.0724
151: , p6_a6 DATE := fnd_api.g_miss_date
152: , p6_a7 NUMBER := 0-1962.0724
153: , p6_a8 DATE := fnd_api.g_miss_date
147: , p6_a2 NUMBER := 0-1962.0724
148: , p6_a3 NUMBER := 0-1962.0724
149: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
150: , p6_a5 NUMBER := 0-1962.0724
151: , p6_a6 DATE := fnd_api.g_miss_date
152: , p6_a7 NUMBER := 0-1962.0724
153: , p6_a8 DATE := fnd_api.g_miss_date
154: , p6_a9 NUMBER := 0-1962.0724
155: )
149: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
150: , p6_a5 NUMBER := 0-1962.0724
151: , p6_a6 DATE := fnd_api.g_miss_date
152: , p6_a7 NUMBER := 0-1962.0724
153: , p6_a8 DATE := fnd_api.g_miss_date
154: , p6_a9 NUMBER := 0-1962.0724
155: )
156:
157: as
260: , p7_a8 out nocopy DATE
261: , p7_a9 out nocopy NUMBER
262: , p5_a0 NUMBER := 0-1962.0724
263: , p5_a1 NUMBER := 0-1962.0724
264: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a3 NUMBER := 0-1962.0724
266: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a0 NUMBER := 0-1962.0724
263: , p5_a1 NUMBER := 0-1962.0724
264: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a3 NUMBER := 0-1962.0724
266: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
263: , p5_a1 NUMBER := 0-1962.0724
264: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a3 NUMBER := 0-1962.0724
266: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
264: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a3 NUMBER := 0-1962.0724
266: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
265: , p5_a3 NUMBER := 0-1962.0724
266: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
266: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
267: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
269: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
270: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
271: , p5_a9 DATE := fnd_api.g_miss_date
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
272: , p5_a10 DATE := fnd_api.g_miss_date
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
277: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
278: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
279: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
280: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
281: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a27 NUMBER := 0-1962.0724
282: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a27 NUMBER := 0-1962.0724
290: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a27 NUMBER := 0-1962.0724
290: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a29 NUMBER := 0-1962.0724
284: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
285: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a27 NUMBER := 0-1962.0724
290: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a29 NUMBER := 0-1962.0724
292: , p5_a30 DATE := fnd_api.g_miss_date
286: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
288: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a27 NUMBER := 0-1962.0724
290: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a29 NUMBER := 0-1962.0724
292: , p5_a30 DATE := fnd_api.g_miss_date
293: , p5_a31 NUMBER := 0-1962.0724
294: , p5_a32 DATE := fnd_api.g_miss_date
288: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a27 NUMBER := 0-1962.0724
290: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a29 NUMBER := 0-1962.0724
292: , p5_a30 DATE := fnd_api.g_miss_date
293: , p5_a31 NUMBER := 0-1962.0724
294: , p5_a32 DATE := fnd_api.g_miss_date
295: , p5_a33 NUMBER := 0-1962.0724
296: , p6_a0 NUMBER := 0-1962.0724
290: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
291: , p5_a29 NUMBER := 0-1962.0724
292: , p5_a30 DATE := fnd_api.g_miss_date
293: , p5_a31 NUMBER := 0-1962.0724
294: , p5_a32 DATE := fnd_api.g_miss_date
295: , p5_a33 NUMBER := 0-1962.0724
296: , p6_a0 NUMBER := 0-1962.0724
297: , p6_a1 NUMBER := 0-1962.0724
298: , p6_a2 NUMBER := 0-1962.0724
296: , p6_a0 NUMBER := 0-1962.0724
297: , p6_a1 NUMBER := 0-1962.0724
298: , p6_a2 NUMBER := 0-1962.0724
299: , p6_a3 NUMBER := 0-1962.0724
300: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
301: , p6_a5 NUMBER := 0-1962.0724
302: , p6_a6 DATE := fnd_api.g_miss_date
303: , p6_a7 NUMBER := 0-1962.0724
304: , p6_a8 DATE := fnd_api.g_miss_date
298: , p6_a2 NUMBER := 0-1962.0724
299: , p6_a3 NUMBER := 0-1962.0724
300: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
301: , p6_a5 NUMBER := 0-1962.0724
302: , p6_a6 DATE := fnd_api.g_miss_date
303: , p6_a7 NUMBER := 0-1962.0724
304: , p6_a8 DATE := fnd_api.g_miss_date
305: , p6_a9 NUMBER := 0-1962.0724
306: )
300: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
301: , p6_a5 NUMBER := 0-1962.0724
302: , p6_a6 DATE := fnd_api.g_miss_date
303: , p6_a7 NUMBER := 0-1962.0724
304: , p6_a8 DATE := fnd_api.g_miss_date
305: , p6_a9 NUMBER := 0-1962.0724
306: )
307:
308: as
477: , p7_a8 out nocopy JTF_DATE_TABLE
478: , p7_a9 out nocopy JTF_NUMBER_TABLE
479: , p5_a0 NUMBER := 0-1962.0724
480: , p5_a1 NUMBER := 0-1962.0724
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 NUMBER := 0-1962.0724
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a0 NUMBER := 0-1962.0724
480: , p5_a1 NUMBER := 0-1962.0724
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 NUMBER := 0-1962.0724
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a1 NUMBER := 0-1962.0724
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 NUMBER := 0-1962.0724
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
481: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a3 NUMBER := 0-1962.0724
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
482: , p5_a3 NUMBER := 0-1962.0724
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a9 DATE := fnd_api.g_miss_date
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a10 DATE := fnd_api.g_miss_date
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
495: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a27 NUMBER := 0-1962.0724
499: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a27 NUMBER := 0-1962.0724
507: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
500: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a27 NUMBER := 0-1962.0724
507: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a29 NUMBER := 0-1962.0724
501: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a27 NUMBER := 0-1962.0724
507: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a29 NUMBER := 0-1962.0724
509: , p5_a30 DATE := fnd_api.g_miss_date
503: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
505: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a27 NUMBER := 0-1962.0724
507: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a29 NUMBER := 0-1962.0724
509: , p5_a30 DATE := fnd_api.g_miss_date
510: , p5_a31 NUMBER := 0-1962.0724
511: , p5_a32 DATE := fnd_api.g_miss_date
505: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
506: , p5_a27 NUMBER := 0-1962.0724
507: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a29 NUMBER := 0-1962.0724
509: , p5_a30 DATE := fnd_api.g_miss_date
510: , p5_a31 NUMBER := 0-1962.0724
511: , p5_a32 DATE := fnd_api.g_miss_date
512: , p5_a33 NUMBER := 0-1962.0724
513: )
507: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
508: , p5_a29 NUMBER := 0-1962.0724
509: , p5_a30 DATE := fnd_api.g_miss_date
510: , p5_a31 NUMBER := 0-1962.0724
511: , p5_a32 DATE := fnd_api.g_miss_date
512: , p5_a33 NUMBER := 0-1962.0724
513: )
514:
515: as
630: , p7_a8 out nocopy JTF_DATE_TABLE
631: , p7_a9 out nocopy JTF_NUMBER_TABLE
632: , p5_a0 NUMBER := 0-1962.0724
633: , p5_a1 NUMBER := 0-1962.0724
634: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a3 NUMBER := 0-1962.0724
636: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a0 NUMBER := 0-1962.0724
633: , p5_a1 NUMBER := 0-1962.0724
634: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a3 NUMBER := 0-1962.0724
636: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a1 NUMBER := 0-1962.0724
634: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a3 NUMBER := 0-1962.0724
636: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
634: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
635: , p5_a3 NUMBER := 0-1962.0724
636: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
635: , p5_a3 NUMBER := 0-1962.0724
636: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
637: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
638: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
639: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a9 DATE := fnd_api.g_miss_date
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
642: , p5_a10 DATE := fnd_api.g_miss_date
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
643: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
645: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
646: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
647: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
648: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
650: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a27 NUMBER := 0-1962.0724
652: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a27 NUMBER := 0-1962.0724
660: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a27 NUMBER := 0-1962.0724
660: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a29 NUMBER := 0-1962.0724
654: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a27 NUMBER := 0-1962.0724
660: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a29 NUMBER := 0-1962.0724
662: , p5_a30 DATE := fnd_api.g_miss_date
656: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a27 NUMBER := 0-1962.0724
660: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a29 NUMBER := 0-1962.0724
662: , p5_a30 DATE := fnd_api.g_miss_date
663: , p5_a31 NUMBER := 0-1962.0724
664: , p5_a32 DATE := fnd_api.g_miss_date
658: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a27 NUMBER := 0-1962.0724
660: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a29 NUMBER := 0-1962.0724
662: , p5_a30 DATE := fnd_api.g_miss_date
663: , p5_a31 NUMBER := 0-1962.0724
664: , p5_a32 DATE := fnd_api.g_miss_date
665: , p5_a33 NUMBER := 0-1962.0724
666: )
660: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a29 NUMBER := 0-1962.0724
662: , p5_a30 DATE := fnd_api.g_miss_date
663: , p5_a31 NUMBER := 0-1962.0724
664: , p5_a32 DATE := fnd_api.g_miss_date
665: , p5_a33 NUMBER := 0-1962.0724
666: )
667:
668: as