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_TERMS_QA_PVT dependencies on OKC_QA_ERRORS_T

Line 218: title OKC_QA_ERRORS_T.title%TYPE,

214: article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE,
215: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE,
216: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE,
217: scn_id OKC_K_ARTICLES_B.scn_id%TYPE,
218: title OKC_QA_ERRORS_T.title%TYPE,
219: std_art_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE
220: );
221:
222: /* expert commented out

Line 227: title OKC_QA_ERRORS_T.title%TYPE,

223: -- new type to store xprt clause details
224: TYPE xprt_article_rec_type IS RECORD (
225: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
226: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
227: title OKC_QA_ERRORS_T.title%TYPE,
228: rule_id OKC_XPRT_CLAUSES_V.rule_id%TYPE,
229: rule_name OKC_XPRT_CLAUSES_V.rule_name%TYPE
230: );
231: */

Line 238: heading OKC_QA_ERRORS_T.section_name%TYPE,

234: id OKC_SECTIONS_B.ID%TYPE,
235: amendment_operation_code OKC_SECTIONS_B.amendment_operation_code%TYPE,
236: amendment_description OKC_SECTIONS_B.amendment_description%TYPE,
237: scn_id OKC_SECTIONS_B.scn_id%TYPE,
238: heading OKC_QA_ERRORS_T.section_name%TYPE,
239: scn_code OKC_SECTIONS_B.scn_code%TYPE
240: );
241:
242: TYPE qa_detail_type IS RECORD (

Line 273: --<<<<<<<<<<<<<<<<<< INTERNAL Simple API PROCEDURES for OKC_QA_ERRORS_T <<<<<<<<<<<<<<<<<<

269:
270: /* expert commented out
271: l_xprt_article_tbl xprt_article_tbl_type;
272: */
273: --<<<<<<<<<<<<<<<<<< INTERNAL Simple API PROCEDURES for OKC_QA_ERRORS_T <<<<<<<<<<<<<<<<<<
274:
275: ---------------------------------------------------------------------------
276: -- FUNCTION do_validation
277: ---------------------------------------------------------------------------

Line 317: SELECT OKC_QA_ERRORS_T_S.NEXTVAL FROM DUAL;

313: IS
314:
315: l_api_name CONSTANT VARCHAR2(30) := 'get_seq_id';
316: CURSOR l_seq_csr IS
317: SELECT OKC_QA_ERRORS_T_S.NEXTVAL FROM DUAL;
318:
319: BEGIN
320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered get_seq_id');

Line 355: -- PROCEDURE insert_row for:OKC_QA_ERRORS_T --

351:
352: END get_seq_id;
353:
354: ------------------------------------------------
355: -- PROCEDURE insert_row for:OKC_QA_ERRORS_T --
356: ------------------------------------------------
357: FUNCTION insert_row(
358: p_document_type IN VARCHAR2,
359: p_document_id IN NUMBER,

Line 391: INSERT INTO OKC_QA_ERRORS_T

387: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Insert_Row function');
389: END IF;
390:
391: INSERT INTO OKC_QA_ERRORS_T
392: (
393: DOCUMENT_TYPE,
394: DOCUMENT_ID,
395: SEQUENCE_ID,

Line 474: l_article_title OKC_QA_ERRORS_T.TITLE%TYPE;

470: FUNCTION get_article_title (
471: p_cat_id IN NUMBER) RETURN VARCHAR2
472: IS
473:
474: l_article_title OKC_QA_ERRORS_T.TITLE%TYPE;
475:
476: BEGIN
477: IF l_article_tbl.COUNT > 0 THEN
478: FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP

Line 496: l_section_title OKC_QA_ERRORS_T.TITLE%TYPE;

492: p_scn_id IN NUMBER
493: ) RETURN VARCHAR2
494: IS
495:
496: l_section_title OKC_QA_ERRORS_T.TITLE%TYPE;
497:
498: BEGIN
499: IF l_section_tbl.COUNT > 0 THEN
500: FOR i IN l_section_tbl.FIRST..l_section_tbl.LAST LOOP

Line 687: l_incom_severity OKC_QA_ERRORS_T.Error_severity%TYPE;

683: IS
684:
685: l_api_name CONSTANT VARCHAR2(30) := 'Check_Incomp_and_alternate';
686: l_indx NUMBER;
687: l_incom_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
688: l_incom_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
689: l_alternate_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
690: l_alternate_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
691: l_perform_alternate_qa VARCHAR2(1);

Line 688: l_incom_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

684:
685: l_api_name CONSTANT VARCHAR2(30) := 'Check_Incomp_and_alternate';
686: l_indx NUMBER;
687: l_incom_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
688: l_incom_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
689: l_alternate_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
690: l_alternate_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
691: l_perform_alternate_qa VARCHAR2(1);
692: l_perform_incom_qa VARCHAR2(1);

Line 689: l_alternate_severity OKC_QA_ERRORS_T.Error_severity%TYPE;

685: l_api_name CONSTANT VARCHAR2(30) := 'Check_Incomp_and_alternate';
686: l_indx NUMBER;
687: l_incom_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
688: l_incom_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
689: l_alternate_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
690: l_alternate_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
691: l_perform_alternate_qa VARCHAR2(1);
692: l_perform_incom_qa VARCHAR2(1);
693:

Line 690: l_alternate_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

686: l_indx NUMBER;
687: l_incom_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
688: l_incom_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
689: l_alternate_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
690: l_alternate_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
691: l_perform_alternate_qa VARCHAR2(1);
692: l_perform_incom_qa VARCHAR2(1);
693:
694: l_current_org_id VARCHAR2(100);

Line 964: l_lock_severity OKC_QA_ERRORS_T.Error_severity%TYPE;

960: IS
961:
962: l_api_name CONSTANT VARCHAR2(30) := 'check_lock_contract';
963: l_indx NUMBER;
964: l_lock_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
965: l_lock_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
966: l_lock_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;
967:
968: l_perform_lock_qa VARCHAR2(1);

Line 965: l_lock_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

961:
962: l_api_name CONSTANT VARCHAR2(30) := 'check_lock_contract';
963: l_indx NUMBER;
964: l_lock_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
965: l_lock_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
966: l_lock_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;
967:
968: l_perform_lock_qa VARCHAR2(1);
969: l_lock_contract VARCHAR2(1);

Line 966: l_lock_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;

962: l_api_name CONSTANT VARCHAR2(30) := 'check_lock_contract';
963: l_indx NUMBER;
964: l_lock_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
965: l_lock_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
966: l_lock_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;
967:
968: l_perform_lock_qa VARCHAR2(1);
969: l_lock_contract VARCHAR2(1);
970:

Line 1097: l_ctrt_admin_severity OKC_QA_ERRORS_T.Error_severity%TYPE;

1093: IS
1094:
1095: l_api_name CONSTANT VARCHAR2(30) := 'check_contract_admin';
1096: l_indx NUMBER;
1097: l_ctrt_admin_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
1098: l_ctrt_admin_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1099: l_ctrt_admin_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;
1100:
1101: l_perform_ctrt_admin_qa VARCHAR2(1);

Line 1098: l_ctrt_admin_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

1094:
1095: l_api_name CONSTANT VARCHAR2(30) := 'check_contract_admin';
1096: l_indx NUMBER;
1097: l_ctrt_admin_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
1098: l_ctrt_admin_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1099: l_ctrt_admin_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;
1100:
1101: l_perform_ctrt_admin_qa VARCHAR2(1);
1102: l_ctrt_admin VARCHAR2(1);

Line 1099: l_ctrt_admin_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;

1095: l_api_name CONSTANT VARCHAR2(30) := 'check_contract_admin';
1096: l_indx NUMBER;
1097: l_ctrt_admin_severity OKC_QA_ERRORS_T.Error_severity%TYPE;
1098: l_ctrt_admin_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1099: l_ctrt_admin_severity_flag OKC_QA_ERRORS_T.Error_severity%TYPE;
1100:
1101: l_perform_ctrt_admin_qa VARCHAR2(1);
1102: l_ctrt_admin VARCHAR2(1);
1103: l_ctrt_admin_emp VARCHAR2(1);

Line 1349: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

1345:
1346: l_api_name CONSTANT VARCHAR2(30) := 'check_duplicate_articles';
1347: l_indx NUMBER;
1348: l_error_count NUMBER := 0;
1349: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1350: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1351: l_perform_duplicate_qa Varchar2(1);
1352:
1353: /* expert commented out

Line 1350: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

1346: l_api_name CONSTANT VARCHAR2(30) := 'check_duplicate_articles';
1347: l_indx NUMBER;
1348: l_error_count NUMBER := 0;
1349: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1350: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1351: l_perform_duplicate_qa Varchar2(1);
1352:
1353: /* expert commented out
1354: -- new cursor to check for xprt articles

Line 1537: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

1533: IS
1534:
1535: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_var_doc_type_usage';
1536: l_indx NUMBER;
1537: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1538: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1539: l_perform_var_usg_qa VARCHAR2(1);
1540:
1541: /* 11.5.10+ modified cursor - see below

Line 1538: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

1534:
1535: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_var_doc_type_usage';
1536: l_indx NUMBER;
1537: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1538: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1539: l_perform_var_usg_qa VARCHAR2(1);
1540:
1541: /* 11.5.10+ modified cursor - see below
1542: CURSOR l_check_usage_csr IS

Line 1901: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

1897: IS
1898:
1899: l_api_name CONSTANT VARCHAR2(30) := 'check_user_vars_with_procs';
1900: l_indx NUMBER;
1901: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1902: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1903: l_perform_int_qa VARCHAR2(1);
1904:
1905: l_variable_value VARCHAR2(2500) := NULL;

Line 1902: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

1898:
1899: l_api_name CONSTANT VARCHAR2(30) := 'check_user_vars_with_procs';
1900: l_indx NUMBER;
1901: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1902: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1903: l_perform_int_qa VARCHAR2(1);
1904:
1905: l_variable_value VARCHAR2(2500) := NULL;
1906: l_previous_var_code okc_bus_variables_b.variable_code%TYPE := '-99';

Line 2049: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2045: IS
2046:
2047: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_variables';
2048: l_indx NUMBER;
2049: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2050: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2051: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2052: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2053: l_perform_int_qa VARCHAR2(1);

Line 2050: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2046:
2047: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_variables';
2048: l_indx NUMBER;
2049: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2050: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2051: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2052: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2053: l_perform_int_qa VARCHAR2(1);
2054: l_perform_ext_qa VARCHAR2(1);

Line 2051: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2047: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_variables';
2048: l_indx NUMBER;
2049: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2050: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2051: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2052: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2053: l_perform_int_qa VARCHAR2(1);
2054: l_perform_ext_qa VARCHAR2(1);
2055: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 2052: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2048: l_indx NUMBER;
2049: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2050: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2051: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2052: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2053: l_perform_int_qa VARCHAR2(1);
2054: l_perform_ext_qa VARCHAR2(1);
2055: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2056: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 2055: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2051: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2052: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2053: l_perform_int_qa VARCHAR2(1);
2054: l_perform_ext_qa VARCHAR2(1);
2055: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2056: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2057: l_perform_sys_qa Varchar2(1);
2058: l_var_value_tbl OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type;
2059: l_msg_count NUMBER;

Line 2056: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2052: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2053: l_perform_int_qa VARCHAR2(1);
2054: l_perform_ext_qa VARCHAR2(1);
2055: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2056: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2057: l_perform_sys_qa Varchar2(1);
2058: l_var_value_tbl OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type;
2059: l_msg_count NUMBER;
2060: l_msg_data VARCHAR2(1000);

Line 2309: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2305: IS
2306:
2307: l_api_name CONSTANT VARCHAR2(30) := 'G_check_unassigned_articles';
2308: l_indx NUMBER;
2309: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2310: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2311: l_perform_unas_art_qa VARCHAR2(1);
2312:
2313: CURSOR l_get_unass_art_crs IS

Line 2310: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2306:
2307: l_api_name CONSTANT VARCHAR2(30) := 'G_check_unassigned_articles';
2308: l_indx NUMBER;
2309: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2310: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2311: l_perform_unas_art_qa VARCHAR2(1);
2312:
2313: CURSOR l_get_unass_art_crs IS
2314: SELECT

Line 2418: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2414: IS
2415:
2416: l_api_name CONSTANT VARCHAR2(30) := 'G_check_empty_sections';
2417: l_indx NUMBER;
2418: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2419: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2420: l_perform_empty_scn_qa VARCHAR2(1);
2421:
2422: CURSOR l_get_empty_section_csr IS

Line 2419: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2415:
2416: l_api_name CONSTANT VARCHAR2(30) := 'G_check_empty_sections';
2417: l_indx NUMBER;
2418: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2419: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2420: l_perform_empty_scn_qa VARCHAR2(1);
2421:
2422: CURSOR l_get_empty_section_csr IS
2423: SELECT

Line 2527: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2523: IS
2524:
2525: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_Section_Amend_No_Texts';
2526: l_indx NUMBER;
2527: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2528: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2529: l_perform_scn_amend_qa VARCHAR2(1);
2530: l_disable_amend_yn VARCHAR2(1);
2531:

Line 2528: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2524:
2525: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_Section_Amend_No_Texts';
2526: l_indx NUMBER;
2527: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2528: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2529: l_perform_scn_amend_qa VARCHAR2(1);
2530: l_disable_amend_yn VARCHAR2(1);
2531:
2532: CURSOR l_get_doc_disable_amend_csr IS

Line 2628: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2624: IS
2625:
2626: l_api_name CONSTANT VARCHAR2(30) := 'G_check_article_amend_no_texts';
2627: l_indx NUMBER;
2628: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2629: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2630: l_perform_art_amend_qa VARCHAR2(1);
2631: l_disable_amend_yn VARCHAR2(1);
2632:

Line 2629: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2625:
2626: l_api_name CONSTANT VARCHAR2(30) := 'G_check_article_amend_no_texts';
2627: l_indx NUMBER;
2628: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2629: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2630: l_perform_art_amend_qa VARCHAR2(1);
2631: l_disable_amend_yn VARCHAR2(1);
2632:
2633: CURSOR l_get_doc_disable_amend_csr IS

Line 2734: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2730: IS
2731:
2732: l_api_name CONSTANT VARCHAR2(30) := 'check_inactive_template';
2733: l_indx NUMBER;
2734: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2735: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2736: l_perform_tmpl_qa VARCHAR2(1);
2737: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;
2738: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

Line 2735: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2731:
2732: l_api_name CONSTANT VARCHAR2(30) := 'check_inactive_template';
2733: l_indx NUMBER;
2734: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2735: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2736: l_perform_tmpl_qa VARCHAR2(1);
2737: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;
2738: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
2739:

Line 2892: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2888:
2889: l_api_name CONSTANT VARCHAR2(30) := 'G_check_art_effectivity';
2890: l_indx NUMBER;
2891: l_indx1 NUMBER;
2892: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2893: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2894:
2895: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2896: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 2893: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2889: l_api_name CONSTANT VARCHAR2(30) := 'G_check_art_effectivity';
2890: l_indx NUMBER;
2891: l_indx1 NUMBER;
2892: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2893: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2894:
2895: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2896: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2897: l_start_date DATE;

Line 2895: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2891: l_indx1 NUMBER;
2892: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2893: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2894:
2895: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2896: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2897: l_start_date DATE;
2898: l_end_date DATE;
2899: l_found BOOLEAN := FALSE;

Line 2896: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2892: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2893: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2894:
2895: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2896: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2897: l_start_date DATE;
2898: l_end_date DATE;
2899: l_found BOOLEAN := FALSE;
2900:

Line 3360: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3356: IS
3357:
3358: l_api_name CONSTANT VARCHAR2(30) := 'G_CHECK_LAYOUT_TEMPLATE';
3359: l_indx NUMBER;
3360: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3361: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3362: l_perform_layout_tmpl_qa VARCHAR2(1);
3363: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3364: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;

Line 3361: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3357:
3358: l_api_name CONSTANT VARCHAR2(30) := 'G_CHECK_LAYOUT_TEMPLATE';
3359: l_indx NUMBER;
3360: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3361: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3362: l_perform_layout_tmpl_qa VARCHAR2(1);
3363: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3364: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
3365:

Line 3476: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3472: IS
3473:
3474: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_REVISION';
3475: l_indx NUMBER;
3476: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3477: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3478: l_perform_trans_rev_qa VARCHAR2(1);
3479: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3480: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

Line 3477: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3473:
3474: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_REVISION';
3475: l_indx NUMBER;
3476: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3477: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3478: l_perform_trans_rev_qa VARCHAR2(1);
3479: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3480: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3481: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

Line 3599: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3595: IS
3596:
3597: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_EFFECTIVITY';
3598: l_indx NUMBER;
3599: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3600: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3601: l_perform_trans_tmpl_eff_qa VARCHAR2(1);
3602: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3603: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

Line 3600: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3596:
3597: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_EFFECTIVITY';
3598: l_indx NUMBER;
3599: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3600: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3601: l_perform_trans_tmpl_eff_qa VARCHAR2(1);
3602: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3603: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3604: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

Line 3721: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3717: IS
3718:
3719: l_api_name CONSTANT VARCHAR2(30) := 'check_articles_exist';
3720: l_indx NUMBER;
3721: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3722: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3723: l_perform_articles_exist_qa VARCHAR2(1);
3724:
3725: BEGIN

Line 3722: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3718:
3719: l_api_name CONSTANT VARCHAR2(30) := 'check_articles_exist';
3720: l_indx NUMBER;
3721: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3722: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3723: l_perform_articles_exist_qa VARCHAR2(1);
3724:
3725: BEGIN
3726:

Line 3821: title OKC_QA_ERRORS_T.title%TYPE,

3817: /*
3818: TYPE draft_art_rec_type IS RECORD (
3819: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
3820: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
3821: title OKC_QA_ERRORS_T.title%TYPE,
3822: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE
3823: );
3824:
3825: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;

Line 3850: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3846: l_msg_data VARCHAR2(2000);
3847: l_qa_return_status VARCHAR2(1);
3848:
3849: l_perform_qa_art_typ VARCHAR2(1);
3850: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3851: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3852:
3853: l_perform_qa_def_sec VARCHAR2(1);
3854: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3851: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3847: l_qa_return_status VARCHAR2(1);
3848:
3849: l_perform_qa_art_typ VARCHAR2(1);
3850: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3851: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3852:
3853: l_perform_qa_def_sec VARCHAR2(1);
3854: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3855: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3854: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3850: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3851: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3852:
3853: l_perform_qa_def_sec VARCHAR2(1);
3854: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3855: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3856:
3857: l_perform_qa_inv_var VARCHAR2(1);
3858: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3855: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3851: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3852:
3853: l_perform_qa_def_sec VARCHAR2(1);
3854: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3855: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3856:
3857: l_perform_qa_inv_var VARCHAR2(1);
3858: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3859: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3858: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3854: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3855: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3856:
3857: l_perform_qa_inv_var VARCHAR2(1);
3858: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3859: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3860:
3861: l_perform_qa_inv_val VARCHAR2(1);
3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3859: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3855: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3856:
3857: l_perform_qa_inv_var VARCHAR2(1);
3858: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3859: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3860:
3861: l_perform_qa_inv_val VARCHAR2(1);
3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3863: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3858: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3859: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3860:
3861: l_perform_qa_inv_val VARCHAR2(1);
3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3863: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3864:
3865: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3866: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;

Line 3863: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3859: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3860:
3861: l_perform_qa_inv_val VARCHAR2(1);
3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3863: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3864:
3865: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3866: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;
3867:

Line 3865: l_title OKC_QA_ERRORS_T.TITLE%TYPE;

3861: l_perform_qa_inv_val VARCHAR2(1);
3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3863: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3864:
3865: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3866: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;
3867:
3868: CURSOR l_draft_art_csr IS
3869: SELECT DRA.article_id, DRA.article_version_id,

Line 3866: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;

3862: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3863: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3864:
3865: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3866: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;
3867:
3868: CURSOR l_draft_art_csr IS
3869: SELECT DRA.article_id, DRA.article_version_id,
3870: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section

Line 4284: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

4280: x_return_status OUT NOCOPY VARCHAR2)
4281: IS
4282: l_api_name CONSTANT VARCHAR2(30) := 'check_rejected_clauses';
4283: l_indx NUMBER;
4284: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
4285: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
4286: l_perform_articles_exist_qa VARCHAR2(1);
4287:
4288: CURSOR l_rejected_art_csr IS

Line 4285: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

4281: IS
4282: l_api_name CONSTANT VARCHAR2(30) := 'check_rejected_clauses';
4283: l_indx NUMBER;
4284: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
4285: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
4286: l_perform_articles_exist_qa VARCHAR2(1);
4287:
4288: CURSOR l_rejected_art_csr IS
4289: SELECT DRA.article_id article_id, DRA.article_version_id,