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.HZ_MO_GLOBAL_CACHE dependencies on HR_OPERATING_UNITS

Line 573: l_org_name hr_operating_units.name%TYPE;

569: STATUS OUT NOCOPY VARCHAR2)
570: IS
571:
572: l_org_id Number;
573: l_org_name hr_operating_units.name%TYPE;
574:
575: BEGIN
576:
577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 616: hr_operating_units hr,

612: INTO
613: l_org_id,
614: l_org_name
615: FROM
616: hr_operating_units hr,
617: ar_system_parameters s
618: WHERE
619: mo_global.check_access(hr.organization_id) = 'Y'
620: AND hr.organization_id = s.org_id

Line 638: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,MOD_validate_orgid_pub_api,'caught exception no_data_found in sql=SELECT hr.organization_id,hr.name FROM hr_operating_units hr WHERE mo_global.check_access(hr.organization_id) = "Y" AND rownum < 2');

634: EXCEPTION
635: WHEN no_data_found THEN
636:
637: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,MOD_validate_orgid_pub_api,'caught exception no_data_found in sql=SELECT hr.organization_id,hr.name FROM hr_operating_units hr WHERE mo_global.check_access(hr.organization_id) = "Y" AND rownum < 2');
639: END IF;
640:
641: --if an org is still not available let default behavior persist
642:

Line 685: hr_operating_units hr,

681: INTO
682: l_org_id,
683: l_org_name
684: FROM
685: hr_operating_units hr,
686: ar_system_parameters s
687: WHERE
688: mo_global.check_access(hr.organization_id) = 'Y'
689: AND hr.organization_id = s.org_id

Line 728: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,MOD_validate_orgid_pub_api,'caught exception no_data_found in sql=SELECT hr.organization_id,hr.name FROM hr_operating_units hr WHERE mo_global.check_access(hr.organization_id) = "Y" AND rownum < 2');

724: EXCEPTION
725: WHEN no_data_found THEN
726:
727: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
728: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,MOD_validate_orgid_pub_api,'caught exception no_data_found in sql=SELECT hr.organization_id,hr.name FROM hr_operating_units hr WHERE mo_global.check_access(hr.organization_id) = "Y" AND rownum < 2');
729: END IF;
730:
731: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
732: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,MOD_validate_orgid_pub_api,'ERROR: raising APP_EXCEPTION.RAISE_EXCEPTION');