APPS.XDP_MERGE SQL Statements

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

Line: 51

   SELECT rowid
   FROM   xdp_order_headers
   WHERE  p_from_fk_id IN (customer_id)
   FOR    UPDATE NOWAIT;

Line: 70

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 102

	 -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 110

	 -- if no records were found to be updated then stop and return to calling prg.
	 IF l_rowid_tbl.count = 0 THEN
	    RETURN;

Line: 114

            SELECT party_name
              INTO l_customer_name
              FROM hz_parties
             WHERE party_id = p_to_fk_id ;

Line: 122

 	   UPDATE xdp_order_headers
	      SET customer_id           = DECODE(customer_id, p_from_fk_id, p_to_fk_id, customer_id),
                  customer_name         = DECODE(customer_id,p_from_fk_id,substr(l_customer_name,1,80),customer_name),
	          last_update_date      = SYSDATE,
	          last_updated_by       = G_USER_ID,
	          last_update_login     = G_LOGIN_ID
           WHERE  rowid                 = l_rowid_tbl(i);

Line: 132

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