Search Results cz_contracts_api_grp




Overview
Explore in AI Chat

Overview

The APPS.CZ_CONTRACTS_API_GRP package is a public API group (GRP) belonging to the Oracle E-Business Suite Contracts module, specifically the ETRM (Enterprise Trading and Risk Management) product line. Its role is to expose a controlled, packaged interface for contract-related development and publication operations that would otherwise be performed directly against base tables. In EBS 12.1.1 and 12.2.2, this package sits in the APPS schema alongside other CZ_ objects and is classified as an API entry point.

The package is validated and registered against the ETRM 12.2.2 code line. Its business purpose centers on managing "RP" (report/publication) folders, importing and publishing models, generating logic, and creating UI definitions used when extending or customizing contract artifacts.

Key Procedures and Functions

Twelve documented entry points are exposed through this API group:

  • RP_FOLDER_EXISTS — Checks whether an RP folder of a given name already exists.
  • CREATE_RP_FOLDER — Creates a new RP folder to hold report/publication artifacts.
  • IMPORT_GENERIC — Generic import routine for loading contract models, clauses, rules, or variables from an external source.
  • DELETE_MODEL — Removes a model definition from the system.
  • CREATE_PUBLICATION_REQUEST — Creates a publication request used to stage a model for release.
  • EDIT_PUBLICATION — Modifies an existing publication record.
  • DELETE_PUBLICATION — Deletes a publication entry.
  • DELETE_UI_DEF — Deletes a UI definition record.
  • GENERATE_LOGIC — Generates PL/SQL or related logic used by a model.
  • PUBLISH_MODEL — Publishes a model so it becomes active/available downstream.
  • CREATE_JRAD_UI — Creates an Oracle JRAD (JDeveloper/ADF) user interface definition.
  • RP_FOLDER_EXISTS — Supports existence validation used by the folder creation flow.

The procedures are intentionally coarse-grained, shielding callers from direct DML against configuration tables. Parameter lists are not published in the metadata and should not be inferred.

Tables Accessed

  • CZ_RP_ENTRIES — Stores RP folder entries; central to the folder and publication routines.
  • CZ_DB_LOGS — Logs actions and errors generated during import, generate, and publish operations.
  • CZ_DEVL_PROJECTS — Holds development project metadata associated with models being generated or published.
  • CZ_UI_DEFS — Stores UI definitions; touched by CREATE_JRAD_UI and DELETE_UI_DEF.
  • FND_LANGUAGES — Provides language context for import/publication processing.
  • PLITBLM — The PL/SQL internal table utility, referenced for array/collection handling inside the package.

Usage Notes

CZ_CONTRACTS_API_GRP is referenced by four other packages — OKC_XPRT_CZ_INT_PVT (twice), OKC_XPRT_IMPORT_CLAUSES_PVT, OKC_XPRT_IMPORT_RULES_PVT, OKC_XPRT_IMPORT_TEMPLATE_PVT, and OKC_XPRT_IMPORT_VARIABLES_PVT — confirming that it is invoked from the ETRM import and XPRT export layer rather than directly from an EBS form in most flows. Custom code should call these procedures rather than modifying CZ_RP_ENTRIES or CZ_UI_DEFS directly, because the API maintains logging into CZ_DB_LOGS and enforces folder/UI integrity. Typical scenarios include provisioning a new contract model, publishing a model to production, and generating logic as part of a customization rollout.