Search Results hxc_tcc_ins




Overview
Explore in AI Chat

Overview

HXC_TCC_INS is an Oracle Application Object Library package owned by the APPS schema that supports the maintenance of Time Category Component definitions within the Oracle E-Business Suite Time and Labor (HXC) module. Functionally, a "time category component" represents the association between a time category and the building-block elements that roll up into it, allowing an implementation to model how reported, calculated, and earned time is grouped for processing, approval, and transfer downstream.

As classified in the ETRM documentation for release 12.2.2, the package falls under the API classification "OTHER," indicating that it is not one of the primary public APIs (such as HXC_TIME_CATEGORY_COMP_API) intended for external or customer-directed use. It operates as a lower-level supporting package invoked internally, and the documentation records only a single documented entry point, INS. The package is listed with a VALID status, and it depends at runtime upon the APPS synonym HXC_TCC_SHD, which is the shadow-table utility associated with the base component table, as well as the SYS.STANDARD package.

Key Procedures and Functions

The ETRM metadata documents a single procedure/function entry, INS. Consistent with the naming conventions used throughout Oracle EBS HXC packages, INS is the internal insertion routine responsible for creating a new row in the Time Category Component structure. It encapsulates the insert operation so that callers do not write directly to the underlying tables and so that necessary audit columns, identifiers, and shadow-table synchronization are handled uniformly.

  • INS — the documented insertion routine of the package; it records a new Time Category Component definition. As the metadata does not expose parameter signatures, the parameter list is not reproduced here; implementers should treat it as an internal routine whose interface may change between patch levels.

No additional procedures or functions are reported in the documented package metadata; the reference to itself in the dependency listing indicates the package internally resolves its own body and its associated shadow code object.

Tables Accessed

The documented tables referenced through APPS synonyms are:

  • HXC_TIME_CATEGORY_COMPS — the transactional/base table holding Time Category Component records. INS performs its insert against this table.
  • HXC_TIME_CATEGORY_COMPS_S — the corresponding shadow (TL/audit/denormalized) table. Oracle EBS HXC tables conventionally maintain a paired "_S" table for secure, denormalized, or audit-oriented access; INS writes here in step with the base table so that the two remain consistent.

Reads or updates beyond these documented tables are not enumerated in the metadata; the presence of HXC_TCC_SHD in the dependency list confirms that shadow-table maintenance is part of the insertion logic.

Usage Notes

HXC_TCC_INS is referenced by one other package, HXC_TIME_CATEGORY_COMP_API, which is the public-facing API for Time Category Component maintenance. In standard application flow, therefore, INS is reached indirectly when a user or program invokes the public API to define a new time category component; direct invocation from forms, concurrent programs, or custom code is not the documented pattern.

Because the object is classified "OTHER" and exposes only an internal insert entry point, Oracle EBS 12.1.1 and 12.2.2 customizations should call HXC_TIME_CATEGORY_COMP_API rather than HXC_TCC_INS directly. Maintaining the public API as the integration point preserves validation, security, and shadow-table integrity, and avoids dependency on an interface that may be altered by Oracle patches.