DBA Data[Home] [Help]

APPS.IEX_SCORE_PUB_W dependencies on JTF_VARCHAR2_TABLE_200

Line 16: , a3 JTF_VARCHAR2_TABLE_2000

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iex_score_pub.score_eng_comp_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_2000
17: ) as
18: ddindx binary_integer; indx binary_integer;
19: begin
20: if a0 is not null and a0.count > 0 then

Line 41: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

37: end rosetta_table_copy_in_p1;
38: procedure rosetta_table_copy_out_p1(t iex_score_pub.score_eng_comp_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then

Line 49: a3 := JTF_VARCHAR2_TABLE_2000();

45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: a1 := JTF_NUMBER_TABLE();
48: a2 := JTF_NUMBER_TABLE();
49: a3 := JTF_VARCHAR2_TABLE_2000();
50: else
51: a0 := JTF_NUMBER_TABLE();
52: a1 := JTF_NUMBER_TABLE();
53: a2 := JTF_NUMBER_TABLE();

Line 54: a3 := JTF_VARCHAR2_TABLE_2000();

50: else
51: a0 := JTF_NUMBER_TABLE();
52: a1 := JTF_NUMBER_TABLE();
53: a2 := JTF_NUMBER_TABLE();
54: a3 := JTF_VARCHAR2_TABLE_2000();
55: if t.count > 0 then
56: a0.extend(t.count);
57: a1.extend(t.count);
58: a2.extend(t.count);

Line 84: , a7 JTF_VARCHAR2_TABLE_200

80: , a3 JTF_NUMBER_TABLE
81: , a4 JTF_DATE_TABLE
82: , a5 JTF_NUMBER_TABLE
83: , a6 JTF_NUMBER_TABLE
84: , a7 JTF_VARCHAR2_TABLE_200
85: , a8 JTF_VARCHAR2_TABLE_100
86: , a9 JTF_DATE_TABLE
87: , a10 JTF_DATE_TABLE
88: , a11 JTF_NUMBER_TABLE

Line 151: , a7 out nocopy JTF_VARCHAR2_TABLE_200

147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_DATE_TABLE
149: , a5 out nocopy JTF_NUMBER_TABLE
150: , a6 out nocopy JTF_NUMBER_TABLE
151: , a7 out nocopy JTF_VARCHAR2_TABLE_200
152: , a8 out nocopy JTF_VARCHAR2_TABLE_100
153: , a9 out nocopy JTF_DATE_TABLE
154: , a10 out nocopy JTF_DATE_TABLE
155: , a11 out nocopy JTF_NUMBER_TABLE

Line 180: a7 := JTF_VARCHAR2_TABLE_200();

176: a3 := JTF_NUMBER_TABLE();
177: a4 := JTF_DATE_TABLE();
178: a5 := JTF_NUMBER_TABLE();
179: a6 := JTF_NUMBER_TABLE();
180: a7 := JTF_VARCHAR2_TABLE_200();
181: a8 := JTF_VARCHAR2_TABLE_100();
182: a9 := JTF_DATE_TABLE();
183: a10 := JTF_DATE_TABLE();
184: a11 := JTF_NUMBER_TABLE();

Line 206: a7 := JTF_VARCHAR2_TABLE_200();

202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_DATE_TABLE();
204: a5 := JTF_NUMBER_TABLE();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_VARCHAR2_TABLE_200();
207: a8 := JTF_VARCHAR2_TABLE_100();
208: a9 := JTF_DATE_TABLE();
209: a10 := JTF_DATE_TABLE();
210: a11 := JTF_NUMBER_TABLE();

Line 398: , a4 JTF_VARCHAR2_TABLE_2000

394: procedure rosetta_table_copy_in_p11(t out nocopy iex_score_pub.score_comp_det_tbl_type, a0 JTF_NUMBER_TABLE
395: , a1 JTF_NUMBER_TABLE
396: , a2 JTF_NUMBER_TABLE
397: , a3 JTF_NUMBER_TABLE
398: , a4 JTF_VARCHAR2_TABLE_2000
399: , a5 JTF_NUMBER_TABLE
400: , a6 JTF_NUMBER_TABLE
401: , a7 JTF_NUMBER_TABLE
402: , a8 JTF_DATE_TABLE

Line 441: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

437: procedure rosetta_table_copy_out_p11(t iex_score_pub.score_comp_det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
438: , a1 out nocopy JTF_NUMBER_TABLE
439: , a2 out nocopy JTF_NUMBER_TABLE
440: , a3 out nocopy JTF_NUMBER_TABLE
441: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
442: , a5 out nocopy JTF_NUMBER_TABLE
443: , a6 out nocopy JTF_NUMBER_TABLE
444: , a7 out nocopy JTF_NUMBER_TABLE
445: , a8 out nocopy JTF_DATE_TABLE

Line 458: a4 := JTF_VARCHAR2_TABLE_2000();

454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_NUMBER_TABLE();
456: a2 := JTF_NUMBER_TABLE();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_2000();
459: a5 := JTF_NUMBER_TABLE();
460: a6 := JTF_NUMBER_TABLE();
461: a7 := JTF_NUMBER_TABLE();
462: a8 := JTF_DATE_TABLE();

Line 472: a4 := JTF_VARCHAR2_TABLE_2000();

468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_NUMBER_TABLE();
472: a4 := JTF_VARCHAR2_TABLE_2000();
473: a5 := JTF_NUMBER_TABLE();
474: a6 := JTF_NUMBER_TABLE();
475: a7 := JTF_NUMBER_TABLE();
476: a8 := JTF_DATE_TABLE();

Line 530: , a9 JTF_VARCHAR2_TABLE_2000

526: , a5 JTF_NUMBER_TABLE
527: , a6 JTF_NUMBER_TABLE
528: , a7 JTF_DATE_TABLE
529: , a8 JTF_NUMBER_TABLE
530: , a9 JTF_VARCHAR2_TABLE_2000
531: , a10 JTF_VARCHAR2_TABLE_100
532: , a11 JTF_VARCHAR2_TABLE_100
533: , a12 JTF_VARCHAR2_TABLE_100
534: , a13 JTF_VARCHAR2_TABLE_100

Line 583: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

579: , a5 out nocopy JTF_NUMBER_TABLE
580: , a6 out nocopy JTF_NUMBER_TABLE
581: , a7 out nocopy JTF_DATE_TABLE
582: , a8 out nocopy JTF_NUMBER_TABLE
583: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
584: , a10 out nocopy JTF_VARCHAR2_TABLE_100
585: , a11 out nocopy JTF_VARCHAR2_TABLE_100
586: , a12 out nocopy JTF_VARCHAR2_TABLE_100
587: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 605: a9 := JTF_VARCHAR2_TABLE_2000();

601: a5 := JTF_NUMBER_TABLE();
602: a6 := JTF_NUMBER_TABLE();
603: a7 := JTF_DATE_TABLE();
604: a8 := JTF_NUMBER_TABLE();
605: a9 := JTF_VARCHAR2_TABLE_2000();
606: a10 := JTF_VARCHAR2_TABLE_100();
607: a11 := JTF_VARCHAR2_TABLE_100();
608: a12 := JTF_VARCHAR2_TABLE_100();
609: a13 := JTF_VARCHAR2_TABLE_100();

Line 624: a9 := JTF_VARCHAR2_TABLE_2000();

620: a5 := JTF_NUMBER_TABLE();
621: a6 := JTF_NUMBER_TABLE();
622: a7 := JTF_DATE_TABLE();
623: a8 := JTF_NUMBER_TABLE();
624: a9 := JTF_VARCHAR2_TABLE_2000();
625: a10 := JTF_VARCHAR2_TABLE_100();
626: a11 := JTF_VARCHAR2_TABLE_100();
627: a12 := JTF_VARCHAR2_TABLE_100();
628: a13 := JTF_VARCHAR2_TABLE_100();

Line 913: , p3_a7 JTF_VARCHAR2_TABLE_200

909: , p3_a3 JTF_NUMBER_TABLE
910: , p3_a4 JTF_DATE_TABLE
911: , p3_a5 JTF_NUMBER_TABLE
912: , p3_a6 JTF_NUMBER_TABLE
913: , p3_a7 JTF_VARCHAR2_TABLE_200
914: , p3_a8 JTF_VARCHAR2_TABLE_100
915: , p3_a9 JTF_DATE_TABLE
916: , p3_a10 JTF_DATE_TABLE
917: , p3_a11 JTF_NUMBER_TABLE

Line 1301: , p3_a9 JTF_VARCHAR2_TABLE_2000

1297: , p3_a5 JTF_NUMBER_TABLE
1298: , p3_a6 JTF_NUMBER_TABLE
1299: , p3_a7 JTF_DATE_TABLE
1300: , p3_a8 JTF_NUMBER_TABLE
1301: , p3_a9 JTF_VARCHAR2_TABLE_2000
1302: , p3_a10 JTF_VARCHAR2_TABLE_100
1303: , p3_a11 JTF_VARCHAR2_TABLE_100
1304: , p3_a12 JTF_VARCHAR2_TABLE_100
1305: , p3_a13 JTF_VARCHAR2_TABLE_100

Line 1381: , p3_a9 JTF_VARCHAR2_TABLE_2000

1377: , p3_a5 JTF_NUMBER_TABLE
1378: , p3_a6 JTF_NUMBER_TABLE
1379: , p3_a7 JTF_DATE_TABLE
1380: , p3_a8 JTF_NUMBER_TABLE
1381: , p3_a9 JTF_VARCHAR2_TABLE_2000
1382: , p3_a10 JTF_VARCHAR2_TABLE_100
1383: , p3_a11 JTF_VARCHAR2_TABLE_100
1384: , p3_a12 JTF_VARCHAR2_TABLE_100
1385: , p3_a13 JTF_VARCHAR2_TABLE_100

Line 1452: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000

1448: , p3_a0 in out nocopy JTF_NUMBER_TABLE
1449: , p3_a1 in out nocopy JTF_NUMBER_TABLE
1450: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1451: , p3_a3 in out nocopy JTF_NUMBER_TABLE
1452: , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_2000
1453: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1454: , p3_a6 in out nocopy JTF_NUMBER_TABLE
1455: , p3_a7 in out nocopy JTF_NUMBER_TABLE
1456: , p3_a8 in out nocopy JTF_DATE_TABLE

Line 1532: , p3_a4 JTF_VARCHAR2_TABLE_2000

1528: , p3_a0 JTF_NUMBER_TABLE
1529: , p3_a1 JTF_NUMBER_TABLE
1530: , p3_a2 JTF_NUMBER_TABLE
1531: , p3_a3 JTF_NUMBER_TABLE
1532: , p3_a4 JTF_VARCHAR2_TABLE_2000
1533: , p3_a5 JTF_NUMBER_TABLE
1534: , p3_a6 JTF_NUMBER_TABLE
1535: , p3_a7 JTF_NUMBER_TABLE
1536: , p3_a8 JTF_DATE_TABLE