Search Results chk_no_flex_segment_comb




Overview
Explore in AI Chat

Overview

APPS.HR_TIM_BUS is a business-layer PL/SQL package within the Oracle E-Business Suite 12.1.1 / 12.2.2 Human Resources (HR) module. It belongs to the family of "BUS" (business) wrapper packages generated by the Oracle HRMS API framework, which sit between the user-facing layer (forms, concurrent programs, and public APIs) and the underlying table-handling (TAB) packages. The package name and header reference hrtimrhi.pkh, confirming it is generated from the HRMS API template used to build row-handler interfaces for entities that do not have a full public API.

The object it governs is the template item entity, identified by the primary key template_item_id. Template items belong to the HR form/template configuration model used to define the structure of HRMS forms and templates (for example, the layout of configurable forms and their constituent fields). The package exposes internal validation and security-group management routines rather than a public transactional API, and its access status is explicitly documented as "Internal Development Use Only." It is declared AUTHID CURRENT_USER, meaning its programs execute with the privileges of the invoking schema.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents six procedures/functions in the package body:

  • SET_SECURITY_GROUP_ID — Sets the security_group_id in CLIENT_INFO for the appropriate business group context. The header comments note that for template items no business group context applies and security group is not applicable, but the routine is retained as part of the standard generated template.
  • RETURN_LEGISLATION_CODE — Returns the legislation code associated with a given primary key value. This may be null in certain cases. It supports legislation-specific validation logic.
  • CHK_NO_FLEX_SEGMENT_COMB — A validation routine (the object the user searched for) that checks flexfield segment combinations. It is invoked during insert/update processing to enforce key flexfield combination validity for template item records.
  • INSERT_VALIDATE — Performs row-level validation logic before an insert into the template item table. It enforces required attributes, references, and cross-field rules.
  • UPDATE_VALIDATE — Performs row-level validation logic before an update, ensuring modified values remain consistent and valid.
  • DELETE_VALIDATE — Performs validation before a delete, typically checking that dependent rows or referential constraints permit removal.

Per the header comments, prerequisites for these routines require the primary key identified by template_item_id to already exist, and post-failure behavior raises an error.

Tables Accessed

The package operates against three base tables via APPS synonyms:

  • HR_TEMPLATE_ITEMS_B — The primary entity table holding template item definitions. Read/written during insert, update, and delete validation.
  • HR_FORM_TEMPLATES_B — The parent template header table, referenced to validate contextual relationships.
  • HR_FORM_ITEMS_B — The form item definitions referenced by template items, used for validation and flexfield segment combination checks.

Usage Notes

HR_TIM_BUS is flagged "Internal Development Use Only" and is not intended for direct invocation by customers. It is typically called indirectly by generated row-handler packages during DML on template items, or from HRMS configuration forms that manage template items. Because the ETRM metadata shows it is referenced by three other packages, callers should be aware the package is an internal dependency. The CHK_NO_FLEX_SEGMENT_COMB procedure is invoked specifically when validating key flexfield segment combinations against the application's flexfield definitions. Customizations should not call these routines directly; the supported extension points for template item configuration lie in the HRMS public APIs and forms, not in this business-layer package.