DBA Data[Home] [Help]

APPS.PQH_RLS_INS dependencies on WF_EVENT

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

314: declare
315: l_plist wf_parameter_list_t;
316: begin
317: hr_utility.set_location('Before calling WF_SYNC parameters:'||l_proc, 5);
318: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);
320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);

Line 319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);

315: l_plist wf_parameter_list_t;
316: begin
317: hr_utility.set_location('Before calling WF_SYNC parameters:'||l_proc, 5);
318: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);
320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);

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

316: begin
317: hr_utility.set_location('Before calling WF_SYNC parameters:'||l_proc, 5);
318: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);
320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);

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

317: hr_utility.set_location('Before calling WF_SYNC parameters:'||l_proc, 5);
318: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);
320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);

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

318: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);
320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);
326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);

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

319: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name, l_plist);
320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);
326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);
327: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);

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

320: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name, l_plist);
321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);
326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);
327: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
328:

Line 325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);

321: WF_EVENT.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_plist);
322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);
326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);
327: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
328:
329: hr_utility.set_location('Before calling WF_SYNC package role:'|| p_rec.role_id, 5);

Line 326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);

322: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE', l_plist);
323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);
326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);
327: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
328:
329: hr_utility.set_location('Before calling WF_SYNC package role:'|| p_rec.role_id, 5);
330: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',

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

323: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
324: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
325: WF_EVENT.AddParameterToList('ExpirationDate',to_char(null),l_plist);
326: WF_EVENT.AddParameterToList('StartDate',to_char(p_effective_date,wf_engine.date_format),l_plist);
327: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
328:
329: hr_utility.set_location('Before calling WF_SYNC package role:'|| p_rec.role_id, 5);
330: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
331: p_orig_system_id => p_rec.role_id,