eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PERZ_QUERY_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 26: , a4 JTF_VARCHAR2_TABLE_300

22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_parameter_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;

Line 57: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

53: procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
54: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
55: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
56: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
58: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
59: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;

Line 68: a4 := JTF_VARCHAR2_TABLE_300();

64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_300();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_NUMBER_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();

Line 76: a4 := JTF_VARCHAR2_TABLE_300();

72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_NUMBER_TABLE();
74: a2 := JTF_VARCHAR2_TABLE_100();
75: a3 := JTF_VARCHAR2_TABLE_100();
76: a4 := JTF_VARCHAR2_TABLE_300();
77: a5 := JTF_VARCHAR2_TABLE_100();
78: a6 := JTF_NUMBER_TABLE();
79: if t.count > 0 then
80: a0.extend(t.count);

Line 112: , a5 JTF_VARCHAR2_TABLE_300

108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_NUMBER_TABLE
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_VARCHAR2_TABLE_100
112: , a5 JTF_VARCHAR2_TABLE_300
113: , a6 JTF_VARCHAR2_TABLE_2000
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin

Line 143: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

139: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
140: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
141: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
142: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
143: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
144: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
145: ) as
146: ddindx binary_integer; indx binary_integer;
147: begin

Line 154: a5 := JTF_VARCHAR2_TABLE_300();

150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_100();
154: a5 := JTF_VARCHAR2_TABLE_300();
155: a6 := JTF_VARCHAR2_TABLE_2000();
156: else
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_NUMBER_TABLE();

Line 162: a5 := JTF_VARCHAR2_TABLE_300();

158: a1 := JTF_NUMBER_TABLE();
159: a2 := JTF_NUMBER_TABLE();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_100();
162: a5 := JTF_VARCHAR2_TABLE_300();
163: a6 := JTF_VARCHAR2_TABLE_2000();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);

Line 284: , p13_a4 JTF_VARCHAR2_TABLE_300

280: , p13_a0 JTF_NUMBER_TABLE
281: , p13_a1 JTF_NUMBER_TABLE
282: , p13_a2 JTF_VARCHAR2_TABLE_100
283: , p13_a3 JTF_VARCHAR2_TABLE_100
284: , p13_a4 JTF_VARCHAR2_TABLE_300
285: , p13_a5 JTF_VARCHAR2_TABLE_100
286: , p13_a6 JTF_NUMBER_TABLE
287: , p14_a0 JTF_NUMBER_TABLE
288: , p14_a1 JTF_NUMBER_TABLE

Line 422: , p11_a4 JTF_VARCHAR2_TABLE_300

418: , p11_a0 JTF_NUMBER_TABLE
419: , p11_a1 JTF_NUMBER_TABLE
420: , p11_a2 JTF_VARCHAR2_TABLE_100
421: , p11_a3 JTF_VARCHAR2_TABLE_100
422: , p11_a4 JTF_VARCHAR2_TABLE_300
423: , p11_a5 JTF_VARCHAR2_TABLE_100
424: , p11_a6 JTF_NUMBER_TABLE
425: , p12_a0 JTF_NUMBER_TABLE
426: , p12_a1 JTF_NUMBER_TABLE

Line 549: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

545: , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
546: , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
547: , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
548: , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
549: , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
550: , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
551: , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
552: , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
553: , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 674: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

670: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
671: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
672: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
673: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
674: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
675: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
676: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
677: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
678: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 749: , p10_a4 JTF_VARCHAR2_TABLE_300

745: , p10_a0 JTF_NUMBER_TABLE
746: , p10_a1 JTF_NUMBER_TABLE
747: , p10_a2 JTF_VARCHAR2_TABLE_100
748: , p10_a3 JTF_VARCHAR2_TABLE_100
749: , p10_a4 JTF_VARCHAR2_TABLE_300
750: , p10_a5 JTF_VARCHAR2_TABLE_100
751: , p10_a6 JTF_NUMBER_TABLE
752: , p11_a0 JTF_NUMBER_TABLE
753: , p11_a1 JTF_NUMBER_TABLE