APPS.OKL_MASS_REBOOK_PVT_W dependencies on JTF_VARCHAR2_TABLE_600

Line 106: , a3 JTF_VARCHAR2_TABLE_600

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
110: if a0 is not null and a0.count > 0 then

Line 131: , a3 out nocopy JTF_VARCHAR2_TABLE_600

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
135: if t is null or t.count = 0 then

Line 139: a3 := JTF_VARCHAR2_TABLE_600();

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();
143: a2 := JTF_NUMBER_TABLE();

Line 144: 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);
148: a2.extend(t.count);

Line 492: , p6_a1 JTF_VARCHAR2_TABLE_600

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
496: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 497: , p6_a6 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
501: , p6_a10 JTF_VARCHAR2_TABLE_100

Line 498: , p6_a7 JTF_VARCHAR2_TABLE_600

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
501: , p6_a10 JTF_VARCHAR2_TABLE_100
502: , p6_a11 JTF_VARCHAR2_TABLE_100

Line 499: , p6_a8 JTF_VARCHAR2_TABLE_600

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
501: , p6_a10 JTF_VARCHAR2_TABLE_100
502: , p6_a11 JTF_VARCHAR2_TABLE_100
503: , p6_a12 JTF_VARCHAR2_TABLE_500

Line 527: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600

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
530: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
531: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 668: , p7_a1 JTF_VARCHAR2_TABLE_600

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
672: , p7_a5 JTF_VARCHAR2_TABLE_100

Line 673: , p7_a6 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
677: , p7_a10 JTF_VARCHAR2_TABLE_100

Line 674: , p7_a7 JTF_VARCHAR2_TABLE_600

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
677: , p7_a10 JTF_VARCHAR2_TABLE_100
678: , p7_a11 JTF_VARCHAR2_TABLE_100

Line 675: , p7_a8 JTF_VARCHAR2_TABLE_600

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
677: , p7_a10 JTF_VARCHAR2_TABLE_100
678: , p7_a11 JTF_VARCHAR2_TABLE_100
679: , p7_a12 JTF_VARCHAR2_TABLE_500

Line 703: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_600

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
706: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
707: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 849: , p5_a3 JTF_VARCHAR2_TABLE_600

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
853: , p_basic_rate NUMBER

Line 978: , p5_a3 JTF_VARCHAR2_TABLE_600

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
982: , p_basic_rate NUMBER

Line 1116: , p5_a3 JTF_VARCHAR2_TABLE_600

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
1120: , p_basic_rate NUMBER

Line 1260: , p5_a3 JTF_VARCHAR2_TABLE_600

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
1264: , p_basic_rate NUMBER

Line 1401: , p5_a3 JTF_VARCHAR2_TABLE_600

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
1405: , p_basic_rate NUMBER

Line 1676: , p5_a4 JTF_VARCHAR2_TABLE_600

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
1679: , p5_a7 JTF_VARCHAR2_TABLE_100
1680: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 1707: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

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
1710: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1711: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1839: , p6_a1 JTF_VARCHAR2_TABLE_600

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
1843: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 1844: , p6_a6 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
1848: , p6_a10 JTF_VARCHAR2_TABLE_100

Line 1845: , p6_a7 JTF_VARCHAR2_TABLE_600

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
1848: , p6_a10 JTF_VARCHAR2_TABLE_100
1849: , p6_a11 JTF_VARCHAR2_TABLE_100

Line 1846: , p6_a8 JTF_VARCHAR2_TABLE_600

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
1848: , p6_a10 JTF_VARCHAR2_TABLE_100
1849: , p6_a11 JTF_VARCHAR2_TABLE_100
1850: , p6_a12 JTF_VARCHAR2_TABLE_500

Line 1871: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_600

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
1875: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1876: , p7_a6 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
1880: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1877: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_600

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
1880: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1881: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1878: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_600

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
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