Search Results create_element

Overview

PAY_ELEMENT_TEMPLATE_USER_ISWI is an Oracle Payroll self-service wrapper package in the APPS schema. Its designation as an "ISWI" (Internet Self-Service Web Interface) package indicates that it exposes server-side PL/SQL entry points intended for consumption by self-service web-based flows rather than by batch or core payroll processing. Specifically, the package wraps the underlying business logic held in PAY_ELEMENT_TEMPLATE_USER_INIT, providing a thin, self-service-facing layer over element template creation and removal operations.

The business function it serves centers on enabling authorized users — typically HR or payroll administrators operating through self-service interfaces — to create and delete payroll element templates. Element templates are the metadata definitions from which concrete payroll elements are generated; they drive how earnings, deductions, and other element classifications behave across payroll runs. By exposing a controlled wrapper, Oracle isolates the self-service channel from the core API, allowing the UI layer to pass pre-validated parameters while the underlying initialization API performs the substantive processing.

Key Procedures and Functions

• CREATE_ELEMENT — The self-service wrapper for pay_element_template_user_init.create_element. It accepts a validation flag and a save-for-later indicator, along with structured element, subclass, and frequency-rule data, and returns a newly generated element template identifier together with a status value. On success the return status signals completion; on failure it indicates the error condition.
• DELETE_ELEMENT — The corresponding wrapper for pay_element_template_user_init.delete_element. It follows the same self-service pattern for removing an existing element template definition, returning a status value to indicate success or failure back to the calling interface.

Both procedures adhere to a consistent wrapper convention: all IN parameters are assumed to have been appropriately derived by the caller before invocation, and outcomes are communicated through the out NOCOPY return status parameter.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables referenced through APPS synonyms. As a wrapper, PAY_ELEMENT_TEMPLATE_USER_ISWI does not itself perform direct DML; instead, the underlying initialization package (PAY_ELEMENT_TEMPLATE_USER_INIT) manages persistence against the Payroll element template and associated definition tables. The structured parameters visible in the signature — an element template object, a subclass table, and a frequency-rule table — reflect the composite payload that ultimately feeds those underlying element definition structures.

Usage Notes

This package is classified as Internal Development use only, meaning it is not published as a supported public API for customer customization. It is most commonly invoked from self-service web pages and related Oracle Payroll configuration flows that present an element-template maintenance screen. It would not ordinarily be called from concurrent programs or batch processes, which typically target the underlying initialization API directly. Developers performing custom integration should recognize that any reliance on this wrapper carries no support guarantee, and that the documented entry point names CREATE_ELEMENT and DELETE_ELEMENT map one-to-one to the equivalent procedures in PAY_ELEMENT_TEMPLATE_USER_INIT. Because the metadata records no dependencies from other packages, its role is strictly downstream-facing toward the user interface layer.