Search Results set_group_by2




Overview
Explore in AI Chat

Overview

The APPS.OKE_FUNDING_INQUIRY package body is a component of Oracle E-Business Suite's Oracle Contracts Core (OKE) module, which underpins project funding, contract deliverables, and version-controlled contract terms. In EBS 12.1.1 and 12.2.2, this package serves as a supporting inquiry utility that exposes and manages session-level state used by the Funding Inquiry user interface. Its primary business function is to hold, retrieve, and expose "major version" and "group-by" selection criteria that a user establishes while browsing funding and version-number data associated with contracts and projects.

The metadata classifies this object as an OTHER API rather than a public, formally supported interface, indicating that it is intended primarily for internal consumption by OKE forms and related inquiry logic rather than for direct customer invocation. The package body is documented as VALID in the APPS schema and is referenced by two other database objects, confirming its role as a shared utility within the OKE stack.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within the package body. Their purposes are as follows:

  • SET_MAJOR_VERSION — Establishes the active major version number within the package's session state, so subsequent inquiries filter results against the selected version.
  • SET_GROUP_BY1, SET_GROUP_BY2, SET_GROUP_BY3 — Set up to three configurable grouping attributes that control how funding inquiry results are aggregated or organized.
  • MAJOR_VERSION — Returns the currently selected major version, allowing callers to read back the value set by SET_MAJOR_VERSION.
  • GROUP_BY1, GROUP_BY2, GROUP_BY3 — Retrieve the respective grouping selections previously established through their setter counterparts.
  • GET_VERSION_DATE — Returns the effective date associated with the current version context, supporting date-sensitive version comparisons.

Together these routines implement a simple getter/setter pattern that persists user inquiry preferences for the duration of a session. No parameter lists are documented, and none should be assumed.

Tables Accessed

The package body references a single documented table through APPS synonyms: OKE_K_VERS_NUMBERS_H. This is the version-numbers history table for the Contracts (OKE) schema, storing version numbering and effective-date information. The package reads this table to resolve major version values and their associated version dates, which the getter functions then surface to the inquiry UI. Because the object is classified as an inquiry package, the predominant access pattern is read-oriented.

Usage Notes

OKE_FUNDING_INQUIRY is typically invoked indirectly. The Funding Inquiry forms in Oracle Contracts, together with dependent OKE packages (it is referenced by two other database objects), call these procedures and functions to initialize and query session-level version and grouping parameters. Developers extending or debugging the funding inquiry workflow may encounter this package when tracing how a form determines which version and grouping context to display. Because the object is classified as OTHER and not as a supported public API, custom code should avoid depending on it directly; instead, standard OKE APIs and views should be used where available. Any direct invocation carries upgrade risk across EBS releases.