[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;
323: v_type := 2;
324: END IF;
325:
326: INSERT
327: 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)
328: 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
329: v_is_different, -- isdifferent
330: 'N', -- istransformed
331: decode(v_is_different, 'C', 'Y', 'N'), --show only diff--v_show_only_diff, -- show_only_diff
471: || to_char(systimestamp), 'v_exclude_details: ' || v_exclude_details || ' p_results_pid: ' || p_results_pid);
472: END IF;
473:
474: INSERT
475: 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)
476: 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
477: 'A', -- isdifferent
478: 'N', -- istransformed
479: 'Y', -- show_diff_only
590: || p_results_pid);
591: END IF;
592:
593: INSERT
594: 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)
595: 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
596: 'B', -- isdifferent
597: 'N', -- istransformed
598: 'Y', -- show_diff_only
653: SELECT id,
654: parent_id bulk collect
655: INTO v_different_id_list,
656: v_different_pid_list
657: FROM az_diff_results
658: WHERE request_id = p_request_id
659: AND source = p_source
660: AND is_different <> 'N' -- gets you A, B or C
661: ORDER BY depth;
676: show_only_diff
677: INTO v_parent_id,
678: v_is_different,
679: v_show_only_diff
680: FROM az_diff_results
681: WHERE request_id = p_request_id
682: AND source = p_source
683: AND id = v_id;
684:
695:
696: IF v_is_different = 'N'
697: AND v_show_only_diff = 'N' THEN
698:
699: UPDATE az_diff_results
700: SET show_only_diff = 'Y',
701: is_different = 'D'
702: WHERE request_id = p_request_id
703: AND source = p_source
790: v_diff_type_list
791: FROM
792: (SELECT decode(is_different, 'A', 'P6', 'B', 'P7', 'C', 'P8', 'D', 'P8', 'N', 'P9') name,
793: COUNT(is_different) COUNT
794: FROM az_diff_results d
795: WHERE request_id = p_request_id
796: AND source = p_source
797: AND parent_id = 1
798: GROUP BY is_different)