APPS.CZ_PB_MGR dependencies on CZ_UI_COLLECT_TMPLS_V

Line 8431: FROM cz_ui_collect_tmpls_v

8427: IF cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 AND cz_pb_mgr.v_session_parameter <> model_copy THEN
8428: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
8429: l_temp_tbl.DELETE;
8430: SELECT template_id BULK COLLECT INTO l_temp_tbl
8431: FROM cz_ui_collect_tmpls_v
8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
8433: AND cz_ui_collect_tmpls_v.template_id IN
8434: (SELECT template_id
8435: FROM cz_ui_templates

Line 8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)

8428: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
8429: l_temp_tbl.DELETE;
8430: SELECT template_id BULK COLLECT INTO l_temp_tbl
8431: FROM cz_ui_collect_tmpls_v
8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
8433: AND cz_ui_collect_tmpls_v.template_id IN
8434: (SELECT template_id
8435: FROM cz_ui_templates
8436: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'

Line 8433: AND cz_ui_collect_tmpls_v.template_id IN

8429: l_temp_tbl.DELETE;
8430: SELECT template_id BULK COLLECT INTO l_temp_tbl
8431: FROM cz_ui_collect_tmpls_v
8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
8433: AND cz_ui_collect_tmpls_v.template_id IN
8434: (SELECT template_id
8435: FROM cz_ui_templates
8436: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
8437: AND cz_ui_templates.ui_def_id = 0);

Line 17074: FROM cz_ui_collect_tmpls_v

17070: l_global_temp_tbl.DELETE;
17071:
17072: SELECT template_id
17073: BULK COLLECT INTO l_global_temp_tbl
17074: FROM cz_ui_collect_tmpls_v
17075: WHERE cz_ui_collect_tmpls_v.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_ui_collect_tmpls_v.ui_def_id = 0;
17076:
17077: IF (l_global_temp_tbl.COUNT > 0)
17078: THEN

Line 17075: WHERE cz_ui_collect_tmpls_v.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_ui_collect_tmpls_v.ui_def_id = 0;

17071:
17072: SELECT template_id
17073: BULK COLLECT INTO l_global_temp_tbl
17074: FROM cz_ui_collect_tmpls_v
17075: WHERE cz_ui_collect_tmpls_v.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_ui_collect_tmpls_v.ui_def_id = 0;
17076:
17077: IF (l_global_temp_tbl.COUNT > 0)
17078: THEN
17079: rec_count := cz_pb_mgr.g_ui_templates_old_temp_id_ref.COUNT;