DBA Data[Home] [Help]

APPS.OKL_MST_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_mst_pvt.mstv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_600
27: , a5 JTF_NUMBER_TABLE

Line 25: , a3 JTF_VARCHAR2_TABLE_200

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

Line 102: , a1 out nocopy JTF_VARCHAR2_TABLE_200

98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_200
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_600
106: , a5 out nocopy 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_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_200
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_600
106: , a5 out nocopy JTF_NUMBER_TABLE
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: a1 := JTF_VARCHAR2_TABLE_200();

133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_600();
141: a5 := 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_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_600();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();

Line 169: a1 := JTF_VARCHAR2_TABLE_200();

165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_DATE_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_VARCHAR2_TABLE_200();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_600();
173: a5 := JTF_NUMBER_TABLE();

Line 171: a3 := JTF_VARCHAR2_TABLE_200();

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

Line 276: , a1 JTF_VARCHAR2_TABLE_200

272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_VARCHAR2_TABLE_200
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_VARCHAR2_TABLE_200
279: , a4 JTF_VARCHAR2_TABLE_600
280: , a5 JTF_NUMBER_TABLE

Line 278: , a3 JTF_VARCHAR2_TABLE_200

274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_VARCHAR2_TABLE_200
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_VARCHAR2_TABLE_200
279: , a4 JTF_VARCHAR2_TABLE_600
280: , a5 JTF_NUMBER_TABLE
281: , a6 JTF_NUMBER_TABLE
282: , a7 JTF_VARCHAR2_TABLE_100

Line 355: , a1 out nocopy JTF_VARCHAR2_TABLE_200

351: end if;
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_VARCHAR2_TABLE_200
358: , a4 out nocopy JTF_VARCHAR2_TABLE_600
359: , a5 out nocopy JTF_NUMBER_TABLE

Line 357: , a3 out nocopy JTF_VARCHAR2_TABLE_200

353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_VARCHAR2_TABLE_200
358: , a4 out nocopy JTF_VARCHAR2_TABLE_600
359: , a5 out nocopy JTF_NUMBER_TABLE
360: , a6 out nocopy JTF_NUMBER_TABLE
361: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 390: a1 := JTF_VARCHAR2_TABLE_200();

386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_VARCHAR2_TABLE_200();
393: a4 := JTF_VARCHAR2_TABLE_600();
394: a5 := JTF_NUMBER_TABLE();

Line 392: a3 := JTF_VARCHAR2_TABLE_200();

388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_VARCHAR2_TABLE_200();
393: a4 := JTF_VARCHAR2_TABLE_600();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_NUMBER_TABLE();
396: a7 := JTF_VARCHAR2_TABLE_100();

Line 422: a1 := JTF_VARCHAR2_TABLE_200();

418: a29 := JTF_NUMBER_TABLE();
419: a30 := JTF_DATE_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_VARCHAR2_TABLE_200();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_VARCHAR2_TABLE_200();
425: a4 := JTF_VARCHAR2_TABLE_600();
426: a5 := JTF_NUMBER_TABLE();

Line 424: a3 := JTF_VARCHAR2_TABLE_200();

420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_VARCHAR2_TABLE_200();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_VARCHAR2_TABLE_200();
425: a4 := JTF_VARCHAR2_TABLE_600();
426: a5 := JTF_NUMBER_TABLE();
427: a6 := JTF_NUMBER_TABLE();
428: a7 := JTF_VARCHAR2_TABLE_100();

Line 697: , p5_a1 JTF_VARCHAR2_TABLE_200

693: , x_return_status out nocopy VARCHAR2
694: , x_msg_count out nocopy NUMBER
695: , x_msg_data out nocopy VARCHAR2
696: , p5_a0 JTF_NUMBER_TABLE
697: , p5_a1 JTF_VARCHAR2_TABLE_200
698: , p5_a2 JTF_NUMBER_TABLE
699: , p5_a3 JTF_VARCHAR2_TABLE_200
700: , p5_a4 JTF_VARCHAR2_TABLE_600
701: , p5_a5 JTF_NUMBER_TABLE

Line 699: , p5_a3 JTF_VARCHAR2_TABLE_200

695: , x_msg_data out nocopy VARCHAR2
696: , p5_a0 JTF_NUMBER_TABLE
697: , p5_a1 JTF_VARCHAR2_TABLE_200
698: , p5_a2 JTF_NUMBER_TABLE
699: , p5_a3 JTF_VARCHAR2_TABLE_200
700: , p5_a4 JTF_VARCHAR2_TABLE_600
701: , p5_a5 JTF_NUMBER_TABLE
702: , p5_a6 JTF_NUMBER_TABLE
703: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 728: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

724: , p5_a28 JTF_DATE_TABLE
725: , p5_a29 JTF_NUMBER_TABLE
726: , p5_a30 JTF_DATE_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
729: , p6_a2 out nocopy JTF_NUMBER_TABLE
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
732: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

726: , p5_a30 JTF_DATE_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
729: , p6_a2 out nocopy JTF_NUMBER_TABLE
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
732: , p6_a5 out nocopy JTF_NUMBER_TABLE
733: , p6_a6 out nocopy JTF_NUMBER_TABLE
734: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 959: , p5_a1 JTF_VARCHAR2_TABLE_200

955: , x_return_status out nocopy VARCHAR2
956: , x_msg_count out nocopy NUMBER
957: , x_msg_data out nocopy VARCHAR2
958: , p5_a0 JTF_NUMBER_TABLE
959: , p5_a1 JTF_VARCHAR2_TABLE_200
960: , p5_a2 JTF_NUMBER_TABLE
961: , p5_a3 JTF_VARCHAR2_TABLE_200
962: , p5_a4 JTF_VARCHAR2_TABLE_600
963: , p5_a5 JTF_NUMBER_TABLE

Line 961: , p5_a3 JTF_VARCHAR2_TABLE_200

957: , x_msg_data out nocopy VARCHAR2
958: , p5_a0 JTF_NUMBER_TABLE
959: , p5_a1 JTF_VARCHAR2_TABLE_200
960: , p5_a2 JTF_NUMBER_TABLE
961: , p5_a3 JTF_VARCHAR2_TABLE_200
962: , p5_a4 JTF_VARCHAR2_TABLE_600
963: , p5_a5 JTF_NUMBER_TABLE
964: , p5_a6 JTF_NUMBER_TABLE
965: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1220: , p5_a1 JTF_VARCHAR2_TABLE_200

1216: , x_return_status out nocopy VARCHAR2
1217: , x_msg_count out nocopy NUMBER
1218: , x_msg_data out nocopy VARCHAR2
1219: , p5_a0 JTF_NUMBER_TABLE
1220: , p5_a1 JTF_VARCHAR2_TABLE_200
1221: , p5_a2 JTF_NUMBER_TABLE
1222: , p5_a3 JTF_VARCHAR2_TABLE_200
1223: , p5_a4 JTF_VARCHAR2_TABLE_600
1224: , p5_a5 JTF_NUMBER_TABLE

Line 1222: , p5_a3 JTF_VARCHAR2_TABLE_200

1218: , x_msg_data out nocopy VARCHAR2
1219: , p5_a0 JTF_NUMBER_TABLE
1220: , p5_a1 JTF_VARCHAR2_TABLE_200
1221: , p5_a2 JTF_NUMBER_TABLE
1222: , p5_a3 JTF_VARCHAR2_TABLE_200
1223: , p5_a4 JTF_VARCHAR2_TABLE_600
1224: , p5_a5 JTF_NUMBER_TABLE
1225: , p5_a6 JTF_NUMBER_TABLE
1226: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1251: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

1247: , p5_a28 JTF_DATE_TABLE
1248: , p5_a29 JTF_NUMBER_TABLE
1249: , p5_a30 JTF_DATE_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1252: , p6_a2 out nocopy JTF_NUMBER_TABLE
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1255: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

1249: , p5_a30 JTF_DATE_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1252: , p6_a2 out nocopy JTF_NUMBER_TABLE
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1255: , p6_a5 out nocopy JTF_NUMBER_TABLE
1256: , p6_a6 out nocopy JTF_NUMBER_TABLE
1257: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1482: , p5_a1 JTF_VARCHAR2_TABLE_200

1478: , x_return_status out nocopy VARCHAR2
1479: , x_msg_count out nocopy NUMBER
1480: , x_msg_data out nocopy VARCHAR2
1481: , p5_a0 JTF_NUMBER_TABLE
1482: , p5_a1 JTF_VARCHAR2_TABLE_200
1483: , p5_a2 JTF_NUMBER_TABLE
1484: , p5_a3 JTF_VARCHAR2_TABLE_200
1485: , p5_a4 JTF_VARCHAR2_TABLE_600
1486: , p5_a5 JTF_NUMBER_TABLE

Line 1484: , p5_a3 JTF_VARCHAR2_TABLE_200

1480: , x_msg_data out nocopy VARCHAR2
1481: , p5_a0 JTF_NUMBER_TABLE
1482: , p5_a1 JTF_VARCHAR2_TABLE_200
1483: , p5_a2 JTF_NUMBER_TABLE
1484: , p5_a3 JTF_VARCHAR2_TABLE_200
1485: , p5_a4 JTF_VARCHAR2_TABLE_600
1486: , p5_a5 JTF_NUMBER_TABLE
1487: , p5_a6 JTF_NUMBER_TABLE
1488: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1677: , p5_a1 JTF_VARCHAR2_TABLE_200

1673: , x_return_status out nocopy VARCHAR2
1674: , x_msg_count out nocopy NUMBER
1675: , x_msg_data out nocopy VARCHAR2
1676: , p5_a0 JTF_NUMBER_TABLE
1677: , p5_a1 JTF_VARCHAR2_TABLE_200
1678: , p5_a2 JTF_NUMBER_TABLE
1679: , p5_a3 JTF_VARCHAR2_TABLE_200
1680: , p5_a4 JTF_VARCHAR2_TABLE_600
1681: , p5_a5 JTF_NUMBER_TABLE

Line 1679: , p5_a3 JTF_VARCHAR2_TABLE_200

1675: , x_msg_data out nocopy VARCHAR2
1676: , p5_a0 JTF_NUMBER_TABLE
1677: , p5_a1 JTF_VARCHAR2_TABLE_200
1678: , p5_a2 JTF_NUMBER_TABLE
1679: , p5_a3 JTF_VARCHAR2_TABLE_200
1680: , p5_a4 JTF_VARCHAR2_TABLE_600
1681: , p5_a5 JTF_NUMBER_TABLE
1682: , p5_a6 JTF_NUMBER_TABLE
1683: , p5_a7 JTF_VARCHAR2_TABLE_100