DBA Data[Home] [Help]

APPS.OKL_ETH_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 5: , a2 JTF_VARCHAR2_TABLE_300

1: package body okl_eth_pvt_w as
2: /* $Header: OKLIETHB.pls 120.0 2005/07/07 10:38:19 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100

Line 90: , a2 out nocopy JTF_VARCHAR2_TABLE_300

86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_300
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: a2 := JTF_VARCHAR2_TABLE_300();

124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_300();
129: a3 := JTF_VARCHAR2_TABLE_2000();
130: a4 := JTF_NUMBER_TABLE();
131: a5 := JTF_VARCHAR2_TABLE_100();
132: a6 := JTF_VARCHAR2_TABLE_100();

Line 163: a2 := JTF_VARCHAR2_TABLE_300();

159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_300();
164: a3 := JTF_VARCHAR2_TABLE_2000();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();

Line 279: , a2 JTF_VARCHAR2_TABLE_300

275: end rosetta_table_copy_out_p1;
276:
277: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
278: , a1 JTF_NUMBER_TABLE
279: , a2 JTF_VARCHAR2_TABLE_300
280: , a3 JTF_NUMBER_TABLE
281: , a4 JTF_VARCHAR2_TABLE_100
282: , a5 JTF_VARCHAR2_TABLE_100
283: , a6 JTF_NUMBER_TABLE

Line 362: , a2 out nocopy JTF_VARCHAR2_TABLE_300

358: end if;
359: end rosetta_table_copy_in_p3;
360: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_VARCHAR2_TABLE_300
363: , a3 out nocopy JTF_NUMBER_TABLE
364: , a4 out nocopy JTF_VARCHAR2_TABLE_100
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_NUMBER_TABLE

Line 399: a2 := JTF_VARCHAR2_TABLE_300();

395: begin
396: if t is null or t.count = 0 then
397: a0 := JTF_NUMBER_TABLE();
398: a1 := JTF_NUMBER_TABLE();
399: a2 := JTF_VARCHAR2_TABLE_300();
400: a3 := JTF_NUMBER_TABLE();
401: a4 := JTF_VARCHAR2_TABLE_100();
402: a5 := JTF_VARCHAR2_TABLE_100();
403: a6 := JTF_NUMBER_TABLE();

Line 433: a2 := JTF_VARCHAR2_TABLE_300();

429: a32 := JTF_NUMBER_TABLE();
430: else
431: a0 := JTF_NUMBER_TABLE();
432: a1 := JTF_NUMBER_TABLE();
433: a2 := JTF_VARCHAR2_TABLE_300();
434: a3 := JTF_NUMBER_TABLE();
435: a4 := JTF_VARCHAR2_TABLE_100();
436: a5 := JTF_VARCHAR2_TABLE_100();
437: a6 := JTF_NUMBER_TABLE();

Line 832: , p5_a2 JTF_VARCHAR2_TABLE_300

828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2
830: , p5_a0 JTF_NUMBER_TABLE
831: , p5_a1 JTF_NUMBER_TABLE
832: , p5_a2 JTF_VARCHAR2_TABLE_300
833: , p5_a3 JTF_VARCHAR2_TABLE_2000
834: , p5_a4 JTF_NUMBER_TABLE
835: , p5_a5 JTF_VARCHAR2_TABLE_100
836: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

862: , p5_a32 JTF_DATE_TABLE
863: , p5_a33 JTF_NUMBER_TABLE
864: , p6_a0 out nocopy JTF_NUMBER_TABLE
865: , p6_a1 out nocopy JTF_NUMBER_TABLE
866: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
867: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 out nocopy JTF_NUMBER_TABLE
869: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1184: , p5_a2 JTF_VARCHAR2_TABLE_300

1180: , x_msg_count out nocopy NUMBER
1181: , x_msg_data out nocopy VARCHAR2
1182: , p5_a0 JTF_NUMBER_TABLE
1183: , p5_a1 JTF_NUMBER_TABLE
1184: , p5_a2 JTF_VARCHAR2_TABLE_300
1185: , p5_a3 JTF_VARCHAR2_TABLE_2000
1186: , p5_a4 JTF_NUMBER_TABLE
1187: , p5_a5 JTF_VARCHAR2_TABLE_100
1188: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

1214: , p5_a32 JTF_DATE_TABLE
1215: , p5_a33 JTF_NUMBER_TABLE
1216: , p6_a0 out nocopy JTF_NUMBER_TABLE
1217: , p6_a1 out nocopy JTF_NUMBER_TABLE
1218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1220: , p6_a4 out nocopy JTF_NUMBER_TABLE
1221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1464: , p5_a2 JTF_VARCHAR2_TABLE_300

1460: , x_msg_count out nocopy NUMBER
1461: , x_msg_data out nocopy VARCHAR2
1462: , p5_a0 JTF_NUMBER_TABLE
1463: , p5_a1 JTF_NUMBER_TABLE
1464: , p5_a2 JTF_VARCHAR2_TABLE_300
1465: , p5_a3 JTF_VARCHAR2_TABLE_2000
1466: , p5_a4 JTF_NUMBER_TABLE
1467: , p5_a5 JTF_VARCHAR2_TABLE_100
1468: , p5_a6 JTF_VARCHAR2_TABLE_100