APPS.FND_CONC_PP SQL Statements

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

Line: 80

   SELECT application_id
     INTO application_id_ret
     FROM fnd_application
     WHERE application_short_name = application_name_in;

Line: 88

       SELECT application_id
         INTO application_id_ret
         FROM fnd_application_tl
        WHERE application_name = application_name_in
          AND rownum = 1;

Line: 112

  SELECT EXECUTABLE_ID
    INTO exec_id
    FROM FND_EXECUTABLES
   WHERE application_id = program_application_id
     AND executable_name = exec_name;

Line: 176

	select OPS_INSTANCE into
 	ins_num
	from fnd_concurrent_requests
	where request_id = Req_ID;

Line: 209

	Select count(*)
  	into step_id
   	from fnd_conc_pp_actions
   	where concurrent_request_id = Req_ID
   	and Action_Type = 4;

Line: 216

     		Select max(SEQUENCE)
     		into step_id
     		from fnd_conc_pp_actions
     		where concurrent_request_id = Req_ID
     		and Action_Type = 4;

Line: 232

	Insert into fnd_conc_pp_actions
     	   (CONCURRENT_REQUEST_ID,ACTION_TYPE, STATUS_S_FLAG, STATUS_W_FLAG,
	   STATUS_F_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
	   LAST_UPDATE_LOGIN, CREATED_BY, PROGRAM_APPLICATION_ID, PROGRAM_ID,
	   Argument1, Argument2, Argument3, Argument4, Argument5,
	   Argument6, Argument7, Argument8, Argument9, Argument10,
	   SEQUENCE, OPS_INSTANCE)
     	Select Req_ID, 4, S_Flag, W_Flag,
           F_Flag, sysdate, user_id, sysdate,
           fnd_global.login_id, user_id, app_id, exec_id,
           Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10,
	   step_id, ins_num from dual;

Line: 245

        message_add('Error while inserting into fnd_conc_pp_actions.');

Line: 291

      select STATUS_S_FLAG, STATUS_W_FLAG, STATUS_F_FLAG,
    	PROGRAM_APPLICATION_ID, PROGRAM_ID,
	Argument1, Argument2, Argument3, Argument4, Argument5,
	Argument6, Argument7, Argument8, Argument9, Argument10
      into S_Flag, W_Flag, F_Flag, app_id, exec_id,
	Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10
      from fnd_conc_pp_actions
      where CONCURRENT_REQUEST_ID = Req_ID and
	sequence = Step and
	action_type = 4;

Line: 312

      select Application_short_name
      into app_short_name
      from FND_APPLICATION
      where application_id = app_id;

Line: 326

      select Executable_Name
      into exec_name
      from FND_EXECUTABLES
      where application_id = app_id
	and executable_id = exec_id;