APPS.QA_AUDIT_PKG dependencies on QA_RESULTS

Line 86: l_sql_string := 'INSERT INTO qa_results ( collection_id, ' ||

82:
83: l_sql_string VARCHAR2(1000);
84:
85: BEGIN
86: l_sql_string := 'INSERT INTO qa_results ( collection_id, ' ||
87: ' occurrence, ' ||
88: ' last_update_date, ' ||
89: ' qa_last_update_date, '||
90: ' last_updated_by, ' ||

Line 130: ' FROM QA_RESULTS QR ' ||

126: g_qb_result_columns(qa_ss_const.audit_area) || ', ' ||
127: g_qb_result_columns(qa_ss_const.question_category) || ', ' ||
128: g_qb_result_columns(qa_ss_const.question_code) || ', ' ||
129: g_qb_result_columns(qa_ss_const.audit_question) || ' ' ||
130: ' FROM QA_RESULTS QR ' ||
131: ' WHERE QR.PLAN_ID = :5 ' ||-- qb_plan_id
132: ' AND QR.ORGANIZATION_ID = :6 '; -- qb_org_id
133:
134:

Line 296: FROM qa_results qr, qa_pc_plan_relationship qppr

292: CURSOR C(x_id NUMBER, x_org_id NUMBER, x_audit_num VARCHAR2) IS
293: SELECT qr.plan_id,
294: qr.collection_id,
295: qr.occurrence
296: FROM qa_results qr, qa_pc_plan_relationship qppr
297: WHERE qr.plan_id = qppr.parent_plan_id
298: AND qppr.child_plan_id = x_id
299: AND qr.organization_id = x_org_id
300: AND (qr.status = 2 OR qr.status IS NULL)

Line 317: FROM QA_RESULTS

313: p_collection_id NUMBER) RETURN NUMBER IS
314:
315: CURSOR C IS
316: SELECT count(OCCURRENCE)
317: FROM QA_RESULTS
318: WHERE plan_id = p_audit_que_plan_id
319: AND collection_id = p_collection_id;
320:
321: l_rows NUMBER;

Line 371: p_function_name => 'QA_RESULTS_ENTER',

367:
368: -- (1) verify whether user has create privillege on audit questions plan
369:
370: l_ret_status := qa_web_txn_api.allowed_for_plan (
371: p_function_name => 'QA_RESULTS_ENTER',
372: p_plan_id => p_audit_question_plan_id);
373:
374: if(l_ret_status = 'F') then
375: x_return_status := FND_API.G_RET_STS_ERROR;