Search Results hxc_tcc_del




Overview
Explore in AI Chat

Overview

HXC_TCC_SHD is an Oracle Application Object Library package in the APPS schema that serves as the shadow (SHD) implementation layer for the HXC Time Category Components (TCC) entity within Oracle Time and Labor. In Oracle EBS 12.1.1 and 12.2.2, shadow packages encapsulate the low-level Data Manipulation Language operations and validation logic that the generated Table Handler (or "BUS" business layer) packages invoke during insert, update, delete, and lock operations on the underlying base table. HXC_TCC_SHD provides the reusable internal routines consumed by HXC_TCC_INS, HXC_TCC_UPD, HXC_TCC_DEL, and HXC_TCC_BUS, shielding callers from the physical structure of the HXC_TIME_CATEGORY_COMPS table and centralizing concurrency checking, constraint validation, and attribute conversion.

A secondary role of the package is evident from its dependency relationship with APPS.HXC_TIME_CATEGORY_UTILS_PKG. HXC_TIME_CATEGORY_UTILS_PKG references HXC_TCC_SHD, confirming that the utilities package relies on this shadow layer's low-level primitives when performing category-related operations. The package is fully VALID and API classification is recorded as OTHER, meaning it is not exposed as a public, supported business API for external integration but is instead a technical infrastructure component.

Key Procedures and Functions

  • RETURN_API_DML_STATUS — Reports the success or failure status of the most recent DML operation executed through the package, allowing the calling Table Handler to determine whether to commit, rollback, or raise an application error. Standard for the multi-row DML pattern used by EBS Table Handlers.
  • CONSTRAINT_ERROR — Centralizes handling of constraint-related failures. It inspects the ALL_CONSTRAINTS dictionary view to identify the specific constraint that was violated and maps it to a user-facing or developer-diagnostic error message, supporting the generic constraint-checking pattern documented for this shadow package.
  • API_UPDATING — Indicates whether an API-driven update is currently in progress on the entity, preventing recursive or conflicting DML. This flag is consulted by the Table Handler layer before permitting direct updates.
  • LCK — Implements the locking routine used to obtain and verify a row-level lock on HXC_TIME_CATEGORY_COMPS, ensuring optimistic and pessimistic concurrency control consistent with Oracle Forms and concurrent processing behavior.
  • CONVERT_ARGS — Normalizes and converts the arguments passed from the generated Table Handler into the internal representation expected by the shadow layer, including datatype and NULL handling for the component columns.

Tables Accessed

The package operates against HXC_TIME_CATEGORY_COMPS (accessed via APPS synonym), the base table storing the composition or component definitions that make up time categories in OTL. Insert, update, delete, and lock operations performed by the dependent Table Handler packages are physically routed through this shadow package to that table. The package also queries ALL_CONSTRAINTS, the data dictionary view exposing constraint definitions, to resolve and report constraint violations during CONSTRAINT_ERROR processing.

Usage Notes

HXC_TCC_SHD is not intended for direct invocation by end users or custom integrations. It is invoked indirectly:

  • By the generated Table Handler packages HXC_TCC_INS, HXC_TCC_UPD, HXC_TCC_DEL, and HXC_TCC_BUS when Oracle Forms or concurrent programs manipulate time category components.
  • By HXC_TIME_CATEGORY_UTILS_PKG, which calls into the shadow layer to reuse its low-level DML and validation primitives.
  • Through the Oracle Forms-based setup UI for Time and Labor time categories, and through any concurrent program or workflow that creates or updates time category components.

Custom code should never call HXC_TCC_SHD directly; supported operations should use the documented public APIs or the Time Category business layer. When troubleshooting OTL time category errors, DBAs commonly trace calls into HXC_TCC_SHD to isolate constraint violations reported by CONSTRAINT_ERROR or lock contention surfaced by LCK.