Search Results pay_pct_upd




Overview
Explore in AI Chat

Overview

APPS.PAY_PCT_UPD is a PL/SQL package that forms part of the Oracle Payroll (PAY) schema within Oracle E-Business Suite, delivered under the APPS schema. Its name reflects its role as an update utility for "PCT" objects — most directly the Payroll user column definitions stored in the PAY_USER_COLUMNS tables. In EBS releases 12.1.1 and 12.2.2, the Payroll module allows implementers to define additional, user-defined columns on payroll-related records so that legislative and site-specific data can be captured without modifying the base product. These definitions are multilingual (translated) entities, maintained in the _TL (translated) and _B (base) table pairs. PAY_PCT_UPD provides the internal programmatic layer through which the translated descriptive information for these user columns is inserted, changed, or refreshed.

The package is classified in the ETRM repository as an "OTHER" API rather than a formally published public API. This classification indicates that it is a supporting internal utility invoked by other Payroll packages and by the multi-lingual (MLS) translation helper rather than being intended as a direct integration point for customer code.

Key Procedures and Functions

ETRM documents one procedure or function for this package:

  • UPD_TL — Handles updates to the translated (TL) attributes associated with Payroll user column definitions. The naming convention "TL" confirms that this routine operates on language-specific descriptive text rather than the non-translated base rows. It is the mechanism by which changes to column prompts, labels, and other translated descriptive fields are persisted through the Payroll user column maintenance flow.

No public parameter signatures are published in the ETRM record, and this summary deliberately does not speculate on them. Consumers should treat UPD_TL as an internal routine whose contract is owned by the Payroll development team.

Tables Accessed

The documented table reference for this package is PAY_USER_COLUMNS_TL, accessed via the APPS synonym. This is the translated table holding language-specific descriptions for the user-defined payroll columns. The package writes to (and may read from) this table as part of processing the UPD_TL operation. The base counterpart, PAY_USER_COLUMNS, and the related _B table supply the non-translated key and structural data that the TL rows describe, though the ETRM metadata lists only the _TL table explicitly.

Usage Notes

PAY_PCT_UPD depends on HR_API — the shared Human Resources API utility package — and on the SYS.STANDARD package, and is itself referenced by several other Payroll components: PAY_PCT_MNT_TL_ARU (the application-level "after row update" logic for the user column maintenance form), PAY_USER_COLUMNS_PKG, and PAY_USER_COLUMN_API. This dependency chain shows that the package is normally reached indirectly:

  • When a user maintains Payroll user columns through the Payroll setup forms, the form's MLS and row-update triggers call into PAY_PCT_MNT_TL_ARU and related packages, which in turn invoke PAY_PCT_UPD.UPD_TL to persist translated text.
  • The PAY_USER_COLUMNS_PKG and PAY_USER_COLUMN_API packages act as the higher-level entry points for definition and maintenance of user columns; PAY_PCT_UPD supplies the low-level TL update work beneath them.
  • Because the package is classified as OTHER in ETRM, it is not a supported direct-call interface. Custom code should use the documented Payroll user column APIs instead of invoking PAY_PCT_UPD directly, since internal signatures may change without notice across patch levels or between 12.1.1 and 12.2.2.

In summary, PAY_PCT_UPD is a narrow internal Payroll utility dedicated to maintaining the translated descriptive data of user-defined payroll columns, sitting beneath the supported Payroll user column APIs and MLS maintenance logic.