100: RAISE NO_DATA_FOUND;
101: end if;
102: CLOSE C;
103:
104: wf_local_synch.propagate_user_role(
105: p_user_orig_system => 'PER',
106: p_user_orig_system_id => x_employee_Id,
107: p_role_orig_system => 'ENG_LIST',
108: p_role_orig_system_id => x_approval_List_Id,
299: -- Bug 3817690
300: -- If the employee itself is being updated, then disable the old employee
301: IF (l_old_employee_id <> X_Employee_Id)
302: THEN
303: wf_local_synch.propagate_user_role(
304: p_user_orig_system => 'PER',
305: p_user_orig_system_id => l_old_employee_id,
306: p_role_orig_system => 'ENG_LIST',
307: p_role_orig_system_id => x_approval_List_Id,
309: p_expiration_date => sysdate,
310: p_overwrite => TRUE);
311: END IF;
312:
313: wf_local_synch.propagate_user_role(
314: p_user_orig_system => 'PER',
315: p_user_orig_system_id => x_employee_Id,
316: p_role_orig_system => 'ENG_LIST',
317: p_role_orig_system_id => x_approval_List_Id,
374: role_orig_system_id => l_approval_list_id);
375: -- adding ends here Bug #3342686
376: */
377:
378: wf_local_synch.propagate_user_role(
379: p_user_orig_system => 'PER',
380: p_user_orig_system_id => l_employee_id,
381: p_role_orig_system => 'ENG_LIST',
382: p_role_orig_system_id => l_approval_list_id,