DBA Data[Home] [Help]

APPS.OKL_CLH_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 24: , a2 JTF_VARCHAR2_TABLE_200

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clh_pvt.clhv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_600
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE

Line 25: , a3 JTF_VARCHAR2_TABLE_2000

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_clh_pvt.clhv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_600
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_DATE_TABLE

Line 121: , a2 out nocopy JTF_VARCHAR2_TABLE_200

117: end if;
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
123: , a4 out nocopy JTF_VARCHAR2_TABLE_600
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_DATE_TABLE

Line 122: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
123: , a4 out nocopy JTF_VARCHAR2_TABLE_600
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_DATE_TABLE
126: , a7 out nocopy JTF_DATE_TABLE

Line 165: a2 := JTF_VARCHAR2_TABLE_200();

161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_VARCHAR2_TABLE_200();
166: a3 := JTF_VARCHAR2_TABLE_2000();
167: a4 := JTF_VARCHAR2_TABLE_600();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_DATE_TABLE();

Line 166: a3 := JTF_VARCHAR2_TABLE_2000();

162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_VARCHAR2_TABLE_200();
166: a3 := JTF_VARCHAR2_TABLE_2000();
167: a4 := JTF_VARCHAR2_TABLE_600();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_DATE_TABLE();
170: a7 := JTF_DATE_TABLE();

Line 206: a2 := JTF_VARCHAR2_TABLE_200();

202: a39 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_VARCHAR2_TABLE_200();
207: a3 := JTF_VARCHAR2_TABLE_2000();
208: a4 := JTF_VARCHAR2_TABLE_600();
209: a5 := JTF_VARCHAR2_TABLE_100();
210: a6 := JTF_DATE_TABLE();

Line 207: a3 := JTF_VARCHAR2_TABLE_2000();

203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_VARCHAR2_TABLE_200();
207: a3 := JTF_VARCHAR2_TABLE_2000();
208: a4 := JTF_VARCHAR2_TABLE_600();
209: a5 := JTF_VARCHAR2_TABLE_100();
210: a6 := JTF_DATE_TABLE();
211: a7 := JTF_DATE_TABLE();

Line 340: , a2 JTF_VARCHAR2_TABLE_200

336: end rosetta_table_copy_out_p2;
337:
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_VARCHAR2_TABLE_200
341: , a3 JTF_VARCHAR2_TABLE_2000
342: , a4 JTF_VARCHAR2_TABLE_600
343: , a5 JTF_VARCHAR2_TABLE_100
344: , a6 JTF_DATE_TABLE

Line 341: , a3 JTF_VARCHAR2_TABLE_2000

337:
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_VARCHAR2_TABLE_200
341: , a3 JTF_VARCHAR2_TABLE_2000
342: , a4 JTF_VARCHAR2_TABLE_600
343: , a5 JTF_VARCHAR2_TABLE_100
344: , a6 JTF_DATE_TABLE
345: , a7 JTF_DATE_TABLE

Line 437: , a2 out nocopy JTF_VARCHAR2_TABLE_200

433: end if;
434: end rosetta_table_copy_in_p5;
435: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
436: , a1 out nocopy JTF_NUMBER_TABLE
437: , a2 out nocopy JTF_VARCHAR2_TABLE_200
438: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a4 out nocopy JTF_VARCHAR2_TABLE_600
440: , a5 out nocopy JTF_VARCHAR2_TABLE_100
441: , a6 out nocopy JTF_DATE_TABLE

Line 438: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

434: end rosetta_table_copy_in_p5;
435: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
436: , a1 out nocopy JTF_NUMBER_TABLE
437: , a2 out nocopy JTF_VARCHAR2_TABLE_200
438: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a4 out nocopy JTF_VARCHAR2_TABLE_600
440: , a5 out nocopy JTF_VARCHAR2_TABLE_100
441: , a6 out nocopy JTF_DATE_TABLE
442: , a7 out nocopy JTF_DATE_TABLE

Line 481: a2 := JTF_VARCHAR2_TABLE_200();

477: begin
478: if t is null or t.count = 0 then
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_200();
482: a3 := JTF_VARCHAR2_TABLE_2000();
483: a4 := JTF_VARCHAR2_TABLE_600();
484: a5 := JTF_VARCHAR2_TABLE_100();
485: a6 := JTF_DATE_TABLE();

Line 482: a3 := JTF_VARCHAR2_TABLE_2000();

478: if t is null or t.count = 0 then
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_VARCHAR2_TABLE_200();
482: a3 := JTF_VARCHAR2_TABLE_2000();
483: a4 := JTF_VARCHAR2_TABLE_600();
484: a5 := JTF_VARCHAR2_TABLE_100();
485: a6 := JTF_DATE_TABLE();
486: a7 := JTF_DATE_TABLE();

Line 522: a2 := JTF_VARCHAR2_TABLE_200();

518: a39 := JTF_NUMBER_TABLE();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_VARCHAR2_TABLE_200();
523: a3 := JTF_VARCHAR2_TABLE_2000();
524: a4 := JTF_VARCHAR2_TABLE_600();
525: a5 := JTF_VARCHAR2_TABLE_100();
526: a6 := JTF_DATE_TABLE();

Line 523: a3 := JTF_VARCHAR2_TABLE_2000();

519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_VARCHAR2_TABLE_200();
523: a3 := JTF_VARCHAR2_TABLE_2000();
524: a4 := JTF_VARCHAR2_TABLE_600();
525: a5 := JTF_VARCHAR2_TABLE_100();
526: a6 := JTF_DATE_TABLE();
527: a7 := JTF_DATE_TABLE();

Line 860: , p5_a2 JTF_VARCHAR2_TABLE_200

856: , x_msg_count out nocopy NUMBER
857: , x_msg_data out nocopy VARCHAR2
858: , p5_a0 JTF_NUMBER_TABLE
859: , p5_a1 JTF_NUMBER_TABLE
860: , p5_a2 JTF_VARCHAR2_TABLE_200
861: , p5_a3 JTF_VARCHAR2_TABLE_2000
862: , p5_a4 JTF_VARCHAR2_TABLE_600
863: , p5_a5 JTF_VARCHAR2_TABLE_100
864: , p5_a6 JTF_DATE_TABLE

Line 861: , p5_a3 JTF_VARCHAR2_TABLE_2000

857: , x_msg_data out nocopy VARCHAR2
858: , p5_a0 JTF_NUMBER_TABLE
859: , p5_a1 JTF_NUMBER_TABLE
860: , p5_a2 JTF_VARCHAR2_TABLE_200
861: , p5_a3 JTF_VARCHAR2_TABLE_2000
862: , p5_a4 JTF_VARCHAR2_TABLE_600
863: , p5_a5 JTF_VARCHAR2_TABLE_100
864: , p5_a6 JTF_DATE_TABLE
865: , p5_a7 JTF_DATE_TABLE

Line 900: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_NUMBER_TABLE
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
902: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
903: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a6 out nocopy JTF_DATE_TABLE

Line 901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

897: , p5_a39 JTF_NUMBER_TABLE
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
902: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
903: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a6 out nocopy JTF_DATE_TABLE
905: , p6_a7 out nocopy JTF_DATE_TABLE

Line 1176: , p5_a2 JTF_VARCHAR2_TABLE_200

1172: , x_msg_count out nocopy NUMBER
1173: , x_msg_data out nocopy VARCHAR2
1174: , p5_a0 JTF_NUMBER_TABLE
1175: , p5_a1 JTF_NUMBER_TABLE
1176: , p5_a2 JTF_VARCHAR2_TABLE_200
1177: , p5_a3 JTF_VARCHAR2_TABLE_2000
1178: , p5_a4 JTF_VARCHAR2_TABLE_600
1179: , p5_a5 JTF_VARCHAR2_TABLE_100
1180: , p5_a6 JTF_DATE_TABLE

Line 1177: , p5_a3 JTF_VARCHAR2_TABLE_2000

1173: , x_msg_data out nocopy VARCHAR2
1174: , p5_a0 JTF_NUMBER_TABLE
1175: , p5_a1 JTF_NUMBER_TABLE
1176: , p5_a2 JTF_VARCHAR2_TABLE_200
1177: , p5_a3 JTF_VARCHAR2_TABLE_2000
1178: , p5_a4 JTF_VARCHAR2_TABLE_600
1179: , p5_a5 JTF_VARCHAR2_TABLE_100
1180: , p5_a6 JTF_DATE_TABLE
1181: , p5_a7 JTF_DATE_TABLE

Line 1491: , p5_a2 JTF_VARCHAR2_TABLE_200

1487: , x_msg_count out nocopy NUMBER
1488: , x_msg_data out nocopy VARCHAR2
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_VARCHAR2_TABLE_200
1492: , p5_a3 JTF_VARCHAR2_TABLE_2000
1493: , p5_a4 JTF_VARCHAR2_TABLE_600
1494: , p5_a5 JTF_VARCHAR2_TABLE_100
1495: , p5_a6 JTF_DATE_TABLE

Line 1492: , p5_a3 JTF_VARCHAR2_TABLE_2000

1488: , x_msg_data out nocopy VARCHAR2
1489: , p5_a0 JTF_NUMBER_TABLE
1490: , p5_a1 JTF_NUMBER_TABLE
1491: , p5_a2 JTF_VARCHAR2_TABLE_200
1492: , p5_a3 JTF_VARCHAR2_TABLE_2000
1493: , p5_a4 JTF_VARCHAR2_TABLE_600
1494: , p5_a5 JTF_VARCHAR2_TABLE_100
1495: , p5_a6 JTF_DATE_TABLE
1496: , p5_a7 JTF_DATE_TABLE

Line 1531: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

1527: , p5_a38 JTF_VARCHAR2_TABLE_100
1528: , p5_a39 JTF_NUMBER_TABLE
1529: , p6_a0 out nocopy JTF_NUMBER_TABLE
1530: , p6_a1 out nocopy JTF_NUMBER_TABLE
1531: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1532: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1533: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1534: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1535: , p6_a6 out nocopy JTF_DATE_TABLE

Line 1532: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

1528: , p5_a39 JTF_NUMBER_TABLE
1529: , p6_a0 out nocopy JTF_NUMBER_TABLE
1530: , p6_a1 out nocopy JTF_NUMBER_TABLE
1531: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1532: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1533: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1534: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1535: , p6_a6 out nocopy JTF_DATE_TABLE
1536: , p6_a7 out nocopy JTF_DATE_TABLE

Line 1807: , p5_a2 JTF_VARCHAR2_TABLE_200

1803: , x_msg_count out nocopy NUMBER
1804: , x_msg_data out nocopy VARCHAR2
1805: , p5_a0 JTF_NUMBER_TABLE
1806: , p5_a1 JTF_NUMBER_TABLE
1807: , p5_a2 JTF_VARCHAR2_TABLE_200
1808: , p5_a3 JTF_VARCHAR2_TABLE_2000
1809: , p5_a4 JTF_VARCHAR2_TABLE_600
1810: , p5_a5 JTF_VARCHAR2_TABLE_100
1811: , p5_a6 JTF_DATE_TABLE

Line 1808: , p5_a3 JTF_VARCHAR2_TABLE_2000

1804: , x_msg_data out nocopy VARCHAR2
1805: , p5_a0 JTF_NUMBER_TABLE
1806: , p5_a1 JTF_NUMBER_TABLE
1807: , p5_a2 JTF_VARCHAR2_TABLE_200
1808: , p5_a3 JTF_VARCHAR2_TABLE_2000
1809: , p5_a4 JTF_VARCHAR2_TABLE_600
1810: , p5_a5 JTF_VARCHAR2_TABLE_100
1811: , p5_a6 JTF_DATE_TABLE
1812: , p5_a7 JTF_DATE_TABLE

Line 2038: , p5_a2 JTF_VARCHAR2_TABLE_200

2034: , x_msg_count out nocopy NUMBER
2035: , x_msg_data out nocopy VARCHAR2
2036: , p5_a0 JTF_NUMBER_TABLE
2037: , p5_a1 JTF_NUMBER_TABLE
2038: , p5_a2 JTF_VARCHAR2_TABLE_200
2039: , p5_a3 JTF_VARCHAR2_TABLE_2000
2040: , p5_a4 JTF_VARCHAR2_TABLE_600
2041: , p5_a5 JTF_VARCHAR2_TABLE_100
2042: , p5_a6 JTF_DATE_TABLE

Line 2039: , p5_a3 JTF_VARCHAR2_TABLE_2000

2035: , x_msg_data out nocopy VARCHAR2
2036: , p5_a0 JTF_NUMBER_TABLE
2037: , p5_a1 JTF_NUMBER_TABLE
2038: , p5_a2 JTF_VARCHAR2_TABLE_200
2039: , p5_a3 JTF_VARCHAR2_TABLE_2000
2040: , p5_a4 JTF_VARCHAR2_TABLE_600
2041: , p5_a5 JTF_VARCHAR2_TABLE_100
2042: , p5_a6 JTF_DATE_TABLE
2043: , p5_a7 JTF_DATE_TABLE