Search Results okc_xprt_import_variables_pvt




Overview
Explore in AI Chat

Overview

The OKC_XPRT_IMPORT_VARIABLES_PVT package is a private PL/SQL API within the Oracle E-Business Suite Contracts (OKC) module, specifically belonging to the Contract Expert / Expert Rules infrastructure. Its principal business function is to rebuild the Variable Model for a given operating unit (organization) by importing variable definitions from an external source — typically a development project definition exported and transferred between environments. Contract Expert rules are authored against a set of business variables (such as contract amount, customer, or clause-related attributes), and those variables must be loaded into the target instance before rules, questions, and rule conditions can be evaluated. This package encapsulates that load process behind a single, well-defined entry point, insulating callers from the underlying staging and language tables. It is declared with AUTHID CURRENT_USER and is classified as a private (PVT) API, meaning it is not intended as a supported public interface and may change without notice. The header identifies it as an internal utility (script OKCVXVARS.pls) used to regenerate the variable model per organization.

Key Procedures and Functions

The package exposes a single documented procedure, IMPORT_VARIABLES. Its stated purpose is to rebuild the Variable Model for the supplied organization. It follows the standard Oracle EBS PL/SQL API conventions: an API version parameter for compatibility control, an initialization parameter for message-list handling, a commit flag that allows the caller to defer or force a transaction boundary, an input organization identifier that scopes the import to Org Rules, and the standard three output parameters — return status, message data, and message count — used for error and diagnostic reporting. No other procedures or functions are documented for this package.

Tables Accessed

The documented table references span three functional areas. The Contract Expert repository is represented by OKC_BUS_VARIABLES_B and OKC_BUS_VARIABLES_TL (the base and translated variable definitions that constitute the rebuilt variable model), OKC_XPRT_QUESTIONS_B and OKC_XPRT_QUESTIONS_TL (the questions associated with those variables), and OKC_XPRT_RULE_HDRS_ALL along with OKC_XPRT_RULE_CONDITIONS and OKC_XPRT_RULE_COND_VALS, which hold rule headers, conditions, and condition values that depend on the variable model. The import and staging infrastructure is represented by CZ_DEVL_PROJECTS, CZ_IMP_DEVL_PROJECT, CZ_IMP_PS_NODES, CZ_IMP_LOCALIZED_TEXTS, and CZ_XFR_RUN_INFOS_S, which carry project definitions, node hierarchies, localized text, and transfer run information from the source environment. Reference data is drawn from FND_LANGUAGES (for multilingual text handling), DUAL, and PLITBLM (the PL/SQL index-by table utility used for bulk message handling). Read and write activity concentrates on the OKC variable, question, and rule tables, with the CZ tables providing the source content.

Usage Notes

Because the package is classified as private, it is normally invoked by other internal Contract Expert packages rather than directly from forms or concurrent programs; ETRM records it as referenced by one other package, which orchestrates the overall import process. In practice, IMPORT_VARIABLES executes during the migration or setup of Contract Expert rules between instances — for example, after an export from a development environment has been staged in the CZ interface tables, when the target organization's variable model must be synchronized. A typical call supplies an organization ID scoped to Org Rules and requests an immediate commit, then inspects the return status and message list to confirm success. Customizations should not call this API directly; the supported, public entry points of the Contract Expert import flow should be used instead, since the private interface and its underlying staging tables may be altered by patching.