APPS.QA_PLANS_PUB dependencies on QA_RESULTS

Line 2200: 'SELECT 1 FROM qa_results WHERE plan_id = :id AND rownum = 1 AND ' ||

2196: RETURN true;
2197: END IF;
2198:
2199: l_sql_statement :=
2200: 'SELECT 1 FROM qa_results WHERE plan_id = :id AND rownum = 1 AND ' ||
2201: l_result_column_name || ' IS NOT NULL';
2202:
2203: OPEN c FOR l_sql_statement USING p_plan_id;
2204: FETCH c INTO l_dummy;

Line 2219: FROM qa_results

2215: TYPE numType IS REF CURSOR;
2216:
2217: CURSOR c IS
2218: SELECT 1
2219: FROM qa_results
2220: WHERE plan_id = p_plan_id AND rownum = 1;
2221:
2222: l_dummy NUMBER;
2223: l_found BOOLEAN;

Line 3319: fnd_message.set_name('QA', 'QA_RESULTS_EXIST_FOR_PLANCHAR');

3315: RAISE fnd_api.g_exc_error;
3316: END IF;
3317:
3318: IF results_exist(l_plan_id, l_element_id) THEN
3319: fnd_message.set_name('QA', 'QA_RESULTS_EXIST_FOR_PLANCHAR');
3320: fnd_msg_pub.add();
3321: RAISE fnd_api.g_exc_error;
3322: END IF;
3323: