Results for “per_dpf_ins”

36 results




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

Overview

PER_DPF_INS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented as ETRM class OTHER. Its name follows the Oracle HRMS convention for deployment factor processing, where "DPF" denotes deployment factors and "INS" denotes the insert-oriented routine contained within the package. The package supplies the low-level data manipulation layer for the deployment factor entity in Oracle Human Resources (PER), which is the module responsible for capturing the percentage of an employee's time or cost charged to a given assignment, organization, or project.

Deployment factors are reference data used by HR and by downstream applications such as Oracle Project Manufacturing, where the distribution of labor across organizational units must be recorded and later consumed by costing. PER_DPF_INS therefore provides a controlled, server-side path for creating deployment factor rows, isolating callers from the physical table structures and allowing Oracle to enforce its own validation, audit, and multi-tenant partitioning logic in a single place.

The package operates against the HRMS secured schema. Its dependency on PER_DPF_SHD indicates that the underlying table is protected by a shadow table used for the HRMS date-tracked or audit mechanism, meaning inserts routed through this package participate in the standard Oracle date-tracked entity pattern.

Key Procedures and Functions

The ETRM metadata documents a single procedure, INS, within the package. Consistent with the naming convention and with the dependency on the shadow table, INS is the insertion routine that creates a deployment factor record. It encapsulates the physical insert against the base table and the corresponding shadow-table maintenance so that the date-tracked representation of the record remains synchronized. Because the package is classified as OTHER rather than as a published public API, the routine is intended for internal consumption by Oracle's own code rather than as a supported extension point for customer development.

No parameter list is documented, and the routine should not be invoked speculatively without confirming the signature from the Package Body in the target instance. Callers are expected to supply deployment factor attributes such as the deployment factor identifier, the associated assignment or organization, the effective dates, and the factor value, but the exact argument sequence is version-specific.

Tables Accessed

The package reads and writes PER_DEPLOYMENT_FACTORS, the base table storing deployment factor definitions and their effective-dated attributes, and PER_DEPLOYMENT_FACTORS_S, its shadow table. The shadow table holds the row-level history required by the HRMS date-tracked entity mechanism, so an insert through INS results in coordinated writes to both objects. Access is made through APPS synonyms, which is standard for delivered HRMS code and ensures the package resolves correctly regardless of the invoking session's schema.

Usage Notes

PER_DPF_INS is referenced by two other delivered packages: HR_DEPLOYMENT_FACTOR_API and PQH_PTX_UTL. HR_DEPLOYMENT_FACTOR_API is the public wrapper through which forms, concurrent programs, and customer code are expected to maintain deployment factors; PQH_PTX_UTL is used by Oracle Public Sector / position transaction processing. The self-reference to PER_DPF_INS confirms internal recursion or shared helper usage within the package body.

Direct calls from custom code are strongly discouraged. Integrations and extensions should use HR_DEPLOYMENT_FACTOR_API so that validation, security, and date-track handling remain intact. When troubleshooting, confirm the object status is VALID in ALL_OBJECTS and recompile dependencies after any HRMS patch, since an invalid package body here will cascade to the two dependent packages and block deployment factor maintenance in the affected environment.