APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ACTIONS

Line 2081: FROM igc_cc_actions CA

2077: LAST_UPDATED_BY ,
2078: LAST_UPDATE_LOGIN ,
2079: CREATION_DATE ,
2080: CREATED_BY
2081: FROM igc_cc_actions CA
2082: WHERE CA.cc_header_id IN
2083: ( SELECT ICV.cc_header_id
2084: FROM igc_arc_pur_candidates ICV
2085: );

Line 5263: FROM igc_cc_actions

5259: -- --------------------------------------------------------------------
5260: -- Delete all CC Action records for related CC Header IDs.
5261: -- --------------------------------------------------------------------
5262: DELETE
5263: FROM igc_cc_actions
5264: WHERE cc_header_id = l_cc_header_id;
5265:
5266: IF (g_debug_mode = 'Y') THEN
5267: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACTIONS for CC Header ID : ' ||

Line 5267: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACTIONS for CC Header ID : ' ||

5263: FROM igc_cc_actions
5264: WHERE cc_header_id = l_cc_header_id;
5265:
5266: IF (g_debug_mode = 'Y') THEN
5267: g_debug_msg := 'Number Rows Deleted from IGC_CC_ACTIONS for CC Header ID : ' ||
5268: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5269: to_char(SQL%ROWCOUNT);
5270: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5271: END IF;