DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_UI_DEFS

Line 708: FROM cz_ui_defs

704:
705: -- UIs for the template not attached to Production publication
706: CURSOR csr_template_ui(p_model_id IN NUMBER) IS
707: SELECT ui_def_id
708: FROM cz_ui_defs
709: WHERE devl_project_id = p_model_id
710: AND deleted_flag = '0'
711: AND ui_def_id NOT IN ( SELECT ui_def_id
712: FROM cz_model_publications

Line 725: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;

721: l_api_version CONSTANT NUMBER := 1;
722: l_api_name CONSTANT VARCHAR2(30) := 'create_test_publication';
723: l_template_id okc_terms_templates_all.template_id%TYPE;
724: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
725: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
726: l_new_ui_def_id cz_ui_defs.ui_def_id%TYPE;
727: l_run_id NUMBER;
728: l_publication_id NUMBER;
729:

Line 726: l_new_ui_def_id cz_ui_defs.ui_def_id%TYPE;

722: l_api_name CONSTANT VARCHAR2(30) := 'create_test_publication';
723: l_template_id okc_terms_templates_all.template_id%TYPE;
724: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
725: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
726: l_new_ui_def_id cz_ui_defs.ui_def_id%TYPE;
727: l_run_id NUMBER;
728: l_publication_id NUMBER;
729:
730: