[Home] [Help]
95:
96: v_am_name_a VARCHAR2(4000);
97: v_am_disp_name_a VARCHAR2(4000);
98: v_results_id NUMBER := 1;
99: -- id for az_diff_results
100: -- v_attr_clob CLOB;
101: v_hcd_a VARCHAR2(4000);
102: l_api_name constant VARCHAR2(30) := 'compare : ';
103: BEGIN
122:
123: EXECUTE IMMEDIATE 'ALTER SESSION SET CURSOR_SHARING=''SIMILAR''';
124:
125: INSERT
126: INTO az_diff_results(name, display_name, request_id, source, type, id, parent_id, hashcode_details, depth, is_different, is_transformed, show_only_diff, param2, attr_diff)
127: VALUES(v_am_name_a, -- name
128: v_am_disp_name_a, p_request_id, p_source, -1, -- type
129: v_results_id, 0, -- parent_id
130: v_hcd_a, 1, -- depth
135: NULL);
136: -- attr_diff
137:
138: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
139: fnd_log.string(fnd_log.level_statement, c_log_head || l_api_name || to_char(systimestamp), 'Inserting into az_diff_results for request_id: '
140: || p_request_id || ' source: ' || p_source);
141: END IF;
142:
143: v_dml_count := v_dml_count + 1;
327: v_type := 2;
328: END IF;
329:
330: INSERT
331: INTO az_diff_results(name, display_name, request_id, source, type, id, parent_id, hashcode_details, depth, is_different, is_transformed, show_only_diff, param2, attr_diff)
332: VALUES(v_children_a_name_list(i), v_children_a_disp_name_list(i), p_request_id, p_source, v_type, p_results_id, p_results_pid, v_children_a_hcd_list(i), p_depth, -- depth
333: v_is_different, -- isdifferent
334: 'N', -- istransformed
335: decode(v_is_different, 'C', 'Y', 'N'), --show only diff--v_show_only_diff, -- show_only_diff
475: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: ' || p_results_pid);
476: END IF;
477:
478: INSERT
479: INTO az_diff_results(name, display_name, request_id, source, type, id, parent_id, hashcode_details, depth, is_different, is_transformed, show_only_diff, param2, attr_diff)
480: VALUES(v_name_a, v_disp_name_a, p_request_id, p_source, v_type, p_results_id, p_results_pid, v_hcd_a, p_depth, -- depth
481: 'A', -- isdifferent
482: 'N', -- istransformed
483: 'Y', -- show_diff_only
594: || p_results_pid);
595: END IF;
596:
597: INSERT
598: INTO az_diff_results(name, display_name, request_id, source, type, id, parent_id, hashcode_details, depth, is_different, is_transformed, show_only_diff, param2, attr_diff)
599: VALUES(v_name_b, v_disp_name_b, p_request_id, p_source, v_type, p_results_id, p_results_pid, v_hcd_b, p_depth, -- depth
600: 'B', -- isdifferent
601: 'N', -- istransformed
602: 'Y', -- show_diff_only
657: SELECT id,
658: parent_id bulk collect
659: INTO v_different_id_list,
660: v_different_pid_list
661: FROM az_diff_results
662: WHERE request_id = p_request_id
663: AND source = p_source
664: AND is_different <> 'N' -- gets you A, B or C
665: ORDER BY depth;
680: show_only_diff
681: INTO v_parent_id,
682: v_is_different,
683: v_show_only_diff
684: FROM az_diff_results
685: WHERE request_id = p_request_id
686: AND source = p_source
687: AND id = v_id;
688:
699:
700: IF v_is_different = 'N'
701: AND v_show_only_diff = 'N' THEN
702:
703: UPDATE az_diff_results
704: SET show_only_diff = 'Y',
705: is_different = 'D'
706: WHERE request_id = p_request_id
707: AND source = p_source
794: v_diff_type_list
795: FROM
796: (SELECT decode(is_different, 'A', 'P6', 'B', 'P7', 'C', 'P8', 'D', 'P8', 'N', 'P9') name,
797: COUNT(is_different) COUNT
798: FROM az_diff_results d
799: WHERE request_id = p_request_id
800: AND source = p_source
801: AND parent_id = 1
802: GROUP BY is_different)