APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_ACT_LOGS

Line 1342: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =

1338: l_count number; --DBMS_SQL.NUMBER_TABLE;
1339: idx varchar2(6);
1340:
1341: begin
1342: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =
1343: 'RECL' and ACT_LOG_USED_BY_ID = p_template_id;
1344: -- dbms_output.put_line('IN AMS_List_running_total_pvt----------------------- ');
1345: AMS_Utility_PVT.Create_Log (
1346: x_return_status => l_return_status,