APPS.QLTVCREB dependencies on QA_CHARS

Line 236: -- FROM qa_chars qc

232: -- bso Tue Jan 31 14:57:53 PST 2006
233: --
234: -- CURSOR elements_cursor IS
235: -- SELECT qc.char_id, qc.name, qc.hardcoded_column, qc.datatype
236: -- FROM qa_chars qc
237: -- WHERE qc.enabled_flag = 1 and
238: -- rownum < (max_columns - fixed_columns)
239: -- ORDER BY qc.hardcoded_column, qc.name;
240: --

Line 249: l_element_name qa_chars.name%TYPE;

245: -- element_hardcoded_columns dbms_sql.varchar2s;
246: -- element_datatypes dbms_sql.number_table;
247: --
248: l_element_id NUMBER;
249: l_element_name qa_chars.name%TYPE;
250: l_element_hardcoded_column qa_chars.hardcoded_column%TYPE;
251: l_element_datatype NUMBER;
252:
253: --

Line 250: l_element_hardcoded_column qa_chars.hardcoded_column%TYPE;

246: -- element_datatypes dbms_sql.number_table;
247: --
248: l_element_id NUMBER;
249: l_element_name qa_chars.name%TYPE;
250: l_element_hardcoded_column qa_chars.hardcoded_column%TYPE;
251: l_element_datatype NUMBER;
252:
253: --
254: -- This cursor is used to fetch foreign key info for hardcoded,

Line 270: FROM qa_chars qc

266: qc.fk_id3,
267: qc.fk_meaning,
268: qc.fk_description,
269: qc.fk_add_where
270: FROM qa_chars qc
271: WHERE qc.char_id = x;
272:
273: fk fk_cursor%ROWTYPE;
274:

Line 295: FROM qa_plan_chars qpc, qa_chars qc

291: decode(qc.hardcoded_column, null, qpc.plan_id, 0) plan_id,
292: upper(qpc.result_column_name) result_column_name,
293: qc.name,
294: qc.hardcoded_column
295: FROM qa_plan_chars qpc, qa_chars qc
296: WHERE qc.char_id = qpc.char_id AND
297: qpc.enabled_flag = 1 AND
298: qc.enabled_flag = 1
299: ORDER BY qc.hardcoded_column, qc.name;

Line 396: FROM qa_chars

392:
393: SELECT char_id, name, hardcoded_column, datatype
394: INTO l_element_id, l_element_name, l_element_hardcoded_column,
395: l_element_datatype
396: FROM qa_chars
397: WHERE char_id = current_element;
398:
399: -- There are several conditions.
400:

Line 688: FROM qa_chars qc,

684: qc.FK_MEANING,
685: qc.FK_DESCRIPTION,
686: qc.FK_ADD_WHERE,
687: qc.DATATYPE
688: FROM qa_chars qc,
689: qa_plan_chars qpc
690: WHERE qc.char_id = qpc.char_id
691: AND qpc.plan_id = x_plan_id
692: ORDER BY qpc.prompt_sequence;

Line 1006: FROM qa_plan_chars qpc, qa_chars qc

1002: SELECT qpc.result_column_name,
1003: upper(translate(qc.name,' ''*{}','_____')) name,
1004: qc.hardcoded_column,
1005: qc.developer_name
1006: FROM qa_plan_chars qpc, qa_chars qc
1007: WHERE qpc.char_id = qc.char_id AND qpc.plan_id = x_plan_id
1008: ORDER BY prompt_sequence;
1009:
1010: --