Search Results qp_grants_s

Overview

QP_SECURITY is an Oracle Advanced Pricing (Oracle Pricing) security package owned by APPS. It centralizes the security model that governs access to pricing entities such as price lists, modifiers, formulas, and agreements in Oracle E-Business Suite 12.1.1 and 12.2.2. The package resolves the user's identity, organization, and responsibility context from the FND session, then applies grants defined through the Oracle Pricing security framework to determine whether a given pricing object, function, or instance may be created, viewed, or modified. It is classified as a package body under the APPS schema and is referenced by fifteen other packages, indicating that it serves as the shared security kernel for the pricing module rather than an application-specific utility.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. Several are simple session accessors: GET_USER_ID, GET_ORG_ID, GET_RESP_ID, and GET_MENU_MAINTAIN_ID return the current FND user, organization, responsibility, and menu customization identifier respectively, allowing callers to evaluate grants against the active context. GET_OBJECT_ID_FOR_INSTANCE and GET_OBJECT_NAME_FOR_INSTANCE map an instance type (price list, modifier, agreement, formula, or ALL) to the corresponding FND_OBJECTS object identifier or object name, using the cached global G_OBJECT_ID_CACHE to avoid repeated lookups. GET_FUNCTION_ID resolves a function name to its FND_FORM_FUNCTIONS identifier and caches the result in G_FUNCTION_ID_CACHE and G_FUNCTION_NAME_CACHE. SECURITY_ON and CHECK_FUNCTION act as the primary gatekeepers, testing whether security is enabled and whether the current user holds the required function privilege. SET_GRANTS and CREATE_DEFAULT_GRANTS create and persist grant records, with CREATE_DEFAULT_GRANTS establishing baseline grants when none exist. AUTH_INSTANCES determines which pricing instances the user is authorized to access. GET_UPDATE_ALLOWED indicates whether the user may modify pricing data, while QP_ORG_SECURITY enforces organizational restrictions. QP_V_SEC and QP_VL_SEC provide security-aware views over pricing data used by concurrent and form-based queries.

Tables Accessed

The package reads and writes QP_GRANTS and its synonym QP_GRANTS_S to store and evaluate grant definitions by instance type. FND_OBJECTS is queried to translate instance types into object identifiers under application_id 661 (Oracle Pricing). FND_GRANTS supplies the generic grant framework data used to validate privileges. FND_FORM_FUNCTIONS, FND_COMPILED_MENU_FUNCTIONS, and FND_MENUS resolve function and menu privileges tied to the user's responsibility. FND_USER identifies the current user, while QP_LIST_HEADERS_B is referenced when evaluating security on price list headers. DUAL supports singleton computations, and PLITBLM is used during bulk grant maintenance operations. Referenced tables are accessed through APPS synonyms rather than direct schema-qualified names.

Usage Notes

QP_SECURITY is invoked primarily by Oracle Pricing forms and by the pricing APIs and concurrent programs that call those forms' underlying logic. Because fifteen other packages depend on it, customizations that require pricing security enforcement should call its public functions rather than querying QP_GRANTS directly, ensuring consistency with caching behavior and the standard grant model. Custom code can call GET_OBJECT_ID_FOR_INSTANCE with an instance type to obtain the correct FND_OBJECTS identifier before performing its own grant checks, and CHECK_FUNCTION or GET_UPDATE_ALLOWED to verify privilege and update rights. The package caches object, function, and instance-type lookups in package globals for the duration of an FND session, so callers should not assume cache values reflect changes made to QP_GRANTS within the same session.