APPS.OKL_AM_PARTIES_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 39: , a17 JTF_VARCHAR2_TABLE_200

35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_200
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_400
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_100

Line 42: , a20 JTF_VARCHAR2_TABLE_2000

38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_200
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_400
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_200
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_400

Line 44: , a22 JTF_VARCHAR2_TABLE_200

40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_400
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_200
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_400
47: , a25 JTF_VARCHAR2_TABLE_2000
48: , a26 JTF_VARCHAR2_TABLE_2000

Line 47: , a25 JTF_VARCHAR2_TABLE_2000

43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_200
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_400
47: , a25 JTF_VARCHAR2_TABLE_2000
48: , a26 JTF_VARCHAR2_TABLE_2000
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE

Line 48: , a26 JTF_VARCHAR2_TABLE_2000

44: , a22 JTF_VARCHAR2_TABLE_200
45: , a23 JTF_VARCHAR2_TABLE_100
46: , a24 JTF_VARCHAR2_TABLE_400
47: , a25 JTF_VARCHAR2_TABLE_2000
48: , a26 JTF_VARCHAR2_TABLE_2000
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_VARCHAR2_TABLE_100

Line 54: , a32 JTF_VARCHAR2_TABLE_2000

50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_2000
55: , a33 JTF_VARCHAR2_TABLE_2000
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_DATE_TABLE
58: ) as

Line 55: , a33 JTF_VARCHAR2_TABLE_2000

51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_2000
55: , a33 JTF_VARCHAR2_TABLE_2000
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_DATE_TABLE
58: ) as
59: ddindx binary_integer; indx binary_integer;

Line 128: , a17 out nocopy JTF_VARCHAR2_TABLE_200

124: , a13 out nocopy JTF_NUMBER_TABLE
125: , a14 out nocopy JTF_VARCHAR2_TABLE_100
126: , a15 out nocopy JTF_VARCHAR2_TABLE_100
127: , a16 out nocopy JTF_VARCHAR2_TABLE_100
128: , a17 out nocopy JTF_VARCHAR2_TABLE_200
129: , a18 out nocopy JTF_VARCHAR2_TABLE_100
130: , a19 out nocopy JTF_VARCHAR2_TABLE_400
131: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
132: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a20 out nocopy JTF_VARCHAR2_TABLE_2000

127: , a16 out nocopy JTF_VARCHAR2_TABLE_100
128: , a17 out nocopy JTF_VARCHAR2_TABLE_200
129: , a18 out nocopy JTF_VARCHAR2_TABLE_100
130: , a19 out nocopy JTF_VARCHAR2_TABLE_400
131: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
132: , a21 out nocopy JTF_VARCHAR2_TABLE_100
133: , a22 out nocopy JTF_VARCHAR2_TABLE_200
134: , a23 out nocopy JTF_VARCHAR2_TABLE_100
135: , a24 out nocopy JTF_VARCHAR2_TABLE_400

Line 133: , a22 out nocopy JTF_VARCHAR2_TABLE_200

129: , a18 out nocopy JTF_VARCHAR2_TABLE_100
130: , a19 out nocopy JTF_VARCHAR2_TABLE_400
131: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
132: , a21 out nocopy JTF_VARCHAR2_TABLE_100
133: , a22 out nocopy JTF_VARCHAR2_TABLE_200
134: , a23 out nocopy JTF_VARCHAR2_TABLE_100
135: , a24 out nocopy JTF_VARCHAR2_TABLE_400
136: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
137: , a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 136: , a25 out nocopy JTF_VARCHAR2_TABLE_2000

132: , a21 out nocopy JTF_VARCHAR2_TABLE_100
133: , a22 out nocopy JTF_VARCHAR2_TABLE_200
134: , a23 out nocopy JTF_VARCHAR2_TABLE_100
135: , a24 out nocopy JTF_VARCHAR2_TABLE_400
136: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
137: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
138: , a27 out nocopy JTF_NUMBER_TABLE
139: , a28 out nocopy JTF_DATE_TABLE
140: , a29 out nocopy JTF_NUMBER_TABLE

Line 137: , a26 out nocopy JTF_VARCHAR2_TABLE_2000

133: , a22 out nocopy JTF_VARCHAR2_TABLE_200
134: , a23 out nocopy JTF_VARCHAR2_TABLE_100
135: , a24 out nocopy JTF_VARCHAR2_TABLE_400
136: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
137: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
138: , a27 out nocopy JTF_NUMBER_TABLE
139: , a28 out nocopy JTF_DATE_TABLE
140: , a29 out nocopy JTF_NUMBER_TABLE
141: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 143: , a32 out nocopy JTF_VARCHAR2_TABLE_2000

139: , a28 out nocopy JTF_DATE_TABLE
140: , a29 out nocopy JTF_NUMBER_TABLE
141: , a30 out nocopy JTF_VARCHAR2_TABLE_100
142: , a31 out nocopy JTF_VARCHAR2_TABLE_100
143: , a32 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a34 out nocopy JTF_NUMBER_TABLE
146: , a35 out nocopy JTF_DATE_TABLE
147: ) as

Line 144: , a33 out nocopy JTF_VARCHAR2_TABLE_2000

140: , a29 out nocopy JTF_NUMBER_TABLE
141: , a30 out nocopy JTF_VARCHAR2_TABLE_100
142: , a31 out nocopy JTF_VARCHAR2_TABLE_100
143: , a32 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a34 out nocopy JTF_NUMBER_TABLE
146: , a35 out nocopy JTF_DATE_TABLE
147: ) as
148: ddindx binary_integer; indx binary_integer;

Line 168: a17 := JTF_VARCHAR2_TABLE_200();

164: a13 := JTF_NUMBER_TABLE();
165: a14 := JTF_VARCHAR2_TABLE_100();
166: a15 := JTF_VARCHAR2_TABLE_100();
167: a16 := JTF_VARCHAR2_TABLE_100();
168: a17 := JTF_VARCHAR2_TABLE_200();
169: a18 := JTF_VARCHAR2_TABLE_100();
170: a19 := JTF_VARCHAR2_TABLE_400();
171: a20 := JTF_VARCHAR2_TABLE_2000();
172: a21 := JTF_VARCHAR2_TABLE_100();

Line 171: a20 := JTF_VARCHAR2_TABLE_2000();

167: a16 := JTF_VARCHAR2_TABLE_100();
168: a17 := JTF_VARCHAR2_TABLE_200();
169: a18 := JTF_VARCHAR2_TABLE_100();
170: a19 := JTF_VARCHAR2_TABLE_400();
171: a20 := JTF_VARCHAR2_TABLE_2000();
172: a21 := JTF_VARCHAR2_TABLE_100();
173: a22 := JTF_VARCHAR2_TABLE_200();
174: a23 := JTF_VARCHAR2_TABLE_100();
175: a24 := JTF_VARCHAR2_TABLE_400();

Line 173: a22 := JTF_VARCHAR2_TABLE_200();

169: a18 := JTF_VARCHAR2_TABLE_100();
170: a19 := JTF_VARCHAR2_TABLE_400();
171: a20 := JTF_VARCHAR2_TABLE_2000();
172: a21 := JTF_VARCHAR2_TABLE_100();
173: a22 := JTF_VARCHAR2_TABLE_200();
174: a23 := JTF_VARCHAR2_TABLE_100();
175: a24 := JTF_VARCHAR2_TABLE_400();
176: a25 := JTF_VARCHAR2_TABLE_2000();
177: a26 := JTF_VARCHAR2_TABLE_2000();

Line 176: a25 := JTF_VARCHAR2_TABLE_2000();

172: a21 := JTF_VARCHAR2_TABLE_100();
173: a22 := JTF_VARCHAR2_TABLE_200();
174: a23 := JTF_VARCHAR2_TABLE_100();
175: a24 := JTF_VARCHAR2_TABLE_400();
176: a25 := JTF_VARCHAR2_TABLE_2000();
177: a26 := JTF_VARCHAR2_TABLE_2000();
178: a27 := JTF_NUMBER_TABLE();
179: a28 := JTF_DATE_TABLE();
180: a29 := JTF_NUMBER_TABLE();

Line 177: a26 := JTF_VARCHAR2_TABLE_2000();

173: a22 := JTF_VARCHAR2_TABLE_200();
174: a23 := JTF_VARCHAR2_TABLE_100();
175: a24 := JTF_VARCHAR2_TABLE_400();
176: a25 := JTF_VARCHAR2_TABLE_2000();
177: a26 := JTF_VARCHAR2_TABLE_2000();
178: a27 := JTF_NUMBER_TABLE();
179: a28 := JTF_DATE_TABLE();
180: a29 := JTF_NUMBER_TABLE();
181: a30 := JTF_VARCHAR2_TABLE_100();

Line 183: a32 := JTF_VARCHAR2_TABLE_2000();

179: a28 := JTF_DATE_TABLE();
180: a29 := JTF_NUMBER_TABLE();
181: a30 := JTF_VARCHAR2_TABLE_100();
182: a31 := JTF_VARCHAR2_TABLE_100();
183: a32 := JTF_VARCHAR2_TABLE_2000();
184: a33 := JTF_VARCHAR2_TABLE_2000();
185: a34 := JTF_NUMBER_TABLE();
186: a35 := JTF_DATE_TABLE();
187: else

Line 184: a33 := JTF_VARCHAR2_TABLE_2000();

180: a29 := JTF_NUMBER_TABLE();
181: a30 := JTF_VARCHAR2_TABLE_100();
182: a31 := JTF_VARCHAR2_TABLE_100();
183: a32 := JTF_VARCHAR2_TABLE_2000();
184: a33 := JTF_VARCHAR2_TABLE_2000();
185: a34 := JTF_NUMBER_TABLE();
186: a35 := JTF_DATE_TABLE();
187: else
188: a0 := JTF_NUMBER_TABLE();

Line 205: a17 := JTF_VARCHAR2_TABLE_200();

201: a13 := JTF_NUMBER_TABLE();
202: a14 := JTF_VARCHAR2_TABLE_100();
203: a15 := JTF_VARCHAR2_TABLE_100();
204: a16 := JTF_VARCHAR2_TABLE_100();
205: a17 := JTF_VARCHAR2_TABLE_200();
206: a18 := JTF_VARCHAR2_TABLE_100();
207: a19 := JTF_VARCHAR2_TABLE_400();
208: a20 := JTF_VARCHAR2_TABLE_2000();
209: a21 := JTF_VARCHAR2_TABLE_100();

Line 208: a20 := JTF_VARCHAR2_TABLE_2000();

204: a16 := JTF_VARCHAR2_TABLE_100();
205: a17 := JTF_VARCHAR2_TABLE_200();
206: a18 := JTF_VARCHAR2_TABLE_100();
207: a19 := JTF_VARCHAR2_TABLE_400();
208: a20 := JTF_VARCHAR2_TABLE_2000();
209: a21 := JTF_VARCHAR2_TABLE_100();
210: a22 := JTF_VARCHAR2_TABLE_200();
211: a23 := JTF_VARCHAR2_TABLE_100();
212: a24 := JTF_VARCHAR2_TABLE_400();

Line 210: a22 := JTF_VARCHAR2_TABLE_200();

206: a18 := JTF_VARCHAR2_TABLE_100();
207: a19 := JTF_VARCHAR2_TABLE_400();
208: a20 := JTF_VARCHAR2_TABLE_2000();
209: a21 := JTF_VARCHAR2_TABLE_100();
210: a22 := JTF_VARCHAR2_TABLE_200();
211: a23 := JTF_VARCHAR2_TABLE_100();
212: a24 := JTF_VARCHAR2_TABLE_400();
213: a25 := JTF_VARCHAR2_TABLE_2000();
214: a26 := JTF_VARCHAR2_TABLE_2000();

Line 213: a25 := JTF_VARCHAR2_TABLE_2000();

209: a21 := JTF_VARCHAR2_TABLE_100();
210: a22 := JTF_VARCHAR2_TABLE_200();
211: a23 := JTF_VARCHAR2_TABLE_100();
212: a24 := JTF_VARCHAR2_TABLE_400();
213: a25 := JTF_VARCHAR2_TABLE_2000();
214: a26 := JTF_VARCHAR2_TABLE_2000();
215: a27 := JTF_NUMBER_TABLE();
216: a28 := JTF_DATE_TABLE();
217: a29 := JTF_NUMBER_TABLE();

Line 214: a26 := JTF_VARCHAR2_TABLE_2000();

210: a22 := JTF_VARCHAR2_TABLE_200();
211: a23 := JTF_VARCHAR2_TABLE_100();
212: a24 := JTF_VARCHAR2_TABLE_400();
213: a25 := JTF_VARCHAR2_TABLE_2000();
214: a26 := JTF_VARCHAR2_TABLE_2000();
215: a27 := JTF_NUMBER_TABLE();
216: a28 := JTF_DATE_TABLE();
217: a29 := JTF_NUMBER_TABLE();
218: a30 := JTF_VARCHAR2_TABLE_100();

Line 220: a32 := JTF_VARCHAR2_TABLE_2000();

216: a28 := JTF_DATE_TABLE();
217: a29 := JTF_NUMBER_TABLE();
218: a30 := JTF_VARCHAR2_TABLE_100();
219: a31 := JTF_VARCHAR2_TABLE_100();
220: a32 := JTF_VARCHAR2_TABLE_2000();
221: a33 := JTF_VARCHAR2_TABLE_2000();
222: a34 := JTF_NUMBER_TABLE();
223: a35 := JTF_DATE_TABLE();
224: if t.count > 0 then

Line 221: a33 := JTF_VARCHAR2_TABLE_2000();

217: a29 := JTF_NUMBER_TABLE();
218: a30 := JTF_VARCHAR2_TABLE_100();
219: a31 := JTF_VARCHAR2_TABLE_100();
220: a32 := JTF_VARCHAR2_TABLE_2000();
221: a33 := JTF_VARCHAR2_TABLE_2000();
222: a34 := JTF_NUMBER_TABLE();
223: a35 := JTF_DATE_TABLE();
224: if t.count > 0 then
225: a0.extend(t.count);

Line 312: , a2 JTF_VARCHAR2_TABLE_200

308: end rosetta_table_copy_out_p2;
309:
310: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_parties_pvt.party_object_tbl_type, a0 JTF_VARCHAR2_TABLE_100
311: , a1 JTF_VARCHAR2_TABLE_100
312: , a2 JTF_VARCHAR2_TABLE_200
313: , a3 JTF_VARCHAR2_TABLE_400
314: , a4 JTF_VARCHAR2_TABLE_2000
315: , a5 JTF_VARCHAR2_TABLE_100
316: , a6 JTF_VARCHAR2_TABLE_100

Line 314: , a4 JTF_VARCHAR2_TABLE_2000

310: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_parties_pvt.party_object_tbl_type, a0 JTF_VARCHAR2_TABLE_100
311: , a1 JTF_VARCHAR2_TABLE_100
312: , a2 JTF_VARCHAR2_TABLE_200
313: , a3 JTF_VARCHAR2_TABLE_400
314: , a4 JTF_VARCHAR2_TABLE_2000
315: , a5 JTF_VARCHAR2_TABLE_100
316: , a6 JTF_VARCHAR2_TABLE_100
317: , a7 JTF_VARCHAR2_TABLE_200
318: , a8 JTF_VARCHAR2_TABLE_400

Line 317: , a7 JTF_VARCHAR2_TABLE_200

313: , a3 JTF_VARCHAR2_TABLE_400
314: , a4 JTF_VARCHAR2_TABLE_2000
315: , a5 JTF_VARCHAR2_TABLE_100
316: , a6 JTF_VARCHAR2_TABLE_100
317: , a7 JTF_VARCHAR2_TABLE_200
318: , a8 JTF_VARCHAR2_TABLE_400
319: , a9 JTF_VARCHAR2_TABLE_2000
320: , a10 JTF_VARCHAR2_TABLE_100
321: , a11 JTF_VARCHAR2_TABLE_100

Line 319: , a9 JTF_VARCHAR2_TABLE_2000

315: , a5 JTF_VARCHAR2_TABLE_100
316: , a6 JTF_VARCHAR2_TABLE_100
317: , a7 JTF_VARCHAR2_TABLE_200
318: , a8 JTF_VARCHAR2_TABLE_400
319: , a9 JTF_VARCHAR2_TABLE_2000
320: , a10 JTF_VARCHAR2_TABLE_100
321: , a11 JTF_VARCHAR2_TABLE_100
322: , a12 JTF_VARCHAR2_TABLE_200
323: , a13 JTF_VARCHAR2_TABLE_400

Line 322: , a12 JTF_VARCHAR2_TABLE_200

318: , a8 JTF_VARCHAR2_TABLE_400
319: , a9 JTF_VARCHAR2_TABLE_2000
320: , a10 JTF_VARCHAR2_TABLE_100
321: , a11 JTF_VARCHAR2_TABLE_100
322: , a12 JTF_VARCHAR2_TABLE_200
323: , a13 JTF_VARCHAR2_TABLE_400
324: , a14 JTF_VARCHAR2_TABLE_2000
325: , a15 JTF_VARCHAR2_TABLE_2000
326: , a16 JTF_NUMBER_TABLE

Line 324: , a14 JTF_VARCHAR2_TABLE_2000

320: , a10 JTF_VARCHAR2_TABLE_100
321: , a11 JTF_VARCHAR2_TABLE_100
322: , a12 JTF_VARCHAR2_TABLE_200
323: , a13 JTF_VARCHAR2_TABLE_400
324: , a14 JTF_VARCHAR2_TABLE_2000
325: , a15 JTF_VARCHAR2_TABLE_2000
326: , a16 JTF_NUMBER_TABLE
327: , a17 JTF_NUMBER_TABLE
328: , a18 JTF_VARCHAR2_TABLE_100

Line 325: , a15 JTF_VARCHAR2_TABLE_2000

321: , a11 JTF_VARCHAR2_TABLE_100
322: , a12 JTF_VARCHAR2_TABLE_200
323: , a13 JTF_VARCHAR2_TABLE_400
324: , a14 JTF_VARCHAR2_TABLE_2000
325: , a15 JTF_VARCHAR2_TABLE_2000
326: , a16 JTF_NUMBER_TABLE
327: , a17 JTF_NUMBER_TABLE
328: , a18 JTF_VARCHAR2_TABLE_100
329: , a19 JTF_VARCHAR2_TABLE_2000

Line 329: , a19 JTF_VARCHAR2_TABLE_2000

325: , a15 JTF_VARCHAR2_TABLE_2000
326: , a16 JTF_NUMBER_TABLE
327: , a17 JTF_NUMBER_TABLE
328: , a18 JTF_VARCHAR2_TABLE_100
329: , a19 JTF_VARCHAR2_TABLE_2000
330: ) as
331: ddindx binary_integer; indx binary_integer;
332: begin
333: if a0 is not null and a0.count > 0 then

Line 369: , a2 out nocopy JTF_VARCHAR2_TABLE_200

365: end if;
366: end rosetta_table_copy_in_p3;
367: procedure rosetta_table_copy_out_p3(t okl_am_parties_pvt.party_object_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
368: , a1 out nocopy JTF_VARCHAR2_TABLE_100
369: , a2 out nocopy JTF_VARCHAR2_TABLE_200
370: , a3 out nocopy JTF_VARCHAR2_TABLE_400
371: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
372: , a5 out nocopy JTF_VARCHAR2_TABLE_100
373: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 371: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

367: procedure rosetta_table_copy_out_p3(t okl_am_parties_pvt.party_object_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
368: , a1 out nocopy JTF_VARCHAR2_TABLE_100
369: , a2 out nocopy JTF_VARCHAR2_TABLE_200
370: , a3 out nocopy JTF_VARCHAR2_TABLE_400
371: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
372: , a5 out nocopy JTF_VARCHAR2_TABLE_100
373: , a6 out nocopy JTF_VARCHAR2_TABLE_100
374: , a7 out nocopy JTF_VARCHAR2_TABLE_200
375: , a8 out nocopy JTF_VARCHAR2_TABLE_400

Line 374: , a7 out nocopy JTF_VARCHAR2_TABLE_200

370: , a3 out nocopy JTF_VARCHAR2_TABLE_400
371: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
372: , a5 out nocopy JTF_VARCHAR2_TABLE_100
373: , a6 out nocopy JTF_VARCHAR2_TABLE_100
374: , a7 out nocopy JTF_VARCHAR2_TABLE_200
375: , a8 out nocopy JTF_VARCHAR2_TABLE_400
376: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
377: , a10 out nocopy JTF_VARCHAR2_TABLE_100
378: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 376: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

372: , a5 out nocopy JTF_VARCHAR2_TABLE_100
373: , a6 out nocopy JTF_VARCHAR2_TABLE_100
374: , a7 out nocopy JTF_VARCHAR2_TABLE_200
375: , a8 out nocopy JTF_VARCHAR2_TABLE_400
376: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
377: , a10 out nocopy JTF_VARCHAR2_TABLE_100
378: , a11 out nocopy JTF_VARCHAR2_TABLE_100
379: , a12 out nocopy JTF_VARCHAR2_TABLE_200
380: , a13 out nocopy JTF_VARCHAR2_TABLE_400

Line 379: , a12 out nocopy JTF_VARCHAR2_TABLE_200

375: , a8 out nocopy JTF_VARCHAR2_TABLE_400
376: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
377: , a10 out nocopy JTF_VARCHAR2_TABLE_100
378: , a11 out nocopy JTF_VARCHAR2_TABLE_100
379: , a12 out nocopy JTF_VARCHAR2_TABLE_200
380: , a13 out nocopy JTF_VARCHAR2_TABLE_400
381: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
382: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
383: , a16 out nocopy JTF_NUMBER_TABLE

Line 381: , a14 out nocopy JTF_VARCHAR2_TABLE_2000

377: , a10 out nocopy JTF_VARCHAR2_TABLE_100
378: , a11 out nocopy JTF_VARCHAR2_TABLE_100
379: , a12 out nocopy JTF_VARCHAR2_TABLE_200
380: , a13 out nocopy JTF_VARCHAR2_TABLE_400
381: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
382: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
383: , a16 out nocopy JTF_NUMBER_TABLE
384: , a17 out nocopy JTF_NUMBER_TABLE
385: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 382: , a15 out nocopy JTF_VARCHAR2_TABLE_2000

378: , a11 out nocopy JTF_VARCHAR2_TABLE_100
379: , a12 out nocopy JTF_VARCHAR2_TABLE_200
380: , a13 out nocopy JTF_VARCHAR2_TABLE_400
381: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
382: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
383: , a16 out nocopy JTF_NUMBER_TABLE
384: , a17 out nocopy JTF_NUMBER_TABLE
385: , a18 out nocopy JTF_VARCHAR2_TABLE_100
386: , a19 out nocopy JTF_VARCHAR2_TABLE_2000

Line 386: , a19 out nocopy JTF_VARCHAR2_TABLE_2000

382: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
383: , a16 out nocopy JTF_NUMBER_TABLE
384: , a17 out nocopy JTF_NUMBER_TABLE
385: , a18 out nocopy JTF_VARCHAR2_TABLE_100
386: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
387: ) as
388: ddindx binary_integer; indx binary_integer;
389: begin
390: if t is null or t.count = 0 then

Line 393: a2 := JTF_VARCHAR2_TABLE_200();

389: begin
390: if t is null or t.count = 0 then
391: a0 := JTF_VARCHAR2_TABLE_100();
392: a1 := JTF_VARCHAR2_TABLE_100();
393: a2 := JTF_VARCHAR2_TABLE_200();
394: a3 := JTF_VARCHAR2_TABLE_400();
395: a4 := JTF_VARCHAR2_TABLE_2000();
396: a5 := JTF_VARCHAR2_TABLE_100();
397: a6 := JTF_VARCHAR2_TABLE_100();

Line 395: a4 := JTF_VARCHAR2_TABLE_2000();

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

Line 398: a7 := JTF_VARCHAR2_TABLE_200();

394: a3 := JTF_VARCHAR2_TABLE_400();
395: a4 := JTF_VARCHAR2_TABLE_2000();
396: a5 := JTF_VARCHAR2_TABLE_100();
397: a6 := JTF_VARCHAR2_TABLE_100();
398: a7 := JTF_VARCHAR2_TABLE_200();
399: a8 := JTF_VARCHAR2_TABLE_400();
400: a9 := JTF_VARCHAR2_TABLE_2000();
401: a10 := JTF_VARCHAR2_TABLE_100();
402: a11 := JTF_VARCHAR2_TABLE_100();

Line 400: a9 := JTF_VARCHAR2_TABLE_2000();

396: a5 := JTF_VARCHAR2_TABLE_100();
397: a6 := JTF_VARCHAR2_TABLE_100();
398: a7 := JTF_VARCHAR2_TABLE_200();
399: a8 := JTF_VARCHAR2_TABLE_400();
400: a9 := JTF_VARCHAR2_TABLE_2000();
401: a10 := JTF_VARCHAR2_TABLE_100();
402: a11 := JTF_VARCHAR2_TABLE_100();
403: a12 := JTF_VARCHAR2_TABLE_200();
404: a13 := JTF_VARCHAR2_TABLE_400();

Line 403: a12 := JTF_VARCHAR2_TABLE_200();

399: a8 := JTF_VARCHAR2_TABLE_400();
400: a9 := JTF_VARCHAR2_TABLE_2000();
401: a10 := JTF_VARCHAR2_TABLE_100();
402: a11 := JTF_VARCHAR2_TABLE_100();
403: a12 := JTF_VARCHAR2_TABLE_200();
404: a13 := JTF_VARCHAR2_TABLE_400();
405: a14 := JTF_VARCHAR2_TABLE_2000();
406: a15 := JTF_VARCHAR2_TABLE_2000();
407: a16 := JTF_NUMBER_TABLE();

Line 405: a14 := JTF_VARCHAR2_TABLE_2000();

401: a10 := JTF_VARCHAR2_TABLE_100();
402: a11 := JTF_VARCHAR2_TABLE_100();
403: a12 := JTF_VARCHAR2_TABLE_200();
404: a13 := JTF_VARCHAR2_TABLE_400();
405: a14 := JTF_VARCHAR2_TABLE_2000();
406: a15 := JTF_VARCHAR2_TABLE_2000();
407: a16 := JTF_NUMBER_TABLE();
408: a17 := JTF_NUMBER_TABLE();
409: a18 := JTF_VARCHAR2_TABLE_100();

Line 406: a15 := JTF_VARCHAR2_TABLE_2000();

402: a11 := JTF_VARCHAR2_TABLE_100();
403: a12 := JTF_VARCHAR2_TABLE_200();
404: a13 := JTF_VARCHAR2_TABLE_400();
405: a14 := JTF_VARCHAR2_TABLE_2000();
406: a15 := JTF_VARCHAR2_TABLE_2000();
407: a16 := JTF_NUMBER_TABLE();
408: a17 := JTF_NUMBER_TABLE();
409: a18 := JTF_VARCHAR2_TABLE_100();
410: a19 := JTF_VARCHAR2_TABLE_2000();

Line 410: a19 := JTF_VARCHAR2_TABLE_2000();

406: a15 := JTF_VARCHAR2_TABLE_2000();
407: a16 := JTF_NUMBER_TABLE();
408: a17 := JTF_NUMBER_TABLE();
409: a18 := JTF_VARCHAR2_TABLE_100();
410: a19 := JTF_VARCHAR2_TABLE_2000();
411: else
412: a0 := JTF_VARCHAR2_TABLE_100();
413: a1 := JTF_VARCHAR2_TABLE_100();
414: a2 := JTF_VARCHAR2_TABLE_200();

Line 414: a2 := JTF_VARCHAR2_TABLE_200();

410: a19 := JTF_VARCHAR2_TABLE_2000();
411: else
412: a0 := JTF_VARCHAR2_TABLE_100();
413: a1 := JTF_VARCHAR2_TABLE_100();
414: a2 := JTF_VARCHAR2_TABLE_200();
415: a3 := JTF_VARCHAR2_TABLE_400();
416: a4 := JTF_VARCHAR2_TABLE_2000();
417: a5 := JTF_VARCHAR2_TABLE_100();
418: a6 := JTF_VARCHAR2_TABLE_100();

Line 416: a4 := JTF_VARCHAR2_TABLE_2000();

412: a0 := JTF_VARCHAR2_TABLE_100();
413: a1 := JTF_VARCHAR2_TABLE_100();
414: a2 := JTF_VARCHAR2_TABLE_200();
415: a3 := JTF_VARCHAR2_TABLE_400();
416: a4 := JTF_VARCHAR2_TABLE_2000();
417: a5 := JTF_VARCHAR2_TABLE_100();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_VARCHAR2_TABLE_400();

Line 419: a7 := JTF_VARCHAR2_TABLE_200();

415: a3 := JTF_VARCHAR2_TABLE_400();
416: a4 := JTF_VARCHAR2_TABLE_2000();
417: a5 := JTF_VARCHAR2_TABLE_100();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_VARCHAR2_TABLE_400();
421: a9 := JTF_VARCHAR2_TABLE_2000();
422: a10 := JTF_VARCHAR2_TABLE_100();
423: a11 := JTF_VARCHAR2_TABLE_100();

Line 421: a9 := JTF_VARCHAR2_TABLE_2000();

417: a5 := JTF_VARCHAR2_TABLE_100();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_VARCHAR2_TABLE_400();
421: a9 := JTF_VARCHAR2_TABLE_2000();
422: a10 := JTF_VARCHAR2_TABLE_100();
423: a11 := JTF_VARCHAR2_TABLE_100();
424: a12 := JTF_VARCHAR2_TABLE_200();
425: a13 := JTF_VARCHAR2_TABLE_400();

Line 424: a12 := JTF_VARCHAR2_TABLE_200();

420: a8 := JTF_VARCHAR2_TABLE_400();
421: a9 := JTF_VARCHAR2_TABLE_2000();
422: a10 := JTF_VARCHAR2_TABLE_100();
423: a11 := JTF_VARCHAR2_TABLE_100();
424: a12 := JTF_VARCHAR2_TABLE_200();
425: a13 := JTF_VARCHAR2_TABLE_400();
426: a14 := JTF_VARCHAR2_TABLE_2000();
427: a15 := JTF_VARCHAR2_TABLE_2000();
428: a16 := JTF_NUMBER_TABLE();

Line 426: a14 := JTF_VARCHAR2_TABLE_2000();

422: a10 := JTF_VARCHAR2_TABLE_100();
423: a11 := JTF_VARCHAR2_TABLE_100();
424: a12 := JTF_VARCHAR2_TABLE_200();
425: a13 := JTF_VARCHAR2_TABLE_400();
426: a14 := JTF_VARCHAR2_TABLE_2000();
427: a15 := JTF_VARCHAR2_TABLE_2000();
428: a16 := JTF_NUMBER_TABLE();
429: a17 := JTF_NUMBER_TABLE();
430: a18 := JTF_VARCHAR2_TABLE_100();

Line 427: a15 := JTF_VARCHAR2_TABLE_2000();

423: a11 := JTF_VARCHAR2_TABLE_100();
424: a12 := JTF_VARCHAR2_TABLE_200();
425: a13 := JTF_VARCHAR2_TABLE_400();
426: a14 := JTF_VARCHAR2_TABLE_2000();
427: a15 := JTF_VARCHAR2_TABLE_2000();
428: a16 := JTF_NUMBER_TABLE();
429: a17 := JTF_NUMBER_TABLE();
430: a18 := JTF_VARCHAR2_TABLE_100();
431: a19 := JTF_VARCHAR2_TABLE_2000();

Line 431: a19 := JTF_VARCHAR2_TABLE_2000();

427: a15 := JTF_VARCHAR2_TABLE_2000();
428: a16 := JTF_NUMBER_TABLE();
429: a17 := JTF_NUMBER_TABLE();
430: a18 := JTF_VARCHAR2_TABLE_100();
431: a19 := JTF_VARCHAR2_TABLE_2000();
432: if t.count > 0 then
433: a0.extend(t.count);
434: a1.extend(t.count);
435: a2.extend(t.count);

Line 502: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200

498: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
500: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
503: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
506: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 505: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200

501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
503: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
506: , p6_a15 out nocopy JTF_NUMBER_TABLE
507: , p6_a16 out nocopy JTF_DATE_TABLE
508: , p6_a17 out nocopy JTF_NUMBER_TABLE
509: , p6_a18 out nocopy JTF_DATE_TABLE

Line 528: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200

524: , p7_a13 out nocopy JTF_NUMBER_TABLE
525: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
526: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
527: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
528: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
529: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
530: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
531: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
532: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 531: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000

527: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
528: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
529: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
530: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
531: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
532: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
533: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
534: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
535: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_400

Line 533: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200

529: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
530: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
531: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
532: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
533: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
534: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
535: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_400
536: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
537: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 536: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000

532: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
533: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
534: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
535: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_400
536: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
537: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000
538: , p7_a27 out nocopy JTF_NUMBER_TABLE
539: , p7_a28 out nocopy JTF_DATE_TABLE
540: , p7_a29 out nocopy JTF_NUMBER_TABLE

Line 537: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000

533: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
534: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
535: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_400
536: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
537: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000
538: , p7_a27 out nocopy JTF_NUMBER_TABLE
539: , p7_a28 out nocopy JTF_DATE_TABLE
540: , p7_a29 out nocopy JTF_NUMBER_TABLE
541: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 543: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_2000

539: , p7_a28 out nocopy JTF_DATE_TABLE
540: , p7_a29 out nocopy JTF_NUMBER_TABLE
541: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
542: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
543: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_2000
544: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_2000
545: , p7_a34 out nocopy JTF_NUMBER_TABLE
546: , p7_a35 out nocopy JTF_DATE_TABLE
547: , x_record_count out nocopy NUMBER

Line 544: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_2000

540: , p7_a29 out nocopy JTF_NUMBER_TABLE
541: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
542: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
543: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_2000
544: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_2000
545: , p7_a34 out nocopy JTF_NUMBER_TABLE
546: , p7_a35 out nocopy JTF_DATE_TABLE
547: , x_record_count out nocopy NUMBER
548: , p5_a0 NUMBER := 0-1962.0724

Line 819: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_200

815: , p2_a7 out nocopy JTF_NUMBER_TABLE
816: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_600
817: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
818: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
819: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_200
820: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
821: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
822: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_200
823: , p2_a15 out nocopy JTF_NUMBER_TABLE

Line 822: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_200

818: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
819: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_200
820: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
821: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
822: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_200
823: , p2_a15 out nocopy JTF_NUMBER_TABLE
824: , p2_a16 out nocopy JTF_DATE_TABLE
825: , p2_a17 out nocopy JTF_NUMBER_TABLE
826: , p2_a18 out nocopy JTF_DATE_TABLE

Line 1053: , p1_a11 JTF_VARCHAR2_TABLE_200

1049: , p1_a7 JTF_NUMBER_TABLE
1050: , p1_a8 JTF_VARCHAR2_TABLE_600
1051: , p1_a9 JTF_VARCHAR2_TABLE_100
1052: , p1_a10 JTF_VARCHAR2_TABLE_100
1053: , p1_a11 JTF_VARCHAR2_TABLE_200
1054: , p1_a12 JTF_VARCHAR2_TABLE_100
1055: , p1_a13 JTF_VARCHAR2_TABLE_100
1056: , p1_a14 JTF_VARCHAR2_TABLE_200
1057: , p1_a15 JTF_NUMBER_TABLE

Line 1056: , p1_a14 JTF_VARCHAR2_TABLE_200

1052: , p1_a10 JTF_VARCHAR2_TABLE_100
1053: , p1_a11 JTF_VARCHAR2_TABLE_200
1054: , p1_a12 JTF_VARCHAR2_TABLE_100
1055: , p1_a13 JTF_VARCHAR2_TABLE_100
1056: , p1_a14 JTF_VARCHAR2_TABLE_200
1057: , p1_a15 JTF_NUMBER_TABLE
1058: , p1_a16 JTF_DATE_TABLE
1059: , p1_a17 JTF_NUMBER_TABLE
1060: , p1_a18 JTF_DATE_TABLE

Line 1074: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_200

1070: , p3_a7 out nocopy JTF_NUMBER_TABLE
1071: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_600
1072: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1073: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
1074: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_200
1075: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1076: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200
1078: , p3_a15 out nocopy JTF_NUMBER_TABLE

Line 1077: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200

1073: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
1074: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_200
1075: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1076: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200
1078: , p3_a15 out nocopy JTF_NUMBER_TABLE
1079: , p3_a16 out nocopy JTF_DATE_TABLE
1080: , p3_a17 out nocopy JTF_NUMBER_TABLE
1081: , p3_a18 out nocopy JTF_DATE_TABLE

Line 1326: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200

1322: procedure get_party_details(p_id_code VARCHAR2
1323: , p_id_value VARCHAR2
1324: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1325: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1326: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
1327: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
1328: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1329: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1328: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000

1324: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
1325: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
1326: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
1327: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
1328: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1329: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
1331: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
1332: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400

Line 1331: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200

1327: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
1328: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1329: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
1331: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
1332: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
1333: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1334: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
1335: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1333: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000

1329: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
1331: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
1332: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
1333: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1334: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
1335: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
1336: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_200
1337: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_400

Line 1336: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_200

1332: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
1333: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1334: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
1335: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
1336: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_200
1337: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_400
1338: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1339: , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p2_a16 out nocopy JTF_NUMBER_TABLE

Line 1338: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_2000

1334: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
1335: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
1336: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_200
1337: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_400
1338: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1339: , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p2_a16 out nocopy JTF_NUMBER_TABLE
1341: , p2_a17 out nocopy JTF_NUMBER_TABLE
1342: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 1339: , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000

1335: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
1336: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_200
1337: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_400
1338: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1339: , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p2_a16 out nocopy JTF_NUMBER_TABLE
1341: , p2_a17 out nocopy JTF_NUMBER_TABLE
1342: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
1343: , p2_a19 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1343: , p2_a19 out nocopy JTF_VARCHAR2_TABLE_2000

1339: , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p2_a16 out nocopy JTF_NUMBER_TABLE
1341: , p2_a17 out nocopy JTF_NUMBER_TABLE
1342: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
1343: , p2_a19 out nocopy JTF_VARCHAR2_TABLE_2000
1344: , x_return_status out nocopy VARCHAR2
1345: )
1346:
1347: as

Line 1412: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200

1408: , p6_a13 out nocopy JTF_NUMBER_TABLE
1409: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1410: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1411: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1412: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1413: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1414: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 1415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000

1411: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1412: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1413: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1414: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1417: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1418: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1419: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400

Line 1417: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200

1413: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1414: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1417: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1418: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1419: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1420: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1421: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1420: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000

1416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1417: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1418: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1419: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1420: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1421: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
1422: , p6_a27 out nocopy JTF_NUMBER_TABLE
1423: , p6_a28 out nocopy JTF_DATE_TABLE
1424: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 1421: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000

1417: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1418: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1419: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1420: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1421: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
1422: , p6_a27 out nocopy JTF_NUMBER_TABLE
1423: , p6_a28 out nocopy JTF_DATE_TABLE
1424: , p6_a29 out nocopy JTF_NUMBER_TABLE
1425: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1427: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000

1423: , p6_a28 out nocopy JTF_DATE_TABLE
1424: , p6_a29 out nocopy JTF_NUMBER_TABLE
1425: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1426: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1427: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
1428: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
1429: , p6_a34 out nocopy JTF_NUMBER_TABLE
1430: , p6_a35 out nocopy JTF_DATE_TABLE
1431: , x_record_count out nocopy NUMBER

Line 1428: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000

1424: , p6_a29 out nocopy JTF_NUMBER_TABLE
1425: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1426: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1427: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
1428: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
1429: , p6_a34 out nocopy JTF_NUMBER_TABLE
1430: , p6_a35 out nocopy JTF_DATE_TABLE
1431: , x_record_count out nocopy NUMBER
1432: , p5_a0 NUMBER := 0-1962.0724

Line 1600: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200

1596: , p6_a13 out nocopy JTF_NUMBER_TABLE
1597: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1599: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1600: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1604: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 1603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000

1599: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1600: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1604: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1606: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400

Line 1605: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200

1601: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1602: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1603: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1604: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1606: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1608: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1609: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1608: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000

1604: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1606: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1608: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1609: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
1610: , p6_a27 out nocopy JTF_NUMBER_TABLE
1611: , p6_a28 out nocopy JTF_DATE_TABLE
1612: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 1609: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000

1605: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1606: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1607: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1608: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1609: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
1610: , p6_a27 out nocopy JTF_NUMBER_TABLE
1611: , p6_a28 out nocopy JTF_DATE_TABLE
1612: , p6_a29 out nocopy JTF_NUMBER_TABLE
1613: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1615: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000

1611: , p6_a28 out nocopy JTF_DATE_TABLE
1612: , p6_a29 out nocopy JTF_NUMBER_TABLE
1613: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1615: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
1616: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
1617: , p6_a34 out nocopy JTF_NUMBER_TABLE
1618: , p6_a35 out nocopy JTF_DATE_TABLE
1619: , x_record_count out nocopy NUMBER

Line 1616: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000

1612: , p6_a29 out nocopy JTF_NUMBER_TABLE
1613: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1615: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
1616: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
1617: , p6_a34 out nocopy JTF_NUMBER_TABLE
1618: , p6_a35 out nocopy JTF_DATE_TABLE
1619: , x_record_count out nocopy NUMBER
1620: , p5_a0 NUMBER := 0-1962.0724

Line 1788: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200

1784: , p6_a13 out nocopy JTF_NUMBER_TABLE
1785: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1786: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1787: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1788: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1789: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1790: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1791: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1792: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 1791: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000

1787: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1788: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1789: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1790: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1791: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1792: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1793: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1794: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1795: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400

Line 1793: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200

1789: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1790: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
1791: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
1792: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1793: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1794: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1795: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1796: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1797: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1796: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000

1792: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1793: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1794: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1795: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1796: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1797: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
1798: , p6_a27 out nocopy JTF_NUMBER_TABLE
1799: , p6_a28 out nocopy JTF_DATE_TABLE
1800: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 1797: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000

1793: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1794: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1795: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
1796: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1797: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
1798: , p6_a27 out nocopy JTF_NUMBER_TABLE
1799: , p6_a28 out nocopy JTF_DATE_TABLE
1800: , p6_a29 out nocopy JTF_NUMBER_TABLE
1801: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1803: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000

1799: , p6_a28 out nocopy JTF_DATE_TABLE
1800: , p6_a29 out nocopy JTF_NUMBER_TABLE
1801: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1802: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1803: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
1804: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
1805: , p6_a34 out nocopy JTF_NUMBER_TABLE
1806: , p6_a35 out nocopy JTF_DATE_TABLE
1807: , x_record_count out nocopy NUMBER

Line 1804: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000

1800: , p6_a29 out nocopy JTF_NUMBER_TABLE
1801: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1802: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1803: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
1804: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
1805: , p6_a34 out nocopy JTF_NUMBER_TABLE
1806: , p6_a35 out nocopy JTF_DATE_TABLE
1807: , x_record_count out nocopy NUMBER
1808: , p5_a0 NUMBER := 0-1962.0724