APPS.HXC_RDB_PROCESS SQL Statements

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

Line: 76

        SELECT phase_code,
               status_code
          INTO l_phase,
               l_status
          FROM fnd_concurrent_requests
         WHERE request_id = l_request_id;

Line: 83

        INSERT INTO hxc_rdb_processes
         ( request_id,
           conc_program_id,
           conc_program_name,
           date_start,
           phase,
           status,
           ret_user_id )
        VALUES ( l_request_id,
                 l_conc_id,
                 'PYTSHPRI',
                  l_sysdate,
                  l_phase,
                  l_status,
                  FND_GLOBAL.USER_ID);

Line: 121

        SELECT phase_code,
               status_code
          INTO l_phase,
               l_status
          FROM fnd_concurrent_requests
         WHERE request_id = l_request_id;

Line: 129

       INSERT INTO hxc_rdb_processes
        ( request_id,
          conc_program_id,
          conc_program_name,
          date_start,
           phase,
           status,
          ret_user_id  )
       VALUES ( l_request_id,
                l_conc_id,
                'PAXTRTRX',
                 l_sysdate,
                  l_phase,
                  l_status,
                 FND_GLOBAL.USER_ID);

Line: 162

       IS SELECT concurrent_program_id
            FROM fnd_concurrent_programs
           WHERE concurrent_program_name = p_conc_name
             AND application_id = p_application_id ;

Line: 203

      IS SELECT status_code,
                phase_code,
                actual_completion_date,
                ROWIDTOCHAR(rdb.rowid)
           FROM hxc_rdb_processes rdb,
                fnd_concurrent_requests fnd
          WHERE rdb.ret_user_id = FND_GLOBAL.user_id
            AND rdb.request_id = fnd.request_id
            AND fnd.requested_by = rdb.ret_user_id
            AND rdb.phase <> 'C';

Line: 234

           UPDATE hxc_rdb_processes
              SET status = l_status_tab(i),
                  phase  = l_phase_tab(i),
                  date_end = l_comp_tab(i)
            WHERE ROWID = CHARTOROWID(l_row_tab(i));