Search Results change_party_site




Overview
Explore in AI Chat

Overview

CSL_HZ_PARTY_SITES_ACC_PKG is an Oracle E-Business Suite supporting package owned by the APPS schema and classified under the ETRM metadata taxonomy as OTHER. It belongs to the CSL (Contact/Party Site) family of packages that maintain the territory and resource assignment architecture underpinning Oracle's customer and party-site data model. Specifically, this package body keeps the Access Control Component (ACC) tables synchronized with the HZ_PARTY_SITES base table whenever party site records are created, modified, or removed. It does so by delegating to JTM_HOOK_UTIL_PKG, the shared hook utility that all CSL ACC packages use to register publication items against resource identifiers.

Two globally scoped constants anchor the package's behavior: g_acc_table_name points to the ACC shadow table CSL_HZ_PARTY_SITES_ACC, and g_table_name identifies HZ_PARTY_SITES as the driving base entity, with PARTY_SITE_ID serving as the primary key (g_pk1_name) used to correlate rows between the two tables. The publication item list, built from a single-element collection of CSL_HZ_PARTY_SITES, tells the hook utility which publication tier must receive the access control rows.

Key Procedures and Functions

ETRM documents four procedures in this package body. Their names, and their inferred responsibilities within the ACC synchronization lifecycle, are:

  • INSERT_PARTY_SITE — Registers a new access control record for a party site by calling JTM_HOOK_UTIL_PKG.Insert_Acc with the package's publication item list, ACC table name, primary key name and value, and the supplied resource identifier. The documented body excerpt additionally shows that this procedure opens an explicit cursor against HZ_PARTY_SITES, fetches the row by party_site_id, and then invokes CSL_HZ_LOCATIONS_ACC_PKG.INSERT_LOCATION for the associated location_id so that the site's location also receives its matching ACC entry.
  • UPDATE_PARTY_SITE — Handles the maintenance path when an existing party site is changed; it re-aligns the corresponding ACC rows with the current state of HZ_PARTY_SITES.
  • DELETE_PARTY_SITE — Removes the access control rows associated with a party site that no longer exists, preventing orphaned ACC entries.
  • CHANGE_PARTY_SITE — Provides the transition path used when a party site's assignment context changes; this is the entry point most commonly reached by callers searching for a change_party_site routine in the CSL_HZ_PARTY_SITES_ACC_PKG surface.

No parameter lists are asserted here, as the documented metadata does not enumerate them.

Tables Accessed

The documented table references are:

  • HZ_PARTY_SITES — The principal base table. It is read via an explicit cursor in INSERT_PARTY_SITE (and by extension in the other procedures) to obtain LOCATION_ID and any other attributes needed to keep the ACC shadow table consistent. PARTY_SITE_ID is the primary key used for correlation.
  • CSL_HZ_PARTY_SITES_ACC — The Access Control Component shadow table, designated by g_acc_table_name, into which the hook utility writes and from which ACC-aware queries read.
  • DBMS_SQL — Referenced by the package, indicating that at least one operation builds or executes dynamic SQL rather than relying exclusively on static statements.
  • PLITBLM — The PL/SQL table-to-index-by utility package, used in the broader ACC framework for collection handling within JTM_HOOK_UTIL_PKG and related calls.

Usage Notes

CSL_HZ_PARTY_SITES_ACC_PKG is not an end-user-facing API. It is invoked indirectly by Oracle's party-site maintenance flows — the forms and concurrent processes that create, update, and delete HZ_PARTY_SITES rows — so that the ACC layer stays synchronized without explicit user intervention. ETRM records that the package is referenced by four other packages, confirming its role as a shared dependency in the CSL ACC stack rather than a standalone utility. Customers extending Oracle EBS through form personalization, custom concurrent programs, or bespoke PL/SQL integrations should not call this package directly; the supported extension point is the base HZ_PARTY_SITES DML path, which triggers the appropriate ACC procedure. Debug output is emitted through JTM_MESSAGE_LOG_PKG at the levels g_debug_level and G_DEBUG_LEVEL_FULL/MEDIUM, allowing administrators to trace ACC synchronization behavior when diagnosing territory or resource assignment discrepancies.