Search Results csm_ha_audit_pkg




Overview
Explore in AI Chat

Overview

CSM_HA_AUDIT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API type. Its name and structure indicate that it belongs to the CSM (Customer Support / Service) module's high-availability ("HA") subsystem, which is associated with the historical TeleService and Service Request infrastructure used for session tracking and payload handling. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and therefore relies on the caller's schema-level grants and synonyms to resolve the database objects it references. In practice, CSM_HA_AUDIT_PKG provides a single entry point for recording audit information tied to an HA payload, allowing the application tier to persist an audit trail for a specific payload identifier alongside a caller-supplied audit type. The package was last versioned in the 12.1.1 code line (header 120.0.12010000.1, dated 2010/04/08), and it remains documented in ETRM 12.2.2 without functional change.

Key Procedures and Functions

The package exposes exactly one documented procedure:

  • AUDIT_RECORD — Records an audit entry for a given high-availability payload. By naming convention and the tables it touches, the procedure accepts an HA payload identifier and an audit type descriptor, then writes the corresponding audit record to the CSM HA audit tables. It is the sole public interface of the package; no functions or additional overloads are documented.

No parameter lists should be assumed beyond what the documented specification shows: the procedure is declared to take a payload identifier (NUMBER) and an audit type (VARCHAR2). Because the package body is not exposed in the metadata, the internal logic and any private helpers remain undocumented.

Tables Accessed

The package references the following objects, resolved through APPS synonyms:

  • CSM_HA_AUDIT — the primary audit header table; the target of audit record creation.
  • CSM_HA_AUDIT_S — the corresponding audit detail/segment table, typically holding line-level audit attributes linked to the audit header.
  • CSM_HA_PAYLOAD_DATA — stores the HA payload content (including XML payloads) against which audit activity is associated.
  • CSM_HA_SESSION_INFO — session-level context for HA processing, used to correlate the audit entry with the originating session.
  • XMLTYPE — the Oracle XML DB type, indicating the procedure parses or stores XML-typed payload or audit content.
  • PLITBLM — the PL/SQL integer-indexed table type (typically PLITBLM in the PLITBLM package), used for bulk/array operations within the procedure.
  • DUAL — used for scalar evaluations and constant lookups.

Usage Notes

CSM_HA_AUDIT_PKG is an internal utility rather than a public integration API. It is invoked by at least one other package in the APPS schema (ETRM records one referencing package), which suggests it is called during HA payload processing rather than directly from an Oracle Forms screen or standalone concurrent program. Typical invocation occurs from server-side PL/SQL — for example, from service request or session-management logic that must log an audit event (such as payload receipt, transformation, or transmission) against a specific p_ha_payload_id and p_audit_type. Customizations should not call AUDIT_RECORD without ensuring the caller has appropriate grants on the four CSM_HA tables and on XMLTYPE, since AUTHID CURRENT_USER removes definer-rights resolution. Because the package is undocumented beyond the specification shown here, developers integrating with it should treat its behavior as version-specific and verify expected audit table contents after upgrade from 12.1.1 to 12.2.2.