Search Results get_access_list




Overview
Explore in AI Chat

Overview

The APPS.CSM_DBOARD_SRCH_COLS_EVENT_PKG package body is part of the Oracle E-Business Suite Service (CSM) module, specifically supporting the dashboard search-columns configuration framework. Its principal business function is to maintain the mapping between dashboard search columns and the access identifiers that determine which users or responsibilities may view them. The package synchronizes the access-control intersection table CSM_DASHBOARD_SEARCH_COLS_ACC with the parent definition table CSM_DASHBOARD_SEARCH_COLS, ensuring that access records remain consistent as search-column definitions are inserted, updated, or removed. The header comment ($Header: csmedscb.pls 120.2 2008/02/07) confirms this object has been shipped and maintained since at least the 11i/12.0 era and remains present in 12.1.1 and 12.2.2.

Key Procedures and Functions

Although the ETRM metadata lists only REFRESH_ACC as a documented procedure, the package source declares two procedures.

  • GET_ACCESS_LIST — Accepts an access identifier and a count and populates the package global collection g_access_list (typed as asg_download.access_list). The collection is first cleared via DELETE, then loaded with p_count entries, each set to the supplied access identifier. This procedure prepares the in-memory access list consumed by downstream download or security logic.
  • REFRESH_ACC — The primary maintenance routine. It returns a status and message pair to the caller. It reconciles CSM_DASHBOARD_SEARCH_COLS_ACC against CSM_DASHBOARD_SEARCH_COLS using three driving cursors: a delete cursor for access rows whose column name no longer exists, an update cursor for rows whose parent column was modified after the last concurrent program run date, and an insert cursor for new parent columns with no corresponding access row. The last run date is read from JTM_CON_REQUEST_DATA by matching the package name and API name constants.

Tables Accessed

  • CSM_DASHBOARD_SEARCH_COLS — The parent definition table of dashboard search columns; read to identify new or modified columns.
  • CSM_DASHBOARD_SEARCH_COLS_ACC — The access intersection table; deleted from, updated, and inserted into during REFRESH_ACC, and the source of ACCESS_ID values passed to GET_ACCESS_LIST.
  • JTM_CON_REQUEST_DATA — Stores the last run date of the concurrent request, used to bound incremental updates.
  • CSM_DASHBOARD_SRCH_COLS_ACC_S — The sequence supplying new ACCESS_ID values.
  • ASG_USER, DUAL, and PLITBLM — Referenced indirectly through the access-list type, dummy selection, and PL/SQL table support respectively.

Usage Notes

REFRESH_ACC is invoked as a concurrent program-managed API, consistent with its reading of JTM_CON_REQUEST_DATA keyed by package and procedure name. The ETRM metadata records one dependent package referencing this object, indicating it is called programmatically rather than from a form directly. In 12.1.1 and 12.2.2 it is typically scheduled to run after dashboard search-column configuration changes so that the access table reflects current definitions. Custom code should not call REFRESH_ACC concurrently with the standard submission, and any direct manipulation of CSM_DASHBOARD_SEARCH_COLS_ACC should be avoided in favour of this API to preserve referential consistency.