Search Results create_grants

Overview

APPS.IRC_GRANTS_UTIL is a utility package in the Oracle E-Business Suite that belongs to the iRecruitment (IRC) product family. Its classification within the ETRM metadata is that of a utility (UTIL) package, indicating that it provides shared, low-level helper logic rather than a self-contained business transaction API. In the Oracle EBS 12.1.1 and 12.2.2 environments, the package is present in the APPS schema in a VALID state.

The central business purpose of IRC_GRANTS_UTIL is the programmatic provisioning and maintenance of Oracle EBS grant records. Grants are the mechanism by which specific users are given explicit access to a menu, function, or responsibility, independent of the underlying responsibility-based security model. The single documented entry point, CREATE_GRANTS, exists to generate those grant records on demand. In the iRecruitment context, this utility allows the application to extend access to recruiting-related menus or functions to named users without altering their assigned responsibilities.

The ETRM documentation lists no other procedures or functions beyond CREATE_GRANTS, and the package is not referenced by any other database package. This confirms its role as a leaf-level utility that is called by forms, concurrent programs, or custom extensions rather than by other PL/SQL APIs.

Key Procedures and Functions

The ETRM metadata documents exactly one callable program unit within IRC_GRANTS_UTIL:

• CREATE_GRANTS — The sole documented procedure. Its purpose is to create grant records in the EBS security tables, providing a specific user with access to designated menus, functions, or responsibilities. Parameter lists are not exposed in the ETRM excerpt and should not be assumed; the procedure should be referenced through the package specification at runtime rather than inferred.

Because CREATE_GRANTS is the only documented entry point, there are no additional public helpers, private utility routines, or overloaded variants described in the metadata. The package body remains the authoritative source for any internal logic.

Tables Accessed

The documented table references, resolved through APPS synonyms, define the scope of the package’s data access:

• FND_GRANTS — The primary target of the CREATE_GRANTS procedure. This table stores individual grant records linking a grantee to a menu, function, or responsibility.
• FND_MENUS — Read to validate and identify the menu to which a grant applies.
• FND_RESPONSIBILITY — Read to resolve responsibility definitions, since grants can be issued against responsibilities as well as menus.
• FND_USER — Read to validate the grantee, confirming that the user to whom access is being granted exists in the EBS user repository.
• PLITBLM — The PL/SQL table of line/column metadata used by Oracle Forms. Its presence indicates that the package includes forms-oriented data handling, typically for passing multi-row selections from an iRecruitment form into the grant-creation logic.

No application tables outside the FND security schema are documented, reinforcing the package’s narrow, security-centric remit.

Usage Notes

IRC_GRANTS_UTIL is invoked indirectly. It is designed to be called from iRecruitment forms or concurrent programs that require users to be granted access to recruiting menus or functions as part of a business flow. Typical triggers include assigning a hiring manager or recruiter access to specific iRecruitment functionality without modifying their responsibility set.

The package is not referenced by any other PL/SQL package, so custom code is the most likely external caller. Developers extending iRecruitment should invoke CREATE_GRANTS rather than writing directly to FND_GRANTS, because the utility encapsulates the validation and formatting expected by the EBS security model. Because the documented interface is limited to this one procedure, any custom integration should confirm the runtime signature from the package specification and be aware that the package body, not the metadata, contains the complete implementation of the grant-creation logic.