Search Results fnd_request_groups_s

Overview

FND_RESPONSIBILITY_PKG is the core PL/SQL package body in the APPS schema that maintains the definition of Oracle E-Business Suite responsibilities. A responsibility binds an application, a menu, a request group, and a data group into a single security and navigation construct that is assigned to users. This package provides the programmatic interface for creating, updating, translating, loading, and deleting responsibility rows in the FND_RESPONSIBILITY, FND_RESPONSIBILITY_S, and FND_RESPONSIBILITY_TL tables, together with the supporting validation against menus, applications, data groups, and request groups. In release 12.1.1 and 12.2.2, the object is reported by ETRM as VALID in the APPS schema with an API classification of OTHER. Its dependency list confirms references to both the base table FND_REQUEST_GROUPS and its sequence-backed view FND_REQUEST_GROUPS_S, which is the object most commonly associated with the search term "fnd_request_groups_s." The package is not referenced by any other database object, indicating it is an entry point rather than a utility called internally by other packages.

Key Procedures and Functions

The documented interface comprises eleven procedures and functions:

• INSERT_ROW — creates a new responsibility definition and its associated translated and security rows.
• LOCK_ROW — acquires a row-level lock on an existing responsibility prior to modification.
• UPDATE_ROW — modifies attributes of an existing responsibility record.
• TRANSLATE_ROW — maintains the language-specific responsibility name and description held in FND_RESPONSIBILITY_TL.
• LOAD_ROW — used by the standard loader/upload utilities to insert or update a responsibility from an external definition file.
• DELETE_ROW — removes a responsibility definition and its dependent rows.
• ADD_LANGUAGE — inserts the translated rows required when a new language is installed or activated for existing responsibilities.
• RESP_SYNCH — synchronizes responsibility data, including the relationship to request groups and data groups.

The presence of LOCK_ROW, INSERT_ROW, UPDATE_ROW, and DELETE_ROW identifies this as a table-handler style API rather than a business-event API; callers are responsible for validation sequencing and commit control.

Tables Accessed

• FND_RESPONSIBILITY — the base responsibility definition (application, menu, request group, data group, flags).
• FND_RESPONSIBILITY_S — the sequence-backed view used to generate the responsibility identifier.
• FND_RESPONSIBILITY_TL — language-specific responsibility name and description.
• FND_APPLICATION — validates the owning application of the responsibility.
• FND_MENUS_VL — validates the menu assigned to the responsibility.
• FND_REQUEST_GROUPS and FND_REQUEST_GROUPS_S — validate and resolve the request group attached to the responsibility.
• FND_DATA_GROUPS and FND_DATA_GROUP_UNITS — validate the data group and its unit assignments.
• FND_LANGUAGES — drives language handling in TRANSLATE_ROW and ADD_LANGUAGE.
• WF_PARAMETER_LIST_T and DUAL — used for supporting parameter and singleton constructs.

Usage Notes

The package is invoked by the Responsibilities form and by the standard concurrent programs that load and upload seed data, including the FNDLOAD-based migration path in which LOAD_ROW and TRANSLATE_ROW are the loader entry points. ADD_LANGUAGE is triggered during language installation and patching so that new languages receive translated responsibility names. RESP_SYNCH is used to reconcile responsibility configuration, particularly where request group or data group assignments have changed. Custom code may call INSERT_ROW, UPDATE_ROW, and DELETE_ROW directly, but should invoke LOCK_ROW first and should leave the transaction open for the calling program to commit, since the package performs only the row-level data manipulation.