eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_INP_BUS dependencies on PER_ADDRESSES

Line 445: -- Validates if the address id exists in PER_ADDRESSES table, if its not null

441: -- |---------------------------< chk_address_id >-----------------------------|
442: -- ----------------------------------------------------------------------------
443: --
444: -- Description:
445: -- Validates if the address id exists in PER_ADDRESSES table, if its not null
446: --
447: -- Prerequisites:
448: -- Must be called after the chk_party_id in insert_validate.
449: --

Line 456: -- If the address_id is existing in PER_ADDRESSES then continue.

452: -- p_address_id
453: -- p_object_version_number
454: --
455: -- Post Success:
456: -- If the address_id is existing in PER_ADDRESSES then continue.
457: --
458: -- Post Failure:
459: -- If the party_id does not exist in PER_ADDRESSES
460: -- then throw an error indicating the same.

Line 459: -- If the party_id does not exist in PER_ADDRESSES

455: -- Post Success:
456: -- If the address_id is existing in PER_ADDRESSES then continue.
457: --
458: -- Post Failure:
459: -- If the party_id does not exist in PER_ADDRESSES
460: -- then throw an error indicating the same.
461: --
462: -- Access Status:
463: -- Internal Row Handler Use Only.

Line 485: from per_addresses

481: l_api_updating boolean;
482: --
483: cursor csr_address_id is
484: select 1
485: from per_addresses
486: where person_id = p_person_id
487: and address_id = p_address_id;
488: --
489: Begin