APPS.CZ_PB_MGR dependencies on CZ_UI_COLLECT_TMPLS_V

Line 9161: FROM cz_ui_collect_tmpls_v

9157: IF cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 AND cz_pb_mgr.v_session_parameter <> model_copy THEN
9158: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
9159: l_temp_tbl.DELETE;
9160: SELECT template_id BULK COLLECT INTO l_temp_tbl
9161: FROM cz_ui_collect_tmpls_v
9162: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
9163: AND cz_ui_collect_tmpls_v.template_id IN
9164: (SELECT template_id
9165: FROM cz_ui_templates

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

9158: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST LOOP
9159: l_temp_tbl.DELETE;
9160: SELECT template_id BULK COLLECT INTO l_temp_tbl
9161: FROM cz_ui_collect_tmpls_v
9162: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
9163: AND cz_ui_collect_tmpls_v.template_id IN
9164: (SELECT template_id
9165: FROM cz_ui_templates
9166: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'

Line 9163: AND cz_ui_collect_tmpls_v.template_id IN

9159: l_temp_tbl.DELETE;
9160: SELECT template_id BULK COLLECT INTO l_temp_tbl
9161: FROM cz_ui_collect_tmpls_v
9162: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
9163: AND cz_ui_collect_tmpls_v.template_id IN
9164: (SELECT template_id
9165: FROM cz_ui_templates
9166: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
9167: AND cz_ui_templates.ui_def_id = 0);

Line 18217: FROM cz_ui_collect_tmpls_v

18213: l_global_temp_tbl.DELETE;
18214:
18215: SELECT template_id
18216: BULK COLLECT INTO l_global_temp_tbl
18217: FROM cz_ui_collect_tmpls_v
18218: 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;
18219:
18220: IF (l_global_temp_tbl.COUNT > 0)
18221: THEN

Line 18218: 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;

18214:
18215: SELECT template_id
18216: BULK COLLECT INTO l_global_temp_tbl
18217: FROM cz_ui_collect_tmpls_v
18218: 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;
18219:
18220: IF (l_global_temp_tbl.COUNT > 0)
18221: THEN
18222: rec_count := cz_pb_mgr.g_ui_templates_old_temp_id_ref.COUNT;