APPS.QA_SS_RESULTS dependencies on QA_CHARS

Line 210: name qa_chars.prompt%TYPE;

206: p_plan_id IN NUMBER,
207: x_messages OUT NOCOPY VARCHAR2) IS
208:
209: separator CONSTANT VARCHAR2(1) := '@';
210: name qa_chars.prompt%TYPE;
211: code VARCHAR2(2000);
212:
213: -- Bug 5307450
214: -- Cursor to get the message entered by the user for the

Line 284: name qa_chars.prompt%TYPE;

280: plan_id IN NUMBER,
281: messages OUT NOCOPY VARCHAR2) IS
282:
283: separator CONSTANT VARCHAR2(1) := '@';
284: name qa_chars.prompt%TYPE;
285: code VARCHAR2(2000);
286: BEGIN
287:
288: messages := '';

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

445: --
446: PROCEDURE initialize_seq_elements(x_plan_id IN NUMBER,
447: elements IN OUT NOCOPY qa_validation_api.ElementsArray)
448: IS
449: TYPE seq_charid_tab_typ IS TABLE OF qa_chars.char_id%TYPE INDEX BY BINARY_INTEGER;
450: seq_charid_tab seq_charid_tab_typ;
451:
452: def_seq_val VARCHAR2(100);
453: BEGIN

Line 456: FROM qa_chars qc, qa_plan_chars qpc

452: def_seq_val VARCHAR2(100);
453: BEGIN
454: SELECT qc.char_id
455: BULK COLLECT INTO seq_charid_tab
456: FROM qa_chars qc, qa_plan_chars qpc
457: WHERE qpc.plan_id = x_plan_id
458: AND qc.char_id = qpc.char_id
459: AND qc.datatype = 5;
460:

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

1669: loop
1670: If l_results_array(id_ctr).id IS NOT NULL THEN
1671: -- Append the HC element column name to the char id string
1672: charid_str := charid_str ||
1673: qa_chars_api.hardcoded_column(l_results_array(id_ctr).element_id)||
1674: ',';
1675: -- Append the Id value to Normalized id string
1676: id_str := id_str || l_results_array(id_ctr).id||',';
1677: End If;