2187: IF ( v_duplicate_id <> v_customer_id ) THEN
2188: IF ( ( v_prev_duplicate_id IS NULL ) OR
2189: ( v_prev_duplicate_id <> v_duplicate_id ) )
2190: THEN
2191: arp_cust_alt_match_pkg.lock_match (
2192: v_duplicate_id, NULL, v_lock_status );
2193:
2194: IF ( v_lock_status = 1 ) THEN
2195: arp_cust_alt_match_pkg.delete_match ( v_duplicate_id, NULL, NULL );
2191: arp_cust_alt_match_pkg.lock_match (
2192: v_duplicate_id, NULL, v_lock_status );
2193:
2194: IF ( v_lock_status = 1 ) THEN
2195: arp_cust_alt_match_pkg.delete_match ( v_duplicate_id, NULL, NULL );
2196: END IF;
2197:
2198: v_prev_duplicate_id := v_duplicate_id ;
2199:
2198: v_prev_duplicate_id := v_duplicate_id ;
2199:
2200: END IF ;
2201: ELSE
2202: arp_cust_alt_match_pkg.lock_match (
2203: v_duplicate_id, v_duplicate_site_id, v_lock_status );
2204:
2205: IF ( v_lock_status = 1 ) THEN
2206: arp_cust_alt_match_pkg.delete_match (
2202: arp_cust_alt_match_pkg.lock_match (
2203: v_duplicate_id, v_duplicate_site_id, v_lock_status );
2204:
2205: IF ( v_lock_status = 1 ) THEN
2206: arp_cust_alt_match_pkg.delete_match (
2207: v_duplicate_id, v_duplicate_site_id, NULL );
2208: END IF;
2209:
2210: END IF;