Search Results find_as_rel_ps

Overview

The APPS.ARH_DQM_CUST_HELPER package is a PL/SQL helper unit that supports Oracle EBS's customer data quality management (DQM) subsystem, part of the Receivables (AR) and Trading Community (HZ) architecture. Its core responsibility is to determine the matching and deduplication treatment that should be applied to customer records — accounts, roles, account sites, contacts, and parties — during a DQM processing run. It operates against a set of global temporary tables (the "_GT" tables such as HZ_MATCHED_PARTIES_GT, HZ_MATCHED_CONTACTS_GT, and HZ_MATCHED_PARTY_SITES_GT) that hold the intermediate results of a matching session, identified by a context ID (P_CTX_ID). The package's functions answer two related questions: whether a given entity has already been matched into the working set, and how a relationship between two entities should be scored and treated. It declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the defining schema. The package is referenced by one other package within the EBS codebase.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. The lookup functions use a consistent convention: each returns 'Y' or 'N' to indicate membership or association status, taking a context identifier plus the relevant entity key. IS_CUST_ACCT_IN_PTY_GT returns 'Y' if the supplied customer account ID is already present in HZ_MATCHED_PARTIES_GT. IS_CUST_ROLE_IN_CT_GT checks whether a customer account role ID has been inserted into HZ_MATCHED_CONTACTS_GT. IS_ACCT_SITE_IN_PS_GT determines whether a customer account site ID already resides in HZ_MATCHED_PARTY_SITES_GT. IS_AS_REL_PS_IN_PS_GT performs an analogous test for an account-site-to-party-site relationship. Association functions IS_CUST_ROLE_REL_DQM_PTY, IS_AS_REL_DQM_PTY, and IS_AC_REL_PTY_IN_P_GT verify whether a role, account-site, or account relationship is linked to a party already recorded in the matched-parties table.

Scoring and insertion logic is handled by SCORE_OF_REL_PS, SCORE_REL_PARTY, INS_AS_IN_PS_GT, and INS_CA_CAR_IN_GT, which compute relationship match scores and persist matched account-site or account-role rows into the temporary tables. FIND_AS_REL_PS and FIND_ALL_ACCOUNT_FOR_PARTY locate the account-site relationships and accounts tied to a party. The remaining routines — AS_PS_TREATMENT, AC_PTY_TREATMENT, and CAR_OC_TREATMENT — determine the deduplication treatment to apply to account-site/party-site, account/party, and contact-role/org-contact combinations respectively.

Tables Accessed

The package reads and writes the working-set global temporary tables HZ_MATCHED_PARTIES_GT, HZ_MATCHED_CONTACTS_GT, HZ_MATCHED_PARTY_SITES_GT, and HZ_MATCHED_CPTS_GT (matched contact points). These hold transient match results for a DQM run. It reads the trading community master and relationship tables HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES and HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, HZ_ORG_CONTACTS, HZ_CONTACT_POINTS, and HZ_RELATIONSHIPS to resolve entity keys and relationships. All are accessed through APPS synonyms.

Usage Notes

ARH_DQM_CUST_HELPER is not intended for direct end-user invocation. It is called programmatically by the customer DQM matching engine and by other packages (one documented caller) during deduplication and match-merge processing in Receivables and the Trading Community. The P_CTX_ID parameter ties each call to a specific matching context, ensuring that lookups and insertions remain scoped to a single run. Customizations should treat the package as an internal helper and avoid direct calls, relying instead on supported DQM and HZ matching APIs, since its interface and behavior are tightly coupled to the intermediate temporary-table model.