APPS.OE_PARTY_MERGE_PKG SQL Statements

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

Line: 32

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 61

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

Line: 65

       UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
       SET  pricing_attr_value_from = to_char(p_to_fk_id),
            last_update_date = hz_utility_v2pub.last_update_date,
       	    last_updated_by = hz_utility_v2pub.user_id,
            last_update_login = hz_utility_v2pub.last_update_login,
      	    request_id =  hz_utility_v2pub.request_id,
     	    program_application_id = hz_utility_v2pub.program_application_id,
       	    program_id = hz_utility_v2pub.program_id,
       	    program_update_date = sysdate
          WHERE pricing_attr_value_from = to_char(p_from_fk_id)
                and (pricing_context = 'ASOPARTYINFO'  AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1'
                     OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16'
                     OR pricing_context = 'CUSTOMER_GROUP' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE3'
                     OR pricing_context = 'PARTY' AND pricing_attribute
                                    IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2')
                    );

Line: 121

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 150

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

Line: 154

       UPDATE /*+ index(S OE_PRICE_ADJ_ATTRIBS_N2) */ OE_PRICE_ADJ_ATTRIBS S
       SET  pricing_attr_value_from = to_char(p_to_fk_id),
            last_update_date = hz_utility_v2pub.last_update_date,
       	    last_updated_by = hz_utility_v2pub.user_id,
            last_update_login = hz_utility_v2pub.last_update_login,
      	    request_id =  hz_utility_v2pub.request_id,
     	    program_application_id = hz_utility_v2pub.program_application_id,
       	    program_id = hz_utility_v2pub.program_id,
       	    program_update_date = sysdate
          WHERE pricing_attr_value_from = to_char(p_from_fk_id)
          AND   (pricing_context = 'ASOPARTYINFO'
                   AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')
                 OR pricing_context = 'CUSTOMER'
                   AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18')
                );