DBA Data[Home] [Help]

APPS.OKL_FE_ADJ_MATRIX_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_fe_adj_matrix_pvt_w as
2: /* $Header: OKLEPAMB.pls 120.0 2005/07/07 10:37:39 viselvar noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy okl_fe_adj_matrix_pvt.invalid_object_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: ) as
8: ddindx binary_integer; indx binary_integer;
9: begin

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLEPAMB.pls 120.0 2005/07/07 10:37:39 viselvar noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy okl_fe_adj_matrix_pvt.invalid_object_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: ) as
8: ddindx binary_integer; indx binary_integer;
9: begin
10: if a0 is not null and a0.count > 0 then

Line 30: , a2 out nocopy JTF_VARCHAR2_TABLE_100

26: end if;
27: end rosetta_table_copy_in_p6;
28: procedure rosetta_table_copy_out_p6(t okl_fe_adj_matrix_pvt.invalid_object_tbl, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_300
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin

Line 31: , a3 out nocopy JTF_VARCHAR2_TABLE_100

27: end rosetta_table_copy_in_p6;
28: procedure rosetta_table_copy_out_p6(t okl_fe_adj_matrix_pvt.invalid_object_tbl, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_300
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then

Line 38: a2 := JTF_VARCHAR2_TABLE_100();

34: begin
35: if t is null or t.count = 0 then
36: a0 := JTF_NUMBER_TABLE();
37: a1 := JTF_VARCHAR2_TABLE_300();
38: a2 := JTF_VARCHAR2_TABLE_100();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_300();

Line 39: a3 := JTF_VARCHAR2_TABLE_100();

35: if t is null or t.count = 0 then
36: a0 := JTF_NUMBER_TABLE();
37: a1 := JTF_VARCHAR2_TABLE_300();
38: a2 := JTF_VARCHAR2_TABLE_100();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_300();
43: a2 := JTF_VARCHAR2_TABLE_100();

Line 43: a2 := JTF_VARCHAR2_TABLE_100();

39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_300();
43: a2 := JTF_VARCHAR2_TABLE_100();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then
46: a0.extend(t.count);
47: a1.extend(t.count);

Line 44: a3 := JTF_VARCHAR2_TABLE_100();

40: else
41: a0 := JTF_NUMBER_TABLE();
42: a1 := JTF_VARCHAR2_TABLE_300();
43: a2 := JTF_VARCHAR2_TABLE_100();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then
46: a0.extend(t.count);
47: a1.extend(t.count);
48: a2.extend(t.count);

Line 151: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

147: , p10_a2 out nocopy JTF_NUMBER_TABLE
148: , p10_a3 out nocopy JTF_NUMBER_TABLE
149: , p10_a4 out nocopy JTF_DATE_TABLE
150: , p10_a5 out nocopy JTF_DATE_TABLE
151: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
152: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
153: , p10_a8 out nocopy JTF_NUMBER_TABLE
154: , p10_a9 out nocopy JTF_DATE_TABLE
155: , p10_a10 out nocopy JTF_NUMBER_TABLE

Line 152: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

148: , p10_a3 out nocopy JTF_NUMBER_TABLE
149: , p10_a4 out nocopy JTF_DATE_TABLE
150: , p10_a5 out nocopy JTF_DATE_TABLE
151: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
152: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
153: , p10_a8 out nocopy JTF_NUMBER_TABLE
154: , p10_a9 out nocopy JTF_DATE_TABLE
155: , p10_a10 out nocopy JTF_NUMBER_TABLE
156: , p10_a11 out nocopy JTF_DATE_TABLE

Line 161: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

157: , p10_a12 out nocopy JTF_NUMBER_TABLE
158: , p11_a0 out nocopy JTF_NUMBER_TABLE
159: , p11_a1 out nocopy JTF_NUMBER_TABLE
160: , p11_a2 out nocopy JTF_NUMBER_TABLE
161: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
164: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
165: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 162: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

158: , p11_a0 out nocopy JTF_NUMBER_TABLE
159: , p11_a1 out nocopy JTF_NUMBER_TABLE
160: , p11_a2 out nocopy JTF_NUMBER_TABLE
161: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
164: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
165: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_300
166: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 163: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

159: , p11_a1 out nocopy JTF_NUMBER_TABLE
160: , p11_a2 out nocopy JTF_NUMBER_TABLE
161: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
164: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
165: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_300
166: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_300
167: , p11_a9 out nocopy JTF_NUMBER_TABLE

Line 164: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

160: , p11_a2 out nocopy JTF_NUMBER_TABLE
161: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
164: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
165: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_300
166: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_300
167: , p11_a9 out nocopy JTF_NUMBER_TABLE
168: , p11_a10 out nocopy JTF_NUMBER_TABLE

Line 171: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100

167: , p11_a9 out nocopy JTF_NUMBER_TABLE
168: , p11_a10 out nocopy JTF_NUMBER_TABLE
169: , p11_a11 out nocopy JTF_DATE_TABLE
170: , p11_a12 out nocopy JTF_DATE_TABLE
171: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
172: , p11_a14 out nocopy JTF_NUMBER_TABLE
173: , p11_a15 out nocopy JTF_NUMBER_TABLE
174: , p11_a16 out nocopy JTF_DATE_TABLE
175: , p11_a17 out nocopy JTF_NUMBER_TABLE

Line 178: , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100

174: , p11_a16 out nocopy JTF_DATE_TABLE
175: , p11_a17 out nocopy JTF_NUMBER_TABLE
176: , p11_a18 out nocopy JTF_DATE_TABLE
177: , p11_a19 out nocopy JTF_NUMBER_TABLE
178: , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
179: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
180: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
181: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
182: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_500

Line 451: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100

447: , p9_a2 out nocopy JTF_NUMBER_TABLE
448: , p9_a3 out nocopy JTF_NUMBER_TABLE
449: , p9_a4 out nocopy JTF_DATE_TABLE
450: , p9_a5 out nocopy JTF_DATE_TABLE
451: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a8 out nocopy JTF_NUMBER_TABLE
454: , p9_a9 out nocopy JTF_DATE_TABLE
455: , p9_a10 out nocopy JTF_NUMBER_TABLE

Line 452: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100

448: , p9_a3 out nocopy JTF_NUMBER_TABLE
449: , p9_a4 out nocopy JTF_DATE_TABLE
450: , p9_a5 out nocopy JTF_DATE_TABLE
451: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
452: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
453: , p9_a8 out nocopy JTF_NUMBER_TABLE
454: , p9_a9 out nocopy JTF_DATE_TABLE
455: , p9_a10 out nocopy JTF_NUMBER_TABLE
456: , p9_a11 out nocopy JTF_DATE_TABLE

Line 461: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100

457: , p9_a12 out nocopy JTF_NUMBER_TABLE
458: , p10_a0 out nocopy JTF_NUMBER_TABLE
459: , p10_a1 out nocopy JTF_NUMBER_TABLE
460: , p10_a2 out nocopy JTF_NUMBER_TABLE
461: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
464: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
465: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 462: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

458: , p10_a0 out nocopy JTF_NUMBER_TABLE
459: , p10_a1 out nocopy JTF_NUMBER_TABLE
460: , p10_a2 out nocopy JTF_NUMBER_TABLE
461: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
464: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
465: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_300
466: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 463: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

459: , p10_a1 out nocopy JTF_NUMBER_TABLE
460: , p10_a2 out nocopy JTF_NUMBER_TABLE
461: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
464: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
465: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_300
466: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
467: , p10_a9 out nocopy JTF_NUMBER_TABLE

Line 464: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

460: , p10_a2 out nocopy JTF_NUMBER_TABLE
461: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
463: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
464: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
465: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_300
466: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
467: , p10_a9 out nocopy JTF_NUMBER_TABLE
468: , p10_a10 out nocopy JTF_NUMBER_TABLE

Line 471: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100

467: , p10_a9 out nocopy JTF_NUMBER_TABLE
468: , p10_a10 out nocopy JTF_NUMBER_TABLE
469: , p10_a11 out nocopy JTF_DATE_TABLE
470: , p10_a12 out nocopy JTF_DATE_TABLE
471: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
472: , p10_a14 out nocopy JTF_NUMBER_TABLE
473: , p10_a15 out nocopy JTF_NUMBER_TABLE
474: , p10_a16 out nocopy JTF_DATE_TABLE
475: , p10_a17 out nocopy JTF_NUMBER_TABLE

Line 478: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100

474: , p10_a16 out nocopy JTF_DATE_TABLE
475: , p10_a17 out nocopy JTF_NUMBER_TABLE
476: , p10_a18 out nocopy JTF_DATE_TABLE
477: , p10_a19 out nocopy JTF_NUMBER_TABLE
478: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
479: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
480: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
481: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
482: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500

Line 1304: , p7_a6 JTF_VARCHAR2_TABLE_100

1300: , p7_a2 JTF_NUMBER_TABLE
1301: , p7_a3 JTF_NUMBER_TABLE
1302: , p7_a4 JTF_DATE_TABLE
1303: , p7_a5 JTF_DATE_TABLE
1304: , p7_a6 JTF_VARCHAR2_TABLE_100
1305: , p7_a7 JTF_VARCHAR2_TABLE_100
1306: , p7_a8 JTF_NUMBER_TABLE
1307: , p7_a9 JTF_DATE_TABLE
1308: , p7_a10 JTF_NUMBER_TABLE

Line 1305: , p7_a7 JTF_VARCHAR2_TABLE_100

1301: , p7_a3 JTF_NUMBER_TABLE
1302: , p7_a4 JTF_DATE_TABLE
1303: , p7_a5 JTF_DATE_TABLE
1304: , p7_a6 JTF_VARCHAR2_TABLE_100
1305: , p7_a7 JTF_VARCHAR2_TABLE_100
1306: , p7_a8 JTF_NUMBER_TABLE
1307: , p7_a9 JTF_DATE_TABLE
1308: , p7_a10 JTF_NUMBER_TABLE
1309: , p7_a11 JTF_DATE_TABLE

Line 1314: , p8_a3 JTF_VARCHAR2_TABLE_100

1310: , p7_a12 JTF_NUMBER_TABLE
1311: , p8_a0 JTF_NUMBER_TABLE
1312: , p8_a1 JTF_NUMBER_TABLE
1313: , p8_a2 JTF_NUMBER_TABLE
1314: , p8_a3 JTF_VARCHAR2_TABLE_100
1315: , p8_a4 JTF_VARCHAR2_TABLE_100
1316: , p8_a5 JTF_VARCHAR2_TABLE_100
1317: , p8_a6 JTF_VARCHAR2_TABLE_100
1318: , p8_a7 JTF_VARCHAR2_TABLE_300

Line 1315: , p8_a4 JTF_VARCHAR2_TABLE_100

1311: , p8_a0 JTF_NUMBER_TABLE
1312: , p8_a1 JTF_NUMBER_TABLE
1313: , p8_a2 JTF_NUMBER_TABLE
1314: , p8_a3 JTF_VARCHAR2_TABLE_100
1315: , p8_a4 JTF_VARCHAR2_TABLE_100
1316: , p8_a5 JTF_VARCHAR2_TABLE_100
1317: , p8_a6 JTF_VARCHAR2_TABLE_100
1318: , p8_a7 JTF_VARCHAR2_TABLE_300
1319: , p8_a8 JTF_VARCHAR2_TABLE_300

Line 1316: , p8_a5 JTF_VARCHAR2_TABLE_100

1312: , p8_a1 JTF_NUMBER_TABLE
1313: , p8_a2 JTF_NUMBER_TABLE
1314: , p8_a3 JTF_VARCHAR2_TABLE_100
1315: , p8_a4 JTF_VARCHAR2_TABLE_100
1316: , p8_a5 JTF_VARCHAR2_TABLE_100
1317: , p8_a6 JTF_VARCHAR2_TABLE_100
1318: , p8_a7 JTF_VARCHAR2_TABLE_300
1319: , p8_a8 JTF_VARCHAR2_TABLE_300
1320: , p8_a9 JTF_NUMBER_TABLE

Line 1317: , p8_a6 JTF_VARCHAR2_TABLE_100

1313: , p8_a2 JTF_NUMBER_TABLE
1314: , p8_a3 JTF_VARCHAR2_TABLE_100
1315: , p8_a4 JTF_VARCHAR2_TABLE_100
1316: , p8_a5 JTF_VARCHAR2_TABLE_100
1317: , p8_a6 JTF_VARCHAR2_TABLE_100
1318: , p8_a7 JTF_VARCHAR2_TABLE_300
1319: , p8_a8 JTF_VARCHAR2_TABLE_300
1320: , p8_a9 JTF_NUMBER_TABLE
1321: , p8_a10 JTF_NUMBER_TABLE

Line 1324: , p8_a13 JTF_VARCHAR2_TABLE_100

1320: , p8_a9 JTF_NUMBER_TABLE
1321: , p8_a10 JTF_NUMBER_TABLE
1322: , p8_a11 JTF_DATE_TABLE
1323: , p8_a12 JTF_DATE_TABLE
1324: , p8_a13 JTF_VARCHAR2_TABLE_100
1325: , p8_a14 JTF_NUMBER_TABLE
1326: , p8_a15 JTF_NUMBER_TABLE
1327: , p8_a16 JTF_DATE_TABLE
1328: , p8_a17 JTF_NUMBER_TABLE

Line 1331: , p8_a20 JTF_VARCHAR2_TABLE_100

1327: , p8_a16 JTF_DATE_TABLE
1328: , p8_a17 JTF_NUMBER_TABLE
1329: , p8_a18 JTF_DATE_TABLE
1330: , p8_a19 JTF_NUMBER_TABLE
1331: , p8_a20 JTF_VARCHAR2_TABLE_100
1332: , p8_a21 JTF_VARCHAR2_TABLE_500
1333: , p8_a22 JTF_VARCHAR2_TABLE_500
1334: , p8_a23 JTF_VARCHAR2_TABLE_500
1335: , p8_a24 JTF_VARCHAR2_TABLE_500

Line 1487: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1483: , x_msg_data out nocopy VARCHAR2
1484: , p_version_id NUMBER
1485: , p6_a0 out nocopy JTF_NUMBER_TABLE
1486: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1487: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1488: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1489: )
1490:
1491: as

Line 1488: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

1484: , p_version_id NUMBER
1485: , p6_a0 out nocopy JTF_NUMBER_TABLE
1486: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1487: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1488: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1489: )
1490:
1491: as
1492: ddx_obj_tbl okl_fe_adj_matrix_pvt.invalid_object_tbl;