APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on PO_LINE_LOCATIONS

Line 2859: FROM po_line_locations PLLA

2855: match_option,
2856: tax_code_id,
2857: calculate_tax_flag,
2858: change_promised_date_reason
2859: FROM po_line_locations PLLA
2860: WHERE PLLA.po_header_id IN
2861: ( SELECT po_header_id
2862: FROM po_headers PHA
2863: WHERE PHA.segment1 IN

Line 3896: g_debug_msg := ' Deleting records from Archive PO Line Locations table for' ||

3892: -- Delete Archived PO Line Location records that may exist
3893: -- --------------------------------------------------------------------
3894: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3895: IF (g_debug_mode = 'Y') THEN
3896: g_debug_msg := ' Deleting records from Archive PO Line Locations table for' ||
3897: ' Last Activity Date : ' || g_last_activity_date;
3898: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3899: END IF;
3900:

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;