Search Results hxc_time_category_hook




Overview
Explore in AI Chat

Overview

The APPS.HXC_TIME_CATEGORY_HOOK package is a server-side PL/SQL hook packaged within the Oracle E-Business Suite Time and Labor (HXC) application module. Its business purpose is to provide a controlled extension point for integrating Paid Time Off (PTO) time categories with Oracle Payroll accrual and net calculation logic. In Oracle EBS, a time category classifies the type of time reported by an employee — for example regular hours, overtime, or paid leave. When a PTO time category must be tied to a payroll accrual plan or to a net calculation rule, the automatic creation or maintenance of that linkage is performed through this hook rather than through direct table manipulation.

The package belongs to the Time and Labor product family, but its procedures operate on configuration that spans both HXC (time) and PAY (payroll) schemas, reflecting the cross-product nature of PTO accrual processing. It is classified in ETRM as an OTHER API, meaning it is a supporting hook package rather than a standalone public business API such as those used for time entry or approval. Its declaration in the source header identifies it as a shipped, non-customer-modifiable object.

Key Procedures and Functions

ETRM documents four procedures in this package, operating on PTO time category records:

  • CREATE_PTO_TIME_CATEGORY_A — the primary creation routine invoked to establish a PTO time category association, working with accrual plan and net calculation rule inputs.
  • UPDATE_PTO_TIME_CATEGORY_A — the pre-update (validation/before-image) stage of maintaining an existing PTO time category association.
  • UPDATE_PTO_TIME_CATEGORY_B — the post-update (after-image) stage, paired with the A procedure to complete an update cycle.
  • DELETE_PTO_TIME_CATEGORY_B — the deletion routine that removes the PTO time category linkage, operating on the net calculation rule reference.

The naming convention using the _A and _B suffixes follows the standard Oracle EBS hook pattern, where the A procedure performs work before the core DML and the B procedure performs work afterward. Parameter lists are intentionally omitted here; only the documented procedure names and their intended roles are described.

Tables Accessed

Via APPS synonyms, the package reads and writes the following documented tables:

Together these tables form the configuration chain from a time category through its components to the payroll accrual and net calculation definitions that govern how PTO balances are earned and paid.

Usage Notes

This package is a hook rather than an end-user API; it is typically invoked indirectly by other HXC or payroll setup processes when PTO time categories are created or changed. ETRM records that it is referenced by three other packages, indicating it is called from within the Time and Labor setup logic rather than directly from a form or concurrent program. Custom development should not normally call the procedures directly unless extending the standard PTO configuration flow, since the A/B sequencing must be preserved. Because the package manipulates both HXC and PAY tables, any custom invocation must respect the same validation and integrity rules applied by the standard setup path.