APPS.PER_SPP_DEL dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 71: delete from per_spinal_point_placements_f

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from per_spinal_point_placements_f
72: where placement_id = p_rec.placement_id
73: and effective_start_date = p_validation_start_date;
74: --
75: per_spp_shd.g_api_dml := false; -- Unset the api dml status

Line 82: delete from per_spinal_point_placements_f

78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --
82: delete from per_spinal_point_placements_f
83: where placement_id = p_rec.placement_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: per_spp_shd.g_api_dml := false; -- Unset the api dml status

Line 315: from per_spinal_point_placements_f

311: -- records in the table per_spinal_point_steps_f
312: --
313: cursor c_next_placement_st_date is
314: select min(effective_start_date)
315: from per_spinal_point_placements_f
316: where assignment_id = p_rec.assignment_id
317: and effective_start_date > p_rec.effective_start_date;
318: -- changes end for 7457065
319: --

Line 341: update per_spinal_point_placements_f

337: fnd_message.set_token('END_DATE',l_step_end_date);
338: fnd_message.raise_error;
339: end if;
340: else
341: update per_spinal_point_placements_f
342: set effective_end_date = l_step_end_date
343: where placement_id = p_rec.placement_id
344: and effective_start_date = p_rec.effective_start_date;
345: end if;

Line 433: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'

429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
434: ,p_hook_type => 'AD');
435: --
436: end;
437: --