[Home] [Help]
35:
36: -- special fields in id resolution
37: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
38: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
39: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
40: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
41: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';
42: FLD_UI_NODE_REF_ID CONSTANT VARCHAR2(9) := 'UINREFID';
43: FLD_IGNORE_NOW CONSTANT VARCHAR2(9) := 'IGNOREID';
211: cz_pb_mgr.v_arg_sig_old_tbl.DELETE;
212: cz_pb_mgr.v_arg_sig_tbl.DELETE;
213: cz_pb_mgr.v_data_sig_tbl.DELETE;
214: cz_pb_mgr.g_page_sets_jrad_doc_ref.DELETE;
215: cz_pb_mgr.v_cz_ui_nodes_idx_ref.DELETE;
216: cz_pb_mgr.l_cnt_typ_tmpls_cont_ref.DELETE;
217: cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref.DELETE;
218: cz_pb_mgr.l_ui_images_ui_ref.DELETE;
219: cz_pb_mgr.l_ui_images_enty_tbl.DELETE;
357: cz_pb_mgr.v_ui_defs_mcpt_rule_ref.DELETE;
358: cz_pb_mgr.v_ui_defs_pcpt_rule_ref.DELETE;
359: cz_pb_mgr.v_master_template_id_ref.DELETE;
360: END IF;
361: ELSIF(p_table_name = 'cz_ui_nodes')
362: THEN
363: IF (p_table_type = 'ref')
364: THEN
365: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
361: ELSIF(p_table_name = 'cz_ui_nodes')
362: THEN
363: IF (p_table_type = 'ref')
364: THEN
365: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
366: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
367: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
362: THEN
363: IF (p_table_type = 'ref')
364: THEN
365: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
366: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
367: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
363: IF (p_table_type = 'ref')
364: THEN
365: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
366: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
367: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
364: THEN
365: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
366: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
367: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
365: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
366: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
367: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
366: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
367: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
374: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
367: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
374: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
375: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
368: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
374: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
375: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
376: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
369: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
374: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
375: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
376: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
377: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
370: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
374: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
375: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
376: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
377: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
378: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
371: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
374: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
375: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
376: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
377: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
378: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
379: END IF;
372: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
373: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
374: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
375: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
376: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
377: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
378: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
379: END IF;
380: ELSIF(p_table_name = 'cz_ps_prop_vals')
7188: -- ,cz_pb_mgr.v_models_to_be_exported_new
7189: -- );
7190: delete_from_table('cz_ui_defs', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7191: delete_from_table('cz_ui_properties', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7192: delete_from_table('cz_ui_nodes', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7193: delete_from_table('cz_ui_node_props', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7194: delete_from_table('cz_model_ref_expls'
7195: ,'model_ref_expl_id'
7196: ,v_database_link
7189: -- );
7190: delete_from_table('cz_ui_defs', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7191: delete_from_table('cz_ui_properties', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7192: delete_from_table('cz_ui_nodes', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7193: delete_from_table('cz_ui_node_props', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7194: delete_from_table('cz_model_ref_expls'
7195: ,'model_ref_expl_id'
7196: ,v_database_link
7197: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
7736:
7737: BEGIN
7738: SELECT DISTINCT ui_def_ref_id
7739: BULK COLLECT INTO v_src_uis_tbl
7740: FROM cz_ui_nodes
7741: WHERE cz_ui_nodes.ui_def_id IN(
7742: SELECT cz_ui_defs.ui_def_id
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7737: BEGIN
7738: SELECT DISTINCT ui_def_ref_id
7739: BULK COLLECT INTO v_src_uis_tbl
7740: FROM cz_ui_nodes
7741: WHERE cz_ui_nodes.ui_def_id IN(
7742: SELECT cz_ui_defs.ui_def_id
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7742: SELECT cz_ui_defs.ui_def_id
7743: FROM cz_ui_defs
7744: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7745: AND cz_ui_defs.NAME <> 'MUID')
7746: AND cz_ui_nodes.ui_def_ref_id IN(
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7750: AND cz_ui_defs.NAME <> 'MUID')
7747: SELECT cz_ui_defs.ui_def_id
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7750: AND cz_ui_defs.NAME <> 'MUID')
7751: AND cz_ui_nodes.deleted_flag = '0'
7752: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7753: EXCEPTION
7754: WHEN OTHERS
7755: THEN
7748: FROM cz_ui_defs
7749: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7750: AND cz_ui_defs.NAME <> 'MUID')
7751: AND cz_ui_nodes.deleted_flag = '0'
7752: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7753: EXCEPTION
7754: WHEN OTHERS
7755: THEN
7756: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
7783: ----procedure that returns the max last_update_date of ui schema
7784: PROCEDURE get_max_ui_date(p_ui_def_id IN cz_model_publications.ui_def_id%TYPE, x_max_update_date IN OUT NOCOPY DATE)
7785: AS
7786: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7787: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7788: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7789: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7790: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7791: v_initialized_date DATE;
7784: PROCEDURE get_max_ui_date(p_ui_def_id IN cz_model_publications.ui_def_id%TYPE, x_max_update_date IN OUT NOCOPY DATE)
7785: AS
7786: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7787: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7788: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7789: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7790: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7791: v_initialized_date DATE;
7792: v_ui_pages_date DATE;
7785: AS
7786: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7787: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7788: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7789: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7790: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7791: v_initialized_date DATE;
7792: v_ui_pages_date DATE;
7793: v_ui_pages_capt_date DATE;
7786: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7787: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7788: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7789: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7790: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7791: v_initialized_date DATE;
7792: v_ui_pages_date DATE;
7793: v_ui_pages_capt_date DATE;
7794: v_ui_page_sets_date DATE;
7810:
7811: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7812: IS
7813: SELECT last_update_date
7814: FROM cz_ui_nodes
7815: WHERE cz_ui_nodes.ui_def_id = node_ui_def_id AND cz_ui_nodes.deleted_flag = '0'
7816: ORDER BY last_update_date DESC;
7817:
7818: CURSOR ui_properties_cur(prop_ui_def_id NUMBER)
7811: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7812: IS
7813: SELECT last_update_date
7814: FROM cz_ui_nodes
7815: WHERE cz_ui_nodes.ui_def_id = node_ui_def_id AND cz_ui_nodes.deleted_flag = '0'
7816: ORDER BY last_update_date DESC;
7817:
7818: CURSOR ui_properties_cur(prop_ui_def_id NUMBER)
7819: IS
7833: IS
7834: SELECT last_update_date
7835: FROM cz_intl_texts
7836: WHERE intl_text_id IN(SELECT f.tool_tip_id
7837: FROM cz_ui_nodes f
7838: WHERE f.ui_def_id = p_ui_def_id AND f.deleted_flag = '0'
7839: UNION
7840: SELECT g.caption_id
7841: FROM cz_ui_nodes g
7837: FROM cz_ui_nodes f
7838: WHERE f.ui_def_id = p_ui_def_id AND f.deleted_flag = '0'
7839: UNION
7840: SELECT g.caption_id
7841: FROM cz_ui_nodes g
7842: WHERE g.ui_def_id = p_ui_def_id AND g.deleted_flag = '0')
7843: ORDER BY last_update_date DESC;
7844:
7845: CURSOR ui_pages_cur(ui_pages_def_id NUMBER)
8331: --------procedure that checks if logic has changed since the model was last published
8332: PROCEDURE chk_if_logic_changed(p_model_array IN cz_pb_mgr.t_ref, p_last_xfr_date IN DATE, x_record_count IN OUT NOCOPY NUMBER)
8333: AS
8334: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
8335: v_expr_node_date cz_ui_nodes.last_update_date%TYPE;
8336: BEGIN
8337: IF (p_model_array.COUNT > 0)
8338: THEN
8339: FOR i IN p_model_array.FIRST .. p_model_array.LAST
11701: ,cz_pb_mgr.v_server_id
11702: ,cz_pb_mgr.v_status_code
11703: );
11704: ELSIF(p_column_name IN
11705: ('cz_ui_nodes.ui_def_ref_id'
11706: ,'cz_ui_refs.ref_ui_def_id'
11707: ,'cz_ui_page_refs.target_ui_def_id'
11708: ,'cz_ui_page_elements.target_page_ui_def_id'
11709: ,'cz_ui_ref_templates.ref_template_ui_def_id'
12146: END IF;
12147: END get_uis_of_mdls_not_exported;
12148:
12149: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12150: --------Procedure to resolve remote ui nodes of cz_ui_nodes
12151: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
12152: PROCEDURE resolve_remote_ui_nodes(
12153: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
12154: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
12147: END get_uis_of_mdls_not_exported;
12148:
12149: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12150: --------Procedure to resolve remote ui nodes of cz_ui_nodes
12151: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
12152: PROCEDURE resolve_remote_ui_nodes(
12153: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
12154: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
12155: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
12149: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12150: --------Procedure to resolve remote ui nodes of cz_ui_nodes
12151: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
12152: PROCEDURE resolve_remote_ui_nodes(
12153: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
12154: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
12155: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
12156: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
12157: ,x_status IN OUT NOCOPY VARCHAR2
12151: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
12152: PROCEDURE resolve_remote_ui_nodes(
12153: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
12154: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
12155: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
12156: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
12157: ,x_status IN OUT NOCOPY VARCHAR2
12158: )
12159: AS
12230:
12231: BEGIN
12232: SELECT ui_node_id, ui_def_id, persistent_ui_node_id
12233: BULK COLLECT INTO v_remote_ui_nodes_tbl, v_remote_ui_nod_ui_def_tbl, v_remote_pers_ui_node_tbl
12234: FROM cz_ui_nodes
12235: WHERE cz_ui_nodes.ui_def_id = v_remote_ui_defs_ref(i) AND cz_ui_nodes.deleted_flag = '0'
12236: ORDER BY cz_ui_nodes.ui_node_id;
12237: EXCEPTION
12238: WHEN NO_DATA_FOUND
12231: BEGIN
12232: SELECT ui_node_id, ui_def_id, persistent_ui_node_id
12233: BULK COLLECT INTO v_remote_ui_nodes_tbl, v_remote_ui_nod_ui_def_tbl, v_remote_pers_ui_node_tbl
12234: FROM cz_ui_nodes
12235: WHERE cz_ui_nodes.ui_def_id = v_remote_ui_defs_ref(i) AND cz_ui_nodes.deleted_flag = '0'
12236: ORDER BY cz_ui_nodes.ui_node_id;
12237: EXCEPTION
12238: WHEN NO_DATA_FOUND
12239: THEN
12232: SELECT ui_node_id, ui_def_id, persistent_ui_node_id
12233: BULK COLLECT INTO v_remote_ui_nodes_tbl, v_remote_ui_nod_ui_def_tbl, v_remote_pers_ui_node_tbl
12234: FROM cz_ui_nodes
12235: WHERE cz_ui_nodes.ui_def_id = v_remote_ui_defs_ref(i) AND cz_ui_nodes.deleted_flag = '0'
12236: ORDER BY cz_ui_nodes.ui_node_id;
12237: EXCEPTION
12238: WHEN NO_DATA_FOUND
12239: THEN
12240: cz_pb_mgr.v_err_message := 'No ui_node_ids found ';
12283: CLOSE l_ui_def_cur;
12284:
12285: OPEN ui_def_ref_id_cv FOR 'SELECT ui_node_id'
12286: || ' '
12287: || 'FROM cz_ui_nodes'
12288: || cz_pb_mgr.v_db_link
12289: || ' t'
12290: || ' '
12291: || 'WHERE t.persistent_ui_node_id = :pers_ui_node_id'
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
14986: l_prop_node_tbl.DELETE;
14987:
14988: SELECT DISTINCT prop.ui_node_id
14989: BULK COLLECT INTO l_prop_node_tbl
14990: FROM cz_ui_node_props prop, cz_ui_nodes node
14991: WHERE prop.ui_def_id = node.ui_def_id
14992: AND prop.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
14993: AND node.ui_node_id = prop.ui_node_id
14994: AND node.deleted_flag = record_not_deleted
15011: END IF;
15012:
15013: IF cz_pb_mgr.g_ui_node_prop_new_node_tbl.COUNT > 0
15014: THEN
15015: resolve_ids(cz_pb_mgr.g_ui_node_prop_new_node_tbl, cz_pb_mgr.v_cz_ui_nodes_idx_ref, 'ui node ids of ui node props');
15016: resolve_ids(cz_pb_mgr.g_ui_node_prop_new_uidf_tbl, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui node props');
15017: l_plsql_table_list(1).col_name := 'ui_node_id';
15018: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_ui_node_prop_new_node_tbl';
15019: l_plsql_table_list(2).col_name := 'ui_def_id';
15212: v_cz_ui_defs_old_tbl cz_pb_mgr.t_ref;
15213: v_ui_devl_id_tbl cz_pb_mgr.t_ref;
15214: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
15215: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
15216: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
15217: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
15218: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15213: v_ui_devl_id_tbl cz_pb_mgr.t_ref;
15214: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
15215: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
15216: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
15217: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
15218: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15214: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
15215: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
15216: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
15217: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
15218: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15215: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
15216: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
15217: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
15218: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15216: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
15217: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
15218: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15217: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
15218: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15225: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
15218: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15225: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
15226: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
15219: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15225: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
15226: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
15227: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
15220: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15225: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
15226: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
15227: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
15228: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
15221: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15225: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
15226: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
15227: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
15228: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
15229: v_page_capt_rule_tbl cz_pb_mgr.t_ref;
15222: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15225: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
15226: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
15227: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
15228: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
15229: v_page_capt_rule_tbl cz_pb_mgr.t_ref;
15230: l_from_mt_id_tbl cz_pb_mgr.t_ref;
15223: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
15224: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
15225: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
15226: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
15227: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
15228: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
15229: v_page_capt_rule_tbl cz_pb_mgr.t_ref;
15230: l_from_mt_id_tbl cz_pb_mgr.t_ref;
15231: BEGIN
15477: THEN
15478: log_timing_message('end insert_into_table cz_ui_properties');
15479: END IF;
15480:
15481: ----------insert ids of cz_ui_nodes
15482: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
15483:
15484: IF (cz_pb_mgr.g_log_timing = publication_timing)
15485: THEN
15478: log_timing_message('end insert_into_table cz_ui_properties');
15479: END IF;
15480:
15481: ----------insert ids of cz_ui_nodes
15482: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
15483:
15484: IF (cz_pb_mgr.g_log_timing = publication_timing)
15485: THEN
15486: log_timing_message('start bulk collect of cz_ui_nodes');
15482: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
15483:
15484: IF (cz_pb_mgr.g_log_timing = publication_timing)
15485: THEN
15486: log_timing_message('start bulk collect of cz_ui_nodes');
15487: END IF;
15488:
15489: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
15490: THEN
15489: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
15490: THEN
15491: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15492: LOOP
15493: v_cz_ui_nodes_new_tbl.DELETE;
15494: v_cz_ui_nodes_old_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15490: THEN
15491: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15492: LOOP
15493: v_cz_ui_nodes_new_tbl.DELETE;
15494: v_cz_ui_nodes_old_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15491: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
15492: LOOP
15493: v_cz_ui_nodes_new_tbl.DELETE;
15494: v_cz_ui_nodes_old_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15492: LOOP
15493: v_cz_ui_nodes_new_tbl.DELETE;
15494: v_cz_ui_nodes_old_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15493: v_cz_ui_nodes_new_tbl.DELETE;
15494: v_cz_ui_nodes_old_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15494: v_cz_ui_nodes_old_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15502: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15495: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15502: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15503: v_cz_ui_nodes_capt_id_tbl.DELETE;
15496: v_cz_ui_nodes_parent_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15502: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15503: v_cz_ui_nodes_capt_id_tbl.DELETE;
15504: v_cz_ui_nodes_tool_id_tbl.DELETE;
15497: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15502: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15503: v_cz_ui_nodes_capt_id_tbl.DELETE;
15504: v_cz_ui_nodes_tool_id_tbl.DELETE;
15505:
15498: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15502: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15503: v_cz_ui_nodes_capt_id_tbl.DELETE;
15504: v_cz_ui_nodes_tool_id_tbl.DELETE;
15505:
15506: BEGIN
15499: v_cz_ui_nodes_component_id_tbl.DELETE;
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15502: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15503: v_cz_ui_nodes_capt_id_tbl.DELETE;
15504: v_cz_ui_nodes_tool_id_tbl.DELETE;
15505:
15506: BEGIN
15507: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
15500: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15501: v_cz_ui_nodes_expl_id_tbl.DELETE;
15502: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15503: v_cz_ui_nodes_capt_id_tbl.DELETE;
15504: v_cz_ui_nodes_tool_id_tbl.DELETE;
15505:
15506: BEGIN
15507: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
15508: , 'cz_ui_nodes_s.nextval' || cz_pb_mgr.v_db_link
15503: v_cz_ui_nodes_capt_id_tbl.DELETE;
15504: v_cz_ui_nodes_tool_id_tbl.DELETE;
15505:
15506: BEGIN
15507: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
15508: , 'cz_ui_nodes_s.nextval' || cz_pb_mgr.v_db_link
15509: ,cz_pb_mgr.v_oraclesequenceincr
15510: )
15511: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
15504: v_cz_ui_nodes_tool_id_tbl.DELETE;
15505:
15506: BEGIN
15507: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
15508: , 'cz_ui_nodes_s.nextval' || cz_pb_mgr.v_db_link
15509: ,cz_pb_mgr.v_oraclesequenceincr
15510: )
15511: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
15512: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
15510: )
15511: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
15512: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
15513: ,func_comp_id, caption_id, tool_tip_id
15514: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
15515: ,v_cz_ui_nodes_old_tbl, v_cz_ui_nodes_ui_def_id_tbl, v_cz_ui_nodes_parent_id_tbl, v_cz_ui_nodes_ui_ref_id_tbl
15516: ,v_cz_ui_nodes_ui_dref_id_tbl, v_cz_ui_nodes_ps_node_id_tbl, v_cz_ui_nodes_component_id_tbl, v_cz_ui_nodes_expl_id_tbl
15517: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
15518: FROM cz_ui_nodes
15511: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
15512: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
15513: ,func_comp_id, caption_id, tool_tip_id
15514: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
15515: ,v_cz_ui_nodes_old_tbl, v_cz_ui_nodes_ui_def_id_tbl, v_cz_ui_nodes_parent_id_tbl, v_cz_ui_nodes_ui_ref_id_tbl
15516: ,v_cz_ui_nodes_ui_dref_id_tbl, v_cz_ui_nodes_ps_node_id_tbl, v_cz_ui_nodes_component_id_tbl, v_cz_ui_nodes_expl_id_tbl
15517: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
15518: FROM cz_ui_nodes
15519: WHERE cz_ui_nodes.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_nodes.deleted_flag = record_not_deleted;
15512: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
15513: ,func_comp_id, caption_id, tool_tip_id
15514: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
15515: ,v_cz_ui_nodes_old_tbl, v_cz_ui_nodes_ui_def_id_tbl, v_cz_ui_nodes_parent_id_tbl, v_cz_ui_nodes_ui_ref_id_tbl
15516: ,v_cz_ui_nodes_ui_dref_id_tbl, v_cz_ui_nodes_ps_node_id_tbl, v_cz_ui_nodes_component_id_tbl, v_cz_ui_nodes_expl_id_tbl
15517: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
15518: FROM cz_ui_nodes
15519: WHERE cz_ui_nodes.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_nodes.deleted_flag = record_not_deleted;
15520: EXCEPTION
15513: ,func_comp_id, caption_id, tool_tip_id
15514: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
15515: ,v_cz_ui_nodes_old_tbl, v_cz_ui_nodes_ui_def_id_tbl, v_cz_ui_nodes_parent_id_tbl, v_cz_ui_nodes_ui_ref_id_tbl
15516: ,v_cz_ui_nodes_ui_dref_id_tbl, v_cz_ui_nodes_ps_node_id_tbl, v_cz_ui_nodes_component_id_tbl, v_cz_ui_nodes_expl_id_tbl
15517: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
15518: FROM cz_ui_nodes
15519: WHERE cz_ui_nodes.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_nodes.deleted_flag = record_not_deleted;
15520: EXCEPTION
15521: WHEN NO_DATA_FOUND
15514: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
15515: ,v_cz_ui_nodes_old_tbl, v_cz_ui_nodes_ui_def_id_tbl, v_cz_ui_nodes_parent_id_tbl, v_cz_ui_nodes_ui_ref_id_tbl
15516: ,v_cz_ui_nodes_ui_dref_id_tbl, v_cz_ui_nodes_ps_node_id_tbl, v_cz_ui_nodes_component_id_tbl, v_cz_ui_nodes_expl_id_tbl
15517: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
15518: FROM cz_ui_nodes
15519: WHERE cz_ui_nodes.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_nodes.deleted_flag = record_not_deleted;
15520: EXCEPTION
15521: WHEN NO_DATA_FOUND
15522: THEN
15515: ,v_cz_ui_nodes_old_tbl, v_cz_ui_nodes_ui_def_id_tbl, v_cz_ui_nodes_parent_id_tbl, v_cz_ui_nodes_ui_ref_id_tbl
15516: ,v_cz_ui_nodes_ui_dref_id_tbl, v_cz_ui_nodes_ps_node_id_tbl, v_cz_ui_nodes_component_id_tbl, v_cz_ui_nodes_expl_id_tbl
15517: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
15518: FROM cz_ui_nodes
15519: WHERE cz_ui_nodes.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i) AND cz_ui_nodes.deleted_flag = record_not_deleted;
15520: EXCEPTION
15521: WHEN NO_DATA_FOUND
15522: THEN
15523: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
15523: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
15524: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UINODES', SQLCODE);
15525: WHEN OTHERS
15526: THEN
15527: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_nodes', 'SQLERRM', SQLERRM);
15528: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
15529: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15530: RAISE;
15531: END;
15529: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15530: RAISE;
15531: END;
15532:
15533: IF (v_cz_ui_nodes_new_tbl.COUNT > 0)
15534: THEN
15535: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
15536: LOOP
15537: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
15531: END;
15532:
15533: IF (v_cz_ui_nodes_new_tbl.COUNT > 0)
15534: THEN
15535: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
15536: LOOP
15537: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
15538: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15533: IF (v_cz_ui_nodes_new_tbl.COUNT > 0)
15534: THEN
15535: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
15536: LOOP
15537: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
15538: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15534: THEN
15535: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
15536: LOOP
15537: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
15538: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15535: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
15536: LOOP
15537: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
15538: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15536: LOOP
15537: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
15538: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15537: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
15538: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15538: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15539: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15540: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15541: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15549: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
15542: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15549: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
15550: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
15543: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15549: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
15550: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
15551: END LOOP;
15544: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15549: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
15550: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
15551: END LOOP;
15552: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
15545: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15549: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
15550: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
15551: END LOOP;
15552: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
15553: END LOOP;
15546: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
15547: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15549: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
15550: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
15551: END LOOP;
15552: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
15553: END LOOP;
15554: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
15548: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
15549: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
15550: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
15551: END LOOP;
15552: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
15553: END LOOP;
15554: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
15555:
15556: IF (cz_pb_mgr.g_log_timing = publication_timing)
15554: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
15555:
15556: IF (cz_pb_mgr.g_log_timing = publication_timing)
15557: THEN
15558: log_timing_message('end bulk collect of cz_ui_nodes');
15559: END IF;
15560:
15561: ----intl texts of ui nodes
15562: IF (cz_pb_mgr.g_log_timing = publication_timing)
15563: THEN
15564: log_timing_message('start insert_intl_texts caption ids of ui nodes');
15565: END IF;
15566:
15567: insert_intl_texts(cz_pb_mgr.v_cz_ui_nodes_capt_id_ref, 'Caption ids of ui nodes');
15568:
15569: IF (cz_pb_mgr.g_log_timing = publication_timing)
15570: THEN
15571: log_timing_message('end insert_intl_texts caption ids of ui nodes');
15576: THEN
15577: log_timing_message('start resolve_intl_texts caption ids of ui nodes');
15578: END IF;
15579:
15580: resolve_intl_texts(cz_pb_mgr.v_cz_ui_nodes_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of ui nodes');
15581:
15582: IF (cz_pb_mgr.g_log_timing = publication_timing)
15583: THEN
15584: log_timing_message('end resolve_intl_texts caption ids of ui nodes');
15589: THEN
15590: log_timing_message('start insert_intl_texts Tool tip ids of ui nodes');
15591: END IF;
15592:
15593: insert_intl_texts(cz_pb_mgr.v_cz_ui_nodes_tool_id_ref, 'Tool tip ids of ui nodes');
15594:
15595: IF (cz_pb_mgr.g_log_timing = publication_timing)
15596: THEN
15597: log_timing_message('end insert_intl_texts Tool tip ids of ui nodes');
15602: THEN
15603: log_timing_message('start resolve_intl_texts tool tip ids of ui nodes');
15604: END IF;
15605:
15606: resolve_intl_texts(cz_pb_mgr.v_cz_ui_nodes_tool_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'tool tip ids of ui nodes');
15607:
15608: IF (cz_pb_mgr.g_log_timing = publication_timing)
15609: THEN
15610: log_timing_message('end resolve_intl_texts tool tip ids of ui nodes');
15615: THEN
15616: log_timing_message('start resolve_ids ui def ids of ui nodes');
15617: END IF;
15618:
15619: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui nodes');
15620:
15621: IF (cz_pb_mgr.g_log_timing = publication_timing)
15622: THEN
15623: log_timing_message('end resolve_ids ui def ids of ui nodes');
15628: THEN
15629: log_timing_message('start resolve_ids parent ids of ui nodes');
15630: END IF;
15631:
15632: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_parent_id_ref, cz_pb_mgr.v_cz_ui_nodes_idx_ref, 'parent ids of ui nodes');
15633:
15634: IF (cz_pb_mgr.g_log_timing = publication_timing)
15635: THEN
15636: log_timing_message('end resolve_ids parent ids of ui nodes');
15641: THEN
15642: log_timing_message('start resolve_ids ui node ref ids of ui nodes');
15643: END IF;
15644:
15645: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref, cz_pb_mgr.v_cz_ui_nodes_idx_ref, 'ui node ref ids of ui nodes', FLD_IGNORE_NOW);
15646:
15647: IF (cz_pb_mgr.g_log_timing = publication_timing)
15648: THEN
15649: log_timing_message('end resolve_ids ui node ref ids of ui nodes');
15654: THEN
15655: log_timing_message('start resolve_ids ps node ids of ui nodes');
15656: END IF;
15657:
15658: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'ps node ids of ui nodes');
15659:
15660: IF (cz_pb_mgr.g_log_timing = publication_timing)
15661: THEN
15662: log_timing_message('end resolve_ids ps node ids of ui nodes');
15667: THEN
15668: log_timing_message('start resolve_ids component ids of ui nodes');
15669: END IF;
15670:
15671: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_component_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component ids of ui nodes');
15672:
15673: IF (cz_pb_mgr.g_log_timing = publication_timing)
15674: THEN
15675: log_timing_message('end resolve_ids component ids of ui nodes');
15672:
15673: IF (cz_pb_mgr.g_log_timing = publication_timing)
15674: THEN
15675: log_timing_message('end resolve_ids component ids of ui nodes');
15676: log_timing_message('start resolve_ids model ref expl id of cz_ui nodes');
15677: END IF;
15678:
15679: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_ui nodes');
15680:
15675: log_timing_message('end resolve_ids component ids of ui nodes');
15676: log_timing_message('start resolve_ids model ref expl id of cz_ui nodes');
15677: END IF;
15678:
15679: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_ui nodes');
15680:
15681: IF (cz_pb_mgr.g_log_timing = publication_timing)
15682: THEN
15683: log_timing_message('end resolve_ids model ref expl id of cz_ui nodes');
15679: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_ui nodes');
15680:
15681: IF (cz_pb_mgr.g_log_timing = publication_timing)
15682: THEN
15683: log_timing_message('end resolve_ids model ref expl id of cz_ui nodes');
15684: log_timing_message('start resolve_ids func comp ids of ui nodes');
15685: END IF;
15686:
15687: ---------resolve func comp ids of ui nodes
15684: log_timing_message('start resolve_ids func comp ids of ui nodes');
15685: END IF;
15686:
15687: ---------resolve func comp ids of ui nodes
15688: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref, cz_pb_mgr.v_cz_func_comp_idx_ref, 'func comp ids of ui nodes');
15689:
15690: IF (cz_pb_mgr.g_log_timing = publication_timing)
15691: THEN
15692: log_timing_message('end resolve_ids func comp ids of ui nodes');
15694: END IF;
15695:
15696: ---------resolve ui_def_ref_id
15697: -- should call resolve_ids instead
15698: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
15699: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15700: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
15701: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
15702: ,'cz_ui_nodes.ui_def_ref_id'
15697: -- should call resolve_ids instead
15698: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
15699: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15700: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
15701: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
15702: ,'cz_ui_nodes.ui_def_ref_id'
15703: ,cz_pb_mgr.v_status_code
15704: );
15705:
15698: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
15699: ,cz_pb_mgr.v_cz_ui_defs_old_ref
15700: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
15701: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
15702: ,'cz_ui_nodes.ui_def_ref_id'
15703: ,cz_pb_mgr.v_status_code
15704: );
15705:
15706: IF (cz_pb_mgr.g_log_timing = publication_timing)
15709: log_timing_message('start resolve_remote_ui_nodes');
15710: END IF;
15711:
15712: ----------resolve remote ui_node_ids
15713: resolve_remote_ui_nodes(cz_pb_mgr.v_cz_ui_nodes_new_ref
15714: ,cz_pb_mgr.v_models_not_to_be_exported
15715: ,cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref
15716: ,cz_pb_mgr.v_server_id
15717: ,cz_pb_mgr.v_status_code
15711:
15712: ----------resolve remote ui_node_ids
15713: resolve_remote_ui_nodes(cz_pb_mgr.v_cz_ui_nodes_new_ref
15714: ,cz_pb_mgr.v_models_not_to_be_exported
15715: ,cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref
15716: ,cz_pb_mgr.v_server_id
15717: ,cz_pb_mgr.v_status_code
15718: );
15719:
15725: --------populate plsql_table_list for ui_nodes
15726: plsql_table_list.DELETE;
15727: rec_count := 1;
15728: plsql_table_list(rec_count).col_name := 'ui_node_id';
15729: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_new_ref';
15730: rec_count := rec_count + 1;
15731: plsql_table_list(rec_count).col_name := 'ui_def_id';
15732: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref';
15733: rec_count := rec_count + 1;
15728: plsql_table_list(rec_count).col_name := 'ui_node_id';
15729: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_new_ref';
15730: rec_count := rec_count + 1;
15731: plsql_table_list(rec_count).col_name := 'ui_def_id';
15732: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref';
15733: rec_count := rec_count + 1;
15734: plsql_table_list(rec_count).col_name := 'parent_id';
15735: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_parent_id_ref';
15736: rec_count := rec_count + 1;
15731: plsql_table_list(rec_count).col_name := 'ui_def_id';
15732: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref';
15733: rec_count := rec_count + 1;
15734: plsql_table_list(rec_count).col_name := 'parent_id';
15735: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_parent_id_ref';
15736: rec_count := rec_count + 1;
15737: plsql_table_list(rec_count).col_name := 'component_id';
15738: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_component_id_ref';
15739: rec_count := rec_count + 1;
15734: plsql_table_list(rec_count).col_name := 'parent_id';
15735: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_parent_id_ref';
15736: rec_count := rec_count + 1;
15737: plsql_table_list(rec_count).col_name := 'component_id';
15738: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_component_id_ref';
15739: rec_count := rec_count + 1;
15740: plsql_table_list(rec_count).col_name := 'ps_node_id';
15741: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref';
15742: rec_count := rec_count + 1;
15737: plsql_table_list(rec_count).col_name := 'component_id';
15738: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_component_id_ref';
15739: rec_count := rec_count + 1;
15740: plsql_table_list(rec_count).col_name := 'ps_node_id';
15741: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref';
15742: rec_count := rec_count + 1;
15743: plsql_table_list(rec_count).col_name := 'ui_node_ref_id';
15744: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref';
15745: rec_count := rec_count + 1;
15740: plsql_table_list(rec_count).col_name := 'ps_node_id';
15741: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref';
15742: rec_count := rec_count + 1;
15743: plsql_table_list(rec_count).col_name := 'ui_node_ref_id';
15744: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref';
15745: rec_count := rec_count + 1;
15746: plsql_table_list(rec_count).col_name := 'ui_def_ref_id';
15747: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref';
15748: rec_count := rec_count + 1;
15743: plsql_table_list(rec_count).col_name := 'ui_node_ref_id';
15744: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref';
15745: rec_count := rec_count + 1;
15746: plsql_table_list(rec_count).col_name := 'ui_def_ref_id';
15747: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref';
15748: rec_count := rec_count + 1;
15749: plsql_table_list(rec_count).col_name := 'func_comp_id';
15750: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref';
15751: rec_count := rec_count + 1;
15746: plsql_table_list(rec_count).col_name := 'ui_def_ref_id';
15747: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref';
15748: rec_count := rec_count + 1;
15749: plsql_table_list(rec_count).col_name := 'func_comp_id';
15750: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref';
15751: rec_count := rec_count + 1;
15752: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
15753: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_expl_id_ref';
15754: rec_count := rec_count + 1;
15749: plsql_table_list(rec_count).col_name := 'func_comp_id';
15750: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref';
15751: rec_count := rec_count + 1;
15752: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
15753: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_expl_id_ref';
15754: rec_count := rec_count + 1;
15755: plsql_table_list(rec_count).col_name := 'caption_id';
15756: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_capt_id_ref';
15757: rec_count := rec_count + 1;
15752: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
15753: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_expl_id_ref';
15754: rec_count := rec_count + 1;
15755: plsql_table_list(rec_count).col_name := 'caption_id';
15756: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_capt_id_ref';
15757: rec_count := rec_count + 1;
15758: plsql_table_list(rec_count).col_name := 'tool_tip_id';
15759: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_tool_id_ref';
15760:
15755: plsql_table_list(rec_count).col_name := 'caption_id';
15756: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_capt_id_ref';
15757: rec_count := rec_count + 1;
15758: plsql_table_list(rec_count).col_name := 'tool_tip_id';
15759: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_tool_id_ref';
15760:
15761: IF (cz_pb_mgr.g_log_timing = publication_timing)
15762: THEN
15763: log_timing_message('start insert_into_table cz_ui_nodes');
15759: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_tool_id_ref';
15760:
15761: IF (cz_pb_mgr.g_log_timing = publication_timing)
15762: THEN
15763: log_timing_message('start insert_into_table cz_ui_nodes');
15764: END IF;
15765:
15766: -----------insert into cz_ui_nodes of target server
15767: insert_into_table('cz_ui_nodes'
15762: THEN
15763: log_timing_message('start insert_into_table cz_ui_nodes');
15764: END IF;
15765:
15766: -----------insert into cz_ui_nodes of target server
15767: insert_into_table('cz_ui_nodes'
15768: ,'ui_node_id'
15769: ,cz_pb_mgr.v_db_link
15770: ,plsql_table_list
15763: log_timing_message('start insert_into_table cz_ui_nodes');
15764: END IF;
15765:
15766: -----------insert into cz_ui_nodes of target server
15767: insert_into_table('cz_ui_nodes'
15768: ,'ui_node_id'
15769: ,cz_pb_mgr.v_db_link
15770: ,plsql_table_list
15771: ,'cz_pb_mgr.v_cz_ui_nodes_old_ref'
15767: insert_into_table('cz_ui_nodes'
15768: ,'ui_node_id'
15769: ,cz_pb_mgr.v_db_link
15770: ,plsql_table_list
15771: ,'cz_pb_mgr.v_cz_ui_nodes_old_ref'
15772: ,cz_pb_mgr.v_cz_ui_nodes_old_ref
15773: );
15774:
15775: IF (cz_pb_mgr.g_log_timing = publication_timing)
15768: ,'ui_node_id'
15769: ,cz_pb_mgr.v_db_link
15770: ,plsql_table_list
15771: ,'cz_pb_mgr.v_cz_ui_nodes_old_ref'
15772: ,cz_pb_mgr.v_cz_ui_nodes_old_ref
15773: );
15774:
15775: IF (cz_pb_mgr.g_log_timing = publication_timing)
15776: THEN
15773: );
15774:
15775: IF (cz_pb_mgr.g_log_timing = publication_timing)
15776: THEN
15777: log_timing_message('end insert_into_table cz_ui_nodes');
15778: END IF;
15779:
15780: --------populate plsql_table_list for ui_node_props
15781: IF (cz_pb_mgr.g_log_timing = publication_timing)
15790: log_timing_message('end insert_into_table cz_ui_node_props');
15791: END IF;
15792:
15793: -------------release local pl/sql tables
15794: v_cz_ui_nodes_new_tbl.DELETE;
15795: v_cz_ui_nodes_old_tbl.DELETE;
15796: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15791: END IF;
15792:
15793: -------------release local pl/sql tables
15794: v_cz_ui_nodes_new_tbl.DELETE;
15795: v_cz_ui_nodes_old_tbl.DELETE;
15796: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15792:
15793: -------------release local pl/sql tables
15794: v_cz_ui_nodes_new_tbl.DELETE;
15795: v_cz_ui_nodes_old_tbl.DELETE;
15796: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15793: -------------release local pl/sql tables
15794: v_cz_ui_nodes_new_tbl.DELETE;
15795: v_cz_ui_nodes_old_tbl.DELETE;
15796: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15801: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15794: v_cz_ui_nodes_new_tbl.DELETE;
15795: v_cz_ui_nodes_old_tbl.DELETE;
15796: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15801: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15802: v_cz_ui_nodes_expl_id_tbl.DELETE;
15795: v_cz_ui_nodes_old_tbl.DELETE;
15796: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15801: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15802: v_cz_ui_nodes_expl_id_tbl.DELETE;
15803: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15796: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15801: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15802: v_cz_ui_nodes_expl_id_tbl.DELETE;
15803: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15804:
15797: v_cz_ui_nodes_parent_id_tbl.DELETE;
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15801: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15802: v_cz_ui_nodes_expl_id_tbl.DELETE;
15803: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15804:
15805: EXCEPTION
15798: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15801: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15802: v_cz_ui_nodes_expl_id_tbl.DELETE;
15803: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15804:
15805: EXCEPTION
15806: WHEN OTHERS
15799: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
15800: v_cz_ui_nodes_component_id_tbl.DELETE;
15801: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
15802: v_cz_ui_nodes_expl_id_tbl.DELETE;
15803: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
15804:
15805: EXCEPTION
15806: WHEN OTHERS
15807: THEN
18507: END IF;
18508: ELSE
18509: IF (l_ui_style IN(g_ui_style_dhtml, g_ui_style_applet)) THEN
18510: SELECT DISTINCT ui_def_id BULK COLLECT INTO l_ui_tbl
18511: FROM cz_ui_nodes
18512: WHERE deleted_flag = '0'
18513: START WITH ui_def_id = p_ui_def_id
18514: CONNECT BY PRIOR ui_def_ref_id = ui_def_id AND PRIOR deleted_flag = '0';
18515: ELSIF (l_ui_style = g_ui_style_jrad) THEN