DBA Data[Home] [Help]

APPS.OKL_DRA_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 28: , a3 JTF_VARCHAR2_TABLE_200

24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_dra_pvt.drav_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_200
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_DATE_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100

Line 41: , a16 JTF_VARCHAR2_TABLE_2000

37: , a12 JTF_VARCHAR2_TABLE_100
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_100
41: , a16 JTF_VARCHAR2_TABLE_2000
42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_VARCHAR2_TABLE_500
44: , a19 JTF_VARCHAR2_TABLE_500
45: , a20 JTF_VARCHAR2_TABLE_500

Line 121: , a3 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 134: , a16 out nocopy JTF_VARCHAR2_TABLE_2000

130: , a12 out nocopy JTF_VARCHAR2_TABLE_100
131: , a13 out nocopy JTF_NUMBER_TABLE
132: , a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , a15 out nocopy JTF_VARCHAR2_TABLE_100
134: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
135: , a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , a18 out nocopy JTF_VARCHAR2_TABLE_500
137: , a19 out nocopy JTF_VARCHAR2_TABLE_500
138: , a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 163: a3 := JTF_VARCHAR2_TABLE_200();

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

Line 176: a16 := JTF_VARCHAR2_TABLE_2000();

172: a12 := JTF_VARCHAR2_TABLE_100();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_VARCHAR2_TABLE_100();
175: a15 := JTF_VARCHAR2_TABLE_100();
176: a16 := JTF_VARCHAR2_TABLE_2000();
177: a17 := JTF_VARCHAR2_TABLE_100();
178: a18 := JTF_VARCHAR2_TABLE_500();
179: a19 := JTF_VARCHAR2_TABLE_500();
180: a20 := JTF_VARCHAR2_TABLE_500();

Line 202: a3 := JTF_VARCHAR2_TABLE_200();

198: else
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_100();
202: a3 := JTF_VARCHAR2_TABLE_200();
203: a4 := JTF_NUMBER_TABLE();
204: a5 := JTF_DATE_TABLE();
205: a6 := JTF_DATE_TABLE();
206: a7 := JTF_VARCHAR2_TABLE_100();

Line 215: a16 := JTF_VARCHAR2_TABLE_2000();

211: a12 := JTF_VARCHAR2_TABLE_100();
212: a13 := JTF_NUMBER_TABLE();
213: a14 := JTF_VARCHAR2_TABLE_100();
214: a15 := JTF_VARCHAR2_TABLE_100();
215: a16 := JTF_VARCHAR2_TABLE_2000();
216: a17 := JTF_VARCHAR2_TABLE_100();
217: a18 := JTF_VARCHAR2_TABLE_500();
218: a19 := JTF_VARCHAR2_TABLE_500();
219: a20 := JTF_VARCHAR2_TABLE_500();

Line 331: , a4 JTF_VARCHAR2_TABLE_2000

327: procedure rosetta_table_copy_in_p5(t out nocopy okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_VARCHAR2_TABLE_100
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_2000
332: , a5 JTF_NUMBER_TABLE
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_NUMBER_TABLE
335: , a8 JTF_DATE_TABLE

Line 368: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

364: procedure rosetta_table_copy_out_p5(t okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
365: , a1 out nocopy JTF_VARCHAR2_TABLE_100
366: , a2 out nocopy JTF_VARCHAR2_TABLE_100
367: , a3 out nocopy JTF_VARCHAR2_TABLE_100
368: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
369: , a5 out nocopy JTF_NUMBER_TABLE
370: , a6 out nocopy JTF_DATE_TABLE
371: , a7 out nocopy JTF_NUMBER_TABLE
372: , a8 out nocopy JTF_DATE_TABLE

Line 382: a4 := JTF_VARCHAR2_TABLE_2000();

378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_100();
380: a2 := JTF_VARCHAR2_TABLE_100();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_2000();
383: a5 := JTF_NUMBER_TABLE();
384: a6 := JTF_DATE_TABLE();
385: a7 := JTF_NUMBER_TABLE();
386: a8 := JTF_DATE_TABLE();

Line 393: a4 := JTF_VARCHAR2_TABLE_2000();

389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_VARCHAR2_TABLE_100();
392: a3 := JTF_VARCHAR2_TABLE_100();
393: a4 := JTF_VARCHAR2_TABLE_2000();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_DATE_TABLE();
396: a7 := JTF_NUMBER_TABLE();
397: a8 := JTF_DATE_TABLE();

Line 435: , a2 JTF_VARCHAR2_TABLE_200

431: end rosetta_table_copy_out_p5;
432:
433: procedure rosetta_table_copy_in_p8(t out nocopy okl_dra_pvt.dra_tbl_type, a0 JTF_NUMBER_TABLE
434: , a1 JTF_NUMBER_TABLE
435: , a2 JTF_VARCHAR2_TABLE_200
436: , a3 JTF_NUMBER_TABLE
437: , a4 JTF_DATE_TABLE
438: , a5 JTF_DATE_TABLE
439: , a6 JTF_VARCHAR2_TABLE_100

Line 524: , a2 out nocopy JTF_VARCHAR2_TABLE_200

520: end if;
521: end rosetta_table_copy_in_p8;
522: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
523: , a1 out nocopy JTF_NUMBER_TABLE
524: , a2 out nocopy JTF_VARCHAR2_TABLE_200
525: , a3 out nocopy JTF_NUMBER_TABLE
526: , a4 out nocopy JTF_DATE_TABLE
527: , a5 out nocopy JTF_DATE_TABLE
528: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 564: a2 := JTF_VARCHAR2_TABLE_200();

560: begin
561: if t is null or t.count = 0 then
562: a0 := JTF_NUMBER_TABLE();
563: a1 := JTF_NUMBER_TABLE();
564: a2 := JTF_VARCHAR2_TABLE_200();
565: a3 := JTF_NUMBER_TABLE();
566: a4 := JTF_DATE_TABLE();
567: a5 := JTF_DATE_TABLE();
568: a6 := JTF_VARCHAR2_TABLE_100();

Line 601: a2 := JTF_VARCHAR2_TABLE_200();

597: a35 := JTF_NUMBER_TABLE();
598: else
599: a0 := JTF_NUMBER_TABLE();
600: a1 := JTF_NUMBER_TABLE();
601: a2 := JTF_VARCHAR2_TABLE_200();
602: a3 := JTF_NUMBER_TABLE();
603: a4 := JTF_DATE_TABLE();
604: a5 := JTF_DATE_TABLE();
605: a6 := JTF_VARCHAR2_TABLE_100();

Line 920: , p5_a3 JTF_VARCHAR2_TABLE_200

916: , x_msg_data out nocopy VARCHAR2
917: , p5_a0 JTF_NUMBER_TABLE
918: , p5_a1 JTF_NUMBER_TABLE
919: , p5_a2 JTF_VARCHAR2_TABLE_100
920: , p5_a3 JTF_VARCHAR2_TABLE_200
921: , p5_a4 JTF_NUMBER_TABLE
922: , p5_a5 JTF_DATE_TABLE
923: , p5_a6 JTF_DATE_TABLE
924: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 933: , p5_a16 JTF_VARCHAR2_TABLE_2000

929: , p5_a12 JTF_VARCHAR2_TABLE_100
930: , p5_a13 JTF_NUMBER_TABLE
931: , p5_a14 JTF_VARCHAR2_TABLE_100
932: , p5_a15 JTF_VARCHAR2_TABLE_100
933: , p5_a16 JTF_VARCHAR2_TABLE_2000
934: , p5_a17 JTF_VARCHAR2_TABLE_100
935: , p5_a18 JTF_VARCHAR2_TABLE_500
936: , p5_a19 JTF_VARCHAR2_TABLE_500
937: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 958: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

954: , p5_a37 JTF_NUMBER_TABLE
955: , p6_a0 out nocopy JTF_NUMBER_TABLE
956: , p6_a1 out nocopy JTF_NUMBER_TABLE
957: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
958: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
959: , p6_a4 out nocopy JTF_NUMBER_TABLE
960: , p6_a5 out nocopy JTF_DATE_TABLE
961: , p6_a6 out nocopy JTF_DATE_TABLE
962: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 971: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000

967: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
968: , p6_a13 out nocopy JTF_NUMBER_TABLE
969: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
970: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
971: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
972: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
973: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
974: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
975: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 1224: , p5_a3 JTF_VARCHAR2_TABLE_200

1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_VARCHAR2_TABLE_200
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_DATE_TABLE
1227: , p5_a6 JTF_DATE_TABLE
1228: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1237: , p5_a16 JTF_VARCHAR2_TABLE_2000

1233: , p5_a12 JTF_VARCHAR2_TABLE_100
1234: , p5_a13 JTF_NUMBER_TABLE
1235: , p5_a14 JTF_VARCHAR2_TABLE_100
1236: , p5_a15 JTF_VARCHAR2_TABLE_100
1237: , p5_a16 JTF_VARCHAR2_TABLE_2000
1238: , p5_a17 JTF_VARCHAR2_TABLE_100
1239: , p5_a18 JTF_VARCHAR2_TABLE_500
1240: , p5_a19 JTF_VARCHAR2_TABLE_500
1241: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 1527: , p5_a3 JTF_VARCHAR2_TABLE_200

1523: , x_msg_data out nocopy VARCHAR2
1524: , p5_a0 JTF_NUMBER_TABLE
1525: , p5_a1 JTF_NUMBER_TABLE
1526: , p5_a2 JTF_VARCHAR2_TABLE_100
1527: , p5_a3 JTF_VARCHAR2_TABLE_200
1528: , p5_a4 JTF_NUMBER_TABLE
1529: , p5_a5 JTF_DATE_TABLE
1530: , p5_a6 JTF_DATE_TABLE
1531: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1540: , p5_a16 JTF_VARCHAR2_TABLE_2000

1536: , p5_a12 JTF_VARCHAR2_TABLE_100
1537: , p5_a13 JTF_NUMBER_TABLE
1538: , p5_a14 JTF_VARCHAR2_TABLE_100
1539: , p5_a15 JTF_VARCHAR2_TABLE_100
1540: , p5_a16 JTF_VARCHAR2_TABLE_2000
1541: , p5_a17 JTF_VARCHAR2_TABLE_100
1542: , p5_a18 JTF_VARCHAR2_TABLE_500
1543: , p5_a19 JTF_VARCHAR2_TABLE_500
1544: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 1565: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

1561: , p5_a37 JTF_NUMBER_TABLE
1562: , p6_a0 out nocopy JTF_NUMBER_TABLE
1563: , p6_a1 out nocopy JTF_NUMBER_TABLE
1564: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1566: , p6_a4 out nocopy JTF_NUMBER_TABLE
1567: , p6_a5 out nocopy JTF_DATE_TABLE
1568: , p6_a6 out nocopy JTF_DATE_TABLE
1569: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1578: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000

1574: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1575: , p6_a13 out nocopy JTF_NUMBER_TABLE
1576: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1578: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
1579: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1580: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1581: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1582: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 1831: , p5_a3 JTF_VARCHAR2_TABLE_200

1827: , x_msg_data out nocopy VARCHAR2
1828: , p5_a0 JTF_NUMBER_TABLE
1829: , p5_a1 JTF_NUMBER_TABLE
1830: , p5_a2 JTF_VARCHAR2_TABLE_100
1831: , p5_a3 JTF_VARCHAR2_TABLE_200
1832: , p5_a4 JTF_NUMBER_TABLE
1833: , p5_a5 JTF_DATE_TABLE
1834: , p5_a6 JTF_DATE_TABLE
1835: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1844: , p5_a16 JTF_VARCHAR2_TABLE_2000

1840: , p5_a12 JTF_VARCHAR2_TABLE_100
1841: , p5_a13 JTF_NUMBER_TABLE
1842: , p5_a14 JTF_VARCHAR2_TABLE_100
1843: , p5_a15 JTF_VARCHAR2_TABLE_100
1844: , p5_a16 JTF_VARCHAR2_TABLE_2000
1845: , p5_a17 JTF_VARCHAR2_TABLE_100
1846: , p5_a18 JTF_VARCHAR2_TABLE_500
1847: , p5_a19 JTF_VARCHAR2_TABLE_500
1848: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 2054: , p5_a3 JTF_VARCHAR2_TABLE_200

2050: , x_msg_data out nocopy VARCHAR2
2051: , p5_a0 JTF_NUMBER_TABLE
2052: , p5_a1 JTF_NUMBER_TABLE
2053: , p5_a2 JTF_VARCHAR2_TABLE_100
2054: , p5_a3 JTF_VARCHAR2_TABLE_200
2055: , p5_a4 JTF_NUMBER_TABLE
2056: , p5_a5 JTF_DATE_TABLE
2057: , p5_a6 JTF_DATE_TABLE
2058: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 2067: , p5_a16 JTF_VARCHAR2_TABLE_2000

2063: , p5_a12 JTF_VARCHAR2_TABLE_100
2064: , p5_a13 JTF_NUMBER_TABLE
2065: , p5_a14 JTF_VARCHAR2_TABLE_100
2066: , p5_a15 JTF_VARCHAR2_TABLE_100
2067: , p5_a16 JTF_VARCHAR2_TABLE_2000
2068: , p5_a17 JTF_VARCHAR2_TABLE_100
2069: , p5_a18 JTF_VARCHAR2_TABLE_500
2070: , p5_a19 JTF_VARCHAR2_TABLE_500
2071: , p5_a20 JTF_VARCHAR2_TABLE_500