Search Results hxt_seqno




Overview
Explore in AI Chat

Overview

HXT_GEN_AAI is an Oracle Application Object Library package body 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. Its core business purpose is the generation and maintenance of Additional Assignment Information (AAI) records for time entry and payroll costing purposes. In OTL, rotation plans, shift differential policies, earning policies, and hour deduction policies can each carry secondary assignment attributes — element, cost, or accounting information — that must be validated, created, or updated whenever an assignment is associated with a rotation plan or earning rule. HXT_GEN_AAI centralizes that logic so that dependent packages, including HXT_ADD_ASSIGN_INFO_F, can persist consistent AAI rows without embedding policy-specific validation rules in every consumer. Because it is a package body and is not referenced by any other database object, its procedures are invoked internally by the Time and Labor application layer rather than exposed as a standalone public API.

Key Procedures and Functions

The package body exposes three documented program units:

  • AAI_VALIDATIONS — Performs the validation logic that determines whether an AAI record is valid for a given assignment and policy context before creation or update. It checks the applicable rotation, shift differential, earning, and hour deduction policy definitions to confirm that the requested additional assignment information is permitted.
  • CREATE_OTLR_ADD_ASSIGN_INFO — Creates a new OTL Additional Assignment Information record, applying the results of AAI_VALIDATIONS and populating the HXT_ADD_ASSIGN_INFO_F entity with the derived element, cost, and policy details.
  • UPDATE_OTLR_ADD_ASSIGN_INFO — Modifies an existing OTL Additional Assignment Information record when assignment, policy, or rule data changes, preserving referential integrity with the underlying HR and payroll link records.

No parameter signatures are documented for these units, so callers must consult the package specification (HXT_GEN_AAI) directly to determine the exact PL/SQL interface.

Tables Accessed

The package reads and writes the following objects, all referenced through APPS synonyms:

Usage Notes

HXT_GEN_AAI is invoked indirectly whenever an OTL user saves or submits time that is governed by rotation plans, shift differentials, earning rules, or hour deduction policies. Typical entry points include the Time and Labor self-service time entry pages, the OTL concurrent programs that rebuild or validate assignment-level cost information, and internal calls from HXT_ADD_ASSIGN_INFO_F and related HXT packages. Because the package is VALID and not referenced by any other database object, it should be treated as an internal implementation unit rather than a documented callable API; customizations that require AAI behavior should call the documented HXT_ADD_ASSIGN_INFO_F interfaces instead of HXT_GEN_AAI directly. The HXT_SEQNO sequence is shared with other HXT objects, so any custom code that consumes sequence values must expect gaps when transactions roll back.