APPS.OKL_MASS_REBOOK_PVT_W dependencies on JTF_NUMBER_TABLE

Line 25: procedure rosetta_table_copy_in_p31(t out nocopy okl_mass_rebook_pvt.crit_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
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

Line 54: procedure rosetta_table_copy_out_p31(t okl_mass_rebook_pvt.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

50: end loop;
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

Line 64: a0 := JTF_NUMBER_TABLE();

60: ) as
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();

Line 71: a0 := JTF_NUMBER_TABLE();

67: a3 := JTF_VARCHAR2_TABLE_200();
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();

Line 103: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE

99: end if;
100: end if;
101: end rosetta_table_copy_out_p31;
102:
103: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_VARCHAR2_TABLE_200
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_VARCHAR2_TABLE_600
107: ) as

Line 105: , a2 JTF_NUMBER_TABLE

101: end rosetta_table_copy_out_p31;
102:
103: procedure rosetta_table_copy_in_p33(t out nocopy okl_mass_rebook_pvt.rbk_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_VARCHAR2_TABLE_200
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_VARCHAR2_TABLE_600
107: ) as
108: ddindx binary_integer; indx binary_integer;
109: begin

Line 128: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

124: end loop;
125: end if;
126: end if;
127: end rosetta_table_copy_in_p33;
128: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_200
130: , a2 out nocopy JTF_NUMBER_TABLE
131: , a3 out nocopy JTF_VARCHAR2_TABLE_600
132: ) as

Line 130: , a2 out nocopy JTF_NUMBER_TABLE

126: end if;
127: end rosetta_table_copy_in_p33;
128: procedure rosetta_table_copy_out_p33(t okl_mass_rebook_pvt.rbk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_VARCHAR2_TABLE_200
130: , a2 out nocopy JTF_NUMBER_TABLE
131: , a3 out nocopy JTF_VARCHAR2_TABLE_600
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin

Line 136: a0 := JTF_NUMBER_TABLE();

132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_600();
140: else

Line 138: a2 := JTF_NUMBER_TABLE();

134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_600();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_200();

Line 141: a0 := JTF_NUMBER_TABLE();

137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_600();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_200();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_VARCHAR2_TABLE_600();
145: if t.count > 0 then

Line 143: a2 := JTF_NUMBER_TABLE();

139: a3 := JTF_VARCHAR2_TABLE_600();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_200();
143: a2 := JTF_NUMBER_TABLE();
144: a3 := JTF_VARCHAR2_TABLE_600();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);

Line 167: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE

163: end if;
164: end if;
165: end rosetta_table_copy_out_p33;
166:
167: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE
168: , a1 JTF_NUMBER_TABLE
169: , a2 JTF_VARCHAR2_TABLE_500
170: , a3 JTF_VARCHAR2_TABLE_500
171: , a4 JTF_VARCHAR2_TABLE_500

Line 168: , a1 JTF_NUMBER_TABLE

164: end if;
165: end rosetta_table_copy_out_p33;
166:
167: procedure rosetta_table_copy_in_p35(t out nocopy okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 JTF_NUMBER_TABLE
168: , a1 JTF_NUMBER_TABLE
169: , a2 JTF_VARCHAR2_TABLE_500
170: , a3 JTF_VARCHAR2_TABLE_500
171: , a4 JTF_VARCHAR2_TABLE_500
172: , a5 JTF_VARCHAR2_TABLE_500

Line 238: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

234: end loop;
235: end if;
236: end if;
237: end rosetta_table_copy_in_p35;
238: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
239: , a1 out nocopy JTF_NUMBER_TABLE
240: , a2 out nocopy JTF_VARCHAR2_TABLE_500
241: , a3 out nocopy JTF_VARCHAR2_TABLE_500
242: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 239: , a1 out nocopy JTF_NUMBER_TABLE

235: end if;
236: end if;
237: end rosetta_table_copy_in_p35;
238: procedure rosetta_table_copy_out_p35(t okl_mass_rebook_pvt.strm_lalevl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
239: , a1 out nocopy JTF_NUMBER_TABLE
240: , a2 out nocopy JTF_VARCHAR2_TABLE_500
241: , a3 out nocopy JTF_VARCHAR2_TABLE_500
242: , a4 out nocopy JTF_VARCHAR2_TABLE_500
243: , a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 269: a0 := JTF_NUMBER_TABLE();

265: ) as
266: ddindx binary_integer; indx binary_integer;
267: begin
268: if t is null or t.count = 0 then
269: a0 := JTF_NUMBER_TABLE();
270: a1 := JTF_NUMBER_TABLE();
271: a2 := JTF_VARCHAR2_TABLE_500();
272: a3 := JTF_VARCHAR2_TABLE_500();
273: a4 := JTF_VARCHAR2_TABLE_500();

Line 270: a1 := JTF_NUMBER_TABLE();

266: ddindx binary_integer; indx binary_integer;
267: begin
268: if t is null or t.count = 0 then
269: a0 := JTF_NUMBER_TABLE();
270: a1 := JTF_NUMBER_TABLE();
271: a2 := JTF_VARCHAR2_TABLE_500();
272: a3 := JTF_VARCHAR2_TABLE_500();
273: a4 := JTF_VARCHAR2_TABLE_500();
274: a5 := JTF_VARCHAR2_TABLE_500();

Line 297: a0 := JTF_NUMBER_TABLE();

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();
300: a3 := JTF_VARCHAR2_TABLE_500();
301: a4 := JTF_VARCHAR2_TABLE_500();

Line 298: a1 := JTF_NUMBER_TABLE();

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();
300: a3 := JTF_VARCHAR2_TABLE_500();
301: a4 := JTF_VARCHAR2_TABLE_500();
302: a5 := JTF_VARCHAR2_TABLE_500();

Line 392: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE

388: end if;
389: end if;
390: end rosetta_table_copy_out_p35;
391:
392: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
393: , a1 JTF_NUMBER_TABLE
394: ) as
395: ddindx binary_integer; indx binary_integer;
396: begin

Line 393: , a1 JTF_NUMBER_TABLE

389: end if;
390: end rosetta_table_copy_out_p35;
391:
392: procedure rosetta_table_copy_in_p37(t out nocopy okl_mass_rebook_pvt.strm_trx_tbl_type, a0 JTF_NUMBER_TABLE
393: , a1 JTF_NUMBER_TABLE
394: ) as
395: ddindx binary_integer; indx binary_integer;
396: begin
397: if a0 is not null and a0.count > 0 then

Line 413: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

409: end loop;
410: end if;
411: end if;
412: end rosetta_table_copy_in_p37;
413: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
414: , a1 out nocopy JTF_NUMBER_TABLE
415: ) as
416: ddindx binary_integer; indx binary_integer;
417: begin

Line 414: , a1 out nocopy JTF_NUMBER_TABLE

410: end if;
411: end if;
412: end rosetta_table_copy_in_p37;
413: procedure rosetta_table_copy_out_p37(t okl_mass_rebook_pvt.strm_trx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
414: , a1 out nocopy JTF_NUMBER_TABLE
415: ) as
416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then

Line 419: a0 := JTF_NUMBER_TABLE();

415: ) as
416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: else
422: a0 := JTF_NUMBER_TABLE();
423: a1 := JTF_NUMBER_TABLE();

Line 420: a1 := JTF_NUMBER_TABLE();

416: ddindx binary_integer; indx binary_integer;
417: begin
418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: else
422: a0 := JTF_NUMBER_TABLE();
423: a1 := JTF_NUMBER_TABLE();
424: if t.count > 0 then

Line 422: a0 := JTF_NUMBER_TABLE();

418: if t is null or t.count = 0 then
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: else
422: a0 := JTF_NUMBER_TABLE();
423: a1 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
425: a0.extend(t.count);
426: a1.extend(t.count);

Line 423: a1 := JTF_NUMBER_TABLE();

419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: else
422: a0 := JTF_NUMBER_TABLE();
423: a1 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
425: a0.extend(t.count);
426: a1.extend(t.count);
427: ddindx := t.first;

Line 442: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE

438: end if;
439: end if;
440: end rosetta_table_copy_out_p37;
441:
442: procedure rosetta_table_copy_in_p39(t out nocopy okl_mass_rebook_pvt.kle_tbl_type, a0 JTF_NUMBER_TABLE
443: ) as
444: ddindx binary_integer; indx binary_integer;
445: begin
446: if a0 is not null and a0.count > 0 then

Line 461: procedure rosetta_table_copy_out_p39(t okl_mass_rebook_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

457: end loop;
458: end if;
459: end if;
460: end rosetta_table_copy_in_p39;
461: procedure rosetta_table_copy_out_p39(t okl_mass_rebook_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin
465: if t is null or t.count = 0 then

Line 466: a0 := JTF_NUMBER_TABLE();

462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin
465: if t is null or t.count = 0 then
466: a0 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: if t.count > 0 then
470: a0.extend(t.count);

Line 468: a0 := JTF_NUMBER_TABLE();

464: begin
465: if t is null or t.count = 0 then
466: a0 := JTF_NUMBER_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: if t.count > 0 then
470: a0.extend(t.count);
471: ddindx := t.first;
472: indx := 1;

Line 491: , p6_a0 JTF_NUMBER_TABLE

487: , x_return_status out nocopy VARCHAR2
488: , x_msg_count out nocopy NUMBER
489: , x_msg_data out nocopy VARCHAR2
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

Line 493: , p6_a2 JTF_NUMBER_TABLE

489: , x_msg_data out nocopy VARCHAR2
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

Line 518: , p6_a27 JTF_NUMBER_TABLE

514: , p6_a23 JTF_VARCHAR2_TABLE_500
515: , p6_a24 JTF_VARCHAR2_TABLE_500
516: , p6_a25 JTF_VARCHAR2_TABLE_500
517: , p6_a26 JTF_VARCHAR2_TABLE_500
518: , p6_a27 JTF_NUMBER_TABLE
519: , p6_a28 JTF_DATE_TABLE
520: , p6_a29 JTF_NUMBER_TABLE
521: , p6_a30 JTF_DATE_TABLE
522: , p6_a31 JTF_NUMBER_TABLE

Line 520: , p6_a29 JTF_NUMBER_TABLE

516: , p6_a25 JTF_VARCHAR2_TABLE_500
517: , p6_a26 JTF_VARCHAR2_TABLE_500
518: , p6_a27 JTF_NUMBER_TABLE
519: , p6_a28 JTF_DATE_TABLE
520: , p6_a29 JTF_NUMBER_TABLE
521: , p6_a30 JTF_DATE_TABLE
522: , p6_a31 JTF_NUMBER_TABLE
523: , p7_a0 out nocopy JTF_NUMBER_TABLE
524: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 522: , p6_a31 JTF_NUMBER_TABLE

518: , p6_a27 JTF_NUMBER_TABLE
519: , p6_a28 JTF_DATE_TABLE
520: , p6_a29 JTF_NUMBER_TABLE
521: , p6_a30 JTF_DATE_TABLE
522: , p6_a31 JTF_NUMBER_TABLE
523: , p7_a0 out nocopy JTF_NUMBER_TABLE
524: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
525: , p7_a2 out nocopy JTF_NUMBER_TABLE
526: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 523: , p7_a0 out nocopy JTF_NUMBER_TABLE

519: , p6_a28 JTF_DATE_TABLE
520: , p6_a29 JTF_NUMBER_TABLE
521: , p6_a30 JTF_DATE_TABLE
522: , p6_a31 JTF_NUMBER_TABLE
523: , p7_a0 out nocopy JTF_NUMBER_TABLE
524: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
525: , p7_a2 out nocopy JTF_NUMBER_TABLE
526: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
527: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 525: , p7_a2 out nocopy JTF_NUMBER_TABLE

521: , p6_a30 JTF_DATE_TABLE
522: , p6_a31 JTF_NUMBER_TABLE
523: , p7_a0 out nocopy JTF_NUMBER_TABLE
524: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
525: , p7_a2 out nocopy JTF_NUMBER_TABLE
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

Line 528: , p7_a5 out nocopy JTF_NUMBER_TABLE

524: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
525: , p7_a2 out nocopy JTF_NUMBER_TABLE
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

Line 529: , p7_a6 out nocopy JTF_NUMBER_TABLE

525: , p7_a2 out nocopy JTF_NUMBER_TABLE
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

Line 548: , p7_a25 out nocopy JTF_NUMBER_TABLE

544: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
545: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
546: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
547: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
548: , p7_a25 out nocopy JTF_NUMBER_TABLE
549: , p7_a26 out nocopy JTF_DATE_TABLE
550: , p7_a27 out nocopy JTF_NUMBER_TABLE
551: , p7_a28 out nocopy JTF_DATE_TABLE
552: , p7_a29 out nocopy JTF_NUMBER_TABLE

Line 550: , p7_a27 out nocopy JTF_NUMBER_TABLE

546: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
547: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
548: , p7_a25 out nocopy JTF_NUMBER_TABLE
549: , p7_a26 out nocopy JTF_DATE_TABLE
550: , p7_a27 out nocopy JTF_NUMBER_TABLE
551: , p7_a28 out nocopy JTF_DATE_TABLE
552: , p7_a29 out nocopy JTF_NUMBER_TABLE
553: , p7_a30 out nocopy JTF_DATE_TABLE
554: , x_rbk_count out nocopy NUMBER

Line 552: , p7_a29 out nocopy JTF_NUMBER_TABLE

548: , p7_a25 out nocopy JTF_NUMBER_TABLE
549: , p7_a26 out nocopy JTF_DATE_TABLE
550: , p7_a27 out nocopy JTF_NUMBER_TABLE
551: , p7_a28 out nocopy JTF_DATE_TABLE
552: , p7_a29 out nocopy JTF_NUMBER_TABLE
553: , p7_a30 out nocopy JTF_DATE_TABLE
554: , x_rbk_count out nocopy NUMBER
555: )
556:

Line 667: , p7_a0 JTF_NUMBER_TABLE

663: , x_msg_count out nocopy NUMBER
664: , x_msg_data out nocopy VARCHAR2
665: , p_request_name VARCHAR2
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

Line 669: , p7_a2 JTF_NUMBER_TABLE

665: , p_request_name VARCHAR2
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

Line 694: , p7_a27 JTF_NUMBER_TABLE

690: , p7_a23 JTF_VARCHAR2_TABLE_500
691: , p7_a24 JTF_VARCHAR2_TABLE_500
692: , p7_a25 JTF_VARCHAR2_TABLE_500
693: , p7_a26 JTF_VARCHAR2_TABLE_500
694: , p7_a27 JTF_NUMBER_TABLE
695: , p7_a28 JTF_DATE_TABLE
696: , p7_a29 JTF_NUMBER_TABLE
697: , p7_a30 JTF_DATE_TABLE
698: , p7_a31 JTF_NUMBER_TABLE

Line 696: , p7_a29 JTF_NUMBER_TABLE

692: , p7_a25 JTF_VARCHAR2_TABLE_500
693: , p7_a26 JTF_VARCHAR2_TABLE_500
694: , p7_a27 JTF_NUMBER_TABLE
695: , p7_a28 JTF_DATE_TABLE
696: , p7_a29 JTF_NUMBER_TABLE
697: , p7_a30 JTF_DATE_TABLE
698: , p7_a31 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy JTF_NUMBER_TABLE
700: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 698: , p7_a31 JTF_NUMBER_TABLE

694: , p7_a27 JTF_NUMBER_TABLE
695: , p7_a28 JTF_DATE_TABLE
696: , p7_a29 JTF_NUMBER_TABLE
697: , p7_a30 JTF_DATE_TABLE
698: , p7_a31 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy JTF_NUMBER_TABLE
700: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
701: , p8_a2 out nocopy JTF_NUMBER_TABLE
702: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 699: , p8_a0 out nocopy JTF_NUMBER_TABLE

695: , p7_a28 JTF_DATE_TABLE
696: , p7_a29 JTF_NUMBER_TABLE
697: , p7_a30 JTF_DATE_TABLE
698: , p7_a31 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy JTF_NUMBER_TABLE
700: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
701: , p8_a2 out nocopy JTF_NUMBER_TABLE
702: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
703: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 701: , p8_a2 out nocopy JTF_NUMBER_TABLE

697: , p7_a30 JTF_DATE_TABLE
698: , p7_a31 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy JTF_NUMBER_TABLE
700: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
701: , p8_a2 out nocopy JTF_NUMBER_TABLE
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

Line 704: , p8_a5 out nocopy JTF_NUMBER_TABLE

700: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
701: , p8_a2 out nocopy JTF_NUMBER_TABLE
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

Line 705: , p8_a6 out nocopy JTF_NUMBER_TABLE

701: , p8_a2 out nocopy JTF_NUMBER_TABLE
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

Line 724: , p8_a25 out nocopy JTF_NUMBER_TABLE

720: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
721: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_500
722: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
723: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
724: , p8_a25 out nocopy JTF_NUMBER_TABLE
725: , p8_a26 out nocopy JTF_DATE_TABLE
726: , p8_a27 out nocopy JTF_NUMBER_TABLE
727: , p8_a28 out nocopy JTF_DATE_TABLE
728: , p8_a29 out nocopy JTF_NUMBER_TABLE

Line 726: , p8_a27 out nocopy JTF_NUMBER_TABLE

722: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
723: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
724: , p8_a25 out nocopy JTF_NUMBER_TABLE
725: , p8_a26 out nocopy JTF_DATE_TABLE
726: , p8_a27 out nocopy JTF_NUMBER_TABLE
727: , p8_a28 out nocopy JTF_DATE_TABLE
728: , p8_a29 out nocopy JTF_NUMBER_TABLE
729: , p8_a30 out nocopy JTF_DATE_TABLE
730: , x_rbk_count out nocopy NUMBER

Line 728: , p8_a29 out nocopy JTF_NUMBER_TABLE

724: , p8_a25 out nocopy JTF_NUMBER_TABLE
725: , p8_a26 out nocopy JTF_DATE_TABLE
726: , p8_a27 out nocopy JTF_NUMBER_TABLE
727: , p8_a28 out nocopy JTF_DATE_TABLE
728: , p8_a29 out nocopy JTF_NUMBER_TABLE
729: , p8_a30 out nocopy JTF_DATE_TABLE
730: , x_rbk_count out nocopy NUMBER
731: )
732:

Line 846: , p5_a0 JTF_NUMBER_TABLE

842: , p_init_msg_list VARCHAR2
843: , x_return_status out nocopy VARCHAR2
844: , x_msg_count out nocopy NUMBER
845: , x_msg_data out nocopy VARCHAR2
846: , p5_a0 JTF_NUMBER_TABLE
847: , p5_a1 JTF_VARCHAR2_TABLE_200
848: , p5_a2 JTF_NUMBER_TABLE
849: , p5_a3 JTF_VARCHAR2_TABLE_600
850: , p_deprn_method_code VARCHAR2

Line 848: , p5_a2 JTF_NUMBER_TABLE

844: , x_msg_count out nocopy NUMBER
845: , x_msg_data out nocopy VARCHAR2
846: , p5_a0 JTF_NUMBER_TABLE
847: , p5_a1 JTF_VARCHAR2_TABLE_200
848: , p5_a2 JTF_NUMBER_TABLE
849: , p5_a3 JTF_VARCHAR2_TABLE_600
850: , p_deprn_method_code VARCHAR2
851: , p_in_service_date date
852: , p_life_in_months NUMBER

Line 856: , p12_a0 JTF_NUMBER_TABLE

852: , p_life_in_months NUMBER
853: , p_basic_rate NUMBER
854: , p_adjusted_rate NUMBER
855: , p_residual_value NUMBER
856: , p12_a0 JTF_NUMBER_TABLE
857: , p12_a1 JTF_NUMBER_TABLE
858: , p12_a2 JTF_VARCHAR2_TABLE_500
859: , p12_a3 JTF_VARCHAR2_TABLE_500
860: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 857: , p12_a1 JTF_NUMBER_TABLE

853: , p_basic_rate NUMBER
854: , p_adjusted_rate NUMBER
855: , p_residual_value NUMBER
856: , p12_a0 JTF_NUMBER_TABLE
857: , p12_a1 JTF_NUMBER_TABLE
858: , p12_a2 JTF_VARCHAR2_TABLE_500
859: , p12_a3 JTF_VARCHAR2_TABLE_500
860: , p12_a4 JTF_VARCHAR2_TABLE_500
861: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 975: , p5_a0 JTF_NUMBER_TABLE

971: , p_init_msg_list VARCHAR2
972: , x_return_status out nocopy VARCHAR2
973: , x_msg_count out nocopy NUMBER
974: , x_msg_data out nocopy VARCHAR2
975: , p5_a0 JTF_NUMBER_TABLE
976: , p5_a1 JTF_VARCHAR2_TABLE_200
977: , p5_a2 JTF_NUMBER_TABLE
978: , p5_a3 JTF_VARCHAR2_TABLE_600
979: , p_deprn_method_code VARCHAR2

Line 977: , p5_a2 JTF_NUMBER_TABLE

973: , x_msg_count out nocopy NUMBER
974: , x_msg_data out nocopy VARCHAR2
975: , p5_a0 JTF_NUMBER_TABLE
976: , p5_a1 JTF_VARCHAR2_TABLE_200
977: , p5_a2 JTF_NUMBER_TABLE
978: , p5_a3 JTF_VARCHAR2_TABLE_600
979: , p_deprn_method_code VARCHAR2
980: , p_in_service_date date
981: , p_life_in_months NUMBER

Line 985: , p12_a0 JTF_NUMBER_TABLE

981: , p_life_in_months NUMBER
982: , p_basic_rate NUMBER
983: , p_adjusted_rate NUMBER
984: , p_residual_value NUMBER
985: , p12_a0 JTF_NUMBER_TABLE
986: , p12_a1 JTF_NUMBER_TABLE
987: , p12_a2 JTF_VARCHAR2_TABLE_500
988: , p12_a3 JTF_VARCHAR2_TABLE_500
989: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 986: , p12_a1 JTF_NUMBER_TABLE

982: , p_basic_rate NUMBER
983: , p_adjusted_rate NUMBER
984: , p_residual_value NUMBER
985: , p12_a0 JTF_NUMBER_TABLE
986: , p12_a1 JTF_NUMBER_TABLE
987: , p12_a2 JTF_VARCHAR2_TABLE_500
988: , p12_a3 JTF_VARCHAR2_TABLE_500
989: , p12_a4 JTF_VARCHAR2_TABLE_500
990: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 1012: , p13_a0 out nocopy JTF_NUMBER_TABLE

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:
1016: as

Line 1013: , p13_a1 out nocopy JTF_NUMBER_TABLE

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:
1016: as
1017: ddp_rbk_tbl okl_mass_rebook_pvt.rbk_tbl_type;

Line 1113: , p5_a0 JTF_NUMBER_TABLE

1109: , p_init_msg_list VARCHAR2
1110: , x_return_status out nocopy VARCHAR2
1111: , x_msg_count out nocopy NUMBER
1112: , x_msg_data out nocopy VARCHAR2
1113: , p5_a0 JTF_NUMBER_TABLE
1114: , p5_a1 JTF_VARCHAR2_TABLE_200
1115: , p5_a2 JTF_NUMBER_TABLE
1116: , p5_a3 JTF_VARCHAR2_TABLE_600
1117: , p_deprn_method_code VARCHAR2

Line 1115: , p5_a2 JTF_NUMBER_TABLE

1111: , x_msg_count out nocopy NUMBER
1112: , x_msg_data out nocopy VARCHAR2
1113: , p5_a0 JTF_NUMBER_TABLE
1114: , p5_a1 JTF_VARCHAR2_TABLE_200
1115: , p5_a2 JTF_NUMBER_TABLE
1116: , p5_a3 JTF_VARCHAR2_TABLE_600
1117: , p_deprn_method_code VARCHAR2
1118: , p_in_service_date date
1119: , p_life_in_months NUMBER

Line 1123: , p12_a0 JTF_NUMBER_TABLE

1119: , p_life_in_months NUMBER
1120: , p_basic_rate NUMBER
1121: , p_adjusted_rate NUMBER
1122: , p_residual_value NUMBER
1123: , p12_a0 JTF_NUMBER_TABLE
1124: , p12_a1 JTF_NUMBER_TABLE
1125: , p12_a2 JTF_VARCHAR2_TABLE_500
1126: , p12_a3 JTF_VARCHAR2_TABLE_500
1127: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 1124: , p12_a1 JTF_NUMBER_TABLE

1120: , p_basic_rate NUMBER
1121: , p_adjusted_rate NUMBER
1122: , p_residual_value NUMBER
1123: , p12_a0 JTF_NUMBER_TABLE
1124: , p12_a1 JTF_NUMBER_TABLE
1125: , p12_a2 JTF_VARCHAR2_TABLE_500
1126: , p12_a3 JTF_VARCHAR2_TABLE_500
1127: , p12_a4 JTF_VARCHAR2_TABLE_500
1128: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 1151: , p14_a0 out nocopy JTF_NUMBER_TABLE

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: )
1154:
1155: as

Line 1152: , p14_a1 out nocopy JTF_NUMBER_TABLE

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: )
1154:
1155: as
1156: ddp_rbk_tbl okl_mass_rebook_pvt.rbk_tbl_type;

Line 1257: , p5_a0 JTF_NUMBER_TABLE

1253: , p_init_msg_list VARCHAR2
1254: , x_return_status out nocopy VARCHAR2
1255: , x_msg_count out nocopy NUMBER
1256: , x_msg_data out nocopy VARCHAR2
1257: , p5_a0 JTF_NUMBER_TABLE
1258: , p5_a1 JTF_VARCHAR2_TABLE_200
1259: , p5_a2 JTF_NUMBER_TABLE
1260: , p5_a3 JTF_VARCHAR2_TABLE_600
1261: , p_deprn_method_code VARCHAR2

Line 1259: , p5_a2 JTF_NUMBER_TABLE

1255: , x_msg_count out nocopy NUMBER
1256: , x_msg_data out nocopy VARCHAR2
1257: , p5_a0 JTF_NUMBER_TABLE
1258: , p5_a1 JTF_VARCHAR2_TABLE_200
1259: , p5_a2 JTF_NUMBER_TABLE
1260: , p5_a3 JTF_VARCHAR2_TABLE_600
1261: , p_deprn_method_code VARCHAR2
1262: , p_in_service_date date
1263: , p_life_in_months NUMBER

Line 1267: , p12_a0 JTF_NUMBER_TABLE

1263: , p_life_in_months NUMBER
1264: , p_basic_rate NUMBER
1265: , p_adjusted_rate NUMBER
1266: , p_residual_value NUMBER
1267: , p12_a0 JTF_NUMBER_TABLE
1268: , p12_a1 JTF_NUMBER_TABLE
1269: , p12_a2 JTF_VARCHAR2_TABLE_500
1270: , p12_a3 JTF_VARCHAR2_TABLE_500
1271: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 1268: , p12_a1 JTF_NUMBER_TABLE

1264: , p_basic_rate NUMBER
1265: , p_adjusted_rate NUMBER
1266: , p_residual_value NUMBER
1267: , p12_a0 JTF_NUMBER_TABLE
1268: , p12_a1 JTF_NUMBER_TABLE
1269: , p12_a2 JTF_VARCHAR2_TABLE_500
1270: , p12_a3 JTF_VARCHAR2_TABLE_500
1271: , p12_a4 JTF_VARCHAR2_TABLE_500
1272: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 1398: , p5_a0 JTF_NUMBER_TABLE

1394: , p_init_msg_list VARCHAR2
1395: , x_return_status out nocopy VARCHAR2
1396: , x_msg_count out nocopy NUMBER
1397: , x_msg_data out nocopy VARCHAR2
1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_VARCHAR2_TABLE_200
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_600
1402: , p_deprn_method_code VARCHAR2

Line 1400: , p5_a2 JTF_NUMBER_TABLE

1396: , x_msg_count out nocopy NUMBER
1397: , x_msg_data out nocopy VARCHAR2
1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_VARCHAR2_TABLE_200
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_600
1402: , p_deprn_method_code VARCHAR2
1403: , p_in_service_date date
1404: , p_life_in_months NUMBER

Line 1408: , p12_a0 JTF_NUMBER_TABLE

1404: , p_life_in_months NUMBER
1405: , p_basic_rate NUMBER
1406: , p_adjusted_rate NUMBER
1407: , p_residual_value NUMBER
1408: , p12_a0 JTF_NUMBER_TABLE
1409: , p12_a1 JTF_NUMBER_TABLE
1410: , p12_a2 JTF_VARCHAR2_TABLE_500
1411: , p12_a3 JTF_VARCHAR2_TABLE_500
1412: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 1409: , p12_a1 JTF_NUMBER_TABLE

1405: , p_basic_rate NUMBER
1406: , p_adjusted_rate NUMBER
1407: , p_residual_value NUMBER
1408: , p12_a0 JTF_NUMBER_TABLE
1409: , p12_a1 JTF_NUMBER_TABLE
1410: , p12_a2 JTF_VARCHAR2_TABLE_500
1411: , p12_a3 JTF_VARCHAR2_TABLE_500
1412: , p12_a4 JTF_VARCHAR2_TABLE_500
1413: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 1546: , p6_a0 JTF_NUMBER_TABLE

1542: , x_return_status out nocopy VARCHAR2
1543: , x_msg_count out nocopy NUMBER
1544: , x_msg_data out nocopy VARCHAR2
1545: , p_chr_id NUMBER
1546: , p6_a0 JTF_NUMBER_TABLE
1547: , p_source_trx_id NUMBER
1548: , p_source_trx_type VARCHAR2
1549: , p_transaction_date date
1550: , x_mass_rebook_trx_id out nocopy NUMBER

Line 1553: , p13_a0 JTF_NUMBER_TABLE

1549: , p_transaction_date date
1550: , x_mass_rebook_trx_id out nocopy NUMBER
1551: , p_ppd_amount NUMBER
1552: , p_ppd_reason_code VARCHAR2
1553: , p13_a0 JTF_NUMBER_TABLE
1554: , p13_a1 JTF_NUMBER_TABLE
1555: , p13_a2 JTF_VARCHAR2_TABLE_500
1556: , p13_a3 JTF_VARCHAR2_TABLE_500
1557: , p13_a4 JTF_VARCHAR2_TABLE_500

Line 1554: , p13_a1 JTF_NUMBER_TABLE

1550: , x_mass_rebook_trx_id out nocopy NUMBER
1551: , p_ppd_amount NUMBER
1552: , p_ppd_reason_code VARCHAR2
1553: , p13_a0 JTF_NUMBER_TABLE
1554: , p13_a1 JTF_NUMBER_TABLE
1555: , p13_a2 JTF_VARCHAR2_TABLE_500
1556: , p13_a3 JTF_VARCHAR2_TABLE_500
1557: , p13_a4 JTF_VARCHAR2_TABLE_500
1558: , p13_a5 JTF_VARCHAR2_TABLE_500

Line 1672: , p5_a0 JTF_NUMBER_TABLE

1668: , p_init_msg_list VARCHAR2
1669: , x_return_status out nocopy VARCHAR2
1670: , x_msg_count out nocopy NUMBER
1671: , x_msg_data out nocopy VARCHAR2
1672: , p5_a0 JTF_NUMBER_TABLE
1673: , p5_a1 JTF_VARCHAR2_TABLE_200
1674: , p5_a2 JTF_NUMBER_TABLE
1675: , p5_a3 JTF_VARCHAR2_TABLE_200
1676: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 1674: , p5_a2 JTF_NUMBER_TABLE

1670: , x_msg_count out nocopy NUMBER
1671: , x_msg_data out nocopy VARCHAR2
1672: , p5_a0 JTF_NUMBER_TABLE
1673: , p5_a1 JTF_VARCHAR2_TABLE_200
1674: , p5_a2 JTF_NUMBER_TABLE
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

Line 1677: , p5_a5 JTF_NUMBER_TABLE

1673: , p5_a1 JTF_VARCHAR2_TABLE_200
1674: , p5_a2 JTF_NUMBER_TABLE
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

Line 1678: , p5_a6 JTF_NUMBER_TABLE

1674: , p5_a2 JTF_NUMBER_TABLE
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

Line 1697: , p5_a25 JTF_NUMBER_TABLE

1693: , p5_a21 JTF_VARCHAR2_TABLE_500
1694: , p5_a22 JTF_VARCHAR2_TABLE_500
1695: , p5_a23 JTF_VARCHAR2_TABLE_500
1696: , p5_a24 JTF_VARCHAR2_TABLE_500
1697: , p5_a25 JTF_NUMBER_TABLE
1698: , p5_a26 JTF_DATE_TABLE
1699: , p5_a27 JTF_NUMBER_TABLE
1700: , p5_a28 JTF_DATE_TABLE
1701: , p5_a29 JTF_NUMBER_TABLE

Line 1699: , p5_a27 JTF_NUMBER_TABLE

1695: , p5_a23 JTF_VARCHAR2_TABLE_500
1696: , p5_a24 JTF_VARCHAR2_TABLE_500
1697: , p5_a25 JTF_NUMBER_TABLE
1698: , p5_a26 JTF_DATE_TABLE
1699: , p5_a27 JTF_NUMBER_TABLE
1700: , p5_a28 JTF_DATE_TABLE
1701: , p5_a29 JTF_NUMBER_TABLE
1702: , p5_a30 JTF_DATE_TABLE
1703: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1701: , p5_a29 JTF_NUMBER_TABLE

1697: , p5_a25 JTF_NUMBER_TABLE
1698: , p5_a26 JTF_DATE_TABLE
1699: , p5_a27 JTF_NUMBER_TABLE
1700: , p5_a28 JTF_DATE_TABLE
1701: , p5_a29 JTF_NUMBER_TABLE
1702: , p5_a30 JTF_DATE_TABLE
1703: , p6_a0 out nocopy JTF_NUMBER_TABLE
1704: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1705: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 1703: , p6_a0 out nocopy JTF_NUMBER_TABLE

1699: , p5_a27 JTF_NUMBER_TABLE
1700: , p5_a28 JTF_DATE_TABLE
1701: , p5_a29 JTF_NUMBER_TABLE
1702: , p5_a30 JTF_DATE_TABLE
1703: , p6_a0 out nocopy JTF_NUMBER_TABLE
1704: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1705: , p6_a2 out nocopy JTF_NUMBER_TABLE
1706: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1707: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 1705: , p6_a2 out nocopy JTF_NUMBER_TABLE

1701: , p5_a29 JTF_NUMBER_TABLE
1702: , p5_a30 JTF_DATE_TABLE
1703: , p6_a0 out nocopy JTF_NUMBER_TABLE
1704: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1705: , p6_a2 out nocopy JTF_NUMBER_TABLE
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

Line 1708: , p6_a5 out nocopy JTF_NUMBER_TABLE

1704: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1705: , p6_a2 out nocopy JTF_NUMBER_TABLE
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

Line 1709: , p6_a6 out nocopy JTF_NUMBER_TABLE

1705: , p6_a2 out nocopy JTF_NUMBER_TABLE
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

Line 1728: , p6_a25 out nocopy JTF_NUMBER_TABLE

1724: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1725: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1726: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1727: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1728: , p6_a25 out nocopy JTF_NUMBER_TABLE
1729: , p6_a26 out nocopy JTF_DATE_TABLE
1730: , p6_a27 out nocopy JTF_NUMBER_TABLE
1731: , p6_a28 out nocopy JTF_DATE_TABLE
1732: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 1730: , p6_a27 out nocopy JTF_NUMBER_TABLE

1726: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1727: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1728: , p6_a25 out nocopy JTF_NUMBER_TABLE
1729: , p6_a26 out nocopy JTF_DATE_TABLE
1730: , p6_a27 out nocopy JTF_NUMBER_TABLE
1731: , p6_a28 out nocopy JTF_DATE_TABLE
1732: , p6_a29 out nocopy JTF_NUMBER_TABLE
1733: , p6_a30 out nocopy JTF_DATE_TABLE
1734: )

Line 1732: , p6_a29 out nocopy JTF_NUMBER_TABLE

1728: , p6_a25 out nocopy JTF_NUMBER_TABLE
1729: , p6_a26 out nocopy JTF_DATE_TABLE
1730: , p6_a27 out nocopy JTF_NUMBER_TABLE
1731: , p6_a28 out nocopy JTF_DATE_TABLE
1732: , p6_a29 out nocopy JTF_NUMBER_TABLE
1733: , p6_a30 out nocopy JTF_DATE_TABLE
1734: )
1735:
1736: as

Line 1838: , p6_a0 JTF_NUMBER_TABLE

1834: , x_return_status out nocopy VARCHAR2
1835: , x_msg_count out nocopy NUMBER
1836: , x_msg_data out nocopy VARCHAR2
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

Line 1840: , p6_a2 JTF_NUMBER_TABLE

1836: , x_msg_data out nocopy VARCHAR2
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

Line 1865: , p6_a27 JTF_NUMBER_TABLE

1861: , p6_a23 JTF_VARCHAR2_TABLE_500
1862: , p6_a24 JTF_VARCHAR2_TABLE_500
1863: , p6_a25 JTF_VARCHAR2_TABLE_500
1864: , p6_a26 JTF_VARCHAR2_TABLE_500
1865: , p6_a27 JTF_NUMBER_TABLE
1866: , p6_a28 JTF_DATE_TABLE
1867: , p6_a29 JTF_NUMBER_TABLE
1868: , p6_a30 JTF_DATE_TABLE
1869: , p6_a31 JTF_NUMBER_TABLE

Line 1867: , p6_a29 JTF_NUMBER_TABLE

1863: , p6_a25 JTF_VARCHAR2_TABLE_500
1864: , p6_a26 JTF_VARCHAR2_TABLE_500
1865: , p6_a27 JTF_NUMBER_TABLE
1866: , p6_a28 JTF_DATE_TABLE
1867: , p6_a29 JTF_NUMBER_TABLE
1868: , p6_a30 JTF_DATE_TABLE
1869: , p6_a31 JTF_NUMBER_TABLE
1870: , p7_a0 out nocopy JTF_NUMBER_TABLE
1871: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600

Line 1869: , p6_a31 JTF_NUMBER_TABLE

1865: , p6_a27 JTF_NUMBER_TABLE
1866: , p6_a28 JTF_DATE_TABLE
1867: , p6_a29 JTF_NUMBER_TABLE
1868: , p6_a30 JTF_DATE_TABLE
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

Line 1870: , p7_a0 out nocopy JTF_NUMBER_TABLE

1866: , p6_a28 JTF_DATE_TABLE
1867: , p6_a29 JTF_NUMBER_TABLE
1868: , p6_a30 JTF_DATE_TABLE
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

Line 1872: , p7_a2 out nocopy JTF_NUMBER_TABLE

1868: , p6_a30 JTF_DATE_TABLE
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

Line 1897: , p7_a27 out nocopy JTF_NUMBER_TABLE

1893: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
1894: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
1895: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_500
1896: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_500
1897: , p7_a27 out nocopy JTF_NUMBER_TABLE
1898: , p7_a28 out nocopy JTF_DATE_TABLE
1899: , p7_a29 out nocopy JTF_NUMBER_TABLE
1900: , p7_a30 out nocopy JTF_DATE_TABLE
1901: , p7_a31 out nocopy JTF_NUMBER_TABLE

Line 1899: , p7_a29 out nocopy JTF_NUMBER_TABLE

1895: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_500
1896: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_500
1897: , p7_a27 out nocopy JTF_NUMBER_TABLE
1898: , p7_a28 out nocopy JTF_DATE_TABLE
1899: , p7_a29 out nocopy JTF_NUMBER_TABLE
1900: , p7_a30 out nocopy JTF_DATE_TABLE
1901: , p7_a31 out nocopy JTF_NUMBER_TABLE
1902: )
1903:

Line 1901: , p7_a31 out nocopy JTF_NUMBER_TABLE

1897: , p7_a27 out nocopy JTF_NUMBER_TABLE
1898: , p7_a28 out nocopy JTF_DATE_TABLE
1899: , p7_a29 out nocopy JTF_NUMBER_TABLE
1900: , p7_a30 out nocopy JTF_DATE_TABLE
1901: , p7_a31 out nocopy JTF_NUMBER_TABLE
1902: )
1903:
1904: as
1905: ddp_mrbv_tbl okl_mass_rebook_pvt.mrbv_tbl_type;