DBA Data[Home] [Help]

APPS.OKL_XMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 5: , a2 JTF_VARCHAR2_TABLE_300

1: package body okl_xmp_pvt_w as
2: /* $Header: OKLIXMPB.pls 120.0 2007/04/02 09:12:52 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_xmp_pvt.xmp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100

Line 29: , a26 JTF_VARCHAR2_TABLE_300

25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_VARCHAR2_TABLE_300
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
33: if a0 is not null and a0.count > 0 then

Line 76: , a2 out nocopy JTF_VARCHAR2_TABLE_300

72: end if;
73: end rosetta_table_copy_in_p2;
74: procedure rosetta_table_copy_out_p2(t okl_xmp_pvt.xmp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_NUMBER_TABLE
76: , a2 out nocopy JTF_VARCHAR2_TABLE_300
77: , a3 out nocopy JTF_NUMBER_TABLE
78: , a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 100: , a26 out nocopy JTF_VARCHAR2_TABLE_300

96: , a22 out nocopy JTF_NUMBER_TABLE
97: , a23 out nocopy JTF_DATE_TABLE
98: , a24 out nocopy JTF_NUMBER_TABLE
99: , a25 out nocopy JTF_DATE_TABLE
100: , a26 out nocopy JTF_VARCHAR2_TABLE_300
101: ) as
102: ddindx binary_integer; indx binary_integer;
103: begin
104: if t is null or t.count = 0 then

Line 107: a2 := JTF_VARCHAR2_TABLE_300();

103: begin
104: if t is null or t.count = 0 then
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_NUMBER_TABLE();
107: a2 := JTF_VARCHAR2_TABLE_300();
108: a3 := JTF_NUMBER_TABLE();
109: a4 := JTF_VARCHAR2_TABLE_100();
110: a5 := JTF_VARCHAR2_TABLE_2000();
111: a6 := JTF_VARCHAR2_TABLE_100();

Line 131: a26 := JTF_VARCHAR2_TABLE_300();

127: a22 := JTF_NUMBER_TABLE();
128: a23 := JTF_DATE_TABLE();
129: a24 := JTF_NUMBER_TABLE();
130: a25 := JTF_DATE_TABLE();
131: a26 := JTF_VARCHAR2_TABLE_300();
132: else
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_VARCHAR2_TABLE_300();

Line 135: a2 := JTF_VARCHAR2_TABLE_300();

131: a26 := JTF_VARCHAR2_TABLE_300();
132: else
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_VARCHAR2_TABLE_300();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_VARCHAR2_TABLE_100();
138: a5 := JTF_VARCHAR2_TABLE_2000();
139: a6 := JTF_VARCHAR2_TABLE_100();

Line 159: a26 := JTF_VARCHAR2_TABLE_300();

155: a22 := JTF_NUMBER_TABLE();
156: a23 := JTF_DATE_TABLE();
157: a24 := JTF_NUMBER_TABLE();
158: a25 := JTF_DATE_TABLE();
159: a26 := JTF_VARCHAR2_TABLE_300();
160: if t.count > 0 then
161: a0.extend(t.count);
162: a1.extend(t.count);
163: a2.extend(t.count);

Line 382: , p5_a2 JTF_VARCHAR2_TABLE_300

378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_300
383: , p5_a3 JTF_NUMBER_TABLE
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_2000
386: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 406: , p5_a26 JTF_VARCHAR2_TABLE_300

402: , p5_a22 JTF_NUMBER_TABLE
403: , p5_a23 JTF_DATE_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p5_a25 JTF_DATE_TABLE
406: , p5_a26 JTF_VARCHAR2_TABLE_300
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_NUMBER_TABLE
409: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
410: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 409: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

405: , p5_a25 JTF_DATE_TABLE
406: , p5_a26 JTF_VARCHAR2_TABLE_300
407: , p6_a0 out nocopy JTF_NUMBER_TABLE
408: , p6_a1 out nocopy JTF_NUMBER_TABLE
409: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
410: , p6_a3 out nocopy JTF_NUMBER_TABLE
411: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
413: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 433: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300

429: , p6_a22 out nocopy JTF_NUMBER_TABLE
430: , p6_a23 out nocopy JTF_DATE_TABLE
431: , p6_a24 out nocopy JTF_NUMBER_TABLE
432: , p6_a25 out nocopy JTF_DATE_TABLE
433: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
434: )
435:
436: as
437: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

Line 620: , p5_a2 JTF_VARCHAR2_TABLE_300

616: , x_msg_count out nocopy NUMBER
617: , x_msg_data out nocopy VARCHAR2
618: , p5_a0 JTF_NUMBER_TABLE
619: , p5_a1 JTF_NUMBER_TABLE
620: , p5_a2 JTF_VARCHAR2_TABLE_300
621: , p5_a3 JTF_NUMBER_TABLE
622: , p5_a4 JTF_VARCHAR2_TABLE_100
623: , p5_a5 JTF_VARCHAR2_TABLE_2000
624: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 644: , p5_a26 JTF_VARCHAR2_TABLE_300

640: , p5_a22 JTF_NUMBER_TABLE
641: , p5_a23 JTF_DATE_TABLE
642: , p5_a24 JTF_NUMBER_TABLE
643: , p5_a25 JTF_DATE_TABLE
644: , p5_a26 JTF_VARCHAR2_TABLE_300
645: , p6_a0 in out nocopy JTF_NUMBER_TABLE
646: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
647: , p6_a2 in out nocopy JTF_NUMBER_TABLE
648: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 737: , p5_a2 JTF_VARCHAR2_TABLE_300

733: , x_msg_count out nocopy NUMBER
734: , x_msg_data out nocopy VARCHAR2
735: , p5_a0 JTF_NUMBER_TABLE
736: , p5_a1 JTF_NUMBER_TABLE
737: , p5_a2 JTF_VARCHAR2_TABLE_300
738: , p5_a3 JTF_NUMBER_TABLE
739: , p5_a4 JTF_VARCHAR2_TABLE_100
740: , p5_a5 JTF_VARCHAR2_TABLE_2000
741: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 761: , p5_a26 JTF_VARCHAR2_TABLE_300

757: , p5_a22 JTF_NUMBER_TABLE
758: , p5_a23 JTF_DATE_TABLE
759: , p5_a24 JTF_NUMBER_TABLE
760: , p5_a25 JTF_DATE_TABLE
761: , p5_a26 JTF_VARCHAR2_TABLE_300
762: )
763:
764: as
765: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

Line 974: , p5_a2 JTF_VARCHAR2_TABLE_300

970: , x_msg_count out nocopy NUMBER
971: , x_msg_data out nocopy VARCHAR2
972: , p5_a0 JTF_NUMBER_TABLE
973: , p5_a1 JTF_NUMBER_TABLE
974: , p5_a2 JTF_VARCHAR2_TABLE_300
975: , p5_a3 JTF_NUMBER_TABLE
976: , p5_a4 JTF_VARCHAR2_TABLE_100
977: , p5_a5 JTF_VARCHAR2_TABLE_2000
978: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 998: , p5_a26 JTF_VARCHAR2_TABLE_300

994: , p5_a22 JTF_NUMBER_TABLE
995: , p5_a23 JTF_DATE_TABLE
996: , p5_a24 JTF_NUMBER_TABLE
997: , p5_a25 JTF_DATE_TABLE
998: , p5_a26 JTF_VARCHAR2_TABLE_300
999: , p6_a0 out nocopy JTF_NUMBER_TABLE
1000: , p6_a1 out nocopy JTF_NUMBER_TABLE
1001: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1002: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1001: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

997: , p5_a25 JTF_DATE_TABLE
998: , p5_a26 JTF_VARCHAR2_TABLE_300
999: , p6_a0 out nocopy JTF_NUMBER_TABLE
1000: , p6_a1 out nocopy JTF_NUMBER_TABLE
1001: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1002: , p6_a3 out nocopy JTF_NUMBER_TABLE
1003: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1004: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1005: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1025: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300

1021: , p6_a22 out nocopy JTF_NUMBER_TABLE
1022: , p6_a23 out nocopy JTF_DATE_TABLE
1023: , p6_a24 out nocopy JTF_NUMBER_TABLE
1024: , p6_a25 out nocopy JTF_DATE_TABLE
1025: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
1026: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1027: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1028: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1029: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 1150: , p5_a2 JTF_VARCHAR2_TABLE_300

1146: , x_msg_count out nocopy NUMBER
1147: , x_msg_data out nocopy VARCHAR2
1148: , p5_a0 JTF_NUMBER_TABLE
1149: , p5_a1 JTF_NUMBER_TABLE
1150: , p5_a2 JTF_VARCHAR2_TABLE_300
1151: , p5_a3 JTF_NUMBER_TABLE
1152: , p5_a4 JTF_VARCHAR2_TABLE_100
1153: , p5_a5 JTF_VARCHAR2_TABLE_2000
1154: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1174: , p5_a26 JTF_VARCHAR2_TABLE_300

1170: , p5_a22 JTF_NUMBER_TABLE
1171: , p5_a23 JTF_DATE_TABLE
1172: , p5_a24 JTF_NUMBER_TABLE
1173: , p5_a25 JTF_DATE_TABLE
1174: , p5_a26 JTF_VARCHAR2_TABLE_300
1175: , p6_a0 out nocopy JTF_NUMBER_TABLE
1176: , p6_a1 out nocopy JTF_NUMBER_TABLE
1177: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1178: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1177: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

1173: , p5_a25 JTF_DATE_TABLE
1174: , p5_a26 JTF_VARCHAR2_TABLE_300
1175: , p6_a0 out nocopy JTF_NUMBER_TABLE
1176: , p6_a1 out nocopy JTF_NUMBER_TABLE
1177: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1178: , p6_a3 out nocopy JTF_NUMBER_TABLE
1179: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1180: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1181: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1201: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300

1197: , p6_a22 out nocopy JTF_NUMBER_TABLE
1198: , p6_a23 out nocopy JTF_DATE_TABLE
1199: , p6_a24 out nocopy JTF_NUMBER_TABLE
1200: , p6_a25 out nocopy JTF_DATE_TABLE
1201: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
1202: )
1203:
1204: as
1205: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

Line 1388: , p5_a2 JTF_VARCHAR2_TABLE_300

1384: , x_msg_count out nocopy NUMBER
1385: , x_msg_data out nocopy VARCHAR2
1386: , p5_a0 JTF_NUMBER_TABLE
1387: , p5_a1 JTF_NUMBER_TABLE
1388: , p5_a2 JTF_VARCHAR2_TABLE_300
1389: , p5_a3 JTF_NUMBER_TABLE
1390: , p5_a4 JTF_VARCHAR2_TABLE_100
1391: , p5_a5 JTF_VARCHAR2_TABLE_2000
1392: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1412: , p5_a26 JTF_VARCHAR2_TABLE_300

1408: , p5_a22 JTF_NUMBER_TABLE
1409: , p5_a23 JTF_DATE_TABLE
1410: , p5_a24 JTF_NUMBER_TABLE
1411: , p5_a25 JTF_DATE_TABLE
1412: , p5_a26 JTF_VARCHAR2_TABLE_300
1413: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1414: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1415: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1416: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 1505: , p5_a2 JTF_VARCHAR2_TABLE_300

1501: , x_msg_count out nocopy NUMBER
1502: , x_msg_data out nocopy VARCHAR2
1503: , p5_a0 JTF_NUMBER_TABLE
1504: , p5_a1 JTF_NUMBER_TABLE
1505: , p5_a2 JTF_VARCHAR2_TABLE_300
1506: , p5_a3 JTF_NUMBER_TABLE
1507: , p5_a4 JTF_VARCHAR2_TABLE_100
1508: , p5_a5 JTF_VARCHAR2_TABLE_2000
1509: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1529: , p5_a26 JTF_VARCHAR2_TABLE_300

1525: , p5_a22 JTF_NUMBER_TABLE
1526: , p5_a23 JTF_DATE_TABLE
1527: , p5_a24 JTF_NUMBER_TABLE
1528: , p5_a25 JTF_DATE_TABLE
1529: , p5_a26 JTF_VARCHAR2_TABLE_300
1530: )
1531:
1532: as
1533: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

Line 1684: , p5_a2 JTF_VARCHAR2_TABLE_300

1680: , x_msg_count out nocopy NUMBER
1681: , x_msg_data out nocopy VARCHAR2
1682: , p5_a0 JTF_NUMBER_TABLE
1683: , p5_a1 JTF_NUMBER_TABLE
1684: , p5_a2 JTF_VARCHAR2_TABLE_300
1685: , p5_a3 JTF_NUMBER_TABLE
1686: , p5_a4 JTF_VARCHAR2_TABLE_100
1687: , p5_a5 JTF_VARCHAR2_TABLE_2000
1688: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1708: , p5_a26 JTF_VARCHAR2_TABLE_300

1704: , p5_a22 JTF_NUMBER_TABLE
1705: , p5_a23 JTF_DATE_TABLE
1706: , p5_a24 JTF_NUMBER_TABLE
1707: , p5_a25 JTF_DATE_TABLE
1708: , p5_a26 JTF_VARCHAR2_TABLE_300
1709: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1710: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1711: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1712: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 1801: , p5_a2 JTF_VARCHAR2_TABLE_300

1797: , x_msg_count out nocopy NUMBER
1798: , x_msg_data out nocopy VARCHAR2
1799: , p5_a0 JTF_NUMBER_TABLE
1800: , p5_a1 JTF_NUMBER_TABLE
1801: , p5_a2 JTF_VARCHAR2_TABLE_300
1802: , p5_a3 JTF_NUMBER_TABLE
1803: , p5_a4 JTF_VARCHAR2_TABLE_100
1804: , p5_a5 JTF_VARCHAR2_TABLE_2000
1805: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1825: , p5_a26 JTF_VARCHAR2_TABLE_300

1821: , p5_a22 JTF_NUMBER_TABLE
1822: , p5_a23 JTF_DATE_TABLE
1823: , p5_a24 JTF_NUMBER_TABLE
1824: , p5_a25 JTF_DATE_TABLE
1825: , p5_a26 JTF_VARCHAR2_TABLE_300
1826: )
1827:
1828: as
1829: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;