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.PA_UTILS3 dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)

576: Org ID passedas a input parameter.
577: Arguments : P_Org_ID - Organization Identifier
578: Return : Operating Unit Name
579: ***************************************************************************/
580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS

Line 581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS

577: Arguments : P_Org_ID - Organization Identifier
578: Return : Operating Unit Name
579: ***************************************************************************/
580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name

Line 582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

578: Return : Operating Unit Name
579: ***************************************************************************/
580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name
586: FROM HR_ALL_ORGANIZATION_UNITS_TL

Line 584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS

580: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
581: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE IS
582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name
586: FROM HR_ALL_ORGANIZATION_UNITS_TL
587: WHERE Organization_ID = P_Org_ID
588: AND Language = USERENV('LANG');

Line 586: FROM HR_ALL_ORGANIZATION_UNITS_TL

582: l_OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
583:
584: CURSOR C_GetOUName_Cur(P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE) IS
585: SELECT Name
586: FROM HR_ALL_ORGANIZATION_UNITS_TL
587: WHERE Organization_ID = P_Org_ID
588: AND Language = USERENV('LANG');
589: BEGIN
590: IF G_OUName_Tab.COUNT > 0 THEN