APPS.XDP_PARTY_MERGE SQL Statements

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

Line: 30

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,ORDER_ID
              ,CUST_ACCOUNT_ID
         FROM XDP_ORDER_HEADERS yt, ra_customer_merges m
         WHERE (
            yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = request_id
         AND    m.set_number = set_number;

Line: 54

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,LINE_ITEM_ID
              ,SITE_USE_ID
         FROM XDP_ORDER_LINE_ITEMS yt, ra_customer_merges m
         WHERE (
            yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = request_id
         AND    m.set_number = set_number;

Line: 93

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID,
           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,
         'XDP_ORDER_HEADERS',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         'U',
         request_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: 124

      UPDATE XDP_ORDER_HEADERS yt SET
           CUST_ACCOUNT_ID=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
--          , REQUEST_ID=request_id
--          , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
--          , PROGRAM_ID=arp_standard.profile.program_id
--          , PROGRAM_UPDATE_DATE=SYSDATE
      WHERE ORDER_ID=PRIMARY_KEY_ID_LIST(I)
         ;

Line: 141

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

Line: 171

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID,
           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,
         'XDP_ORDER_LINE_ITEMS',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID_LIST1(I),
         NUM_COL1_ORIG_LIST1(I),
         NUM_COL1_NEW_LIST1(I),
         'U',
         request_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: 202

      UPDATE XDP_ORDER_LINE_ITEMS yt SET
           SITE_USE_ID=NUM_COL1_NEW_LIST1(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
--          , REQUEST_ID=request_id
--          , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
--          , PROGRAM_ID=arp_standard.profile.program_id
--          , PROGRAM_UPDATE_DATE=SYSDATE
      WHERE LINE_ITEM_ID=PRIMARY_KEY_ID_LIST1(I)
         ;

Line: 219

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