58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the psp_eff_report_approvals row.
63: --
64: delete from psp_eff_report_approvals
65: where effort_report_approval_id = p_rec.effort_report_approval_id;
66: --
60: --
61: --
62: -- Delete the psp_eff_report_approvals row.
63: --
64: delete from psp_eff_report_approvals
65: where effort_report_approval_id = p_rec.effort_report_approval_id;
66: --
67: --
68: --
272: --
273: when hr_api.cannot_find_prog_unit then
274: --
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'PSP_EFF_REPORT_APPROVALS'
277: ,p_hook_type => 'AD');
278: --
279: end;
280: --