Search Results update_party_wfsub

Overview

CSL_HZ_PARTIES_ACC_PKG is an APPS-owned PL/SQL package classified under the OTHER API category within Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the CSL (Customer/Service Logistics and field service) family of packages and provides the party-level access layer used by the CSL incident and resource tracking components. The package encapsulates the create, modify, and delete operations performed against party records held in HZ_PARTIES, together with the surrounding event and replication logic that keeps dependent CSL data synchronized. In effect, it acts as a controlled wrapper around the Trading Community Architecture (TCA) party model, exposing a narrow procedure surface so that calling modules do not issue direct DML against the TCA tables.

Key Procedures and Functions

The package declares twelve documented program units. INSERT_PARTY creates a party association for a given party and resource, accepting a flow type that defaults to the normal CSL incident flow constant. UPDATE_PARTY refreshes an existing party association for the supplied party identifier, and is the entry point most frequently located by users searching for "update_party". DELETE_PARTY removes a party association for a party/resource combination, again with the default flow type. CHANGE_PARTY re-points an existing association from an old party identifier to a new one while retaining the resource context.

The pre- and post-event hooks — PRE_INSERT_PARTY, POST_INSERT_PARTY, PRE_UPDATE_PARTY, POST_UPDATE_PARTY, PRE_DELETE_PARTY, and POST_DELETE_PARTY — are called immediately before and after the corresponding DML against the party record. Each returns a return status through an OUT NOCOPY VARCHAR2 parameter, allowing the caller to detect and react to failures raised by validation or event processing. Replicate_Record is a BOOLEAN function that determines whether a party record requires replication for the supplied party identifier. UPDATE_PARTY_WFSUB is a Workflow subscription callback that receives a subscription GUID and a Workflow event structure and returns a status string, enabling the package to respond to party-related business events raised through the Workflow Business Event System.

Tables Accessed

The package operates against HZ_PARTIES, the central TCA table holding party definitions, which it reads and updates when parties are inserted, changed, or removed. WF_EVENT_T is the Workflow event message structure used by UPDATE_PARTY_WFSUB to carry event payload data into the subscription handler. DBMS_SQL supplies dynamic SQL capabilities used for the package's replication and query logic, and PLITBLM is the PL/SQL table/index-by-table support package referenced by the compiled unit. Access is performed through APPS synonyms, consistent with the AUTHID CURRENT_USER declaration, so privileges resolve against the calling schema.

Usage Notes

CSL_HZ_PARTIES_ACC_PKG is invoked primarily from CSL field service forms and supporting CSL packages, and it is referenced by two other packages in the ETRM inventory. The pre- and post-hooks are intended to be called by the CSL framework rather than directly by end users. Customizations should call UPDATE_PARTY or CHANGE_PARTY rather than issuing DML against HZ_PARTIES, so that the associated event hooks and replication logic remain intact. UPDATE_PARTY_WFSUB should be registered as a Workflow subscription handler rather than invoked manually. Because the unit is compiled with AUTHID CURRENT_USER and is dated to early releases, it should be revalidated after any TCA or Workflow patch application in 12.1.1 or 12.2.2.