Search Results submit_req

Overview

GL_DAS_DB_PKG is a database package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package supports the Definition Access Set feature of Oracle General Ledger. Definition Access Sets provide a security and authorization mechanism that controls which users or responsibilities may view, create, update, delete, or authorize specific General Ledger definitions, such as accounts, budgets, and recurring journals. GL_DAS_DB_PKG encapsulates the core database operations used to assign definitions to access sets and to trigger the flattening program that materializes the effective access rules.

Because it is declared with AUTHID CURRENT_USER, the package executes with the privileges of the invoking user rather than the definer, which means callers must possess the appropriate privileges on the underlying tables. The package header is tracked under the source control header gldefacs.pls.

Key Procedures and Functions

• INSERT_SUPER — Assigns a definition to the Super User Definition Access Set. The parameters include a row identifier, the definition access set identifier, the object type and object key identifying the definition, and the user, login, and date audit values. Its purpose is to ensure the designated definition is exposed to the predefined Super User access set.
• INSERT_DEFAULT — Assigns a definition to the default definition access sets associated with the current responsibility. It operates on the object type and object key, plus the user, login, and date audit values. This procedure is used when a definition must be made available automatically under the default access configuration of a responsibility.
• SUBMIT_REQ — A function that submits the definition access set flattening program, returning a numeric status value. The flattening program resolves the assignment records into their effective form. This is the routine most commonly associated with the "submit_req" search, and it is the entry point used when callers need to request that the flattening concurrent process be launched after assignments change.

Tables Accessed

The package operates against two documented tables, accessed through APPS synonyms:

• GL_DEFAS_ASSIGNMENTS — Stores the assignment of individual definitions to definition access sets. INSERT_SUPER and INSERT_DEFAULT write assignment rows into this table.
• GL_DEFAS_RESP_ASSIGN — Stores the association between definition access sets and responsibilities. This table underpins the default access set behavior that INSERT_DEFAULT relies upon when determining the current responsibility's default sets.

Usage Notes

GL_DAS_DB_PKG is an internal database layer, not a documented public API. It is typically invoked indirectly from the General Ledger Definition Access Sets forms and related setup components rather than being called directly by end users. The INSERT_SUPER and INSERT_DEFAULT procedures are called when definitions are assigned to the Super User or default access sets, and SUBMIT_REQ is called to launch the flattening program so that assignment changes take effect. Custom code should treat this package as subject to change, since it is classified as OTHER and is not part of Oracle's supported public interface. The metadata records no dependent packages, and the package is not referenced by other documented packages, which confirms its position as a lower-level implementation object within the Definition Access Sets subsystem.