Search Results ass_attribute




Overview
Explore in AI Chat

Overview

APPS.HR_TIM_BUS is the business-layer package body responsible for managing HR form template items within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Form templates define the configurable layout and content that Oracle HRMS uses to render legislative and statutory forms, and template items represent the individual configurable elements that populate those forms. HR_TIM_BUS encapsulates the validation and business rules applied whenever a template item record is inserted, updated, or deleted, including the enforcement of key flexfield segment combinations.

The package follows the standard Oracle HRMS business-layer convention: a corresponding table handler would normally invoke HR_TIM_BUS from its row-level validation hooks, allowing the package to centralize multi-table integrity checks and derived attribute logic. The package header is referenced by three other packages in the APPS schema, indicating that HR_TIM_BUS also serves as a shared utility for template item validation across the HRMS form generation stack. In this context, the concept of an "attribute" relates to the configurable properties carried by template items, which the validation routines interrogate before permitting persistence.

Key Procedures and Functions

  • SET_SECURITY_GROUP_ID — A stub implementation in the R12 code level. This procedure accepts a template item identifier and performs no operation, because form template items carry no business group context and therefore no security group applies. It exists to satisfy the uniform business-layer interface signature used across HRMS table handlers.
  • RETURN_LEGISLATION_CODE — Returns the legislation code associated with a given template item. It derives the value by joining the base template item row to its owning form template and reading the template's legislative designation. This supports downstream legislative filtering and date-tracked validation.
  • CHK_NO_FLEX_SEGMENT_COMB — Validates that no key flexfield segment combination has been supplied where one is not permitted for the template item being processed. This is the guard that prevents inappropriate flexfield attribute assignment on template item records.
  • INSERT_VALIDATE — Performs all business-layer validation required before a new HR_FORM_ITEMS_B row is created. Logic consolidates the checks above so that the table handler can invoke a single validation entry point.
  • UPDATE_VALIDATE — Applies equivalent validation when an existing template item is modified, ensuring attribute changes remain consistent with template and legislative constraints.
  • DELETE_VALIDATE — Confirms that a template item may be removed without violating referential or business rules applicable to the owning template.

Tables Accessed

  • HR_FORM_ITEMS_B — The primary subject of the package. Validation routines read and evaluate the attributes of rows in this table, and the insert, update, and delete validators gate changes to it.
  • HR_FORM_TEMPLATES_B — Read to resolve the legislation code and template-level context for a given template item, since the item inherits much of its governing behavior from the parent template.
  • HR_TEMPLATE_ITEMS_B — Joined in the legislation code lookup to traverse from the template item identifier through the template structure to the owning form template.

Access is performed through APPS synonyms in the standard manner, and all reads are consistent with the multi-org and legislative data security model enforced elsewhere in HRMS.

Usage Notes

HR_TIM_BUS is not intended for direct invocation by end users or concurrent programs. It is invoked programmatically by the HR_FORM_ITEMS_B table handler and by the three dependent packages that reference it, most likely during form template maintenance performed through the HRMS form template setup windows and through the Template Item generation and migration utilities.

Developers writing custom code against HRMS templates should not call the validate routines directly; the supported path is to insert or update the base table, allowing the table handler to route the row through HR_TIM_BUS. Where custom logic must pre-check a proposed change, RETURN_LEGISLATION_CODE provides a safe read-only interface. Patch application to the HRMS legislative data set frequently delivers new versions of this package body, so customizations should never modify it in place; use a wrapping or event-based extension instead.