APPS.GHR_CORR_CANC_SF52 dependencies on PER_PEOPLE_EXTRA_INFO

Line 4430: -- This procedure deletes a row from per_people_extra_info table.

4426: -- ---------------------------------------------------------------------------
4427: -- {Start Of Comments}
4428: --
4429: -- Description:
4430: -- This procedure deletes a row from per_people_extra_info table.
4431: --
4432: -- Pre-Requisities:
4433: -- None.
4434: --

Line 4454: l_proc varchar2(72) := 'delete_per_people_extra_info_row';

4450: -- {End Of Comments}
4451: -- ---------------------------------------------------------------------------
4452:
4453: PROCEDURE delete_peopei_row( p_person_extra_info_id in varchar2) IS
4454: l_proc varchar2(72) := 'delete_per_people_extra_info_row';
4455: l_ovn number;
4456: cursor c_get_ovn (cp_person_extra_info_id in number) is
4457: SELECT object_version_number
4458: FROM PER_PEOPLE_EXTRA_INFO

Line 4458: FROM PER_PEOPLE_EXTRA_INFO

4454: l_proc varchar2(72) := 'delete_per_people_extra_info_row';
4455: l_ovn number;
4456: cursor c_get_ovn (cp_person_extra_info_id in number) is
4457: SELECT object_version_number
4458: FROM PER_PEOPLE_EXTRA_INFO
4459: WHERE person_extra_info_id = cp_person_extra_info_id ;
4460: BEGIN
4461: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4462: open c_get_ovn(p_person_extra_info_id);