APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on CZ_DEVL_PROJECTS

Line 717: FROM cz_devl_projects

713: */
714: CURSOR csr_template_model_id(p_orig_sys_ref IN VARCHAR2) IS
715: SELECT devl_project_id ,
716: orig_sys_ref
717: FROM cz_devl_projects
718: WHERE orig_sys_ref = p_orig_sys_ref
719: AND devl_project_id = persistent_project_id
720: AND deleted_flag = 0 ;
721:

Line 746: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
743: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
744:
745: l_cz_imp_rules cz_imp_rules%ROWTYPE;
746: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
747:
748: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
749: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;
750:

Line 748: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;

744:
745: l_cz_imp_rules cz_imp_rules%ROWTYPE;
746: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
747:
748: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
749: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;
750:
751:
752: BEGIN

Line 749: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;

745: l_cz_imp_rules cz_imp_rules%ROWTYPE;
746: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
747:
748: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
749: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;
750:
751:
752: BEGIN
753: -- start debug log

Line 1862: FROM cz_devl_projects

1858: RETURN VARCHAR2 IS
1859:
1860: CURSOR csr_check_var_model IS
1861: SELECT devl_project_id
1862: FROM cz_devl_projects
1863: WHERE orig_sys_ref = G_VARIABLE_MODEL_OSR||p_intent
1864: AND devl_project_id = persistent_project_id
1865: AND deleted_flag = 0;
1866:

Line 1870: FROM cz_devl_projects

1866:
1867: --Added for R12
1868: CURSOR csr_check_cla_model IS
1869: SELECT devl_project_id
1870: FROM cz_devl_projects
1871: WHERE orig_sys_ref = G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent
1872: AND devl_project_id = persistent_project_id
1873: AND deleted_flag = 0;
1874:

Line 1935: FROM cz_devl_projects

1931: WHERE r.request_id = fnd_global.conc_request_id;
1932:
1933: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
1934: SELECT devl_project_id, orig_sys_ref
1935: FROM cz_devl_projects
1936: WHERE orig_sys_ref = G_VARIABLE_MODEL_OSR||l_intent
1937: AND devl_project_id = persistent_project_id
1938: AND deleted_flag = 0;
1939:

Line 1943: FROM cz_devl_projects

1939:
1940: -- Added new cursor for attaching extension rule to Clause model from R12
1941: CURSOR csr_get_cla_model_dtl (l_org_id NUMBER, l_intent VARCHAR2) IS
1942: SELECT devl_project_id, orig_sys_ref
1943: FROM cz_devl_projects
1944: WHERE orig_sys_ref = G_CLAUSE_MODEL_OSR||to_char(l_org_id)||':'||l_intent
1945: AND devl_project_id = persistent_project_id
1946: AND deleted_flag = 0;
1947:

Line 2374: FROM cz_devl_projects

2370: WHERE t.template_id = p_template_id;
2371:
2372: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
2373: SELECT devl_project_id, orig_sys_ref
2374: FROM cz_devl_projects
2375: WHERE orig_sys_ref = G_VARIABLE_MODEL_OSR||l_intent
2376: AND devl_project_id = persistent_project_id
2377: AND deleted_flag = 0;
2378:

Line 2382: FROM cz_devl_projects

2378:
2379: -- Added new cursor for attaching extension rule to Clause model from R12
2380: CURSOR csr_get_cla_model_dtl (l_org_id NUMBER, l_intent VARCHAR2) IS
2381: SELECT devl_project_id, orig_sys_ref
2382: FROM cz_devl_projects
2383: WHERE orig_sys_ref = G_CLAUSE_MODEL_OSR||l_org_id||':'||l_intent
2384: AND devl_project_id = persistent_project_id
2385: AND deleted_flag = 0;
2386: