APPS.PER_HRWF_SYNCH dependencies on PER_ALL_PEOPLE_F

Line 65: l_person_rec per_all_people_f%rowtype;

61: --
62: l_counter number;
63: l_proc varchar2(80) := g_package||'call_back';
64: l_entity varchar2(10);
65: l_person_rec per_all_people_f%rowtype;
66: l_assignment_rec per_all_assignments_f%rowtype;
67: l_pds_rec per_periods_of_service%rowtype;
68: l_person_id number;
69: l_assignment_id number;

Line 80: --per_all_people_f%rowtype cursor.

76: -- 3297591 these not really needed here
77: l_person_party_id number;
78: l_person_party_id_canonical varchar2(20);
79: --
80: --per_all_people_f%rowtype cursor.
81: --
82: cursor l_person_cur is
83: select *
84: from per_all_people_f

Line 84: from per_all_people_f

80: --per_all_people_f%rowtype cursor.
81: --
82: cursor l_person_cur is
83: select *
84: from per_all_people_f
85: where person_id = l_person_id
86: and trunc(effective_start_date) = l_start_date
87: and trunc(effective_end_date) = l_end_date;
88: --

Line 228: p_rec in per_all_people_f%rowtype,

224: -- ----------------------------------------------------------------------------
225: --
226: --
227: procedure per_per_wf(
228: p_rec in per_all_people_f%rowtype,
229: p_action in varchar2) is
230: --
231: -- local variables
232: --

Line 258: l_check_person_id per_all_people_f.person_id%type;

254: l_expiration_date varchar2(30);
255: --l_display_name wf_local_roles.display_name%TYPE;;
256: l_display_name varchar2(310); -- 3297591,4149356
257: l_update varchar(1) default 'Y'; -- Bug 4597033
258: l_check_person_id per_all_people_f.person_id%type;
259: --
260: -- cursors
261: --
262: cursor role_exists(p_person_id in number) is

Line 920: l_rec per_all_people_f%rowtype;

916: procedure per_per_wf(
917: p_rec in per_per_shd.g_rec_type,
918: p_action in varchar2) is
919: --
920: l_rec per_all_people_f%rowtype;
921: --
922: l_party_id number(15,0);
923: --
924: cursor get_party_id(p_person_id in number) is

Line 926: from per_all_people_f

922: l_party_id number(15,0);
923: --
924: cursor get_party_id(p_person_id in number) is
925: select party_id
926: from per_all_people_f
927: where person_id = p_rec.person_id;
928: begin
929: -- 3297591 - in case party_id has since been filled... is this needed?
930: if p_rec.party_id is null

Line 944: -- per_all_people_f%rowtype

940: end if;
941: -- 3297591 was that needed?
942: --
943: -- Transfering the argument values from per_per_shd.g_rec_type to
944: -- per_all_people_f%rowtype
945: --
946: l_rec.current_employee_flag := p_rec.current_employee_flag;
947: l_rec.current_npw_flag := p_rec.current_npw_flag;
948: l_rec.person_id := p_rec.person_id;

Line 990: p_in_person_id in per_all_people_f.person_id%type,

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
994: