Search Results lov_data

Overview

APPS.CCT_LKUP_PUB is a public PL/SQL package within the Oracle E-Business Suite ETRM (Enterprise Transaction Resource Manager) module, which underpins the Oracle Applications Manager (OAM) infrastructure for managing application server groups, server instances, and their runtime parameters. The package encapsulates the server-side logic required to populate list-of-values (LOV) data for various server configuration attributes exposed in the administrative user interface. Its central design pattern is the retrieval of a set of allowable or context-sensitive values — collectively referred to as lov_data — for a given server group, server, and server parameter, returned as a collection of strings for rendering in an LOV widget.

Each documented procedure follows a consistent signature convention: it accepts identifiers for the server group, server, and server parameter together with a language code, and returns a count of retrieved values along with the array of lov_data, in addition to the standard concurrent-style OUT parameters for return status, message count, and message data. This uniformity makes the package predictable for its callers and centralizes LOV resolution logic that might otherwise be duplicated across forms and administrative pages.

Key Procedures and Functions

• GET_TRUE_FALSE_LOV — Returns the Boolean-style true/false LOV data applicable to a server parameter, enabling administrators to select between two discrete values.
• GET_JDBC_CONN_LOV — Supplies the set of JDBC connection values available for a given server parameter context, supporting JDBC-based configuration entries.
• GET_TRACE_LOV — Provides valid tracing configuration values, used when administrators set trace or diagnostic levels for a server parameter.
• GET_TEST_TYPE_LOV — Returns LOV data describing applicable test types, used in the context of server parameter validation or testing configuration.
• GET_MW_LOV — Resolves LOV values related to middleware definitions, drawing on the CCT_MIDDLEWARES data to present selectable middleware options.
• GET_ROUTE_POINT_LOV — Returns LOV data for middleware route points, derived from the CCT_MW_ROUTE_POINTS table for routing configuration selection.

Tables Accessed

The package reads from four documented objects (via APPS synonyms): CCT_MIDDLEWARES and CCT_MW_ROUTE_POINTS, which hold middleware definitions and their associated route points and drive the GET_MW_LOV and GET_ROUTE_POINT_LOV procedures; FND_LOOKUP_VALUES, the standard EBS lookup repository that supplies enumerated values such as the true/false and trace options; and PLITBLM, an internal EBS table used in the context of dynamically resolving and formatting LOV data. All access is read-oriented, consistent with the package's lookup role; no transactional writes are implied by the documented interface.

Usage Notes

CCT_LKUP_PUB is classified as a PUB (public) API, indicating it is intended for supported external invocation. In practice it is called by the ETRM administrative forms and pages that render server parameter LOV widgets, supplying the required server group, server, server parameter, and language inputs and receiving back the lov_data collection. Because the procedures accept the standard x_return_status, x_msg_count, and x_msg_data outputs, callers should always check x_return_status for success before consuming x_lov_data, and should use the FND_MSG_PUB API to retrieve error details when the status indicates failure. The package is not referenced by any other documented packages, so custom code integrating with it should treat it as a leaf-level lookup service. The NOCOPY hints on the OUT parameters indicate the package is optimized to pass large collections by reference, which is relevant when the returned lov_data array is sizable.