APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_MODEL_PUBLICATIONS

Line 577: FROM cz_model_publications

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

Line 666: CZ Publication Process (cz_model_publications)

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

Line 714: FROM cz_model_publications

710: FROM cz_ui_defs
711: WHERE devl_project_id = p_model_id
712: AND deleted_flag = '0'
713: AND ui_def_id NOT IN ( SELECT ui_def_id
714: FROM cz_model_publications
715: WHERE model_id = p_model_id
716: AND publication_mode = G_PRODUCTION_MODE
717: AND deleted_flag = '0'
718: AND source_target_flag = 'S'

Line 1825: FROM cz_model_publications

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

Line 1835: l_publication_id cz_model_publications.publication_id%TYPE;

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

Line 1836: l_ui_def_id cz_model_publications.ui_def_id%TYPE;

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