APPS.DPP_ACCOUNT_MERGE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

        SELECT DISTINCT m.customer_merge_header_id
              ,yt.customer_inv_line_id
              ,m.customer_id
         FROM dpp_customer_claims_all yt, ra_customer_merges m
         WHERE (
            yt.cust_account_id = m.duplicate_id
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 90

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID1,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'dpp_customer_claims_all',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID1_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 122

      UPDATE dpp_customer_claims_all yt SET
           cust_account_id = TO_CHAR(NUM_COL1_NEW_LIST(I))
          , LAST_UPDATE_DATE = SYSDATE
          , last_updated_by = arp_standard.profile.user_id
          , last_update_login = arp_standard.profile.last_update_login
      WHERE customer_inv_line_id = PRIMARY_KEY_ID1_LIST(I);

Line: 134

    arp_message.set_name('AR','AR_ROWS_UPDATED');

Line: 181

        SELECT DISTINCT m.customer_merge_header_id
              ,yt.log_id
              ,m.customer_id
         FROM dpp_customer_claims_log yt, ra_customer_merges m
         WHERE (
            yt.cust_account_id = m.duplicate_id
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 225

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID1,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
      ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
         'dpp_customer_claims_log',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID1_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         req_id,
         hz_utility_pub.CREATED_BY,
         hz_utility_pub.CREATION_DATE,
         hz_utility_pub.LAST_UPDATE_LOGIN,
         hz_utility_pub.LAST_UPDATE_DATE,
         hz_utility_pub.LAST_UPDATED_BY
      );

Line: 257

      UPDATE dpp_customer_claims_log yt SET
           cust_account_id = TO_CHAR(NUM_COL1_NEW_LIST(I))
          , LAST_UPDATE_DATE = SYSDATE
          , last_updated_by = arp_standard.profile.user_id
          , last_update_login = arp_standard.profile.last_update_login
      WHERE log_id = PRIMARY_KEY_ID1_LIST(I);

Line: 269

    arp_message.set_name('AR','AR_ROWS_UPDATED');