Search Results per_ppc_bus




Overview
Explore in AI Chat

Overview

PER_PPC_SHD is an Oracle EBS Human Resources (PER) package owned by the APPS schema. The "SHD" suffix in Oracle Application Object Library conventions indicates a shared or shadow helper package — typically a supporting module that centralizes logic consumed by a family of related DML packages rather than being called directly by forms or concurrent programs. In the Pay Proposals module, the PER_PPC_* family (PER_PPC_BUS, PER_PPC_DEL, PER_PPC_FLEX, PER_PPC_INS, PER_PPC_UPD, and PER_PPC_SHD) implements the interface layer governing Pay Proposal Components — the line-level component records attached to a pay proposal for a person or assignment.

PER_PPC_SHD serves as the shared utility layer for this family, providing constructs reused across the business, delete, flex, insert, and update handlers. The ETRM record classifies it as API type OTHER with status VALID, and confirms it is referenced by six other packages within the same module. Notably, the user search term "per_ppc_bus" resolves here because PER_PPC_BUS is the most prominent consumer of PER_PPC_SHD: the business-rules package calls this shared layer to perform common validation, locking, and status checks before commit.

Key Procedures and Functions

The documented interface exposes five procedures/functions. No parameter signatures are published, so the following describes purpose only:

  • RETURN_API_DML_STATUS — Returns the DML outcome flag of the most recent API operation, allowing a caller such as PER_PPC_BUS to determine whether an insert, update, or delete succeeded or failed without inspecting SQL%ROWCOUNT directly.
  • CONSTRAINT_ERROR — Handles Oracle integrity constraint exceptions raised during Pay Proposal Component DML, mapping database errors into the application's API error stack.
  • API_UPDATING — Indicates or tracks whether an API-driven update is in progress, preventing conflicting row operations within the same transaction.
  • LCK — Performs row-level locking on the target Pay Proposal Component record, guarding against concurrent modification by another session.
  • CONVERT_ARGS — Normalizes or converts arguments passed from the outer API into an internal representation used by the shared routines.

Tables Accessed

The ETRM metadata documents two referenced objects via APPS synonyms: PER_PAY_PROPOSAL_COMPONENTS and ALL_CONSTRAINTS. PER_PAY_PROPOSAL_COMPONENTS is the base transaction table holding component lines for a pay proposal; the SHD layer reads it for existence and locking checks, and its DML status logic is driven by operations performed against it. ALL_CONSTRAINTS, a standard Oracle data dictionary view, is referenced for constraint validation — consistent with CONSTRAINT_ERROR — enabling the package to identify and interpret integrity violations when component rows are written. Because PER_PPC_SHD is a helper rather than the primary DML owner, its direct writes are minimal; conforming inserts, updates, and deletes are executed by PER_PPC_INS, PER_PPC_UPD, and PER_PPC_DEL.

Usage Notes

PER_PPC_SHD is an internal dependency and is not intended for direct invocation from forms or custom code. It is called by PER_PPC_BUS, PER_PPC_DEL, PER_PPC_FLEX, PER_PPC_INS, PER_PPC_UPD, and, per the ETRM dependency list, by PER_PPC_SHD itself; the Pay Proposal Components OVN (PER_PROPOSAL_COMPS_OVN) is likewise associated with the family. Customizations should call the public API surface — typically PER_PPC_INS, PER_PPC_UPD, and PER_PPC_DEL — which in turn route validation, locking, and status handling through PER_PPC_SHD. References to this package are considered internal implementation detail in both 12.1.1 and 12.2.2; direct dependency on it risks breakage during patching, since the shared layer may change without notice while public API signatures remain stable.