Search Results generate_logic

Overview

The APPS.CZ_CONTRACTS_API_GRP package body is a group (GRP) type API within the Oracle E-Business Suite Contracts (CZ) schema, part of the Oracle Contracts Core / Enterprise Contracts model infrastructure. It functions as a thin coordinating wrapper that exposes operations on contract models, contracts folders (RP entries), publications, and UI definitions to other EBS components. Rather than implementing business logic directly, the package largely delegates to lower-level public APIs such as CZ_MODELOPERATIONS_PUB and CZ_IMP_PS_NODE, providing a stable, grouped entry point for callers. The header comment dates the source to 2008, and the object remains documented in ETRM 12.2.2 under APPS ownership. Its responsibilities include folder existence checks, folder creation, generic import, model deletion and publication, publication request management, UI definition deletion, logic generation, and JRAD UI creation.

Key Procedures and Functions

• RP_FOLDER_EXISTS — Boolean function returning whether a given RP (reporting/publication) folder already exists; delegates to CZ_MODELOPERATIONS_PUB.RP_FOLDER_EXISTS.
• CREATE_RP_FOLDER — Creates a new RP folder entry, accepting folder name, description, and notes, and returning the new folder identifier along with standard return status, message count, and message data outputs.
• IMPORT_GENERIC — Performs a generic model import, setting the gContractsModel flag on CZ_IMP_PS_NODE so seeded models are recognised, and returning run ID and status.
• DELETE_MODEL — Removes a contract model definition from the repository.
• CREATE_PUBLICATION_REQUEST — Raises a request to publish a model, initiating the publication workflow.
• EDIT_PUBLICATION — Modifies an existing publication record.
• DELETE_PUBLICATION — Removes a publication.
• DELETE_UI_DEF — Deletes a user-interface definition record; this is the procedure most commonly referenced by searches for delete_ui_def, and it operates against CZ_UI_DEFS.
• GENERATE_LOGIC — Generates the underlying logic associated with a model or UI definition.
• PUBLISH_MODEL — Publishes a contract model, making it available for use.
• CREATE_JRAD_UI — Creates a JRAD (Java runtime application definition) UI artefact tied to a model.

The package also declares a private exception, G_INCOMPATIBLE_API, used to signal incompatible API version calls, and the constant G_PKG_NAME.

Tables Accessed

• CZ_RP_ENTRIES — Stores RP folder records; referenced by folder creation and existence checks.
• CZ_UI_DEFS — Holds UI definitions; targeted by DELETE_UI_DEF and UI creation routines.
• CZ_DEVL_PROJECTS — Development project metadata associated with models and generated logic.
• CZ_DB_LOGS — Logging of API activity and errors.
• FND_LANGUAGES — EBS language reference, used for language-sensitive operations.
• PLITBLM — Standard EBS PL/SQL message table used with the message stack (msg count/data outputs).

Usage Notes

The package is typically invoked from Contracts setup forms (particularly model and publication administration screens), from concurrent programs handling model import and publication, and from custom extensions that require a supported API surface rather than direct table manipulation. Its GRP classification indicates it is a grouping module intended for internal EBS orchestration; direct calls should be version-guarded using the p_api_version parameter and standard x_return_status, x_msg_count, and x_msg_data conventions. The package is referenced by five other packages, reinforcing its role as a shared service layer. Customisations should favour DELETE_UI_DEF and its sibling procedures over direct DML on CZ_UI_DEFS or CZ_RP_ENTRIES to preserve referential consistency.