DBA Data[Home] [Help]

APPS.OKL_IDX_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_idx_pvt.idx_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_2000

Line 27: , a5 JTF_VARCHAR2_TABLE_2000

23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_2000
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE

Line 102: , a1 out nocopy JTF_VARCHAR2_TABLE_200

98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_idx_pvt.idx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_200
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: , a4 out nocopy JTF_NUMBER_TABLE
106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

102: , a1 out nocopy JTF_VARCHAR2_TABLE_200
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: , a4 out nocopy JTF_NUMBER_TABLE
106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_NUMBER_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
110: , a9 out nocopy JTF_DATE_TABLE

Line 137: a1 := JTF_VARCHAR2_TABLE_200();

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_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_NUMBER_TABLE();
141: a5 := JTF_VARCHAR2_TABLE_2000();

Line 141: a5 := JTF_VARCHAR2_TABLE_2000();

137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_100();
140: a4 := JTF_NUMBER_TABLE();
141: a5 := JTF_VARCHAR2_TABLE_2000();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_NUMBER_TABLE();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_DATE_TABLE();

Line 169: a1 := JTF_VARCHAR2_TABLE_200();

165: a29 := JTF_DATE_TABLE();
166: a30 := JTF_NUMBER_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_VARCHAR2_TABLE_200();
170: a2 := JTF_VARCHAR2_TABLE_100();
171: a3 := JTF_VARCHAR2_TABLE_100();
172: a4 := JTF_NUMBER_TABLE();
173: a5 := JTF_VARCHAR2_TABLE_2000();

Line 173: a5 := JTF_VARCHAR2_TABLE_2000();

169: a1 := JTF_VARCHAR2_TABLE_200();
170: a2 := JTF_VARCHAR2_TABLE_100();
171: a3 := JTF_VARCHAR2_TABLE_100();
172: a4 := JTF_NUMBER_TABLE();
173: a5 := JTF_VARCHAR2_TABLE_2000();
174: a6 := JTF_NUMBER_TABLE();
175: a7 := JTF_NUMBER_TABLE();
176: a8 := JTF_NUMBER_TABLE();
177: a9 := JTF_DATE_TABLE();

Line 277: , a2 JTF_VARCHAR2_TABLE_200

273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_idx_pvt.idxv_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_VARCHAR2_TABLE_200
278: , a3 JTF_VARCHAR2_TABLE_2000
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_VARCHAR2_TABLE_500
281: , a6 JTF_VARCHAR2_TABLE_500

Line 278: , a3 JTF_VARCHAR2_TABLE_2000

274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_idx_pvt.idxv_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_NUMBER_TABLE
277: , a2 JTF_VARCHAR2_TABLE_200
278: , a3 JTF_VARCHAR2_TABLE_2000
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_VARCHAR2_TABLE_500
281: , a6 JTF_VARCHAR2_TABLE_500
282: , a7 JTF_VARCHAR2_TABLE_500

Line 356: , a2 out nocopy JTF_VARCHAR2_TABLE_200

352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_idx_pvt.idxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: , a2 out nocopy JTF_VARCHAR2_TABLE_200
357: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100
359: , a5 out nocopy JTF_VARCHAR2_TABLE_500
360: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 357: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_idx_pvt.idxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_NUMBER_TABLE
356: , a2 out nocopy JTF_VARCHAR2_TABLE_200
357: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100
359: , a5 out nocopy JTF_VARCHAR2_TABLE_500
360: , a6 out nocopy JTF_VARCHAR2_TABLE_500
361: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 391: a2 := JTF_VARCHAR2_TABLE_200();

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

Line 392: a3 := JTF_VARCHAR2_TABLE_2000();

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

Line 423: a2 := JTF_VARCHAR2_TABLE_200();

419: a30 := JTF_NUMBER_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_NUMBER_TABLE();
423: a2 := JTF_VARCHAR2_TABLE_200();
424: a3 := JTF_VARCHAR2_TABLE_2000();
425: a4 := JTF_VARCHAR2_TABLE_100();
426: a5 := JTF_VARCHAR2_TABLE_500();
427: a6 := JTF_VARCHAR2_TABLE_500();

Line 424: a3 := JTF_VARCHAR2_TABLE_2000();

420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_NUMBER_TABLE();
423: a2 := JTF_VARCHAR2_TABLE_200();
424: a3 := JTF_VARCHAR2_TABLE_2000();
425: a4 := JTF_VARCHAR2_TABLE_100();
426: a5 := JTF_VARCHAR2_TABLE_500();
427: a6 := JTF_VARCHAR2_TABLE_500();
428: a7 := JTF_VARCHAR2_TABLE_500();

Line 698: , p5_a2 JTF_VARCHAR2_TABLE_200

694: , x_msg_count out nocopy NUMBER
695: , x_msg_data out nocopy VARCHAR2
696: , p5_a0 JTF_NUMBER_TABLE
697: , p5_a1 JTF_NUMBER_TABLE
698: , p5_a2 JTF_VARCHAR2_TABLE_200
699: , p5_a3 JTF_VARCHAR2_TABLE_2000
700: , p5_a4 JTF_VARCHAR2_TABLE_100
701: , p5_a5 JTF_VARCHAR2_TABLE_500
702: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 699: , p5_a3 JTF_VARCHAR2_TABLE_2000

695: , x_msg_data out nocopy VARCHAR2
696: , p5_a0 JTF_NUMBER_TABLE
697: , p5_a1 JTF_NUMBER_TABLE
698: , p5_a2 JTF_VARCHAR2_TABLE_200
699: , p5_a3 JTF_VARCHAR2_TABLE_2000
700: , p5_a4 JTF_VARCHAR2_TABLE_100
701: , p5_a5 JTF_VARCHAR2_TABLE_500
702: , p5_a6 JTF_VARCHAR2_TABLE_500
703: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 729: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

725: , p5_a29 JTF_DATE_TABLE
726: , p5_a30 JTF_NUMBER_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_NUMBER_TABLE
729: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
732: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
733: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

726: , p5_a30 JTF_NUMBER_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_NUMBER_TABLE
729: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
732: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
733: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
734: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 960: , p5_a2 JTF_VARCHAR2_TABLE_200

956: , x_msg_count out nocopy NUMBER
957: , x_msg_data out nocopy VARCHAR2
958: , p5_a0 JTF_NUMBER_TABLE
959: , p5_a1 JTF_NUMBER_TABLE
960: , p5_a2 JTF_VARCHAR2_TABLE_200
961: , p5_a3 JTF_VARCHAR2_TABLE_2000
962: , p5_a4 JTF_VARCHAR2_TABLE_100
963: , p5_a5 JTF_VARCHAR2_TABLE_500
964: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 961: , p5_a3 JTF_VARCHAR2_TABLE_2000

957: , x_msg_data out nocopy VARCHAR2
958: , p5_a0 JTF_NUMBER_TABLE
959: , p5_a1 JTF_NUMBER_TABLE
960: , p5_a2 JTF_VARCHAR2_TABLE_200
961: , p5_a3 JTF_VARCHAR2_TABLE_2000
962: , p5_a4 JTF_VARCHAR2_TABLE_100
963: , p5_a5 JTF_VARCHAR2_TABLE_500
964: , p5_a6 JTF_VARCHAR2_TABLE_500
965: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1221: , p5_a2 JTF_VARCHAR2_TABLE_200

1217: , x_msg_count out nocopy NUMBER
1218: , x_msg_data out nocopy VARCHAR2
1219: , p5_a0 JTF_NUMBER_TABLE
1220: , p5_a1 JTF_NUMBER_TABLE
1221: , p5_a2 JTF_VARCHAR2_TABLE_200
1222: , p5_a3 JTF_VARCHAR2_TABLE_2000
1223: , p5_a4 JTF_VARCHAR2_TABLE_100
1224: , p5_a5 JTF_VARCHAR2_TABLE_500
1225: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 1222: , p5_a3 JTF_VARCHAR2_TABLE_2000

1218: , x_msg_data out nocopy VARCHAR2
1219: , p5_a0 JTF_NUMBER_TABLE
1220: , p5_a1 JTF_NUMBER_TABLE
1221: , p5_a2 JTF_VARCHAR2_TABLE_200
1222: , p5_a3 JTF_VARCHAR2_TABLE_2000
1223: , p5_a4 JTF_VARCHAR2_TABLE_100
1224: , p5_a5 JTF_VARCHAR2_TABLE_500
1225: , p5_a6 JTF_VARCHAR2_TABLE_500
1226: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1252: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

1248: , p5_a29 JTF_DATE_TABLE
1249: , p5_a30 JTF_NUMBER_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_NUMBER_TABLE
1252: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1255: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1256: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

1249: , p5_a30 JTF_NUMBER_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_NUMBER_TABLE
1252: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1255: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1256: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1257: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 1483: , p5_a2 JTF_VARCHAR2_TABLE_200

1479: , x_msg_count out nocopy NUMBER
1480: , x_msg_data out nocopy VARCHAR2
1481: , p5_a0 JTF_NUMBER_TABLE
1482: , p5_a1 JTF_NUMBER_TABLE
1483: , p5_a2 JTF_VARCHAR2_TABLE_200
1484: , p5_a3 JTF_VARCHAR2_TABLE_2000
1485: , p5_a4 JTF_VARCHAR2_TABLE_100
1486: , p5_a5 JTF_VARCHAR2_TABLE_500
1487: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 1484: , p5_a3 JTF_VARCHAR2_TABLE_2000

1480: , x_msg_data out nocopy VARCHAR2
1481: , p5_a0 JTF_NUMBER_TABLE
1482: , p5_a1 JTF_NUMBER_TABLE
1483: , p5_a2 JTF_VARCHAR2_TABLE_200
1484: , p5_a3 JTF_VARCHAR2_TABLE_2000
1485: , p5_a4 JTF_VARCHAR2_TABLE_100
1486: , p5_a5 JTF_VARCHAR2_TABLE_500
1487: , p5_a6 JTF_VARCHAR2_TABLE_500
1488: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1678: , p5_a2 JTF_VARCHAR2_TABLE_200

1674: , x_msg_count out nocopy NUMBER
1675: , x_msg_data out nocopy VARCHAR2
1676: , p5_a0 JTF_NUMBER_TABLE
1677: , p5_a1 JTF_NUMBER_TABLE
1678: , p5_a2 JTF_VARCHAR2_TABLE_200
1679: , p5_a3 JTF_VARCHAR2_TABLE_2000
1680: , p5_a4 JTF_VARCHAR2_TABLE_100
1681: , p5_a5 JTF_VARCHAR2_TABLE_500
1682: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 1679: , p5_a3 JTF_VARCHAR2_TABLE_2000

1675: , x_msg_data out nocopy VARCHAR2
1676: , p5_a0 JTF_NUMBER_TABLE
1677: , p5_a1 JTF_NUMBER_TABLE
1678: , p5_a2 JTF_VARCHAR2_TABLE_200
1679: , p5_a3 JTF_VARCHAR2_TABLE_2000
1680: , p5_a4 JTF_VARCHAR2_TABLE_100
1681: , p5_a5 JTF_VARCHAR2_TABLE_500
1682: , p5_a6 JTF_VARCHAR2_TABLE_500
1683: , p5_a7 JTF_VARCHAR2_TABLE_500