APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 2430: FROM okc_terms_templates_all,

2426: DECODE(parent_template_id, NULL, template_id, parent_template_id),
2427: intent,
2428: name,
2429: org_id
2430: FROM okc_terms_templates_all,
2431: hr_operating_units
2432: WHERE organization_id = org_id
2433: AND template_id = p_template_id ;
2434:

Line 2470: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

2466: l_template_folder_id NUMBER :=NULL;
2467: l_folder_desc VARCHAR2(255);
2468: l_import_status VARCHAR2(10);
2469:
2470: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2471: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2472: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
2473: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
2474: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

Line 2471: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

2467: l_folder_desc VARCHAR2(255);
2468: l_import_status VARCHAR2(10);
2469:
2470: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2471: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2472: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
2473: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
2474: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
2475: l_folder_name cz_rp_entries.name%TYPE;

Line 2472: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;

2468: l_import_status VARCHAR2(10);
2469:
2470: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2471: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2472: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
2473: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
2474: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
2475: l_folder_name cz_rp_entries.name%TYPE;
2476:

Line 2473: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;

2469:
2470: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2471: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2472: l_intent OKC_TERMS_TEMPLATES_ALL.intent%TYPE;
2473: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
2474: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
2475: l_folder_name cz_rp_entries.name%TYPE;
2476:
2477: BEGIN

Line 2532: UPDATE okc_terms_templates_all

2528: fnd_file.put_line(FND_FILE.LOG,'Template Name : '||l_template_name);
2529:
2530:
2531: -- Update the xprt_request_id for the current template
2532: UPDATE okc_terms_templates_all
2533: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
2534: last_update_login = FND_GLOBAL.LOGIN_ID,
2535: last_update_date = SYSDATE,
2536: last_updated_by = FND_GLOBAL.USER_ID

Line 2838: UPDATE okc_terms_templates_all

2834: OPEN csr_template_model_id(p_orig_sys_ref => l_tmpl_orig_sys_ref);
2835: FETCH csr_template_model_id INTO l_template_model_id;
2836: CLOSE csr_template_model_id;
2837:
2838: UPDATE okc_terms_templates_all
2839: SET template_model_id = l_template_model_id
2840: WHERE template_id = p_template_id;
2841:
2842:

Line 2915: FROM okc_terms_templates_all t,

2911: -- Templates to be rebuilt for Publishing or Disabling Rules
2912: CURSOR csr_local_rules_templates IS
2913: -- Templates on Local Rules
2914: SELECT DISTINCT to_char(r.template_id)
2915: FROM okc_terms_templates_all t,
2916: okc_xprt_template_rules r,
2917: okc_xprt_rule_hdrs_all h
2918: WHERE r.template_id = t.template_id
2919: AND r.rule_id = h.rule_id

Line 2939: FROM okc_terms_templates_all t

2935:
2936: CURSOR csr_org_rules_templates(p_org_id IN NUMBER) IS
2937: -- Org Wide Rule Templates
2938: SELECT t.template_id
2939: FROM okc_terms_templates_all t
2940: WHERE t.org_id = p_org_id
2941: AND t.intent IN (
2942: SELECT DISTINCT intent
2943: FROM okc_xprt_rule_hdrs_all

Line 2963: l_template_id okc_terms_templates_all.template_id%TYPE;

2959: FROM okc_xprt_rule_hdrs_all
2960: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
2961:
2962: l_api_name CONSTANT VARCHAR2(30) := 'rebuild_tmpl_pub_disable';
2963: l_template_id okc_terms_templates_all.template_id%TYPE;
2964: l_org_rules_yn okc_xprt_rule_hdrs_all.org_wide_flag%TYPE := NULL;
2965: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2966:
2967: BEGIN

Line 3132: FROM okc_terms_templates_all t

3128: ) IS
3129:
3130: CURSOR csr_templates IS
3131: SELECT t.template_id
3132: FROM okc_terms_templates_all t
3133: WHERE t.org_id = p_org_id
3134: AND t.intent = p_intent
3135: AND t.template_id = NVL(p_template_id, template_id)
3136: AND t.contract_expert_enabled = 'Y'

Line 3141: l_template_id okc_terms_templates_all.template_id%TYPE;

3137: AND t.status_code IN ('APPROVED','ON_HOLD') ;
3138:
3139:
3140: l_api_name CONSTANT VARCHAR2(30) := 'rebuild_tmpl_pub_disable';
3141: l_template_id okc_terms_templates_all.template_id%TYPE;
3142:
3143:
3144: BEGIN
3145: -- start debug log