APPS.PER_HRWF_SYNCH dependencies on FND_USER

Line 252: l_user_name fnd_user.user_name%type; -- 5340008

248: l_updated_by varchar2(20);
249: l_created_by varchar2(20);
250: -- l_user_name wf_local_roles.name%type;
251: -- l_user_name varchar2(60); -- 3297591
252: l_user_name fnd_user.user_name%type; -- 5340008
253: l_per_role varchar2(200);
254: l_expiration_date varchar2(30);
255: --l_display_name wf_local_roles.display_name%TYPE;;
256: l_display_name varchar2(310); -- 3297591,4149356

Line 989: procedure sych_user_pos_role (p_in_user_name in fnd_user.user_name%type,

985: p_action => p_action);
986: --
987: end per_pds_wf;
988: --
989: procedure sych_user_pos_role (p_in_user_name in fnd_user.user_name%type,
990: p_in_person_id in per_all_people_f.person_id%type,
991: p_in_start_date in fnd_user.start_date%type,
992: p_in_exp_date in fnd_user.end_date%type)
993: is

Line 991: p_in_start_date in fnd_user.start_date%type,

987: end per_pds_wf;
988: --
989: procedure sych_user_pos_role (p_in_user_name in fnd_user.user_name%type,
990: p_in_person_id in per_all_people_f.person_id%type,
991: p_in_start_date in fnd_user.start_date%type,
992: p_in_exp_date in fnd_user.end_date%type)
993: is
994:
995: l_user_name fnd_user.user_name%type;

Line 992: p_in_exp_date in fnd_user.end_date%type)

988: --
989: procedure sych_user_pos_role (p_in_user_name in fnd_user.user_name%type,
990: p_in_person_id in per_all_people_f.person_id%type,
991: p_in_start_date in fnd_user.start_date%type,
992: p_in_exp_date in fnd_user.end_date%type)
993: is
994:
995: l_user_name fnd_user.user_name%type;
996: srch_criteria_table srch_criteria;

Line 995: l_user_name fnd_user.user_name%type;

991: p_in_start_date in fnd_user.start_date%type,
992: p_in_exp_date in fnd_user.end_date%type)
993: is
994:
995: l_user_name fnd_user.user_name%type;
996: srch_criteria_table srch_criteria;
997: srch_criteria_table2 srch_criteria;
998: l_fetch_rec_count number :=0;
999: l_fetch_loop_iter number :=0;