eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_AUDIT_PKG dependencies on QA_SS_CONST

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 103: g_que_result_columns(qa_ss_const.section_violated) || ', ' ||

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) || ', ' ||
107: g_que_result_columns(qa_ss_const.audit_question) || ') ' ||

Line 104: g_que_result_columns(qa_ss_const.audit_area) || ', ' ||

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) || ', ' ||
107: g_que_result_columns(qa_ss_const.audit_question) || ') ' ||
108: ' SELECT :1, ' ||

Line 105: g_que_result_columns(qa_ss_const.question_category) || ', ' ||

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) || ', ' ||
107: g_que_result_columns(qa_ss_const.audit_question) || ') ' ||
108: ' SELECT :1, ' ||
109: ' QA_OCCURRENCE_S.NEXTVAL, ' ||

Line 106: g_que_result_columns(qa_ss_const.question_code) || ', ' ||

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) || ', ' ||
107: g_que_result_columns(qa_ss_const.audit_question) || ') ' ||
108: ' SELECT :1, ' ||
109: ' QA_OCCURRENCE_S.NEXTVAL, ' ||
110: ' sysdate, ' ||

Line 107: g_que_result_columns(qa_ss_const.audit_question) || ') ' ||

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) || ', ' ||
107: g_que_result_columns(qa_ss_const.audit_question) || ') ' ||
108: ' SELECT :1, ' ||
109: ' QA_OCCURRENCE_S.NEXTVAL, ' ||
110: ' sysdate, ' ||
111: ' sysdate, ' ||

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 125: g_qb_result_columns(qa_ss_const.section_violated) || ', ' ||

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) || ', ' ||
129: g_qb_result_columns(qa_ss_const.audit_question) || ' ' ||

Line 126: g_qb_result_columns(qa_ss_const.audit_area) || ', ' ||

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) || ', ' ||
129: g_qb_result_columns(qa_ss_const.audit_question) || ' ' ||
130: ' FROM QA_RESULTS QR ' ||

Line 127: g_qb_result_columns(qa_ss_const.question_category) || ', ' ||

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) || ', ' ||
129: g_qb_result_columns(qa_ss_const.audit_question) || ' ' ||
130: ' FROM QA_RESULTS QR ' ||
131: ' WHERE QR.PLAN_ID = :5 ' ||-- qb_plan_id

Line 128: g_qb_result_columns(qa_ss_const.question_code) || ', ' ||

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) || ', ' ||
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

Line 129: g_qb_result_columns(qa_ss_const.audit_question) || ' ' ||

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) || ', ' ||
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:

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 243: ' AND ' || g_qb_result_columns(qa_ss_const.section_violated) || ' = :8 '||

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:
247: EXECUTE IMMEDIATE l_sql_string USING p_collection_id,

Line 244: ' AND ' || g_qb_result_columns(qa_ss_const.audit_area) || ' = :9 '||

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:
247: EXECUTE IMMEDIATE l_sql_string USING p_collection_id,
248: p_audit_question_org_id,

Line 245: ' AND ' || g_qb_result_columns(qa_ss_const.question_category) || ' = :10 ';

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:
247: EXECUTE IMMEDIATE l_sql_string USING p_collection_id,
248: p_audit_question_org_id,
249: p_audit_question_plan_id,