APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 5299: FROM po_line_locations_all PLLA

5295: -- --------------------------------------------------------------------
5296: -- Delete all PO Line Location records for related CC Header IDs.
5297: -- --------------------------------------------------------------------
5298: DELETE
5299: FROM po_line_locations_all PLLA
5300: WHERE PLLA.po_header_id IN
5301: ( SELECT PHA.po_header_id
5302: FROM po_headers_all PHA
5303: WHERE PHA.segment1 IN

Line 5311: g_debug_msg := 'Number Rows Deleted from PO_LINE_LOCATIONS_ALL for CC Header ID : ' ||

5307: )
5308: );
5309:
5310: IF (g_debug_mode = 'Y') THEN
5311: g_debug_msg := 'Number Rows Deleted from PO_LINE_LOCATIONS_ALL for CC Header ID : ' ||
5312: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5313: to_char(SQL%ROWCOUNT);
5314: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5315: END IF;