APPS.CS_SR_ACCOUNT_MERGE_PKG SQL Statements

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

Line: 98

         SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,INCIDENT_ID
              ,ACCOUNT_ID
              ,BILL_TO_ACCOUNT_ID
              ,SHIP_TO_ACCOUNT_ID
              ,LAST_UPDATE_PROGRAM_CODE
         FROM CS_INCIDENTS_ALL_B yt,
	      ra_customer_merges m
         WHERE ( yt.ACCOUNT_ID = m.DUPLICATE_ID
	 OR yt.BILL_TO_ACCOUNT_ID = m.DUPLICATE_ID
         OR yt.SHIP_TO_ACCOUNT_ID = m.DUPLICATE_ID)
         AND    m.process_flag = 'N'
         AND    m.request_id   = req_id
         AND    m.set_number   = set_number;

Line: 114

         SELECT PARTY_ID
         FROM HZ_CUST_ACCOUNTS HCA
         WHERE cust_account_id = p_cust_account_id;

Line: 119

 	 select CUSTOMER_ID, DUPLICATE_ID
	 from   RA_CUSTOMER_MERGES RCM
	 Where  rcm.request_id   = req_id
	 And    rcm.set_number   = set_number
	 And    rcm.process_flag = 'N';

Line: 136

  l_last_update_program_code   VARCHAR2_30_TBL;

Line: 185

          , L_LAST_UPDATE_PROGRAM_CODE
          limit 1000;

Line: 210

            INSERT INTO HZ_CUSTOMER_MERGE_LOG (
               MERGE_LOG_ID,                        TABLE_NAME,
	       MERGE_HEADER_ID,                     PRIMARY_KEY_ID,
	       NUM_COL1_ORIG,                       NUM_COL1_NEW,
               NUM_COL2_ORIG,                       NUM_COL2_NEW,
	       NUM_COL3_ORIG,                       NUM_COL3_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,     'CS_INCIDENTS_ALL_B',
	       MERGE_HEADER_ID_LIST(I),             PRIMARY_KEY_ID_LIST(I),
	       NUM_COL1_ORIG_LIST(I),               NUM_COL1_NEW_LIST(I),
               NUM_COL2_ORIG_LIST(I),               NUM_COL2_NEW_LIST(I),
	       NUM_COL3_ORIG_LIST(I),               NUM_COL3_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: 234

            UPDATE CS_INCIDENTS_ALL_B yt SET
               ACCOUNT_ID              = NUM_COL1_NEW_LIST(I)
             , BILL_TO_ACCOUNT_ID      = NUM_COL2_NEW_LIST(I)
             , SHIP_TO_ACCOUNT_ID      = NUM_COL3_NEW_LIST(I)
             , LAST_UPDATE_PROGRAM_CODE = 'ACCOUNT_MERGE'
             , INCIDENT_LAST_MODIFIED_DATE = SYSDATE
             , LAST_UPDATE_DATE        = SYSDATE
             , last_updated_by         = arp_standard.profile.user_id
             , last_update_login       = arp_standard.profile.last_update_login
             , REQUEST_ID              = req_id
             , PROGRAM_APPLICATION_ID  = arp_standard.profile.program_application_id
             , PROGRAM_ID              = arp_standard.profile.program_id
             , PROGRAM_UPDATE_DATE     = SYSDATE
         WHERE INCIDENT_ID=PRIMARY_KEY_ID_LIST(I) ;

Line: 298

                    l_audit_vals_rec.last_update_program_code 	:= 'ACCOUNT_MERGE' ;

Line: 299

                    l_audit_vals_rec.old_last_update_program_code 	:= l_last_update_program_code (i);

Line: 300

                    l_audit_vals_rec.updated_entity_code 		:= 'SR_HEADER';

Line: 301

                    l_audit_vals_rec.updated_entity_id 		:= PRIMARY_KEY_ID_LIST(I);

Line: 315

                               p_last_update_date    	=> SYSDATE,
                               p_creation_date       	=> SYSDATE,
                               p_comments            	=> NULL,
                               x_audit_id            	=> l_audit_id);

Line: 329

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