Search Results pay_element_template_user_init




Overview
Explore in AI Chat

Overview

The APPS.PAY_ELEMENT_TEMPLATE_USER_INIT package belongs to the Oracle Payroll (PAY) product family and is classified in the ETRM repository as an OTHER API rather than a public, supported interface. Its documented purpose is to create earning and deduction elements through Element Templates for Oracle International Payroll. Element Templates provide a declarative mechanism by which payroll implementers define a reusable blueprint of an element, including its classification, input values, formulas, and balance feeds. This package materializes that blueprint into concrete payroll element definitions at runtime.

The package is declared with AUTHID CURRENT_USER, meaning that name resolution and privilege checking occur under the invoking schema rather than the defining schema. The source header carries the version marker payeletmplusrini.pkh 120.1, and the change history records creation on 12-NOV-2004, subsequent refinements to the p_rec parameter (made IN-only), the removal of SYSTEM schema references, the addition of the DELETE_ELEMENT procedure in April 2005, and the introduction of exception handlers and pragmas in September 2005. These revisions predate the 12.1.1 and 12.2.2 releases and remain stable across both.

Key Procedures and Functions

Two procedures are documented for this package:

  • CREATE_ELEMENT — Generates earning or deduction element definitions using an Element Template as the source specification. It resolves the template metadata and writes the resulting element type, shadow element type, and associated payroll objects.
  • DELETE_ELEMENT — Removes an element previously created through the template mechanism, including its dependent shadow objects, so that the template-derived definition can be reversed cleanly.

No parameter lists are reproduced here; the ETRM metadata documents procedure names and purpose only. The package also declares a user-defined exception, Cannot_Find_Prog_Unit, together with associated pragmas. This exception is raised when a dynamically constructed program unit cannot be resolved at runtime. The source notes that although Oracle normally surfaces ORA-06508 when a program unit is missing, this package executes program units dynamically via string construction (for example, EXECUTE IMMEDIATE 'BEGIN Program_Un...'), which requires explicit handling of that failure mode.

Tables Accessed

The package reads and writes a set of core payroll and Fast Formula tables through APPS synonyms:

Usage Notes

Because the package is classified as OTHER rather than a public API, it is not documented for direct customer invocation. It is referenced by two other packages within the Payroll schema, and the Cannot_Find_Prog_Unit exception exists specifically to support dynamic invocation of those downstream program units. The search term cannot_find_prog_unit corresponds directly to this exception: encountering it typically indicates that a dynamically resolved package or procedure referenced during element creation or deletion is missing, invalid, or not visible under the current schema. In practice, this arises when a custom or localized program unit expected by the template logic has not been deployed, has been invalidated, or when the AUTHID CURRENT_USER resolution model exposes a synonym or grant gap. Remediation focuses on validating the referenced program units and confirming that the invoking schema holds appropriate EXECUTE privileges and synonym access.