APPS.QA_SS_LOV_API dependencies on QA_CHARS

Line 171: FUNCTION qa_chars_values_exist (x_char_id IN NUMBER)

167: RAISE;
168: END fetch_qa_plan_chars;
169:
170: --parent-child addition
171: FUNCTION qa_chars_values_exist (x_char_id IN NUMBER)
172: RETURN BOOLEAN IS
173:
174: result BOOLEAN;
175: dummy NUMBER;

Line 179: from qa_chars qc

175: dummy NUMBER;
176:
177: CURSOR c IS
178: select 1
179: from qa_chars qc
180: where qc.char_id = x_char_id
181: AND qc.values_exist_flag = 1;
182: BEGIN
183: OPEN c;

Line 192: END qa_chars_values_exist;

188: RETURN result;
189:
190:
191:
192: END qa_chars_values_exist;
193: ---
194:
195: FUNCTION qpc_values_exist_flag(plan_id IN NUMBER,
196: element_id IN NUMBER) RETURN NUMBER IS

Line 224: RETURN qa_chars_api.sql_validation_string(element_id) IS NOT NULL;

220: RETURN BOOLEAN IS
221:
222: BEGIN
223:
224: RETURN qa_chars_api.sql_validation_string(element_id) IS NOT NULL;
225:
226: END sql_validation_exists;
227:
228:

Line 243: RETURN qa_chars_api.sql_validation_string(element_id);

239:
240: FUNCTION get_sql_validation_string (element_id IN NUMBER)
241: RETURN VARCHAR2 IS
242: BEGIN
243: RETURN qa_chars_api.sql_validation_string(element_id);
244: END get_sql_validation_string;
245:
246:
247: FUNCTION sql_string_exists(x_plan_id IN NUMBER, x_char_id IN NUMBER,

Line 254: IF qa_chars_values_exist(x_char_id) THEN

250:
251: BEGIN
252:
253: IF (x_plan_id = -1) THEN
254: IF qa_chars_values_exist(x_char_id) THEN
255: x_lov_sql := 'SELECT short_code, description
256: FROM qa_char_value_lookups
257: WHERE char_id = :1 ';
258:

Line 276: x_lov_sql := qa_chars_api.format_sql_for_lov(x_lov_sql,

272:
273: ELSIF sql_validation_exists(x_char_id) THEN
274:
275: x_lov_sql := get_sql_validation_string(x_char_id);
276: x_lov_sql := qa_chars_api.format_sql_for_lov(x_lov_sql,
277: org_id, user_id);
278:
279: RETURN TRUE;
280:

Line 294: IF qa_chars_values_exist(p_char_id) THEN

290:
291: BEGIN
292:
293: IF (p_plan_id = -1) THEN
294: IF qa_chars_values_exist(p_char_id) THEN
295:
296: RETURN to_char(p_char_id);
297:
298: END IF;