DBA Data[Home] [Help]

APPS.QLTCONTB dependencies on QA_CHART_DATA

Line 137: -- want to populate qa_chart_data with latest data

133: END LOOP; -- while loop
134:
135:
136: IF (NOT compute_new_limits) THEN
137: -- want to populate qa_chart_data with latest data
138: FOR j IN 1..num_subgroups LOOP
139: INSERT INTO QA_CHART_DATA
140: (LAST_UPDATE_DATE,
141: LAST_UPDATED_BY,

Line 139: INSERT INTO QA_CHART_DATA

135:
136: IF (NOT compute_new_limits) THEN
137: -- want to populate qa_chart_data with latest data
138: FOR j IN 1..num_subgroups LOOP
139: INSERT INTO QA_CHART_DATA
140: (LAST_UPDATE_DATE,
141: LAST_UPDATED_BY,
142: CREATION_DATE,
143: CREATED_BY,

Line 312: -- want to populate qa_chart_data with latest data

308:
309: END LOOP; -- while loop
310:
311: IF (NOT compute_new_limits) THEN
312: -- want to populate qa_chart_data with latest data
313: FOR j IN 1..num_subgroups LOOP
314: INSERT INTO QA_CHART_DATA
315: (LAST_UPDATE_DATE,
316: LAST_UPDATED_BY,

Line 314: INSERT INTO QA_CHART_DATA

310:
311: IF (NOT compute_new_limits) THEN
312: -- want to populate qa_chart_data with latest data
313: FOR j IN 1..num_subgroups LOOP
314: INSERT INTO QA_CHART_DATA
315: (LAST_UPDATE_DATE,
316: LAST_UPDATED_BY,
317: CREATION_DATE,
318: CREATED_BY,

Line 530: -- want to populate qa_chart_data with latest data

526:
527: END IF;
528:
529: IF (NOT compute_new_limits) THEN
530: -- want to populate qa_chart_data with latest data
531: FOR k IN first_x_point..rows_retrieved LOOP
532:
533: INSERT INTO QA_CHART_DATA
534: (LAST_UPDATE_DATE,

Line 533: INSERT INTO QA_CHART_DATA

529: IF (NOT compute_new_limits) THEN
530: -- want to populate qa_chart_data with latest data
531: FOR k IN first_x_point..rows_retrieved LOOP
532:
533: INSERT INTO QA_CHART_DATA
534: (LAST_UPDATE_DATE,
535: LAST_UPDATED_BY,
536: CREATION_DATE,
537: CREATED_BY,

Line 773: -- want to populate qa_chart_data with latest data

769:
770: END IF;
771:
772: IF (NOT compute_new_limits) THEN
773: -- want to populate qa_chart_data with latest data
774: FOR k IN first_point..rows_retrieved LOOP
775:
776: INSERT INTO QA_CHART_DATA
777: (LAST_UPDATE_DATE,

Line 776: INSERT INTO QA_CHART_DATA

772: IF (NOT compute_new_limits) THEN
773: -- want to populate qa_chart_data with latest data
774: FOR k IN first_point..rows_retrieved LOOP
775:
776: INSERT INTO QA_CHART_DATA
777: (LAST_UPDATE_DATE,
778: LAST_UPDATED_BY,
779: CREATION_DATE,
780: CREATED_BY,

Line 1010: INSERT INTO QA_CHART_DATA

1006: END IF;
1007:
1008: -- insert the first point. has to be treated a bit differently because
1009: -- of the lower boundary
1010: INSERT INTO QA_CHART_DATA
1011: (LAST_UPDATE_DATE,
1012: LAST_UPDATED_BY,
1013: CREATION_DATE,
1014: CREATED_BY,

Line 1036: INSERT INTO QA_CHART_DATA

1032: to_char(minimum) || ' - ' || to_char(boundary(1)),
1033: occurrences(1));
1034:
1035: FOR i IN 2..num_bars LOOP
1036: INSERT INTO QA_CHART_DATA
1037: (LAST_UPDATE_DATE,
1038: LAST_UPDATED_BY,
1039: CREATION_DATE,
1040: CREATED_BY,