APPS.FND_CONCURRENT_BUSINESS_EVENT SQL Statements

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

Line: 22

  select decode(p_event_code, 1, 'oracle.apps.fnd.concurrent.request.submitted',
                              2, 'oracle.apps.fnd.concurrent.request.on_hold',
                              3, 'oracle.apps.fnd.concurrent.request.resumed',
                              4, 'oracle.apps.fnd.concurrent.request.running',
                              5, 'oracle.apps.fnd.concurrent.program.completed',
                              6, 'oracle.apps.fnd.concurrent.request.postprocessing_started',
                              7, 'oracle.apps.fnd.concurrent.request.postprocessing_ended',
                              8, 'oracle.apps.fnd.concurrent.request.completed',
                              'NOT_FOUND')
       into v_event_name
       from dual;

Line: 184

  select count(*) into v_tempcount
  from fnd_concurrent_requests
  where request_id = p_request_id;

Line: 200

  select program_application_id, concurrent_program_id
    into v_program_application_id, v_concurrent_program_id
    from fnd_concurrent_requests
   where request_id = p_request_id;

Line: 205

  select business_event_map into v_event_map_info
    from fnd_conc_prog_onsite_info
   where program_application_id = v_program_application_id
     and concurrent_program_id = v_concurrent_program_id;

Line: 222

      select requested_by, program_application_id, concurrent_program_id, status_code, completion_text
        into v_requested_by, v_program_application_id, v_concurrent_program_id, v_status_code, v_completion_text
        from fnd_concurrent_requests
       where request_id = p_request_id;

Line: 288

  select count(*)
   into v_temp_count
   from fnd_conc_prog_onsite_info
   where program_application_id = p_application_id
     and concurrent_program_id = p_concurrent_program_id;

Line: 303

  select RPAD(business_event_map, 50, 'N')
    into v_current_state
    from fnd_conc_prog_onsite_info
   where program_application_id = p_application_id
     and concurrent_program_id = p_concurrent_program_id;

Line: 322

  update fnd_conc_prog_onsite_info
    set business_event_map = v_new_char
  where program_application_id = p_application_id
    and  concurrent_program_id = p_concurrent_program_id;