DBA Data[Home] [Help]

APPS.EAM_PMDEF_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: EAMWPMDB.pls 120.2 2005/10/14 12:11:19 hkarmach noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_pmdef_pub.pm_activities_grp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: ) as

Line 37: , a3 out nocopy JTF_VARCHAR2_TABLE_100

33: end rosetta_table_copy_in_p2;
34: procedure rosetta_table_copy_out_p2(t eam_pmdef_pub.pm_activities_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_DATE_TABLE
41: ) as

Line 48: a3 := JTF_VARCHAR2_TABLE_100();

44: if t is null or t.count = 0 then
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_NUMBER_TABLE();
47: a2 := JTF_NUMBER_TABLE();
48: a3 := JTF_VARCHAR2_TABLE_100();
49: a4 := JTF_NUMBER_TABLE();
50: a5 := JTF_DATE_TABLE();
51: a6 := JTF_DATE_TABLE();
52: else

Line 56: a3 := JTF_VARCHAR2_TABLE_100();

52: else
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_NUMBER_TABLE();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_VARCHAR2_TABLE_100();
57: a4 := JTF_NUMBER_TABLE();
58: a5 := JTF_DATE_TABLE();
59: a6 := JTF_DATE_TABLE();
60: if t.count > 0 then

Line 100: , a12 JTF_VARCHAR2_TABLE_100

96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_DATE_TABLE
98: , a10 JTF_DATE_TABLE
99: , a11 JTF_DATE_TABLE
100: , a12 JTF_VARCHAR2_TABLE_100
101: ) as
102: ddindx binary_integer; indx binary_integer;
103: begin
104: if a0 is not null and a0.count > 0 then

Line 143: , a12 out nocopy JTF_VARCHAR2_TABLE_100

139: , a8 out nocopy JTF_NUMBER_TABLE
140: , a9 out nocopy JTF_DATE_TABLE
141: , a10 out nocopy JTF_DATE_TABLE
142: , a11 out nocopy JTF_DATE_TABLE
143: , a12 out nocopy JTF_VARCHAR2_TABLE_100
144: ) as
145: ddindx binary_integer; indx binary_integer;
146: begin
147: if t is null or t.count = 0 then

Line 160: a12 := JTF_VARCHAR2_TABLE_100();

156: a8 := JTF_NUMBER_TABLE();
157: a9 := JTF_DATE_TABLE();
158: a10 := JTF_DATE_TABLE();
159: a11 := JTF_DATE_TABLE();
160: a12 := JTF_VARCHAR2_TABLE_100();
161: else
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_NUMBER_TABLE();
164: a2 := JTF_NUMBER_TABLE();

Line 174: a12 := JTF_VARCHAR2_TABLE_100();

170: a8 := JTF_NUMBER_TABLE();
171: a9 := JTF_DATE_TABLE();
172: a10 := JTF_DATE_TABLE();
173: a11 := JTF_DATE_TABLE();
174: a12 := JTF_VARCHAR2_TABLE_100();
175: if t.count > 0 then
176: a0.extend(t.count);
177: a1.extend(t.count);
178: a2.extend(t.count);

Line 432: , p8_a3 JTF_VARCHAR2_TABLE_100

428: , p7_a47 NUMBER
429: , p8_a0 JTF_NUMBER_TABLE
430: , p8_a1 JTF_NUMBER_TABLE
431: , p8_a2 JTF_NUMBER_TABLE
432: , p8_a3 JTF_VARCHAR2_TABLE_100
433: , p8_a4 JTF_NUMBER_TABLE
434: , p8_a5 JTF_DATE_TABLE
435: , p8_a6 JTF_DATE_TABLE
436: , p9_a0 JTF_NUMBER_TABLE

Line 448: , p9_a12 JTF_VARCHAR2_TABLE_100

444: , p9_a8 JTF_NUMBER_TABLE
445: , p9_a9 JTF_DATE_TABLE
446: , p9_a10 JTF_DATE_TABLE
447: , p9_a11 JTF_DATE_TABLE
448: , p9_a12 JTF_VARCHAR2_TABLE_100
449: , p10_a0 JTF_NUMBER_TABLE
450: , p10_a1 JTF_NUMBER_TABLE
451: , p10_a2 JTF_NUMBER_TABLE
452: , p10_a3 JTF_NUMBER_TABLE

Line 461: , p10_a12 JTF_VARCHAR2_TABLE_100

457: , p10_a8 JTF_NUMBER_TABLE
458: , p10_a9 JTF_DATE_TABLE
459: , p10_a10 JTF_DATE_TABLE
460: , p10_a11 JTF_DATE_TABLE
461: , p10_a12 JTF_VARCHAR2_TABLE_100
462: , p11_a0 JTF_NUMBER_TABLE
463: , p11_a1 JTF_NUMBER_TABLE
464: , p11_a2 JTF_NUMBER_TABLE
465: , p11_a3 JTF_NUMBER_TABLE

Line 474: , p11_a12 JTF_VARCHAR2_TABLE_100

470: , p11_a8 JTF_NUMBER_TABLE
471: , p11_a9 JTF_DATE_TABLE
472: , p11_a10 JTF_DATE_TABLE
473: , p11_a11 JTF_DATE_TABLE
474: , p11_a12 JTF_VARCHAR2_TABLE_100
475: , x_new_pm_schedule_id out nocopy NUMBER
476: )
477:
478: as

Line 687: , p8_a3 JTF_VARCHAR2_TABLE_100

683: , p7_a47 NUMBER
684: , p8_a0 JTF_NUMBER_TABLE
685: , p8_a1 JTF_NUMBER_TABLE
686: , p8_a2 JTF_NUMBER_TABLE
687: , p8_a3 JTF_VARCHAR2_TABLE_100
688: , p8_a4 JTF_NUMBER_TABLE
689: , p8_a5 JTF_DATE_TABLE
690: , p8_a6 JTF_DATE_TABLE
691: , p9_a0 JTF_NUMBER_TABLE

Line 703: , p9_a12 JTF_VARCHAR2_TABLE_100

699: , p9_a8 JTF_NUMBER_TABLE
700: , p9_a9 JTF_DATE_TABLE
701: , p9_a10 JTF_DATE_TABLE
702: , p9_a11 JTF_DATE_TABLE
703: , p9_a12 JTF_VARCHAR2_TABLE_100
704: , p10_a0 JTF_NUMBER_TABLE
705: , p10_a1 JTF_NUMBER_TABLE
706: , p10_a2 JTF_NUMBER_TABLE
707: , p10_a3 JTF_NUMBER_TABLE

Line 716: , p10_a12 JTF_VARCHAR2_TABLE_100

712: , p10_a8 JTF_NUMBER_TABLE
713: , p10_a9 JTF_DATE_TABLE
714: , p10_a10 JTF_DATE_TABLE
715: , p10_a11 JTF_DATE_TABLE
716: , p10_a12 JTF_VARCHAR2_TABLE_100
717: , p11_a0 JTF_NUMBER_TABLE
718: , p11_a1 JTF_NUMBER_TABLE
719: , p11_a2 JTF_NUMBER_TABLE
720: , p11_a3 JTF_NUMBER_TABLE

Line 729: , p11_a12 JTF_VARCHAR2_TABLE_100

725: , p11_a8 JTF_NUMBER_TABLE
726: , p11_a9 JTF_DATE_TABLE
727: , p11_a10 JTF_DATE_TABLE
728: , p11_a11 JTF_DATE_TABLE
729: , p11_a12 JTF_VARCHAR2_TABLE_100
730: )
731:
732: as
733: ddp_pm_schedule_rec eam_pmdef_pub.pm_scheduling_rec_type;

Line 1174: , p0_a12 JTF_VARCHAR2_TABLE_100

1170: , p0_a8 JTF_NUMBER_TABLE
1171: , p0_a9 JTF_DATE_TABLE
1172: , p0_a10 JTF_DATE_TABLE
1173: , p0_a11 JTF_DATE_TABLE
1174: , p0_a12 JTF_VARCHAR2_TABLE_100
1175: , x_reason_failed out nocopy VARCHAR2
1176: , ddrosetta_retval_bool OUT NOCOPY NUMBER
1177: )
1178:

Line 1228: , p0_a12 JTF_VARCHAR2_TABLE_100

1224: , p0_a8 JTF_NUMBER_TABLE
1225: , p0_a9 JTF_DATE_TABLE
1226: , p0_a10 JTF_DATE_TABLE
1227: , p0_a11 JTF_DATE_TABLE
1228: , p0_a12 JTF_VARCHAR2_TABLE_100
1229: , x_reason_failed out nocopy VARCHAR2
1230: , ddrosetta_retval_bool OUT NOCOPY NUMBER
1231: )
1232:

Line 1282: , p0_a12 JTF_VARCHAR2_TABLE_100

1278: , p0_a8 JTF_NUMBER_TABLE
1279: , p0_a9 JTF_DATE_TABLE
1280: , p0_a10 JTF_DATE_TABLE
1281: , p0_a11 JTF_DATE_TABLE
1282: , p0_a12 JTF_VARCHAR2_TABLE_100
1283: , x_reason_failed out nocopy VARCHAR2
1284: , ddrosetta_retval_bool OUT NOCOPY NUMBER
1285: )
1286:

Line 1384: , p1_a12 JTF_VARCHAR2_TABLE_100

1380: , p1_a8 JTF_NUMBER_TABLE
1381: , p1_a9 JTF_DATE_TABLE
1382: , p1_a10 JTF_DATE_TABLE
1383: , p1_a11 JTF_DATE_TABLE
1384: , p1_a12 JTF_VARCHAR2_TABLE_100
1385: , p2_a0 JTF_NUMBER_TABLE
1386: , p2_a1 JTF_NUMBER_TABLE
1387: , p2_a2 JTF_NUMBER_TABLE
1388: , p2_a3 JTF_NUMBER_TABLE

Line 1397: , p2_a12 JTF_VARCHAR2_TABLE_100

1393: , p2_a8 JTF_NUMBER_TABLE
1394: , p2_a9 JTF_DATE_TABLE
1395: , p2_a10 JTF_DATE_TABLE
1396: , p2_a11 JTF_DATE_TABLE
1397: , p2_a12 JTF_VARCHAR2_TABLE_100
1398: , p3_a0 JTF_NUMBER_TABLE
1399: , p3_a1 JTF_NUMBER_TABLE
1400: , p3_a2 JTF_NUMBER_TABLE
1401: , p3_a3 JTF_NUMBER_TABLE

Line 1410: , p3_a12 JTF_VARCHAR2_TABLE_100

1406: , p3_a8 JTF_NUMBER_TABLE
1407: , p3_a9 JTF_DATE_TABLE
1408: , p3_a10 JTF_DATE_TABLE
1409: , p3_a11 JTF_DATE_TABLE
1410: , p3_a12 JTF_VARCHAR2_TABLE_100
1411: , x_reason_failed out nocopy VARCHAR2
1412: , ddrosetta_retval_bool OUT NOCOPY NUMBER
1413: )
1414:

Line 1559: , p1_a12 JTF_VARCHAR2_TABLE_100

1555: , p1_a8 JTF_NUMBER_TABLE
1556: , p1_a9 JTF_DATE_TABLE
1557: , p1_a10 JTF_DATE_TABLE
1558: , p1_a11 JTF_DATE_TABLE
1559: , p1_a12 JTF_VARCHAR2_TABLE_100
1560: , p2_a0 NUMBER
1561: , p2_a1 NUMBER
1562: , p2_a2 VARCHAR2
1563: , p2_a3 DATE

Line 1862: , p0_a3 JTF_VARCHAR2_TABLE_100

1858:
1859: procedure validate_pm_activities(p0_a0 JTF_NUMBER_TABLE
1860: , p0_a1 JTF_NUMBER_TABLE
1861: , p0_a2 JTF_NUMBER_TABLE
1862: , p0_a3 JTF_VARCHAR2_TABLE_100
1863: , p0_a4 JTF_NUMBER_TABLE
1864: , p0_a5 JTF_DATE_TABLE
1865: , p0_a6 JTF_DATE_TABLE
1866: , p1_a0 JTF_NUMBER_TABLE

Line 1878: , p1_a12 JTF_VARCHAR2_TABLE_100

1874: , p1_a8 JTF_NUMBER_TABLE
1875: , p1_a9 JTF_DATE_TABLE
1876: , p1_a10 JTF_DATE_TABLE
1877: , p1_a11 JTF_DATE_TABLE
1878: , p1_a12 JTF_VARCHAR2_TABLE_100
1879: , p2_a0 NUMBER
1880: , p2_a1 NUMBER
1881: , p2_a2 VARCHAR2
1882: , p2_a3 DATE

Line 2124: , p0_a12 JTF_VARCHAR2_TABLE_100

2120: , p0_a8 JTF_NUMBER_TABLE
2121: , p0_a9 JTF_DATE_TABLE
2122: , p0_a10 JTF_DATE_TABLE
2123: , p0_a11 JTF_DATE_TABLE
2124: , p0_a12 JTF_VARCHAR2_TABLE_100
2125: , p1_a0 JTF_NUMBER_TABLE
2126: , p1_a1 JTF_NUMBER_TABLE
2127: , p1_a2 JTF_NUMBER_TABLE
2128: , p1_a3 JTF_NUMBER_TABLE

Line 2137: , p1_a12 JTF_VARCHAR2_TABLE_100

2133: , p1_a8 JTF_NUMBER_TABLE
2134: , p1_a9 JTF_DATE_TABLE
2135: , p1_a10 JTF_DATE_TABLE
2136: , p1_a11 JTF_DATE_TABLE
2137: , p1_a12 JTF_VARCHAR2_TABLE_100
2138: , p2_a0 out nocopy JTF_NUMBER_TABLE
2139: , p2_a1 out nocopy JTF_NUMBER_TABLE
2140: , p2_a2 out nocopy JTF_NUMBER_TABLE
2141: , p2_a3 out nocopy JTF_NUMBER_TABLE

Line 2150: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100

2146: , p2_a8 out nocopy JTF_NUMBER_TABLE
2147: , p2_a9 out nocopy JTF_DATE_TABLE
2148: , p2_a10 out nocopy JTF_DATE_TABLE
2149: , p2_a11 out nocopy JTF_DATE_TABLE
2150: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
2151: )
2152:
2153: as
2154: ddp_rules_tbl1 eam_pmdef_pub.pm_rule_tbl_type;