APPS.QLTVCREB dependencies on QA_CHARS

Line 238: -- FROM qa_chars qc

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

Line 251: l_element_name qa_chars.name%TYPE;

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

Line 252: l_element_hardcoded_column qa_chars.hardcoded_column%TYPE;

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

Line 272: FROM qa_chars qc

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

Line 297: FROM qa_plan_chars qpc, qa_chars qc

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

Line 402: FROM qa_chars

398:
399: SELECT char_id, name, hardcoded_column, datatype
400: INTO l_element_id, l_element_name, l_element_hardcoded_column,
401: l_element_datatype
402: FROM qa_chars
403: WHERE char_id = current_element;
404:
405: -- There are several conditions.
406:

Line 712: FROM qa_chars qc,

708: qc.FK_MEANING,
709: qc.FK_DESCRIPTION,
710: qc.FK_ADD_WHERE,
711: qc.DATATYPE
712: FROM qa_chars qc,
713: qa_plan_chars qpc
714: WHERE qc.char_id = qpc.char_id
715: AND qpc.plan_id = x_plan_id
716: ORDER BY qpc.prompt_sequence;

Line 942: FROM qa_chars qc,

938: qc.FK_MEANING,
939: qc.FK_DESCRIPTION,
940: qc.FK_ADD_WHERE,
941: qc.DATATYPE
942: FROM qa_chars qc,
943: qa_plan_chars qpc
944: WHERE qc.char_id = qpc.char_id
945: AND qpc.plan_id = x_plan_id
946: ORDER BY qpc.prompt_sequence;

Line 1291: FROM qa_plan_chars qpc, qa_chars qc

1287: SELECT qpc.result_column_name,
1288: upper(translate(qc.name,' ''*{}','_____')) name,
1289: qc.hardcoded_column,
1290: qc.developer_name
1291: FROM qa_plan_chars qpc, qa_chars qc
1292: WHERE qpc.char_id = qc.char_id AND qpc.plan_id = x_plan_id
1293: ORDER BY prompt_sequence;
1294:
1295: --