Search Results get_multiselect_count




Overview
Explore in AI Chat

Overview

APPS.JTFB_DCF is a PL/SQL package body in the Oracle E-Business Suite Applications Technology layer, associated with the CRM Foundation (JTF) module. The package supports the Data Collection Framework (DCF) component of Oracle's application architecture. Its primary business function is to manage the metadata that defines user interface regions, attributes, menus, and menu entries used by the framework, while also providing a set of utility routines that support session handling, parameter parsing, list-of-values and graph rendering, and column-level audit configuration. Because the package is classified as OTHER in the ETRM metadata rather than as a public API, it is best understood as internal infrastructure code invoked by framework and upgrade processes rather than as a supported integration point for customer extensions.

Key Procedures and Functions

The documented package exposes ten procedures and functions. The following are the most significant:

  • SECURITY_UPDATE — Removes orphan DCF menus and their associated menu entries. It identifies menus named with the DCF_ prefix that have no active entries and deletes both the menu and any residual menu entries that reference them, committing within the routine.
  • AUDIT_COLUMNS_PATCH — Applies patch logic relating to audit columns, setting up or correcting column-level audit metadata. The name indicates it exists to bring existing audit column definitions into alignment with current release requirements. This is the procedure associated with the user's search term.
  • COPY — Provides a copy capability for framework metadata, allowing collection definitions or related configuration records to be duplicated.
  • GET_ICX_SESSION_ID — Returns the current ICX session identifier, allowing framework code to associate metadata operations with the active user session.
  • GET_PARAMETER_VALUE — Retrieves a named parameter value from the framework's parameter context for use in downstream processing.
  • GET_MULTISELECT_COUNT and GET_MULTISELECT_VALUE — Return the number of selected entries and the value of an indexed selection within a multi-select field, respectively, supporting multi-select region items.
  • LOV_UPGRADE, GRAPH_UPGRADE, and MULTISELECT_UPGRADE — Upgrade routines that migrate list-of-values, graph, and multi-select region item definitions to the current attribute and region structure.

Tables Accessed

The package reads and writes several AK (Application Kit) metadata tables through APPS synonyms: AK_ATTRIBUTES, AK_REGIONS, AK_REGIONS_TL, AK_REGION_ITEMS, and AK_REGION_ITEMS_TL. These store attribute definitions, region definitions, region item definitions, and their translated equivalents, and are the foundation of the framework's region metadata. To manage menus, the package uses FND_MENUS and FND_MENU_ENTRIES, deleting rows through FND_MENUS_PKG.DELETE_ROW and FND_MENU_ENTRIES_PKG.DELETE_ROW in SECURITY_UPDATE. This combination of AK metadata and FND menu tables reflects the package's dual role of managing both region configuration and the navigation menus that surface DCF collections.

Usage Notes

JTFB_DCF is typically invoked indirectly. SECURITY_UPDATE is designed to be executed as part of maintenance or migration activity, often from a concurrent program or a one-time script following an upgrade, to clean up orphaned DCF menus. The upgrade routines (LOV_UPGRADE, GRAPH_UPGRADE, MULTISELECT_UPGRADE) and AUDIT_COLUMNS_PATCH are intended to run during patching or upgrade cycles to transform existing metadata into the current release format. GET_ICX_SESSION_ID, GET_PARAMETER_VALUE, and the multi-select helpers are called at runtime by framework pages and forms to resolve session and parameter context. The package is referenced by three other packages, confirming its role as shared infrastructure. Because the header revision dates to the 11i era (115.23) and the object persists in 12.1.1 and 12.2.2, custom code should avoid direct dependency on these internals; they are subject to change without a documented public interface.