42: --check the merge reason, if merge reason is 'Duplicate Record' then no validation is performed.
43: --otherwise check if the resource is being used somewhere
44: SELECT merge_reason_code
45: INTO l_merge_reason_code
46: FROM hz_merge_batch
47: WHERE batch_id = p_batch_id;
48:
49: IF l_merge_reason_code = 'DUPLICATE' THEN
50: -- if reason code is duplicate then allow the party merge to happen without
172: --check the merge reason, if merge reason is 'Duplicate Record' then no validation is performed.
173: --otherwise check if the resource is being used somewhere
174: SELECT merge_reason_code
175: INTO l_merge_reason_code
176: FROM hz_merge_batch
177: WHERE batch_id = p_batch_id;
178:
179: IF l_merge_reason_code = 'DUPLICATE' THEN
180: -- if reason code is duplicate then allow the party merge to happen without