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 326: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);

322:
323: begin
324: hr_utility.set_location('building list '||l_proc, 12);
325: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
326: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
327: --WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',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);

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

323: begin
324: hr_utility.set_location('building list '||l_proc, 12);
325: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
326: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
327: --WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',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('DISPLAYNAME',p_rec.role_name,l_plist);

324: hr_utility.set_location('building list '||l_proc, 12);
325: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
326: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
327: --WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',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('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
326: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
327: --WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',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: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
327: --WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',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('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',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('DISPLAYNAME',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: if (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')

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: if (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')
337: then

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: if (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')
337: then
338: WF_EVENT.AddParameterToList('UPDATEONLY','TRUE',l_plist);

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: if (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')
337: then
338: WF_EVENT.AddParameterToList('UPDATEONLY','TRUE',l_plist);
339: end if;

Line 338: WF_EVENT.AddParameterToList('UPDATEONLY','TRUE',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: if (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')
337: then
338: WF_EVENT.AddParameterToList('UPDATEONLY','TRUE',l_plist);
339: end if;
340:
341: hr_utility.set_location('calling sync role '||l_proc, 14);
342: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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