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_person_id number;
68: l_assignment_id number;
69: l_person_id_canonical varchar2(20);

Line 79: --per_all_people_f%rowtype cursor.

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

Line 83: from per_all_people_f

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

Line 201: p_rec in per_all_people_f%rowtype,

197: -- ----------------------------------------------------------------------------
198: --
199: --
200: procedure per_per_wf(
201: p_rec in per_all_people_f%rowtype,
202: p_action in varchar2) is
203: --
204: -- local variables
205: --

Line 727: l_rec per_all_people_f%rowtype;

723: procedure per_per_wf(
724: p_rec in per_per_shd.g_rec_type,
725: p_action in varchar2) is
726: --
727: l_rec per_all_people_f%rowtype;
728: --
729: l_party_id number(15,0);
730: --
731: cursor get_party_id(p_person_id in number) is

Line 733: from per_all_people_f

729: l_party_id number(15,0);
730: --
731: cursor get_party_id(p_person_id in number) is
732: select party_id
733: from per_all_people_f
734: where person_id = p_rec.person_id;
735: begin
736: -- 3297591 - in case party_id has since been filled... is this needed?
737: if p_rec.party_id is null

Line 751: -- per_all_people_f%rowtype

747: end if;
748: -- 3297591 was that needed?
749: --
750: -- Transfering the argument values from per_per_shd.g_rec_type to
751: -- per_all_people_f%rowtype
752: --
753: l_rec.current_employee_flag := p_rec.current_employee_flag;
754: l_rec.current_npw_flag := p_rec.current_npw_flag;
755: l_rec.person_id := p_rec.person_id;