eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_POOL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 27: , a2 JTF_VARCHAR2_TABLE_100

23: end;
24:
25: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_400
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE

Line 32: , a7 JTF_VARCHAR2_TABLE_100

28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_DATE_TABLE
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_DATE_TABLE

Line 39: , a14 JTF_VARCHAR2_TABLE_100

35: , a10 JTF_DATE_TABLE
36: , a11 JTF_DATE_TABLE
37: , a12 JTF_DATE_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_100

Line 43: , a18 JTF_VARCHAR2_TABLE_100

39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_100
44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE

Line 44: , a19 JTF_VARCHAR2_TABLE_100

40: , a15 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_100
44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE

Line 45: , a20 JTF_VARCHAR2_TABLE_100

41: , a16 JTF_NUMBER_TABLE
42: , a17 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_100
44: , a19 JTF_VARCHAR2_TABLE_100
45: , a20 JTF_VARCHAR2_TABLE_100
46: , a21 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE

Line 55: , a30 JTF_VARCHAR2_TABLE_100

51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200
54: , a29 JTF_VARCHAR2_TABLE_200
55: , a30 JTF_VARCHAR2_TABLE_100
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_DATE_TABLE
59: , a34 JTF_NUMBER_TABLE

Line 56: , a31 JTF_VARCHAR2_TABLE_100

52: , a27 JTF_NUMBER_TABLE
53: , a28 JTF_VARCHAR2_TABLE_200
54: , a29 JTF_VARCHAR2_TABLE_200
55: , a30 JTF_VARCHAR2_TABLE_100
56: , a31 JTF_VARCHAR2_TABLE_100
57: , a32 JTF_DATE_TABLE
58: , a33 JTF_DATE_TABLE
59: , a34 JTF_NUMBER_TABLE
60: , a35 JTF_NUMBER_TABLE

Line 63: , a38 JTF_VARCHAR2_TABLE_100

59: , a34 JTF_NUMBER_TABLE
60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_DATE_TABLE
63: , a38 JTF_VARCHAR2_TABLE_100
64: , a39 JTF_VARCHAR2_TABLE_100
65: ) as
66: ddindx binary_integer; indx binary_integer;
67: begin

Line 64: , a39 JTF_VARCHAR2_TABLE_100

60: , a35 JTF_NUMBER_TABLE
61: , a36 JTF_DATE_TABLE
62: , a37 JTF_DATE_TABLE
63: , a38 JTF_VARCHAR2_TABLE_100
64: , a39 JTF_VARCHAR2_TABLE_100
65: ) as
66: ddindx binary_integer; indx binary_integer;
67: begin
68: if a0 is not null and a0.count > 0 then

Line 124: , a2 out nocopy JTF_VARCHAR2_TABLE_100

120: end if;
121: end rosetta_table_copy_in_p46;
122: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_VARCHAR2_TABLE_400
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_NUMBER_TABLE

Line 129: , a7 out nocopy JTF_VARCHAR2_TABLE_100

125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_NUMBER_TABLE
129: , a7 out nocopy JTF_VARCHAR2_TABLE_100
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_DATE_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_DATE_TABLE

Line 136: , a14 out nocopy JTF_VARCHAR2_TABLE_100

132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_DATE_TABLE
134: , a12 out nocopy JTF_DATE_TABLE
135: , a13 out nocopy JTF_NUMBER_TABLE
136: , a14 out nocopy JTF_VARCHAR2_TABLE_100
137: , a15 out nocopy JTF_VARCHAR2_TABLE_500
138: , a16 out nocopy JTF_NUMBER_TABLE
139: , a17 out nocopy JTF_NUMBER_TABLE
140: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , a18 out nocopy JTF_VARCHAR2_TABLE_100

136: , a14 out nocopy JTF_VARCHAR2_TABLE_100
137: , a15 out nocopy JTF_VARCHAR2_TABLE_500
138: , a16 out nocopy JTF_NUMBER_TABLE
139: , a17 out nocopy JTF_NUMBER_TABLE
140: , a18 out nocopy JTF_VARCHAR2_TABLE_100
141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE

Line 141: , a19 out nocopy JTF_VARCHAR2_TABLE_100

137: , a15 out nocopy JTF_VARCHAR2_TABLE_500
138: , a16 out nocopy JTF_NUMBER_TABLE
139: , a17 out nocopy JTF_NUMBER_TABLE
140: , a18 out nocopy JTF_VARCHAR2_TABLE_100
141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE

Line 142: , a20 out nocopy JTF_VARCHAR2_TABLE_100

138: , a16 out nocopy JTF_NUMBER_TABLE
139: , a17 out nocopy JTF_NUMBER_TABLE
140: , a18 out nocopy JTF_VARCHAR2_TABLE_100
141: , a19 out nocopy JTF_VARCHAR2_TABLE_100
142: , a20 out nocopy JTF_VARCHAR2_TABLE_100
143: , a21 out nocopy JTF_NUMBER_TABLE
144: , a22 out nocopy JTF_NUMBER_TABLE
145: , a23 out nocopy JTF_NUMBER_TABLE
146: , a24 out nocopy JTF_NUMBER_TABLE

Line 152: , a30 out nocopy JTF_VARCHAR2_TABLE_100

148: , a26 out nocopy JTF_NUMBER_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200
151: , a29 out nocopy JTF_VARCHAR2_TABLE_200
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: , a32 out nocopy JTF_DATE_TABLE
155: , a33 out nocopy JTF_DATE_TABLE
156: , a34 out nocopy JTF_NUMBER_TABLE

Line 153: , a31 out nocopy JTF_VARCHAR2_TABLE_100

149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_VARCHAR2_TABLE_200
151: , a29 out nocopy JTF_VARCHAR2_TABLE_200
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: , a32 out nocopy JTF_DATE_TABLE
155: , a33 out nocopy JTF_DATE_TABLE
156: , a34 out nocopy JTF_NUMBER_TABLE
157: , a35 out nocopy JTF_NUMBER_TABLE

Line 160: , a38 out nocopy JTF_VARCHAR2_TABLE_100

156: , a34 out nocopy JTF_NUMBER_TABLE
157: , a35 out nocopy JTF_NUMBER_TABLE
158: , a36 out nocopy JTF_DATE_TABLE
159: , a37 out nocopy JTF_DATE_TABLE
160: , a38 out nocopy JTF_VARCHAR2_TABLE_100
161: , a39 out nocopy JTF_VARCHAR2_TABLE_100
162: ) as
163: ddindx binary_integer; indx binary_integer;
164: begin

Line 161: , a39 out nocopy JTF_VARCHAR2_TABLE_100

157: , a35 out nocopy JTF_NUMBER_TABLE
158: , a36 out nocopy JTF_DATE_TABLE
159: , a37 out nocopy JTF_DATE_TABLE
160: , a38 out nocopy JTF_VARCHAR2_TABLE_100
161: , a39 out nocopy JTF_VARCHAR2_TABLE_100
162: ) as
163: ddindx binary_integer; indx binary_integer;
164: begin
165: if t is null or t.count = 0 then

Line 168: a2 := JTF_VARCHAR2_TABLE_100();

164: begin
165: if t is null or t.count = 0 then
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_400();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();

Line 173: a7 := JTF_VARCHAR2_TABLE_100();

169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_200();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_VARCHAR2_TABLE_100();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_DATE_TABLE();
176: a10 := JTF_DATE_TABLE();
177: a11 := JTF_DATE_TABLE();

Line 180: a14 := JTF_VARCHAR2_TABLE_100();

176: a10 := JTF_DATE_TABLE();
177: a11 := JTF_DATE_TABLE();
178: a12 := JTF_DATE_TABLE();
179: a13 := JTF_NUMBER_TABLE();
180: a14 := JTF_VARCHAR2_TABLE_100();
181: a15 := JTF_VARCHAR2_TABLE_500();
182: a16 := JTF_NUMBER_TABLE();
183: a17 := JTF_NUMBER_TABLE();
184: a18 := JTF_VARCHAR2_TABLE_100();

Line 184: a18 := JTF_VARCHAR2_TABLE_100();

180: a14 := JTF_VARCHAR2_TABLE_100();
181: a15 := JTF_VARCHAR2_TABLE_500();
182: a16 := JTF_NUMBER_TABLE();
183: a17 := JTF_NUMBER_TABLE();
184: a18 := JTF_VARCHAR2_TABLE_100();
185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();

Line 185: a19 := JTF_VARCHAR2_TABLE_100();

181: a15 := JTF_VARCHAR2_TABLE_500();
182: a16 := JTF_NUMBER_TABLE();
183: a17 := JTF_NUMBER_TABLE();
184: a18 := JTF_VARCHAR2_TABLE_100();
185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();

Line 186: a20 := JTF_VARCHAR2_TABLE_100();

182: a16 := JTF_NUMBER_TABLE();
183: a17 := JTF_NUMBER_TABLE();
184: a18 := JTF_VARCHAR2_TABLE_100();
185: a19 := JTF_VARCHAR2_TABLE_100();
186: a20 := JTF_VARCHAR2_TABLE_100();
187: a21 := JTF_NUMBER_TABLE();
188: a22 := JTF_NUMBER_TABLE();
189: a23 := JTF_NUMBER_TABLE();
190: a24 := JTF_NUMBER_TABLE();

Line 196: a30 := JTF_VARCHAR2_TABLE_100();

192: a26 := JTF_NUMBER_TABLE();
193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();
195: a29 := JTF_VARCHAR2_TABLE_200();
196: a30 := JTF_VARCHAR2_TABLE_100();
197: a31 := JTF_VARCHAR2_TABLE_100();
198: a32 := JTF_DATE_TABLE();
199: a33 := JTF_DATE_TABLE();
200: a34 := JTF_NUMBER_TABLE();

Line 197: a31 := JTF_VARCHAR2_TABLE_100();

193: a27 := JTF_NUMBER_TABLE();
194: a28 := JTF_VARCHAR2_TABLE_200();
195: a29 := JTF_VARCHAR2_TABLE_200();
196: a30 := JTF_VARCHAR2_TABLE_100();
197: a31 := JTF_VARCHAR2_TABLE_100();
198: a32 := JTF_DATE_TABLE();
199: a33 := JTF_DATE_TABLE();
200: a34 := JTF_NUMBER_TABLE();
201: a35 := JTF_NUMBER_TABLE();

Line 204: a38 := JTF_VARCHAR2_TABLE_100();

200: a34 := JTF_NUMBER_TABLE();
201: a35 := JTF_NUMBER_TABLE();
202: a36 := JTF_DATE_TABLE();
203: a37 := JTF_DATE_TABLE();
204: a38 := JTF_VARCHAR2_TABLE_100();
205: a39 := JTF_VARCHAR2_TABLE_100();
206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_400();

Line 205: a39 := JTF_VARCHAR2_TABLE_100();

201: a35 := JTF_NUMBER_TABLE();
202: a36 := JTF_DATE_TABLE();
203: a37 := JTF_DATE_TABLE();
204: a38 := JTF_VARCHAR2_TABLE_100();
205: a39 := JTF_VARCHAR2_TABLE_100();
206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_400();
209: a2 := JTF_VARCHAR2_TABLE_100();

Line 209: a2 := JTF_VARCHAR2_TABLE_100();

205: a39 := JTF_VARCHAR2_TABLE_100();
206: else
207: a0 := JTF_NUMBER_TABLE();
208: a1 := JTF_VARCHAR2_TABLE_400();
209: a2 := JTF_VARCHAR2_TABLE_100();
210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_VARCHAR2_TABLE_200();
212: a5 := JTF_NUMBER_TABLE();
213: a6 := JTF_NUMBER_TABLE();

Line 214: a7 := JTF_VARCHAR2_TABLE_100();

210: a3 := JTF_NUMBER_TABLE();
211: a4 := JTF_VARCHAR2_TABLE_200();
212: a5 := JTF_NUMBER_TABLE();
213: a6 := JTF_NUMBER_TABLE();
214: a7 := JTF_VARCHAR2_TABLE_100();
215: a8 := JTF_NUMBER_TABLE();
216: a9 := JTF_DATE_TABLE();
217: a10 := JTF_DATE_TABLE();
218: a11 := JTF_DATE_TABLE();

Line 221: a14 := JTF_VARCHAR2_TABLE_100();

217: a10 := JTF_DATE_TABLE();
218: a11 := JTF_DATE_TABLE();
219: a12 := JTF_DATE_TABLE();
220: a13 := JTF_NUMBER_TABLE();
221: a14 := JTF_VARCHAR2_TABLE_100();
222: a15 := JTF_VARCHAR2_TABLE_500();
223: a16 := JTF_NUMBER_TABLE();
224: a17 := JTF_NUMBER_TABLE();
225: a18 := JTF_VARCHAR2_TABLE_100();

Line 225: a18 := JTF_VARCHAR2_TABLE_100();

221: a14 := JTF_VARCHAR2_TABLE_100();
222: a15 := JTF_VARCHAR2_TABLE_500();
223: a16 := JTF_NUMBER_TABLE();
224: a17 := JTF_NUMBER_TABLE();
225: a18 := JTF_VARCHAR2_TABLE_100();
226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();

Line 226: a19 := JTF_VARCHAR2_TABLE_100();

222: a15 := JTF_VARCHAR2_TABLE_500();
223: a16 := JTF_NUMBER_TABLE();
224: a17 := JTF_NUMBER_TABLE();
225: a18 := JTF_VARCHAR2_TABLE_100();
226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();

Line 227: a20 := JTF_VARCHAR2_TABLE_100();

223: a16 := JTF_NUMBER_TABLE();
224: a17 := JTF_NUMBER_TABLE();
225: a18 := JTF_VARCHAR2_TABLE_100();
226: a19 := JTF_VARCHAR2_TABLE_100();
227: a20 := JTF_VARCHAR2_TABLE_100();
228: a21 := JTF_NUMBER_TABLE();
229: a22 := JTF_NUMBER_TABLE();
230: a23 := JTF_NUMBER_TABLE();
231: a24 := JTF_NUMBER_TABLE();

Line 237: a30 := JTF_VARCHAR2_TABLE_100();

233: a26 := JTF_NUMBER_TABLE();
234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();
236: a29 := JTF_VARCHAR2_TABLE_200();
237: a30 := JTF_VARCHAR2_TABLE_100();
238: a31 := JTF_VARCHAR2_TABLE_100();
239: a32 := JTF_DATE_TABLE();
240: a33 := JTF_DATE_TABLE();
241: a34 := JTF_NUMBER_TABLE();

Line 238: a31 := JTF_VARCHAR2_TABLE_100();

234: a27 := JTF_NUMBER_TABLE();
235: a28 := JTF_VARCHAR2_TABLE_200();
236: a29 := JTF_VARCHAR2_TABLE_200();
237: a30 := JTF_VARCHAR2_TABLE_100();
238: a31 := JTF_VARCHAR2_TABLE_100();
239: a32 := JTF_DATE_TABLE();
240: a33 := JTF_DATE_TABLE();
241: a34 := JTF_NUMBER_TABLE();
242: a35 := JTF_NUMBER_TABLE();

Line 245: a38 := JTF_VARCHAR2_TABLE_100();

241: a34 := JTF_NUMBER_TABLE();
242: a35 := JTF_NUMBER_TABLE();
243: a36 := JTF_DATE_TABLE();
244: a37 := JTF_DATE_TABLE();
245: a38 := JTF_VARCHAR2_TABLE_100();
246: a39 := JTF_VARCHAR2_TABLE_100();
247: if t.count > 0 then
248: a0.extend(t.count);
249: a1.extend(t.count);

Line 246: a39 := JTF_VARCHAR2_TABLE_100();

242: a35 := JTF_NUMBER_TABLE();
243: a36 := JTF_DATE_TABLE();
244: a37 := JTF_DATE_TABLE();
245: a38 := JTF_VARCHAR2_TABLE_100();
246: a39 := JTF_VARCHAR2_TABLE_100();
247: if t.count > 0 then
248: a0.extend(t.count);
249: a1.extend(t.count);
250: a2.extend(t.count);

Line 347: , a6 JTF_VARCHAR2_TABLE_100

343: , a2 JTF_VARCHAR2_TABLE_200
344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_NUMBER_TABLE
347: , a6 JTF_VARCHAR2_TABLE_100
348: , a7 JTF_VARCHAR2_TABLE_100
349: , a8 JTF_VARCHAR2_TABLE_100
350: ) as
351: ddindx binary_integer; indx binary_integer;

Line 348: , a7 JTF_VARCHAR2_TABLE_100

344: , a3 JTF_VARCHAR2_TABLE_400
345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_NUMBER_TABLE
347: , a6 JTF_VARCHAR2_TABLE_100
348: , a7 JTF_VARCHAR2_TABLE_100
349: , a8 JTF_VARCHAR2_TABLE_100
350: ) as
351: ddindx binary_integer; indx binary_integer;
352: begin

Line 349: , a8 JTF_VARCHAR2_TABLE_100

345: , a4 JTF_VARCHAR2_TABLE_200
346: , a5 JTF_NUMBER_TABLE
347: , a6 JTF_VARCHAR2_TABLE_100
348: , a7 JTF_VARCHAR2_TABLE_100
349: , a8 JTF_VARCHAR2_TABLE_100
350: ) as
351: ddindx binary_integer; indx binary_integer;
352: begin
353: if a0 is not null and a0.count > 0 then

Line 382: , a6 out nocopy JTF_VARCHAR2_TABLE_100

378: , a2 out nocopy JTF_VARCHAR2_TABLE_200
379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200
381: , a5 out nocopy JTF_NUMBER_TABLE
382: , a6 out nocopy JTF_VARCHAR2_TABLE_100
383: , a7 out nocopy JTF_VARCHAR2_TABLE_100
384: , a8 out nocopy JTF_VARCHAR2_TABLE_100
385: ) as
386: ddindx binary_integer; indx binary_integer;

Line 383: , a7 out nocopy JTF_VARCHAR2_TABLE_100

379: , a3 out nocopy JTF_VARCHAR2_TABLE_400
380: , a4 out nocopy JTF_VARCHAR2_TABLE_200
381: , a5 out nocopy JTF_NUMBER_TABLE
382: , a6 out nocopy JTF_VARCHAR2_TABLE_100
383: , a7 out nocopy JTF_VARCHAR2_TABLE_100
384: , a8 out nocopy JTF_VARCHAR2_TABLE_100
385: ) as
386: ddindx binary_integer; indx binary_integer;
387: begin

Line 384: , a8 out nocopy JTF_VARCHAR2_TABLE_100

380: , a4 out nocopy JTF_VARCHAR2_TABLE_200
381: , a5 out nocopy JTF_NUMBER_TABLE
382: , a6 out nocopy JTF_VARCHAR2_TABLE_100
383: , a7 out nocopy JTF_VARCHAR2_TABLE_100
384: , a8 out nocopy JTF_VARCHAR2_TABLE_100
385: ) as
386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then

Line 395: a6 := JTF_VARCHAR2_TABLE_100();

391: a2 := JTF_VARCHAR2_TABLE_200();
392: a3 := JTF_VARCHAR2_TABLE_400();
393: a4 := JTF_VARCHAR2_TABLE_200();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_VARCHAR2_TABLE_100();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: else
399: a0 := JTF_NUMBER_TABLE();

Line 396: a7 := JTF_VARCHAR2_TABLE_100();

392: a3 := JTF_VARCHAR2_TABLE_400();
393: a4 := JTF_VARCHAR2_TABLE_200();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_VARCHAR2_TABLE_100();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();

Line 397: a8 := JTF_VARCHAR2_TABLE_100();

393: a4 := JTF_VARCHAR2_TABLE_200();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_VARCHAR2_TABLE_100();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_VARCHAR2_TABLE_200();

Line 405: a6 := JTF_VARCHAR2_TABLE_100();

401: a2 := JTF_VARCHAR2_TABLE_200();
402: a3 := JTF_VARCHAR2_TABLE_400();
403: a4 := JTF_VARCHAR2_TABLE_200();
404: a5 := JTF_NUMBER_TABLE();
405: a6 := JTF_VARCHAR2_TABLE_100();
406: a7 := JTF_VARCHAR2_TABLE_100();
407: a8 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then
409: a0.extend(t.count);

Line 406: a7 := JTF_VARCHAR2_TABLE_100();

402: a3 := JTF_VARCHAR2_TABLE_400();
403: a4 := JTF_VARCHAR2_TABLE_200();
404: a5 := JTF_NUMBER_TABLE();
405: a6 := JTF_VARCHAR2_TABLE_100();
406: a7 := JTF_VARCHAR2_TABLE_100();
407: a8 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then
409: a0.extend(t.count);
410: a1.extend(t.count);

Line 407: a8 := JTF_VARCHAR2_TABLE_100();

403: a4 := JTF_VARCHAR2_TABLE_200();
404: a5 := JTF_NUMBER_TABLE();
405: a6 := JTF_VARCHAR2_TABLE_100();
406: a7 := JTF_VARCHAR2_TABLE_100();
407: a8 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then
409: a0.extend(t.count);
410: a1.extend(t.count);
411: a2.extend(t.count);

Line 1211: , p5_a14 JTF_VARCHAR2_TABLE_100

1207: , p5_a10 JTF_DATE_TABLE
1208: , p5_a11 JTF_NUMBER_TABLE
1209: , p5_a12 JTF_NUMBER_TABLE
1210: , p5_a13 JTF_DATE_TABLE
1211: , p5_a14 JTF_VARCHAR2_TABLE_100
1212: , p5_a15 JTF_VARCHAR2_TABLE_100
1213: , p5_a16 JTF_VARCHAR2_TABLE_500
1214: , p5_a17 JTF_VARCHAR2_TABLE_500
1215: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 1212: , p5_a15 JTF_VARCHAR2_TABLE_100

1208: , p5_a11 JTF_NUMBER_TABLE
1209: , p5_a12 JTF_NUMBER_TABLE
1210: , p5_a13 JTF_DATE_TABLE
1211: , p5_a14 JTF_VARCHAR2_TABLE_100
1212: , p5_a15 JTF_VARCHAR2_TABLE_100
1213: , p5_a16 JTF_VARCHAR2_TABLE_500
1214: , p5_a17 JTF_VARCHAR2_TABLE_500
1215: , p5_a18 JTF_VARCHAR2_TABLE_500
1216: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1251: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

1247: , p6_a10 out nocopy JTF_DATE_TABLE
1248: , p6_a11 out nocopy JTF_NUMBER_TABLE
1249: , p6_a12 out nocopy JTF_NUMBER_TABLE
1250: , p6_a13 out nocopy JTF_DATE_TABLE
1251: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1253: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1254: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1255: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 1252: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

1248: , p6_a11 out nocopy JTF_NUMBER_TABLE
1249: , p6_a12 out nocopy JTF_NUMBER_TABLE
1250: , p6_a13 out nocopy JTF_DATE_TABLE
1251: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1253: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1254: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1255: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 1611: , p5_a14 JTF_VARCHAR2_TABLE_100

1607: , p5_a10 JTF_DATE_TABLE
1608: , p5_a11 JTF_NUMBER_TABLE
1609: , p5_a12 JTF_NUMBER_TABLE
1610: , p5_a13 JTF_DATE_TABLE
1611: , p5_a14 JTF_VARCHAR2_TABLE_100
1612: , p5_a15 JTF_VARCHAR2_TABLE_100
1613: , p5_a16 JTF_VARCHAR2_TABLE_500
1614: , p5_a17 JTF_VARCHAR2_TABLE_500
1615: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 1612: , p5_a15 JTF_VARCHAR2_TABLE_100

1608: , p5_a11 JTF_NUMBER_TABLE
1609: , p5_a12 JTF_NUMBER_TABLE
1610: , p5_a13 JTF_DATE_TABLE
1611: , p5_a14 JTF_VARCHAR2_TABLE_100
1612: , p5_a15 JTF_VARCHAR2_TABLE_100
1613: , p5_a16 JTF_VARCHAR2_TABLE_500
1614: , p5_a17 JTF_VARCHAR2_TABLE_500
1615: , p5_a18 JTF_VARCHAR2_TABLE_500
1616: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 1651: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

1647: , p6_a10 out nocopy JTF_DATE_TABLE
1648: , p6_a11 out nocopy JTF_NUMBER_TABLE
1649: , p6_a12 out nocopy JTF_NUMBER_TABLE
1650: , p6_a13 out nocopy JTF_DATE_TABLE
1651: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1652: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1653: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1654: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1655: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 1652: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

1648: , p6_a11 out nocopy JTF_NUMBER_TABLE
1649: , p6_a12 out nocopy JTF_NUMBER_TABLE
1650: , p6_a13 out nocopy JTF_DATE_TABLE
1651: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1652: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1653: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1654: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1655: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1656: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 1927: , p5_a14 JTF_VARCHAR2_TABLE_100

1923: , p5_a10 JTF_DATE_TABLE
1924: , p5_a11 JTF_NUMBER_TABLE
1925: , p5_a12 JTF_NUMBER_TABLE
1926: , p5_a13 JTF_DATE_TABLE
1927: , p5_a14 JTF_VARCHAR2_TABLE_100
1928: , p5_a15 JTF_VARCHAR2_TABLE_100
1929: , p5_a16 JTF_VARCHAR2_TABLE_500
1930: , p5_a17 JTF_VARCHAR2_TABLE_500
1931: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 1928: , p5_a15 JTF_VARCHAR2_TABLE_100

1924: , p5_a11 JTF_NUMBER_TABLE
1925: , p5_a12 JTF_NUMBER_TABLE
1926: , p5_a13 JTF_DATE_TABLE
1927: , p5_a14 JTF_VARCHAR2_TABLE_100
1928: , p5_a15 JTF_VARCHAR2_TABLE_100
1929: , p5_a16 JTF_VARCHAR2_TABLE_500
1930: , p5_a17 JTF_VARCHAR2_TABLE_500
1931: , p5_a18 JTF_VARCHAR2_TABLE_500
1932: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 2743: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100

2739: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
2740: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p33_a5 out nocopy JTF_NUMBER_TABLE
2743: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100
2746: )
2747:

Line 2744: , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100

2740: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p33_a5 out nocopy JTF_NUMBER_TABLE
2743: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100
2746: )
2747:
2748: as

Line 2745: , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100

2741: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
2742: , p33_a5 out nocopy JTF_NUMBER_TABLE
2743: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100
2744: , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100
2745: , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100
2746: )
2747:
2748: as
2749: ddp_start_from_date date;