Search Results pay_us_dedn_template_wrapper




Overview
Explore in AI Chat

Overview

PAY_US_DEDN_TEMPLATE_WRAPPER is a PL/SQL package in the APPS schema that supports the creation and maintenance of deduction element templates used by Oracle Payroll (US localization) during upgrade and setup operations. Its role is that of a wrapper or helper layer: it isolates the logic required to insert, configure and remove deduction element definitions so that upgrade programs and setup utilities do not need to manipulate the underlying element template tables directly.

The package is classified in the ETRM repository as OTHER, meaning it is not a published public API. It is invoked internally by other Oracle-delivered packages rather than being called from customer code. Its close association with the US deduction template and US garnishment upgrade infrastructure reflects its use during payroll upgrade processing, where deduction elements must be generated or removed on behalf of a specific legislation and element template.

Key Procedures and Functions

  • CREATE_DEDUCTION_ELEMENT — Creates a deduction element based on the supplied deduction element template. It encapsulates the standard element creation steps, including the assignment of the element to the appropriate template and the population of any additional element-type attributes required for a deduction.
  • DELETE_DEDUCTION_ELEMENT — Removes a previously created deduction element. It provides the inverse of the creation routine so that upgrade and setup routines can clean up elements that are no longer required or that were created in a prior processing run.

The two procedures are complementary and are typically executed together as part of an upgrade or setup sequence. Neither procedure is documented as a supported public API, and no parameter signatures are published in the ETRM record.

Tables Accessed

  • PAY_ELEMENT_TEMPLATES — The element template definition used as the basis for the deduction element being created or deleted.
  • PAY_ELEMENT_TYPE_EXTRA_INFO — Additional element type classification information populated or validated when a deduction element is generated.
  • PAY_UPGRADE_DEFINITIONS — The upgrade definition driving the processing context in which the wrapper is invoked.
  • PAY_UPGRADE_STATUS — The upgrade status record used to track or validate the state of upgrade processing for the element.

Access to these tables is performed through APPS synonyms. The package itself depends only on the STANDARD and SYS schemas at the database level, indicating that it relies primarily on these Payroll tables and standard PL/SQL constructs.

Usage Notes

The package is not exposed through a form or a standalone concurrent program; it is a programmatic wrapper called by other PL/SQL units. The ETRM dependency listing shows that PAY_US_DEDN_TEMPLATE_WRAPPER is referenced by PAY_US_GARN_UPGRADE and PAY_US_ISETUP_EARN_DEDN, both of which are US payroll upgrade and setup drivers. When those programs need to create or remove a deduction element within the upgrade framework, they delegate to this wrapper.

For Oracle EBS 12.1.1 and 12.2.2, the behavior is consistent: the package remains valid and is delivered as part of the APPS schema. Customers should not call CREATE_DEDUCTION_ELEMENT or DELETE_DEDUCTION_ELEMENT directly, because the routines are not a supported API and assume an upgrade context established by the calling program. Any custom requirement to create deduction elements should be met through the supported element creation interfaces or the element template setup screens. When reviewing upgrade failures involving US deduction or garnishment elements, the package is a relevant object to inspect for errors logged during element creation or deletion.