APPS.AML_PURGE_IMPORT_INTERFACE dependencies on AS_IMPORT_INTERFACE

Line 57: write_log(1,Recs_deleted(8)||l_no_of_rows_deleted||'AS_IMPORT_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');
55: write_log(1,Recs_deleted(6)||l_no_of_rows_deleted||'AML_INTERACTION_LEADS');
56: -- write_log(1,Recs_deleted(7)||l_no_of_rows_deleted||'PV_ENTITY_RULES_APPLIED');
57: write_log(1,Recs_deleted(8)||l_no_of_rows_deleted||'AS_IMPORT_INTERFACE');
58: END write_count;
59:
60: PROCEDURE Delete_Identified_Leads(P_Id_Tab IN AML_PURGE_IMPORT_INTERFACE.Import_Interface_Id_Tab) IS
61: BEGIN

Line 116: FROM AS_IMPORT_INTERFACE

112:
113: -- Lead Import Base table
114: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
115: DELETE
116: FROM AS_IMPORT_INTERFACE
117: WHERE import_interface_id = P_Id_Tab(I);
118: Recs_deleted(8) := Recs_deleted(8) + SQL%ROWCOUNT;
119:
120: END Delete_Identified_Leads;

Line 141: FROM AS_IMPORT_INTERFACE

137: l_end_date date;
138:
139: CURSOR Collect_Imp_Interface_Ids(l_start_date in date,l_end_date in date,p_status in varchar2) IS
140: SELECT import_interface_id
141: FROM AS_IMPORT_INTERFACE
142: WHERE TRUNC(creation_date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
143: AND load_status = P_STATUS;
144:
145: BEGIN

Line 180: FROM AS_IMPORT_INTERFACE

176:
177: --The remaining records to be deleted.
178: SELECT import_interface_id BULK COLLECT
179: INTO Id_Tab
180: FROM AS_IMPORT_INTERFACE
181: WHERE TRUNC(creation_date) BETWEEN TRUNC(l_start_date) AND TRUNC(l_end_date)
182: AND load_status = P_STATUS;
183:
184: IF Id_Tab.FIRST IS NOT NULL THEN --This should be executed only if atleast there is one record.