Search Results get_menu_id

Overview

IRC_GRANTS_UTIL is a utility package body owned by the APPS schema in Oracle E-Business Suite. Its documented purpose is to support the iRecruitment module's use of the Oracle Fusion Middleware (formerly Oracle Internet Directory) grants model, which governs fine-grained authorization to web-based menu functions. The single documented entry point, CREATE_GRANTS, performs a bulk provisioning routine: it identifies candidate end users who hold a given responsibility and then creates the corresponding grant records required for those users to access a specific permission set (RM/UMX menu). The package belongs to the UTIL classification, indicating it is a helper/back-office routine rather than a user-facing API, and is typically driven by administrative or concurrent processing rather than interactive forms.

Key Procedures and Functions

One procedure is documented in the ETRM metadata for version 12.2.2:

• CREATE_GRANTS — The primary routine that provisions grants for a defined population of users. Its internal logic resolves the target permission set to a menu identifier, resolves the supplied responsibility key to a responsibility identifier, and then selects eligible users from the intersection of FND_USER and FND_USER_RESP_GROUPS who do not already possess a matching grant. The procedure takes an error buffer and return code (standard concurrent-program out parameters) alongside responsibility and permission-set inputs, and writes grants for each qualifying user.

Internally the procedure relies on three declared cursors, including the cursor named get_menu_id, which resolves FND_MENUS.MENU_NAME from the supplied permission-set name using an uppercase comparison. The routine also declares PL/SQL associative-array types for bulk collection of user IDs, user names, responsibility IDs, application IDs, and security group IDs, indicating a bulk-bind or bulk-insert strategy for grant creation.

Tables Accessed

• FND_GRANTS — The target table for insert operations; also read to exclude users who already hold a grant for the given menu and responsibility, preventing duplicate provisioning.
• FND_MENUS — Read by the get_menu_id cursor to translate the permission-set name into a numeric menu identifier.
• FND_RESPONSIBILITY — Read to resolve the responsibility key to a responsibility ID and application ID.
• FND_USER — Read to validate candidate users, their active date ranges, and to skip seeded/internal accounts (user_id greater than 1000).
• PLITBLM — The PL/SQL table/array support object referenced for the bulk collection types used during processing.

Usage Notes

Because the procedure exposes concurrent-program style errbuf and retcode parameters, CREATE_GRANTS is most likely invoked from a concurrent program or an administrative wrapper rather than from an end-user form. It is used when an administrator needs to mass-provision Oracle grants for every active user holding a specific responsibility, for example after enabling a new permission set. The user search performed via get_menu_id reflects the fact that grants are keyed by menu identifier, so the permission set name must correspond exactly to an existing entry in FND_MENUS; case is normalized to uppercase. Environments with large active user populations should expect the routine to process candidates in bulk, and its date-range filter means users with expired or future-dated assignments are excluded automatically. Customizations should reference the documented CREATE_GRANTS entry point rather than internal cursors, since the helper logic is not part of the published interface.