Search Results set_group_by3




Overview
Explore in AI Chat

Overview

OKE_FUNDING_INQUIRY is a PL/SQL package in the APPS schema belonging to the Oracle E-Business Suite Oracle Knowledgebase and Contracts (OKE) module, which provides the technical foundation for Oracle Project Contracts and associated funding, versioning, and inquiry functionality. The package is declared with AUTHID CURRENT_USER, meaning that its unqualified database references resolve against the privileges of the invoking session rather than the package owner; callers therefore require direct grants on the underlying objects. Its documented classification in the ETRM repository is OTHER, indicating that it is an internal supporting package rather than a published public API with committed interface guarantees.

Functionally, the package acts as a session-level state holder and metadata accessor for the funding inquiry feature. It exposes setters and getters for a "major version" value and for three separate grouping attributes, together with a routine that retrieves the version date for a given header and version combination. This pattern is characteristic of Oracle Forms-based inquiry screens in EBS 12.1.1 and 12.2.2, where the form records the user's chosen version and grouping criteria in package-level state so that subsequent queries and block refreshes can reuse them consistently within the session.

Key Procedures and Functions

  • SET_MAJOR_VERSION — Stores the currently selected major version in package state for later retrieval during the same session.
  • SET_GROUP_BY1, SET_GROUP_BY2, SET_GROUP_BY3 — Store up to three grouping attributes used to control how funding inquiry results are aggregated or ordered.
  • MAJOR_VERSION — Returns the major version previously stored by SET_MAJOR_VERSION.
  • GROUP_BY1, GROUP_BY2, GROUP_BY3 — Return the corresponding grouping attributes previously stored by the setter routines.
  • GET_VERSION_DATE — Returns the effective date of a specified version for a specified header, accepting a header identifier and version number as inputs.

These nine documented routines are all lightweight interface elements; no business logic beyond state retention and single-row version date lookup is attributed to the package in the ETRM metadata.

Tables Accessed

The only documented table reference is OKE_K_VERS_NUMBERS_H, accessed through an APPS synonym. This table holds version numbering header information for OK E contract or knowledgebase entities. The package reads it within GET_VERSION_DATE to resolve the date associated with a particular header and version, supporting the version-date display on the funding inquiry screen. The setters and getters for major version and grouping attributes operate purely on package state and do not require table access.

Usage Notes

Because the package is referenced by two other packages and includes no autonomous transaction or DML logic, it is intended to be invoked from Oracle Forms event triggers and from other PL/SQL programs that need to share the current inquiry context. Typical invocation points include form-level WHEN-NEW-FORM-INSTANCE and block query triggers that set the major version and grouping values before executing a query, and item-level triggers that call GET_VERSION_DATE to populate a display field. Custom code may call the getters to read the user's current selection without re-prompting, but developers should note that the package-level variables are session-scoped and the package is not documented as a committed public interface, so reliance on it outside the delivered forms carries upgrade risk between 12.1.1 and 12.2.2.