APPS.GHR_CORR_CANC_SF52 dependencies on PER_ADDRESSES

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

4931: -- ---------------------------------------------------------------------------
4932: -- {Start Of Comments}
4933: --
4934: -- Description:
4935: -- This procedure deletes a row from per_addresses table.
4936: --
4937: -- Pre-Requisities:
4938: -- None.
4939: --

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

4940: -- In Parameters:
4941: -- p_address_id -> address_id to be deleted.
4942: --
4943: -- Post Success:
4944: -- per_addresses row will have been deleted.
4945: --
4946: -- Post Failure:
4947: -- message will have been displayed to user explaining why the delete could not be completed.
4948: --

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

4956: -- ---------------------------------------------------------------------------
4957:
4958: PROCEDURE delete_address_row( p_address_id in varchar2) IS
4959:
4960: l_proc varchar2(72) := 'delete_per_addresses_row';
4961: l_ovn number;
4962: cursor c_get_ovn (cp_address_id in number) is
4963: SELECT object_version_number
4964: FROM PER_ADDRESSES

Line 4964: FROM PER_ADDRESSES

4960: l_proc varchar2(72) := 'delete_per_addresses_row';
4961: l_ovn number;
4962: cursor c_get_ovn (cp_address_id in number) is
4963: SELECT object_version_number
4964: FROM PER_ADDRESSES
4965: WHERE address_id = cp_address_id ;
4966:
4967: BEGIN
4968: hr_utility.set_location( 'Entering : ' || l_proc, 10);