Search Results hr_assignment_bk5




Overview
Explore in AI Chat

Overview

APPS.HR_ASSIGNMENT_BK5 is a companion "BK" (booking) PL/SQL package within the Oracle E-Business Suite Human Resources (HR) module. It operates in the APPS schema and carries a status of VALID in the ETRM metadata for Oracle EBS 12.1.1 and 12.2.2. The package is classified under the "OTHER" API category, indicating that it is not part of the primary public API surface but instead functions as an internal helper used to support the main assignment maintenance API.

The package participates in the maintenance of employee assignment records, which represent the link between a person and their position, job, organization, payroll, and other assignment attributes. In the Oracle HR architecture, "BK" packages such as HR_ASSIGNMENT_BK5 typically provide the pre-processing (Before) and post-processing (After) logic that bookends the core business logic executed by an associated "_B" and "_A" procedure pair. The "BK5" suffix signals that this is the fifth in a series of such booking packages supporting the HR_ASSIGNMENT_API, confirming its role as a supplementary routine rather than an entry point invoked directly by end users.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package:

  • UPDATE_APL_ASG_B — The "before" procedure paired with an assignment update operation. It is designed to execute pre-validation and setup logic prior to the main update of the assignment record. The "_B" suffix conventionally denotes "Before," meaning this routine runs ahead of the core DML so that dependent attributes, validations, or derived values are prepared first.
  • UPDATE_APL_ASG_A — The corresponding "after" procedure. The "_A" suffix denotes "After," so this routine runs following the main update to perform post-processing, such as synchronizing related records, recalculating derived data, or applying follow-on effects that depend on the completed update.

No parameter lists are documented in the ETRM metadata, and the exact signatures should be confirmed by inspecting the package source in the database before direct invocation. The naming convention strongly implies these procedures are invoked internally by the parent API rather than called directly.

Tables Accessed

The ETRM metadata does not enumerate specific tables accessed via APPS synonyms for this package. Based on its documented dependency on APPS.HR_ASSIGNMENT_API and its assignment-update purpose, this package should be understood as operating against the HR assignment data model — the core assignment records and their associated assignment extra-information and date-tracked attributes. Because no table list is documented, the safest practice is to treat the actual read/write footprint as defined solely by the package source and to avoid assuming a schema beyond the assignment tables implied by the package name. Confirmation of specific tables should be obtained through static analysis of the compiled package body or by querying the ALL_SOURCE view for HR_ASSIGNMENT_BK5.

Usage Notes

HR_ASSIGNMENT_BK5 is referenced by one other package, HR_ASSIGNMENT_API, and references STANDARD and SYS. This confirms it is a subordinate component of the HR assignment API stack, not a standalone callable API. It is not exposed through a form, concurrent program, or public interface in the documented metadata, and there is no indication that customers or developers should invoke it directly.

Typical invocation occurs implicitly whenever the HR_ASSIGNMENT_API performs an assignment update: the API calls the UPDATE_APL_ASG_B and UPDATE_APL_ASG_A routines to bracket the transactional update. Developers building custom extensions should call HR_ASSIGNMENT_API rather than HR_ASSIGNMENT_BK5, and should rely on the documented API contract to ensure the before/after logic executes correctly. Any direct dependency on HR_ASSIGNMENT_BK5 risks breakage across patch levels, since internal "BK" packages are not part of Oracle's supported public API and may change without notice.