DBA Data[Home] [Help]

APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on AMS_ACT_LOGS

Line 1408: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =

1404: l_count number; --DBMS_SQL.NUMBER_TABLE;
1405: idx varchar2(6);
1406:
1407: begin
1408: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =
1409: 'RECL' and ACT_LOG_USED_BY_ID = p_template_id;
1410: -- dbms_output.put_line('IN AMS_List_running_total_pvt----------------------- ');
1411: AMS_Utility_PVT.Create_Log (
1412: x_return_status => l_return_status,