DBA Data[Home] [Help]

APPS.OKL_SRS_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_srs_pvt.srs_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_DATE_TABLE

Line 98: , a1 out nocopy JTF_VARCHAR2_TABLE_200

94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_srs_pvt.srs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_VARCHAR2_TABLE_200
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_DATE_TABLE

Line 131: a1 := JTF_VARCHAR2_TABLE_200();

127: ddindx binary_integer; indx binary_integer;
128: begin
129: if t is null or t.count = 0 then
130: a0 := JTF_NUMBER_TABLE();
131: a1 := JTF_VARCHAR2_TABLE_200();
132: a2 := JTF_NUMBER_TABLE();
133: a3 := JTF_VARCHAR2_TABLE_100();
134: a4 := JTF_NUMBER_TABLE();
135: a5 := JTF_DATE_TABLE();

Line 161: a1 := JTF_VARCHAR2_TABLE_200();

157: a27 := JTF_DATE_TABLE();
158: a28 := JTF_NUMBER_TABLE();
159: else
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_VARCHAR2_TABLE_200();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_DATE_TABLE();

Line 262: , a1 JTF_VARCHAR2_TABLE_200

258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_srs_pvt.srsv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_200
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_NUMBER_TABLE
266: , a5 JTF_DATE_TABLE

Line 337: , a1 out nocopy JTF_VARCHAR2_TABLE_200

333: end if;
334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_srs_pvt.srsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_200
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_NUMBER_TABLE
341: , a5 out nocopy JTF_DATE_TABLE

Line 370: a1 := JTF_VARCHAR2_TABLE_200();

366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_VARCHAR2_TABLE_200();
371: a2 := JTF_NUMBER_TABLE();
372: a3 := JTF_VARCHAR2_TABLE_100();
373: a4 := JTF_NUMBER_TABLE();
374: a5 := JTF_DATE_TABLE();

Line 400: a1 := JTF_VARCHAR2_TABLE_200();

396: a27 := JTF_DATE_TABLE();
397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_200();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: a4 := JTF_NUMBER_TABLE();
404: a5 := JTF_DATE_TABLE();

Line 661: , p5_a1 JTF_VARCHAR2_TABLE_200

657: , x_return_status out nocopy VARCHAR2
658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_VARCHAR2_TABLE_200
662: , p5_a2 JTF_NUMBER_TABLE
663: , p5_a3 JTF_VARCHAR2_TABLE_100
664: , p5_a4 JTF_NUMBER_TABLE
665: , p5_a5 JTF_DATE_TABLE

Line 690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

686: , p5_a26 JTF_DATE_TABLE
687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
691: , p6_a2 out nocopy JTF_NUMBER_TABLE
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a4 out nocopy JTF_NUMBER_TABLE
694: , p6_a5 out nocopy JTF_DATE_TABLE

Line 911: , p5_a1 JTF_VARCHAR2_TABLE_200

907: , x_return_status out nocopy VARCHAR2
908: , x_msg_count out nocopy NUMBER
909: , x_msg_data out nocopy VARCHAR2
910: , p5_a0 JTF_NUMBER_TABLE
911: , p5_a1 JTF_VARCHAR2_TABLE_200
912: , p5_a2 JTF_NUMBER_TABLE
913: , p5_a3 JTF_VARCHAR2_TABLE_100
914: , p5_a4 JTF_NUMBER_TABLE
915: , p5_a5 JTF_DATE_TABLE

Line 1160: , p5_a1 JTF_VARCHAR2_TABLE_200

1156: , x_return_status out nocopy VARCHAR2
1157: , x_msg_count out nocopy NUMBER
1158: , x_msg_data out nocopy VARCHAR2
1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_VARCHAR2_TABLE_200
1161: , p5_a2 JTF_NUMBER_TABLE
1162: , p5_a3 JTF_VARCHAR2_TABLE_100
1163: , p5_a4 JTF_NUMBER_TABLE
1164: , p5_a5 JTF_DATE_TABLE

Line 1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

1185: , p5_a26 JTF_DATE_TABLE
1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1190: , p6_a2 out nocopy JTF_NUMBER_TABLE
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1192: , p6_a4 out nocopy JTF_NUMBER_TABLE
1193: , p6_a5 out nocopy JTF_DATE_TABLE

Line 1410: , p5_a1 JTF_VARCHAR2_TABLE_200

1406: , x_return_status out nocopy VARCHAR2
1407: , x_msg_count out nocopy NUMBER
1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_VARCHAR2_TABLE_200
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_100
1413: , p5_a4 JTF_NUMBER_TABLE
1414: , p5_a5 JTF_DATE_TABLE

Line 1597: , p5_a1 JTF_VARCHAR2_TABLE_200

1593: , x_return_status out nocopy VARCHAR2
1594: , x_msg_count out nocopy NUMBER
1595: , x_msg_data out nocopy VARCHAR2
1596: , p5_a0 JTF_NUMBER_TABLE
1597: , p5_a1 JTF_VARCHAR2_TABLE_200
1598: , p5_a2 JTF_NUMBER_TABLE
1599: , p5_a3 JTF_VARCHAR2_TABLE_100
1600: , p5_a4 JTF_NUMBER_TABLE
1601: , p5_a5 JTF_DATE_TABLE

Line 1686: , p0_a1 JTF_VARCHAR2_TABLE_200

1682:
1683: end;
1684:
1685: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
1686: , p0_a1 JTF_VARCHAR2_TABLE_200
1687: , p0_a2 JTF_NUMBER_TABLE
1688: , p0_a3 JTF_VARCHAR2_TABLE_100
1689: , p0_a4 JTF_NUMBER_TABLE
1690: , p0_a5 JTF_DATE_TABLE