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.OKC_XPRT_UTIL_PVT dependencies on OKC_QA_ERRORS_T

Line 2211: l_template_rule_status_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2207: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;
2208:
2209: l_qa_tbl_index NUMBER;
2210:
2211: l_template_rule_status_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2212: l_template_rule_status_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2213: l_perf_template_rule_status VARCHAR2(1);
2214:
2215: l_def_template_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 2212: l_template_rule_status_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2208:
2209: l_qa_tbl_index NUMBER;
2210:
2211: l_template_rule_status_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2212: l_template_rule_status_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2213: l_perf_template_rule_status VARCHAR2(1);
2214:
2215: l_def_template_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2216: l_def_template_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 2215: l_def_template_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2211: l_template_rule_status_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2212: l_template_rule_status_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2213: l_perf_template_rule_status VARCHAR2(1);
2214:
2215: l_def_template_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2216: l_def_template_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2217: l_def_template_status VARCHAR2(1);
2218:
2219: l_tmpl_non_active_rule_exists VARCHAR2(1);

Line 2216: l_def_template_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2212: l_template_rule_status_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2213: l_perf_template_rule_status VARCHAR2(1);
2214:
2215: l_def_template_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2216: l_def_template_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2217: l_def_template_status VARCHAR2(1);
2218:
2219: l_tmpl_non_active_rule_exists VARCHAR2(1);
2220:

Line 2221: l_template_no_rule_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2217: l_def_template_status VARCHAR2(1);
2218:
2219: l_tmpl_non_active_rule_exists VARCHAR2(1);
2220:
2221: l_template_no_rule_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2222: l_template_no_rule_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2223: l_perf_template_no_rule VARCHAR2(1);
2224:
2225: l_tmpl_active_rule_exists VARCHAR2(1);

Line 2222: l_template_no_rule_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2218:
2219: l_tmpl_non_active_rule_exists VARCHAR2(1);
2220:
2221: l_template_no_rule_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2222: l_template_no_rule_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2223: l_perf_template_no_rule VARCHAR2(1);
2224:
2225: l_tmpl_active_rule_exists VARCHAR2(1);
2226: l_template_name okc_terms_templates_all.template_name%TYPE;

Line 3191: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3187: l_expert_articles_tbl expert_articles_tbl_type;
3188: l_articles_not_in_cz_tbl expert_articles_tbl_type;
3189:
3190: l_qa_tbl_index NUMBER;
3191: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3192: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3193: l_perform_bv_qa VARCHAR2(1);
3194:
3195: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3192: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3188: l_articles_not_in_cz_tbl expert_articles_tbl_type;
3189:
3190: l_qa_tbl_index NUMBER;
3191: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3192: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3193: l_perform_bv_qa VARCHAR2(1);
3194:
3195: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3196: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3195: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3191: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3192: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3193: l_perform_bv_qa VARCHAR2(1);
3194:
3195: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3196: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3197: l_perf_new_expert_art VARCHAR2(1);
3198:
3199: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3196: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3192: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3193: l_perform_bv_qa VARCHAR2(1);
3194:
3195: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3196: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3197: l_perf_new_expert_art VARCHAR2(1);
3198:
3199: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3200: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3199: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3195: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3196: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3197: l_perf_new_expert_art VARCHAR2(1);
3198:
3199: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3200: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3201: l_perf_old_expert_art VARCHAR2(1);
3202:
3203: --

Line 3200: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3196: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3197: l_perf_new_expert_art VARCHAR2(1);
3198:
3199: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3200: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3201: l_perf_old_expert_art VARCHAR2(1);
3202:
3203: --
3204: -- Cursor to check provision allowed for doc type

Line 6205: FROM okc_qa_errors_t

6201: SELECT title,
6202: problem_short_desc,
6203: problem_details,
6204: suggestion
6205: FROM okc_qa_errors_t
6206: WHERE sequence_id = p_sequence_id
6207: AND error_severity = 'E';
6208:
6209: l_ruleid_tbl OKC_XPRT_QA_PVT.RuleIdList;

Line 9081: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9077: l_cz_cfg_msgs CZ_CF_API.CFG_OUTPUT_PIECES;
9078: l_validation_status NUMBER;
9079:
9080: -- Severity related local variables
9081: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9082: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9083: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9084: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9085: l_perf_expert_not_applied VARCHAR2(1);

Line 9082: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9078: l_validation_status NUMBER;
9079:
9080: -- Severity related local variables
9081: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9082: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9083: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9084: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9085: l_perf_expert_not_applied VARCHAR2(1);
9086:

Line 9083: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9079:
9080: -- Severity related local variables
9081: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9082: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9083: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9084: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9085: l_perf_expert_not_applied VARCHAR2(1);
9086:
9087: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 9084: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

9080: -- Severity related local variables
9081: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9082: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9083: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9084: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9085: l_perf_expert_not_applied VARCHAR2(1);
9086:
9087: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9088: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 9087: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

9083: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9084: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9085: l_perf_expert_not_applied VARCHAR2(1);
9086:
9087: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9088: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9089: l_perf_expert_partially_run VARCHAR2(1);
9090:
9091: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 9088: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9084: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9085: l_perf_expert_not_applied VARCHAR2(1);
9086:
9087: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9088: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9089: l_perf_expert_partially_run VARCHAR2(1);
9090:
9091: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9092: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 9091: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9087: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9088: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9089: l_perf_expert_partially_run VARCHAR2(1);
9090:
9091: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9092: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9093: l_perf_invalid_config VARCHAR2(1);
9094:
9095: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 9092: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

9088: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9089: l_perf_expert_partially_run VARCHAR2(1);
9090:
9091: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9092: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9093: l_perf_invalid_config VARCHAR2(1);
9094:
9095: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9096: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 9095: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9091: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9092: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9093: l_perf_invalid_config VARCHAR2(1);
9094:
9095: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9096: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9097: l_perf_incomplt_config VARCHAR2(1);
9098:
9099: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 9096: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

9092: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9093: l_perf_invalid_config VARCHAR2(1);
9094:
9095: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9096: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9097: l_perf_incomplt_config VARCHAR2(1);
9098:
9099: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9100: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 9099: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9095: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9096: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9097: l_perf_incomplt_config VARCHAR2(1);
9098:
9099: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9100: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9101: l_perf_new_expert_art VARCHAR2(1);
9102:
9103: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 9100: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

9096: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9097: l_perf_incomplt_config VARCHAR2(1);
9098:
9099: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9100: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9101: l_perf_new_expert_art VARCHAR2(1);
9102:
9103: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9104: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 9103: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

9099: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9100: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9101: l_perf_new_expert_art VARCHAR2(1);
9102:
9103: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9104: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9105: l_perf_old_expert_art VARCHAR2(1);
9106:
9107: --Start - Added by kartik dummy variable

Line 9104: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

9100: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9101: l_perf_new_expert_art VARCHAR2(1);
9102:
9103: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
9104: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
9105: l_perf_old_expert_art VARCHAR2(1);
9106:
9107: --Start - Added by kartik dummy variable
9108: l_count_articles_dropped NUMBER;