Search Results dbms_repcat_decl

Overview

SYS.DBMS_REPCAT_DECL is a proprietary Oracle-supplied PL/SQL package body that forms part of the Oracle Advanced Replication infrastructure shipped with the database. Its name — REPCAT DECL — designates it as the declaration-side component of the replication catalog management layer. In Oracle E-Business Suite 12.1.1 and 12.2.2, this package operates silently beneath the application tier. It does not implement business logic for any EBS module; rather, it supports the database-level replication facilities upon which certain multi-tier and distributed EBS deployments were historically constructed, including the classic Multi-Org and Distributed Deployment models that relied on symmetric replication.

The ETRM metadata classifies the object under SYS with an API classification of OTHER and records a VALID status, confirming it is installed and compiled as part of the standard database dictionary. It is documented as being referenced by 73 other packages, which indicates that it serves as a foundational declaration unit consumed by higher-level Replication Manager and replication catalog routines. Documented procedures and functions total zero, which is consistent with a declaration-only body that exposes specifications rather than executable business operations.

Key Procedures and Functions

The ETRM documentation records no documented procedures or functions for this package body. This is characteristic of a declaration package whose public interface is defined in its companion specification rather than its body, and whose substantial content consists of internal forwarding declarations, type definitions, and referenced object identifiers.

Declarative containers — the body carries the internal declarations required to compile and expose the replication catalog API surface consumed by dependent packages.
No public callable units — because the metadata enumerates zero procedures and functions, no entry points are documented for direct invocation by application code.
Companion relationship — the body is referenced internally by SYS.DBMS_REPCAT_DECL itself, reflecting a self-referential dependency typical of specification/body pairs.

Tables Accessed

The documented dependency list identifies the dictionary tables read by this package body. These are core data dictionary objects rather than application tables, and none are accessed through APPS synonyms.

SYS.COL$ — the dictionary table describing columns of every object in the database; consulted to resolve replication catalog column definitions.
SYS.OBJ$ — the dictionary table of all database objects; used to resolve object numbers and names during catalog processing.
SYS.USER$ — the dictionary table of database users and schemas; referenced to resolve schema ownership and replication group membership.

No application-facing tables are documented as being read or written. Because the body declares no procedures, its dictionary access is limited to the compilation-time and resolution-time references above.

Usage Notes

SYS.DBMS_REPCAT_DECL is not invoked from EBS forms, concurrent programs, or customer-written PL/SQL. It is an internal database component. The metadata confirms it is referenced by 73 other packages while referencing none of the application schemas, placing it firmly inside the database kernel layer.

Never call directly — because no procedures or functions are documented, direct invocation from custom code is neither supported nor possible.
Compilation dependency — custom objects that depend on replication catalog packages may fail to compile if this body is invalidated; its VALID status should be verified after database upgrades.
Upgrade impact — during 12.1.1 to 12.2.2 upgrades and database patching, this package is recompiled as part of the standard dictionary refresh; operators should treat any INVALID status as a patching issue requiring recompilation of the Replication Manager stack.

PACKAGE BODY: SYS.DBMS_REPCAT_DECL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_DECL, status:VALID,
SYNONYM: PUBLIC.DBMS_REPCAT_DECL 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_REPCAT_DECL, status:VALID,
SYNONYM: PUBLIC.DBMS_REPCAT_DECL 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_DECL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_DECL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_DECL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MIG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MIG_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MIG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MIG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RPC_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RPC_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_PROPAGATION_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_PROPAGATION_ADM, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SNA 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SNA, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_DECL 12.2.2
PACKAGE: SYS.DBMS_REPCAT_SNA_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SNA_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_INTERNAL_PACKAGE 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_INTERNAL_PACKAGE, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_INTERNAL_PACKAGE 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_INTERNAL_PACKAGE, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_DECL 12.1.1
PACKAGE BODY: SYS.DBMS_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_AUTH 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_AUTH, status:VALID,
PACKAGE BODY: SYS.DBMS_INTERNAL_REPCAT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_INTERNAL_REPCAT, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM_IVK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MIG 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MIG, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_COMMON_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_COMMON_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MIGRATION 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MIGRATION, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_DEF_PROC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_DEF_PROC, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UNTRUSTED 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UNTRUSTED, status:VALID,
PACKAGE BODY: SYS.DBMS_PROPAGATION_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_PROPAGATION_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_RPC_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_RPC_UTL, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SNA 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SNA, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_DEF_PROC 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_DEF_PROC, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_SNA_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_SNA_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_SNA 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_SNA, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_FLA_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_FLA_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_OFFLINE_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_OFFLINE_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_MIG 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_MIG, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_EXP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_EXP, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_EXP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_EXP, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_FLA 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_FLA, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CACHE 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CACHE, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_WRAP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_WRAP, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_CACHE 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_CACHE, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_WRAP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_WRAP, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_COMMON_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_COMMON_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_UNTRUSTED 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_UNTRUSTED, status:VALID,
PACKAGE: SYS.DBMS_REPCAT_MAS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REPCAT_MAS, status:VALID,
PACKAGE BODY: SYS.DBMS_REPUTIL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPUTIL, status:VALID,
PACKAGE BODY: SYS.DBMS_REPCAT_VALIDATE 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_REPCAT_VALIDATE, status:VALID,