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_PERUSEOC_XMLP_PKG dependencies on PER_US_HR_UTILITY_PKG

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

459: G_EOL VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
460: BEGIN
461: IF P_AUDIT_REPORT = 'Y' THEN
462: FOR per IN C_PERSONS LOOP
463: /* Replaced NVL(PER.ETHNIC, ' ') with a function call to PER_US_HR_UTILITY_PKG for bug#11736960 */
464: L_BUFFER := PER.PERSON_ID || G_DELIMITER || PER.LAST_NAME || G_DELIMITER || NVL(PER.FIRST_NAME
465: ,' ') || G_DELIMITER || NVL(PER.EMPLOYEE_NUMBER
466: ,' ') || G_DELIMITER || NVL(PER.SEX
467: ,' ') || G_DELIMITER || PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PER.PERSON_ID)

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

463: /* Replaced NVL(PER.ETHNIC, ' ') with a function call to PER_US_HR_UTILITY_PKG for bug#11736960 */
464: L_BUFFER := PER.PERSON_ID || G_DELIMITER || PER.LAST_NAME || G_DELIMITER || NVL(PER.FIRST_NAME
465: ,' ') || G_DELIMITER || NVL(PER.EMPLOYEE_NUMBER
466: ,' ') || G_DELIMITER || NVL(PER.SEX
467: ,' ') || G_DELIMITER || PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PER.PERSON_ID)
468: || G_DELIMITER || PER.ASSIGNMENT_ID || G_DELIMITER || NVL(TO_CHAR(PER.JOB_ID)
469: ,' ') || G_DELIMITER || NVL(PER.JOB_NAME
470: ,' ') || G_DELIMITER || NVL(TO_CHAR(PER.LOCATION_ID)
471: ,' ') || G_DELIMITER || NVL(PER.LOCATION_CODE