Search Results okc_xprt_import_template_pvt




Overview
Explore in AI Chat

Overview

OKC_XPRT_IMPORT_TEMPLATE_PVT is a private PL/SQL package in the APPS schema that supports Oracle E-Business Suite's Contract Terms and Export Compliance functionality. Its primary business purpose is to import and rebuild contract terms templates and the associated rules, questions, and localized text that drive Oracle Contracts (OKC) and the Oracle Global Trade Management / Export Compliance rule structures. In ETRM terms, this package is a worker package invoked by the public-facing wrapper OKC_XPRT_IMPORT_PVT, which coordinates the loading and regeneration of template metadata from staged flat-file or intermediate import tables into the transactional template tables used by the Terms Template setup and Export Compliance rule authoring screens.

The package is classified as type PVT, indicating it contains private implementation logic that is not part of the supported public API surface. It is intended for internal consumption by sibling packages and standard import processes rather than for direct customer invocation. Its status is VALID on both Oracle EBS 12.1.1 and 12.2.2, and it references only the SYS.STANDARD package plus APPS synonyms, consistent with a standard EBS 12.x deployment where public synonyms resolve to the APPS schema objects.

Key Procedures and Functions

  • IMPORT_TEMPLATE — The core procedure that performs the template import. It reads staged export-compliance template definitions and their dependent questions, rules, and localized text, then writes or merges them into the target OKC template and rule headers. This is the primary entry point used when a template bundle is loaded into an instance.
  • REBUILD_TMPL_PUB_DISABLE — A maintenance procedure that rebuilds template publication data and disables published templates where appropriate, typically preceding a re-import so that stale or superseded template definitions are not exposed to end users. It is invoked as part of the rebuild cycle that keeps imported definitions consistent with the published setup.
  • REBUILD_TMPL_SYNC — Synchronizes template and export-compliance metadata after an import, ensuring the relationship between template headers, questions, rule headers, and localized text remains internally consistent. It is the counterpart to REBUILD_TMPL_PUB_DISABLE, restoring and reconciling published state once the import has completed.

Tables Accessed

The package reads and writes OKC_TERMS_TEMPLATES_ALL, the central repository of contract terms templates, along with OKC_XPRT_RULE_HDRS_ALL, OKC_XPRT_QUESTIONS_B, OKC_XPRT_QUESTIONS_TL, and OKC_XPRT_QUESTION_ORDERS, which hold the export-compliance rule headers, question definitions, translations, and question sequencing generated during import. Localized message text is sourced from CZ_IMP_LOCALIZED_TEXTS, and staged or intermediate export-compliance data is read from CZ_IMP_DEVL_PROJECT, CZ_IMP_PS_NODES, CZ_DEVL_PROJECTS, CZ_RP_ENTRIES, CZ_RULES, and CZ_XFR_RUN_INFOS_S. Finally, the package queries FND_LANGUAGES, FND_FLEX_VALUE_SETS, and FND_FLEX_VALIDATION_TABLES to resolve language and value-set validation metadata required when constructing and validating imported template content.

Usage Notes

Because OKC_XPRT_IMPORT_TEMPLATE_PVT is a private package, it is not intended for direct invocation from custom code or concurrent program definitions. It is called by OKC_XPRT_IMPORT_PVT, the public wrapper, which is the supported entry point for template import operations in Oracle EBS 12.1.1 and 12.2.2. Typical invocation occurs during export-compliance setup and template migration, where import data is staged and then processed through the public importer, which in turn drives this package's procedures to rebuild and synchronize published templates. Customers extending or troubleshooting template imports should reference OKC_XPRT_IMPORT_PVT and the standard Terms Template setup forms rather than calling this package directly, since its procedures are subject to change without notice across release upgrades.