DECLARE
    V_ROWID_TABLE              CHAR(14);
    V_SRC_ROWID_OBJECT         CHAR(14);
    V_TGT_ROWID_OBJECT         CHAR(14);
    V_PROMOTE_STRING           VARCHAR2(2000);
    V_INTERACTION_ID           INT      := NULL;
    V_USER_NAME                VARCHAR2(50);
    OUT_MERGED_IS_UNIQUE_IND   INT;
    OUT_ERROR_MESSAGE          VARCHAR2(2000);
    OUT_RETURN_CODE            INT;
    OUT_TMP_TABLE_LIST         VARCHAR2(32000);

BEGIN
    SELECT ROWID_TABLE
    INTO   V_ROWID_TABLE
    FROM   C_REPOS_TABLE
    WHERE  TABLE_NAME = 'C_CUSTOMER';
    V_TGT_ROWID_OBJECT         := 1;
    V_SRC_ROWID_OBJECT         := 2;
    V_PROMOTE_STRING           := NULL;   --Contains Rowid_column~winner~ For trusted columns to force the winning cell for that column.
                                --Winner can either be "s"ource or "t"arget.  Example:  'svr1.7sv~t~svr1.7sw~s~'
    V_INTERACTION_ID           := NULL;
    OUT_TMP_TABLE_LIST         :=NULL;
    CMXMM.MANUAL_MERGE (V_ROWID_TABLE, V_SRC_ROWID_OBJECT, V_TGT_ROWID_OBJECT, V_PROMOTE_STRING, V_INTERACTION_ID, 'ADMIN', OUT_MERGED_IS_UNIQUE_IND, OUT_ERROR_MESSAGE, OUT_RETURN_CODE, OUT_TMP_TABLE_LIST);
    DBMS_OUTPUT.PUT_LINE( 'MERGED IS UNIQUE IND: ' || OUT_MERGED_IS_UNIQUE_IND ); 
    DBMS_OUTPUT.PUT_LINE( 'RETURN MESSAGE: ' || SUBSTR( OUT_ERROR_MESSAGE, 1, 255 ));    
    DBMS_OUTPUT.PUT_LINE( 'RETURN CODE: ' || OUT_RETURN_CODE );
    DBMS_OUTPUT.PUT_LINE('OUT_ERROR_MESSAGE = ' || OUT_ERROR_MESSAGE); 
    DBMS_OUTPUT.PUT_LINE('OUT_RETURN_CODE = ' || TO_CHAR(OUT_RETURN_CODE)); 
    IF OUT_RETURN_CODE < 0 THEN
      ROLLBACK;
    ELSE
      COMMIT;
    END IF; 
    CMXUT.DROP_TABLE_IN_LIST(OUT_TMP_TABLE_LIST,OUT_ERROR_MESSAGE,OUT_RETURN_CODE); --Clean up temporary tables
END;