DBA Data[Home] [Help]

APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_INTERFACE

Line 5441: FROM igc_cc_interface CI

5437: -- --------------------------------------------------------------------
5438: -- Delete all CC Interface records for related CC Header IDs.
5439: -- --------------------------------------------------------------------
5440: DELETE
5441: FROM igc_cc_interface CI
5442: WHERE CI.cc_header_id = l_cc_header_id
5443: AND CI.set_of_books_id = g_sob_id;
5444:
5445: IF (g_debug_mode = 'Y') THEN

Line 5446: g_debug_msg := 'Number Rows Deleted from IGC_CC_INTERFACE for CC Header ID : ' ||

5442: WHERE CI.cc_header_id = l_cc_header_id
5443: AND CI.set_of_books_id = g_sob_id;
5444:
5445: IF (g_debug_mode = 'Y') THEN
5446: g_debug_msg := 'Number Rows Deleted from IGC_CC_INTERFACE for CC Header ID : ' ||
5447: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5448: to_char(SQL%ROWCOUNT);
5449: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5450: END IF;