APPS.PER_PER_DEL dependencies on PER_ALL_PEOPLE_F

Line 71: delete from per_all_people_f

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

Line 83: delete from per_all_people_f

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

Line 236: l_per_rec per_all_people_f%rowtype;

232: p_validation_end_date in date) is
233: --
234: l_proc varchar2(72) := g_package||'pre_delete';
235: --
236: l_per_rec per_all_people_f%rowtype;
237: cursor l_per_cur is
238: select *
239: from per_all_people_f
240: where person_id = p_rec.person_id

Line 239: from per_all_people_f

235: --
236: l_per_rec per_all_people_f%rowtype;
237: cursor l_per_cur is
238: select *
239: from per_all_people_f
240: where person_id = p_rec.person_id
241: and effective_start_date = p_rec.effective_start_date
242: and effective_end_date = p_rec.effective_end_date;
243:

Line 250: from per_all_people_f

246: nvl statement in Cussor l_per_cur. */
247:
248: cursor l_per_cur1 is
249: select *
250: from per_all_people_f
251: where person_id = p_rec.person_id;
252: --
253: -- Cursor C_Sel1 select comments to be deleted
254: --

Line 257: from per_all_people_f t1

253: -- Cursor C_Sel1 select comments to be deleted
254: --
255: Cursor C_Sel1 is
256: select t1.comment_id
257: from per_all_people_f t1
258: where t1.comment_id is not null
259: and t1.person_id = p_rec.person_id
260: and t1.effective_start_date <= p_validation_end_date
261: and t1.effective_end_date >= p_validation_start_date

Line 264: from per_all_people_f t2

260: and t1.effective_start_date <= p_validation_end_date
261: and t1.effective_end_date >= p_validation_start_date
262: and not exists
263: (select 1
264: from per_all_people_f t2
265: where t2.comment_id = t1.comment_id
266: and t2.person_id = t1.person_id
267: and (t2.effective_start_date > p_validation_end_date
268: or t2.effective_end_date < p_validation_start_date));

Line 667: (p_module_name => 'per_all_people_f'

663: );
664: exception
665: when hr_api.cannot_find_prog_unit then
666: hr_api.cannot_find_prog_unit_error
667: (p_module_name => 'per_all_people_f'
668: ,p_hook_type => 'AD'
669: );
670: end;
671: -- End of API User Hook for post_delete.