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.OKC_REP_UTIL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1587: FROM hr_all_organization_units

1583: AND document_type_class = 'REPOSITORY';
1584:
1585: CURSOR internal_party_exist_csr IS
1586: SELECT organization_id
1587: FROM hr_all_organization_units
1588: WHERE UPPER(name) = UPPER(p_party_name);
1589:
1590: CURSOR tca_party_exist_csr IS
1591: SELECT party_id

Line 1624: FROM hr_all_organization_units

1620: AND party_role_code = p_party_role_code;
1621:
1622: CURSOR internal_party_and_role_csr IS
1623: SELECT 1
1624: FROM hr_all_organization_units
1625: WHERE UPPER(name) = UPPER(p_party_name)
1626: AND organization_id = p_party_id;
1627:
1628: CURSOR tca_party_and_role_csr IS

Line 2030: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HR_ALL_ORGANIZATION_UNITS');

2026: IF internal_party_and_role_csr%NOTFOUND THEN
2027:
2028: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2030: 'Party with id' || p_party_id || ' and name ' || p_party_name || 'not found in table HR_ALL_ORGANIZATION_UNITS');
2031: END IF;
2032:
2033: CLOSE internal_party_and_role_csr;
2034:

Line 4066: FROM HR_ALL_ORGANIZATION_UNITS

4062: AND bus_doc.document_type_class = 'REPOSITORY';
4063:
4064: CURSOR ORG_NAME_CSR (p_org_name VARCHAR2) IS
4065: SELECT ORGANIZATION_ID
4066: FROM HR_ALL_ORGANIZATION_UNITS
4067: WHERE UPPER(NAME) = UPPER(p_org_name)
4068: AND mo_global.check_access(ORGANIZATION_ID) = 'Y';
4069:
4070: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS