APPS.FND_AMP_PRIVATE SQL Statements

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

Line: 94

      fnd_conc_request_pkg.delete_children (
                        request_id,
                        fnd_global.user_id);

Line: 154

    select count(*) into c
      from fnd_concurrent_program_serial
     where running_application_id = program_appl2
       and running_concurrent_program_id = program_id2
       and to_run_application_id = program_appl1
       and to_run_concurrent_program_id = program_id1;

Line: 317

      select sid, serial#
        into ssid, sserial#
        from gv$session
       where kill_session.audsid = gv$session.audsid
         and kill_session.inst_id = gv$session.inst_id;

Line: 398

      select phase_code, status_code,
             is_sub_request, has_sub_request,
             controlling_manager, parent_request_id
        into req_phase, req_status,
             is_sub_req, has_sub_req,
             mgr_proc, par_req_id
        from fnd_concurrent_requests
       where request_id = req_id
         for update of phase_code nowait;

Line: 442

    update fnd_concurrent_requests
       set phase_code = decode(new_status, 'T', phase_code, 'C'),
           status_code = new_status,
           completion_text = who_cancelled,
           last_update_date = sysdate,
           last_updated_by = fnd_global.user_id
     where request_id = req_id;

Line: 501

      select phase_code, hold_flag, request_type
        into req_phase, req_hold, req_type
        from fnd_concurrent_requests
       where request_id = req_id
         for update of phase_code nowait;

Line: 533

    update fnd_concurrent_requests
       set hold_flag = new_hold,
           last_update_date = sysdate,
           last_updated_by = fnd_global.user_id
     where request_id = req_id;

Line: 582

      select phase_code
        into req_phase
        from fnd_concurrent_requests
       where request_id = req_id
         for update of phase_code nowait;

Line: 602

    update fnd_concurrent_requests
       set priority = new_priority,
           last_update_date = sysdate,
           last_updated_by = fnd_global.user_id
     where request_id = req_id;