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.WSH_ROUTING_REQUEST dependencies on HR_ORGANIZATION_UNITS

Line 4708: -- Procedure : API to validate Operating Unit. Api validate operating Unit name against HR_ORGANIZATION_UNITS table.

4704: -- Start of comments
4705: -- API name : Validate_Org
4706: -- Type : Private
4707: -- Pre-reqs : None.
4708: -- Procedure : API to validate Operating Unit. Api validate operating Unit name against HR_ORGANIZATION_UNITS table.
4709: --
4710: -- Parameters :
4711: -- IN:
4712: -- p_org_name IN Operating Unit Name.

Line 4729: FROM HR_ORGANIZATION_UNITS

4725:
4726: --Cursor to validate Operating Unit
4727: CURSOR get_org_csr(p_org_name varchar2) IS
4728: SELECT organization_id
4729: FROM HR_ORGANIZATION_UNITS
4730: WHERE name = p_org_name;
4731:
4732: BEGIN
4733: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 4745: --Validate operating Unit name against HR_ORGANIZATION_UNITS table.

4741: END IF;
4742:
4743: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4744:
4745: --Validate operating Unit name against HR_ORGANIZATION_UNITS table.
4746: OPEN get_org_csr(p_org_name);
4747: FETCH get_org_csr INTO x_org_id;
4748: CLOSE get_org_csr;
4749: