APPS.QLTTRAWB dependencies on QA_PLAN_CHARS

Line 3225: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri

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;

Line 5615: FROM QA_CHARS QC, QA_PLAN_CHARS_V QPCV

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;

Line 5644: -- definition of qa_plan_chars_v which was used before this fix.

5640: --
5641:
5642: -- Just added the nvl condition for decimal_precision column.
5643: -- This was done to have the select statement similar to the
5644: -- definition of qa_plan_chars_v which was used before this fix.
5645: -- Bug 4254876.suramasw
5646:
5647: SELECT
5648: qpc.char_id,

Line 5675: qa_plan_chars qpc

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;
5679:

Line 7761: FROM QA_PLAN_CHARS QPC, qa_chars qc

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;

Line 7879: FROM qa_plan_chars

7875: -- bug 12739071
7876: --
7877: CURSOR sc_elements_cur IS
7878: SELECT result_column_name
7879: FROM qa_plan_chars
7880: WHERE plan_id = (SELECT plan_id from qa_results_interface
7881: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID)
7882: AND (result_column_name like 'CHARACTER%' OR
7883: result_column_name like 'COMMENT%');

Line 7885: TYPE sc_elements_tab_typ IS TABLE OF qa_plan_chars.result_column_name%TYPE INDEX BY BINARY_INTEGER;

7881: WHERE TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID)
7882: AND (result_column_name like 'CHARACTER%' OR
7883: result_column_name like 'COMMENT%');
7884:
7885: TYPE sc_elements_tab_typ IS TABLE OF qa_plan_chars.result_column_name%TYPE INDEX BY BINARY_INTEGER;
7886: sc_elements_tab sc_elements_tab_typ;
7887:
7888: null_num number := fnd_api.G_NULL_NUM;
7889: null_char varchar2(1) := fnd_api.G_NULL_char;

Line 7995: FROM QA_PLAN_CHARS QPC,

7991:
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;

Line 8307: qa_plan_chars qpc

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;
8311:

Line 8476: FROM QA_PLAN_CHARS

8472:
8473: I := 0;
8474: -- Bug 4958776. SQL Repository Fix SQL ID: 15009245
8475: FOR CHARREC IN (SELECT RESULT_COLUMN_NAME
8476: FROM QA_PLAN_CHARS
8477: WHERE PLAN_ID = X_PLAN_ID) LOOP
8478: I := I + 1;
8479: RESULT_COLUMN_NAME_TABLE(I) := CHARREC.RESULT_COLUMN_NAME;
8480: END LOOP;