Search Results pay_ptt_bus




Overview
Explore in AI Chat

Overview

PAY_PTT_BUS is a PL/SQL business-layer package owned by the APPS schema in Oracle E-Business Suite, classified as a component of the Payroll (PAY) product family. The "PTT" prefix designates functionality associated with Payroll User Tables and the Payroll Translation/User Table maintenance framework. The package serves as the validation and security plumbing behind the Payroll User Tables feature, providing a centralized business logic layer that governs how user-defined payroll tables — and their translated (multi-language) counterparts — are secured, inserted, updated, and deleted within the Oracle HRMS schema.

Rather than encapsulating an Oracle-published public API for external consumers, PAY_PTT_BUS functions primarily as an internal business logic module. Its documented procedures align with the standard DAL (Data Access Layer) pattern used throughout Oracle Payroll, separating validation concerns from the physical table manipulation performed by the companion insert, update, and delete packages.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within PAY_PTT_BUS:

  • SET_SECURITY_GROUP_ID — Establishes the security group context under which subsequent user-table operations execute. This is essential in a multi-organization or multi-business-group environment, ensuring user-table rows are filtered and written against the correct security group.
  • RETURN_LEGISLATION_CODE — A function that resolves and returns the legislation code applicable to the payroll user-table context. Legislation code drives localization and validation behavior, as user-table structures may differ by country/legislative context.
  • INSERT_VALIDATE — Performs business-rule validation before a new user-table row (or translated row) is committed, ensuring duplicate or inconsistent data is rejected prior to insertion.
  • UPDATE_VALIDATE — Validates modifications to existing user-table records, enforcing the same integrity constraints that apply on creation.
  • DELETE_VALIDATE — Verifies that a user-table record may be safely removed, checking referential and business constraints before deletion proceeds.

These procedures are invoked by the corresponding PAY_PTT_INS, PAY_PTT_UPD, and PAY_PTT_DEL packages, which handle physical DML.

Tables Accessed

The package references two documented tables through APPS synonyms:

  • PAY_USER_TABLES — The base repository of user-defined payroll table definitions. PAY_PTT_BUS reads from this table during validation to confirm uniqueness, legislation context, and security-group membership before permitting DML.
  • PAY_USER_TABLES_TL — The translation table holding language-specific (MLS) descriptive columns for each user table. Validation against translated rows ensures that insert, update, and delete operations preserve translation integrity across installed languages.

Dependency metadata also records that PAY_PTT_BUS references the APPS.PAY_PTT_SHD shadow package (generated code supporting the table handler) and SYS.STANDARD.

Usage Notes

PAY_PTT_BUS exposes no documented public API parameters via ETRM and is not intended for direct invocation by end users or custom extensions. It is referenced by three other packages — PAY_PTT_INS, PAY_PTT_UPD, and PAY_PTT_DEL — confirming its role as an internal validation service consumed by the Payroll User Tables maintenance flow. Typical invocation paths include the Oracle Forms-based Payroll User Table maintenance screens and any concurrent or background process that manipulates user-table definitions. Developers customizing around Payroll User Tables should treat PAY_PTT_BUS as a private implementation detail and, where possible, route changes through the supported table-handler packages to preserve validation integrity. Its validity status (VALID) in both 12.1.1 and 12.2.2 confirms stable, supported behavior across those releases.