Search Results per_ppc_del




Overview
Explore in AI Chat

Overview

PER_PPC_DEL is an Oracle EBS Applications (APPS) schema PL/SQL package that supports deletion logic for the Payroll Proposal Components entity. It is classified under the ETRM metadata as an "OTHER" API, meaning it is a supporting or internal utility package rather than a public, fully documented business API. The package serves as a low-level deletion helper for records held in the PER_PAY_PROPOSAL_COMPONENTS table, which stores the individual component lines that make up a payroll proposal. Payroll proposals are used within Oracle HRMS and Payroll to model and review changes to an employee's compensation — for example, a proposed salary adjustment, bonus, or other element entry — before those changes are approved and applied to the live payroll assignment. The DEL package provides the mechanism for removing proposal component rows when a proposal is discarded, revised, or superseded. Within ETRM it is recorded as a VALID object owned by APPS, with a package specification and a package body, and it is positioned at the lower end of the proposal management call stack.

Key Procedures and Functions

The documented metadata identifies a single procedure, DEL, exposed by the package.

  • DEL — The deletion procedure for payroll proposal component data. Its purpose is to remove one or more rows from the proposal components store, typically keyed to a specific proposal or proposal component identifier. Because the ETRM record does not publish the parameter list, the exact signature is not reproduced here; the procedure is understood to accept identifying arguments (such as a proposal or component key) that determine which component records are deleted. This procedure is intended for internal invocation by the surrounding HRMS proposal APIs rather than for direct use by end users.

The package has no documented functions; DEL is the sole documented entry point, reflecting its narrow, single-purpose design.

Tables Accessed

The package references the APPS synonym for PER_PAY_PROPOSAL_COMPONENTS. This table holds the granular component records that belong to a payroll proposal. When a proposal is abandoned, replaced, or its components are rebuilt, PER_PPC_DEL deletes the obsolete component rows from this table, keeping the proposal data internally consistent with the current proposal definition. No other application tables are documented as being accessed directly by this package. The package also depends on the APPS.PER_PPC_SHD shadow (audit) package and on the SYS.STANDARD package, which is consistent with Oracle's standard auditing/shadow-table pattern for HRMS data.

Usage Notes

PER_PPC_DEL is not a standalone interface and is not exposed as a form or concurrent program. It is invoked indirectly through higher-level proposal management APIs. The ETRM dependency list shows that it is referenced by HR_ASSIGNMENT_INTERNAL, HR_MAINTAIN_PROPOSAL_API, and HR_UPLOAD_PROPOSAL_API, as well as recursively by PER_PPC_DEL itself. This means the package is called when a proposal is maintained or uploaded — for instance, when HR_MAINTAIN_PROPOSAL_API processes a user's changes and needs to clear out existing component rows before re-inserting updated ones, or when HR_UPLOAD_PROPOSAL_API loads proposal data in bulk and removes stale entries. The self-reference indicates internal recursive or repeated deletion calls. Administrators and developers should treat PER_PPC_DEL as a private implementation detail: custom code should drive proposal changes through the documented maintain and upload APIs rather than invoking DEL directly. This preserves the shadow-table auditing and validation logic applied by the parent APIs. The package applies to both 12.1.1 and 12.2.2, where the underlying PER_PAY_PROPOSAL_COMPONENTS data model and proposal APIs remain consistent.