DBA Data[Home] [Help]

APPS.OKL_RULE_EXTRACT_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 82: , a3 JTF_VARCHAR2_TABLE_300

78:
79: procedure rosetta_table_copy_in_p24(t out nocopy okl_rule_extract_pvt.sc_rg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_VARCHAR2_TABLE_300
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if a0 is not null and a0.count > 0 then

Line 107: , a3 out nocopy JTF_VARCHAR2_TABLE_300

103: end rosetta_table_copy_in_p24;
104: procedure rosetta_table_copy_out_p24(t okl_rule_extract_pvt.sc_rg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
105: , a1 out nocopy JTF_VARCHAR2_TABLE_100
106: , a2 out nocopy JTF_VARCHAR2_TABLE_100
107: , a3 out nocopy JTF_VARCHAR2_TABLE_300
108: ) as
109: ddindx binary_integer; indx binary_integer;
110: begin
111: if t is null or t.count = 0 then

Line 115: a3 := JTF_VARCHAR2_TABLE_300();

111: if t is null or t.count = 0 then
112: a0 := JTF_VARCHAR2_TABLE_100();
113: a1 := JTF_VARCHAR2_TABLE_100();
114: a2 := JTF_VARCHAR2_TABLE_100();
115: a3 := JTF_VARCHAR2_TABLE_300();
116: else
117: a0 := JTF_VARCHAR2_TABLE_100();
118: a1 := JTF_VARCHAR2_TABLE_100();
119: a2 := JTF_VARCHAR2_TABLE_100();

Line 120: a3 := JTF_VARCHAR2_TABLE_300();

116: else
117: a0 := JTF_VARCHAR2_TABLE_100();
118: a1 := JTF_VARCHAR2_TABLE_100();
119: a2 := JTF_VARCHAR2_TABLE_100();
120: a3 := JTF_VARCHAR2_TABLE_300();
121: if t.count > 0 then
122: a0.extend(t.count);
123: a1.extend(t.count);
124: a2.extend(t.count);

Line 250: , a22 JTF_VARCHAR2_TABLE_300

246: , a18 JTF_VARCHAR2_TABLE_100
247: , a19 JTF_VARCHAR2_TABLE_100
248: , a20 JTF_VARCHAR2_TABLE_100
249: , a21 JTF_VARCHAR2_TABLE_100
250: , a22 JTF_VARCHAR2_TABLE_300
251: ) as
252: ddindx binary_integer; indx binary_integer;
253: begin
254: if a0 is not null and a0.count > 0 then

Line 313: , a22 out nocopy JTF_VARCHAR2_TABLE_300

309: , a18 out nocopy JTF_VARCHAR2_TABLE_100
310: , a19 out nocopy JTF_VARCHAR2_TABLE_100
311: , a20 out nocopy JTF_VARCHAR2_TABLE_100
312: , a21 out nocopy JTF_VARCHAR2_TABLE_100
313: , a22 out nocopy JTF_VARCHAR2_TABLE_300
314: ) as
315: ddindx binary_integer; indx binary_integer;
316: begin
317: if t is null or t.count = 0 then

Line 340: a22 := JTF_VARCHAR2_TABLE_300();

336: a18 := JTF_VARCHAR2_TABLE_100();
337: a19 := JTF_VARCHAR2_TABLE_100();
338: a20 := JTF_VARCHAR2_TABLE_100();
339: a21 := JTF_VARCHAR2_TABLE_100();
340: a22 := JTF_VARCHAR2_TABLE_300();
341: else
342: a0 := JTF_VARCHAR2_TABLE_100();
343: a1 := JTF_VARCHAR2_TABLE_100();
344: a2 := JTF_VARCHAR2_TABLE_100();

Line 364: a22 := JTF_VARCHAR2_TABLE_300();

360: a18 := JTF_VARCHAR2_TABLE_100();
361: a19 := JTF_VARCHAR2_TABLE_100();
362: a20 := JTF_VARCHAR2_TABLE_100();
363: a21 := JTF_VARCHAR2_TABLE_100();
364: a22 := JTF_VARCHAR2_TABLE_300();
365: if t.count > 0 then
366: a0.extend(t.count);
367: a1.extend(t.count);
368: a2.extend(t.count);

Line 447: , a22 JTF_VARCHAR2_TABLE_300

443: , a18 JTF_VARCHAR2_TABLE_100
444: , a19 JTF_VARCHAR2_TABLE_100
445: , a20 JTF_VARCHAR2_TABLE_100
446: , a21 JTF_VARCHAR2_TABLE_100
447: , a22 JTF_VARCHAR2_TABLE_300
448: , a23 JTF_VARCHAR2_TABLE_300
449: , a24 JTF_VARCHAR2_TABLE_300
450: , a25 JTF_VARCHAR2_TABLE_1000
451: , a26 JTF_VARCHAR2_TABLE_1000

Line 448: , a23 JTF_VARCHAR2_TABLE_300

444: , a19 JTF_VARCHAR2_TABLE_100
445: , a20 JTF_VARCHAR2_TABLE_100
446: , a21 JTF_VARCHAR2_TABLE_100
447: , a22 JTF_VARCHAR2_TABLE_300
448: , a23 JTF_VARCHAR2_TABLE_300
449: , a24 JTF_VARCHAR2_TABLE_300
450: , a25 JTF_VARCHAR2_TABLE_1000
451: , a26 JTF_VARCHAR2_TABLE_1000
452: , a27 JTF_VARCHAR2_TABLE_100

Line 449: , a24 JTF_VARCHAR2_TABLE_300

445: , a20 JTF_VARCHAR2_TABLE_100
446: , a21 JTF_VARCHAR2_TABLE_100
447: , a22 JTF_VARCHAR2_TABLE_300
448: , a23 JTF_VARCHAR2_TABLE_300
449: , a24 JTF_VARCHAR2_TABLE_300
450: , a25 JTF_VARCHAR2_TABLE_1000
451: , a26 JTF_VARCHAR2_TABLE_1000
452: , a27 JTF_VARCHAR2_TABLE_100
453: ) as

Line 520: , a22 out nocopy JTF_VARCHAR2_TABLE_300

516: , a18 out nocopy JTF_VARCHAR2_TABLE_100
517: , a19 out nocopy JTF_VARCHAR2_TABLE_100
518: , a20 out nocopy JTF_VARCHAR2_TABLE_100
519: , a21 out nocopy JTF_VARCHAR2_TABLE_100
520: , a22 out nocopy JTF_VARCHAR2_TABLE_300
521: , a23 out nocopy JTF_VARCHAR2_TABLE_300
522: , a24 out nocopy JTF_VARCHAR2_TABLE_300
523: , a25 out nocopy JTF_VARCHAR2_TABLE_1000
524: , a26 out nocopy JTF_VARCHAR2_TABLE_1000

Line 521: , a23 out nocopy JTF_VARCHAR2_TABLE_300

517: , a19 out nocopy JTF_VARCHAR2_TABLE_100
518: , a20 out nocopy JTF_VARCHAR2_TABLE_100
519: , a21 out nocopy JTF_VARCHAR2_TABLE_100
520: , a22 out nocopy JTF_VARCHAR2_TABLE_300
521: , a23 out nocopy JTF_VARCHAR2_TABLE_300
522: , a24 out nocopy JTF_VARCHAR2_TABLE_300
523: , a25 out nocopy JTF_VARCHAR2_TABLE_1000
524: , a26 out nocopy JTF_VARCHAR2_TABLE_1000
525: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 522: , a24 out nocopy JTF_VARCHAR2_TABLE_300

518: , a20 out nocopy JTF_VARCHAR2_TABLE_100
519: , a21 out nocopy JTF_VARCHAR2_TABLE_100
520: , a22 out nocopy JTF_VARCHAR2_TABLE_300
521: , a23 out nocopy JTF_VARCHAR2_TABLE_300
522: , a24 out nocopy JTF_VARCHAR2_TABLE_300
523: , a25 out nocopy JTF_VARCHAR2_TABLE_1000
524: , a26 out nocopy JTF_VARCHAR2_TABLE_1000
525: , a27 out nocopy JTF_VARCHAR2_TABLE_100
526: ) as

Line 552: a22 := JTF_VARCHAR2_TABLE_300();

548: a18 := JTF_VARCHAR2_TABLE_100();
549: a19 := JTF_VARCHAR2_TABLE_100();
550: a20 := JTF_VARCHAR2_TABLE_100();
551: a21 := JTF_VARCHAR2_TABLE_100();
552: a22 := JTF_VARCHAR2_TABLE_300();
553: a23 := JTF_VARCHAR2_TABLE_300();
554: a24 := JTF_VARCHAR2_TABLE_300();
555: a25 := JTF_VARCHAR2_TABLE_1000();
556: a26 := JTF_VARCHAR2_TABLE_1000();

Line 553: a23 := JTF_VARCHAR2_TABLE_300();

549: a19 := JTF_VARCHAR2_TABLE_100();
550: a20 := JTF_VARCHAR2_TABLE_100();
551: a21 := JTF_VARCHAR2_TABLE_100();
552: a22 := JTF_VARCHAR2_TABLE_300();
553: a23 := JTF_VARCHAR2_TABLE_300();
554: a24 := JTF_VARCHAR2_TABLE_300();
555: a25 := JTF_VARCHAR2_TABLE_1000();
556: a26 := JTF_VARCHAR2_TABLE_1000();
557: a27 := JTF_VARCHAR2_TABLE_100();

Line 554: a24 := JTF_VARCHAR2_TABLE_300();

550: a20 := JTF_VARCHAR2_TABLE_100();
551: a21 := JTF_VARCHAR2_TABLE_100();
552: a22 := JTF_VARCHAR2_TABLE_300();
553: a23 := JTF_VARCHAR2_TABLE_300();
554: a24 := JTF_VARCHAR2_TABLE_300();
555: a25 := JTF_VARCHAR2_TABLE_1000();
556: a26 := JTF_VARCHAR2_TABLE_1000();
557: a27 := JTF_VARCHAR2_TABLE_100();
558: else

Line 581: a22 := JTF_VARCHAR2_TABLE_300();

577: a18 := JTF_VARCHAR2_TABLE_100();
578: a19 := JTF_VARCHAR2_TABLE_100();
579: a20 := JTF_VARCHAR2_TABLE_100();
580: a21 := JTF_VARCHAR2_TABLE_100();
581: a22 := JTF_VARCHAR2_TABLE_300();
582: a23 := JTF_VARCHAR2_TABLE_300();
583: a24 := JTF_VARCHAR2_TABLE_300();
584: a25 := JTF_VARCHAR2_TABLE_1000();
585: a26 := JTF_VARCHAR2_TABLE_1000();

Line 582: a23 := JTF_VARCHAR2_TABLE_300();

578: a19 := JTF_VARCHAR2_TABLE_100();
579: a20 := JTF_VARCHAR2_TABLE_100();
580: a21 := JTF_VARCHAR2_TABLE_100();
581: a22 := JTF_VARCHAR2_TABLE_300();
582: a23 := JTF_VARCHAR2_TABLE_300();
583: a24 := JTF_VARCHAR2_TABLE_300();
584: a25 := JTF_VARCHAR2_TABLE_1000();
585: a26 := JTF_VARCHAR2_TABLE_1000();
586: a27 := JTF_VARCHAR2_TABLE_100();

Line 583: a24 := JTF_VARCHAR2_TABLE_300();

579: a20 := JTF_VARCHAR2_TABLE_100();
580: a21 := JTF_VARCHAR2_TABLE_100();
581: a22 := JTF_VARCHAR2_TABLE_300();
582: a23 := JTF_VARCHAR2_TABLE_300();
583: a24 := JTF_VARCHAR2_TABLE_300();
584: a25 := JTF_VARCHAR2_TABLE_1000();
585: a26 := JTF_VARCHAR2_TABLE_1000();
586: a27 := JTF_VARCHAR2_TABLE_100();
587: if t.count > 0 then

Line 666: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300

662: , p_chr_id VARCHAR2
663: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
664: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
665: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
666: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
667: )
668:
669: as
670: ddx_sc_rg_tbl okl_rule_extract_pvt.sc_rg_tbl_type;

Line 789: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300

785: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
786: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300
790: )
791:
792: as
793: ddx_rule_segment_tbl okl_rule_extract_pvt.rule_segment_tbl_type;

Line 889: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_300

885: , p14_a18 out nocopy JTF_VARCHAR2_TABLE_100
886: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_100
887: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_100
888: , p14_a21 out nocopy JTF_VARCHAR2_TABLE_100
889: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_300
890: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_300
891: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_300
892: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_1000
893: , p14_a26 out nocopy JTF_VARCHAR2_TABLE_1000

Line 890: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_300

886: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_100
887: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_100
888: , p14_a21 out nocopy JTF_VARCHAR2_TABLE_100
889: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_300
890: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_300
891: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_300
892: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_1000
893: , p14_a26 out nocopy JTF_VARCHAR2_TABLE_1000
894: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 891: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_300

887: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_100
888: , p14_a21 out nocopy JTF_VARCHAR2_TABLE_100
889: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_300
890: , p14_a23 out nocopy JTF_VARCHAR2_TABLE_300
891: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_300
892: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_1000
893: , p14_a26 out nocopy JTF_VARCHAR2_TABLE_1000
894: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
895: )