Search Results per_pyp_del




Overview
Explore in AI Chat

Overview

PER_PYP_DEL is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API rather than a public, customer-facing interface. Its name follows Oracle's internal naming convention for packages that operate on the PER_PAY_PROPOSALS table, where "PYP" abbreviates "Pay Proposals." The package therefore serves the Payroll and Human Resources proposal-management business flow, providing the deletion logic used when a pay proposal record must be removed from the system. Pay proposals represent planned or draft adjustments to an employee's pay — such as a salary change or grade step progression awaiting approval — and the ability to delete a proposal cleanly is a necessary part of that lifecycle.

PER_PYP_DEL is not a standalone feature exposed to end users directly; it is a low-level utility package that other application components call. The ETRM metadata records it as a VALID package in both the 12.1.1 and 12.2.2 releases, with a corresponding package body and two documented subobjects (Package and Package Body).

Key Procedures and Functions

The documented public interface of PER_PYP_DEL consists of a single procedure, DEL. The ETRM lists two documented procedures/functions in total, consistent with the package specification declaring DEL and the package body implementing it.

  • DEL — The deletion routine that removes a pay proposal record. This is the operative entry point of the package and is called by other EBS components (notably HR_MAINTAIN_PROPOSAL_API) when a proposal must be permanently removed. The ETRM documentation does not publish a parameter list for DEL, and no parameter signature should be assumed; integrators must inspect the package specification in the target instance before invoking it.
  • Package Body — The implementation unit containing the compiled logic for DEL. The body is a documented subobject and is shown as VALID.

Tables Accessed

Per the documented table dependencies, PER_PYP_DEL references the following table via its APPS synonym:

  • PER_PAY_PROPOSALS — The core Pay Proposals table holding salary, grade, and other pay-change proposal rows. DEL operates on this table to remove the targeted proposal record. Because this is the only documented table reference, the package is narrowly scoped to proposal deletion and does not appear to touch adjacent payroll-detail tables directly.

Usage Notes

PER_PYP_DEL is referenced by exactly one other documented package, HR_MAINTAIN_PROPOSAL_API, which is the higher-level API used by Oracle HRMS forms and processes to create, update, and delete pay proposals. In practice, the Oracle Payroll/HRMS proposal maintenance form and any concurrent or batch process that manages proposals will reach PER_PYP_DEL transitively through HR_MAINTAIN_PROPOSAL_API rather than calling it directly. The package also carries a self-reference, indicating internal recursion or internal calls within the same package body.

Because PER_PYP_DEL is classified as OTHER and is not a supported public API, customizations should invoke HR_MAINTAIN_PROPOSAL_API or the standard product forms wherever possible, and should call PER_PYP_DEL directly only when a genuine low-level deletion is required. Any such direct call must be validated against the actual package specification in the deployed instance, since the ETRM metadata intentionally omits parameter signatures. Direct DML against PER_PAY_PROPOSALS is strongly discouraged, as the package encapsulates the deletion semantics Oracle expects.