Search Results hr_contract_bk2




Overview
Explore in AI Chat

Overview

HR_CONTRACT_BK2 is a private helper package in the APPS schema that supports the Oracle E-Business Suite Human Resources contract management functionality. In the Oracle EBS 12.1.1 and 12.2.2 releases, the HR_CONTRACT_API package exposes the public, documented entry points used by other applications, forms, and interfaces to create, update, and delete employee contract records stored in the PER_ALL_ASSIGNMENTS_F and related contract tables. HR_CONTRACT_BK2 serves as the internal "before" and "after" processing companion to that public API.

The "BK" naming convention denotes a package that contains the procedural logic that fires before and after the main API operation, allowing the primary API to remain thin while business validation, derived-column population, date-tracked (DateTrack) handling, and secondary-table synchronization are delegated to the helper package. The ETRM metadata classifies this object with an API classification of OTHER, indicating it is not itself an integration-facing API but rather an internal component of the HR contract framework.

Key Procedures and Functions

The documented package exposes two procedures that correspond to the standard Oracle API "before" and "after" processing pattern:

  • UPDATE_CONTRACT_B — the "before-update" routine. It performs pre-processing and validation work required prior to modifying a contract record, including checks on the incoming contract data before the base row change is applied.
  • UPDATE_CONTRACT_A — the "after-update" routine. It executes post-processing logic once the contract update has been persisted, handling any dependent actions or downstream consistency steps required by the contract model.

The "_B"/"_A" suffixes are the conventional Oracle EBS marker for before-image and after-image processing. Together they wrap the UPDATE operation of the public HR_CONTRACT_API so that callers need only invoke the API, while the sequencing and validation logic remains encapsulated here. The metadata does not document parameter lists, and none are reproduced or inferred here.

Tables Accessed

The supplied ETRM extract does not enumerate base tables for this package. Oracle's metadata records table references through APPS synonyms, and for HR_CONTRACT_BK2 the documented table list is empty—all DML is executed against the HR contract tables through the owning API rather than directly from this package. In the HR contract model the underlying data is held principally in PER_ALL_ASSIGNMENTS_F (the DateTracked assignment/contract row) and its associated contract and assignment-extra-information tables. HR_CONTRACT_BK2 operates on the in-memory record structures passed down from HR_CONTRACT_API and applies its before/after logic against those structures, which is why no independent table dependency is recorded. This design keeps the validation logic decoupled from direct SQL and consistent with the API framework.

Usage Notes

HR_CONTRACT_BK2 is not intended for direct invocation. Its documented caller is the public package APPS.HR_CONTRACT_API, and it is additionally self-referenced (HR_CONTRACT_BK2 appears both as a referenced-by and referencing entry), confirming internal use. The package also references the SYS.STANDARD package, the standard PL/SQL built-in library available to all stored programs. Because the package status is VALID and no invalidation is reported, it compiles cleanly against the current schema.

In practice, the procedures are executed indirectly whenever an application or interface calls HR_CONTRACT_API to update a contract—for example from the Contract Management or Assignment forms, from concurrent programs that mass-update contract data, or from custom code integrated through the public API. Developers extending HR contract behavior should continue to call HR_CONTRACT_API and must not bypass it by invoking HR_CONTRACT_BK2 directly, as doing so would skip the surrounding sequencing that the before/after contract depends upon.