Search Results per_ppc_upd




Overview
Explore in AI Chat

Overview

PER_PPC_UPD is a PL/SQL package owned by the APPS schema that supports the maintenance of pay proposal components within Oracle Human Resources. In the Oracle E-Business Suite R12.1.1 and R12.2.2 environments, the package operates as a low-level data manipulation utility that handles the insertion, update, and deletion of records in the pay proposal component entity that underpins the salary proposal and compensation workflow. Pay proposals in Oracle HRMS represent recommended changes to an employee's pay, such as a proposed salary adjustment following a performance review, a promotion, or an annual merit cycle. Each proposal is decomposed into one or more components, and PER_PPC_UPD provides the programmatic pathway by which those components are written to the database. The package is classified as an OTHER API in the E-Business Suite Technical Reference Manual (ETRM), meaning that it is not part of the published, supported public API surface but is instead an internal building block used by higher-level APIs and concurrent processes.

Key Procedures and Functions

The ETRM documentation identifies a single documented program unit within the package:

  • UPD — The primary procedure that performs the maintenance of pay proposal component data. Its name indicates an update-oriented operation, though as the sole entry point in the package it is understood to service the full range of write activity against the components table, including the creation and modification of component rows associated with a proposal. No parameter list is published in the ETRM metadata, so integrators should treat the signature as internal and subject to change.

Because only one procedure is documented, the package is deliberately narrow in scope. It exists to encapsulate the mechanics of writing pay proposal components rather than to expose a broad functional interface.

Tables Accessed

The package references a single documented table through APPS synonyms:

  • PER_PAY_PROPOSAL_COMPONENTS — This is the base table that stores the individual component lines belonging to a pay proposal. Each row records a component amount, percentage, or other element of the proposed compensation change. PER_PPC_UPD reads and writes this table to persist the component detail supplied by the calling API. Because the table is exposed only through an APPS synonym, all access occurs within the trusted APPS schema context.

The dependency listing also shows references to HR_API, PER_PPC_SHD, and the SYS.STANDARD package. PER_PPC_SHD is the shadow (history) counterpart table or package used to preserve audit trails of changes to pay proposal components, while HR_API provides shared date-tracked and business-group utilities. These dependencies confirm that PER_PPC_UPD participates in Oracle HRMS date-tracked data maintenance rather than performing unqualified direct DML.

Usage Notes

PER_PPC_UPD is not intended for direct invocation by end users or custom code. Within the ETRM dependency graph it is referenced only by two higher-level packages: HR_MAINTAIN_PROPOSAL_API and HR_UPLOAD_PROPOSAL_API. The former supports interactive maintenance of proposals, including the forms-based Salary Proposal pages in Oracle HRMS, while the latter supports bulk upload of proposals, typically through concurrent programs or interface processes. Customizations that need to create or amend pay proposal components should therefore call HR_MAINTAIN_PROPOSAL_API or HR_UPLOAD_PROPOSAL_API rather than PER_PPC_UPD directly. Direct calls bypass the validation, date-track integrity, and audit logic enforced by the parent APIs and risk corrupting proposal data. The package may appear in dependency queries or in troubleshooting of pay proposal issues, but it should be regarded as an internal implementation detail that Oracle may modify in patches without notice.