Search Results dbms_logrep_lib

Overview

The SYS.DBMS_LOGREP_DEF_PROC_UTL package body is an Oracle-supplied dictionary utility that forms part of the internal infrastructure supporting Oracle Streams logical change record (LCR) capture and the LogMiner-based replication mechanisms that underpin distributed and advanced replication features in the Oracle database. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is one of several DBMS_LOGREP_% components shipped in the SYS schema. It does not implement EBS business logic directly; rather, it provides helper routines used by the broader LogMiner logical replication framework (for example, DBMS_LOGREP_LIB) to evaluate, prepare, and manage definition-time processing of captured records.

The DEF_PROC element of the name refers to "definition processing," the phase in which captured change vectors must be resolved against object metadata before they can be applied. This utility package encapsulates that supporting logic so the primary LogMiner packages can remain focused on capture and apply orchestration. The object is documented as VALID and owned by SYS, confirming it is an internal kernel-owned package whose execution privileges are granted indirectly through dependent PL/SQL units rather than exposed to application schemas such as APPS.

Key Procedures and Functions

The ETRM metadata records a documented procedure/function count of zero for this object within the EBS reference repository, and the excerpt supplies no public routine signatures. Because the package body extends the internal DBMS_LOGREP_DEF_PROC_UTL specification, its callable units are Oracle-internal and are not published for customer use. No parameter lists are documented in the supplied metadata and none should be assumed; any procedures or functions defined within the body exist solely to service DBMS_LOGREP_LIB and the surrounding LogMiner definition-processing pipeline. Customers and EBS integrators are not expected to invoke these routines directly.

Tables Accessed

The provided dependency information does not enumerate any tables referenced through APPS synonyms. No fixed EBS application tables are documented as being read or written by this package. As an internal SYS utility, any data access it performs would be against Oracle dictionary and LogMiner-specific repository objects rather than EBS transactional or setup tables. Because the ETRM documentation lists no table dependencies, no application-level table access should be attributed to this object.

Usage Notes

This package is not referenced by any database object according to the documented dependency information, and it references only SYS.DBMS_LOGREP_LIB and STANDARD. It is therefore an internal leaf-level utility invoked indirectly through DBMS_LOGREP_LIB rather than through EBS forms, concurrent programs, or standard application APIs. It is typically exercised during database-level replication, Streams capture, or LogMiner configuration activities rather than during ordinary EBS transaction processing. Custom code should never call DBMS_LOGREP_DEF_PROC_UTL directly; doing so bypasses supported interfaces and may fail or corrupt replication state across patching and upgrade operations.

Note the close relationship to DBMS_LOGREP_LIB, which is the package commonly surfaced when searching for "dbms_logrep_lib." Both belong to the same Oracle LogMiner replication family deployed in the SYS schema on EBS 12.1.1 and 12.2.2 environments, and both are Oracle proprietary and unsupported for direct customer invocation.

TYPE BODY: SYS.LCR$_ROW_RECORD 12.1.1
owner:SYS, object_type:TYPE BODY, object_name:LCR$_ROW_RECORD, status:VALID,
TYPE BODY: SYS.LCR$_DDL_RECORD 12.1.1
owner:SYS, object_type:TYPE BODY, object_name:LCR$_DDL_RECORD, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_DEF_PROC_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_DEF_PROC_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_PROCESS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_PROCESS, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_DEF_PROC_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_DEF_PROC_UTL, status:VALID,
TYPE BODY: SYS.LCR$_ROW_RECORD 12.2.2
owner:SYS, object_type:TYPE BODY, object_name:LCR$_ROW_RECORD, 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_LOGREP_UTIL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_PROCESS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_PROCESS, status:VALID,
TYPE BODY: SYS.LCR$_DDL_RECORD 12.2.2
owner:SYS, object_type:TYPE BODY, object_name:LCR$_DDL_RECORD, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL_INVOK, 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_XSTREAM_GG_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_IMP_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_IMP_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_IMP_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_IMP_INTERNAL, status:VALID,
LIBRARY: SYS.DBMS_LOGREP_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_LOGREP_LIB, status:VALID,
LIBRARY: SYS.DBMS_LOGREP_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_LOGREP_LIB, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_LCR_INT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_LCR_INT, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ERROR 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ERROR, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ERROR 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ERROR, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_LCR_INT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_LCR_INT, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_AUTH_IVK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_AUTH_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_AUTH_IVK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_AUTH_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_IMP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_IMP, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_IMP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_IMP, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_ADM_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_ADM_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_ADM_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_ADM_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_UTL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_UTL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_ADM_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_ADM_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_UTL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_UTL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_IVK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM_IVK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM_IVK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM_INTERNAL, status:VALID,
SYS.DBMS_APPLY_ERROR dependencies on DBMS_LOGREP_LIB 12.1.1
SYS.DBMS_LOGREP_UTIL dependencies on DBMS_LOGREP_LIB 12.2.2
SYS.DBMS_APPLY_ADM dependencies on DBMS_LOGREP_LIB 12.2.2
SYS.DBMS_CAPTURE_ADM_INTERNAL dependencies on DBMS_LOGREP_LIB 12.2.2
SYS.DBMS_XSTREAM_AUTH_IVK dependencies on DBMS_LOGREP_LIB 12.1.1
SYS.DBMS_LOGREP_UTIL_INVOK dependencies on DBMS_LOGREP_LIB 12.1.1