APPS.ISC_DBI_ACCT_MERGE_PKG SQL Statements

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

Line: 39

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,LINE_ID
              ,SOLD_TO_ORG_ID
              ,SHIP_TO_ORG_ID
         FROM ISC_BOOK_SUM2_PDUE_F yt, ra_customer_merges m
         WHERE (
            yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
            OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 79

	 select party_id into l_new_party_id
	 from hz_cust_accounts
	 where cust_account_id = NUM_COL1_NEW_LIST(I);

Line: 87

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID1,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           NUM_COL2_ORIG,
           NUM_COL2_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,
         'ISC_BOOK_SUM2_PDUE_F',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID1_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         NUM_COL2_ORIG_LIST(I),
         NUM_COL2_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: 121

      UPDATE ISC_BOOK_SUM2_PDUE_F yt SET
           SOLD_TO_ORG_ID=NUM_COL1_NEW_LIST(I)
          ,SHIP_TO_ORG_ID=NUM_COL2_NEW_LIST(I)
	  ,CUSTOMER_ID=NUM_COL0_NEW_LIST(I)
      WHERE LINE_ID=PRIMARY_KEY_ID1_LIST(I)
         ;

Line: 133

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

Line: 177

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,LINE_ID
              ,SOLD_TO_ORG_ID
              ,SHIP_TO_ORG_ID
         FROM ISC_BOOK_SUM2_PDUE2_F yt, ra_customer_merges m
         WHERE (
            yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
            OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 217

	 select party_id into l_new_party_id
	 from hz_cust_accounts
	 where cust_account_id = NUM_COL1_NEW_LIST(I);

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,
           NUM_COL2_ORIG,
           NUM_COL2_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,
         'ISC_BOOK_SUM2_PDUE2_F',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID1_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         NUM_COL2_ORIG_LIST(I),
         NUM_COL2_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: 259

      UPDATE ISC_BOOK_SUM2_PDUE2_F yt SET
           SOLD_TO_ORG_ID=NUM_COL1_NEW_LIST(I)
          ,SHIP_TO_ORG_ID=NUM_COL2_NEW_LIST(I)
	  ,CUSTOMER_ID=NUM_COL0_NEW_LIST(I)
      WHERE LINE_ID=PRIMARY_KEY_ID1_LIST(I)
         ;

Line: 271

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

Line: 315

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,LINE_ID
              ,SOLD_TO_ORG_ID
              ,SHIP_TO_ORG_ID
         FROM ISC_BOOK_SUM2_BKORD_F yt, ra_customer_merges m
         WHERE (
            yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
            OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 355

	 select party_id into l_new_party_id
	 from hz_cust_accounts
	 where cust_account_id = NUM_COL1_NEW_LIST(I);

Line: 363

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID1,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           NUM_COL2_ORIG,
           NUM_COL2_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,
         'ISC_BOOK_SUM2_BKORD_F',
         MERGE_HEADER_ID_LIST(I),
         PRIMARY_KEY_ID1_LIST(I),
         NUM_COL1_ORIG_LIST(I),
         NUM_COL1_NEW_LIST(I),
         NUM_COL2_ORIG_LIST(I),
         NUM_COL2_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: 397

      UPDATE ISC_BOOK_SUM2_BKORD_F yt SET
           SOLD_TO_ORG_ID=NUM_COL1_NEW_LIST(I)
          ,SHIP_TO_ORG_ID=NUM_COL2_NEW_LIST(I)
	  ,CUSTOMER_ID=NUM_COL0_NEW_LIST(I)
      WHERE LINE_ID=PRIMARY_KEY_ID1_LIST(I)
         ;

Line: 409

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