APPS.PER_HRWF_SYNCH dependencies on PER_PERIODS_OF_SERVICE

Line 67: l_pds_rec per_periods_of_service%rowtype;

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;
70: l_person_id_canonical varchar2(20);
71: l_assignment_id_canonical varchar2(20);

Line 89: --per_periods_of_service%rowtype cursor

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: --
89: --per_periods_of_service%rowtype cursor
90: cursor l_pds_cur is
91: Select *
92: from per_periods_of_service
93: where person_id = l_person_id

Line 92: from per_periods_of_service

88: --
89: --per_periods_of_service%rowtype cursor
90: cursor l_pds_cur is
91: Select *
92: from per_periods_of_service
93: where person_id = l_person_id
94: and trunc(date_start) = l_start_date
95: and trunc(actual_termination_date) = l_end_date;
96: --per_all_assignments_f%rowtype cursor.

Line 750: p_rec in per_periods_of_service%rowtype,

746: -- |-----------------------------< per_pds_wf >-------------------------------|
747: -- ----------------------------------------------------------------------------
748: --
749: procedure per_pds_wf(
750: p_rec in per_periods_of_service%rowtype,
751: p_date in date default null,
752: p_action in varchar2) is
753: --
754: l_proc varchar2(80) := g_package||'per_pds_wf';

Line 972: l_rec per_periods_of_service%rowtype;

968: p_date in date default null,
969: p_date_start in date,
970: p_action in varchar2) is
971: --
972: l_rec per_periods_of_service%rowtype;
973: --
974: begin
975: --
976: -- Transfering the argument values from local variables to

Line 977: -- per_periods_of_service%rowtype

973: --
974: begin
975: --
976: -- Transfering the argument values from local variables to
977: -- per_periods_of_service%rowtype
978: --
979: l_rec.person_id := p_person_id;
980: l_rec.date_start := p_date_start;
981: --