APPS.OKL_MASS_REBOOK_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a1 JTF_VARCHAR2_TABLE_100

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.crit_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_200
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_VARCHAR2_TABLE_200

Line 55: , a1 out nocopy JTF_VARCHAR2_TABLE_100

51: end if;
52: end if;
53: end rosetta_table_copy_in_p31;
54: procedure rosetta_table_copy_out_p31(t okl_mass_rebook_pvt.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_VARCHAR2_TABLE_100
56: , a2 out nocopy JTF_VARCHAR2_TABLE_200
57: , a3 out nocopy JTF_VARCHAR2_TABLE_200
58: , a4 out nocopy JTF_VARCHAR2_TABLE_200
59: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 65: a1 := JTF_VARCHAR2_TABLE_100();

61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_VARCHAR2_TABLE_200();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();

Line 72: a1 := JTF_VARCHAR2_TABLE_100();

68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_200();
74: a3 := JTF_VARCHAR2_TABLE_200();
75: a4 := JTF_VARCHAR2_TABLE_200();
76: a5 := JTF_VARCHAR2_TABLE_200();

Line 184: , a17 JTF_VARCHAR2_TABLE_100

180: , a13 JTF_VARCHAR2_TABLE_500
181: , a14 JTF_VARCHAR2_TABLE_500
182: , a15 JTF_VARCHAR2_TABLE_500
183: , a16 JTF_VARCHAR2_TABLE_500
184: , a17 JTF_VARCHAR2_TABLE_100
185: , a18 JTF_VARCHAR2_TABLE_100
186: , a19 JTF_VARCHAR2_TABLE_200
187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200

Line 185: , a18 JTF_VARCHAR2_TABLE_100

181: , a14 JTF_VARCHAR2_TABLE_500
182: , a15 JTF_VARCHAR2_TABLE_500
183: , a16 JTF_VARCHAR2_TABLE_500
184: , a17 JTF_VARCHAR2_TABLE_100
185: , a18 JTF_VARCHAR2_TABLE_100
186: , a19 JTF_VARCHAR2_TABLE_200
187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100

Line 187: , a20 JTF_VARCHAR2_TABLE_100

183: , a16 JTF_VARCHAR2_TABLE_500
184: , a17 JTF_VARCHAR2_TABLE_100
185: , a18 JTF_VARCHAR2_TABLE_100
186: , a19 JTF_VARCHAR2_TABLE_200
187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
191: , a24 JTF_VARCHAR2_TABLE_100

Line 189: , a22 JTF_VARCHAR2_TABLE_100

185: , a18 JTF_VARCHAR2_TABLE_100
186: , a19 JTF_VARCHAR2_TABLE_200
187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
191: , a24 JTF_VARCHAR2_TABLE_100
192: , a25 JTF_VARCHAR2_TABLE_100
193: , a26 JTF_VARCHAR2_TABLE_100

Line 191: , a24 JTF_VARCHAR2_TABLE_100

187: , a20 JTF_VARCHAR2_TABLE_100
188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
191: , a24 JTF_VARCHAR2_TABLE_100
192: , a25 JTF_VARCHAR2_TABLE_100
193: , a26 JTF_VARCHAR2_TABLE_100
194: ) as
195: ddindx binary_integer; indx binary_integer;

Line 192: , a25 JTF_VARCHAR2_TABLE_100

188: , a21 JTF_VARCHAR2_TABLE_200
189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
191: , a24 JTF_VARCHAR2_TABLE_100
192: , a25 JTF_VARCHAR2_TABLE_100
193: , a26 JTF_VARCHAR2_TABLE_100
194: ) as
195: ddindx binary_integer; indx binary_integer;
196: begin

Line 193: , a26 JTF_VARCHAR2_TABLE_100

189: , a22 JTF_VARCHAR2_TABLE_100
190: , a23 JTF_VARCHAR2_TABLE_200
191: , a24 JTF_VARCHAR2_TABLE_100
192: , a25 JTF_VARCHAR2_TABLE_100
193: , a26 JTF_VARCHAR2_TABLE_100
194: ) as
195: ddindx binary_integer; indx binary_integer;
196: begin
197: if a0 is not null and a0.count > 0 then

Line 255: , a17 out nocopy JTF_VARCHAR2_TABLE_100

251: , a13 out nocopy JTF_VARCHAR2_TABLE_500
252: , a14 out nocopy JTF_VARCHAR2_TABLE_500
253: , a15 out nocopy JTF_VARCHAR2_TABLE_500
254: , a16 out nocopy JTF_VARCHAR2_TABLE_500
255: , a17 out nocopy JTF_VARCHAR2_TABLE_100
256: , a18 out nocopy JTF_VARCHAR2_TABLE_100
257: , a19 out nocopy JTF_VARCHAR2_TABLE_200
258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 256: , a18 out nocopy JTF_VARCHAR2_TABLE_100

252: , a14 out nocopy JTF_VARCHAR2_TABLE_500
253: , a15 out nocopy JTF_VARCHAR2_TABLE_500
254: , a16 out nocopy JTF_VARCHAR2_TABLE_500
255: , a17 out nocopy JTF_VARCHAR2_TABLE_100
256: , a18 out nocopy JTF_VARCHAR2_TABLE_100
257: , a19 out nocopy JTF_VARCHAR2_TABLE_200
258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , a20 out nocopy JTF_VARCHAR2_TABLE_100

254: , a16 out nocopy JTF_VARCHAR2_TABLE_500
255: , a17 out nocopy JTF_VARCHAR2_TABLE_100
256: , a18 out nocopy JTF_VARCHAR2_TABLE_100
257: , a19 out nocopy JTF_VARCHAR2_TABLE_200
258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
262: , a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 260: , a22 out nocopy JTF_VARCHAR2_TABLE_100

256: , a18 out nocopy JTF_VARCHAR2_TABLE_100
257: , a19 out nocopy JTF_VARCHAR2_TABLE_200
258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
262: , a24 out nocopy JTF_VARCHAR2_TABLE_100
263: , a25 out nocopy JTF_VARCHAR2_TABLE_100
264: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , a24 out nocopy JTF_VARCHAR2_TABLE_100

258: , a20 out nocopy JTF_VARCHAR2_TABLE_100
259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
262: , a24 out nocopy JTF_VARCHAR2_TABLE_100
263: , a25 out nocopy JTF_VARCHAR2_TABLE_100
264: , a26 out nocopy JTF_VARCHAR2_TABLE_100
265: ) as
266: ddindx binary_integer; indx binary_integer;

Line 263: , a25 out nocopy JTF_VARCHAR2_TABLE_100

259: , a21 out nocopy JTF_VARCHAR2_TABLE_200
260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
262: , a24 out nocopy JTF_VARCHAR2_TABLE_100
263: , a25 out nocopy JTF_VARCHAR2_TABLE_100
264: , a26 out nocopy JTF_VARCHAR2_TABLE_100
265: ) as
266: ddindx binary_integer; indx binary_integer;
267: begin

Line 264: , a26 out nocopy JTF_VARCHAR2_TABLE_100

260: , a22 out nocopy JTF_VARCHAR2_TABLE_100
261: , a23 out nocopy JTF_VARCHAR2_TABLE_200
262: , a24 out nocopy JTF_VARCHAR2_TABLE_100
263: , a25 out nocopy JTF_VARCHAR2_TABLE_100
264: , a26 out nocopy JTF_VARCHAR2_TABLE_100
265: ) as
266: ddindx binary_integer; indx binary_integer;
267: begin
268: if t is null or t.count = 0 then

Line 286: a17 := JTF_VARCHAR2_TABLE_100();

282: a13 := JTF_VARCHAR2_TABLE_500();
283: a14 := JTF_VARCHAR2_TABLE_500();
284: a15 := JTF_VARCHAR2_TABLE_500();
285: a16 := JTF_VARCHAR2_TABLE_500();
286: a17 := JTF_VARCHAR2_TABLE_100();
287: a18 := JTF_VARCHAR2_TABLE_100();
288: a19 := JTF_VARCHAR2_TABLE_200();
289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();

Line 287: a18 := JTF_VARCHAR2_TABLE_100();

283: a14 := JTF_VARCHAR2_TABLE_500();
284: a15 := JTF_VARCHAR2_TABLE_500();
285: a16 := JTF_VARCHAR2_TABLE_500();
286: a17 := JTF_VARCHAR2_TABLE_100();
287: a18 := JTF_VARCHAR2_TABLE_100();
288: a19 := JTF_VARCHAR2_TABLE_200();
289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();

Line 289: a20 := JTF_VARCHAR2_TABLE_100();

285: a16 := JTF_VARCHAR2_TABLE_500();
286: a17 := JTF_VARCHAR2_TABLE_100();
287: a18 := JTF_VARCHAR2_TABLE_100();
288: a19 := JTF_VARCHAR2_TABLE_200();
289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
293: a24 := JTF_VARCHAR2_TABLE_100();

Line 291: a22 := JTF_VARCHAR2_TABLE_100();

287: a18 := JTF_VARCHAR2_TABLE_100();
288: a19 := JTF_VARCHAR2_TABLE_200();
289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
293: a24 := JTF_VARCHAR2_TABLE_100();
294: a25 := JTF_VARCHAR2_TABLE_100();
295: a26 := JTF_VARCHAR2_TABLE_100();

Line 293: a24 := JTF_VARCHAR2_TABLE_100();

289: a20 := JTF_VARCHAR2_TABLE_100();
290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
293: a24 := JTF_VARCHAR2_TABLE_100();
294: a25 := JTF_VARCHAR2_TABLE_100();
295: a26 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();

Line 294: a25 := JTF_VARCHAR2_TABLE_100();

290: a21 := JTF_VARCHAR2_TABLE_200();
291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
293: a24 := JTF_VARCHAR2_TABLE_100();
294: a25 := JTF_VARCHAR2_TABLE_100();
295: a26 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();

Line 295: a26 := JTF_VARCHAR2_TABLE_100();

291: a22 := JTF_VARCHAR2_TABLE_100();
292: a23 := JTF_VARCHAR2_TABLE_200();
293: a24 := JTF_VARCHAR2_TABLE_100();
294: a25 := JTF_VARCHAR2_TABLE_100();
295: a26 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_VARCHAR2_TABLE_500();

Line 314: a17 := JTF_VARCHAR2_TABLE_100();

310: a13 := JTF_VARCHAR2_TABLE_500();
311: a14 := JTF_VARCHAR2_TABLE_500();
312: a15 := JTF_VARCHAR2_TABLE_500();
313: a16 := JTF_VARCHAR2_TABLE_500();
314: a17 := JTF_VARCHAR2_TABLE_100();
315: a18 := JTF_VARCHAR2_TABLE_100();
316: a19 := JTF_VARCHAR2_TABLE_200();
317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();

Line 315: a18 := JTF_VARCHAR2_TABLE_100();

311: a14 := JTF_VARCHAR2_TABLE_500();
312: a15 := JTF_VARCHAR2_TABLE_500();
313: a16 := JTF_VARCHAR2_TABLE_500();
314: a17 := JTF_VARCHAR2_TABLE_100();
315: a18 := JTF_VARCHAR2_TABLE_100();
316: a19 := JTF_VARCHAR2_TABLE_200();
317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();

Line 317: a20 := JTF_VARCHAR2_TABLE_100();

313: a16 := JTF_VARCHAR2_TABLE_500();
314: a17 := JTF_VARCHAR2_TABLE_100();
315: a18 := JTF_VARCHAR2_TABLE_100();
316: a19 := JTF_VARCHAR2_TABLE_200();
317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
321: a24 := JTF_VARCHAR2_TABLE_100();

Line 319: a22 := JTF_VARCHAR2_TABLE_100();

315: a18 := JTF_VARCHAR2_TABLE_100();
316: a19 := JTF_VARCHAR2_TABLE_200();
317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_100();
323: a26 := JTF_VARCHAR2_TABLE_100();

Line 321: a24 := JTF_VARCHAR2_TABLE_100();

317: a20 := JTF_VARCHAR2_TABLE_100();
318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_100();
323: a26 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);

Line 322: a25 := JTF_VARCHAR2_TABLE_100();

318: a21 := JTF_VARCHAR2_TABLE_200();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_100();
323: a26 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);
326: a1.extend(t.count);

Line 323: a26 := JTF_VARCHAR2_TABLE_100();

319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_VARCHAR2_TABLE_200();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_100();
323: a26 := JTF_VARCHAR2_TABLE_100();
324: if t.count > 0 then
325: a0.extend(t.count);
326: a1.extend(t.count);
327: a2.extend(t.count);

Line 494: , p6_a3 JTF_VARCHAR2_TABLE_100

490: , p_request_name VARCHAR2
491: , p6_a0 JTF_NUMBER_TABLE
492: , p6_a1 JTF_VARCHAR2_TABLE_600
493: , p6_a2 JTF_NUMBER_TABLE
494: , p6_a3 JTF_VARCHAR2_TABLE_100
495: , p6_a4 JTF_VARCHAR2_TABLE_100
496: , p6_a5 JTF_VARCHAR2_TABLE_100
497: , p6_a6 JTF_VARCHAR2_TABLE_600
498: , p6_a7 JTF_VARCHAR2_TABLE_600

Line 495: , p6_a4 JTF_VARCHAR2_TABLE_100

491: , p6_a0 JTF_NUMBER_TABLE
492: , p6_a1 JTF_VARCHAR2_TABLE_600
493: , p6_a2 JTF_NUMBER_TABLE
494: , p6_a3 JTF_VARCHAR2_TABLE_100
495: , p6_a4 JTF_VARCHAR2_TABLE_100
496: , p6_a5 JTF_VARCHAR2_TABLE_100
497: , p6_a6 JTF_VARCHAR2_TABLE_600
498: , p6_a7 JTF_VARCHAR2_TABLE_600
499: , p6_a8 JTF_VARCHAR2_TABLE_600

Line 496: , p6_a5 JTF_VARCHAR2_TABLE_100

492: , p6_a1 JTF_VARCHAR2_TABLE_600
493: , p6_a2 JTF_NUMBER_TABLE
494: , p6_a3 JTF_VARCHAR2_TABLE_100
495: , p6_a4 JTF_VARCHAR2_TABLE_100
496: , p6_a5 JTF_VARCHAR2_TABLE_100
497: , p6_a6 JTF_VARCHAR2_TABLE_600
498: , p6_a7 JTF_VARCHAR2_TABLE_600
499: , p6_a8 JTF_VARCHAR2_TABLE_600
500: , p6_a9 JTF_VARCHAR2_TABLE_2000

Line 501: , p6_a10 JTF_VARCHAR2_TABLE_100

497: , p6_a6 JTF_VARCHAR2_TABLE_600
498: , p6_a7 JTF_VARCHAR2_TABLE_600
499: , p6_a8 JTF_VARCHAR2_TABLE_600
500: , p6_a9 JTF_VARCHAR2_TABLE_2000
501: , p6_a10 JTF_VARCHAR2_TABLE_100
502: , p6_a11 JTF_VARCHAR2_TABLE_100
503: , p6_a12 JTF_VARCHAR2_TABLE_500
504: , p6_a13 JTF_VARCHAR2_TABLE_500
505: , p6_a14 JTF_VARCHAR2_TABLE_500

Line 502: , p6_a11 JTF_VARCHAR2_TABLE_100

498: , p6_a7 JTF_VARCHAR2_TABLE_600
499: , p6_a8 JTF_VARCHAR2_TABLE_600
500: , p6_a9 JTF_VARCHAR2_TABLE_2000
501: , p6_a10 JTF_VARCHAR2_TABLE_100
502: , p6_a11 JTF_VARCHAR2_TABLE_100
503: , p6_a12 JTF_VARCHAR2_TABLE_500
504: , p6_a13 JTF_VARCHAR2_TABLE_500
505: , p6_a14 JTF_VARCHAR2_TABLE_500
506: , p6_a15 JTF_VARCHAR2_TABLE_500

Line 530: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

526: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
527: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
528: , p7_a5 out nocopy JTF_NUMBER_TABLE
529: , p7_a6 out nocopy JTF_NUMBER_TABLE
530: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
531: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
532: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
533: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
534: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 531: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

527: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
528: , p7_a5 out nocopy JTF_NUMBER_TABLE
529: , p7_a6 out nocopy JTF_NUMBER_TABLE
530: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
531: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
532: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
533: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
534: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_500
535: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 532: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

528: , p7_a5 out nocopy JTF_NUMBER_TABLE
529: , p7_a6 out nocopy JTF_NUMBER_TABLE
530: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
531: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
532: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
533: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
534: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_500
535: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_500
536: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 670: , p7_a3 JTF_VARCHAR2_TABLE_100

666: , p_transaction_date date
667: , p7_a0 JTF_NUMBER_TABLE
668: , p7_a1 JTF_VARCHAR2_TABLE_600
669: , p7_a2 JTF_NUMBER_TABLE
670: , p7_a3 JTF_VARCHAR2_TABLE_100
671: , p7_a4 JTF_VARCHAR2_TABLE_100
672: , p7_a5 JTF_VARCHAR2_TABLE_100
673: , p7_a6 JTF_VARCHAR2_TABLE_600
674: , p7_a7 JTF_VARCHAR2_TABLE_600

Line 671: , p7_a4 JTF_VARCHAR2_TABLE_100

667: , p7_a0 JTF_NUMBER_TABLE
668: , p7_a1 JTF_VARCHAR2_TABLE_600
669: , p7_a2 JTF_NUMBER_TABLE
670: , p7_a3 JTF_VARCHAR2_TABLE_100
671: , p7_a4 JTF_VARCHAR2_TABLE_100
672: , p7_a5 JTF_VARCHAR2_TABLE_100
673: , p7_a6 JTF_VARCHAR2_TABLE_600
674: , p7_a7 JTF_VARCHAR2_TABLE_600
675: , p7_a8 JTF_VARCHAR2_TABLE_600

Line 672: , p7_a5 JTF_VARCHAR2_TABLE_100

668: , p7_a1 JTF_VARCHAR2_TABLE_600
669: , p7_a2 JTF_NUMBER_TABLE
670: , p7_a3 JTF_VARCHAR2_TABLE_100
671: , p7_a4 JTF_VARCHAR2_TABLE_100
672: , p7_a5 JTF_VARCHAR2_TABLE_100
673: , p7_a6 JTF_VARCHAR2_TABLE_600
674: , p7_a7 JTF_VARCHAR2_TABLE_600
675: , p7_a8 JTF_VARCHAR2_TABLE_600
676: , p7_a9 JTF_VARCHAR2_TABLE_2000

Line 677: , p7_a10 JTF_VARCHAR2_TABLE_100

673: , p7_a6 JTF_VARCHAR2_TABLE_600
674: , p7_a7 JTF_VARCHAR2_TABLE_600
675: , p7_a8 JTF_VARCHAR2_TABLE_600
676: , p7_a9 JTF_VARCHAR2_TABLE_2000
677: , p7_a10 JTF_VARCHAR2_TABLE_100
678: , p7_a11 JTF_VARCHAR2_TABLE_100
679: , p7_a12 JTF_VARCHAR2_TABLE_500
680: , p7_a13 JTF_VARCHAR2_TABLE_500
681: , p7_a14 JTF_VARCHAR2_TABLE_500

Line 678: , p7_a11 JTF_VARCHAR2_TABLE_100

674: , p7_a7 JTF_VARCHAR2_TABLE_600
675: , p7_a8 JTF_VARCHAR2_TABLE_600
676: , p7_a9 JTF_VARCHAR2_TABLE_2000
677: , p7_a10 JTF_VARCHAR2_TABLE_100
678: , p7_a11 JTF_VARCHAR2_TABLE_100
679: , p7_a12 JTF_VARCHAR2_TABLE_500
680: , p7_a13 JTF_VARCHAR2_TABLE_500
681: , p7_a14 JTF_VARCHAR2_TABLE_500
682: , p7_a15 JTF_VARCHAR2_TABLE_500

Line 706: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

702: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
703: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
704: , p8_a5 out nocopy JTF_NUMBER_TABLE
705: , p8_a6 out nocopy JTF_NUMBER_TABLE
706: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
707: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
708: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
709: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500
710: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 707: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

703: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600
704: , p8_a5 out nocopy JTF_NUMBER_TABLE
705: , p8_a6 out nocopy JTF_NUMBER_TABLE
706: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
707: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
708: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
709: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500
710: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_500
711: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 708: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

704: , p8_a5 out nocopy JTF_NUMBER_TABLE
705: , p8_a6 out nocopy JTF_NUMBER_TABLE
706: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
707: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
708: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
709: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500
710: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_500
711: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_500
712: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 873: , p12_a17 JTF_VARCHAR2_TABLE_100

869: , p12_a13 JTF_VARCHAR2_TABLE_500
870: , p12_a14 JTF_VARCHAR2_TABLE_500
871: , p12_a15 JTF_VARCHAR2_TABLE_500
872: , p12_a16 JTF_VARCHAR2_TABLE_500
873: , p12_a17 JTF_VARCHAR2_TABLE_100
874: , p12_a18 JTF_VARCHAR2_TABLE_100
875: , p12_a19 JTF_VARCHAR2_TABLE_200
876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200

Line 874: , p12_a18 JTF_VARCHAR2_TABLE_100

870: , p12_a14 JTF_VARCHAR2_TABLE_500
871: , p12_a15 JTF_VARCHAR2_TABLE_500
872: , p12_a16 JTF_VARCHAR2_TABLE_500
873: , p12_a17 JTF_VARCHAR2_TABLE_100
874: , p12_a18 JTF_VARCHAR2_TABLE_100
875: , p12_a19 JTF_VARCHAR2_TABLE_200
876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100

Line 876: , p12_a20 JTF_VARCHAR2_TABLE_100

872: , p12_a16 JTF_VARCHAR2_TABLE_500
873: , p12_a17 JTF_VARCHAR2_TABLE_100
874: , p12_a18 JTF_VARCHAR2_TABLE_100
875: , p12_a19 JTF_VARCHAR2_TABLE_200
876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
880: , p12_a24 JTF_VARCHAR2_TABLE_100

Line 878: , p12_a22 JTF_VARCHAR2_TABLE_100

874: , p12_a18 JTF_VARCHAR2_TABLE_100
875: , p12_a19 JTF_VARCHAR2_TABLE_200
876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
880: , p12_a24 JTF_VARCHAR2_TABLE_100
881: , p12_a25 JTF_VARCHAR2_TABLE_100
882: , p12_a26 JTF_VARCHAR2_TABLE_100

Line 880: , p12_a24 JTF_VARCHAR2_TABLE_100

876: , p12_a20 JTF_VARCHAR2_TABLE_100
877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
880: , p12_a24 JTF_VARCHAR2_TABLE_100
881: , p12_a25 JTF_VARCHAR2_TABLE_100
882: , p12_a26 JTF_VARCHAR2_TABLE_100
883: )
884:

Line 881: , p12_a25 JTF_VARCHAR2_TABLE_100

877: , p12_a21 JTF_VARCHAR2_TABLE_200
878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
880: , p12_a24 JTF_VARCHAR2_TABLE_100
881: , p12_a25 JTF_VARCHAR2_TABLE_100
882: , p12_a26 JTF_VARCHAR2_TABLE_100
883: )
884:
885: as

Line 882: , p12_a26 JTF_VARCHAR2_TABLE_100

878: , p12_a22 JTF_VARCHAR2_TABLE_100
879: , p12_a23 JTF_VARCHAR2_TABLE_200
880: , p12_a24 JTF_VARCHAR2_TABLE_100
881: , p12_a25 JTF_VARCHAR2_TABLE_100
882: , p12_a26 JTF_VARCHAR2_TABLE_100
883: )
884:
885: as
886: ddp_rbk_tbl okl_mass_rebook_pvt.rbk_tbl_type;

Line 1002: , p12_a17 JTF_VARCHAR2_TABLE_100

998: , p12_a13 JTF_VARCHAR2_TABLE_500
999: , p12_a14 JTF_VARCHAR2_TABLE_500
1000: , p12_a15 JTF_VARCHAR2_TABLE_500
1001: , p12_a16 JTF_VARCHAR2_TABLE_500
1002: , p12_a17 JTF_VARCHAR2_TABLE_100
1003: , p12_a18 JTF_VARCHAR2_TABLE_100
1004: , p12_a19 JTF_VARCHAR2_TABLE_200
1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200

Line 1003: , p12_a18 JTF_VARCHAR2_TABLE_100

999: , p12_a14 JTF_VARCHAR2_TABLE_500
1000: , p12_a15 JTF_VARCHAR2_TABLE_500
1001: , p12_a16 JTF_VARCHAR2_TABLE_500
1002: , p12_a17 JTF_VARCHAR2_TABLE_100
1003: , p12_a18 JTF_VARCHAR2_TABLE_100
1004: , p12_a19 JTF_VARCHAR2_TABLE_200
1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100

Line 1005: , p12_a20 JTF_VARCHAR2_TABLE_100

1001: , p12_a16 JTF_VARCHAR2_TABLE_500
1002: , p12_a17 JTF_VARCHAR2_TABLE_100
1003: , p12_a18 JTF_VARCHAR2_TABLE_100
1004: , p12_a19 JTF_VARCHAR2_TABLE_200
1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1009: , p12_a24 JTF_VARCHAR2_TABLE_100

Line 1007: , p12_a22 JTF_VARCHAR2_TABLE_100

1003: , p12_a18 JTF_VARCHAR2_TABLE_100
1004: , p12_a19 JTF_VARCHAR2_TABLE_200
1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1009: , p12_a24 JTF_VARCHAR2_TABLE_100
1010: , p12_a25 JTF_VARCHAR2_TABLE_100
1011: , p12_a26 JTF_VARCHAR2_TABLE_100

Line 1009: , p12_a24 JTF_VARCHAR2_TABLE_100

1005: , p12_a20 JTF_VARCHAR2_TABLE_100
1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1009: , p12_a24 JTF_VARCHAR2_TABLE_100
1010: , p12_a25 JTF_VARCHAR2_TABLE_100
1011: , p12_a26 JTF_VARCHAR2_TABLE_100
1012: , p13_a0 out nocopy JTF_NUMBER_TABLE
1013: , p13_a1 out nocopy JTF_NUMBER_TABLE

Line 1010: , p12_a25 JTF_VARCHAR2_TABLE_100

1006: , p12_a21 JTF_VARCHAR2_TABLE_200
1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1009: , p12_a24 JTF_VARCHAR2_TABLE_100
1010: , p12_a25 JTF_VARCHAR2_TABLE_100
1011: , p12_a26 JTF_VARCHAR2_TABLE_100
1012: , p13_a0 out nocopy JTF_NUMBER_TABLE
1013: , p13_a1 out nocopy JTF_NUMBER_TABLE
1014: )

Line 1011: , p12_a26 JTF_VARCHAR2_TABLE_100

1007: , p12_a22 JTF_VARCHAR2_TABLE_100
1008: , p12_a23 JTF_VARCHAR2_TABLE_200
1009: , p12_a24 JTF_VARCHAR2_TABLE_100
1010: , p12_a25 JTF_VARCHAR2_TABLE_100
1011: , p12_a26 JTF_VARCHAR2_TABLE_100
1012: , p13_a0 out nocopy JTF_NUMBER_TABLE
1013: , p13_a1 out nocopy JTF_NUMBER_TABLE
1014: )
1015:

Line 1140: , p12_a17 JTF_VARCHAR2_TABLE_100

1136: , p12_a13 JTF_VARCHAR2_TABLE_500
1137: , p12_a14 JTF_VARCHAR2_TABLE_500
1138: , p12_a15 JTF_VARCHAR2_TABLE_500
1139: , p12_a16 JTF_VARCHAR2_TABLE_500
1140: , p12_a17 JTF_VARCHAR2_TABLE_100
1141: , p12_a18 JTF_VARCHAR2_TABLE_100
1142: , p12_a19 JTF_VARCHAR2_TABLE_200
1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200

Line 1141: , p12_a18 JTF_VARCHAR2_TABLE_100

1137: , p12_a14 JTF_VARCHAR2_TABLE_500
1138: , p12_a15 JTF_VARCHAR2_TABLE_500
1139: , p12_a16 JTF_VARCHAR2_TABLE_500
1140: , p12_a17 JTF_VARCHAR2_TABLE_100
1141: , p12_a18 JTF_VARCHAR2_TABLE_100
1142: , p12_a19 JTF_VARCHAR2_TABLE_200
1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100

Line 1143: , p12_a20 JTF_VARCHAR2_TABLE_100

1139: , p12_a16 JTF_VARCHAR2_TABLE_500
1140: , p12_a17 JTF_VARCHAR2_TABLE_100
1141: , p12_a18 JTF_VARCHAR2_TABLE_100
1142: , p12_a19 JTF_VARCHAR2_TABLE_200
1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1147: , p12_a24 JTF_VARCHAR2_TABLE_100

Line 1145: , p12_a22 JTF_VARCHAR2_TABLE_100

1141: , p12_a18 JTF_VARCHAR2_TABLE_100
1142: , p12_a19 JTF_VARCHAR2_TABLE_200
1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1147: , p12_a24 JTF_VARCHAR2_TABLE_100
1148: , p12_a25 JTF_VARCHAR2_TABLE_100
1149: , p12_a26 JTF_VARCHAR2_TABLE_100

Line 1147: , p12_a24 JTF_VARCHAR2_TABLE_100

1143: , p12_a20 JTF_VARCHAR2_TABLE_100
1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1147: , p12_a24 JTF_VARCHAR2_TABLE_100
1148: , p12_a25 JTF_VARCHAR2_TABLE_100
1149: , p12_a26 JTF_VARCHAR2_TABLE_100
1150: , p_transaction_date date
1151: , p14_a0 out nocopy JTF_NUMBER_TABLE

Line 1148: , p12_a25 JTF_VARCHAR2_TABLE_100

1144: , p12_a21 JTF_VARCHAR2_TABLE_200
1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1147: , p12_a24 JTF_VARCHAR2_TABLE_100
1148: , p12_a25 JTF_VARCHAR2_TABLE_100
1149: , p12_a26 JTF_VARCHAR2_TABLE_100
1150: , p_transaction_date date
1151: , p14_a0 out nocopy JTF_NUMBER_TABLE
1152: , p14_a1 out nocopy JTF_NUMBER_TABLE

Line 1149: , p12_a26 JTF_VARCHAR2_TABLE_100

1145: , p12_a22 JTF_VARCHAR2_TABLE_100
1146: , p12_a23 JTF_VARCHAR2_TABLE_200
1147: , p12_a24 JTF_VARCHAR2_TABLE_100
1148: , p12_a25 JTF_VARCHAR2_TABLE_100
1149: , p12_a26 JTF_VARCHAR2_TABLE_100
1150: , p_transaction_date date
1151: , p14_a0 out nocopy JTF_NUMBER_TABLE
1152: , p14_a1 out nocopy JTF_NUMBER_TABLE
1153: )

Line 1284: , p12_a17 JTF_VARCHAR2_TABLE_100

1280: , p12_a13 JTF_VARCHAR2_TABLE_500
1281: , p12_a14 JTF_VARCHAR2_TABLE_500
1282: , p12_a15 JTF_VARCHAR2_TABLE_500
1283: , p12_a16 JTF_VARCHAR2_TABLE_500
1284: , p12_a17 JTF_VARCHAR2_TABLE_100
1285: , p12_a18 JTF_VARCHAR2_TABLE_100
1286: , p12_a19 JTF_VARCHAR2_TABLE_200
1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200

Line 1285: , p12_a18 JTF_VARCHAR2_TABLE_100

1281: , p12_a14 JTF_VARCHAR2_TABLE_500
1282: , p12_a15 JTF_VARCHAR2_TABLE_500
1283: , p12_a16 JTF_VARCHAR2_TABLE_500
1284: , p12_a17 JTF_VARCHAR2_TABLE_100
1285: , p12_a18 JTF_VARCHAR2_TABLE_100
1286: , p12_a19 JTF_VARCHAR2_TABLE_200
1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100

Line 1287: , p12_a20 JTF_VARCHAR2_TABLE_100

1283: , p12_a16 JTF_VARCHAR2_TABLE_500
1284: , p12_a17 JTF_VARCHAR2_TABLE_100
1285: , p12_a18 JTF_VARCHAR2_TABLE_100
1286: , p12_a19 JTF_VARCHAR2_TABLE_200
1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1291: , p12_a24 JTF_VARCHAR2_TABLE_100

Line 1289: , p12_a22 JTF_VARCHAR2_TABLE_100

1285: , p12_a18 JTF_VARCHAR2_TABLE_100
1286: , p12_a19 JTF_VARCHAR2_TABLE_200
1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1291: , p12_a24 JTF_VARCHAR2_TABLE_100
1292: , p12_a25 JTF_VARCHAR2_TABLE_100
1293: , p12_a26 JTF_VARCHAR2_TABLE_100

Line 1291: , p12_a24 JTF_VARCHAR2_TABLE_100

1287: , p12_a20 JTF_VARCHAR2_TABLE_100
1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1291: , p12_a24 JTF_VARCHAR2_TABLE_100
1292: , p12_a25 JTF_VARCHAR2_TABLE_100
1293: , p12_a26 JTF_VARCHAR2_TABLE_100
1294: , p_source_trx_id NUMBER
1295: , p_source_trx_type VARCHAR2

Line 1292: , p12_a25 JTF_VARCHAR2_TABLE_100

1288: , p12_a21 JTF_VARCHAR2_TABLE_200
1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1291: , p12_a24 JTF_VARCHAR2_TABLE_100
1292: , p12_a25 JTF_VARCHAR2_TABLE_100
1293: , p12_a26 JTF_VARCHAR2_TABLE_100
1294: , p_source_trx_id NUMBER
1295: , p_source_trx_type VARCHAR2
1296: , x_mass_rebook_trx_id out nocopy NUMBER

Line 1293: , p12_a26 JTF_VARCHAR2_TABLE_100

1289: , p12_a22 JTF_VARCHAR2_TABLE_100
1290: , p12_a23 JTF_VARCHAR2_TABLE_200
1291: , p12_a24 JTF_VARCHAR2_TABLE_100
1292: , p12_a25 JTF_VARCHAR2_TABLE_100
1293: , p12_a26 JTF_VARCHAR2_TABLE_100
1294: , p_source_trx_id NUMBER
1295: , p_source_trx_type VARCHAR2
1296: , x_mass_rebook_trx_id out nocopy NUMBER
1297: )

Line 1425: , p12_a17 JTF_VARCHAR2_TABLE_100

1421: , p12_a13 JTF_VARCHAR2_TABLE_500
1422: , p12_a14 JTF_VARCHAR2_TABLE_500
1423: , p12_a15 JTF_VARCHAR2_TABLE_500
1424: , p12_a16 JTF_VARCHAR2_TABLE_500
1425: , p12_a17 JTF_VARCHAR2_TABLE_100
1426: , p12_a18 JTF_VARCHAR2_TABLE_100
1427: , p12_a19 JTF_VARCHAR2_TABLE_200
1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200

Line 1426: , p12_a18 JTF_VARCHAR2_TABLE_100

1422: , p12_a14 JTF_VARCHAR2_TABLE_500
1423: , p12_a15 JTF_VARCHAR2_TABLE_500
1424: , p12_a16 JTF_VARCHAR2_TABLE_500
1425: , p12_a17 JTF_VARCHAR2_TABLE_100
1426: , p12_a18 JTF_VARCHAR2_TABLE_100
1427: , p12_a19 JTF_VARCHAR2_TABLE_200
1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100

Line 1428: , p12_a20 JTF_VARCHAR2_TABLE_100

1424: , p12_a16 JTF_VARCHAR2_TABLE_500
1425: , p12_a17 JTF_VARCHAR2_TABLE_100
1426: , p12_a18 JTF_VARCHAR2_TABLE_100
1427: , p12_a19 JTF_VARCHAR2_TABLE_200
1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1432: , p12_a24 JTF_VARCHAR2_TABLE_100

Line 1430: , p12_a22 JTF_VARCHAR2_TABLE_100

1426: , p12_a18 JTF_VARCHAR2_TABLE_100
1427: , p12_a19 JTF_VARCHAR2_TABLE_200
1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1432: , p12_a24 JTF_VARCHAR2_TABLE_100
1433: , p12_a25 JTF_VARCHAR2_TABLE_100
1434: , p12_a26 JTF_VARCHAR2_TABLE_100

Line 1432: , p12_a24 JTF_VARCHAR2_TABLE_100

1428: , p12_a20 JTF_VARCHAR2_TABLE_100
1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1432: , p12_a24 JTF_VARCHAR2_TABLE_100
1433: , p12_a25 JTF_VARCHAR2_TABLE_100
1434: , p12_a26 JTF_VARCHAR2_TABLE_100
1435: , p_source_trx_id NUMBER
1436: , p_source_trx_type VARCHAR2

Line 1433: , p12_a25 JTF_VARCHAR2_TABLE_100

1429: , p12_a21 JTF_VARCHAR2_TABLE_200
1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1432: , p12_a24 JTF_VARCHAR2_TABLE_100
1433: , p12_a25 JTF_VARCHAR2_TABLE_100
1434: , p12_a26 JTF_VARCHAR2_TABLE_100
1435: , p_source_trx_id NUMBER
1436: , p_source_trx_type VARCHAR2
1437: , p_transaction_date date

Line 1434: , p12_a26 JTF_VARCHAR2_TABLE_100

1430: , p12_a22 JTF_VARCHAR2_TABLE_100
1431: , p12_a23 JTF_VARCHAR2_TABLE_200
1432: , p12_a24 JTF_VARCHAR2_TABLE_100
1433: , p12_a25 JTF_VARCHAR2_TABLE_100
1434: , p12_a26 JTF_VARCHAR2_TABLE_100
1435: , p_source_trx_id NUMBER
1436: , p_source_trx_type VARCHAR2
1437: , p_transaction_date date
1438: , x_mass_rebook_trx_id out nocopy NUMBER

Line 1570: , p13_a17 JTF_VARCHAR2_TABLE_100

1566: , p13_a13 JTF_VARCHAR2_TABLE_500
1567: , p13_a14 JTF_VARCHAR2_TABLE_500
1568: , p13_a15 JTF_VARCHAR2_TABLE_500
1569: , p13_a16 JTF_VARCHAR2_TABLE_500
1570: , p13_a17 JTF_VARCHAR2_TABLE_100
1571: , p13_a18 JTF_VARCHAR2_TABLE_100
1572: , p13_a19 JTF_VARCHAR2_TABLE_200
1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200

Line 1571: , p13_a18 JTF_VARCHAR2_TABLE_100

1567: , p13_a14 JTF_VARCHAR2_TABLE_500
1568: , p13_a15 JTF_VARCHAR2_TABLE_500
1569: , p13_a16 JTF_VARCHAR2_TABLE_500
1570: , p13_a17 JTF_VARCHAR2_TABLE_100
1571: , p13_a18 JTF_VARCHAR2_TABLE_100
1572: , p13_a19 JTF_VARCHAR2_TABLE_200
1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100

Line 1573: , p13_a20 JTF_VARCHAR2_TABLE_100

1569: , p13_a16 JTF_VARCHAR2_TABLE_500
1570: , p13_a17 JTF_VARCHAR2_TABLE_100
1571: , p13_a18 JTF_VARCHAR2_TABLE_100
1572: , p13_a19 JTF_VARCHAR2_TABLE_200
1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1577: , p13_a24 JTF_VARCHAR2_TABLE_100

Line 1575: , p13_a22 JTF_VARCHAR2_TABLE_100

1571: , p13_a18 JTF_VARCHAR2_TABLE_100
1572: , p13_a19 JTF_VARCHAR2_TABLE_200
1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1577: , p13_a24 JTF_VARCHAR2_TABLE_100
1578: , p13_a25 JTF_VARCHAR2_TABLE_100
1579: , p13_a26 JTF_VARCHAR2_TABLE_100

Line 1577: , p13_a24 JTF_VARCHAR2_TABLE_100

1573: , p13_a20 JTF_VARCHAR2_TABLE_100
1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1577: , p13_a24 JTF_VARCHAR2_TABLE_100
1578: , p13_a25 JTF_VARCHAR2_TABLE_100
1579: , p13_a26 JTF_VARCHAR2_TABLE_100
1580: )
1581:

Line 1578: , p13_a25 JTF_VARCHAR2_TABLE_100

1574: , p13_a21 JTF_VARCHAR2_TABLE_200
1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1577: , p13_a24 JTF_VARCHAR2_TABLE_100
1578: , p13_a25 JTF_VARCHAR2_TABLE_100
1579: , p13_a26 JTF_VARCHAR2_TABLE_100
1580: )
1581:
1582: as

Line 1579: , p13_a26 JTF_VARCHAR2_TABLE_100

1575: , p13_a22 JTF_VARCHAR2_TABLE_100
1576: , p13_a23 JTF_VARCHAR2_TABLE_200
1577: , p13_a24 JTF_VARCHAR2_TABLE_100
1578: , p13_a25 JTF_VARCHAR2_TABLE_100
1579: , p13_a26 JTF_VARCHAR2_TABLE_100
1580: )
1581:
1582: as
1583: ddp_kle_tbl okl_mass_rebook_pvt.kle_tbl_type;

Line 1679: , p5_a7 JTF_VARCHAR2_TABLE_100

1675: , p5_a3 JTF_VARCHAR2_TABLE_200
1676: , p5_a4 JTF_VARCHAR2_TABLE_600
1677: , p5_a5 JTF_NUMBER_TABLE
1678: , p5_a6 JTF_NUMBER_TABLE
1679: , p5_a7 JTF_VARCHAR2_TABLE_100
1680: , p5_a8 JTF_VARCHAR2_TABLE_100
1681: , p5_a9 JTF_VARCHAR2_TABLE_100
1682: , p5_a10 JTF_VARCHAR2_TABLE_500
1683: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1680: , p5_a8 JTF_VARCHAR2_TABLE_100

1676: , p5_a4 JTF_VARCHAR2_TABLE_600
1677: , p5_a5 JTF_NUMBER_TABLE
1678: , p5_a6 JTF_NUMBER_TABLE
1679: , p5_a7 JTF_VARCHAR2_TABLE_100
1680: , p5_a8 JTF_VARCHAR2_TABLE_100
1681: , p5_a9 JTF_VARCHAR2_TABLE_100
1682: , p5_a10 JTF_VARCHAR2_TABLE_500
1683: , p5_a11 JTF_VARCHAR2_TABLE_500
1684: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1681: , p5_a9 JTF_VARCHAR2_TABLE_100

1677: , p5_a5 JTF_NUMBER_TABLE
1678: , p5_a6 JTF_NUMBER_TABLE
1679: , p5_a7 JTF_VARCHAR2_TABLE_100
1680: , p5_a8 JTF_VARCHAR2_TABLE_100
1681: , p5_a9 JTF_VARCHAR2_TABLE_100
1682: , p5_a10 JTF_VARCHAR2_TABLE_500
1683: , p5_a11 JTF_VARCHAR2_TABLE_500
1684: , p5_a12 JTF_VARCHAR2_TABLE_500
1685: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 1710: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

1706: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1707: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1708: , p6_a5 out nocopy JTF_NUMBER_TABLE
1709: , p6_a6 out nocopy JTF_NUMBER_TABLE
1710: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1714: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 1711: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

1707: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1708: , p6_a5 out nocopy JTF_NUMBER_TABLE
1709: , p6_a6 out nocopy JTF_NUMBER_TABLE
1710: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1714: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1715: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 1712: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

1708: , p6_a5 out nocopy JTF_NUMBER_TABLE
1709: , p6_a6 out nocopy JTF_NUMBER_TABLE
1710: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1712: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1713: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1714: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1715: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1716: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 1841: , p6_a3 JTF_VARCHAR2_TABLE_100

1837: , p_request_name VARCHAR2
1838: , p6_a0 JTF_NUMBER_TABLE
1839: , p6_a1 JTF_VARCHAR2_TABLE_600
1840: , p6_a2 JTF_NUMBER_TABLE
1841: , p6_a3 JTF_VARCHAR2_TABLE_100
1842: , p6_a4 JTF_VARCHAR2_TABLE_100
1843: , p6_a5 JTF_VARCHAR2_TABLE_100
1844: , p6_a6 JTF_VARCHAR2_TABLE_600
1845: , p6_a7 JTF_VARCHAR2_TABLE_600

Line 1842: , p6_a4 JTF_VARCHAR2_TABLE_100

1838: , p6_a0 JTF_NUMBER_TABLE
1839: , p6_a1 JTF_VARCHAR2_TABLE_600
1840: , p6_a2 JTF_NUMBER_TABLE
1841: , p6_a3 JTF_VARCHAR2_TABLE_100
1842: , p6_a4 JTF_VARCHAR2_TABLE_100
1843: , p6_a5 JTF_VARCHAR2_TABLE_100
1844: , p6_a6 JTF_VARCHAR2_TABLE_600
1845: , p6_a7 JTF_VARCHAR2_TABLE_600
1846: , p6_a8 JTF_VARCHAR2_TABLE_600

Line 1843: , p6_a5 JTF_VARCHAR2_TABLE_100

1839: , p6_a1 JTF_VARCHAR2_TABLE_600
1840: , p6_a2 JTF_NUMBER_TABLE
1841: , p6_a3 JTF_VARCHAR2_TABLE_100
1842: , p6_a4 JTF_VARCHAR2_TABLE_100
1843: , p6_a5 JTF_VARCHAR2_TABLE_100
1844: , p6_a6 JTF_VARCHAR2_TABLE_600
1845: , p6_a7 JTF_VARCHAR2_TABLE_600
1846: , p6_a8 JTF_VARCHAR2_TABLE_600
1847: , p6_a9 JTF_VARCHAR2_TABLE_2000

Line 1848: , p6_a10 JTF_VARCHAR2_TABLE_100

1844: , p6_a6 JTF_VARCHAR2_TABLE_600
1845: , p6_a7 JTF_VARCHAR2_TABLE_600
1846: , p6_a8 JTF_VARCHAR2_TABLE_600
1847: , p6_a9 JTF_VARCHAR2_TABLE_2000
1848: , p6_a10 JTF_VARCHAR2_TABLE_100
1849: , p6_a11 JTF_VARCHAR2_TABLE_100
1850: , p6_a12 JTF_VARCHAR2_TABLE_500
1851: , p6_a13 JTF_VARCHAR2_TABLE_500
1852: , p6_a14 JTF_VARCHAR2_TABLE_500

Line 1849: , p6_a11 JTF_VARCHAR2_TABLE_100

1845: , p6_a7 JTF_VARCHAR2_TABLE_600
1846: , p6_a8 JTF_VARCHAR2_TABLE_600
1847: , p6_a9 JTF_VARCHAR2_TABLE_2000
1848: , p6_a10 JTF_VARCHAR2_TABLE_100
1849: , p6_a11 JTF_VARCHAR2_TABLE_100
1850: , p6_a12 JTF_VARCHAR2_TABLE_500
1851: , p6_a13 JTF_VARCHAR2_TABLE_500
1852: , p6_a14 JTF_VARCHAR2_TABLE_500
1853: , p6_a15 JTF_VARCHAR2_TABLE_500

Line 1873: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

1869: , p6_a31 JTF_NUMBER_TABLE
1870: , p7_a0 out nocopy JTF_NUMBER_TABLE
1871: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
1872: , p7_a2 out nocopy JTF_NUMBER_TABLE
1873: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1875: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1876: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_600
1877: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_600

Line 1874: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

1870: , p7_a0 out nocopy JTF_NUMBER_TABLE
1871: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
1872: , p7_a2 out nocopy JTF_NUMBER_TABLE
1873: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1875: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1876: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_600
1877: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_600
1878: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_600

Line 1875: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

1871: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600
1872: , p7_a2 out nocopy JTF_NUMBER_TABLE
1873: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1874: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1875: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1876: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_600
1877: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_600
1878: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_600
1879: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1880: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

1876: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_600
1877: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_600
1878: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_600
1879: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1881: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
1882: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_500
1883: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_500
1884: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 1881: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100

1877: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_600
1878: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_600
1879: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1881: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
1882: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_500
1883: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_500
1884: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_500
1885: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_500