Search Results move_folder

Overview

FND_APPTREE is a server-side PL/SQL package owned by the APPS schema that implements the application folder tree (the "Navigator" / hierarchical menu tree) used throughout Oracle E-Business Suite. The package provides the programmatic API for creating, maintaining, querying, and reorganizing the nodes that make up the folder hierarchy displayed to end users in the EBS forms Navigator and related tree controls. It is the maintenance counterpart to the runtime routines that render the tree, and it is the supported entry point for any code that must manipulate folder definitions without direct DML against the underlying tables. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than those of its owner.

Key Procedures and Functions

• GET_FOLDER_PROPERTIES — Returns the attributes of a single folder identified by its folder ID, including the object name, node label, folder type, value, sequence, parent folder ID, owning user, and the public flag. It is the standard read accessor for folder metadata.
• INSERT_FOLDER — Creates a new folder node under a specified parent and returns the generated folder ID. The caller supplies the object name, node label, folder type, value, parent folder ID, public flag, language, and user ID, and may optionally position the new node after an existing folder via the after_folder_id argument.
• UPDATE_FOLDER — Modifies an existing folder node. Only the attributes the caller wishes to change need to be supplied; unchanged parameters default to a sentinel value, which allows selective maintenance of label, type, value, sequence, parent, public flag, and language.
• UNIQUE_NAME — Returns a folder name that is guaranteed not to collide with existing siblings under the same parent for the given object name and user. It is used to generate safe display or internal names during folder creation.
• DELETE_FOLDER — Removes a folder node from the tree, identified by folder ID.
• MOVE_FOLDER — Reparents an existing folder and optionally resequences it relative to a sibling. It returns a status value indicating the outcome of the operation.

Tables Accessed

The package reads and writes the folder tree definition tables through APPS synonyms: FND_TREE_FOLDERS and FND_TREE_FOLDERS_S. The base table stores the folder hierarchy and node attributes, while the _S table holds the translatable (language-specific) node labels used when folders are displayed in multiple languages. DUAL is referenced for scalar evaluations and default derivation. The package does not expose these tables directly; all persistence is encapsulated behind the six documented routines.

Usage Notes

FND_APPTREE is typically invoked from Oracle Forms that maintain tree and folder definitions, from concurrent programs that build or refresh folder structures, and from custom PL/SQL that needs to extend or reorganize the Navigator. Because it is documented and referenced by twelve other packages, it should be treated as a stable integration point: callers should invoke INSERT_FOLDER, UPDATE_FOLDER, MOVE_FOLDER, and DELETE_FOLDER rather than issuing DML against FND_TREE_FOLDERS, so that sequencing, uniqueness, and translation rows remain consistent. When creating nodes programmatically, UNIQUE_NAME should be used to avoid sibling name conflicts, and INSERT_FOLDER's after_folder_id parameter should be supplied whenever a specific position in the tree is required. Because the package runs as the invoker, the calling session must already possess the necessary privileges on the underlying folder tables.