DBA Data[Home] [Help]

APPS.OKL_SIP_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 27: , a5 JTF_VARCHAR2_TABLE_200

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

Line 28: , a6 JTF_VARCHAR2_TABLE_2000

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

Line 120: , a5 out nocopy JTF_VARCHAR2_TABLE_200

116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100
120: , a5 out nocopy JTF_VARCHAR2_TABLE_200
121: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a7 out nocopy JTF_DATE_TABLE
123: , a8 out nocopy JTF_DATE_TABLE
124: , a9 out nocopy JTF_VARCHAR2_TABLE_100
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 162: a5 := JTF_VARCHAR2_TABLE_200();

158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();

Line 163: a6 := JTF_VARCHAR2_TABLE_2000();

159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_200();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: a7 := JTF_DATE_TABLE();
165: a8 := JTF_DATE_TABLE();
166: a9 := JTF_VARCHAR2_TABLE_100();
167: a10 := JTF_VARCHAR2_TABLE_100();

Line 201: a5 := JTF_VARCHAR2_TABLE_200();

197: a1 := JTF_NUMBER_TABLE();
198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();

Line 202: a6 := JTF_VARCHAR2_TABLE_2000();

198: a2 := JTF_VARCHAR2_TABLE_100();
199: a3 := JTF_VARCHAR2_TABLE_100();
200: a4 := JTF_VARCHAR2_TABLE_100();
201: a5 := JTF_VARCHAR2_TABLE_200();
202: a6 := JTF_VARCHAR2_TABLE_2000();
203: a7 := JTF_DATE_TABLE();
204: a8 := JTF_DATE_TABLE();
205: a9 := JTF_VARCHAR2_TABLE_100();
206: a10 := JTF_VARCHAR2_TABLE_100();

Line 325: , a1 JTF_VARCHAR2_TABLE_200

321: end if;
322: end rosetta_table_copy_out_p2;
323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100

Line 326: , a2 JTF_VARCHAR2_TABLE_2000

322: end rosetta_table_copy_out_p2;
323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100
329: , a5 JTF_VARCHAR2_TABLE_100
330: , a6 JTF_NUMBER_TABLE

Line 364: , a1 out nocopy JTF_VARCHAR2_TABLE_200

360: end if;
361: end if;
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

361: end if;
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , a6 out nocopy JTF_NUMBER_TABLE

Line 379: a1 := JTF_VARCHAR2_TABLE_200();

375: ddindx binary_integer; indx binary_integer;
376: begin
377: if t is null or t.count = 0 then
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();

Line 380: a2 := JTF_VARCHAR2_TABLE_2000();

376: begin
377: if t is null or t.count = 0 then
378: a0 := JTF_NUMBER_TABLE();
379: a1 := JTF_VARCHAR2_TABLE_200();
380: a2 := JTF_VARCHAR2_TABLE_2000();
381: a3 := JTF_VARCHAR2_TABLE_100();
382: a4 := JTF_VARCHAR2_TABLE_100();
383: a5 := JTF_VARCHAR2_TABLE_100();
384: a6 := JTF_NUMBER_TABLE();

Line 391: a1 := JTF_VARCHAR2_TABLE_200();

387: a9 := JTF_DATE_TABLE();
388: a10 := JTF_NUMBER_TABLE();
389: else
390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();

Line 392: a2 := JTF_VARCHAR2_TABLE_2000();

388: a10 := JTF_NUMBER_TABLE();
389: else
390: a0 := JTF_NUMBER_TABLE();
391: a1 := JTF_VARCHAR2_TABLE_200();
392: a2 := JTF_VARCHAR2_TABLE_2000();
393: a3 := JTF_VARCHAR2_TABLE_100();
394: a4 := JTF_VARCHAR2_TABLE_100();
395: a5 := JTF_VARCHAR2_TABLE_100();
396: a6 := JTF_NUMBER_TABLE();

Line 919: , p5_a5 JTF_VARCHAR2_TABLE_200

915: , p5_a1 JTF_NUMBER_TABLE
916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 920: , p5_a6 JTF_VARCHAR2_TABLE_2000

916: , p5_a2 JTF_VARCHAR2_TABLE_100
917: , p5_a3 JTF_VARCHAR2_TABLE_100
918: , p5_a4 JTF_VARCHAR2_TABLE_100
919: , p5_a5 JTF_VARCHAR2_TABLE_200
920: , p5_a6 JTF_VARCHAR2_TABLE_2000
921: , p5_a7 JTF_DATE_TABLE
922: , p5_a8 JTF_DATE_TABLE
923: , p5_a9 JTF_VARCHAR2_TABLE_100
924: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

953: , p6_a1 out nocopy JTF_NUMBER_TABLE
954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

954: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
956: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
957: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
958: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
959: , p6_a7 out nocopy JTF_DATE_TABLE
960: , p6_a8 out nocopy JTF_DATE_TABLE
961: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
962: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1223: , p5_a5 JTF_VARCHAR2_TABLE_200

1219: , p5_a1 JTF_NUMBER_TABLE
1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 1224: , p5_a6 JTF_VARCHAR2_TABLE_2000

1220: , p5_a2 JTF_VARCHAR2_TABLE_100
1221: , p5_a3 JTF_VARCHAR2_TABLE_100
1222: , p5_a4 JTF_VARCHAR2_TABLE_100
1223: , p5_a5 JTF_VARCHAR2_TABLE_200
1224: , p5_a6 JTF_VARCHAR2_TABLE_2000
1225: , p5_a7 JTF_DATE_TABLE
1226: , p5_a8 JTF_DATE_TABLE
1227: , p5_a9 JTF_VARCHAR2_TABLE_100
1228: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 1526: , p5_a5 JTF_VARCHAR2_TABLE_200

1522: , p5_a1 JTF_NUMBER_TABLE
1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 1527: , p5_a6 JTF_VARCHAR2_TABLE_2000

1523: , p5_a2 JTF_VARCHAR2_TABLE_100
1524: , p5_a3 JTF_VARCHAR2_TABLE_100
1525: , p5_a4 JTF_VARCHAR2_TABLE_100
1526: , p5_a5 JTF_VARCHAR2_TABLE_200
1527: , p5_a6 JTF_VARCHAR2_TABLE_2000
1528: , p5_a7 JTF_DATE_TABLE
1529: , p5_a8 JTF_DATE_TABLE
1530: , p5_a9 JTF_VARCHAR2_TABLE_100
1531: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

1560: , p6_a1 out nocopy JTF_NUMBER_TABLE
1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

1561: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1565: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1566: , p6_a7 out nocopy JTF_DATE_TABLE
1567: , p6_a8 out nocopy JTF_DATE_TABLE
1568: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1830: , p5_a5 JTF_VARCHAR2_TABLE_200

1826: , p5_a1 JTF_NUMBER_TABLE
1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 1831: , p5_a6 JTF_VARCHAR2_TABLE_2000

1827: , p5_a2 JTF_VARCHAR2_TABLE_100
1828: , p5_a3 JTF_VARCHAR2_TABLE_100
1829: , p5_a4 JTF_VARCHAR2_TABLE_100
1830: , p5_a5 JTF_VARCHAR2_TABLE_200
1831: , p5_a6 JTF_VARCHAR2_TABLE_2000
1832: , p5_a7 JTF_DATE_TABLE
1833: , p5_a8 JTF_DATE_TABLE
1834: , p5_a9 JTF_VARCHAR2_TABLE_100
1835: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 2053: , p5_a5 JTF_VARCHAR2_TABLE_200

2049: , p5_a1 JTF_NUMBER_TABLE
2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 2054: , p5_a6 JTF_VARCHAR2_TABLE_2000

2050: , p5_a2 JTF_VARCHAR2_TABLE_100
2051: , p5_a3 JTF_VARCHAR2_TABLE_100
2052: , p5_a4 JTF_VARCHAR2_TABLE_100
2053: , p5_a5 JTF_VARCHAR2_TABLE_200
2054: , p5_a6 JTF_VARCHAR2_TABLE_2000
2055: , p5_a7 JTF_DATE_TABLE
2056: , p5_a8 JTF_DATE_TABLE
2057: , p5_a9 JTF_VARCHAR2_TABLE_100
2058: , p5_a10 JTF_VARCHAR2_TABLE_100