Search Results chk_name

Overview

APPS.HR_HTL_BUS is the business-rule layer of the HR High Throughput Lookup (HTL) API family, delivered as part of the Oracle E-Business Suite HRMS schema in release 12.1.1 and 12.2.2. The package body implements server-side validation logic used by the generated HTL API stack against the HR Knowledge Information (KI) hierarchy model. Its principal responsibility is to enforce data integrity before DML operations are permitted against the underlying hierarchy and translated-name tables.

The body is a row handler in the Oracle Designer/HTL generated pattern. It declares private package globals, including a package name identifier (g_package) and two variables — g_hierarchy_id and g_language — reserved exclusively for the return_legislation_code function. Several procedures begin by testing hr_htl_shd.api_updating before performing any work, ensuring that validation only proceeds when the shared row handler is operating in an update context. This design keeps the business layer stateless with respect to the caller and consistent with other HR HTL row handlers.

Key Procedures and Functions

• INSERT_VALIDATE — Executed prior to the physical insert of a hierarchy row. It validates that the incoming record satisfies mandatory attribute and referential requirements before the insert is attempted.
• UPDATE_VALIDATE — Invoked before an update is applied. It confirms the record exists and that the proposed attribute changes are permissible, rejecting attempts to modify columns designated as non-updateable.
• DELETE_VALIDATE — Runs before deletion to ensure the target hierarchy row may be removed without violating business constraints.

These validate procedures are accompanied by the private helper chk_non_updateable_args, which takes a record of type hr_htl_shd.g_rec_type. The helper compares the populated incoming record against g_old_rec, the package variable holding current database values, and raises an application error if any non-updateable attribute has been altered. This call is guarded by hr_htl_shd.api_updating so that the check fires only when a row genuinely exists for the current record in the HR schema.

Tables Accessed

• HR_KI_HIERARCHIES — The base hierarchy definition table. It is read during validation to confirm row existence and to populate g_old_rec, and it is the target of the insert, update, and delete operations overseen by the validate procedures.
• HR_KI_HIERARCHIES_TL — The translation (MLS) table holding language-specific hierarchy names and descriptions. The package references it through APPS synonyms when validating translated attributes and when resolving language-specific rows for the current session.

Usage Notes

HR_HTL_BUS is not intended for direct invocation by end users. It is called by the higher-level HTL API entry points, which pass records of type hr_htl_shd.g_rec_type and rely on this package to raise application errors when business rules are breached. Typical call paths originate from the HRMS hierarchy maintenance forms in the Oracle Applications Forms runtime, from concurrent programs performing bulk hierarchy loads, and from custom PL/SQL that uses the authorized HTL API rather than inserting into the KI tables directly. Because the package is referenced by three other packages within the APPS schema, changes to its validation behavior can affect downstream consumers; it should therefore be treated as a stable internal interface and superseded only through Oracle-supplied patches. The chk_name search term reflects the naming convention applied to the check-type private helpers that guard attribute validation throughout the HR HTL package family.