Results for “per_dpf_del”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PER_DPF_DEL is a PL/SQL deletion package owned by the APPS schema in Oracle E-Business Suite. Its name follows the standard Oracle HRMS naming convention: the PER prefix identifies it as an Oracle Human Resources (People) module object, DPF denotes the Deployment Factors entity, and the DEL suffix marks it as a delete handler. The package provides the programmatic layer through which Deployment Factors records are removed from the PER_DEPLOYMENT_FACTORS table, ensuring that the physical delete operation is executed in a controlled and consistent manner rather than through ad hoc SQL.

The package is classified as OTHER in the ETRM registry, indicating it is not exposed as a public, fully versioned business API but rather functions as an internal utility supporting the deployment factor configuration and maintenance flows. Its dependency list is deliberately narrow: within APPS it references only PER_DPF_SHD, and at the system level it depends on the SYS.STANDARD package. This tight dependency footprint, combined with the fact that it is referenced by no other package, confirms its role as a leaf-level deletion routine invoked directly by the calling form or program rather than a shared library component.

Key Procedures and Functions

The ETRM metadata documents two program units within the package — the package specification and the package body — and records a single named programmatic entry point:

• DEL — The deletion procedure. Its purpose is to remove a Deployment Factors record, identified by the caller, from the PER_DEPLOYMENT_FACTORS table. Because PER_DPF_SHD is listed as a dependency, the procedure is also responsible for propagating the deletion to the corresponding shadow table, which exists to track audit and change history for the deployment factors entity. The verified metadata does not document a parameter list for this procedure; consulting the package source in the target instance is required to determine the exact argument signature and any return or error-raising behavior.

No additional procedures or functions are documented for this package.

Tables Accessed

• PER_DEPLOYMENT_FACTORS — The primary table accessed, referenced through an APPS synonym. This is the base table that stores deployment factor definitions. The DEL procedure writes to it by removing the target row.
• PER_DPF_SHD — The shadow table for the deployment factors entity. The package's dependency on PER_DPF_SHD indicates that the deletion routine also performs the corresponding removal on the shadow record, keeping the audit history consistent with the primary data.

Usage Notes

PER_DPF_DEL is an internal Oracle HRMS utility and is not intended as a public extension surface. It is typically invoked indirectly from the standard Oracle Forms interface when an administrator deletes a deployment factor definition, or from the concurrent or concurrent-processing logic associated with that entity. Because the package is referenced by no other package, custom code should not assume a stable, published signature; integrators who need to remove deployment factor data are advised to use the supported form-based or API-based routes rather than calling PER_DPF_DEL directly.

Where custom code must interact with this package, it should be treated as an unsupported call. Direct invocation bypasses the validation logic a form might otherwise apply, and because the procedure manipulates both PER_DEPLOYMENT_FACTORS and PER_DPF_SHD, any direct use risks leaving the shadow table inconsistent if the operation is interrupted. In 12.1.1 and 12.2.2 environments the package should be verified as VALID before use; the ETRM registry lists its status as VALID at the documented revision.