Search Results per_grd_bus




Overview
Explore in AI Chat

Overview

APPS.PER_GRD_BUS is a business layer PL/SQL package within the Oracle E-Business Suite Human Resources (HRMS) module. It serves as the validation and security-context handler for the Grade entity, which represents a compensation grade or grade structure used in HRMS and Payroll. The package is defined with AUTHID CURRENT_USER and is classified as an Other API in the ETRM metadata, indicating it is primarily designated for Internal Development Use Only rather than as a public, supported API for customer extensions.

Functionally, PER_GRD_BUS encapsulates the business rules required to create, modify, and delete grade records, and it manages the multitenancy construct of Oracle EBS by resolving the correct business group security context for a given grade before any downstream operations are performed. In Oracle EBS 12.1.1 and 12.2.2, business group context is fundamental because grade definitions are partitioned by legislation and business group, so PER_GRD_BUS ensures that DML against grade tables is performed under the correct security_group_id.

The package name derives from "GRD" (grade) and "BUS" (business logic layer), following the standard Oracle Forms-generated table handler architecture: a base table (e.g., PER_ALL_GRADES), a business layer (this package), and an API layer. The header comment carries a version marker (pegrdrhi.pkh 120.0) consistent with an Oracle Forms-driven, generated handler package.

Key Procedures and Functions

The ETRM metadata documents five procedures/functions within this package:

  • SET_SECURITY_GROUP_ID — Sets the security_group_id in CLIENT_INFO to establish the appropriate business group context for the current session, based on the primary key p_grade_id. A prerequisite is that the grade identified by the primary key already exists; otherwise an error is raised. This is a mandatory first step in the handler sequence for grade operations.
  • RETURN_LEGISLATION_CODE — Returns the legislation code associated with a specific primary key value (p_grade_id). The caller passes the grade's primary key, and the package returns the business group's legislation code. If the value does not exist, an error is raised.
  • INSERT_VALIDATE — Performs business-rule validation before a new grade record is inserted into the base tables.
  • UPDATE_VALIDATE — Performs business-rule validation before an existing grade record is modified.
  • DELETE_VALIDATE — Performs business-rule validation before a grade record is deleted.

All five procedures are governed by the standard handler sequence used throughout Oracle HRMS: security initiation, business validation, and finally DML via the corresponding API layer. No parameter lists are documented in the ETRM metadata; the descriptions above reflect only the documented purpose of each procedure.

Tables Accessed

PER_GRD_BUS references the following tables (through APPS synonyms) to read or write grade and related HRMS data:

  • PER_GRADES — The principal grade definition table holding grade names and attributes.
  • PER_GRADE_DEFINITIONS — Stores grade definitions associated with grade structures and legislation context.
  • PER_VALID_GRADES — Maintains valid grade assignments used for validation cross-checks.
  • PER_BUDGET_ELEMENTS — Holds budget element data used for grade-related validation.
  • PER_SALARY_SURVEY_MAPPINGS — Maps grades to salary survey data, ensuring grade changes remain consistent with configured survey mappings.
  • HR_ALL_POSITIONS_F and PER_ALL_ASSIGNMENTS_F — Referenced to support validation such as checking whether a grade is in use by positions or assignments before update or delete operations.

The presence of the date-tracked tables HR_ALL_POSITIONS_F and PER_ALL_ASSIGNMENTS_F indicates the package enforces referential integrity across the HRMS entity model during grade maintenance.

Usage Notes

PER_GRD_BUS is intended for Internal Development Use Only. It is typically invoked by the Oracle Forms-based Grade window (Grade Define form) or by the AutoInstall-generated Forms handler flow, and it is referenced by four other packages within the ETRM inventory. Custom code should not invoke these procedures directly unless intentionally extending Oracle's HRMS grade handler path.

In Oracle EBS 12.1.1 and 12.2.2, the behavior is consistent, but the package must be run under an APPS session with a valid business group context. Concurrent programs or APIs that manipulate grade data indirectly reach this package through its dependent packages. Because the procedures rely on CLIENT_INFO for security context, callers must ensure SET_SECURITY_GROUP_ID is executed first whenever a grade-level operation is initiated outside the forms flow.