Search Results update_otlr_add_assign_info

Overview

HXT_GEN_AAI is an Oracle Application Object Library PL/SQL package owned by the APPS schema that supports the Oracle Time and Labor (OTL) module within Oracle E-Business Suite 12.1.1 and 12.2.2. The package name derives from "HXT" (the OTL application short name) and "GEN AAI," which refers to the generation and maintenance of Additional Assignment Information. Additional Assignment Information extends the standard HR assignment record with time-and-labor-specific attributes — earning policies, rotation plans, shift differential policies, hour deduction policies, and the auto-generation-of-hours flag — that govern how an assignment's time is processed, costed, and validated.

The package is declared as AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling user rather than the package owner, a design choice typical of OTL generation APIs that must respect invoker context. Its header comment ($Header: hxtgenai.pkh 115.3 2003/09/09 ...) indicates the package dates back to the 11.5 code line and was carried forward substantially unchanged into 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents three procedures in this package:

• AAI_VALIDATIONS — Validates the set of policy identifiers and flags supplied for an assignment before any insert or update is committed. It accepts the assignment identifier, earning policy, rotation plan, shift differential policy, hour deduction policy, the auto-generation flag, and an effective start date, and confirms that the referenced policies and plans are consistent and valid for that assignment and date range.
• CREATE_OTLR_ADD_ASSIGN_INFO — Inserts a new Additional Assignment Information row into the underlying OTL table. It accepts the record identifier, effective start date, assignment identifier, auto-generation flag, rotation/earning/shift differential/hour deduction policy identifiers, standard WHO audit columns (created by, creation date, last updated by, last update date, last update login), and the descriptive flexfield attribute columns.
• UPDATE_OTLR_ADD_ASSIGN_INFO — Applies changes to an existing Additional Assignment Information row, preserving the date-effective history maintained by the OTL datetrack model.

Tables Accessed

Through APPS synonyms, the package reads and writes the following tables:

• HXT_ADD_ASSIGN_INFO_F — the primary date-effective table holding Additional Assignment Information rows; the insert and update procedures target this table.
• HXT_EARNING_POLICIES, HXT_EARNING_RULES, HXT_SHIFT_DIFF_POLICIES, HXT_SHIFT_DIFF_RULES, HXT_HOUR_DEDUCT_POLICIES, HXT_ROTATION_PLANS, HXT_ROTATION_SCHEDULES, HXT_WEEKLY_WORK_SCHEDULES — OTL policy and schedule definition tables validated by AAI_VALIDATIONS.
• HXT_SEQNO — supplies sequence numbers for new records.
• PAY_ASSIGNMENT_LINK_USAGES_F and PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F — payroll tables consulted to confirm element link and element type relationships for the assignment.
• PLITBLM — the OTL time-and-labor PL/SQL index table used for internal row processing.

Usage Notes

HXT_GEN_AAI is an internally invoked OTL generation API. The ETRM metadata records that no other PL/SQL package references it, indicating it is called from client-side code and concurrent processes rather than from a package-to-package dependency chain. Typical invocations include the OTL Additional Assignment Information maintenance form, concurrent programs that mass-create or mass-update assignment-level time-and-labor attributes, and DataLoad or API-driven population of OTL configuration during implementation.

Because the package executes AUTHID CURRENT_USER and performs date-effective inserts, callers should invoke it within the standard OTL concurrent manager environment or a session where the invoking user holds the necessary APPS synonym privileges. Customizations should call CREATE_OTLR_ADD_ASSIGN_INFO rather than inserting directly into HXT_ADD_ASSIGN_INFO_F to preserve validation and audit-column integrity.