Search Results get_system_variables




Overview
Explore in AI Chat

Overview

OKC_XPRT_XRULE_VALUES_PVT_W is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as a private (internal) API under the ETRM metadata for release 12.2.2. It belongs to the OKC (Oracle Contracts) product family, and its name indicates its role: it supports the OKC Expert (XPRT) rules engine by resolving the runtime values assigned to system variables, constants, user-defined variables, and document-level variables involved in rule evaluation.

The package header carries the source identifier OKCWXXRULVS.pls and is marked "noship," a designation indicating it is an internal support object rather than a shipped public interface. It is not intended for direct customer invocation. It functions as a wrapper layer that bridges the strongly typed collection types declared in OKC_XPRT_XRULE_VALUES_PVT and the generic JTF table types used for messaging and UI data transfer within the Oracle Technology Foundation stack.

Key Procedures and Functions

The package exposes nineteen documented procedures, organized into two families.

  • ROSETTA_TABLE_COPY_IN_P4 through P11 and ROSETTA_TABLE_COPY_OUT_P4 through P11: These paired routines convert data between OKC_XPRT_XRULE_VALUES_PVT's internal typed collections — such as sys_var_value_tbl_type, category_tbl_type, item_tbl_type, constant_tbl_type, line_sys_var_value_tbl_type, and udf_var_value_tbl_type — and the generic JTF_VARCHAR2 and JTF_NUMBER_TABLE structures. Each numbered pair corresponds to a particular PL/SQL parameter set, with wider signatures (for example the line system variable variant) carrying additional numeric columns alongside the varchar columns.
  • GET_SYSTEM_VARIABLES: The retrieval routine the searcher referenced; it returns the system variable values applicable to rule evaluation, populating a sys_var_value collection.
  • GET_CONSTANT_VALUES: Returns the constant values used within expert rules.
  • GET_LINE_SYSTEM_VARIABLES: Returns system variable values at the contract line level rather than the header level.
  • GET_USER_DEFINED_VARIABLES: Returns user-defined variable values supplied for rule processing.
  • GET_DOCUMENT_VALUES: Returns document-level values used during rule execution.

Tables Accessed

The only table referenced through APPS synonyms is PLITBLM, an Oracle Technology Foundation/PL/SQL helper table. Its presence reflects the package's role as a plumbing layer — it does not query the OKC contract tables directly. All substantive rule and variable data is exchanged through the collection types defined in OKC_XPRT_XRULE_VALUES_PVT and the JTF table types, rather than through direct table access. This design keeps the wrapper lightweight and consistent with its "noship" internal classification.

Usage Notes

As a private wrapper, OKC_XPRT_XRULE_VALUES_PVT_W is invoked indirectly. The transformation pairs (p4 through p11) are called by the underlying private package whenever ETRM Expert rules must move variable data between IDL-style JTF collections and the OKC native types — typically during contract authoring, rule qualification, or document generation, when variable resolution is required. The GET_* routines are reached from the same Expert execution path rather than from an Oracle Forms window or a standalone concurrent program.

Because the package is classified OTHER and marked not-for-shipment, no supported public API is offered. Customizations should use the corresponding public OKC Expert APIs and never call OKC_XPRT_XRULE_VALUES_PVT_W directly, as its signatures and collection structures may change without public notice across 12.1.1 and 12.2.2 patch levels.