APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on PO_LINES_ALL

Line 2373: INTO igc_cc_arc_po_lines_all

2369: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2370: END IF;
2371:
2372: INSERT
2373: INTO igc_cc_arc_po_lines_all
2374: (po_line_id,
2375: last_update_date,
2376: last_updated_by,
2377: po_header_id,

Line 2607: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Lines ALL Table for ' ||

2603: );
2604:
2605: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2606: IF (g_debug_mode = 'Y') THEN
2607: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Lines ALL Table for ' ||
2608: ' Last Activity Date : ' || g_last_activity_date;
2609: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2610: END IF;
2611:

Line 5321: FROM po_lines_all PLA

5317: -- --------------------------------------------------------------------
5318: -- Delete all PO Lines records for related CC Header IDs.
5319: -- --------------------------------------------------------------------
5320: DELETE
5321: FROM po_lines_all PLA
5322: WHERE PLA.po_header_id IN
5323: ( SELECT PHA.po_header_id
5324: FROM po_headers_all PHA
5325: WHERE PHA.segment1 IN

Line 5333: g_debug_msg := 'Number Rows Deleted from PO_LINES_ALL for CC Header ID : ' ||

5329: )
5330: );
5331:
5332: IF (g_debug_mode = 'Y') THEN
5333: g_debug_msg := 'Number Rows Deleted from PO_LINES_ALL for CC Header ID : ' ||
5334: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5335: to_char(SQL%ROWCOUNT);
5336: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5337: END IF;