[Home] [Help]
234:
235: BEGIN
236: qa_core_pkg.dsql_add_text('(');
237: qa_core_pkg.dsql_add_text(' SELECT 1 ' ||
238: ' FROM QA_SPEC_CHARS_V QSC, QA_CHARS QC ' ||
239: ' WHERE QSC.CHAR_ID (+) = QC.CHAR_ID ' ||
240: ' AND QC.CHAR_ID = ');
241:
242: qa_core_pkg.dsql_add_bind(X_CHAR_ID);
3221: p_col_name IN VARCHAR2) RETURN VARCHAR2 IS
3222:
3223: CURSOR c IS
3224: SELECT name
3225: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri
3226: WHERE qc.char_id = qpc.char_id
3227: AND qpc.plan_id = qri.plan_id
3228: AND qpc.result_column_name = p_col_name
3229: AND qri.group_id = p_group_id;
3596: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))
3597: AND NOT EXISTS ' ||
3598: '(SELECT ''X'' ' ||
3599: 'FROM QA_SPEC_CHARS_V QSC, ' ||
3600: 'QA_CHARS QC ' ||
3601: 'WHERE ((QRI.' || COL_NAME || ' IS NULL) ' ||
3602: 'OR (((DECODE(QSC.CHAR_ID, NULL, ' ||
3603: 'QC.LOWER_REASONABLE_LIMIT, ' ||
3604: 'QSC.LOWER_REASONABLE_LIMIT) IS NULL) ' ||
4554: -- Element Name which is the collection element name.This was done because
4555: -- nearly 25 softcoded elements have the Developer_Name different from the
4556: -- collection element name and this causes the issue reported in bug 3860762.
4557: -- Changing the Developer_Name column of all those collection elements in
4558: -- qa_chars would resolve the issue,but this is the easy and efficient way.
4559: -- Commented out the existing code.
4560: -- Bug 3860762.suramasw.
4561:
4562: /*
5611: QPCV.RESULT_COLUMN_NAME, QPCV.ENABLED_FLAG,
5612: QPCV.MANDATORY_FLAG, QC.DATATYPE, QPCV.DECIMAL_PRECISION,
5613: QC.SQL_VALIDATION_STRING, QPCV.VALUES_EXIST_FLAG,
5614: UPPER(REPLACE(QC.NAME, ' ', '_')) CHAR_NAME, READ_ONLY_FLAG
5615: FROM QA_CHARS QC, QA_PLAN_CHARS_V QPCV
5616: WHERE QPCV.PLAN_ID = X_PLAN_ID
5617: AND QPCV.CHAR_ID = QC.CHAR_ID) LOOP
5618: I := I + 1;
5619: CHAR_ID_TABLE(I) := CHARREC.CHAR_ID;
5670: sql_validation_string_table,
5671: values_exist_flag_table,
5672: read_only_flag_table
5673: FROM
5674: qa_chars qc,
5675: qa_plan_chars qpc
5676: WHERE
5677: qpc.plan_id = x_plan_id AND
5678: qpc.char_id = qc.char_id;
7757:
7758: -- Bug 4958776. SQL Repository Fix SQL ID: 15009199
7759: -- replacing view with base tables
7760: FOR RESREC IN (SELECT QPC.CHAR_ID, QPC.RESULT_COLUMN_NAME, QC.DATATYPE
7761: FROM QA_PLAN_CHARS QPC, qa_chars qc
7762: WHERE QPC.PLAN_ID = X_PLAN_ID
7763: AND QC.CHAR_ID = QPC.CHAR_ID ) LOOP
7764: NUM_COLS := NUM_COLS + 1;
7765: RESULT_COLUMN_ID_TABLE(NUM_COLS) := RESREC.CHAR_ID;
7992: -- End of changes for bug 2548710.
7993:
7994: FOR COLUMN_NAMES_REC IN (SELECT QPC.RESULT_COLUMN_NAME
7995: FROM QA_PLAN_CHARS QPC,
7996: QA_CHARS QC
7997: WHERE QPC.PLAN_ID = X_PLAN_ID
7998: AND QPC.CHAR_ID = QC.CHAR_ID) LOOP
7999: I := I + 1;
8000: COLUMNS_TABLE(I) := COLUMN_NAMES_REC.RESULT_COLUMN_NAME;
8302: sql_validation_string_table,
8303: values_exist_flag_table,
8304: read_only_flag_table
8305: FROM
8306: qa_chars qc,
8307: qa_plan_chars qpc
8308: WHERE
8309: qpc.plan_id = x_plan_id AND
8310: qpc.char_id = qc.char_id;