APPS.QA_SS_RESULTS dependencies on QA_CHARS

Line 263: name qa_chars.prompt%TYPE;

259: p_plan_id IN NUMBER,
260: x_messages OUT NOCOPY VARCHAR2) IS
261:
262: separator CONSTANT VARCHAR2(1) := '@';
263: name qa_chars.prompt%TYPE;
264: code VARCHAR2(2000);
265:
266: -- Bug 5307450
267: -- Cursor to get the message entered by the user for the

Line 337: name qa_chars.prompt%TYPE;

333: plan_id IN NUMBER,
334: messages OUT NOCOPY VARCHAR2) IS
335:
336: separator CONSTANT VARCHAR2(1) := '@';
337: name qa_chars.prompt%TYPE;
338: code VARCHAR2(2000);
339: BEGIN
340:
341: messages := '';

Line 502: TYPE seq_charid_tab_typ IS TABLE OF qa_chars.char_id%TYPE INDEX BY BINARY_INTEGER;

498: --
499: PROCEDURE initialize_seq_elements(x_plan_id IN NUMBER,
500: elements IN OUT NOCOPY qa_validation_api.ElementsArray)
501: IS
502: TYPE seq_charid_tab_typ IS TABLE OF qa_chars.char_id%TYPE INDEX BY BINARY_INTEGER;
503: seq_charid_tab seq_charid_tab_typ;
504:
505: def_seq_val VARCHAR2(100);
506: BEGIN

Line 509: FROM qa_chars qc, qa_plan_chars qpc

505: def_seq_val VARCHAR2(100);
506: BEGIN
507: SELECT qc.char_id
508: BULK COLLECT INTO seq_charid_tab
509: FROM qa_chars qc, qa_plan_chars qpc
510: WHERE qpc.plan_id = x_plan_id
511: AND qc.char_id = qpc.char_id
512: AND qc.datatype = 5;
513:

Line 1742: qa_chars_api.hardcoded_column(l_results_array(id_ctr).element_id)||

1738: loop
1739: If l_results_array(id_ctr).id IS NOT NULL THEN
1740: -- Append the HC element column name to the char id string
1741: charid_str := charid_str ||
1742: qa_chars_api.hardcoded_column(l_results_array(id_ctr).element_id)||
1743: ',';
1744: -- Append the Id value to Normalized id string
1745: id_str := id_str || l_results_array(id_ctr).id||',';
1746: End If;