Search Results pap_cmerge




Overview
Explore in AI Chat

Overview

PAP_CMERGE is an Oracle Applications (APPS) schema PL/SQL package that supports customer merge processing within the Projects (PA) module of Oracle E-Business Suite. In EBS, when two customer records are merged through the Oracle Receivables customer merge facility, any project-level data associated with the obsolete (duplicate) customer must be re-pointed to the surviving customer. PAP_CMERGE performs this project-side synchronization work.

The package is the Projects module's subscription handler for the customer merge event flow. Its core purpose is to update project and project-related records so that they reference the surviving customer after a merge. The package is documented in ETRM with object type PACKAGE, owner APPS, and status VALID. It is classified as an "OTHER" API, meaning it is not a published open interface or a standard public API, but an internal engine package supporting the merge workflow. The package contains a single documented procedure, MERGE, and it is referenced by two other packages, indicating it is invoked from higher-level merge orchestration logic.

Key Procedures and Functions

  • MERGE — The single documented procedure in PAP_CMERGE. It carries out the customer merge operation for project-related entities. When the Receivables merge process advances to the Projects application, MERGE updates the project records that point to the from-customer so that they now point to the to-customer. It also updates related child records such as project contacts, agreements, and agreements-all records so that the merge result is consistent across PA. No parameter list is documented in the ETRM metadata, and none should be assumed; the procedure operates within the context of the merge session established by the calling merge packages.

The package's dependency listing shows that PAP_CMERGE is referenced by PAP_CMERGE itself (self-reference, consistent with a package body or internal call) and by the packages PAP_CMERGE_BB1 and PAP_CMERGE_BB2, which are the before/after branch body components of the package. The package is also referenced by two other packages in the documented metadata, confirming it is called as part of a larger merge chain rather than invoked directly by end users.

Tables Accessed

The package reads and writes the following objects, referenced through APPS synonyms:

Usage Notes

PAP_CMERGE is not a user-invoked API. It is called internally during the Oracle Receivables customer merge concurrent process when the Projects application is among the applications selected for merge processing. In EBS 12.1.1 and 12.2.2, the merge is driven from the Trading Community Architecture (TCA) customer merge function; the Projects portion executes automatically via the merge subscription chain. Developers should not call PAP_CMERGE.MERGE directly from custom code, as the Receivables merge orchestration assumes responsibility for call ordering, validation, and commit boundaries. Customizations that must react to a customer merge in Projects should use standard supported integration points or the corresponding documented public APIs rather than the internal PAP_CMERGE package.