Search Results p_organization_structure_id

Overview

APPS.PER_ORS_BUS is the business-layer PL/SQL package that encapsulates the validation and business rules governing Oracle HRMS organization structures. In Oracle E-Business Suite 12.1.1 and 12.2.2, the object name PER_ORS_BUS is derived from the PER_ORGANIZATION_STRUCTURES entity, and the package sits alongside the generated table-handler packages produced by the HRMS API generator. Its principal role is to enforce data integrity for organization structures before the corresponding DML operations are permitted to proceed, and to expose helper routines required by the organization structure APIs.

The package body is stored under the APPS schema and is treated as an OTHER-classified API rather than a public, callable business API in the conventional sense. The header reflects an internal HRMS implementation file (peorsrhi.pkb) whose private global declarations include g_legislation_code and g_organization_structure_id, both documented as being reserved for use by the return_legislation_code function. The user search term p_organization_structure_id corresponds directly to the primary key parameter used throughout the validation procedures, most visibly in the private chk_org_name routine, which compares the incoming structure identifier against the value stored in PER_ORGANIZATION_STRUCTURES to detect duplicate organization structure names within a business group.

Key Procedures and Functions

• INSERT_VALIDATE — Performs the pre-insert validation checks for a new organization structure row. It is the entry point that the table handler invokes before committing an insert, and it calls the private validation logic such as chk_org_name to prevent duplicate names within the same business group.
• UPDATE_VALIDATE — Performs the pre-update validation checks when an existing organization structure is modified. The p_organization_structure_id value passed here identifies the row being updated so that duplicate-name detection excludes the record itself.
• DELETE_VALIDATE — Performs the pre-delete checks that determine whether the organization structure may be removed, typically by confirming that no dependent records remain in related structures and versions.
• RETURN_LEGISLATION_CODE — Returns the legislation code associated with the organization structure. The private global g_legislation_code exists solely for this function, allowing the legislation context to be cached and reused across calls.
• SET_SECURITY_GROUP_ID — Establishes the security group context for the session so that subsequent validation and DML operations are executed against the correct security profile.

Tables Accessed

• PER_ORGANIZATION_STRUCTURES — The primary entity. Read to validate names, business groups, and the structure identifier; written indirectly through the associated table handler.
• PER_ORG_STRUCTURE_VERSIONS — Referenced to validate version-level dependencies of an organization structure.
• PER_SECURITY_PROFILES — Used in conjunction with security group handling to constrain access to organization structures.
• FND_PRODUCT_INSTALLATIONS — Consulted to confirm installation or licensing status before certain logic is executed.

Usage Notes

PER_ORS_BUS is not normally called directly by end users or custom forms. It is invoked by the HRMS table-handler layer whenever organization structures are created, changed, or deleted, and it is referenced by three other packages within the APPS schema. The validation routines run implicitly during standard DML against PER_ORGANIZATION_STRUCTURES, and error conditions are signalled through hr_utility.set_message and hr_utility.raise_error, with progress tracing emitted via hr_utility.set_location. Custom code should invoke the supported organization structure APIs rather than calling PER_ORS_BUS procedures directly, and any direct reference must supply a valid p_organization_structure_id together with the correct security group context established by SET_SECURITY_GROUP_ID.