Search Results cz_schema

Overview

CZ_PUB_MGR is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Configurator (CZ) product family and forms part of the infrastructure that manages publication and schema-related maintenance operations within the Configurator data model. The package is declared with AUTHID CURRENT_USER, meaning its unqualified references resolve against the invoker's schema rather than the definer's, a convention common to Configurator utility packages that must operate against whichever schema is active at runtime.

A distinguishing feature of the package is its package-level variable, CZ_SCHEMA VARCHAR2(30). This global variable is exposed as part of the public interface and is referenced by callers searching on the term "cz_schema" — it allows dependent code to determine or bind the Configurator schema name dynamically rather than hard-coding it. The header comment ($Header: czpmmgrs.pls 115.8 2002/11/27 …) indicates the package body has been stable since the early 11i era and was carried forward into 12.1.1 and 12.2.2 with minimal interface change.

Key Procedures and Functions

The package exposes eight documented procedures, all with no return value:

• ASSESS_DATA — Evaluates the state of published Configurator data, typically to determine what maintenance actions are required.
• TRIGGERS_ENABLED — Accepts a switch value to enable or disable database triggers, used during bulk maintenance operations where trigger firing would be undesirable.
• CONSTRAINTS_ENABLED — Similarly toggles constraint enforcement on or off for the duration of a maintenance run.
• REDO_SEQUENCES — Resynchronizes sequence values, accepting a restart flag and an optional increment. This is used after data refreshes or cloning when sequences may be out of step with existing rows.
• PURGE — Removes obsolete or orphaned publication-related records.
• MODIFIED — Returns (via an OUT NOCOPY parameter) the as-of date reflecting the last modification point, enabling incremental processing.
• RESET_CLEAR — Clears internal state, typically invoked at the start or end of a maintenance cycle.
• REDO_STATISTICS — Recomputes or refreshes statistics used by the Configurator runtime.

Tables Accessed

Through APPS synonyms, the package interacts with a set of Configurator publication and project tables. CZ_DB_LOGS records maintenance activity; CZ_DEVL_PROJECTS and CZ_MODEL_PUBLICATIONS/CZ_PB_MODEL_EXPORTS track development projects and published models; CZ_MODEL_REF_EXPLS holds reference explanations; CZ_PB_CLIENT_APPS and CZ_PB_LANGUAGES describe client applications and language contexts; CZ_PUBLICATION_USAGES records where publications are consumed; and CZ_RP_ENTRIES stores runtime parameter entries. PLITBLM is a standard Oracle server-side temporary/scratch table used for intermediate processing. Collectively these accesses support the assess, purge, and resynchronization logic.

Usage Notes

CZ_PUB_MGR is an internal utility package rather than an end-user API. It is typically invoked from Configurator concurrent programs, from other CZ packages (the metadata records one dependent package), and from administrative scripts during patching, cloning, or data refresh. Because it manipulates trigger and constraint state and rewrites sequence values, it should be executed only under controlled conditions — ideally during scheduled downtime — and never from ad-hoc session code without a clear understanding of the current publication state.