APPS.AML_PURGE_IMPORT_INTERFACE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

RECS_DELETED del_count;

Line: 37

   Recs_deleted(1)  := 0;

Line: 38

   Recs_deleted(2)  := 0;

Line: 39

   Recs_deleted(3)  := 0;

Line: 40

   Recs_deleted(4)  := 0;

Line: 41

   Recs_deleted(5)  := 0;

Line: 42

   Recs_deleted(6)  := 0;

Line: 44

   Recs_deleted(8)  := 0;

Line: 48

l_no_of_rows_deleted  CONSTANT varchar2(100) := ' rows deleted from the table ';

Line: 50

   write_log(1,Recs_deleted(1)||l_no_of_rows_deleted||'AS_LEAD_IMPORT_ERRORS');

Line: 51

   write_log(1,Recs_deleted(2)||l_no_of_rows_deleted||'AS_IMP_SL_FLEX');

Line: 52

   write_log(1,Recs_deleted(3)||l_no_of_rows_deleted||'AS_IMP_CNT_ROL_INTERFACE');

Line: 53

   write_log(1,Recs_deleted(4)||l_no_of_rows_deleted||'AS_IMP_CNT_PNT_INTERFACE');

Line: 54

   write_log(1,Recs_deleted(5)||l_no_of_rows_deleted||'AS_IMP_LINES_INTERFACE');

Line: 55

   write_log(1,Recs_deleted(6)||l_no_of_rows_deleted||'AML_INTERACTION_LEADS');

Line: 57

   write_log(1,Recs_deleted(8)||l_no_of_rows_deleted||'AS_IMPORT_INTERFACE');

Line: 60

PROCEDURE Delete_Identified_Leads(P_Id_Tab IN AML_PURGE_IMPORT_INTERFACE.Import_Interface_Id_Tab) IS
BEGIN

   -- Lead Import Error table
   FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
      DELETE
	FROM AS_LEAD_IMPORT_ERRORS
       WHERE import_interface_id = P_Id_Tab(I);

Line: 68

      Recs_deleted(1) := Recs_deleted(1) + SQL%ROWCOUNT;

Line: 72

       DELETE
	 FROM AS_IMP_SL_FLEX
        WHERE import_interface_id = P_Id_Tab(I);

Line: 75

       Recs_deleted(2) := Recs_deleted(2) + SQL%ROWCOUNT;

Line: 79

       DELETE
	 FROM AS_IMP_CNT_ROL_INTERFACE
        WHERE import_interface_id = P_Id_Tab(I);

Line: 82

      Recs_deleted(3) := Recs_deleted(3) + SQL%ROWCOUNT;

Line: 86

       DELETE
	 FROM AS_IMP_CNT_PNT_INTERFACE
        WHERE import_interface_id = P_Id_Tab(I);

Line: 89

       Recs_deleted(4) := Recs_deleted(4) + SQL%ROWCOUNT;

Line: 93

       DELETE
	 FROM AS_IMP_LINES_INTERFACE
        WHERE import_interface_id = P_Id_Tab(I);

Line: 96

       Recs_deleted(5) := Recs_deleted(5) + SQL%ROWCOUNT;

Line: 100

       DELETE
	 FROM AML_INTERACTION_LEADS
        WHERE import_interface_id = P_Id_Tab(I);

Line: 103

       Recs_deleted(6) := Recs_deleted(6) + SQL%ROWCOUNT;

Line: 107

       DELETE
	 FROM PV_ENTITY_RULES_APPLIED
        WHERE entity_id = P_Id_Tab(I)
   	  AND entity = 'RESPONSE';

Line: 111

       Recs_deleted(7) := Recs_deleted(7) + SQL%ROWCOUNT; */

Line: 115

       DELETE
	 FROM AS_IMPORT_INTERFACE
        WHERE import_interface_id = P_Id_Tab(I);

Line: 118

       Recs_deleted(8) := Recs_deleted(8) + SQL%ROWCOUNT;

Line: 120

END Delete_Identified_Leads;

Line: 133

l_no_of_rows_deleted  CONSTANT varchar2(100) := ' rows deleted from the table ';

Line: 140

   SELECT import_interface_id
     FROM AS_IMPORT_INTERFACE
    WHERE TRUNC(creation_date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
      AND load_status = P_STATUS;

Line: 169

         Id_Tab.DELETE;

Line: 173

      Delete_Identified_Leads(Id_Tab); --Pass the lead nos to the Purge_Qualified_Leads procedure to delete them.

Line: 178

   SELECT import_interface_id BULK COLLECT
     INTO Id_Tab
     FROM AS_IMPORT_INTERFACE
    WHERE TRUNC(creation_date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
      AND load_status = P_STATUS;

Line: 185

      Delete_Identified_Leads(Id_Tab);