Search Results okc_xprt_xrule_values_pvt




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKC_CODE_HOOK is an APPS-owned PL/SQL package within the Oracle Contracts (OKC) module of Oracle E-Business Suite. It is classified as an "OTHER" API — a package that supports internal processing rather than a formally published, interface-stable API — and it is documented as VALID in Oracle ETRM releases 12.1.1 and 12.2.2. Its role is to provide hook routines that the contract authoring and terms-processing framework calls at defined extension points, principally during the export of contract terms, the evaluation of export rules, and the copying or synchronization of clauses and rule outcomes between source and target contract documents.

The package occupies a middle layer in the OKC terms architecture. It depends on OKC_K_ARTICLES_B, OKC_QA_ERRORS_T, OKC_TERMS_MULTIREC_GRP, and OKC_XPRT_XRULE_VALUES_PVT, and is itself referenced by OKC_TERMS_COPY_PVT, OKC_TERMS_MULTIREC_GRP, and OKC_XPRT_XRULE_VALUES_PVT. This bidirectional relationship with OKC_XPRT_XRULE_VALUES_PVT is the reason OKC_CODE_HOOK surfaces when users search for that private package: the two modules collaborate to resolve export-rule values and validate their outcomes.

Key Procedures and Functions

  • GET_MULTIVAL_UDV_FOR_XPRT — Returns the multi-value user-defined variable content needed during the export of contract terms, so that variable-driven clauses resolve to the correct values.
  • GET_XPRT_CLAUSE_ORDER — Determines the sequence in which clauses are presented or emitted during export processing.
  • IS_NOT_PROVISIONAL_SECTION — Tests whether a contract section is non-provisional, allowing callers to exclude provisional (placeholder) sections from export or copy logic.
  • IS_NEW_KFF_ITEM_SEG_ENABLED — Determines whether the new key flexfield item segment is enabled for the contract terms configuration.
  • SYNC_RWA_WITH_DOCUMENT — Synchronizes rule-with-article (RWA) data against the contract document, keeping rule outcomes aligned with current document content.
  • RULES_QA_CHECK — Performs quality-assurance validation of rules, reporting failures through the QA errors structure.
  • SORT_CLAUSES — Orders clauses according to the sequence defined for the terms template or export output.

Tables Accessed

  • OKC_K_ARTICLES_B — The base table of contract articles and clauses; read to obtain clause definitions and ordering attributes.
  • OKC_ARTICLES_ALL — The multi-organization view of articles; used when articles must be resolved across operating units.
  • OKC_QA_ERRORS_T — The QA error structure populated by RULES_QA_CHECK to record validation failures.
  • OKC_XPRT_RULE_OUTCOMES — Stores the results of export-rule evaluation; touched by rule synchronization and multi-value variable resolution.

Usage Notes

OKC_CODE_HOOK is not an end-user facing API. It is invoked internally by the OKC contract authoring forms, by the terms-processing and copy programs (OKC_TERMS_COPY_PVT), and by concurrent programs that export contract terms. Sub-procedures are also called from OKC_TERMS_MULTIREC_GRP and OKC_XPRT_XRULE_VALUES_PVT. Customizations should not call the package directly unless standard callers are unavailable, and any extension should be validated on both 12.1.1 and 12.2.2, since internal signatures published in Oracle ETRM remain valid but may change in future patches.