Search Results update_apl_asg

Overview

APPS.HR_ASSIGNMENT_BK5 is a generated PL/SQL package body belonging to the Oracle HRMS (Human Resources Management System) API Layer in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its header identifies it as code produced by the Oracle HRMS API Hook Pre-processor, a code generator that produces the "BK" (Business Knowledge / hook) wrapper packages surrounding the public HRMS date-tracked APIs. The package therefore exists to support the assignment update API surface, exposing the pre-processing and hook variant of the assignment (APL_ASG) update operation so that customers and Oracle development can attach business rules, validation, and custom logic to assignment changes without modifying seeding-level code.

Key Procedures and Functions

The ETRM documentation for this object records two procedures.

• UPDATE_APL_ASG_A — The primary documented entry point. It accepts the effective date, the datetrack update mode, and the surrogate identifiers and descriptive attributes required to modify an assignment record: assignment identifier and object version number for optimistic locking; the foreign keys that drive assignment placement such as grade, job, payroll, location, organization, position, supervisor, and recruiter; plus assignment-level attributes including manager flag, normal hours, probation and salary review periods, bargaining unit, employment category, source type, and the descriptive flexfield attribute columns. A corresponding UPDATE_APL_ASG_B procedure is also documented as part of the pair, representing the companion before/after variant of the same update operation within the generated API hook scheme.

No parameter lists are invented here; the parameter set above is drawn directly from the documented package body listing, which begins at line 5 with procedure UPDATE_APL_ASG_A and continues through the full attribute list.

Tables Accessed

The ETRM metadata for this package does not enumerate base tables accessed through APPS synonyms. In practice, a BK wrapper of this type operates against the HRMS assignment entity, whose underlying storage is PER_ALL_ASSIGNMENTS_F for the date-tracked assignment rows and PER_ALL_ASSIGNMENTS_F-related lookup and flexfield structures for the descriptive and key flexfield columns. The surrogate identifiers passed in — assignment, grade, job, payroll, location, organization, position, supervisor, set of books, and the soft coding key flexfield — are validated and resolved against their respective HRMS and FND lookup tables by the API layer invoked downstream. Because this is a generated hook package rather than a data-maintenance package, direct DML is not its purpose; it orchestrates and forwards the update.

Usage Notes

This package is not typically called directly by end users. It is invoked indirectly by the HRMS Assignment form (the People / Assignment window in the Oracle HRMS responsibility), by date-tracked API calls such as HR_ASSIGNMENT_API.UPDATE_APL_ASG, and by concurrent programs or custom code that perform assignment updates through the supported API rather than through direct SQL. The presence of the P_DATETRACK_UPDATE_MODE parameter confirms it participates in Oracle's date-track (datetrack) framework for correcting, updating, or inserting dated assignment rows while preserving history. Customizations should extend the hook procedures rather than alter the generated body, since the header comment ($Header: peasgapi.pkb 120.37.12020000.11) indicates the file is regenerated during patch application. The ETRM listing shows the package is referenced by one other package, consistent with its role as a dependent hook layer rather than a top-level public API.