Search Results check_delete_role_ok

Overview

APPS.PA_ROLE_UTILS is a utility package within the Oracle E-Business Suite Projects (PA) module that centralizes validation and lookup logic for project role definitions and role lists. It belongs to the API classification OTHER, meaning it is not a formal public API but rather an internal helper package invoked by Oracle Forms, concurrent programs, and other PL/SQL packages to enforce business rules around roles, role lists, and role-based security. The package consolidates routines for converting between role names and role identifiers, validating role membership in role lists, checking whether a role or role list is eligible for deletion, and managing role-based security grants. Because the package header carries the "noship" designation, it is a shipping utility intended for internal use rather than customer extension.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions. CHECK_ROLE_NAME_OR_ID converts a role name to its identifier or validates a supplied identifier according to a check flag. CHECK_ROLE_ROLELIST performs the same resolution for both a role and a role list, and additionally verifies that the role belongs to the specified role list. GET_ROLE_DEFAULTS returns default attributes for a role. VALIDATE_ROLE_COMPETENCY checks that a role is associated with a valid competency. GET_SCHEDULABLE_FLAG determines whether a role is schedulable.

• CHECK_DELETE_ROLE_OK and CHECK_DELETE_ROLE_LIST_OK verify that a role or role list may be safely deleted, protecting referential integrity.
• CHECK_REMOVE_CONTROL_OK determines whether a role control may be removed from a role.
• UPDATE_MENU_IN_GRANTS, DISABLE_ROLE_BASED_SEC, and ENABLE_ROLE_BASED_SEC manage role-based security by maintaining menu grants and toggling the security state.
• IS_ROLE_IN_USE reports whether a role is currently referenced elsewhere in the system.
• CHECK_DUP_ROLE_NAME and CHECK_DUP_ROLE_LIST_NAME detect duplicate names before insertion, enforcing uniqueness.

The user query "check_remove_control_ok" corresponds directly to one of these routines, indicating a search related to removing role controls.

Tables Accessed

The package reads and writes several PA and HRMS tables through APPS synonyms. PA_PROJECT_ROLE_TYPES_B and PA_ROLE_LISTS supply the core role and role list definitions. PA_ROLE_CONTROLS and PA_ROLE_LIST_MEMBERS support role control removal and role list membership validation. PA_RBS_ELEMENTS and PA_RESOURCE_LIST_MEMBERS underpin role-based security and resource list logic. PA_PROJECT_ASSIGNMENTS, PA_PROJECT_PARTIES, and PA_PROJECTS_ALL are consulted to determine whether a role is in use across project data. PER_COMPETENCES provides competency validation. DUAL is used for simple single-row evaluations. Together these tables allow the package to enforce integrity rules before any destructive or assignment operations proceed.

Usage Notes

PA_ROLE_UTILS is referenced by twenty other packages, confirming its role as shared infrastructure within the Projects suite. It is typically invoked from Oracle Forms when users define or maintain roles and role lists, and from other PL/SQL packages performing pre-validation before DML. Custom code should call these routines rather than duplicating validation logic, ensuring consistent error handling through the standard return status and error message code outputs. Because it is classified as OTHER rather than a public API, its signatures are not guaranteed across releases; any custom dependency should be validated during upgrades from 12.1.1 to 12.2.2. The NOCOPY out parameters and default values on check flags reflect performance-oriented design consistent with the R12 codebase.