APPS.QLTCONTB SQL Statements

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

Line: 139

        INSERT INTO QA_CHART_DATA
  	  (LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_LOGIN,
	   SUBGROUP_NUMBER,
           AVERAGE,
           RANGE,
	   BAR_NUMBER,
	   HIST_RANGE,
	   NUM_OCCURRENCES)
        VALUES
	  (SYSDATE,
	   1,
	   SYSDATE,
	   1,
	   NULL,
	   j,
	   average_table(j),
	   range_table(j),
	   null,
	   null,
	   null);

Line: 177

      SELECT A2, D3, D4 INTO A2, D3, D4
      FROM QA_CHART_CONSTANTS
      WHERE SUBGROUP_SIZE = subgrp_size;

Line: 314

        INSERT INTO QA_CHART_DATA
  	  (LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_LOGIN,
	   SUBGROUP_NUMBER,
           AVERAGE,
           RANGE,
	   BAR_NUMBER,
	   HIST_RANGE,
	   NUM_OCCURRENCES)
        VALUES
	  (SYSDATE,
	   1,
	   SYSDATE,
	   1,
	   NULL,
	   j,
	   average_table(j),
	   std_dev_table(j),
	   null,
	   null,
	   null);

Line: 352

      SELECT A1, B3, B4 INTO A1, B3, B4
      FROM QA_CHART_CONSTANTS
      WHERE SUBGROUP_SIZE = subgrp_size;

Line: 533

        INSERT INTO QA_CHART_DATA
  	  (LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_LOGIN,
	   SUBGROUP_NUMBER,
           AVERAGE,
           RANGE,
	   BAR_NUMBER,
	   HIST_RANGE,
	   NUM_OCCURRENCES)
        VALUES
	  (SYSDATE,
	   1,
	   SYSDATE,
	   1,
	   NULL,
	   k,
	   temp_results(k),
	   range_table(k),
	   null,
	   null,
	   null);

Line: 572

      SELECT D3, D4, E2 INTO D3, D4, E2
      FROM QA_CHART_CONSTANTS
      WHERE SUBGROUP_SIZE = subgrp_size;

Line: 762

insert into jc_temp values ('min_table(' || k || '): ' || to_char(min_table(k)));

Line: 763

insert into jc_temp values ('max_table(' || k || '): ' || to_char(max_table(k)));

Line: 764

insert into jc_temp values ('average_table(' || k || '): ' || to_char(average_table(k)));

Line: 765

insert into jc_temp values ('range_table(' || k || '): ' || to_char(range_table(k)));

Line: 776

        INSERT INTO QA_CHART_DATA
  	  (LAST_UPDATE_DATE,
	   LAST_UPDATED_BY,
	   CREATION_DATE,
	   CREATED_BY,
	   LAST_UPDATE_LOGIN,
	   SUBGROUP_NUMBER,
           AVERAGE,
           RANGE,
	   BAR_NUMBER,
	   HIST_RANGE,
	   NUM_OCCURRENCES)
        VALUES
	  (SYSDATE,
	   1,
	   SYSDATE,
	   1,
	   NULL,
	   k,
	   average_table(k),
	   range_table(k),
	   null,
	   null,
           null);

Line: 818

      SELECT A2, D3, D4 INTO A2, D3, D4
      FROM QA_CHART_CONSTANTS
      WHERE SUBGROUP_SIZE = subgrp_size;

Line: 1010

    INSERT INTO QA_CHART_DATA
      (LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_LOGIN,
	SUBGROUP_NUMBER,
	AVERAGE,
        RANGE,
	BAR_NUMBER,
        HIST_RANGE,
        NUM_OCCURRENCES)
    VALUES
       (SYSDATE,
	1,
	SYSDATE,
	1,
	NULL,
	null,
        null,
        null,
	1,
	to_char(minimum) || ' - ' || to_char(boundary(1)),
	occurrences(1));

Line: 1036

      INSERT INTO QA_CHART_DATA
        (LAST_UPDATE_DATE,
	 LAST_UPDATED_BY,
	 CREATION_DATE,
	 CREATED_BY,
	 LAST_UPDATE_LOGIN,
	 SUBGROUP_NUMBER,
	 AVERAGE,
	 RANGE,
	 BAR_NUMBER,
	 HIST_RANGE,
	 NUM_OCCURRENCES)
      VALUES
	(SYSDATE,
	 1,
	 SYSDATE,
	 1,
	 NULL,
	 null,
	 null,
	 null,
	 i,
	 to_char(boundary(i-1)) || ' - ' || to_char(boundary(i)),
	 occurrences(i));

Line: 1083

      OPEN c FOR 'select 1 from (' || p_query_str || ')';