Search Results hxc_time_category_comps_s

Overview

APPS.HXC_TCC_INS is a PL/SQL package body belonging to the Oracle E-Business Suite Time and Labor (also known as Time and Labor / OTL) module, and it is delivered in the APPS schema with a documented status of VALID in both EBS 12.1.1 and 12.2.2. The acronym "TCC" in the package name corresponds to Time Category Components, and the suffix "_INS" indicates that the package is dedicated to the insert (creation) side of the Time Category Component entity lifecycle. It therefore provides the programmatic mechanism through which new time category component rows are validated and written to the underlying tables when a user or process defines the composition of a time category — for example, the mapping of a time category to the elements, absence types, or measurement attributes that make up how time is classified and subsequently processed by payroll and costing.

As an "OTHER"-classified, internal (non-public) API, HXC_TCC_INS is not intended as a supported integration point. It functions as a low-level helper invoked by the higher-level Time Category API and business logic, and it exists to centralise the insert logic so that validation, key generation, and row creation are handled consistently across all callers.

Key Procedures and Functions

The documented package exposes a single program unit:

• INS — The sole documented procedure. It performs the insert of a Time Category Component record. Consistent with its role, the procedure is expected to accept identifying and descriptive attributes for the component, validate them, and persist a new row. Because the ETRM metadata does not publish a parameter list, the exact signature should not be assumed; the procedure is described here solely by its purpose of inserting a time category component definition on behalf of callers such as the Time Category API.

No functions are documented for this package body, so the insert path is exposed exclusively through the INS procedure.

Tables Accessed

The package references the following documented tables through APPS synonyms:

• HXC_TIME_CATEGORY_COMPS — The base table storing the Time Category Component records. This is the primary insert target of the INS procedure.
• HXC_TIME_CATEGORY_COMPS_S — The corresponding translated (TL) table that holds the language-dependent, user-facing text for each component, such as the component name or description. The INS procedure is expected to populate this table alongside the base table when the component requires translated content.

Additional dependencies documented for the package body indicate that the insert logic delegates to HXC_TIME_CATEGORY_API, HXC_TCC_BUS, HXC_TCC_RKI (row-key information for who-columns), and HXC_TCC_SHD, and relies on HR_API, HR_UTILITY, HXC_TIME_CATEGORY_UTILS_PKG, FND_GLOBAL (for session/user context), and DUAL. These dependencies confirm that the package is embedded within the standard Time and Labor object framework rather than performing raw, unvalidated inserts.

Usage Notes

HXC_TCC_INS is an internal, non-supported package and is not referenced by any other database object, meaning it sits at the bottom of the call hierarchy for its specific insert responsibility. It is not exposed through an Oracle Forms block, a concurrent program, or a public API directly; instead it is invoked indirectly when a time category component is defined or created through the supported Time Category administration flows and the HXC_TIME_CATEGORY_API. The ETRM record notes that APPS.HXC_TCC_INS is referenced by one other package, which is consistent with its role as a fine-grained helper called from the Time Category API layer. Customisations should never call HXC_TCC_INS directly; any requirement to create or modify time category components should instead use the supported HXC_TIME_CATEGORY_API so that the full validation and row-key handling performed by this package and its collaborators is preserved.