Search Results per_in_asg_leg_hook




Overview
Explore in AI Chat

Overview

PER_IN_ASG_LEG_HOOK is an APPS-owned PL/SQL package classified in the ETRM repository as an "OTHER" API component within the Oracle E-Business Suite Human Resources (PER) module. Its name reflects its role as a validation hook associated with assignment legislative data — specifically the processing that occurs when assignment records are created or modified and must be validated against legislative, organizational, and soft-coding rules. Rather than serving as a general-purpose public API, the package functions as a supporting hook invoked indirectly during assignment-related processing.

The package is documented as VALID in both the 12.1.1 and 12.2.2 releases, and the ETRM record shows it is referenced by exactly one other package, HR_ASSIGNMENT_BK2. This dependency confirms its placement within the assignment business logic chain: HR_ASSIGNMENT_BK2 is a dated-track (BK2) assignment processing unit, and PER_IN_ASG_LEG_HOOK supplies the specialized legislative validation logic that the assignment logic calls out to at the appropriate point in the transaction.

Key Procedures and Functions

  • CHECK_ASG_UPDATE — The sole documented procedure in the package. Its name indicates that it performs a validation or eligibility check when an assignment update is being processed. It encapsulates the rules that determine whether a proposed assignment change satisfies the applicable legislative and organizational constraints before the change is committed. Because ETRM documents only the procedure name and not its signature, the exact parameter list should be confirmed against the deployed package specification in the target instance before any direct invocation is attempted.

Tables Accessed

The ETRM metadata records four base tables referenced through APPS synonyms, each consistent with the package's validation purpose:

  • PER_ALL_ASSIGNMENTS_F — The primary dated assignment table. The hook reads the current and prospective assignment rows to evaluate the update request against existing assignment data.
  • HR_ALL_ORGANIZATION_UNITS_TL — Supplies translated organization names and attributes, allowing the validation logic to resolve organizational context for the assignment being processed.
  • HR_SOFT_CODING_KEYFLEX — Provides soft-coding key flexfield definitions and segment values, used to validate any soft-coding applied to the assignment.
  • FND_SESSIONS — The Applications session table, referenced to establish session and user context during validation, a common pattern in EBS server-side validation routines.

Usage Notes

PER_IN_ASG_LEG_HOOK is an internal hook package and is not intended to be called directly by custom code or concurrent programs. Its single documented caller, HR_ASSIGNMENT_BK2, drives invocation as part of the standard assignment processing flow. Practically, this means the procedure executes when assignment records are inserted or updated through supported HR forms, dataloaders, or public assignment APIs that ultimately reach the BK2 logic layer, such as the Assignment form and related People/Assignment maintenance UIs.

Because the package's interface is undocumented beyond the procedure name, any attempt to reference it from custom PL/SQL, personalizations, or extensions carries upgrade risk; the package is subject to change without notice across EBS patch levels. Development teams should treat it strictly as internal HR infrastructure, trace behaviour through HR_ASSIGNMENT_BK2, and validate all findings against the live package specification in the specific EBS instance being analyzed.