Search Results pay_set_ins




Overview
Explore in AI Chat

Overview

PAY_SET_INS is an internal PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Payroll (PAY) product family and its name reflects its function: it acts as an insertion handler for "sets" of payroll-related definitions, most notably shadow element type records maintained by the payroll element template framework. The package has no public business-facing API classification (ETRM classifies it as OTHER), indicating it is a private implementation utility rather than a supported integration interface. Its dependency chain confirms this role: PAY_SET_INS references PAY_SET_SHD (a shadow table) and the SYS.STANDARD package, and is itself referenced by element template packages such as PAY_AE_ELEMENT_TEMPLATE_PKG, PAY_IN_ELEMENT_TEMPLATE_PKG, PAY_CREATE_ELEMNT_TMPLT_RECORD and PAY_ELEMENT_TEMPLATE_UTIL. In practice, the package participates in the declarative loading of global element templates, where a template definition must be materialized as concrete rows across the shadow element type tables.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

  • INS — The sole documented procedure. It performs the insert processing for which the package is named, writing set-level shadow element type data into the underlying shadow schema tables. It encapsulates the row construction and insertion logic so that the various element template packages do not each need to replicate that logic.

No functions are documented, and no parameter lists are published in the ETRM record. Callers should not assume signature stability, since this is an internal, unclassified package. The metadata explicitly distinguishes the [Package] specification from the [Package Body], with the body containing the [SQL Statements] that implement the INS logic.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • PAY_SHADOW_ELEMENT_TYPES — The primary shadow element type definition table. INS writes the element type set rows here as part of template materialization.
  • PAY_SHADOW_ELEMENT_TYPES_S — The corresponding translated (TL-style) shadow element type table. INS inserts the language-specific descriptive rows that accompany the base record.
  • PAY_SET_SHD — Referenced directly within the APPS schema and reflected in the ETRM dependency listing. It provides the shadow set context against which insertions are performed.

Because the shadow tables hold the "build-time" representation of element definitions before they are promoted into the live element structures, writes to them must be consistent across the base and translated tables; the paired _S insert is the reason both tables appear in the dependency list.

Usage Notes

PAY_SET_INS is not intended for direct invocation from Oracle Forms, concurrent programs, or customer-written code. It is a subordinate routine invoked by the element template APIs and utilities that appear in its reverse-dependency list, principally during template creation, localization, and UAE/India-specific element template loading paths. Customizations that need to create or copy shadow element types should call the supported element template packages (for example PAY_ELEMENT_TEMPLATE_UTIL or PAY_CREATE_ELEMNT_TMPLT_RECORD) rather than PAY_SET_INS itself, because the calling packages manage validation, set grouping, and the surrounding transaction that the bare insert routine does not. The package status is VALID in the APPS schema, meaning it is a standard, previously compiled object present in a healthy 12.1.1/12.2.2 instance; it should never be modified or recompiled as a customization. Any diagnostics involving this object should focus on its callers and on data consistency in PAY_SHADOW_ELEMENT_TYPES and PAY_SHADOW_ELEMENT_TYPES_S, since failures in INS surface as element template creation errors rather than as errors in the insert package itself.