APPS.QA_AUDIT_PKG dependencies on STANDARD

Line 102: g_que_result_columns(qa_ss_const.standard_violated) || ', ' ||

98: ' transaction_number, ' ||
99: ' organization_id, ' ||
100: ' plan_id, ' ||
101: ' txn_header_id, ' ||
102: g_que_result_columns(qa_ss_const.standard_violated) || ', ' ||
103: g_que_result_columns(qa_ss_const.section_violated) || ', ' ||
104: g_que_result_columns(qa_ss_const.audit_area) || ', ' ||
105: g_que_result_columns(qa_ss_const.question_category) || ', ' ||
106: g_que_result_columns(qa_ss_const.question_code) || ', ' ||

Line 124: g_qb_result_columns(qa_ss_const.standard_violated) || ', ' ||

120: ' -1, ' ||
121: ' :2, ' || -- question and response org_id
122: ' :3, ' || -- questions and resp plan_id
123: ' :4, ' || -- x_txn_header_id,
124: g_qb_result_columns(qa_ss_const.standard_violated) || ', ' ||
125: g_qb_result_columns(qa_ss_const.section_violated) || ', ' ||
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) || ', ' ||

Line 169: l_summ_params(i) := p_summary_params(i).standard;

165: end if;
166:
167:
168: FOR i IN p_summary_params.FIRST .. p_summary_params.LAST LOOP
169: l_summ_params(i) := p_summary_params(i).standard;
170: END LOOP;
171: l_perf_key := 'AUDIT_STANDARD';
172: qa_performance_temp_pkg.purge_and_add_names(l_perf_key,l_summ_params);
173:

Line 171: l_perf_key := 'AUDIT_STANDARD';

167:
168: FOR i IN p_summary_params.FIRST .. p_summary_params.LAST LOOP
169: l_summ_params(i) := p_summary_params(i).standard;
170: END LOOP;
171: l_perf_key := 'AUDIT_STANDARD';
172: qa_performance_temp_pkg.purge_and_add_names(l_perf_key,l_summ_params);
173:
174:
175: l_sql_string := common_insert_sql ||

Line 176: ' AND ' || g_qb_result_columns(qa_ss_const.standard_violated) ||

172: qa_performance_temp_pkg.purge_and_add_names(l_perf_key,l_summ_params);
173:
174:
175: l_sql_string := common_insert_sql ||
176: ' AND ' || g_qb_result_columns(qa_ss_const.standard_violated) ||
177: ' IN (SELECT NAME ' ||
178: ' FROM QA_PERFORMANCE_TEMP ' ||
179: ' WHERE KEY = :7) ';
180:

Line 242: ' AND ' || g_qb_result_columns(qa_ss_const.standard_violated) || ' = :7 '||

238:
239: FOR i IN p_cat_summary_params.FIRST .. p_cat_summary_params.LAST LOOP
240:
241: l_sql_string := common_insert_sql ||
242: ' AND ' || g_qb_result_columns(qa_ss_const.standard_violated) || ' = :7 '||
243: ' AND ' || g_qb_result_columns(qa_ss_const.section_violated) || ' = :8 '||
244: ' AND ' || g_qb_result_columns(qa_ss_const.audit_area) || ' = :9 '||
245: ' AND ' || g_qb_result_columns(qa_ss_const.question_category) || ' = :10 ';
246:

Line 253: p_cat_summary_params(i).standard,

249: p_audit_question_plan_id,
250: p_txn_header_id,
251: p_audit_bank_plan_id,
252: p_audit_bank_org_id,
253: p_cat_summary_params(i).standard,
254: p_cat_summary_params(i).section,
255: p_cat_summary_params(i).area,
256: p_cat_summary_params(i).category;
257:

Line 461: -- Standard call to get message count and if count is 1, get message info.

457:
458:
459:
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get
463: (
464: p_count => x_msg_count,
465: p_data => x_msg_data