Search Results set_security_group_id

Overview

APPS.PER_SBT_BUS is a business-rule (BUS) package in the Oracle E-Business Suite Human Resources (PER) schema. It encapsulates the server-side logic for the PER_SUBJECTS_TAKEN entity, which stores the subjects or qualifications an employee or applicant has completed. In the Oracle EBS "Business API" (BUS) architecture, packages following the _BUS naming convention implement the validation and enforcement rules that other APIs, forms, and concurrent processes rely upon when manipulating a given base table.

The package body is generated from the HR API framework template (pesbtrhi.pkb), as indicated by the header revision line. This template-driven structure supplies the standard private globals, the g_package name variable, and the mandatory-argument checking conventions characteristic of HRMS business APIs.

Key Procedures and Functions

ETRM documents four procedures or functions in this package:

• SET_SECURITY_GROUP_ID — Derives the business group / security group context for a row in PER_SUBJECTS_TAKEN. Because the base table carries no business group ID column, the procedure uses an internal cursor (csr_qua_id) to read the qualification_id from PER_SUBJECTS_TAKEN and delegates to per_qua_bus.set_security_group_id. This is the procedure most relevant to the search term "set_security_group_id," and the in-line comment explicitly notes that a native per_sbt_bus.set_security_group_id does not otherwise exist, requiring this derivation workaround.
• INSERT_VALIDATE — Performs row-level validation before an insert into PER_SUBJECTS_TAKEN.
• UPDATE_VALIDATE — Performs row-level validation before an update to PER_SUBJECTS_TAKEN.
• DELETE_VALIDATE — Performs row-level validation before a delete from PER_SUBJECTS_TAKEN.

The validate procedures follow the standard HRMS pattern, applying hr_api.mandatory_arg_error checks and logging entry points through hr_utility.set_location. No parameter lists are published in the supplied metadata, so callers should consult the package specification in the target release before invoking them directly.

Tables Accessed

The only documented table is PER_SUBJECTS_TAKEN, referenced through its APPS synonym. The package reads this table in SET_SECURITY_GROUP_ID to obtain the qualification_id that ties the row to a qualification record. The insert, update, and delete validation procedures operate against the same table to enforce business rules for subject-taken records.

Usage Notes

PER_SBT_BUS is referenced by three other packages within the EBS data model, meaning it is normally invoked indirectly rather than called directly by end users. Typical invocation paths include:

• The Subjects Taken form and related HR self-service pages, which call the _BUS validation routines during insert, update, and delete operations.
• Higher-level HR APIs (for example, qualification or person APIs) that propagate security group context downward and therefore reach SET_SECURITY_GROUP_ID.
• Custom or extension code that must respect HRMS validation and security-group derivation rules rather than writing to PER_SUBJECTS_TAKEN directly.

Because security-group derivation is dependent on the qualification linkage, users extending this entity should be aware that the business group context is inherited from the qualification rather than stored on the subjects-taken row itself. Direct DML on the base table bypasses these validations and is not supported.