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 2710: OKC_TERMS_TEMPLATES_ALL TMPL,

2706:
2707: CURSOR l_get_template_crs IS
2708: SELECT status_code,end_date,template_name
2709: FROM
2710: OKC_TERMS_TEMPLATES_ALL TMPL,
2711: OKC_TEMPLATE_USAGES USG
2712: WHERE USG.DOCUMENT_TYPE = p_doc_type
2713: AND USG.DOCUMENT_ID = p_doc_id
2714: AND TMPL.TEMPLATE_ID = USG.TEMPLATE_ID;

Line 2874: FROM OKC_TERMS_TEMPLATES_ALL

2870: l_article_version_tbl article_version_tbl_type;
2871:
2872: CURSOR l_get_tmpl_dates_csr IS
2873: SELECT START_DATE,END_DATE
2874: FROM OKC_TERMS_TEMPLATES_ALL
2875: WHERE TEMPLATE_ID=p_doc_id;
2876:
2877: /* This will executed only in TEMPLATE QA */
2878: /*

Line 2907: okc_terms_templates_all tmpl,

2903: kart.scn_id scn_id,
2904: kart.amendment_operation_code amendment_operation_code,
2905: kart.amendment_description amendment_description
2906: FROM OKC_K_ARTICLES_B KART,
2907: okc_terms_templates_all tmpl,
2908: okc_articles_all art
2909: WHERE kart.document_id = tmpl.template_id
2910: AND kart.sav_sae_id = art.article_id
2911: AND DOCUMENT_TYPE=p_doc_type

Line 2951: okc_terms_templates_all tmpl,

2947: Rule.clause_id xprt_article_id,
2948: Rule.rule_id rule_id,
2949: Rule.rule_name rule_name
2950: FROM okc_xprt_clauses_v rule,
2951: okc_terms_templates_all tmpl,
2952: okc_articles_all art
2953: WHERE rule.template_id = tmpl.template_id
2954: AND tmpl.template_id = p_doc_id
2955: AND art.article_id = rule.clause_id

Line 3021: OKC_TERMS_TEMPLATES_ALL TMPL

3017: FROM OKC_K_ARTICLES_B KART,
3018: OKC_ARTICLE_VERSIONS VERS,
3019: OKC_ARTICLE_VERSIONS VERS1,
3020: OKC_TEMPLATE_USAGES USG,
3021: OKC_TERMS_TEMPLATES_ALL TMPL
3022: WHERE KART.DOCUMENT_TYPE=p_doc_type
3023: AND KART.DOCUMENT_ID =p_doc_id
3024: AND KART.DOCUMENT_TYPE= USG.DOCUMENT_TYPE
3025: AND KART.DOCUMENT_ID = USG.DOCUMENT_ID

Line 3329: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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

Line 3330: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;

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:
3332: CURSOR l_get_layout_tmpl_csr IS
3333: SELECT template_name, print_template_id
3334: FROM okc_terms_templates_all

Line 3334: FROM okc_terms_templates_all

3330: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
3331:
3332: CURSOR l_get_layout_tmpl_csr IS
3333: SELECT template_name, print_template_id
3334: FROM okc_terms_templates_all
3335: WHERE template_id = p_doc_id ;
3336:
3337: BEGIN
3338:

Line 3445: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3448:
3449: CURSOR l_translated_tmpl_revision_csr IS

Line 3446: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3448:
3449: CURSOR l_translated_tmpl_revision_csr IS
3450: SELECT parent.template_id, parent.template_name, trans.template_name

Line 3447: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%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;
3448:
3449: CURSOR l_translated_tmpl_revision_csr IS
3450: SELECT parent.template_id, parent.template_name, trans.template_name
3451: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

Line 3451: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

3447: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
3448:
3449: CURSOR l_translated_tmpl_revision_csr IS
3450: SELECT parent.template_id, parent.template_name, trans.template_name
3451: FROM okc_terms_templates_all parent, okc_terms_templates_all trans
3452: WHERE parent.template_id = trans.translated_from_tmpl_id
3453: AND trans.template_id = p_doc_id
3454: AND exists (SELECT 1
3455: FROM okc_terms_templates_all revision

Line 3455: FROM okc_terms_templates_all revision

3451: FROM okc_terms_templates_all parent, okc_terms_templates_all trans
3452: WHERE parent.template_id = trans.translated_from_tmpl_id
3453: AND trans.template_id = p_doc_id
3454: AND exists (SELECT 1
3455: FROM okc_terms_templates_all revision
3456: WHERE parent.template_id = revision.parent_template_id);
3457:
3458:
3459: BEGIN

Line 3568: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3571:
3572: CURSOR l_get_trans_tmpl_csr IS

Line 3569: l_trans_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

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;
3571:
3572: CURSOR l_get_trans_tmpl_csr IS
3573: SELECT parent.template_id, parent.template_name, trans.template_name

Line 3570: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%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;
3571:
3572: CURSOR l_get_trans_tmpl_csr IS
3573: SELECT parent.template_id, parent.template_name, trans.template_name
3574: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

Line 3574: FROM okc_terms_templates_all parent, okc_terms_templates_all trans

3570: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
3571:
3572: CURSOR l_get_trans_tmpl_csr IS
3573: SELECT parent.template_id, parent.template_name, trans.template_name
3574: FROM okc_terms_templates_all parent, okc_terms_templates_all trans
3575: WHERE ( trunc(sysdate) >= nvl(trunc(parent.end_date),sysdate+1)
3576: OR parent.status_code = 'ON_HOLD' )
3577: AND parent.template_id = trans.translated_from_tmpl_id
3578: AND trans.template_id = p_doc_id;

Line 4516: FROM okc_terms_templates_all

4512:
4513: /* Modified in 11.5.10+ to get additonal template information
4514: CURSOR l_get_effective_date_template IS
4515: SELECT start_date, end_date
4516: FROM okc_terms_templates_all
4517: WHERE template_id = p_doc_id;
4518: */
4519:
4520: -- 11.5.10+ modified cursor to get additional template details

Line 4525: FROM okc_terms_templates_all

4521: CURSOR l_get_effective_date_template IS
4522: SELECT start_date, end_date,
4523: nvl(contract_expert_enabled, 'N'), nvl(status_code, 'DRAFT'),
4524: template_name,org_id
4525: FROM okc_terms_templates_all
4526: WHERE template_id = p_doc_id;
4527:
4528: /* 11.5.10+ replace with global variables
4529: l_start_date DATE;