APPS.FND_CP_OPP_CMD SQL Statements

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

Line: 46

    select processor_id, completed
      into cpid, complete
	  from fnd_conc_pp_actions
	  where concurrent_request_id = reqid
	  and action_type = 6
	  and sequence = 1;

Line: 55

	    -- post-processor has not started yet, update the table with our id
	    -- so the post-processor will not pick it up.

	    update fnd_conc_pp_actions
	      set processor_id = senderid
		  where concurrent_request_id = reqid;

Line: 64

	    -- also update the post-processing status of the request
		-- this could possibly cause a deadlock if the manager running the request still has the lock
		begin
	      update fnd_concurrent_requests
	        set pp_end_date = sysdate,
		    post_request_status = 'E'
		    where request_id = reqid;