APPS.FND_CONC_STAT SQL Statements

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

Line: 62

          SELECT stat_collect
           INTO f_stat_collect
           FROM fnd_concurrent_programs
           WHERE concurrent_program_id = fnd_global.conc_program_id
           AND  application_id = fnd_global.prog_appl_id;

Line: 115

      SELECT actual_start_date
        INTO p_actual_start_date
        FROM fnd_concurrent_requests fcr
        WHERE fcr.request_id = p_req_id;

Line: 120

      INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
	VALUES (p_req_id, 'F', SYS_SEC_ID, sys_sec);

Line: 123

      INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
	VALUES (p_req_id, 'F', SYS_MIC_ID, sys_mic);

Line: 126

      INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
	VALUES (p_req_id, 'F', USR_SEC_ID, usr_sec);

Line: 129

      INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
	VALUES (p_req_id, 'F', USR_MIC_ID, usr_mic);

Line: 132

      INSERT INTO fnd_conc_req_stat (req_id, process_type, statistic#, value)
	VALUES (p_req_id, 'F', REAL_SEC_ID, (SYSDATE - p_actual_start_date ) * DAYSECS );

Line: 166

      SELECT sid
	INTO session
	FROM v$session
	WHERE audsid = userenv('SESSIONID');

Line: 172

        INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
          SELECT p_req_id, 'S', slist.statistic#, vstat.value
          FROM v$sesstat vstat, fnd_conc_stat_list slist
          WHERE vstat.sid = session
          AND slist.statistic# = vstat.statistic#
          AND slist.collect_level = 'S';

Line: 179

        INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
          SELECT p_req_id, 'S', slist.statistic#, vstat.value
          FROM v$sesstat vstat, fnd_conc_stat_list slist
          WHERE vstat.sid = session
          AND slist.statistic# = vstat.statistic#;

Line: 185

        INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
          SELECT p_req_id, 'S', vstat.statistic#, vstat.value
          FROM v$sesstat vstat
          WHERE vstat.sid = session;

Line: 221

      SELECT sid
	INTO session
	FROM v$session
	WHERE audsid = userenv('SESSIONID');

Line: 227

        INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
          SELECT - p_req_id, 'S', slist.statistic#, vstat.value
          FROM v$sesstat vstat, fnd_conc_stat_list slist
          WHERE vstat.sid = session
          AND slist.statistic# = vstat.statistic#
          AND slist.collect_level = 'S';

Line: 234

        INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
          SELECT - p_req_id, 'S', slist.statistic#, vstat.value
          FROM v$sesstat vstat, fnd_conc_stat_list slist
          WHERE vstat.sid = session
          AND slist.statistic# = vstat.statistic#;

Line: 240

        INSERT INTO fnd_conc_req_stat(req_id, process_type, statistic#, value)
          SELECT - p_req_id, 'S', vstat.statistic#, vstat.value
          FROM v$sesstat vstat
          WHERE vstat.sid = session;

Line: 267

	 SELECT statistic#, value
	   FROM fnd_conc_req_stat
	   WHERE req_id = - fnd_global.conc_request_id;

Line: 280

      SELECT sid
	INTO session
	FROM v$session
	WHERE audsid = userenv('SESSIONID');

Line: 287

	 SELECT value
           INTO curr_val
           FROM v$sesstat vstat
           WHERE vstat.sid = session
           AND statistic# = oldstat.statistic#;

Line: 293

	 UPDATE fnd_conc_req_stat
	   SET value = curr_val - oldstat.value, req_id = p_req_id
	   WHERE req_id = - p_req_id
	   AND statistic# = oldstat.statistic#;