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.PAY_EOSY_AC_PKG dependencies on HR_UTILITY

Line 52: --hr_utility.trace_on(null,'fusman');

48:
49: Begin
50:
51: l_package := 'pay_eosy_ac_pkg.range_cursor';
52: --hr_utility.trace_on(null,'fusman');
53: hr_utility.set_location('Entering.. ' || l_package,10);
54:
55: sqlstr:=
56: 'select distinct paf.person_id

Line 53: hr_utility.set_location('Entering.. ' || l_package,10);

49: Begin
50:
51: l_package := 'pay_eosy_ac_pkg.range_cursor';
52: --hr_utility.trace_on(null,'fusman');
53: hr_utility.set_location('Entering.. ' || l_package,10);
54:
55: sqlstr:=
56: 'select distinct paf.person_id
57: from pay_payroll_actions ppa, -- pyugen

Line 109: hr_utility.trace('pactid = ' || pactid);

105: WHERE person_id = paf.person_id
106: AND per_information1 is not null)*/
107: order by paf.person_id';
108:
109: hr_utility.trace('pactid = ' || pactid);
110: hr_utility.set_location('Leaving.. ' || l_package,20);
111: --hr_utility.trace_off;
112: END range_cursor;
113:

Line 110: hr_utility.set_location('Leaving.. ' || l_package,20);

106: AND per_information1 is not null)*/
107: order by paf.person_id';
108:
109: hr_utility.trace('pactid = ' || pactid);
110: hr_utility.set_location('Leaving.. ' || l_package,20);
111: --hr_utility.trace_off;
112: END range_cursor;
113:
114:

Line 111: --hr_utility.trace_off;

107: order by paf.person_id';
108:
109: hr_utility.trace('pactid = ' || pactid);
110: hr_utility.set_location('Leaving.. ' || l_package,20);
111: --hr_utility.trace_off;
112: END range_cursor;
113:
114:
115: ----------------------------- action_creation --------------------------------

Line 233: --hr_utility.trace_on(null,'fusman');

229: l_package varchar2(70);
230:
231: BEGIN
232:
233: --hr_utility.trace_on(null,'fusman');
234:
235: l_package := 'pay_eosy_ac_pkg.action_creation';
236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);
237: hr_utility.trace('pactid = ' || pactid);

Line 236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);

232:
233: --hr_utility.trace_on(null,'fusman');
234:
235: l_package := 'pay_eosy_ac_pkg.action_creation';
236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);
237: hr_utility.trace('pactid = ' || pactid);
238: hr_utility.trace('stperson = ' || stperson);
239: hr_utility.trace('endperson = ' || endperson);
240: hr_utility.trace('chunk = ' || chunk);

Line 237: hr_utility.trace('pactid = ' || pactid);

233: --hr_utility.trace_on(null,'fusman');
234:
235: l_package := 'pay_eosy_ac_pkg.action_creation';
236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);
237: hr_utility.trace('pactid = ' || pactid);
238: hr_utility.trace('stperson = ' || stperson);
239: hr_utility.trace('endperson = ' || endperson);
240: hr_utility.trace('chunk = ' || chunk);
241:

Line 238: hr_utility.trace('stperson = ' || stperson);

234:
235: l_package := 'pay_eosy_ac_pkg.action_creation';
236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);
237: hr_utility.trace('pactid = ' || pactid);
238: hr_utility.trace('stperson = ' || stperson);
239: hr_utility.trace('endperson = ' || endperson);
240: hr_utility.trace('chunk = ' || chunk);
241:
242: OPEN c_report_parameters(pactid);

Line 239: hr_utility.trace('endperson = ' || endperson);

235: l_package := 'pay_eosy_ac_pkg.action_creation';
236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);
237: hr_utility.trace('pactid = ' || pactid);
238: hr_utility.trace('stperson = ' || stperson);
239: hr_utility.trace('endperson = ' || endperson);
240: hr_utility.trace('chunk = ' || chunk);
241:
242: OPEN c_report_parameters(pactid);
243: FETCH c_report_parameters INTO l_end_date,l_start_date,l_version_id,l_est_id;

Line 240: hr_utility.trace('chunk = ' || chunk);

236: hr_utility.set_location('Enerring.. '||l_package||':stperson:'||stperson,10);
237: hr_utility.trace('pactid = ' || pactid);
238: hr_utility.trace('stperson = ' || stperson);
239: hr_utility.trace('endperson = ' || endperson);
240: hr_utility.trace('chunk = ' || chunk);
241:
242: OPEN c_report_parameters(pactid);
243: FETCH c_report_parameters INTO l_end_date,l_start_date,l_version_id,l_est_id;
244: CLOSE c_report_parameters;

Line 246: hr_utility.trace('l_start_date = ' || l_start_date);

242: OPEN c_report_parameters(pactid);
243: FETCH c_report_parameters INTO l_end_date,l_start_date,l_version_id,l_est_id;
244: CLOSE c_report_parameters;
245:
246: hr_utility.trace('l_start_date = ' || l_start_date);
247: hr_utility.trace('l_end_date = ' || l_end_date);
248: hr_utility.trace('l_version_id = ' || l_version_id);
249: hr_utility.trace('l_est_id = ' || l_est_id);
250:

Line 247: hr_utility.trace('l_end_date = ' || l_end_date);

243: FETCH c_report_parameters INTO l_end_date,l_start_date,l_version_id,l_est_id;
244: CLOSE c_report_parameters;
245:
246: hr_utility.trace('l_start_date = ' || l_start_date);
247: hr_utility.trace('l_end_date = ' || l_end_date);
248: hr_utility.trace('l_version_id = ' || l_version_id);
249: hr_utility.trace('l_est_id = ' || l_est_id);
250:
251: hr_utility.set_location(l_package||':stperson:'||stperson,20);

Line 248: hr_utility.trace('l_version_id = ' || l_version_id);

244: CLOSE c_report_parameters;
245:
246: hr_utility.trace('l_start_date = ' || l_start_date);
247: hr_utility.trace('l_end_date = ' || l_end_date);
248: hr_utility.trace('l_version_id = ' || l_version_id);
249: hr_utility.trace('l_est_id = ' || l_est_id);
250:
251: hr_utility.set_location(l_package||':stperson:'||stperson,20);
252: OPEN c_actions(pactid,stperson,endperson,l_start_date,

Line 249: hr_utility.trace('l_est_id = ' || l_est_id);

245:
246: hr_utility.trace('l_start_date = ' || l_start_date);
247: hr_utility.trace('l_end_date = ' || l_end_date);
248: hr_utility.trace('l_version_id = ' || l_version_id);
249: hr_utility.trace('l_est_id = ' || l_est_id);
250:
251: hr_utility.set_location(l_package||':stperson:'||stperson,20);
252: OPEN c_actions(pactid,stperson,endperson,l_start_date,
253: l_end_date,l_version_id,l_est_id);

Line 251: hr_utility.set_location(l_package||':stperson:'||stperson,20);

247: hr_utility.trace('l_end_date = ' || l_end_date);
248: hr_utility.trace('l_version_id = ' || l_version_id);
249: hr_utility.trace('l_est_id = ' || l_est_id);
250:
251: hr_utility.set_location(l_package||':stperson:'||stperson,20);
252: OPEN c_actions(pactid,stperson,endperson,l_start_date,
253: l_end_date,l_version_id,l_est_id);
254: LOOP
255: FETCH c_actions INTO lockedactid

Line 260: hr_utility.trace('In the c_actions%notfound in action cursor');

256: ,l_asgnid,l_person_id
257: ,l_gre_id,l_location_id;
258:
259: IF c_actions%notfound then
260: hr_utility.trace('In the c_actions%notfound in action cursor');
261: hr_utility.set_location(l_package||':stperson:'||stperson,30);
262: EXIT;
263: END IF;
264:

Line 261: hr_utility.set_location(l_package||':stperson:'||stperson,30);

257: ,l_gre_id,l_location_id;
258:
259: IF c_actions%notfound then
260: hr_utility.trace('In the c_actions%notfound in action cursor');
261: hr_utility.set_location(l_package||':stperson:'||stperson,30);
262: EXIT;
263: END IF;
264:
265: hr_utility.set_location(l_package||':stperson:'||stperson,40);

Line 265: hr_utility.set_location(l_package||':stperson:'||stperson,40);

261: hr_utility.set_location(l_package||':stperson:'||stperson,30);
262: EXIT;
263: END IF;
264:
265: hr_utility.set_location(l_package||':stperson:'||stperson,40);
266: --Get the assignment_action_id for creating one for each selected asact_id
267:
268: SELECT pay_assignment_actions_s.nextval
269: INTO lockingactid

Line 274: hr_utility.set_location(l_package||':stperson:'||stperson,50);

270: FROM dual;
271:
272:
273: -- insert the action record.
274: hr_utility.set_location(l_package||':stperson:'||stperson,50);
275: hr_utility.trace('asact_id = '||to_char(lockedactid));
276: hr_utility.trace('l_asgnid = '||to_char(l_asgnid));
277: hr_utility.trace('l_person_id = '||to_char(l_person_id));
278:

Line 275: hr_utility.trace('asact_id = '||to_char(lockedactid));

271:
272:
273: -- insert the action record.
274: hr_utility.set_location(l_package||':stperson:'||stperson,50);
275: hr_utility.trace('asact_id = '||to_char(lockedactid));
276: hr_utility.trace('l_asgnid = '||to_char(l_asgnid));
277: hr_utility.trace('l_person_id = '||to_char(l_person_id));
278:
279: hr_nonrun_asact.insact(lockingactid,l_asgnid,pactid,chunk,l_gre_id);

Line 276: hr_utility.trace('l_asgnid = '||to_char(l_asgnid));

272:
273: -- insert the action record.
274: hr_utility.set_location(l_package||':stperson:'||stperson,50);
275: hr_utility.trace('asact_id = '||to_char(lockedactid));
276: hr_utility.trace('l_asgnid = '||to_char(l_asgnid));
277: hr_utility.trace('l_person_id = '||to_char(l_person_id));
278:
279: hr_nonrun_asact.insact(lockingactid,l_asgnid,pactid,chunk,l_gre_id);
280: UPDATE pay_assignment_actions

Line 277: hr_utility.trace('l_person_id = '||to_char(l_person_id));

273: -- insert the action record.
274: hr_utility.set_location(l_package||':stperson:'||stperson,50);
275: hr_utility.trace('asact_id = '||to_char(lockedactid));
276: hr_utility.trace('l_asgnid = '||to_char(l_asgnid));
277: hr_utility.trace('l_person_id = '||to_char(l_person_id));
278:
279: hr_nonrun_asact.insact(lockingactid,l_asgnid,pactid,chunk,l_gre_id);
280: UPDATE pay_assignment_actions
281: SET serial_number = l_person_id,

Line 285: hr_utility.set_location(l_package||':stperson:'||stperson,60);

281: SET serial_number = l_person_id,
282: source_action_id = l_location_id
283: WHERE assignment_action_id = lockingactid;
284:
285: hr_utility.set_location(l_package||':stperson:'||stperson,60);
286: hr_utility.trace('After inserting into pay_assignment_actions, before pay_action_interlock');
287: -- insert an interlock to this action.
288:
289: hr_nonrun_asact.insint(lockingactid,lockedactid);

Line 286: hr_utility.trace('After inserting into pay_assignment_actions, before pay_action_interlock');

282: source_action_id = l_location_id
283: WHERE assignment_action_id = lockingactid;
284:
285: hr_utility.set_location(l_package||':stperson:'||stperson,60);
286: hr_utility.trace('After inserting into pay_assignment_actions, before pay_action_interlock');
287: -- insert an interlock to this action.
288:
289: hr_nonrun_asact.insint(lockingactid,lockedactid);
290: hr_utility.trace('loop ends');

Line 290: hr_utility.trace('loop ends');

286: hr_utility.trace('After inserting into pay_assignment_actions, before pay_action_interlock');
287: -- insert an interlock to this action.
288:
289: hr_nonrun_asact.insint(lockingactid,lockedactid);
290: hr_utility.trace('loop ends');
291:
292: END LOOP;
293: CLOSE c_actions;
294:

Line 295: hr_utility.trace('END action_creation');

291:
292: END LOOP;
293: CLOSE c_actions;
294:
295: hr_utility.trace('END action_creation');
296: hr_utility.set_location('Leaving.. '||l_package||':stperson:'||stperson,100);
297:
298: --hr_utility.trace_off;
299:

Line 296: hr_utility.set_location('Leaving.. '||l_package||':stperson:'||stperson,100);

292: END LOOP;
293: CLOSE c_actions;
294:
295: hr_utility.trace('END action_creation');
296: hr_utility.set_location('Leaving.. '||l_package||':stperson:'||stperson,100);
297:
298: --hr_utility.trace_off;
299:
300: END action_creation;

Line 298: --hr_utility.trace_off;

294:
295: hr_utility.trace('END action_creation');
296: hr_utility.set_location('Leaving.. '||l_package||':stperson:'||stperson,100);
297:
298: --hr_utility.trace_off;
299:
300: END action_creation;
301:
302: ---------------------------------- sort_action ----------------------------------