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_TERMS_TEMPLATES_ALL

Line 261: g_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;

257: g_validation_level VARCHAR2(1);
258: g_expert_enabled VARCHAR2(1);
259: g_start_date DATE;
260: g_end_date DATE;
261: g_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
262: g_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
263: g_org_id NUMBER;
264:
265: l_qa_detail_tbl qa_detail_tbl_type;

Line 262: g_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

258: g_expert_enabled VARCHAR2(1);
259: g_start_date DATE;
260: g_end_date DATE;
261: g_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
262: g_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
263: g_org_id NUMBER;
264:
265: l_qa_detail_tbl qa_detail_tbl_type;
266: l_article_tbl article_tbl_type;

Line 2744: OKC_TERMS_TEMPLATES_ALL TMPL,

2740:
2741: CURSOR l_get_template_crs IS
2742: SELECT status_code,end_date,template_name
2743: FROM
2744: OKC_TERMS_TEMPLATES_ALL TMPL,
2745: OKC_TEMPLATE_USAGES USG
2746: WHERE USG.DOCUMENT_TYPE = p_doc_type
2747: AND USG.DOCUMENT_ID = p_doc_id
2748: AND TMPL.TEMPLATE_ID = USG.TEMPLATE_ID;

Line 2908: FROM OKC_TERMS_TEMPLATES_ALL

2904: l_article_version_tbl article_version_tbl_type;
2905:
2906: CURSOR l_get_tmpl_dates_csr IS
2907: SELECT START_DATE,END_DATE
2908: FROM OKC_TERMS_TEMPLATES_ALL
2909: WHERE TEMPLATE_ID=p_doc_id;
2910:
2911: /* This will executed only in TEMPLATE QA */
2912: /*

Line 2941: okc_terms_templates_all tmpl,

2937: kart.scn_id scn_id,
2938: kart.amendment_operation_code amendment_operation_code,
2939: kart.amendment_description amendment_description
2940: FROM OKC_K_ARTICLES_B KART,
2941: okc_terms_templates_all tmpl,
2942: okc_articles_all art
2943: WHERE kart.document_id = tmpl.template_id
2944: AND kart.sav_sae_id = art.article_id
2945: AND DOCUMENT_TYPE=p_doc_type

Line 2985: okc_terms_templates_all tmpl,

2981: Rule.clause_id xprt_article_id,
2982: Rule.rule_id rule_id,
2983: Rule.rule_name rule_name
2984: FROM okc_xprt_clauses_v rule,
2985: okc_terms_templates_all tmpl,
2986: okc_articles_all art
2987: WHERE rule.template_id = tmpl.template_id
2988: AND tmpl.template_id = p_doc_id
2989: AND art.article_id = rule.clause_id

Line 3055: OKC_TERMS_TEMPLATES_ALL TMPL

3051: FROM OKC_K_ARTICLES_B KART,
3052: OKC_ARTICLE_VERSIONS VERS,
3053: OKC_ARTICLE_VERSIONS VERS1,
3054: OKC_TEMPLATE_USAGES USG,
3055: OKC_TERMS_TEMPLATES_ALL TMPL
3056: WHERE KART.DOCUMENT_TYPE=p_doc_type
3057: AND KART.DOCUMENT_ID =p_doc_id
3058: AND KART.DOCUMENT_TYPE= USG.DOCUMENT_TYPE
3059: AND KART.DOCUMENT_ID = USG.DOCUMENT_ID

Line 3363: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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:
3366: CURSOR l_get_layout_tmpl_csr IS
3367: SELECT template_name, print_template_id

Line 3364: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;

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:
3366: CURSOR l_get_layout_tmpl_csr IS
3367: SELECT template_name, print_template_id
3368: FROM okc_terms_templates_all

Line 3368: FROM okc_terms_templates_all

3364: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
3365:
3366: CURSOR l_get_layout_tmpl_csr IS
3367: SELECT template_name, print_template_id
3368: FROM okc_terms_templates_all
3369: WHERE template_id = p_doc_id ;
3370:
3371: BEGIN
3372:

Line 3479: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3482:
3483: CURSOR l_translated_tmpl_revision_csr IS

Line 3480: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3482:
3483: CURSOR l_translated_tmpl_revision_csr IS
3484: SELECT parent.template_id, parent.template_name, trans.template_name

Line 3481: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%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;
3482:
3483: CURSOR l_translated_tmpl_revision_csr IS
3484: SELECT parent.template_id, parent.template_name, trans.template_name
3485: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

Line 3485: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

3481: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
3482:
3483: CURSOR l_translated_tmpl_revision_csr IS
3484: SELECT parent.template_id, parent.template_name, trans.template_name
3485: FROM okc_terms_templates_all parent, okc_terms_templates_all trans
3486: WHERE parent.template_id = trans.translated_from_tmpl_id
3487: AND trans.template_id = p_doc_id
3488: AND exists (SELECT 1
3489: FROM okc_terms_templates_all revision

Line 3489: FROM okc_terms_templates_all revision

3485: FROM okc_terms_templates_all parent, okc_terms_templates_all trans
3486: WHERE parent.template_id = trans.translated_from_tmpl_id
3487: AND trans.template_id = p_doc_id
3488: AND exists (SELECT 1
3489: FROM okc_terms_templates_all revision
3490: WHERE parent.template_id = revision.parent_template_id);
3491:
3492:
3493: BEGIN

Line 3602: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3605:
3606: CURSOR l_get_trans_tmpl_csr IS

Line 3603: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3605:
3606: CURSOR l_get_trans_tmpl_csr IS
3607: SELECT parent.template_id, parent.template_name, trans.template_name

Line 3604: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%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;
3605:
3606: CURSOR l_get_trans_tmpl_csr IS
3607: SELECT parent.template_id, parent.template_name, trans.template_name
3608: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

Line 3608: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

3604: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
3605:
3606: CURSOR l_get_trans_tmpl_csr IS
3607: SELECT parent.template_id, parent.template_name, trans.template_name
3608: FROM okc_terms_templates_all parent, okc_terms_templates_all trans
3609: WHERE ( trunc(sysdate) >= nvl(trunc(parent.end_date),sysdate+1)
3610: OR parent.status_code = 'ON_HOLD' )
3611: AND parent.template_id = trans.translated_from_tmpl_id
3612: AND trans.template_id = p_doc_id;

Line 4550: FROM okc_terms_templates_all

4546:
4547: /* Modified in 11.5.10+ to get additonal template information
4548: CURSOR l_get_effective_date_template IS
4549: SELECT start_date, end_date
4550: FROM okc_terms_templates_all
4551: WHERE template_id = p_doc_id;
4552: */
4553:
4554: -- 11.5.10+ modified cursor to get additional template details

Line 4559: FROM okc_terms_templates_all

4555: CURSOR l_get_effective_date_template IS
4556: SELECT start_date, end_date,
4557: nvl(contract_expert_enabled, 'N'), nvl(status_code, 'DRAFT'),
4558: template_name,org_id
4559: FROM okc_terms_templates_all
4560: WHERE template_id = p_doc_id;
4561:
4562: /* 11.5.10+ replace with global variables
4563: l_start_date DATE;