Search Results create_publication_request

Overview

OKC_XPRT_CZ_INT_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Contracts (OKC) integration with Oracle Configurator (CZ). Its prefix identifies it as a Contracts Xpert extension, while the CZ_INT component of the name denotes the Configurator integration layer. The package is classified as PVT, meaning it is an internal implementation package that is not intended to be called directly by external applications; instead, it is consumed by other packages within the same integration stack.

The package addresses the import, publication, and configuration management of contract template models that originate in the Configurator repository, and it exposes utilities for building the folder hierarchy in which these models are stored within contracts. Global constants defined in the package specification, such as G_RP_ROOT_FOLDER_ID, G_XPRT_MAIN_FOLDER_ID, G_TEMPLATE_FOLDER_ID, G_CLAUSE_FOLDER_ID, and G_VARIABLE_FOLDER_ID, establish the fixed navigational structure used to organize templates, clauses, and variables. Additional constants bind the package to the CZ_CONTRACTS_API_GRP date epoch and status values, and G_MASTER_UI_TMPLATE_ID identifies the seeded master UI template in CZ_UI_DEFS.

Key Procedures and Functions

The package exposes thirteen documented procedures. IMPORT_GENERIC imports Configurator model content into the Contracts repository, returning status, message count, and message data to the caller. CREATE_RP_FOLDER is the routine that establishes a runtime publication folder under the configured root folder and is the object most commonly referenced in troubleshooting searches. COPY_CONFIGURATION and DELETE_CONFIGURATION manage the duplication and removal of configuration records associated with a model.

Publication-oriented procedures include CREATE_PUBLICATION_REQUEST, DELETE_PUBLICATION, EDIT_PUBLICATION, PUBLISH_MODEL, PUBLICATION_FOR_PRODUCT, and GENERATE_LOGIC. Together these handle the lifecycle of publishing a Configurator model to contracts, including request creation, logic generation, subsequent edits, deletion, and product-specific publication. BATCH_VALIDATE performs bulk validation of models prior to publication. The user interface functions CREATE_JRAD_UI and DELETE_UI_DEF create and remove the JRAD user interface definitions attached to imported or published models.

Tables Accessed

The package reads and writes CZ_MODEL_PUBLICATIONS, which tracks the publication state and history of each Configurator model, and CZ_DB_LOGS, which records diagnostic and error information generated during import and publication activity. FND_LANGUAGES is queried to support the multilingual (NLS) handling of captions and rule descriptions. PLITBLM is the PL/SQL internal table used for manipulating CLOB and long text content during import and logic generation. UTL_HTTP is referenced to support HTTP-based retrieval of configuration content, typically from the Configurator server.

Usage Notes

Because OKC_XPRT_CZ_INT_PVT is a private package, it should be invoked through the public packages, concurrent programs, or Forms that wrap the Configurator-to-Contracts integration. The metadata indicates the package is referenced by eight other packages, confirming its role as a shared internal service layer rather than a standalone API. Typical invocation paths include the Configurator import and publication concurrent programs and the contract template setup flows. When diagnosing issues with folder creation, the CREATE_RP_FOLDER procedure and the folder ID constants listed above are the appropriate starting points. Direct calls from custom code are not recommended, as the private interface may change between releases; use the supported public API instead. The package behaves consistently across EBS 12.1.1 and 12.2.2, since the underlying database objects are unchanged.