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 2209: l_template_rule_status_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

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

Line 2210: l_template_rule_status_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

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

Line 2213: l_def_template_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

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

Line 2214: l_def_template_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

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

Line 2219: l_template_no_rule_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

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

Line 2220: l_template_no_rule_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

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

Line 3189: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

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

Line 3190: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

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

Line 3193: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

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

Line 3194: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

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

Line 3197: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

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

Line 3198: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

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

Line 6007: FROM okc_qa_errors_t

6003: SELECT title,
6004: problem_short_desc,
6005: problem_details,
6006: suggestion
6007: FROM okc_qa_errors_t
6008: WHERE sequence_id = p_sequence_id
6009: AND error_severity = 'E';
6010:
6011: l_ruleid_tbl OKC_XPRT_QA_PVT.RuleIdList;

Line 8754: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8750: l_cz_cfg_msgs CZ_CF_API.CFG_OUTPUT_PIECES;
8751: l_validation_status NUMBER;
8752:
8753: -- Severity related local variables
8754: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8755: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8756: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8757: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8758: l_perf_expert_not_applied VARCHAR2(1);

Line 8755: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8751: l_validation_status NUMBER;
8752:
8753: -- Severity related local variables
8754: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8755: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8756: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8757: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8758: l_perf_expert_not_applied VARCHAR2(1);
8759:

Line 8756: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8752:
8753: -- Severity related local variables
8754: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8755: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8756: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8757: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8758: l_perf_expert_not_applied VARCHAR2(1);
8759:
8760: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 8757: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

8753: -- Severity related local variables
8754: l_expert_not_applied_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8755: l_expert_not_applied_sev_e OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8756: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8757: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8758: l_perf_expert_not_applied VARCHAR2(1);
8759:
8760: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8761: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 8760: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

8756: l_expert_not_applied_sev_w OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8757: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8758: l_perf_expert_not_applied VARCHAR2(1);
8759:
8760: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8761: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8762: l_perf_expert_partially_run VARCHAR2(1);
8763:
8764: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 8761: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8757: l_expert_not_applied_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8758: l_perf_expert_not_applied VARCHAR2(1);
8759:
8760: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8761: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8762: l_perf_expert_partially_run VARCHAR2(1);
8763:
8764: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8765: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 8764: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8760: l_expert_partially_run_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8761: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8762: l_perf_expert_partially_run VARCHAR2(1);
8763:
8764: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8765: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8766: l_perf_invalid_config VARCHAR2(1);
8767:
8768: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 8765: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

8761: l_expert_partially_run_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8762: l_perf_expert_partially_run VARCHAR2(1);
8763:
8764: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8765: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8766: l_perf_invalid_config VARCHAR2(1);
8767:
8768: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8769: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 8768: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8764: l_invalid_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8765: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8766: l_perf_invalid_config VARCHAR2(1);
8767:
8768: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8769: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8770: l_perf_incomplt_config VARCHAR2(1);
8771:
8772: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 8769: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

8765: l_invalid_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8766: l_perf_invalid_config VARCHAR2(1);
8767:
8768: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8769: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8770: l_perf_incomplt_config VARCHAR2(1);
8771:
8772: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8773: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 8772: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8768: l_incomplt_config_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8769: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8770: l_perf_incomplt_config VARCHAR2(1);
8771:
8772: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8773: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8774: l_perf_new_expert_art VARCHAR2(1);
8775:
8776: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 8773: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

8769: l_incomplt_config_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8770: l_perf_incomplt_config VARCHAR2(1);
8771:
8772: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8773: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8774: l_perf_new_expert_art VARCHAR2(1);
8775:
8776: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8777: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 8776: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

8772: l_new_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8773: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8774: l_perf_new_expert_art VARCHAR2(1);
8775:
8776: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8777: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8778: l_perf_old_expert_art VARCHAR2(1);
8779:
8780: --Start - Added by kartik dummy variable

Line 8777: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

8773: l_new_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8774: l_perf_new_expert_art VARCHAR2(1);
8775:
8776: l_old_expert_article_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
8777: l_old_expert_article_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
8778: l_perf_old_expert_art VARCHAR2(1);
8779:
8780: --Start - Added by kartik dummy variable
8781: l_count_articles_dropped NUMBER;