Search Results set_ele_var_ids

Overview

APPS.HR_PAY_INTERFACE_PKG is a PL/SQL package in the Oracle E-Business Suite Oracle Advanced Benefits (OAB) and Oracle Payroll integration layer. Its primary business purpose is to supply interface functionality that supports the OAB benefits view, exposing benefit enrollment, coverage, and rate data in a form that payroll and benefits reporting components can consume. The package header carries the RCS identifier pegpipkg.pkh, indicating it belongs to the Oracle Payroll (pe) module family. In ETRM the object is classified as "OTHER," meaning it is not a certified public API but rather an internal integration utility referenced broadly across the application; the metadata records 41 other packages that call into it, which confirms its role as a shared, foundational service routine rather than a stand-alone entry point.

Key Procedures and Functions

The package exposes 27 documented procedures and functions, organized around two concerns: benefits data retrieval and validation/control utilities.

• GET_COVERAGE_TYPE — returns the coverage type associated with an option-in-plan record, used to resolve how a benefit is characterized for interface purposes.
• EEPYC / ERPYC accessors — GET_EEPYC_VARCHAR2, GET_EEPYC_NUMBER, GET_EEPYC_DATE, GET_ERPYC_VARCHAR2, GET_ERPYC_NUMBER, and GET_ERPYC_DATE retrieve element eligibility and rate-related values in the appropriate datatype. EEPYC_ERPYC_EXIST tests whether such a record exists before retrieval.
• Split-view variants — SPLIT_EEPYC_EXIST, SPLIT_ERPYC_EXIST, and the corresponding GET_SPLIT_* accessors provide the same retrieval capability for split benefit views, where enrollment results are distributed across multiple records.
• Control procedures — SET_ELE_VAR_IDS, DISABLE_ELE_ENTRY_DELETE, and DISABLE_EMP_NUMBER_UPDATE enforce interface-level restrictions on element entry deletion and employee number changes; CHK_REPORTING_NAME_UNIQUENESS validates that reporting names do not collide.

These routines share a common pattern of accepting an enrollment result identifier together with effective start and end dates, enabling date-tracked, effective-dated retrieval consistent with EBS datetrack conventions.

Tables Accessed

The package reads and writes through APPS synonyms referencing core Benefits and Payroll tables. Benefits-side access centers on BEN_PRTT_ENRT_RSLT_F (participant enrollment results), supported by BEN_OIPL_F and BEN_OPT_F for option-in-plan data and BEN_PRTT_RT_VAL for participant rate values. Payroll-side access includes PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F, PAY_LINK_INPUT_VALUES_F, and PAY_COST_ALLOCATIONS_F, which supply element entry, link, input value, and cost allocation context. Person and assignment data come from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PEOPLE_EXTRA_INFO, and PER_PERIODS_OF_SERVICE. PAY_PERSONAL_PAYMENT_METHODS_F supports payment method retrieval. This table footprint confirms the package's position at the junction of benefits enrollment and payroll element processing.

Usage Notes

HR_PAY_INTERFACE_PKG is an internal package, not a public API, and should not be invoked directly by custom code without careful review of Oracle's supported interfaces. It is typically called from OAB benefits forms, from payroll and benefits concurrent programs, and from other packaged code that requires consistent, effective-dated retrieval of enrollment and element data. Because 41 packages reference it, changes to its signature or behavior carry broad regression risk; customizations should wrap rather than modify it. Version notes indicate the header was last revised in the 12.x release line, and the package remains present in both 12.1.1 and 12.2.2. Developers debugging interface output, coverage resolution, or element entry validation failures in the benefits-to-payroll flow will frequently encounter this package on the call stack.