DBA Data[Home] [Help]

APPS.OKL_SIB_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 25: , a3 JTF_VARCHAR2_TABLE_200

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

Line 104: , a3 out nocopy JTF_VARCHAR2_TABLE_200

100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sib_pvt.sibv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_DATE_TABLE
107: , a6 out nocopy JTF_VARCHAR2_TABLE_100
108: , a7 out nocopy JTF_NUMBER_TABLE

Line 139: a3 := JTF_VARCHAR2_TABLE_200();

135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_DATE_TABLE();
142: a6 := JTF_VARCHAR2_TABLE_100();
143: a7 := JTF_NUMBER_TABLE();

Line 171: a3 := JTF_VARCHAR2_TABLE_200();

167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_NUMBER_TABLE();
170: a2 := JTF_VARCHAR2_TABLE_100();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_100();
173: a5 := JTF_DATE_TABLE();
174: a6 := JTF_VARCHAR2_TABLE_100();
175: a7 := JTF_NUMBER_TABLE();

Line 281: , a6 JTF_VARCHAR2_TABLE_200

277: , a2 JTF_VARCHAR2_TABLE_100
278: , a3 JTF_DATE_TABLE
279: , a4 JTF_VARCHAR2_TABLE_100
280: , a5 JTF_NUMBER_TABLE
281: , a6 JTF_VARCHAR2_TABLE_200
282: , a7 JTF_NUMBER_TABLE
283: , a8 JTF_DATE_TABLE
284: , a9 JTF_VARCHAR2_TABLE_100
285: , a10 JTF_VARCHAR2_TABLE_500

Line 358: , a6 out nocopy JTF_VARCHAR2_TABLE_200

354: , a2 out nocopy JTF_VARCHAR2_TABLE_100
355: , a3 out nocopy JTF_DATE_TABLE
356: , a4 out nocopy JTF_VARCHAR2_TABLE_100
357: , a5 out nocopy JTF_NUMBER_TABLE
358: , a6 out nocopy JTF_VARCHAR2_TABLE_200
359: , a7 out nocopy JTF_NUMBER_TABLE
360: , a8 out nocopy JTF_DATE_TABLE
361: , a9 out nocopy JTF_VARCHAR2_TABLE_100
362: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 392: a6 := JTF_VARCHAR2_TABLE_200();

388: a2 := JTF_VARCHAR2_TABLE_100();
389: a3 := JTF_DATE_TABLE();
390: a4 := JTF_VARCHAR2_TABLE_100();
391: a5 := JTF_NUMBER_TABLE();
392: a6 := JTF_VARCHAR2_TABLE_200();
393: a7 := JTF_NUMBER_TABLE();
394: a8 := JTF_DATE_TABLE();
395: a9 := JTF_VARCHAR2_TABLE_100();
396: a10 := JTF_VARCHAR2_TABLE_500();

Line 423: a6 := JTF_VARCHAR2_TABLE_200();

419: a2 := JTF_VARCHAR2_TABLE_100();
420: a3 := JTF_DATE_TABLE();
421: a4 := JTF_VARCHAR2_TABLE_100();
422: a5 := JTF_NUMBER_TABLE();
423: a6 := JTF_VARCHAR2_TABLE_200();
424: a7 := JTF_NUMBER_TABLE();
425: a8 := JTF_DATE_TABLE();
426: a9 := JTF_VARCHAR2_TABLE_100();
427: a10 := JTF_VARCHAR2_TABLE_500();

Line 522: , a1 JTF_VARCHAR2_TABLE_200

518: end if;
519: end rosetta_table_copy_out_p5;
520:
521: procedure rosetta_table_copy_in_p8(t out nocopy okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 JTF_NUMBER_TABLE
522: , a1 JTF_VARCHAR2_TABLE_200
523: , a2 JTF_VARCHAR2_TABLE_100
524: , a3 JTF_VARCHAR2_TABLE_100
525: , a4 JTF_VARCHAR2_TABLE_100
526: , a5 JTF_NUMBER_TABLE

Line 559: , a1 out nocopy JTF_VARCHAR2_TABLE_200

555: end if;
556: end if;
557: end rosetta_table_copy_in_p8;
558: procedure rosetta_table_copy_out_p8(t okl_sib_pvt.oklsubsidypoolbudgetstltbltype, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_VARCHAR2_TABLE_200
560: , a2 out nocopy JTF_VARCHAR2_TABLE_100
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_100
563: , a5 out nocopy JTF_NUMBER_TABLE

Line 573: a1 := JTF_VARCHAR2_TABLE_200();

569: ddindx binary_integer; indx binary_integer;
570: begin
571: if t is null or t.count = 0 then
572: a0 := JTF_NUMBER_TABLE();
573: a1 := JTF_VARCHAR2_TABLE_200();
574: a2 := JTF_VARCHAR2_TABLE_100();
575: a3 := JTF_VARCHAR2_TABLE_100();
576: a4 := JTF_VARCHAR2_TABLE_100();
577: a5 := JTF_NUMBER_TABLE();

Line 584: a1 := JTF_VARCHAR2_TABLE_200();

580: a8 := JTF_DATE_TABLE();
581: a9 := JTF_NUMBER_TABLE();
582: else
583: a0 := JTF_NUMBER_TABLE();
584: a1 := JTF_VARCHAR2_TABLE_200();
585: a2 := JTF_VARCHAR2_TABLE_100();
586: a3 := JTF_VARCHAR2_TABLE_100();
587: a4 := JTF_VARCHAR2_TABLE_100();
588: a5 := JTF_NUMBER_TABLE();

Line 798: , p5_a3 JTF_VARCHAR2_TABLE_200

794: , x_msg_data out nocopy VARCHAR2
795: , p5_a0 JTF_NUMBER_TABLE
796: , p5_a1 JTF_NUMBER_TABLE
797: , p5_a2 JTF_VARCHAR2_TABLE_100
798: , p5_a3 JTF_VARCHAR2_TABLE_200
799: , p5_a4 JTF_VARCHAR2_TABLE_100
800: , p5_a5 JTF_DATE_TABLE
801: , p5_a6 JTF_VARCHAR2_TABLE_100
802: , p5_a7 JTF_NUMBER_TABLE

Line 829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

825: , p5_a30 JTF_NUMBER_TABLE
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_DATE_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 1060: , p5_a3 JTF_VARCHAR2_TABLE_200

1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_VARCHAR2_TABLE_100
1060: , p5_a3 JTF_VARCHAR2_TABLE_200
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_DATE_TABLE
1063: , p5_a6 JTF_VARCHAR2_TABLE_100
1064: , p5_a7 JTF_NUMBER_TABLE

Line 1321: , p5_a3 JTF_VARCHAR2_TABLE_200

1317: , x_msg_data out nocopy VARCHAR2
1318: , p5_a0 JTF_NUMBER_TABLE
1319: , p5_a1 JTF_NUMBER_TABLE
1320: , p5_a2 JTF_VARCHAR2_TABLE_100
1321: , p5_a3 JTF_VARCHAR2_TABLE_200
1322: , p5_a4 JTF_VARCHAR2_TABLE_100
1323: , p5_a5 JTF_DATE_TABLE
1324: , p5_a6 JTF_VARCHAR2_TABLE_100
1325: , p5_a7 JTF_NUMBER_TABLE

Line 1352: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

1348: , p5_a30 JTF_NUMBER_TABLE
1349: , p6_a0 out nocopy JTF_NUMBER_TABLE
1350: , p6_a1 out nocopy JTF_NUMBER_TABLE
1351: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1352: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1353: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1354: , p6_a5 out nocopy JTF_DATE_TABLE
1355: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1356: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 1583: , p5_a3 JTF_VARCHAR2_TABLE_200

1579: , x_msg_data out nocopy VARCHAR2
1580: , p5_a0 JTF_NUMBER_TABLE
1581: , p5_a1 JTF_NUMBER_TABLE
1582: , p5_a2 JTF_VARCHAR2_TABLE_100
1583: , p5_a3 JTF_VARCHAR2_TABLE_200
1584: , p5_a4 JTF_VARCHAR2_TABLE_100
1585: , p5_a5 JTF_DATE_TABLE
1586: , p5_a6 JTF_VARCHAR2_TABLE_100
1587: , p5_a7 JTF_NUMBER_TABLE

Line 1778: , p5_a3 JTF_VARCHAR2_TABLE_200

1774: , x_msg_data out nocopy VARCHAR2
1775: , p5_a0 JTF_NUMBER_TABLE
1776: , p5_a1 JTF_NUMBER_TABLE
1777: , p5_a2 JTF_VARCHAR2_TABLE_100
1778: , p5_a3 JTF_VARCHAR2_TABLE_200
1779: , p5_a4 JTF_VARCHAR2_TABLE_100
1780: , p5_a5 JTF_DATE_TABLE
1781: , p5_a6 JTF_VARCHAR2_TABLE_100
1782: , p5_a7 JTF_NUMBER_TABLE