Search Results c_count_holders1formula

Overview

APPS.PER_PERRPRPH_XMLP_PKG is the generated PL/SQL package that backs the Oracle HRMS "Position Hierarchy Report" concurrent program in Oracle E-Business Suite 12.1.1 and 12.2.2. The package follows the standard Oracle Reports XML Publisher (XMLP) wrapper pattern: it declares the report's user-entered and derived parameters as package globals and exposes a small set of data-retrieval and formula functions executed at defined report lifecycle events. The "PER" prefix identifies the Human Resources product, the "XMLP" suffix the report-integration layer, and the "RPRPH" stem the Position Hierarchy report (Reporting Position Hierarchy). Its role is to resolve runtime selections — business group, session date, position hierarchy name, structure version, and parent position — and to compute derived values such as hierarchy names, child/subordinate counts, and holder counts that are formatted into the report output.

Key Procedures and Functions

The package exposes seventeen documented functions. Two are report event handlers: BeforeReport performs parameter validation and session setup, and AfterReport performs post-report cleanup. Nine functions are formula columns computed during report execution: C_NAMEFORMULA resolves a position's display name, while C_COUNT_SUBORDSFORMULA and C_COUNT_SUBORDS1FORMULA calculate subordinate position counts at two levels of the hierarchy, and C_COUNT_HOLDERSFORMULA and C_COUNT_HOLDERS1FORMULA calculate the number of incumbents (holders) attached to positions. C_COUNT_CHILD_POSFORMULA returns the count of immediate child positions for a given parent. The remaining six functions are the report's parameter getters, which expose the report-level values to the layout: C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, C_POS_HIERARCHY_NAME_P, C_VERSION_P, C_VERSION_START_DATE_P, C_VERSION_END_DATE_P, C_PARENT_POSITION_NAME_P, C_HOLDERS_SHOWN_P, and C_SESSION_DATE_P. The user search term "c_session_date_p" corresponds exactly to the documented function C_SESSION_DATE_P, which returns the effective session date (type DATE) used to evaluate position and hierarchy records as of a point in time.

Tables Accessed

Per the ETRM metadata, the package references a single documented table through APPS synonyms: PER_POS_STRUCTURE_ELEMENTS. This table stores the parent/child relationships that define a position hierarchy. The package reads it to derive the hierarchy name, walk child and subordinate relationships for the count formulas, and locate the parent position name for the selected parent position ID. Holder information is obtained through this hierarchy element structure to populate the holders-shown counts.

Usage Notes

PER_PERRPRPH_XMLP_PKG is invoked indirectly through the Position Hierarchy Report concurrent program; it is not intended for direct custom calls. The standard interface is the concurrent program, whose submission parameters map to the package globals P_BUSINESS_GROUP_ID, P_SESSION_DATE, P_CONC_REQUEST_ID, P_POS_STRUCTURE_VERSION_ID, P_PARENT_POSITION_ID, and P_HOLDER_FLAG. The session date parameter (P_SESSION_DATE and its character companion P_SESSION_DATE1) and the getter C_SESSION_DATE_P are central to producing a date-effective view of the hierarchy. Because the package is generated as part of the report definition, it is also regenerated when the report is customized. The ETRM classification is OTHER rather than a public API, and the package is referenced by zero other packages, confirming its role as a private report-specific implementation artifact. Customizations should be applied through the report's XML template rather than by modifying the generated package body.