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.PQH_RLS_UPD dependencies on WF_EVENT

Line 327: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);

323:
324: begin
325: hr_utility.set_location('building list '||l_proc, 12);
326: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
327: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
328: WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);
330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);

Line 328: WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);

324: begin
325: hr_utility.set_location('building list '||l_proc, 12);
326: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
327: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
328: WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);
330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);

Line 329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);

325: hr_utility.set_location('building list '||l_proc, 12);
326: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
327: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
328: WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);
330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);

Line 330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);

326: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
327: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
328: WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);
330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);

Line 331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);

327: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
328: WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);
330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);
335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);

Line 332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);

328: WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);
330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);
335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);
336:

Line 333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);

329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);
330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);
335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);
336:
337: hr_utility.set_location('calling sync role '||l_proc, 14);

Line 334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);

330: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref','QUERY',l_plist);
331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);
335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);
336:
337: hr_utility.set_location('calling sync role '||l_proc, 14);
338: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',

Line 335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);

331: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);
335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);
336:
337: hr_utility.set_location('calling sync role '||l_proc, 14);
338: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
339: p_orig_system_id => p_rec.role_id,

Line 348: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);

344: hr_utility.set_location('sync role done'||l_proc, 15);
345: for r1 in c1 loop
346: l_plist := null;
347: hr_utility.set_location('going persons loop '||l_proc, 17);
348: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
349: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);
350: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
351: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);
352: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);

Line 349: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);

345: for r1 in c1 loop
346: l_plist := null;
347: hr_utility.set_location('going persons loop '||l_proc, 17);
348: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
349: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);
350: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
351: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);
352: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);
353: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);

Line 350: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);

346: l_plist := null;
347: hr_utility.set_location('going persons loop '||l_proc, 17);
348: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
349: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);
350: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
351: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);
352: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);
353: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
354: hr_utility.set_location('calling sync user '||l_proc, 19);

Line 351: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);

347: hr_utility.set_location('going persons loop '||l_proc, 17);
348: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
349: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);
350: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
351: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);
352: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);
353: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
354: hr_utility.set_location('calling sync user '||l_proc, 19);
355: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',

Line 352: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);

348: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
349: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);
350: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
351: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);
352: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);
353: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
354: hr_utility.set_location('calling sync user '||l_proc, 19);
355: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
356: p_user_orig_system_id => r1.person_id,

Line 353: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);

349: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);
350: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
351: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);
352: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);
353: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
354: hr_utility.set_location('calling sync user '||l_proc, 19);
355: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
356: p_user_orig_system_id => r1.person_id,
357: p_role_orig_system => 'PQH_ROLE',

Line 379: wf_event.AddParameterToList( 'USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);

375: --
376: begin
377: l_plist := null;
378: hr_utility.set_location('building list'||l_proc, 32);
379: wf_event.AddParameterToList( 'USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
380: wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);
381: wf_event.AddParameterToList( 'EXPIRATIONDATE', to_char(l_start_date,wf_engine.date_format), l_plist);
382: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
383: for r1 in c0 loop

Line 380: wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);

376: begin
377: l_plist := null;
378: hr_utility.set_location('building list'||l_proc, 32);
379: wf_event.AddParameterToList( 'USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
380: wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);
381: wf_event.AddParameterToList( 'EXPIRATIONDATE', to_char(l_start_date,wf_engine.date_format), l_plist);
382: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
383: for r1 in c0 loop
384: hr_utility.set_location('calling sync user '||l_proc, 34);

Line 381: wf_event.AddParameterToList( 'EXPIRATIONDATE', to_char(l_start_date,wf_engine.date_format), l_plist);

377: l_plist := null;
378: hr_utility.set_location('building list'||l_proc, 32);
379: wf_event.AddParameterToList( 'USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
380: wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);
381: wf_event.AddParameterToList( 'EXPIRATIONDATE', to_char(l_start_date,wf_engine.date_format), l_plist);
382: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
383: for r1 in c0 loop
384: hr_utility.set_location('calling sync user '||l_proc, 34);
385: -- setting the expiration date to today

Line 382: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);

378: hr_utility.set_location('building list'||l_proc, 32);
379: wf_event.AddParameterToList( 'USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
380: wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);
381: wf_event.AddParameterToList( 'EXPIRATIONDATE', to_char(l_start_date,wf_engine.date_format), l_plist);
382: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
383: for r1 in c0 loop
384: hr_utility.set_location('calling sync user '||l_proc, 34);
385: -- setting the expiration date to today
386: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',

Line 394: wf_event.AddParameterToList('USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);

390: p_expiration_date => l_start_date);
391: hr_utility.set_location('sync user done'||l_proc, 36);
392: end loop;
393: l_plist := null;
394: wf_event.AddParameterToList('USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
395: wf_event.AddParameterToList('EXPIRATIONDATE', to_char(p_effective_date,wf_engine.date_format), l_plist);
396: wf_event.AddParameterToList('DELETE', 'TRUE', l_plist);
397: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
398: hr_utility.set_location('calling sync role '||l_proc, 38);

Line 395: wf_event.AddParameterToList('EXPIRATIONDATE', to_char(p_effective_date,wf_engine.date_format), l_plist);

391: hr_utility.set_location('sync user done'||l_proc, 36);
392: end loop;
393: l_plist := null;
394: wf_event.AddParameterToList('USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
395: wf_event.AddParameterToList('EXPIRATIONDATE', to_char(p_effective_date,wf_engine.date_format), l_plist);
396: wf_event.AddParameterToList('DELETE', 'TRUE', l_plist);
397: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
398: hr_utility.set_location('calling sync role '||l_proc, 38);
399: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',

Line 396: wf_event.AddParameterToList('DELETE', 'TRUE', l_plist);

392: end loop;
393: l_plist := null;
394: wf_event.AddParameterToList('USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
395: wf_event.AddParameterToList('EXPIRATIONDATE', to_char(p_effective_date,wf_engine.date_format), l_plist);
396: wf_event.AddParameterToList('DELETE', 'TRUE', l_plist);
397: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
398: hr_utility.set_location('calling sync role '||l_proc, 38);
399: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
400: p_orig_system_id => p_rec.role_id,

Line 397: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);

393: l_plist := null;
394: wf_event.AddParameterToList('USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
395: wf_event.AddParameterToList('EXPIRATIONDATE', to_char(p_effective_date,wf_engine.date_format), l_plist);
396: wf_event.AddParameterToList('DELETE', 'TRUE', l_plist);
397: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
398: hr_utility.set_location('calling sync role '||l_proc, 38);
399: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
400: p_orig_system_id => p_rec.role_id,
401: p_attributes => l_plist,