APPS.HR_CHANGE_START_DATE_API dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 490: from per_spinal_point_placements_f sp,

486: ,p_type VARCHAR2) is
487: cursor csr_sp_placement_pds is
488: select 'x' from dual where exists
489: (select 1
490: from per_spinal_point_placements_f sp,
491: per_periods_of_service p,
492: per_assignments_f a
493: where a.person_id = p_person_id
494: and a.period_of_service_id = p.period_of_service_id

Line 518: from per_spinal_point_placements_f sp,

514: --
515: cursor csr_sp_placement_pdp is
516: select 'x' from dual where exists
517: (select 1
518: from per_spinal_point_placements_f sp,
519: per_periods_of_placement p,
520: per_assignments_f a
521: where a.person_id = p_person_id
522: and a.period_of_placement_date_start = p.date_start

Line 1362: from per_spinal_point_placements_f sp

1358: ,p_new_start_date date
1359: ,p_type VARCHAR2) is
1360: cursor csr_ssp is
1361: select placement_id
1362: from per_spinal_point_placements_f sp
1363: where assignment_id in (select a.assignment_id
1364: from per_assignments_f a
1365: where person_id = p_person_id
1366: and a.assignment_type = p_type

Line 1370: l_sp_id per_spinal_point_placements_f.placement_id%TYPE;

1366: and a.assignment_type = p_type
1367: and a.effective_start_date = p_old_start_date)
1368: and sp.effective_start_date = p_old_start_date;
1369: --
1370: l_sp_id per_spinal_point_placements_f.placement_id%TYPE;
1371: --
1372: begin
1373: open csr_ssp;
1374: loop

Line 1377: update per_spinal_point_placements_f

1373: open csr_ssp;
1374: loop
1375: fetch csr_ssp into l_sp_id;
1376: exit when csr_ssp%NOTFOUND;
1377: update per_spinal_point_placements_f
1378: set effective_start_date = p_new_start_date
1379: where effective_start_date = p_old_start_date
1380: and placement_id = l_sp_id;
1381: if sql%rowcount <1 then

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

1379: where effective_start_date = p_old_start_date
1380: and placement_id = l_sp_id;
1381: if sql%rowcount <1 then
1382: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1383: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
1384: hr_utility.raise_error;
1385: end if;
1386: end loop;
1387: close csr_ssp;