Search Results p_rule_set_id

Overview

APPS.PQH_RST_BUS is a business-layer PL/SQL package within the Oracle E-Business Suite HRMS/Enterprise Talent and Recruitment Management (ETRM) schema. It encapsulates the validation and maintenance logic for Rule Sets, the configuration entities that drive rule-based processing across Oracle HRMS modules such as compensation workbench, benefits, and iRecruitment. Rule Sets are defined in the underlying PQH_RULE_SETS and PQH_RULE_SETS_TL tables, where the base table stores the identifier and the translated table holds the user-facing names. PQH_RST_BUS acts as the table handler (row handler) for these entities, providing the standard insert, update, and delete validation entry points invoked by the toolbar and form-level processing on the Rule Set maintenance windows.

Key Procedures and Functions

The package exposes five documented program units, all of which operate as validation or lookup helpers rather than as business transaction APIs:

• RETURN_LEGISLATION_CODE — Returns the legislation code associated with the Rule Set context, allowing downstream logic to apply jurisdiction-specific processing and to restrict which rules or structures may be linked to a given Rule Set.
• GET_ORG_STRUCTURE_VERSION_ID — Resolves the organization structure version identifier linked to the Rule Set, providing the effective-dated view of the organization hierarchy against which the rules will be applied.
• INSERT_VALIDATE — Performs pre-insert validation, confirming that required attributes are populated and that the primary key has not been supplied by the user (the key is generated on insert and is not updatable).
• UPDATE_VALIDATE — Performs pre-update validation, protecting the primary key from modification and verifying that the record is in a state that permits updates.
• DELETE_VALIDATE — Performs pre-delete validation, checking referential and business-rule constraints before the Rule Set may be removed.

An additional private function, GET_RULE_SET_NAME, retrieves the translated rule set name from PQH_RULE_SETS_VL using the p_rule_set_id parameter — the identifier returned when the Rule Set primary key is passed in as p_rule_set_id.

Tables Accessed

The package references the following tables through APPS synonyms:

• PQH_RULE_SETS — the base table holding Rule Set definitions and the primary key rule_set_id.
• PQH_RULE_SETS_TL — the translated (language) table supplying the rule_set_name attribute.
• HR_ALL_ORGANIZATION_UNITS — the organization units used to derive the legislative and organizational context.
• PER_ORGANIZATION_STRUCTURES and PER_ORG_STRUCTURE_ELEMENTS — the organization hierarchy definitions and their element links.
• PER_ORG_STRUCTURE_VERSIONS — the effective-dated hierarchy versions used to return the organization structure version identifier.
• DUAL — used for single-row expression evaluation.

Usage Notes

PQH_RST_BUS is invoked primarily from the Rule Set maintenance forms within Oracle HRMS, where the form's pre-insert, pre-update, and pre-delete triggers call the corresponding validation procedures. It is referenced by three other packages in the ETRM schema, meaning custom extensions that manipulate Rule Sets should route through this handler rather than writing directly to PQH_RULE_SETS to preserve the integrity checks. Because the primary key is generated on insert and immutable thereafter, custom code must never populate rule_set_id on insert; the p_rule_set_id parameter is a read/inbound identifier used for lookups such as GET_RULE_SET_NAME. The package is not a public concurrent-program API and is not intended to be called directly from unmanaged custom code without respecting the documented validation sequence.