Search Results autonomous_transaction

Overview

FND_APPFLDR is an Oracle E-Business Suite (EBS) Application Object Library (AOL) package body owned by the APPS schema that manages the metadata behind Oracle EBS "folders" functionality. Folders (previously known as Folder Tools) allow end users to personalize the layout, query criteria, and displayed columns of an Oracle Forms block through a runtime folder window, rather than through form design changes. The package persists folder definitions and their constituent column definitions, and exposes insertion, update, and deletion entry points for both folder headers and folder columns.

Its API classification per the ETRM metadata is OTHER, indicating that it is intended primarily as an internal implementation package for the folder framework rather than a formally supported public integration API. The header comment indicates the source file is AFFLDRB.pls, with a 2005 revision (120.1) shipped as part of the FND code family.

Key Procedures and Functions

• INSERT_FND_FOLDERS — a function that creates a new folder definition row. It obtains a surrogate folder identifier from the FND_FOLDERS_S sequence and returns that identifier to the caller, recording the object, name, language, window width, public and autoquery flags, an optional WHERE clause, an optional ORDER BY clause, and audit columns.
• INSERT_FND_FOLDER_COLUMNS — a procedure that adds a single column (item) definition to an existing folder, capturing display mode, item name, sequence, item width, item prompt, and x/y positioning together with audit information.
• INSERT_FND_DEFAULT_FOLDERS — inserts default folder rows, establishing the out-of-the-box folder configuration used when a user has not previously personalized the block.
• UPDATE_FND_FOLDERS — modifies an existing folder header, allowing attributes such as naming, flags, or tailoring clauses to be revised.
• DELETE_FND_DEFAULT_FOLDERS — removes default folder definitions.
• DELETE_FND_FOLDER_COLUMNS — removes individual column definitions belonging to a folder.
• DELETE_FND_FOLDERS — removes a folder header, typically as part of a broader cleanup of folder metadata.

Tables Accessed

• FND_FOLDERS — the master store of folder definitions, written by INSERT_FND_FOLDERS and UPDATE_FND_FOLDERS and read by the delete and default routines.
• FND_FOLDERS_S — the sequence used to generate unique FOLDER_ID values for new folders.
• FND_FOLDER_COLUMNS — the child store of per-column folder metadata, populated by INSERT_FND_FOLDER_COLUMNS and purged by DELETE_FND_FOLDER_COLUMNS.
• FND_DEFAULT_FOLDERS — the seeded default folder configuration managed by INSERT_FND_DEFAULT_FOLDERS and DELETE_FND_DEFAULT_FOLDERS.
• DUAL — used to fetch the next sequence value for the folder identifier.

All references are made through APPS synonyms, consistent with standard AOL naming conventions.

Usage Notes

FND_APPFLDR is typically invoked indirectly. The most relevant characteristic is the PRAGMA AUTONOMOUS_TRANSACTION declared in the routines visible in the source excerpt, notably INSERT_FND_FOLDERS and INSERT_FND_FOLDER_COLUMNS. This pragma causes the routine to run in its own transaction, independent of the caller’s transaction, and it commits explicitly before returning. In consequence, folder metadata written by this package is durable even if the calling form’s main transaction later rolls back.

Because the autonomous transaction commits independently, callers must avoid assuming that an outer rollback will undo folder insertions. Folders are normally created and maintained from the Oracle Forms folder customization UI rather than by direct custom code, and the ETRM metadata records no other packages referencing this one, reinforcing its role as a framework-internal component that should be used with caution in customizations.