DBA Data[Home] [Help]

APPS.OKL_SRT_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 5: , a2 JTF_VARCHAR2_TABLE_2000

1: package body okl_srt_pvt_w as
2: /* $Header: OKLISRTB.pls 120.0 2005/07/07 10:40:32 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srt_pvt.okl_srtv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100

Line 98: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

94: end if;
95: end rosetta_table_copy_in_p1;
96: procedure rosetta_table_copy_out_p1(t okl_srt_pvt.okl_srtv_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_300
98: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE
101: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: a2 := JTF_VARCHAR2_TABLE_2000();

136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_VARCHAR2_TABLE_300();
140: a2 := JTF_VARCHAR2_TABLE_2000();
141: a3 := JTF_NUMBER_TABLE();
142: a4 := JTF_NUMBER_TABLE();
143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_VARCHAR2_TABLE_100();

Line 179: a2 := JTF_VARCHAR2_TABLE_2000();

175: a37 := JTF_NUMBER_TABLE();
176: else
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_VARCHAR2_TABLE_300();
179: a2 := JTF_VARCHAR2_TABLE_2000();
180: a3 := JTF_NUMBER_TABLE();
181: a4 := JTF_NUMBER_TABLE();
182: a5 := JTF_VARCHAR2_TABLE_100();
183: a6 := JTF_VARCHAR2_TABLE_100();

Line 601: , a1 JTF_VARCHAR2_TABLE_2000

597: end if;
598: end rosetta_table_copy_out_p3;
599:
600: procedure rosetta_table_copy_in_p5(t out nocopy okl_srt_pvt.okl_srttl_tbl, a0 JTF_NUMBER_TABLE
601: , a1 JTF_VARCHAR2_TABLE_2000
602: , a2 JTF_VARCHAR2_TABLE_100
603: , a3 JTF_VARCHAR2_TABLE_100
604: , a4 JTF_VARCHAR2_TABLE_100
605: , a5 JTF_NUMBER_TABLE

Line 638: , a1 out nocopy JTF_VARCHAR2_TABLE_2000

634: end if;
635: end if;
636: end rosetta_table_copy_in_p5;
637: procedure rosetta_table_copy_out_p5(t okl_srt_pvt.okl_srttl_tbl, a0 out nocopy JTF_NUMBER_TABLE
638: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
639: , a2 out nocopy JTF_VARCHAR2_TABLE_100
640: , a3 out nocopy JTF_VARCHAR2_TABLE_100
641: , a4 out nocopy JTF_VARCHAR2_TABLE_100
642: , a5 out nocopy JTF_NUMBER_TABLE

Line 652: a1 := JTF_VARCHAR2_TABLE_2000();

648: ddindx binary_integer; indx binary_integer;
649: begin
650: if t is null or t.count = 0 then
651: a0 := JTF_NUMBER_TABLE();
652: a1 := JTF_VARCHAR2_TABLE_2000();
653: a2 := JTF_VARCHAR2_TABLE_100();
654: a3 := JTF_VARCHAR2_TABLE_100();
655: a4 := JTF_VARCHAR2_TABLE_100();
656: a5 := JTF_NUMBER_TABLE();

Line 663: a1 := JTF_VARCHAR2_TABLE_2000();

659: a8 := JTF_DATE_TABLE();
660: a9 := JTF_NUMBER_TABLE();
661: else
662: a0 := JTF_NUMBER_TABLE();
663: a1 := JTF_VARCHAR2_TABLE_2000();
664: a2 := JTF_VARCHAR2_TABLE_100();
665: a3 := JTF_VARCHAR2_TABLE_100();
666: a4 := JTF_VARCHAR2_TABLE_100();
667: a5 := JTF_NUMBER_TABLE();

Line 904: , p5_a2 JTF_VARCHAR2_TABLE_2000

900: , x_msg_count out nocopy NUMBER
901: , x_msg_data out nocopy VARCHAR2
902: , p5_a0 JTF_NUMBER_TABLE
903: , p5_a1 JTF_VARCHAR2_TABLE_300
904: , p5_a2 JTF_VARCHAR2_TABLE_2000
905: , p5_a3 JTF_NUMBER_TABLE
906: , p5_a4 JTF_NUMBER_TABLE
907: , p5_a5 JTF_VARCHAR2_TABLE_100
908: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 942: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000

938: , p5_a36 JTF_DATE_TABLE
939: , p5_a37 JTF_NUMBER_TABLE
940: , p6_a0 out nocopy JTF_NUMBER_TABLE
941: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
942: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
943: , p6_a3 out nocopy JTF_NUMBER_TABLE
944: , p6_a4 out nocopy JTF_NUMBER_TABLE
945: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
946: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1288: , p5_a2 JTF_VARCHAR2_TABLE_2000

1284: , x_msg_count out nocopy NUMBER
1285: , x_msg_data out nocopy VARCHAR2
1286: , p5_a0 JTF_NUMBER_TABLE
1287: , p5_a1 JTF_VARCHAR2_TABLE_300
1288: , p5_a2 JTF_VARCHAR2_TABLE_2000
1289: , p5_a3 JTF_NUMBER_TABLE
1290: , p5_a4 JTF_NUMBER_TABLE
1291: , p5_a5 JTF_VARCHAR2_TABLE_100
1292: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1326: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000

1322: , p5_a36 JTF_DATE_TABLE
1323: , p5_a37 JTF_NUMBER_TABLE
1324: , p6_a0 out nocopy JTF_NUMBER_TABLE
1325: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1326: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1327: , p6_a3 out nocopy JTF_NUMBER_TABLE
1328: , p6_a4 out nocopy JTF_NUMBER_TABLE
1329: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1592: , p5_a2 JTF_VARCHAR2_TABLE_2000

1588: , x_msg_count out nocopy NUMBER
1589: , x_msg_data out nocopy VARCHAR2
1590: , p5_a0 JTF_NUMBER_TABLE
1591: , p5_a1 JTF_VARCHAR2_TABLE_300
1592: , p5_a2 JTF_VARCHAR2_TABLE_2000
1593: , p5_a3 JTF_NUMBER_TABLE
1594: , p5_a4 JTF_NUMBER_TABLE
1595: , p5_a5 JTF_VARCHAR2_TABLE_100
1596: , p5_a6 JTF_VARCHAR2_TABLE_100