Search Results ghr_custom_pay_calc

Overview

GHR_CUSTOM_PAY_CALC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and validated in EBS 12.1.1 and 12.2.2. It belongs to the Oracle Advanced Benefits (OAB) module, which processes benefits-related payroll calculations. The package provides a customizable extension point for compensation and pay calculation logic that the core Benefits engine cannot resolve through seeded configuration alone. In standard delivered functionality, the GHR_PAY_CALC package orchestrates benefit pay calculations, electability checks, and rate determination. GHR_CUSTOM_PAY_CALC acts as the customer-specific counterpart, allowing implementers to inject site-specific pay calculation routines without modifying protected Oracle code. ETRM classifies the package as API classification OTHER, indicating it is a supplementary package rather than a formally published public API.

Key Procedures and Functions

ETRM documents exactly one procedure or function for this package: CUSTOM_PAY_CALC. Its name and context indicate it serves as the customer-definable hook invoked during benefits pay calculation to apply organization-specific logic that the delivered GHR_PAY_CALC engine does not perform. Typical implementations use such a procedure to compute benefit-related pay amounts from externally supplied parameters or custom formula drivers. Because ETRM documents only the name and does not expose a signature, the procedure should be treated as a user-definable extension point. The actual callable interface should be confirmed by inspecting the package specification in the database, since the metadata does not enumerate parameter lists.

Tables Accessed

The ETRM excerpt lists no direct table references through APPS synonyms. The documented dependencies are instead package references: GHR_CUSTOM_PAY_CALC depends on APPS.GHR_PAY_CALC and SYS.STANDARD, and is in turn referenced by APPS.GHR_CUSTOM_PAY_CALC (its own package body) and APPS.GHR_PAY_CALC. The dependency on STANDARD is the conventional PL/SQL package dependency present in virtually all compiled database packages. GHR_PAY_CALC is the primary caller, meaning this custom package is invoked from within the standard benefits pay calculation flow. Because no tables are documented, any data access performed by the customized procedure is implementation-specific and cannot be enumerated from the ETRM metadata provided. Implementers should document their own table dependencies when extending the procedure.

Usage Notes

GHR_CUSTOM_PAY_CALC is designed to be extended by customers, not called directly from forms or user interfaces. The dependency data confirms it is invoked by GHR_PAY_CALC, so it executes automatically as part of the benefits pay calculation and payroll processing cycle. Typical invocation paths include Benefits concurrent programs, benefit plan enrollment calculations, and payroll benefit runs that require custom earnings, deductions, or imputed income computations. Because this is a customization package rather than an Oracle public API, changes to its contents are preserved across certain patches only when the package is not overwritten; customers are advised to keep custom logic isolated and to re-verify compilation status after upgrades or patch application. The package status is VALID in the documented environment, confirming that both specification and body compiled successfully. Any custom modifications must respect the calling contract expected by GHR_PAY_CALC, since the core engine invokes CUSTOM_PAY_CALC without tolerance for signature or runtime errors. Given the sparse ETRM metadata, all parameter and return conventions should be validated against the live package source before modification.