Search Results dbms_defergen_wrap

Overview

SYS.DBMS_DEFERGEN_WRAP is an Oracle-supplied wrapper package that belongs to the internal Oracle Advanced Replication infrastructure, not to the E-Business Suite application schema itself. In an EBS 12.1.1 or 12.2.2 environment it is present because the database release bundles the Advanced Replication and deferred transaction components that EBS relies upon for multi-tier deployment, distributed database consistency, and materialized view refresh operations. The package serves as a thin encapsulation layer over DBMS_DEFERGEN, the Oracle package responsible for generating the appropriate PL/SQL call stubs that insert deferred remote procedure calls into the deferred transaction queue. By wrapping DBMS_DEFERGEN, the wrapper isolates callers from the internal mechanics of queue generation and provides a stable interface that other Oracle-supplied packages and internal replication routines can invoke.

The ETRM record confirms the object is owned by SYS, carries a status of VALID, and is classified as OTHER within the documented API taxonomy, meaning it is not a supported application programming interface for customer extension.

Key Procedures and Functions

The ETRM repository documents zero externally published procedures or functions for DBMS_DEFERGEN_WRAP. Its package specification exposes only the internal entry points required by its dependency chain. The package is not documented as offering a public callable API to EBS developers, and no supported parameter interfaces are published. All functional behaviour is inherited from the underlying DBMS_DEFERGEN package, which the wrapper references. Custom code should not attempt to invoke procedures through this package, because any internal routine may change or be removed without notice in a future database patchset or upgrade, particularly across the 12.1.1 to 12.2.2 boundary where database versions also advance.

Tables Accessed

No application tables are documented as being accessed by this package through APPS synonyms. The wrapper and its underlying DBMS_DEFERGEN package operate against Oracle's internal replication dictionary objects, which may include deferred transaction queue structures and replication catalog views maintained by SYS. These are database-level metadata structures rather than EBS business tables; consequently, no FND, INV, PO, or other application schema tables appear in the documented dependency list. Any access to replication catalog data occurs entirely within the SYS schema and is invisible to EBS application SQL.

Usage Notes

DBMS_DEFERGEN_WRAP is not invoked by EBS forms, concurrent programs, or standard application code. Its invocations originate from within the Oracle database kernel and from other SYS-owned packages. The documented dependency metadata shows a bidirectional relationship: DBMS_DEFERGEN_WRAP references DBMS_DEFERGEN and STANDARD, and is in turn referenced by DBMS_DEFERGEN and by itself. This reciprocal reference pattern is characteristic of internal wrapper implementations where the base package and its wrapper share tightly coupled entry points. Because the object is referenced by only one other package, its surface area of influence is narrow.

From an EBS administration standpoint, the package's practical relevance is diagnostic rather than functional. When validating a database after EBS patching, cloning, or the 12.1.1 to 12.2.2 upgrade, DBAs may inspect DBA_OBJECTS and DBA_DEPENDENCIES to confirm that DBMS_DEFERGEN_WRAP remains VALID. If it becomes INVALID, the standard remedy is recompilation using UTL_RECOMP or utlrp.sql, since invalid internal replication wrappers can interfere with deferred transaction processing and materialized view refresh. Customers should never modify, override, or wrap this package in a custom schema, and no EBS configuration or profile option controls its behaviour. Its presence is simply a required element of the underlying Oracle database replication stack.

PACKAGE: SYS.DBMS_DEFERGEN_WRAP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_WRAP, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_WRAP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_WRAP, 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 BODY: SYS.DBMS_DEFERGEN_WRAP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_WRAP, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_WRAP 12.1.1
PACKAGE: SYS.DBMS_DEFERGEN_WRAP 12.2.2
PACKAGE: SYS.DBMS_DEFER_QUERY 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_QUERY, status:VALID,
PACKAGE: SYS.DBMS_DEFER_QUERY 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER_QUERY, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_UTIL, status:VALID,
PACKAGE: SYS.DBMS_DEFERGEN_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFERGEN_UTIL, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
PACKAGE: SYS.DBMS_DEFER 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_DEFER, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN, status:VALID,
TABLE: SYS.ARGUMENT$ 12.2.2
owner:SYS, object_type:TABLE, object_name:ARGUMENT$, status:VALID,
TABLE: SYS.ARGUMENT$ 12.1.1
owner:SYS, object_type:TABLE, object_name:ARGUMENT$, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_WRAP 12.2.2
PACKAGE BODY: SYS.DBMS_DEFERGEN_WRAP 12.1.1
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_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE: SYS.DBMS_SQL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SQL, status:VALID,
PACKAGE: SYS.DBMS_SQL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SQL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.DBMS_SYS_ERROR 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
PACKAGE: SYS.DBMS_SYS_ERROR 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SYS_ERROR, status:VALID,
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_WRAP 12.2.2
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFERGEN_WRAP 12.1.1
SYS.DBMS_DEFERGEN dependencies on DBMS_DEFERGEN_WRAP 12.1.1
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFERGEN_WRAP 12.2.2
PACKAGE: SYS.DBMS_ASSERT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
PACKAGE: SYS.DBMS_ASSERT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASSERT, status:VALID,
TABLE: SYS.OBJ$ 12.2.2
owner:SYS, object_type:TABLE, object_name:OBJ$, status:VALID,
TABLE: SYS.OBJ$ 12.1.1
owner:SYS, object_type:TABLE, object_name:OBJ$, status:VALID,
TABLE: SYS.USER$ 12.1.1
owner:SYS, object_type:TABLE, object_name:USER$, status:VALID,
TABLE: SYS.USER$ 12.2.2
owner:SYS, object_type:TABLE, object_name:USER$, status:VALID,
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFERGEN 12.2.2
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFERGEN 12.1.1
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFERGEN 12.2.2
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFER 12.2.2
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFERGEN 12.1.1
SYS.DBMS_DEFERGEN_WRAP dependencies on DBMS_DEFER 12.1.1
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,