APPS.GHR_CORR_CANC_SF52 dependencies on PER_ADDRESSES

Line 4593: -- This procedure deletes a row from per_addresses table.

4589: -- ---------------------------------------------------------------------------
4590: -- {Start Of Comments}
4591: --
4592: -- Description:
4593: -- This procedure deletes a row from per_addresses table.
4594: --
4595: -- Pre-Requisities:
4596: -- None.
4597: --

Line 4602: -- per_addresses row will have been deleted.

4598: -- In Parameters:
4599: -- p_address_id -> address_id to be deleted.
4600: --
4601: -- Post Success:
4602: -- per_addresses row will have been deleted.
4603: --
4604: -- Post Failure:
4605: -- message will have been displayed to user explaining why the delete could not be completed.
4606: --

Line 4618: l_proc varchar2(72) := 'delete_per_addresses_row';

4614: -- ---------------------------------------------------------------------------
4615:
4616: PROCEDURE delete_address_row( p_address_id in varchar2) IS
4617:
4618: l_proc varchar2(72) := 'delete_per_addresses_row';
4619: l_ovn number;
4620: cursor c_get_ovn (cp_address_id in number) is
4621: SELECT object_version_number
4622: FROM PER_ADDRESSES

Line 4622: FROM PER_ADDRESSES

4618: l_proc varchar2(72) := 'delete_per_addresses_row';
4619: l_ovn number;
4620: cursor c_get_ovn (cp_address_id in number) is
4621: SELECT object_version_number
4622: FROM PER_ADDRESSES
4623: WHERE address_id = cp_address_id ;
4624:
4625: BEGIN
4626: hr_utility.set_location( 'Entering : ' || l_proc, 10);