168:
169: /*v_data_pid_B*/);
170: COMMIT;
171: update_for_show_only_diff(p_request_id, p_source);
172: ---LMATHUR - need to update the individual counts based on the number of differences
173: update_diff_type_counts(p_request_id, p_source);
174: COMMIT;
175:
176: EXCEPTION
294: and SEC.is_primary = 'N';
295:
296: SELECT decode(existsnode(v_temp_xmltype, '/H/V[./A/text()!=./B/text() and not(@U="Y")]'), 1, 'C', 'N')
297: INTO v_is_different
298: FROM dual;
299:
300: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
301: INTO v_exclude_details_temp
302: FROM dual;
298: FROM dual;
299:
300: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
301: INTO v_exclude_details_temp
302: FROM dual;
303:
304: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN
305: v_exclude_details := 'Y';
306: ELSE
447: AND is_primary = 'Y';
448:
449: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
450: INTO v_exclude_details_temp
451: FROM dual;
452:
453: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN
454: v_exclude_details := 'Y';
455: ELSE
565: AND is_primary = 'N';
566:
567: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
568: INTO v_exclude_details_temp
569: FROM dual;
570:
571: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN
572: v_exclude_details := 'Y';
573: ELSE