DBA Data[Home] [Help]

APPS.AML_PURGE_SALES_LEADS dependencies on AML_MONITOR_LOG

Line 72: aml_debug(1,Recs_deleted(8)||l_no_of_rows_deleted||'AML_MONITOR_LOG');

68: aml_debug(1,Recs_deleted(4)||l_no_of_rows_deleted||'AS_SALES_LEADS_LOG');
69: aml_debug(1,Recs_deleted(5)||l_no_of_rows_deleted||'AS_SALES_LEAD_CONTACTS');
70: aml_debug(1,Recs_deleted(6)||l_no_of_rows_deleted||'AS_SALES_LEAD_LINES');
71: -- aml_debug(1,Recs_deleted(7)||l_no_of_rows_deleted||'AS_SALES_LEAD_OPPORTUNITY');
72: aml_debug(1,Recs_deleted(8)||l_no_of_rows_deleted||'AML_MONITOR_LOG');
73: aml_debug(1,Recs_deleted(9)||l_no_of_rows_deleted||'PV_ENTITY_RULES_APPLIED');
74: aml_debug(1,Recs_deleted(10)||l_no_of_rows_deleted||'AS_TERRITORY_ACCESSES');
75: aml_debug(1,Recs_deleted(11)||l_no_of_rows_deleted||'AS_SALES_LEADS');
76: END write_count;

Line 126: FROM AML_MONITOR_LOG

122: Recs_deleted(7) := Recs_deleted(7) + SQL%ROWCOUNT;*/
123:
124: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST
125: DELETE
126: FROM AML_MONITOR_LOG
127: WHERE Sales_Lead_Id = P_Id_Tab(I);
128: Recs_deleted(8) := Recs_deleted(8) + SQL%ROWCOUNT;
129:
130: FORALL I IN P_Id_Tab.FIRST..P_Id_Tab.LAST