[Home] [Help]
5292:
5293: BEGIN
5294: SELECT template_id, ref_template_id, template_ui_def_id, ref_template_ui_def_id
5295: BULK COLLECT INTO l_template_id_tbl, l_ref_template_id_tbl, l_template_ui_tbl, l_ref_templ_ui_tbl
5296: FROM cz_ui_ref_templates
5297: WHERE cz_ui_ref_templates.template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i) AND cz_ui_ref_templates.deleted_flag = '0';
5298: EXCEPTION
5299: WHEN NO_DATA_FOUND
5300: THEN
5293: BEGIN
5294: SELECT template_id, ref_template_id, template_ui_def_id, ref_template_ui_def_id
5295: BULK COLLECT INTO l_template_id_tbl, l_ref_template_id_tbl, l_template_ui_tbl, l_ref_templ_ui_tbl
5296: FROM cz_ui_ref_templates
5297: WHERE cz_ui_ref_templates.template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i) AND cz_ui_ref_templates.deleted_flag = '0';
5298: EXCEPTION
5299: WHEN NO_DATA_FOUND
5300: THEN
5301: NULL;
5334: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_TEMPLATE_UI_ref';
5335: rec_count := rec_count + 1;
5336: plsql_table_list(rec_count).col_name := 'ref_template_ui_def_id';
5337: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_REF_TEMPL_UI_ref';
5338: insert_into_table('CZ_UI_REF_TEMPLATES'
5339: ,'template_id'
5340: ,'ref_template_id'
5341: ,cz_pb_mgr.v_db_link
5342: ,plsql_table_list
6505: delete_from_table('cz_ui_page_refs','ui_def_id','page_set_id','page_ref_id',v_database_link,'cz_pb_mgr.g_page_refs_ui_def_new_ref','cz_pb_mgr.g_page_refs_pg_set_ref','cz_pb_mgr.g_page_refs_pg_ref_ref',cz_pb_mgr.g_page_refs_ui_def_new_ref);
6506: delete_from_table('cz_ui_page_sets','ui_def_id','page_set_id',v_database_link,'cz_pb_mgr.g_page_sets_ui_ref','cz_pb_mgr.g_page_sets_pg_tbl',cz_pb_mgr.g_page_sets_ui_ref);
6507: delete_from_table('cz_ui_refs','ui_def_id','model_ref_expl_id',v_database_link,'cz_pb_mgr.g_ui_refs_new_ui_def_ref','cz_pb_mgr.g_ui_refs_expl_id_ref',cz_pb_mgr.g_ui_refs_new_ui_def_ref);
6508: delete_from_table('cz_ui_cont_type_templs','ui_def_id','content_type',v_database_link,'cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref','cz_pb_mgr.l_cnt_typ_tmpls_cont_ref',cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref);
6509: delete_from_table('cz_ui_ref_templates','template_id','template_ui_def_id',
6510: 'ref_template_id','ref_template_ui_def_id',v_database_link,'cz_pb_mgr.g_TEMPLATE_ID_ref','cz_pb_mgr.g_TEMPLATE_UI_ref',
6511: 'cz_pb_mgr.g_REF_TEMPLATE_ID_ref','cz_pb_mgr.g_REF_TEMPL_UI_ref',cz_pb_mgr.g_TEMPLATE_ID_ref);
6512: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);
6513: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_ref);
8445: IF l_rec_count > 0 THEN
8446: FOR i IN 1 .. l_rec_count LOOP
8447: l_temp_tbl.DELETE;
8448: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
8449: FROM cz_ui_ref_templates
8450: WHERE cz_ui_ref_templates.deleted_flag = '0'
8451: AND cz_ui_ref_templates.seeded_flag = '0'
8452: AND cz_ui_ref_templates.ref_template_id IN
8453: (SELECT template_id
8446: FOR i IN 1 .. l_rec_count LOOP
8447: l_temp_tbl.DELETE;
8448: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
8449: FROM cz_ui_ref_templates
8450: WHERE cz_ui_ref_templates.deleted_flag = '0'
8451: AND cz_ui_ref_templates.seeded_flag = '0'
8452: AND cz_ui_ref_templates.ref_template_id IN
8453: (SELECT template_id
8454: FROM cz_ui_templates t
8447: l_temp_tbl.DELETE;
8448: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
8449: FROM cz_ui_ref_templates
8450: WHERE cz_ui_ref_templates.deleted_flag = '0'
8451: AND cz_ui_ref_templates.seeded_flag = '0'
8452: AND cz_ui_ref_templates.ref_template_id IN
8453: (SELECT template_id
8454: FROM cz_ui_templates t
8455: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
8448: SELECT ref_template_id BULK COLLECT INTO l_temp_tbl
8449: FROM cz_ui_ref_templates
8450: WHERE cz_ui_ref_templates.deleted_flag = '0'
8451: AND cz_ui_ref_templates.seeded_flag = '0'
8452: AND cz_ui_ref_templates.ref_template_id IN
8453: (SELECT template_id
8454: FROM cz_ui_templates t
8455: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
8456: START WITH cz_ui_ref_templates.template_id = l_new_tmpl_tbl(i)
8452: AND cz_ui_ref_templates.ref_template_id IN
8453: (SELECT template_id
8454: FROM cz_ui_templates t
8455: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
8456: START WITH cz_ui_ref_templates.template_id = l_new_tmpl_tbl(i)
8457: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
8458: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';
8459:
8460: check_template_status(l_temp_tbl);
8453: (SELECT template_id
8454: FROM cz_ui_templates t
8455: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
8456: START WITH cz_ui_ref_templates.template_id = l_new_tmpl_tbl(i)
8457: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
8458: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';
8459:
8460: check_template_status(l_temp_tbl);
8461: END LOOP;
8454: FROM cz_ui_templates t
8455: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
8456: START WITH cz_ui_ref_templates.template_id = l_new_tmpl_tbl(i)
8457: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
8458: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';
8459:
8460: check_template_status(l_temp_tbl);
8461: END LOOP;
8462: END IF;
10949: ('cz_ui_nodes.ui_def_ref_id'
10950: ,'cz_ui_refs.ref_ui_def_id'
10951: ,'cz_ui_page_refs.target_ui_def_id'
10952: ,'cz_ui_page_elements.target_page_ui_def_id'
10953: ,'cz_ui_ref_templates.ref_template_ui_def_id'
10954: ,'cz_ui_actions.target_ui_def_id'
10955: )
10956: )
10957: THEN