[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);
3099: p_col_name IN VARCHAR2) RETURN VARCHAR2 IS
3100:
3101: CURSOR c IS
3102: SELECT name
3103: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri
3104: WHERE qc.char_id = qpc.char_id
3105: AND qpc.plan_id = qri.plan_id
3106: AND qpc.result_column_name = p_col_name
3107: AND qri.group_id = p_group_id;
3448: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))
3449: AND NOT EXISTS ' ||
3450: '(SELECT ''X'' ' ||
3451: 'FROM QA_SPEC_CHARS_V QSC, ' ||
3452: 'QA_CHARS QC ' ||
3453: 'WHERE ((QRI.' || COL_NAME || ' IS NULL) ' ||
3454: 'OR (((DECODE(QSC.CHAR_ID, NULL, ' ||
3455: 'QC.LOWER_REASONABLE_LIMIT, ' ||
3456: 'QSC.LOWER_REASONABLE_LIMIT) IS NULL) ' ||
4264: -- Element Name which is the collection element name.This was done because
4265: -- nearly 25 softcoded elements have the Developer_Name different from the
4266: -- collection element name and this causes the issue reported in bug 3860762.
4267: -- Changing the Developer_Name column of all those collection elements in
4268: -- qa_chars would resolve the issue,but this is the easy and efficient way.
4269: -- Commented out the existing code.
4270: -- Bug 3860762.suramasw.
4271:
4272: /*
5252: QPCV.RESULT_COLUMN_NAME, QPCV.ENABLED_FLAG,
5253: QPCV.MANDATORY_FLAG, QC.DATATYPE, QPCV.DECIMAL_PRECISION,
5254: QC.SQL_VALIDATION_STRING, QPCV.VALUES_EXIST_FLAG,
5255: UPPER(REPLACE(QC.NAME, ' ', '_')) CHAR_NAME, READ_ONLY_FLAG
5256: FROM QA_CHARS QC, QA_PLAN_CHARS_V QPCV
5257: WHERE QPCV.PLAN_ID = X_PLAN_ID
5258: AND QPCV.CHAR_ID = QC.CHAR_ID) LOOP
5259: I := I + 1;
5260: CHAR_ID_TABLE(I) := CHARREC.CHAR_ID;
5311: sql_validation_string_table,
5312: values_exist_flag_table,
5313: read_only_flag_table
5314: FROM
5315: qa_chars qc,
5316: qa_plan_chars qpc
5317: WHERE
5318: qpc.plan_id = x_plan_id AND
5319: qpc.char_id = qc.char_id;
7307:
7308: -- Bug 4958776. SQL Repository Fix SQL ID: 15009199
7309: -- replacing view with base tables
7310: FOR RESREC IN (SELECT QPC.CHAR_ID, QPC.RESULT_COLUMN_NAME, QC.DATATYPE
7311: FROM QA_PLAN_CHARS QPC, qa_chars qc
7312: WHERE QPC.PLAN_ID = X_PLAN_ID
7313: AND QC.CHAR_ID = QPC.CHAR_ID ) LOOP
7314: NUM_COLS := NUM_COLS + 1;
7315: RESULT_COLUMN_ID_TABLE(NUM_COLS) := RESREC.CHAR_ID;
7520: -- End of changes for bug 2548710.
7521:
7522: FOR COLUMN_NAMES_REC IN (SELECT QPC.RESULT_COLUMN_NAME
7523: FROM QA_PLAN_CHARS QPC,
7524: QA_CHARS QC
7525: WHERE QPC.PLAN_ID = X_PLAN_ID
7526: AND QPC.CHAR_ID = QC.CHAR_ID) LOOP
7527: I := I + 1;
7528: COLUMNS_TABLE(I) := COLUMN_NAMES_REC.RESULT_COLUMN_NAME;
7786: sql_validation_string_table,
7787: values_exist_flag_table,
7788: read_only_flag_table
7789: FROM
7790: qa_chars qc,
7791: qa_plan_chars qpc
7792: WHERE
7793: qpc.plan_id = x_plan_id AND
7794: qpc.char_id = qc.char_id;