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_CAL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_400
19: , a3 JTF_VARCHAR2_TABLE_100
20: ) as
21: ddindx binary_integer; indx binary_integer;

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_400
19: , a3 JTF_VARCHAR2_TABLE_100
20: ) as
21: ddindx binary_integer; indx binary_integer;
22: begin
23: if a0 is not null and a0.count > 0 then

Line 42: , a1 out nocopy JTF_VARCHAR2_TABLE_100

38: end if;
39: end if;
40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;

Line 44: , a3 out nocopy JTF_VARCHAR2_TABLE_100

40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_400
44: , a3 out nocopy JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then

Line 50: a1 := JTF_VARCHAR2_TABLE_100();

46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_400();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: else
54: a0 := JTF_NUMBER_TABLE();

Line 52: a3 := JTF_VARCHAR2_TABLE_100();

48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_400();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_VARCHAR2_TABLE_400();

Line 55: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 57: a3 := JTF_VARCHAR2_TABLE_100();

53: else
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_VARCHAR2_TABLE_400();
57: a3 := JTF_VARCHAR2_TABLE_100();
58: if t.count > 0 then
59: a0.extend(t.count);
60: a1.extend(t.count);
61: a2.extend(t.count);

Line 132: , a2 JTF_VARCHAR2_TABLE_100

128: end rosetta_table_copy_out_p3;
129:
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200

Line 133: , a3 JTF_VARCHAR2_TABLE_100

129:
130: procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_VARCHAR2_TABLE_100
134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE

Line 138: , a8 JTF_VARCHAR2_TABLE_100

134: , a4 JTF_NUMBER_TABLE
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_VARCHAR2_TABLE_200
137: , a7 JTF_NUMBER_TABLE
138: , a8 JTF_VARCHAR2_TABLE_100
139: , a9 JTF_NUMBER_TABLE
140: , a10 JTF_NUMBER_TABLE
141: , a11 JTF_DATE_TABLE
142: , a12 JTF_DATE_TABLE

Line 146: , a16 JTF_VARCHAR2_TABLE_100

142: , a12 JTF_DATE_TABLE
143: , a13 JTF_VARCHAR2_TABLE_2000
144: , a14 JTF_VARCHAR2_TABLE_2000
145: , a15 JTF_NUMBER_TABLE
146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE

Line 149: , a19 JTF_VARCHAR2_TABLE_100

145: , a15 JTF_NUMBER_TABLE
146: , a16 JTF_VARCHAR2_TABLE_100
147: , a17 JTF_NUMBER_TABLE
148: , a18 JTF_VARCHAR2_TABLE_300
149: , a19 JTF_VARCHAR2_TABLE_100
150: , a20 JTF_NUMBER_TABLE
151: , a21 JTF_NUMBER_TABLE
152: , a22 JTF_NUMBER_TABLE
153: ) as

Line 195: , a2 out nocopy JTF_VARCHAR2_TABLE_100

191: end if;
192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 196: , a3 out nocopy JTF_VARCHAR2_TABLE_100

192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
194: , a1 out nocopy JTF_NUMBER_TABLE
195: , a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , a3 out nocopy JTF_VARCHAR2_TABLE_100
197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE

Line 201: , a8 out nocopy JTF_VARCHAR2_TABLE_100

197: , a4 out nocopy JTF_NUMBER_TABLE
198: , a5 out nocopy JTF_NUMBER_TABLE
199: , a6 out nocopy JTF_VARCHAR2_TABLE_200
200: , a7 out nocopy JTF_NUMBER_TABLE
201: , a8 out nocopy JTF_VARCHAR2_TABLE_100
202: , a9 out nocopy JTF_NUMBER_TABLE
203: , a10 out nocopy JTF_NUMBER_TABLE
204: , a11 out nocopy JTF_DATE_TABLE
205: , a12 out nocopy JTF_DATE_TABLE

Line 209: , a16 out nocopy JTF_VARCHAR2_TABLE_100

205: , a12 out nocopy JTF_DATE_TABLE
206: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
207: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
208: , a15 out nocopy JTF_NUMBER_TABLE
209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE

Line 212: , a19 out nocopy JTF_VARCHAR2_TABLE_100

208: , a15 out nocopy JTF_NUMBER_TABLE
209: , a16 out nocopy JTF_VARCHAR2_TABLE_100
210: , a17 out nocopy JTF_NUMBER_TABLE
211: , a18 out nocopy JTF_VARCHAR2_TABLE_300
212: , a19 out nocopy JTF_VARCHAR2_TABLE_100
213: , a20 out nocopy JTF_NUMBER_TABLE
214: , a21 out nocopy JTF_NUMBER_TABLE
215: , a22 out nocopy JTF_NUMBER_TABLE
216: ) as

Line 222: a2 := JTF_VARCHAR2_TABLE_100();

218: begin
219: if t is null or t.count = 0 then
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();

Line 223: a3 := JTF_VARCHAR2_TABLE_100();

219: if t is null or t.count = 0 then
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_100();
223: a3 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();

Line 228: a8 := JTF_VARCHAR2_TABLE_100();

224: a4 := JTF_NUMBER_TABLE();
225: a5 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_200();
227: a7 := JTF_NUMBER_TABLE();
228: a8 := JTF_VARCHAR2_TABLE_100();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_DATE_TABLE();
232: a12 := JTF_DATE_TABLE();

Line 236: a16 := JTF_VARCHAR2_TABLE_100();

232: a12 := JTF_DATE_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();

Line 239: a19 := JTF_VARCHAR2_TABLE_100();

235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_NUMBER_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_100();
240: a20 := JTF_NUMBER_TABLE();
241: a21 := JTF_NUMBER_TABLE();
242: a22 := JTF_NUMBER_TABLE();
243: else

Line 246: a2 := JTF_VARCHAR2_TABLE_100();

242: a22 := JTF_NUMBER_TABLE();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();

Line 247: a3 := JTF_VARCHAR2_TABLE_100();

243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_VARCHAR2_TABLE_100();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();

Line 252: a8 := JTF_VARCHAR2_TABLE_100();

248: a4 := JTF_NUMBER_TABLE();
249: a5 := JTF_NUMBER_TABLE();
250: a6 := JTF_VARCHAR2_TABLE_200();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_NUMBER_TABLE();
254: a10 := JTF_NUMBER_TABLE();
255: a11 := JTF_DATE_TABLE();
256: a12 := JTF_DATE_TABLE();

Line 260: a16 := JTF_VARCHAR2_TABLE_100();

256: a12 := JTF_DATE_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_2000();
258: a14 := JTF_VARCHAR2_TABLE_2000();
259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();

Line 263: a19 := JTF_VARCHAR2_TABLE_100();

259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_VARCHAR2_TABLE_100();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_300();
263: a19 := JTF_VARCHAR2_TABLE_100();
264: a20 := JTF_NUMBER_TABLE();
265: a21 := JTF_NUMBER_TABLE();
266: a22 := JTF_NUMBER_TABLE();
267: if t.count > 0 then

Line 337: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

333: , p_resourceid in out nocopy NUMBER
334: , p_resourcetype in out nocopy VARCHAR2
335: , p_userid NUMBER
336: , p9_a0 out nocopy JTF_NUMBER_TABLE
337: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
339: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
340: )
341:

Line 339: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

335: , p_userid NUMBER
336: , p9_a0 out nocopy JTF_NUMBER_TABLE
337: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
339: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
340: )
341:
342: as
343: ddx_calendarlist jtf_cal_pvt.callsttbltype;

Line 402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

398: , p6_a5 DATE
399: , p6_a6 NUMBER
400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

399: , p6_a6 NUMBER
400: , p7_a0 out nocopy JTF_NUMBER_TABLE
401: , p7_a1 out nocopy JTF_NUMBER_TABLE
402: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
403: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

404: , p7_a4 out nocopy JTF_NUMBER_TABLE
405: , p7_a5 out nocopy JTF_NUMBER_TABLE
406: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
407: , p7_a7 out nocopy JTF_NUMBER_TABLE
408: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
409: , p7_a9 out nocopy JTF_NUMBER_TABLE
410: , p7_a10 out nocopy JTF_NUMBER_TABLE
411: , p7_a11 out nocopy JTF_DATE_TABLE
412: , p7_a12 out nocopy JTF_DATE_TABLE

Line 416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

412: , p7_a12 out nocopy JTF_DATE_TABLE
413: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
414: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
415: , p7_a15 out nocopy JTF_NUMBER_TABLE
416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE

Line 419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

415: , p7_a15 out nocopy JTF_NUMBER_TABLE
416: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
417: , p7_a17 out nocopy JTF_NUMBER_TABLE
418: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
419: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
420: , p7_a20 out nocopy JTF_NUMBER_TABLE
421: , p7_a21 out nocopy JTF_NUMBER_TABLE
422: , p7_a22 out nocopy JTF_NUMBER_TABLE
423: , p8_a0 out nocopy NUMBER