Search Results per_pse_upd




Overview
Explore in AI Chat

Overview

The APPS.PER_PSE_UPD package body is a database-level API component within the Oracle E-Business Suite Human Resources (HR) product family. Its name derives from the core entity it services: PER_POS_STRUCTURE_ELEMENTS, the table that stores the individual elements forming a position structure hierarchy. The suffix "UPD" denotes an update-oriented API, whose principal responsibility is to synchronize, refresh, or propagate changes to position structure element records in response to upstream modifications. The package operates in the PL/SQL layer beneath the Oracle HRMS forms and concurrent programs, insulating those interfaces from direct DML against base tables. In Oracle EBS 12.1.1 and 12.2.2, the object resides in the APPS schema and reports a status of VALID, confirming it is a supported and compiled component of the standard application. Its classification in the ETRM dictionary is OTHER, indicating that it is an internal utility API rather than a formally published public interface, though it remains callable and is subject to dependency tracking.

Key Procedures and Functions

The ETRM metadata documents a single procedure and no standalone functions:

  • UPD — The sole documented entry point. As the name implies, this procedure performs the update processing for which the package exists. It accepts the context of a position structure element change and carries out the necessary modifications and derived actions. Because it is an internal API, the precise parameter signature is not enumerated here; consumers should treat it as an update handler invoked by sibling packages rather than as a form-driven, user-facing call. No parameter list is asserted, as the metadata does not document one.

The procedure is supported by, and orchestrates calls into, several companion components: PER_PSE_BUS (business logic), PER_PSE_RKU (the "row knowledge update" or who-columns maintenance package), PER_PSE_SHD (the shadow/audit table handler), and HR_API together with HR_UTILITY for shared HRMS API and utility routines. This layering reflects the standard Oracle HRMS API design, where update logic is separated from business validation and audit maintenance.

Tables Accessed

The documentation records one referenced table via its APPS synonym: PER_POS_STRUCTURE_ELEMENTS. This is the primary transactional store for position structure element rows, and it is the table the UPD procedure reads and writes in the course of applying updates. Indirectly, the procedure's delegation to PER_PSE_RKU implies maintenance of the standard WHO columns (created/updated by, dates, login) on that table, while delegation to PER_PSE_SHD implies corresponding handling of the associated shadow (audit) records that Oracle HRMS keeps for date-tracked entities. No additional base tables are documented as directly accessed by this package body.

Usage Notes

PER_PSE_UPD is not referenced by any other database object per the ETRM dependency report, and it is itself a caller only. This signature is characteristic of an internal, event-driven utility that is reached through the business-layer package (PER_PSE_BUS) rather than called directly by forms, concurrent programs, or customer extensions. Standard guidance for Oracle EBS 12.2.2 environments is to invoke the supported public HRMS APIs (such as PER_POS_STRUCTURE_ELEMENTS_API) rather than this internal updater, since the internal package offers no public contract and may change between patches. Custom code requiring position structure element maintenance should treat PER_PSE_UPD as a black-box implementation detail and avoid direct invocation. Its presence in a dependency chain is primarily relevant to impact analysis, patching, and troubleshooting, where understanding that business-layer updates route through this package clarifies the order of audit and who-column maintenance.