DBA Data[Home] [Help]

APPS.PQH_RLS_UPD dependencies on WF_ENGINE

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 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 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 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 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',