APPS.HR_CHANGE_START_DATE_API dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 457: from per_spinal_point_placements_f sp,

453: ,p_type VARCHAR2) is
454: cursor csr_sp_placement_pds is
455: select 'x' from dual where exists
456: (select 1
457: from per_spinal_point_placements_f sp,
458: per_periods_of_service p,
459: per_assignments_f a
460: where a.person_id = p_person_id
461: and a.period_of_service_id = p.period_of_service_id

Line 472: from per_spinal_point_placements_f sp,

468: --
469: cursor csr_sp_placement_pdp is
470: select 'x' from dual where exists
471: (select 1
472: from per_spinal_point_placements_f sp,
473: per_periods_of_placement p,
474: per_assignments_f a
475: where a.person_id = p_person_id
476: and a.period_of_placement_date_start = p.date_start

Line 1014: from per_spinal_point_placements_f sp

1010: ,p_new_start_date date
1011: ,p_type VARCHAR2) is
1012: cursor csr_ssp is
1013: select placement_id
1014: from per_spinal_point_placements_f sp
1015: where assignment_id in (select a.assignment_id
1016: from per_assignments_f a
1017: where person_id = p_person_id
1018: and a.assignment_type = p_type

Line 1022: l_sp_id per_spinal_point_placements_f.placement_id%TYPE;

1018: and a.assignment_type = p_type
1019: and a.effective_start_date = p_old_start_date)
1020: and sp.effective_start_date = p_old_start_date;
1021: --
1022: l_sp_id per_spinal_point_placements_f.placement_id%TYPE;
1023: --
1024: begin
1025: open csr_ssp;
1026: loop

Line 1029: update per_spinal_point_placements_f

1025: open csr_ssp;
1026: loop
1027: fetch csr_ssp into l_sp_id;
1028: exit when csr_ssp%NOTFOUND;
1029: update per_spinal_point_placements_f
1030: set effective_start_date = p_new_start_date
1031: where effective_start_date = p_old_start_date
1032: and placement_id = l_sp_id;
1033: if sql%rowcount <1 then

Line 1035: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');

1031: where effective_start_date = p_old_start_date
1032: and placement_id = l_sp_id;
1033: if sql%rowcount <1 then
1034: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1035: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1036: hr_utility.raise_error;
1037: end if;
1038: end loop;
1039: close csr_ssp;