APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_MODEL_PUBLICATIONS

Line 575: FROM cz_model_publications

571: ) IS
572:
573: CURSOR csr_get_publication_dtl IS
574: SELECT publication_id
575: FROM cz_model_publications
576: WHERE model_id = p_devl_project_id
577: AND deleted_flag = '0'
578: AND publication_mode ='t'
579: AND source_target_flag = 'S'; -- only delete 'S' and never 'T'

Line 664: CZ Publication Process (cz_model_publications)

660: END delete_test_publications;
661:
662:
663: /*
664: CZ Publication Process (cz_model_publications)
665: rec# publication_mode source_target_flag
666: create test publication 1 t S
667: publish test pub 2 t T ( new record created)
668:

Line 712: FROM cz_model_publications

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
713: WHERE model_id = p_model_id
714: AND publication_mode = G_PRODUCTION_MODE
715: AND deleted_flag = '0'
716: AND source_target_flag = 'S'

Line 1823: FROM cz_model_publications

1819:
1820: CURSOR csr_get_publication_id (p_template_model_id NUMBER, p_publication_mode VARCHAR2) IS
1821: SELECT publication_id ,
1822: ui_def_id
1823: FROM cz_model_publications
1824: WHERE model_id = p_template_model_id
1825: AND deleted_flag = '0'
1826: AND publication_mode = p_publication_mode
1827: AND source_target_flag = 'S';

Line 1833: l_publication_id cz_model_publications.publication_id%TYPE;

1829: l_api_version CONSTANT NUMBER := 1;
1830: l_api_name CONSTANT VARCHAR2(30) := 'create_production_publication';
1831: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
1832: l_run_id NUMBER;
1833: l_publication_id cz_model_publications.publication_id%TYPE;
1834: l_ui_def_id cz_model_publications.ui_def_id%TYPE;
1835: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1836: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
1837:

Line 1834: l_ui_def_id cz_model_publications.ui_def_id%TYPE;

1830: l_api_name CONSTANT VARCHAR2(30) := 'create_production_publication';
1831: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
1832: l_run_id NUMBER;
1833: l_publication_id cz_model_publications.publication_id%TYPE;
1834: l_ui_def_id cz_model_publications.ui_def_id%TYPE;
1835: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1836: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
1837:
1838: --Bug 5032199 Using REF cursor