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.PER_FR_WORK_CERT dependencies on PER_FR_REPORT_UTILITIES

Line 101: l_job_name1 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id1,

97: -- Job 1 Details
98: --
99: FETCH c_get_jobs into l_job_id1, l_job_definition_id1, l_job_start_date1, l_job_end_date1;
100: if l_job_definition_id1 is not null then
101: l_job_name1 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id1,
102: p_job_definition_id => l_job_definition_id1,
103: p_report_name => 'WORK_CERTIFICATE');
104: else
105: l_job_name1 := null;

Line 113: l_job_name2 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id2,

109: -- Job 2 Details
110: --
111: FETCH c_get_jobs into l_job_id2, l_job_definition_id2, l_job_start_date2, l_job_end_date2;
112: if l_job_definition_id2 is not null then
113: l_job_name2 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id2,
114: p_job_definition_id => l_job_definition_id2,
115: p_report_name => 'WORK_CERTIFICATE');
116: else
117: l_job_name2 := null;

Line 130: l_job_name2 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id2,

126: EXIT when l_job_name2 <> l_job_name1 or c_get_jobs%NOTFOUND;
127: l_prev_job_end_date := l_job_end_date2;
128: FETCH c_get_jobs into l_job_id2, l_job_definition_id2, l_job_start_date2, l_job_end_date2;
129: if l_job_definition_id2 is not null then
130: l_job_name2 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id2,
131: p_job_definition_id => l_job_definition_id2,
132: p_report_name => 'WORK_CERTIFICATE');
133: else
134: l_job_name2 := null;

Line 151: l_job_name3 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id3,

147: -- Job 3 Details
148: --
149: FETCH c_get_jobs into l_job_id3, l_job_definition_id3, l_job_start_date3, l_job_end_date3;
150: if l_job_definition_id3 is not null then
151: l_job_name3 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id3,
152: p_job_definition_id => l_job_definition_id3,
153: p_report_name => 'WORK_CERTIFICATE');
154: else
155: l_job_name3 := null;

Line 168: l_job_name3 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id3,

164: EXIT when l_job_name3 <> l_job_name2 or c_get_jobs%NOTFOUND;
165: l_prev_job_end_date := l_job_end_date3;
166: FETCH c_get_jobs into l_job_id3, l_job_definition_id3, l_job_start_date3, l_job_end_date3;
167: if l_job_definition_id3 is not null then
168: l_job_name3 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id3,
169: p_job_definition_id => l_job_definition_id3,
170: p_report_name => 'WORK_CERTIFICATE');
171: else
172: l_job_name3 := null;

Line 189: l_job_name4 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id4,

185: -- Job 4 Details
186: --
187: FETCH c_get_jobs into l_job_id4, l_job_definition_id4, l_job_start_date4, l_job_end_date4;
188: if l_job_definition_id4 is not null then
189: l_job_name4 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id4,
190: p_job_definition_id => l_job_definition_id4,
191: p_report_name => 'WORK_CERTIFICATE');
192: else
193: l_job_name4 := null;

Line 206: l_job_name4 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id4,

202: EXIT when l_job_name4 <> l_job_name3 or c_get_jobs%NOTFOUND;
203: l_prev_job_end_date := l_job_end_date4;
204: FETCH c_get_jobs into l_job_id4, l_job_definition_id4, l_job_start_date4, l_job_end_date4;
205: if l_job_definition_id4 is not null then
206: l_job_name4 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id4,
207: p_job_definition_id => l_job_definition_id4,
208: p_report_name => 'WORK_CERTIFICATE');
209: else
210: l_job_name4 := null;

Line 227: l_job_name5 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id5,

223: -- Job 5 Details
224: --
225: FETCH c_get_jobs into l_job_id5, l_job_definition_id5, l_job_start_date5, l_job_end_date5;
226: if l_job_definition_id5 is not null then
227: l_job_name5 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id5,
228: p_job_definition_id => l_job_definition_id5,
229: p_report_name => 'WORK_CERTIFICATE');
230: else
231: l_job_name5 := null;

Line 244: l_job_name5 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id5,

240: EXIT when l_job_name5 <> l_job_name4 or c_get_jobs%NOTFOUND;
241: l_prev_job_end_date := l_job_end_date5;
242: FETCH c_get_jobs into l_job_id5, l_job_definition_id5, l_job_start_date5, l_job_end_date5;
243: if l_job_definition_id5 is not null then
244: l_job_name5 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id5,
245: p_job_definition_id => l_job_definition_id5,
246: p_report_name => 'WORK_CERTIFICATE');
247: else
248: l_job_name5 := null;

Line 266: l_job_name6 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id6,

262: -- Job 6 Details
263: --
264: FETCH c_get_jobs into l_job_id6, l_job_definition_id6, l_job_start_date6, l_job_end_date6;
265: if l_job_definition_id6 is not null then
266: l_job_name6 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id6,
267: p_job_definition_id => l_job_definition_id6,
268: p_report_name => 'WORK_CERTIFICATE');
269: else
270: l_job_name6 := null;

Line 283: l_job_name6 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id6,

279: EXIT when l_job_name6 <> l_job_name5 or c_get_jobs%NOTFOUND;
280: l_prev_job_end_date := l_job_end_date6;
281: FETCH c_get_jobs into l_job_id6, l_job_definition_id6, l_job_start_date6, l_job_end_date6;
282: if l_job_definition_id6 is not null then
283: l_job_name6 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id6,
284: p_job_definition_id => l_job_definition_id6,
285: p_report_name => 'WORK_CERTIFICATE');
286: else
287: l_job_name6 := null;

Line 306: l_job_name7 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id7,

302: -- Job 7 Details
303: --
304: FETCH c_get_jobs into l_job_id7, l_job_definition_id7, l_job_start_date7, l_job_end_date7;
305: if l_job_definition_id7 is not null then
306: l_job_name7 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id7,
307: p_job_definition_id => l_job_definition_id7,
308: p_report_name => 'WORK_CERTIFICATE');
309: else
310: l_job_name7 := null;

Line 323: l_job_name7 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id7,

319: EXIT when l_job_name7 <> l_job_name6 or c_get_jobs%NOTFOUND;
320: l_prev_job_end_date := l_job_end_date7;
321: FETCH c_get_jobs into l_job_id7, l_job_definition_id7, l_job_start_date7, l_job_end_date7;
322: if l_job_definition_id7 is not null then
323: l_job_name7 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id7,
324: p_job_definition_id => l_job_definition_id7,
325: p_report_name => 'WORK_CERTIFICATE');
326: else
327: l_job_name7 := null;

Line 347: l_job_name8 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id8,

343: -- Job 8 Details
344: --
345: FETCH c_get_jobs into l_job_id8, l_job_definition_id8, l_job_start_date8, l_job_end_date8;
346: if l_job_definition_id8 is not null then
347: l_job_name8 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id8,
348: p_job_definition_id => l_job_definition_id8,
349: p_report_name => 'WORK_CERTIFICATE');
350: else
351: l_job_name8 := null;

Line 364: l_job_name8 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id8,

360: EXIT when l_job_name8 <> l_job_name7 or c_get_jobs%NOTFOUND;
361: l_prev_job_end_date := l_job_end_date8;
362: FETCH c_get_jobs into l_job_id8, l_job_definition_id8, l_job_start_date8, l_job_end_date8;
363: if l_job_definition_id8 is not null then
364: l_job_name8 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id8,
365: p_job_definition_id => l_job_definition_id8,
366: p_report_name => 'WORK_CERTIFICATE');
367: else
368: l_job_name8 := null;

Line 389: l_job_name9 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id9,

385: -- Job 9 Details
386: --
387: FETCH c_get_jobs into l_job_id9, l_job_definition_id9, l_job_start_date9, l_job_end_date9;
388: if l_job_definition_id9 is not null then
389: l_job_name9 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id9,
390: p_job_definition_id => l_job_definition_id9,
391: p_report_name => 'WORK_CERTIFICATE');
392: else
393: l_job_name9 := null;

Line 406: l_job_name9 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id9,

402: EXIT when l_job_name9 <> l_job_name8 or c_get_jobs%NOTFOUND;
403: l_prev_job_end_date := l_job_end_date9;
404: FETCH c_get_jobs into l_job_id9, l_job_definition_id9, l_job_start_date9, l_job_end_date9;
405: if l_job_definition_id9 is not null then
406: l_job_name9 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id9,
407: p_job_definition_id => l_job_definition_id9,
408: p_report_name => 'WORK_CERTIFICATE');
409: else
410: l_job_name9 := null;

Line 432: l_job_name10 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id10,

428: -- Job 10 Details
429: --
430: FETCH c_get_jobs into l_job_id10, l_job_definition_id10, l_job_start_date10, l_job_end_date10;
431: if l_job_definition_id10 is not null then
432: l_job_name10 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id10,
433: p_job_definition_id => l_job_definition_id10,
434: p_report_name => 'WORK_CERTIFICATE');
435: else
436: l_job_name10 := null;

Line 449: l_job_name10 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id10,

445: EXIT when l_job_name10 <> l_job_name9 or c_get_jobs%NOTFOUND;
446: l_prev_job_end_date := l_job_end_date10;
447: FETCH c_get_jobs into l_job_id10, l_job_definition_id10, l_job_start_date10, l_job_end_date10;
448: if l_job_definition_id10 is not null then
449: l_job_name10 := per_fr_report_utilities.get_job_names(p_job_id => l_job_id10,
450: p_job_definition_id => l_job_definition_id10,
451: p_report_name => 'WORK_CERTIFICATE');
452: else
453: l_job_name10 := null;