APPS.AML_PURGE_IMPORT_INTERFACE dependencies on AS_LEAD_IMPORT_ERRORS

Line 50: write_log(1,Recs_deleted(1)||l_no_of_rows_deleted||'AS_LEAD_IMPORT_ERRORS');

46:
47: PROCEDURE write_count IS
48: l_no_of_rows_deleted CONSTANT varchar2(100) := ' rows deleted from the table ';
49: BEGIN
50: write_log(1,Recs_deleted(1)||l_no_of_rows_deleted||'AS_LEAD_IMPORT_ERRORS');
51: write_log(1,Recs_deleted(2)||l_no_of_rows_deleted||'AS_IMP_SL_FLEX');
52: write_log(1,Recs_deleted(3)||l_no_of_rows_deleted||'AS_IMP_CNT_ROL_INTERFACE');
53: write_log(1,Recs_deleted(4)||l_no_of_rows_deleted||'AS_IMP_CNT_PNT_INTERFACE');
54: write_log(1,Recs_deleted(5)||l_no_of_rows_deleted||'AS_IMP_LINES_INTERFACE');

Line 66: FROM AS_LEAD_IMPORT_ERRORS

62:
63: -- Lead Import Error table
64: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
65: DELETE
66: FROM AS_LEAD_IMPORT_ERRORS
67: WHERE import_interface_id = P_Id_Tab(I);
68: Recs_deleted(1) := Recs_deleted(1) + SQL%ROWCOUNT;
69:
70: -- Lead Import Flex table