DBA Data[Home] [Help]

APPS.FND_CONC_WEB_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 63

     select nvl(sum(running_processes),0) into v_running_processes from fnd_concurrent_worker_requests where
     (CONTROL_CODE not in ('D', 'T', 'E', 'X', 'R', 'N') OR CONTROL_CODE is NULL)
     and request_id=P_REQUEST_ID;
Line: 95

           ELSIF ((l_dev_status = 'DELETED') OR (l_dev_status = 'TERMINATED')) THEN
	   --Here there are 2 deviation from Original Specification.
	   --Cancelled cahnged to DELETED and Terminating changed to TERMINATED
	   --Cancelled-  DELETED | Terminating - TERMINATED
             l_image_name := 'cancelind_active.gif';