APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on CZ_DEVL_PROJECTS

Line 731: FROM cz_devl_projects

727: */
728: CURSOR csr_template_model_id(p_orig_sys_ref IN VARCHAR2) IS
729: SELECT devl_project_id ,
730: orig_sys_ref
731: FROM cz_devl_projects
732: WHERE orig_sys_ref = p_orig_sys_ref
733: AND devl_project_id = persistent_project_id
734: AND deleted_flag = 0 ;
735:

Line 760: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

756: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
757: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
758:
759: l_cz_imp_rules cz_imp_rules%ROWTYPE;
760: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
761:
762: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
763: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;
764:

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

758:
759: l_cz_imp_rules cz_imp_rules%ROWTYPE;
760: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
761:
762: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
763: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;
764:
765:
766: BEGIN

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

759: l_cz_imp_rules cz_imp_rules%ROWTYPE;
760: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
761:
762: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
763: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;
764:
765:
766: BEGIN
767: -- start debug log

Line 1876: FROM cz_devl_projects

1872: RETURN VARCHAR2 IS
1873:
1874: CURSOR csr_check_var_model IS
1875: SELECT devl_project_id
1876: FROM cz_devl_projects
1877: WHERE orig_sys_ref = G_VARIABLE_MODEL_OSR||p_intent
1878: AND devl_project_id = persistent_project_id
1879: AND deleted_flag = 0;
1880:

Line 1884: FROM cz_devl_projects

1880:
1881: --Added for R12
1882: CURSOR csr_check_cla_model IS
1883: SELECT devl_project_id
1884: FROM cz_devl_projects
1885: WHERE orig_sys_ref = G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent
1886: AND devl_project_id = persistent_project_id
1887: AND deleted_flag = 0;
1888:

Line 1949: FROM cz_devl_projects

1945: WHERE r.request_id = fnd_global.conc_request_id;
1946:
1947: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
1948: SELECT devl_project_id, orig_sys_ref
1949: FROM cz_devl_projects
1950: WHERE orig_sys_ref = G_VARIABLE_MODEL_OSR||l_intent
1951: AND devl_project_id = persistent_project_id
1952: AND deleted_flag = 0;
1953:

Line 1957: FROM cz_devl_projects

1953:
1954: -- Added new cursor for attaching extension rule to Clause model from R12
1955: CURSOR csr_get_cla_model_dtl (l_org_id NUMBER, l_intent VARCHAR2) IS
1956: SELECT devl_project_id, orig_sys_ref
1957: FROM cz_devl_projects
1958: WHERE orig_sys_ref = G_CLAUSE_MODEL_OSR||to_char(l_org_id)||':'||l_intent
1959: AND devl_project_id = persistent_project_id
1960: AND deleted_flag = 0;
1961:

Line 2388: FROM cz_devl_projects

2384: WHERE t.template_id = p_template_id;
2385:
2386: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
2387: SELECT devl_project_id, orig_sys_ref
2388: FROM cz_devl_projects
2389: WHERE orig_sys_ref = G_VARIABLE_MODEL_OSR||l_intent
2390: AND devl_project_id = persistent_project_id
2391: AND deleted_flag = 0;
2392:

Line 2396: FROM cz_devl_projects

2392:
2393: -- Added new cursor for attaching extension rule to Clause model from R12
2394: CURSOR csr_get_cla_model_dtl (l_org_id NUMBER, l_intent VARCHAR2) IS
2395: SELECT devl_project_id, orig_sys_ref
2396: FROM cz_devl_projects
2397: WHERE orig_sys_ref = G_CLAUSE_MODEL_OSR||l_org_id||':'||l_intent
2398: AND devl_project_id = persistent_project_id
2399: AND deleted_flag = 0;
2400: