APPS.AZ_R12_UPD_DET_LOG dependencies on AZ_DIFF_RESULTS

Line 35: FROM az_diff_results

31: BEGIN
32:
33: SELECT MAX(id)
34: INTO v_last_commit_marker_id
35: FROM az_diff_results
36: WHERE request_id = p_request_id
37: AND source = p_source
38: AND name = v_commit_marker_name
39: ORDER BY id;

Line 52: DELETE FROM az_diff_results

48: || to_char(systimestamp), 'Getting Max Commit marker id for p_request_id: ' || p_request_id
49: || ' p_source: ' || p_source || ' v_last_commit_marker_id: ' || v_last_commit_marker_id);
50: end if;
51:
52: DELETE FROM az_diff_results
53: WHERE request_id = p_request_id
54: AND source = p_source
55: AND name = v_commit_marker_name;
56:

Line 59: UPDATE az_diff_results

55: AND name = v_commit_marker_name;
56:
57: -- there are no commit markers, hence update the status as SP for all records
58:
59: UPDATE az_diff_results
60: SET detail_log_status = 'SP'
61: WHERE request_id = p_request_id
62: AND source = p_source
63: AND id > v_last_commit_marker_id

Line 72: FROM az_diff_results

68:
69: -- Now update the entire tree for records which are Skipped with Warning
70: SELECT id bulk collect
71: INTO v_commit_marker_id_list
72: FROM az_diff_results
73: WHERE request_id = p_request_id
74: AND source = p_source
75: AND detail_log_status = 'SW'
76: ORDER BY id;

Line 86: FROM az_diff_results

82: ------------------------------------------------------------------------------
83: -- Now update the entire tree for records which are Skipped with Warning
84: SELECT id bulk collect
85: INTO v_commit_marker_id_list
86: FROM az_diff_results
87: WHERE request_id = p_request_id
88: AND source = p_source
89: AND detail_log_status = 'E'
90: ORDER BY id;

Line 116: l_log_query := 'UPDATE az_diff_results g

112: BEGIN
113:
114: FOR i IN 1 .. p_id_list.COUNT
115: LOOP
116: l_log_query := 'UPDATE az_diff_results g
117: SET g.detail_log_status = ' || p_log_status || '
118: WHERE g.id in
119: (SELECT k.id
120: FROM

Line 124: FROM az_diff_results d

120: FROM
121: (SELECT parent_id, id, detail_log_status
122: FROM
123: (SELECT d.parent_id, d.id, d.detail_log_status
124: FROM az_diff_results d
125: WHERE d.request_id = ' || p_request_id || '
126: AND d.source = ''' || p_source || '''
127: AND d.parent_id >0) f
128: CONNECT BY PRIOR f.parent_id = f.id START WITH f.id = ' || p_id_list(i) || ') k

Line 200: FROM az_diff_results d

196:
197: ---Rows Inserted
198: SELECT COUNT(1)
199: INTO v_rows_count
200: FROM az_diff_results d
201: WHERE request_id = p_request_id
202: AND source = p_source
203: AND parent_id = 1
204: AND detail_log_status = 'I';

Line 213: FROM az_diff_results d

209:
210: ---Rows Updated
211: SELECT COUNT(1)
212: INTO v_rows_count
213: FROM az_diff_results d
214: WHERE request_id = p_request_id
215: AND source = p_source
216: AND parent_id = 1
217: AND detail_log_status = 'U';

Line 225: FROM az_diff_results d

221: v_update_xsl := v_update_xsl || v_rows_count || '';
222:
223: SELECT COUNT(1)
224: INTO v_rows_count
225: FROM az_diff_results d
226: WHERE request_id = p_request_id
227: AND source = p_source
228: AND parent_id = 1
229: AND(detail_log_status LIKE 'S%' OR detail_log_status = 'E');

Line 238: FROM az_diff_results d

234:
235: ---Rows RowsPartiallyInserted
236: SELECT COUNT(1)
237: INTO v_rows_count
238: FROM az_diff_results d
239: WHERE request_id = p_request_id
240: AND source = p_source
241: AND parent_id = 1
242: AND detail_log_status = 'IW';

Line 251: FROM az_diff_results d

247:
248: ---Rows RowsPartiallyUpdated
249: SELECT COUNT(1)
250: INTO v_rows_count
251: FROM az_diff_results d
252: WHERE request_id = p_request_id
253: AND source = p_source
254: AND parent_id = 1
255: AND detail_log_status = 'UW';