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