[Home] [Help]
277: -- log(' p_dup_batch_id = ' || p_dup_batch_id);
278: select a.dup_batch_name, a.match_rule_id,
279: decode(a.request_type, 'SYSTEM_GENERATED', 'SYSTEM_AUTOMERGE', 'IMPORT', 'IMPORT_AUTOMERGE'), a.request_type, b.automerge_flag
280: into l_batch_name, l_match_rule_id, l_req_type, l_request_type, l_automerge_flag
281: from hz_dup_batch a, hz_match_rules_b b
282: where a.dup_batch_id = p_dup_batch_id
283: and a.match_rule_id = b.match_rule_id;
284: -- log(' l_automerge_flag = ' || l_automerge_flag);
285: IF (upper(l_automerge_flag) <> 'Y') THEN
364: -- prefix AM
365: l_all_count := chk_count(A_DUP_SET_ID(I), l_winner_party_id(I));
366: --log (' l_all_count = ' || l_all_count);
367: IF substr(l_batch_name,0,3) <> 'AM:' THEN --SDIB scheduling bug 6067226
368: update hz_dup_batch
369: set dup_batch_name = 'AM: ' ||substr(l_batch_name, 1, 250)
370: where dup_batch_id = p_dup_batch_id;
371: END IF;
372:
371: END IF;
372:
373: IF (( l_count > 0) AND (is_first))THEN
374: is_first := false;
375: select hz_dup_batch_s.nextval into l_new_dup_batch_id from dual;
376: log (' l_new_dup_batch_id = '|| l_new_dup_batch_id);
377: -- substring of dup_batch_name as this gets appended and inserted in same column. This way we avoid insertion errors.
378:
379: insert into hz_dup_batch(dup_batch_id, dup_batch_name, match_rule_id, request_type,
375: select hz_dup_batch_s.nextval into l_new_dup_batch_id from dual;
376: log (' l_new_dup_batch_id = '|| l_new_dup_batch_id);
377: -- substring of dup_batch_name as this gets appended and inserted in same column. This way we avoid insertion errors.
378:
379: insert into hz_dup_batch(dup_batch_id, dup_batch_name, match_rule_id, request_type,
380: created_by, creation_date, last_update_login, last_update_date,
381: last_updated_by, application_id)
382: values(l_new_dup_batch_id, l_batch_name, l_match_rule_id, l_req_type,
383: HZ_UTILITY_V2PUB.CREATED_BY, HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,