268: AND Creation_Date >= g_timestamp2
269: AND Creation_Date < g_timestamp1
270: UNION
271: SELECT Key_Value1_ID Invoice_ID
272: FROM FII_AP_DBI_Log_Exp_T
273: WHERE Table_Name IN ('AP_INVOICES', 'AP_INVOICE_DISTRIBUTIONS')));
274:
275: l_count := SQL%ROWCOUNT;
276:
847: END IF;
848:
849: END LOOP;
850:
851: TRUNCATE_TABLE('FII_AP_DBI_LOG_EXP_T');
852:
853: COMMIT;
854:
855: EXCEPTION
1416: END LOOP;
1417:
1418: END IF;
1419:
1420: TRUNCATE_TABLE('FII_AP_DBI_LOG_EXP_T');
1421:
1422: COMMIT;
1423:
1424: END INSERT_INTO_SUMMARY;