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 1330: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

1326:
1327: l_api_name CONSTANT VARCHAR2(30) := 'check_duplicate_articles';
1328: l_indx NUMBER;
1329: l_error_count NUMBER := 0;
1330: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1331: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1332: l_perform_duplicate_qa Varchar2(1);
1333:
1334: /* expert commented out

Line 1331: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

1327: l_api_name CONSTANT VARCHAR2(30) := 'check_duplicate_articles';
1328: l_indx NUMBER;
1329: l_error_count NUMBER := 0;
1330: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1331: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1332: l_perform_duplicate_qa Varchar2(1);
1333:
1334: /* expert commented out
1335: -- new cursor to check for xprt articles

Line 1518: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

1514: IS
1515:
1516: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_var_doc_type_usage';
1517: l_indx NUMBER;
1518: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1519: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1520: l_perform_var_usg_qa VARCHAR2(1);
1521:
1522: /* 11.5.10+ modified cursor - see below

Line 1519: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

1515:
1516: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_var_doc_type_usage';
1517: l_indx NUMBER;
1518: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1519: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1520: l_perform_var_usg_qa VARCHAR2(1);
1521:
1522: /* 11.5.10+ modified cursor - see below
1523: CURSOR l_check_usage_csr IS

Line 1882: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

1878: IS
1879:
1880: l_api_name CONSTANT VARCHAR2(30) := 'check_user_vars_with_procs';
1881: l_indx NUMBER;
1882: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1883: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1884: l_perform_int_qa VARCHAR2(1);
1885:
1886: l_variable_value VARCHAR2(2500) := NULL;

Line 1883: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

1879:
1880: l_api_name CONSTANT VARCHAR2(30) := 'check_user_vars_with_procs';
1881: l_indx NUMBER;
1882: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
1883: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1884: l_perform_int_qa VARCHAR2(1);
1885:
1886: l_variable_value VARCHAR2(2500) := NULL;
1887: l_previous_var_code okc_bus_variables_b.variable_code%TYPE := '-99';

Line 2030: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2026: IS
2027:
2028: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_variables';
2029: l_indx NUMBER;
2030: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2031: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2032: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2033: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2034: l_perform_int_qa VARCHAR2(1);

Line 2031: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2027:
2028: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_variables';
2029: l_indx NUMBER;
2030: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2031: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2032: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2033: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2034: l_perform_int_qa VARCHAR2(1);
2035: l_perform_ext_qa VARCHAR2(1);

Line 2032: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2028: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_variables';
2029: l_indx NUMBER;
2030: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2031: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2032: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2033: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2034: l_perform_int_qa VARCHAR2(1);
2035: l_perform_ext_qa VARCHAR2(1);
2036: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 2033: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2029: l_indx NUMBER;
2030: l_int_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2031: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2032: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2033: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2034: l_perform_int_qa VARCHAR2(1);
2035: l_perform_ext_qa VARCHAR2(1);
2036: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2037: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 2036: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2032: l_ext_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2033: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2034: l_perform_int_qa VARCHAR2(1);
2035: l_perform_ext_qa VARCHAR2(1);
2036: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2037: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2038: l_perform_sys_qa Varchar2(1);
2039: l_var_value_tbl OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type;
2040: l_msg_count NUMBER;

Line 2037: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2033: l_ext_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2034: l_perform_int_qa VARCHAR2(1);
2035: l_perform_ext_qa VARCHAR2(1);
2036: l_sys_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2037: l_sys_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2038: l_perform_sys_qa Varchar2(1);
2039: l_var_value_tbl OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type;
2040: l_msg_count NUMBER;
2041: l_msg_data VARCHAR2(1000);

Line 2275: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2271: IS
2272:
2273: l_api_name CONSTANT VARCHAR2(30) := 'G_check_unassigned_articles';
2274: l_indx NUMBER;
2275: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2276: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2277: l_perform_unas_art_qa VARCHAR2(1);
2278:
2279: CURSOR l_get_unass_art_crs IS

Line 2276: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2272:
2273: l_api_name CONSTANT VARCHAR2(30) := 'G_check_unassigned_articles';
2274: l_indx NUMBER;
2275: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2276: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2277: l_perform_unas_art_qa VARCHAR2(1);
2278:
2279: CURSOR l_get_unass_art_crs IS
2280: SELECT

Line 2384: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2380: IS
2381:
2382: l_api_name CONSTANT VARCHAR2(30) := 'G_check_empty_sections';
2383: l_indx NUMBER;
2384: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2385: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2386: l_perform_empty_scn_qa VARCHAR2(1);
2387:
2388: CURSOR l_get_empty_section_csr IS

Line 2385: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2381:
2382: l_api_name CONSTANT VARCHAR2(30) := 'G_check_empty_sections';
2383: l_indx NUMBER;
2384: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2385: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2386: l_perform_empty_scn_qa VARCHAR2(1);
2387:
2388: CURSOR l_get_empty_section_csr IS
2389: SELECT

Line 2493: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2489: IS
2490:
2491: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_Section_Amend_No_Texts';
2492: l_indx NUMBER;
2493: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2494: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2495: l_perform_scn_amend_qa VARCHAR2(1);
2496: l_disable_amend_yn VARCHAR2(1);
2497:

Line 2494: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2490:
2491: l_api_name CONSTANT VARCHAR2(30) := 'G_Check_Section_Amend_No_Texts';
2492: l_indx NUMBER;
2493: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2494: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2495: l_perform_scn_amend_qa VARCHAR2(1);
2496: l_disable_amend_yn VARCHAR2(1);
2497:
2498: CURSOR l_get_doc_disable_amend_csr IS

Line 2594: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2590: IS
2591:
2592: l_api_name CONSTANT VARCHAR2(30) := 'G_check_article_amend_no_texts';
2593: l_indx NUMBER;
2594: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2595: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2596: l_perform_art_amend_qa VARCHAR2(1);
2597: l_disable_amend_yn VARCHAR2(1);
2598:

Line 2595: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2591:
2592: l_api_name CONSTANT VARCHAR2(30) := 'G_check_article_amend_no_texts';
2593: l_indx NUMBER;
2594: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2595: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2596: l_perform_art_amend_qa VARCHAR2(1);
2597: l_disable_amend_yn VARCHAR2(1);
2598:
2599: CURSOR l_get_doc_disable_amend_csr IS

Line 2700: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2696: IS
2697:
2698: l_api_name CONSTANT VARCHAR2(30) := 'check_inactive_template';
2699: l_indx NUMBER;
2700: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2701: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2702: l_perform_tmpl_qa VARCHAR2(1);
2703: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;
2704: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

Line 2701: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2697:
2698: l_api_name CONSTANT VARCHAR2(30) := 'check_inactive_template';
2699: l_indx NUMBER;
2700: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2701: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2702: l_perform_tmpl_qa VARCHAR2(1);
2703: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;
2704: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
2705:

Line 2858: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2854:
2855: l_api_name CONSTANT VARCHAR2(30) := 'G_check_art_effectivity';
2856: l_indx NUMBER;
2857: l_indx1 NUMBER;
2858: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2859: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2860:
2861: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2862: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 2859: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2855: l_api_name CONSTANT VARCHAR2(30) := 'G_check_art_effectivity';
2856: l_indx NUMBER;
2857: l_indx1 NUMBER;
2858: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2859: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2860:
2861: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2862: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2863: l_start_date DATE;

Line 2861: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

2857: l_indx1 NUMBER;
2858: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2859: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2860:
2861: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2862: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2863: l_start_date DATE;
2864: l_end_date DATE;
2865: l_found BOOLEAN := FALSE;

Line 2862: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

2858: l_art_val_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2859: l_art_val_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2860:
2861: l_lat_vers_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2862: l_lat_vers_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2863: l_start_date DATE;
2864: l_end_date DATE;
2865: l_found BOOLEAN := FALSE;
2866:

Line 3326: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3322: IS
3323:
3324: l_api_name CONSTANT VARCHAR2(30) := 'G_CHECK_LAYOUT_TEMPLATE';
3325: l_indx NUMBER;
3326: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3327: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3328: l_perform_layout_tmpl_qa VARCHAR2(1);
3329: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3330: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;

Line 3327: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3323:
3324: l_api_name CONSTANT VARCHAR2(30) := 'G_CHECK_LAYOUT_TEMPLATE';
3325: l_indx NUMBER;
3326: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3327: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3328: l_perform_layout_tmpl_qa VARCHAR2(1);
3329: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3330: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
3331:

Line 3442: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3438: IS
3439:
3440: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_REVISION';
3441: l_indx NUMBER;
3442: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3443: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3444: l_perform_trans_rev_qa VARCHAR2(1);
3445: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3446: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

Line 3443: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3439:
3440: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_REVISION';
3441: l_indx NUMBER;
3442: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3443: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3444: l_perform_trans_rev_qa VARCHAR2(1);
3445: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3446: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3447: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

Line 3565: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3561: IS
3562:
3563: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_EFFECTIVITY';
3564: l_indx NUMBER;
3565: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3566: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3567: l_perform_trans_tmpl_eff_qa VARCHAR2(1);
3568: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3569: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

Line 3566: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3562:
3563: l_api_name CONSTANT VARCHAR2(40) := 'G_CHECK_TRANSLATED_TMPL_EFFECTIVITY';
3564: l_indx NUMBER;
3565: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3566: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3567: l_perform_trans_tmpl_eff_qa VARCHAR2(1);
3568: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3569: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3570: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

Line 3687: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3683: IS
3684:
3685: l_api_name CONSTANT VARCHAR2(30) := 'check_articles_exist';
3686: l_indx NUMBER;
3687: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3688: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3689: l_perform_articles_exist_qa VARCHAR2(1);
3690:
3691: BEGIN

Line 3688: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3684:
3685: l_api_name CONSTANT VARCHAR2(30) := 'check_articles_exist';
3686: l_indx NUMBER;
3687: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3688: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3689: l_perform_articles_exist_qa VARCHAR2(1);
3690:
3691: BEGIN
3692:

Line 3787: title OKC_QA_ERRORS_T.title%TYPE,

3783: /*
3784: TYPE draft_art_rec_type IS RECORD (
3785: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
3786: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
3787: title OKC_QA_ERRORS_T.title%TYPE,
3788: section OKC_TMPL_DRAFT_CLAUSES.SECTION_NAME%TYPE
3789: );
3790:
3791: TYPE draft_art_tbl_type IS TABLE OF draft_art_rec_type INDEX BY BINARY_INTEGER;

Line 3816: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3812: l_msg_data VARCHAR2(2000);
3813: l_qa_return_status VARCHAR2(1);
3814:
3815: l_perform_qa_art_typ VARCHAR2(1);
3816: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3817: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3818:
3819: l_perform_qa_def_sec VARCHAR2(1);
3820: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3817: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3813: l_qa_return_status VARCHAR2(1);
3814:
3815: l_perform_qa_art_typ VARCHAR2(1);
3816: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3817: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3818:
3819: l_perform_qa_def_sec VARCHAR2(1);
3820: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3821: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3820: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3816: l_severity_art_typ OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3817: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3818:
3819: l_perform_qa_def_sec VARCHAR2(1);
3820: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3821: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3822:
3823: l_perform_qa_inv_var VARCHAR2(1);
3824: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3821: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3817: l_desc_art_typ OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3818:
3819: l_perform_qa_def_sec VARCHAR2(1);
3820: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3821: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3822:
3823: l_perform_qa_inv_var VARCHAR2(1);
3824: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3825: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3824: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3820: l_severity_def_sec OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3821: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3822:
3823: l_perform_qa_inv_var VARCHAR2(1);
3824: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3825: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3826:
3827: l_perform_qa_inv_val VARCHAR2(1);
3828: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 3825: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3821: l_desc_def_sec OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3822:
3823: l_perform_qa_inv_var VARCHAR2(1);
3824: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3825: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3826:
3827: l_perform_qa_inv_val VARCHAR2(1);
3828: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3829: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

Line 3828: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

3824: l_severity_inv_var OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3825: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3826:
3827: l_perform_qa_inv_val VARCHAR2(1);
3828: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3829: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3830:
3831: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3832: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;

Line 3829: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

3825: l_desc_inv_var OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3826:
3827: l_perform_qa_inv_val VARCHAR2(1);
3828: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3829: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3830:
3831: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3832: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;
3833:

Line 3831: l_title OKC_QA_ERRORS_T.TITLE%TYPE;

3827: l_perform_qa_inv_val VARCHAR2(1);
3828: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3829: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3830:
3831: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3832: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;
3833:
3834: CURSOR l_draft_art_csr IS
3835: SELECT DRA.article_id, DRA.article_version_id,

Line 3832: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;

3828: l_severity_inv_val OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
3829: l_desc_inv_val OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
3830:
3831: l_title OKC_QA_ERRORS_T.TITLE%TYPE;
3832: l_section OKC_QA_ERRORS_T.SECTION_NAME%TYPE;
3833:
3834: CURSOR l_draft_art_csr IS
3835: SELECT DRA.article_id, DRA.article_version_id,
3836: --NVL(VER.display_name, ART.article_title) title, DRA.section_name section

Line 4250: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

4246: x_return_status OUT NOCOPY VARCHAR2)
4247: IS
4248: l_api_name CONSTANT VARCHAR2(30) := 'check_rejected_clauses';
4249: l_indx NUMBER;
4250: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
4251: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
4252: l_perform_articles_exist_qa VARCHAR2(1);
4253:
4254: CURSOR l_rejected_art_csr IS

Line 4251: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;

4247: IS
4248: l_api_name CONSTANT VARCHAR2(30) := 'check_rejected_clauses';
4249: l_indx NUMBER;
4250: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
4251: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
4252: l_perform_articles_exist_qa VARCHAR2(1);
4253:
4254: CURSOR l_rejected_art_csr IS
4255: SELECT DRA.article_id article_id, DRA.article_version_id,