Results for “per_dpf_bus”

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

Overview

PER_DPF_BUS is an Oracle EBS business-layer PL/SQL package owned by the APPS schema that encapsulates the validation and legislative-processing logic for Deployment Factors maintained by Oracle Human Resources. In Oracle EBS 12.1.1 and 12.2.2, deployment factors are configuration records used to control how person and assignment deployment data is derived and applied, particularly for global deployment and localization scenarios. The PER_DPF_BUS package acts as the business rule engine sitting between the deployment factor base tables and the DML layer, ensuring that insert, update, and delete operations conform to application-level integrity rules before they reach the database. The package is documented in ETRM as a VALID object with an API classification of OTHER, and it is recorded as referencing PER_DEPLOYMENT_FACTORS and PER_DPF_SHD, while being referenced by the PER_DPF_DEL, PER_DPF_INS, and PER_DPF_UPD packages that form the table-handler layer for the deployment factor entity.

Key Procedures and Functions

ETRM documents four callable units within PER_DPF_BUS:

• INSERT_VALIDATE — Performs business-rule validation for new deployment factor records prior to insertion. It confirms that the proposed row satisfies the required constraints for the entity so that the table handler PER_DPF_INS can proceed with the physical insert.
• UPDATE_VALIDATE — Validates modifications to existing deployment factor records before the update is applied. It is invoked by the PER_DPF_UPD table handler to ensure changed values remain consistent with the deployment factor model.
• DELETE_VALIDATE — Determines whether an existing deployment factor row may be removed, allowing the PER_DPF_DEL table handler to enforce referential and business restrictions before deletion.
• RETURN_LEGISLATION_CODE — Returns the legislation code associated with the deployment factor being processed. This supports the legislative/territory-driven behavior of deployment factors, which frequently vary by country or legislative context.

No parameter lists are documented in ETRM; the descriptions above reflect the documented names and their evident validation/return roles.

Tables Accessed

The package operates against the following documented objects:

• PER_DEPLOYMENT_FACTORS — The primary deployment factor entity table. PER_DPF_BUS reads existing rows to evaluate insert, update, and delete validation conditions.
• PER_DPF_SHD — The shadow table associated with the deployment factor entity, used to support the date-tracked or audit copy of the base records.
• FND_TERRITORIES — Referenced to resolve territory-level information needed when determining the applicable legislation code for a deployment factor.

Access is performed through APPS synonyms rather than direct schema-qualified references.

Usage Notes

PER_DPF_BUS is an internal business-layer package and is not intended for direct invocation by end users. It is normally called indirectly: the PER_DPF_INS, PER_DPF_UPD, and PER_DPF_DEL table handlers invoke the corresponding validate routines, and those handlers may in turn be driven by Oracle HRMS forms, concurrent programs, or localization setup flows that maintain deployment factors. Custom code or extensions that manipulate PER_DEPLOYMENT_FACTORS should follow the same pattern, routing changes through the documented table handlers so that INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE execute as designed. Because the package is validated and owned by APPS, it is supported across both 12.1.1 and 12.2.2, and direct procedural calls should be treated as unsupported. RETURN_LEGISLATION_CODE is useful to callers needing the legislative context of a deployment factor without duplicating territory lookup logic.