Search Results column_instance_upd_ins




Overview
Explore in AI Chat

Overview

PAY_USER_TABLE_DETAILS_PKG is an Oracle EBS Payroll (PAY) schema package owned by APPS and classified as OTHER within the ETRM repository. It supports the "User Table" and "User Row" / "User Column" framework in Oracle Payroll, a configurable extension mechanism that allows implementers to define custom data structures — tables, columns, rows, and column instances — that participate in payroll processing, formula evaluation, and legislative reporting. The package is a maintenance-layer API: rather than a runtime calculation engine, it encapsulates the DML logic required to create, update, and maintain the metadata definitions and instance records that describe these user-defined structures. Its documented status is VALID and it references the standard PAY_USER_TABLES synonym, positioning it as a foundational utility for the user-table configuration lifecycle.

Key Procedures and Functions

ETRM documents four procedures and functions within this package. Parameter signatures are not published in the metadata, so only their intended purpose is described.

  • USER_TABLE_UPD_INS — Handles insert and update operations against the user table definition record, maintaining the top-level header for a user-defined payroll table in PAY_USER_TABLES.
  • USER_ROW_UPD_INS — Maintains row-level definitions within a user table, supporting the creation and amendment of the row entries that make up the structure of a user table.
  • COLUMN_ROW_UPD_INS — Manages the intersection between user columns and user rows, ensuring that column-to-row assignments remain consistent when either side of the definition changes.
  • COLUMN_INSTANCE_UPD_INS — Maintains column instance records, which represent the runtime data values stored against a user column within a specific legislative or processing context.

Tables Accessed

The package reads and writes a focused set of Payroll configuration tables, accessed through APPS synonyms:

  • PAY_USER_TABLES — the master definition of a user table; the direct dependency listed in the ETRM excerpt.
  • PAY_USER_COLUMNS and PAY_USER_COLUMN_INSTANCES_F — column definitions and their dated instance records.
  • PAY_USER_ROWS_F — dated row definitions belonging to a user table.
  • FF_FORMULAS_F and FF_FORMULA_TYPES — formula metadata, confirming integration with the Fast Formula engine so that user-table data is reachable from payroll formulas.
  • HR_LEGISLATION_INSTALLATIONS — establishes which legislation a given user-table configuration applies to.
  • HR_STU_EXCEPTIONS — exception records associated with the user table framework.
  • USER_VIEWS — the generated or referenced database views that expose user-table data.

Usage Notes

This package is an internal maintenance API rather than a public, documented interface. It is typically invoked indirectly by the Payroll user-table configuration forms and related setup UI when an implementer defines or amends a user table, its columns, rows, and instances. It may also be called from custom PL/SQL or concurrent programs that programmatically build user-table metadata during a data migration or a legislative rollout. ETRM records zero dependent packages, indicating no other shipped package calls it — reinforcing that its consumers are forms, concurrent processing, or bespoke code. Because the package performs direct DML against dated, effective-dated Payroll tables, custom callers must supply correct date-effectivity values and must not bypass the standard commit and validation logic; direct invocation against production Payroll data should be limited to controlled maintenance windows and tested in a cloned environment first.