Search Results csm_notes_type_map_event_pkg




Overview
Explore in AI Chat

Overview

APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG is an Oracle E-Business Suite PL/SQL package that belongs to the Customer Service (CSM) module family, as indicated by its naming prefix and the objects it references. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner, a convention common to Oracle Applications seed data and event-handling utilities.

The single documented procedure, REFRESH_ACC, addresses the intersection of note-type mappings and access control. The "ACC" suffix and the associated tables (CSM_NOTES_TYPE_MAPPING_ACC and its sequence CSM_NOTES_TYPE_MAPPING_ACC_S) indicate that this package maintains a runtime or denormalized copy of note-type-to-object mapping data, refreshed on demand. This supports Oracle's Notes and interaction infrastructure, where notes attached to service requests and other objects must be classified and routed according to configured mapping rules. The package therefore acts as a synchronization utility: it takes source mapping configuration and processes it into the access-oriented mapping table consumed by the Notes feature.

Key Procedures and Functions

The package exposes exactly one documented program unit:

  • REFRESH_ACC — Refreshes the access-control note-type mapping data. It returns status and message information through its two OUT NOCOPY VARCHAR2 parameters, consistent with the standard Oracle EBS API error-handling convention where a caller inspects a status flag and an accompanying message to determine success or failure. The procedure does not raise application errors directly; instead it reports outcome to the caller. Its implementation is not exposed in the header, so no further parameter detail is documented.

No functions are declared, and no other public procedures exist in the package specification.

Tables Accessed

The package operates against the following documented tables (referenced through APPS synonyms):

  • CSM_NOTES_TYPE_MAPPING_ACC and CSM_NOTES_TYPE_MAPPING_ACC_S — the primary target table and its sequence. REFRESH_ACC rebuilds or repopulates this table, using the sequence to generate surrogate keys for newly inserted mapping rows.
  • JTF_OBJECT_MAPPINGS — the CRM Foundation table that defines relationships between business objects and note types. It supplies the source mapping definitions that REFRESH_ACC propagates into the access table.
  • ASG_USER and ASG_USER_PUB_RESPS — resource and responsibility-assignment tables. These are consulted to resolve which users and responsibilities hold visibility to specific note types, supporting the access-control dimension of the mapping.
  • JTM_CON_REQUEST_DATA — a TeleSales/CRM foundation table referenced during processing, likely to resolve territory or resource context associated with the requesting user.
  • PLITBLM — the Oracle Applications PL/SQL table-of-varchar2 type used for in-memory collections during bulk processing within the refresh routine.

Usage Notes

Because the package is not referenced by any other documented package, it is invoked directly rather than through a JTF/CSM framework call chain. Typical invocation patterns include:

  • Administration forms or setup screens where an administrator triggers a rebuild of note-type mappings after configuration changes.
  • Concurrent programs scheduled to keep the access mapping table synchronized with JTF_OBJECT_MAPPINGS and assigned resources.
  • Custom or extension code that calls REFRESH_ACC and inspects the returned status and message parameters.

The header revision marker (120.0, dated 2006) indicates the package has remained stable across releases and is carried forward into EBS 12.1.1 and 12.2.2 without functional change. Callers should treat REFRESH_ACC as a batch reconciliation routine, invoking it after mapping configuration is modified rather than on high-frequency transactional paths, and should always evaluate the returned status before assuming the refresh succeeded.