APPS.GHR_CORR_CANC_SF52 dependencies on PER_PEOPLE_EXTRA_INFO

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

4768: -- ---------------------------------------------------------------------------
4769: -- {Start Of Comments}
4770: --
4771: -- Description:
4772: -- This procedure deletes a row from per_people_extra_info table.
4773: --
4774: -- Pre-Requisities:
4775: -- None.
4776: --

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

4792: -- {End Of Comments}
4793: -- ---------------------------------------------------------------------------
4794:
4795: PROCEDURE delete_peopei_row( p_person_extra_info_id in varchar2) IS
4796: l_proc varchar2(72) := 'delete_per_people_extra_info_row';
4797: l_ovn number;
4798: cursor c_get_ovn (cp_person_extra_info_id in number) is
4799: SELECT object_version_number
4800: FROM PER_PEOPLE_EXTRA_INFO

Line 4800: FROM PER_PEOPLE_EXTRA_INFO

4796: l_proc varchar2(72) := 'delete_per_people_extra_info_row';
4797: l_ovn number;
4798: cursor c_get_ovn (cp_person_extra_info_id in number) is
4799: SELECT object_version_number
4800: FROM PER_PEOPLE_EXTRA_INFO
4801: WHERE person_extra_info_id = cp_person_extra_info_id ;
4802: BEGIN
4803: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4804: open c_get_ovn(p_person_extra_info_id);