Search Results per_empdir_images_s

Overview

APPS.PER_EMPDIR_SS is a valid PL/SQL package body in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the APPS schema. It underpins the Oracle Employee Directory self-service functionality, specifically the server-side processing that assembles and refreshes the directory data set consumed by the Employee Directory web pages. The package operates against the PER_EMPDIR_% family of interface and staging tables, which cache organization, people, assignment, job, position, location, phone, and image information for directory display. The "_SS" suffix identifies it as a self-service component, and its inclusion of image-related tables (notably PER_EMPDIR_IMAGES and PER_EMPDIR_IMAGES_S, the latter matching the user's search term "per_empdir_images_s") indicates it participates in the loading or swapping of employee photograph data into the directory. The package is self-contained in the sense that it is not referenced by any other database object, though it references numerous foundation, HR, and timezone utilities, and it is reported as referenced by seven other packages within the EBS codebase.

Key Procedures and Functions

The ETRM metadata documents eight procedures or functions within this package body. Parameter lists are not published and are therefore not reproduced here.

• MAIN — The primary driver routine. It orchestrates the directory build or refresh process, invoking the supporting logic that reads source HR data and populates the PER_EMPDIR_% staging tables.
• SWAP — Performs the replacement of live directory content with newly prepared content, the classic staging-to-production exchange pattern used to minimize the window during which the directory is inconsistent.
• COMPUTE_REPORTS — Calculates or aggregates reporting-related values associated with the directory extract, supporting summary and reporting output.
• WRITE_LOG — Produces run-time log output, typically directed via FND_FILE, enabling administrators to review the outcome of a directory refresh.
• GET_TIMEZONE_ID — Resolves a timezone identifier, drawing on FND_TIMEZONES, HZ_TIMEZONE_PUB, and the FND_DATE_TZ utility, so that directory entries can display correct local times.
• GET_TIMEZONE_CODE — Returns the timezone code corresponding to a given location or context, complementing the ID lookup above.
• GET_TIME — Derives the current or effective time for a location, used to present accurate time information in the directory.

Tables Accessed

The package reads and writes the employee directory staging tables through APPS synonyms: PER_EMPDIR_ASSIGNMENTS, PER_EMPDIR_IMAGES, PER_EMPDIR_IMAGES_S, PER_EMPDIR_JOBS, PER_EMPDIR_LOCATIONS, PER_EMPDIR_LOCATIONS_TL, PER_EMPDIR_ORGANIZATIONS, PER_EMPDIR_PEOPLE, PER_EMPDIR_PHONES, and PER_EMPDIR_POSITIONS. Together these hold the denormalized directory view for fast page rendering. Source data is drawn from HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, HR_LOCATIONS_ALL_TL, HR_ORGANIZATION_INFORMATION, PER_IMAGES, and PER_PHONES. The image tables in particular connect this package to the "per_empdir_images_s" search term, since the staged image rows must be synchronized before the swap.

Usage Notes

PER_EMPDIR_SS is typically invoked from the Oracle Employee Directory self-service flow and from concurrent programs that refresh the directory cache. Because it is not referenced by any database object but is referenced by seven other packages, it functions as an internal worker rather than a public API. It relies on FND_GLOBAL, FND_PROFILE, FND_MSG_PUB, FND_INSTALLATION, and HR_MULTI_TENANCY_PKG, so correct session context and multi-tenancy setup are prerequisites. Customizations should call only through the officially exposed entry points and never modify the package body directly, as it is an Oracle-owned object.