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.PER_PERUSEO1_XMLP_PKG dependencies on PER_US_HR_UTILITY_PKG

Line 1368: /* Replaced NVL(PER.ETHNIC, ' ') with a function call to PER_US_HR_UTILITY_PKG for bug#11736960 */

1364: --IF (CP_REPORT_TYPE = 'Establishment Report - Type 4' OR CP_REPORT_TYPE = 'Establishment Report - Type 9') AND CP_TOT_EMPS <= P_MINIMUM_NO_OF_EMPLOYEES THEN
1365: -- RETURN NULL;
1366: --ELSE
1367: FOR per IN C_PERSONS LOOP
1368: /* Replaced NVL(PER.ETHNIC, ' ') with a function call to PER_US_HR_UTILITY_PKG for bug#11736960 */
1369: L_BUFFER := PER.PERSON_ID || G_DELIMITER || PER.LAST_NAME || G_DELIMITER || NVL(PER.FIRST_NAME
1370: ,' ') || G_DELIMITER || NVL(PER.EMPLOYEE_NUMBER
1371: ,' ') || G_DELIMITER || NVL(PER.SEX
1372: ,' ') || G_DELIMITER || PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PER.PERSON_ID)

Line 1372: ,' ') || G_DELIMITER || PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PER.PERSON_ID)

1368: /* Replaced NVL(PER.ETHNIC, ' ') with a function call to PER_US_HR_UTILITY_PKG for bug#11736960 */
1369: L_BUFFER := PER.PERSON_ID || G_DELIMITER || PER.LAST_NAME || G_DELIMITER || NVL(PER.FIRST_NAME
1370: ,' ') || G_DELIMITER || NVL(PER.EMPLOYEE_NUMBER
1371: ,' ') || G_DELIMITER || NVL(PER.SEX
1372: ,' ') || G_DELIMITER || PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PER.PERSON_ID)
1373: || G_DELIMITER || PER.ASSIGNMENT_ID || G_DELIMITER || NVL(TO_CHAR(PER.JOB_ID)
1374: ,' ') || G_DELIMITER || NVL(PER.JOB_NAME
1375: ,' ') || G_DELIMITER || NVL(TO_CHAR(PER.LOCATION_ID)
1376: ,' ') || G_DELIMITER || NVL(PER.LOCATION_CODE