Search Results delete_time_entry_rule_group




Overview
Explore in AI Chat

Overview

The APPS.HXC_TIME_ENTRY_RULE_GROUP_API package body is a public PL/SQL API within the Oracle E-Business Suite Time and Labor (OTL) module. It provides the programmatic interface for maintaining time entry rule groups, which are logical containers that organize the rules governing how employees enter and validate their time. Rule groups allow administrators to categorize time entry rules so that specific sets of rules can be applied to distinct populations of workers, assignments, or organizational units. The package encapsulates the business logic, validation, and persistence operations required to create, modify, and remove these groupings while preserving entity group integrity within the HXC schema.

A notable implementation detail is the package-level variable g_entity_type varchar2(16) := 'TIME_ENTRY_RULES';, which the user searched for. This constant identifies the entity type that the API manipulates. It is passed to internal validation routines such as chk_name so that name-uniqueness checks are scoped correctly to the time entry rules entity family. The companion variable g_package supplies the fully qualified package name for debug tracing, while g_debug tracks whether HR_UTILITY.DEBUG_ENABLED is active, enabling HR_UTILITY.SET_LOCATION diagnostic output throughout execution.

Key Procedures and Functions

  • CREATE_TIME_ENTRY_RULE_GROUP — Creates a new time entry rule group. It issues a savepoint to support validation-only mode, invokes CHK_NAME to verify uniqueness, and calls the corresponding before-process user hook (HXC_TIME_ENTRY_RULE_GROUP_BK_1) to permit customer extensions.
  • UPDATE_TIME_ENTRY_RULE_GROUP — Modifies the attributes of an existing rule group, including its name and object version number, enforcing concurrency control.
  • DELETE_TIME_ENTRY_RULE_GROUP — Removes a rule group record, subject to referential integrity checks performed by CHK_DELETE.
  • CHK_NAME — A validation routine that confirms a proposed rule group name is unique for the TIME_ENTRY_RULES entity type, preventing duplicate groupings.
  • CHK_DELETE — Validates whether a rule group may be safely deleted, typically by confirming it is not referenced by dependent records.

Tables Accessed

  • HXC_ENTITY_GROUPS — The primary table storing entity group definitions. The API inserts, updates, and deletes rule group rows here, using columns such as entity_group_id and object_version_number.
  • HXC_ENTITY_GROUP_COMPS — Stores the components (members) that belong to an entity group. This table supports the association between a rule group and its constituent time entry rules.

Usage Notes

The package is typically invoked from the Time and Labor setup forms where administrators define time entry rules, from concurrent programs that bulk-load rule configurations, and from custom PL/SQL extensions requiring programmatic management of rule groups. Callers should always pass a valid object version number for update and delete operations to respect optimistic locking, and should honor the p_validate convention so that test runs can be rolled back via the package savepoint. Because the API fires before-process user hooks, customer logic can be attached without modifying Oracle-owned code. Applications should treat this package as the supported interface rather than writing directly to the underlying HXC tables, ensuring that validation, concurrency control, and auditing remain consistent.