eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_PURGE_PVT dependencies on AMS_ACT_LOGS

Line 483: -- Delete from ams_act_logs

479: AMS_Utility_PVT.Debug_Message(l_api_name||': l_upd_status_code=' || l_upd_status_code);
480: END IF;
481: IF l_upd_status_code = l_lookup_code
482: THEN
483: -- Delete from ams_act_logs
484: DELETE FROM ams_act_logs
485: WHERE arc_act_log_used_by = l_arc_log_used_by
486: AND act_log_used_by_id = l_import_list_header_id;
487: IF (AMS_DEBUG_HIGH_ON) THEN

Line 484: DELETE FROM ams_act_logs

480: END IF;
481: IF l_upd_status_code = l_lookup_code
482: THEN
483: -- Delete from ams_act_logs
484: DELETE FROM ams_act_logs
485: WHERE arc_act_log_used_by = l_arc_log_used_by
486: AND act_log_used_by_id = l_import_list_header_id;
487: IF (AMS_DEBUG_HIGH_ON) THEN
488: AMS_Utility_PVT.debug_message(l_api_name||': count of ams_act_logs deleted:'||sql%rowcount);

Line 488: AMS_Utility_PVT.debug_message(l_api_name||': count of ams_act_logs deleted:'||sql%rowcount);

484: DELETE FROM ams_act_logs
485: WHERE arc_act_log_used_by = l_arc_log_used_by
486: AND act_log_used_by_id = l_import_list_header_id;
487: IF (AMS_DEBUG_HIGH_ON) THEN
488: AMS_Utility_PVT.debug_message(l_api_name||': count of ams_act_logs deleted:'||sql%rowcount);
489: END IF;
490: END IF;
491:
492: COMMIT WORK; --commit after every import header purge

Line 974: DELETE from ams_act_logs

970: BEGIN
971: x_return_status := FND_API.G_RET_STS_SUCCESS;
972:
973: FORALL i in 1 .. p_id_tbl.count
974: DELETE from ams_act_logs
975: WHERE act_log_used_by_id = p_id_tbl(i);
976:
977: FORALL i in 1 .. p_id_tbl.count
978: DELETE from ams_list_select_actions

Line 1469: fnd_file.put_line(fnd_file.log,'Entries purged successfully. Need to purge from ams_act_logs.');

1465:
1466: IF ((l_retcode <> ad_conc_utils_pkg.conc_fail) AND
1467: (l_children_done)) then
1468:
1469: fnd_file.put_line(fnd_file.log,'Entries purged successfully. Need to purge from ams_act_logs.');
1470:
1471: OPEN c_get_list_headers(l_conc_request_id);
1472: LOOP
1473: FETCH c_get_list_headers BULK COLLECT INTO l_header_id_tbl, l_list_name_tbl LIMIT 1000;

Line 1476: DELETE from ams_act_logs

1472: LOOP
1473: FETCH c_get_list_headers BULK COLLECT INTO l_header_id_tbl, l_list_name_tbl LIMIT 1000;
1474:
1475: FORALL i in 1 .. l_header_id_tbl.count
1476: DELETE from ams_act_logs
1477: WHERE act_log_used_by_id = l_header_id_tbl(i);
1478:
1479: FORALL i in 1 .. l_header_id_tbl.count
1480: UPDATE ams_list_headers_all