2329: -- --------------------------------------------------------------------
2330: -- Delete all MRC Header records for related CC Header IDs.
2331: -- --------------------------------------------------------------------
2332: DELETE
2333: FROM igc_cc_mc_headers
2334: WHERE cc_header_id = Recinfo.cc_header_id;
2335:
2336: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2337: IF g_debug_mode = 'Y' THEN
2334: WHERE cc_header_id = Recinfo.cc_header_id;
2335:
2336: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2337: IF g_debug_mode = 'Y' THEN
2338: g_debug_msg := ' IGCCHDRB -- Num Rows Delete IGC_CC_MC_HEADERS for CC Header ID : ' ||
2339: Recinfo.cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
2340: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2341: END IF;
2342: