[Home] [Help]
28:
29: -- special fields in id resolution
30: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
31: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
32: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
33: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
34: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';
35: FLD_UI_NODE_REF_ID CONSTANT VARCHAR2(9) := 'UINREFID';
36: FLD_IGNORE_NOW CONSTANT VARCHAR2(9) := 'IGNOREID';
165: cz_pb_mgr.v_arg_sig_old_tbl.DELETE;
166: cz_pb_mgr.v_arg_sig_tbl.DELETE;
167: cz_pb_mgr.v_data_sig_tbl.DELETE;
168: cz_pb_mgr.g_page_sets_jrad_doc_ref.DELETE;
169: cz_pb_mgr.v_cz_ui_nodes_idx_ref.DELETE;
170: cz_pb_mgr.l_cnt_typ_tmpls_cont_ref.DELETE;
171: cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref.DELETE;
172: cz_pb_mgr.l_ui_images_ui_ref.DELETE;
173: cz_pb_mgr.l_ui_images_enty_tbl.DELETE;
308: cz_pb_mgr.v_ui_defs_mcpt_rule_ref.DELETE;
309: cz_pb_mgr.v_ui_defs_pcpt_rule_ref.DELETE;
310: cz_pb_mgr.v_master_template_id_ref.DELETE;
311: END IF;
312: ELSIF(p_table_name = 'cz_ui_nodes')
313: THEN
314: IF (p_table_type = 'ref')
315: THEN
316: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
312: ELSIF(p_table_name = 'cz_ui_nodes')
313: THEN
314: IF (p_table_type = 'ref')
315: THEN
316: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
317: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
318: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
313: THEN
314: IF (p_table_type = 'ref')
315: THEN
316: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
317: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
318: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
314: IF (p_table_type = 'ref')
315: THEN
316: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
317: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
318: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
315: THEN
316: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
317: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
318: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
316: cz_pb_mgr.v_cz_ui_nodes_new_ref.DELETE;
317: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
318: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
317: cz_pb_mgr.v_cz_ui_nodes_old_ref.DELETE;
318: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
325: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
318: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
325: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
326: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
319: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
325: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
326: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
327: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
320: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
325: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
326: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
327: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
328: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
321: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
325: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
326: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
327: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
328: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
329: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
322: cz_pb_mgr.v_cz_ui_nodes_component_id_ref.DELETE;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
325: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
326: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
327: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
328: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
329: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
330: END IF;
323: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref.DELETE;
324: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref.DELETE;
325: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref.DELETE;
326: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref.DELETE;
327: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref.DELETE;
328: cz_pb_mgr.v_intl_text_model_tbl.DELETE;
329: cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
330: END IF;
331: ELSIF(p_table_name = 'cz_ps_prop_vals')
6476: ,cz_pb_mgr.v_models_to_be_exported_new
6477: );
6478: 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);
6479: 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);
6480: 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);
6481: 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);
6482: delete_from_table('cz_model_ref_expls'
6483: ,'model_ref_expl_id'
6484: ,v_database_link
6477: );
6478: 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);
6479: 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);
6480: 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);
6481: 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);
6482: delete_from_table('cz_model_ref_expls'
6483: ,'model_ref_expl_id'
6484: ,v_database_link
6485: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
7013:
7014: BEGIN
7015: SELECT DISTINCT ui_def_ref_id
7016: BULK COLLECT INTO v_src_uis_tbl
7017: FROM cz_ui_nodes
7018: WHERE cz_ui_nodes.ui_def_id IN(
7019: SELECT cz_ui_defs.ui_def_id
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7014: BEGIN
7015: SELECT DISTINCT ui_def_ref_id
7016: BULK COLLECT INTO v_src_uis_tbl
7017: FROM cz_ui_nodes
7018: WHERE cz_ui_nodes.ui_def_id IN(
7019: SELECT cz_ui_defs.ui_def_id
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7019: SELECT cz_ui_defs.ui_def_id
7020: FROM cz_ui_defs
7021: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7022: AND cz_ui_defs.NAME <> 'MUID')
7023: AND cz_ui_nodes.ui_def_ref_id IN(
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7027: AND cz_ui_defs.NAME <> 'MUID')
7024: SELECT cz_ui_defs.ui_def_id
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7027: AND cz_ui_defs.NAME <> 'MUID')
7028: AND cz_ui_nodes.deleted_flag = '0'
7029: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7030: EXCEPTION
7031: WHEN OTHERS
7032: THEN
7025: FROM cz_ui_defs
7026: WHERE cz_ui_defs.devl_project_id = l_export_model_id AND cz_ui_defs.deleted_flag = '0'
7027: AND cz_ui_defs.NAME <> 'MUID')
7028: AND cz_ui_nodes.deleted_flag = '0'
7029: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL;
7030: EXCEPTION
7031: WHEN OTHERS
7032: THEN
7033: cz_pb_mgr.v_err_message := SUBSTR('bulk collection into cz_pb_mgr.v_cz_ui_defs_old_tbl: ' || SQLERRM, 1, 2000);
7060: ----procedure that returns the max last_update_date of ui schema
7061: 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)
7062: AS
7063: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7064: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7065: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7066: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7067: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7068: v_initialized_date DATE;
7061: 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)
7062: AS
7063: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7064: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7065: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7066: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7067: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7068: v_initialized_date DATE;
7069: v_ui_pages_date DATE;
7062: AS
7063: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7064: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7065: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7066: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7067: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7068: v_initialized_date DATE;
7069: v_ui_pages_date DATE;
7070: v_ui_pages_capt_date DATE;
7063: v_ui_def_id_date cz_ui_defs.last_update_date%TYPE;
7064: v_ui_node_id_date cz_ui_nodes.last_update_date%TYPE;
7065: v_ui_props_date cz_ui_nodes.last_update_date%TYPE;
7066: v_ui_node_props_date cz_ui_nodes.last_update_date%TYPE;
7067: v_ui_node_intl_date cz_ui_nodes.last_update_date%TYPE;
7068: v_initialized_date DATE;
7069: v_ui_pages_date DATE;
7070: v_ui_pages_capt_date DATE;
7071: v_ui_page_sets_date DATE;
7087:
7088: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7089: IS
7090: SELECT last_update_date
7091: FROM cz_ui_nodes
7092: WHERE cz_ui_nodes.ui_def_id = node_ui_def_id AND cz_ui_nodes.deleted_flag = '0'
7093: ORDER BY last_update_date DESC;
7094:
7095: CURSOR ui_properties_cur(prop_ui_def_id NUMBER)
7088: CURSOR ui_nodes_cur(node_ui_def_id NUMBER)
7089: IS
7090: SELECT last_update_date
7091: FROM cz_ui_nodes
7092: WHERE cz_ui_nodes.ui_def_id = node_ui_def_id AND cz_ui_nodes.deleted_flag = '0'
7093: ORDER BY last_update_date DESC;
7094:
7095: CURSOR ui_properties_cur(prop_ui_def_id NUMBER)
7096: IS
7110: IS
7111: SELECT last_update_date
7112: FROM cz_intl_texts
7113: WHERE intl_text_id IN(SELECT f.tool_tip_id
7114: FROM cz_ui_nodes f
7115: WHERE f.ui_def_id = p_ui_def_id AND f.deleted_flag = '0'
7116: UNION
7117: SELECT g.caption_id
7118: FROM cz_ui_nodes g
7114: FROM cz_ui_nodes f
7115: WHERE f.ui_def_id = p_ui_def_id AND f.deleted_flag = '0'
7116: UNION
7117: SELECT g.caption_id
7118: FROM cz_ui_nodes g
7119: WHERE g.ui_def_id = p_ui_def_id AND g.deleted_flag = '0')
7120: ORDER BY last_update_date DESC;
7121:
7122: CURSOR ui_pages_cur(ui_pages_def_id NUMBER)
7608: --------procedure that checks if logic has changed since the model was last published
7609: 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)
7610: AS
7611: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
7612: v_expr_node_date cz_ui_nodes.last_update_date%TYPE;
7613: BEGIN
7614: IF (p_model_array.COUNT > 0)
7615: THEN
7616: FOR i IN p_model_array.FIRST .. p_model_array.LAST
10945: ,cz_pb_mgr.v_server_id
10946: ,cz_pb_mgr.v_status_code
10947: );
10948: ELSIF(p_column_name IN
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'
11390: END IF;
11391: END get_uis_of_mdls_not_exported;
11392:
11393: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11394: --------Procedure to resolve remote ui nodes of cz_ui_nodes
11395: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
11396: PROCEDURE resolve_remote_ui_nodes(
11397: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
11398: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11391: END get_uis_of_mdls_not_exported;
11392:
11393: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11394: --------Procedure to resolve remote ui nodes of cz_ui_nodes
11395: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
11396: PROCEDURE resolve_remote_ui_nodes(
11397: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
11398: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11399: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
11393: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11394: --------Procedure to resolve remote ui nodes of cz_ui_nodes
11395: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
11396: PROCEDURE resolve_remote_ui_nodes(
11397: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
11398: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11399: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
11400: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
11401: ,x_status IN OUT NOCOPY VARCHAR2
11395: -- Note for model conversion, v_cz_ui_nodes_new_ref should be empty, otherwise there would be a problem here
11396: PROCEDURE resolve_remote_ui_nodes(
11397: p_master_keys_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_new_ref
11398: ,p_models_not_exported IN OUT NOCOPY cz_pb_mgr.t_ref
11399: ,p_resolved_array IN OUT NOCOPY cz_pb_mgr.t_ref -- v_cz_ui_nodes_ui_ref_id_ref
11400: ,p_server_id IN OUT NOCOPY cz_servers.server_local_id%TYPE
11401: ,x_status IN OUT NOCOPY VARCHAR2
11402: )
11403: AS
11474:
11475: BEGIN
11476: SELECT ui_node_id, ui_def_id, persistent_ui_node_id
11477: BULK COLLECT INTO v_remote_ui_nodes_tbl, v_remote_ui_nod_ui_def_tbl, v_remote_pers_ui_node_tbl
11478: FROM cz_ui_nodes
11479: WHERE cz_ui_nodes.ui_def_id = v_remote_ui_defs_ref(i) AND cz_ui_nodes.deleted_flag = '0'
11480: ORDER BY cz_ui_nodes.ui_node_id;
11481: EXCEPTION
11482: WHEN NO_DATA_FOUND
11475: BEGIN
11476: SELECT ui_node_id, ui_def_id, persistent_ui_node_id
11477: BULK COLLECT INTO v_remote_ui_nodes_tbl, v_remote_ui_nod_ui_def_tbl, v_remote_pers_ui_node_tbl
11478: FROM cz_ui_nodes
11479: WHERE cz_ui_nodes.ui_def_id = v_remote_ui_defs_ref(i) AND cz_ui_nodes.deleted_flag = '0'
11480: ORDER BY cz_ui_nodes.ui_node_id;
11481: EXCEPTION
11482: WHEN NO_DATA_FOUND
11483: THEN
11476: SELECT ui_node_id, ui_def_id, persistent_ui_node_id
11477: BULK COLLECT INTO v_remote_ui_nodes_tbl, v_remote_ui_nod_ui_def_tbl, v_remote_pers_ui_node_tbl
11478: FROM cz_ui_nodes
11479: WHERE cz_ui_nodes.ui_def_id = v_remote_ui_defs_ref(i) AND cz_ui_nodes.deleted_flag = '0'
11480: ORDER BY cz_ui_nodes.ui_node_id;
11481: EXCEPTION
11482: WHEN NO_DATA_FOUND
11483: THEN
11484: cz_pb_mgr.v_err_message := 'No ui_node_ids found ';
11527: CLOSE l_ui_def_cur;
11528:
11529: OPEN ui_def_ref_id_cv FOR 'SELECT ui_node_id'
11530: || ' '
11531: || 'FROM cz_ui_nodes'
11532: || cz_pb_mgr.v_db_link
11533: || ' t'
11534: || ' '
11535: || 'WHERE t.persistent_ui_node_id = :pers_ui_node_id'
12209: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13926: l_prop_node_tbl.DELETE;
13927:
13928: SELECT DISTINCT prop.ui_node_id
13929: BULK COLLECT INTO l_prop_node_tbl
13930: FROM cz_ui_node_props prop, cz_ui_nodes node
13931: WHERE prop.ui_def_id = node.ui_def_id
13932: AND prop.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
13933: AND node.ui_node_id = prop.ui_node_id
13934: AND node.deleted_flag = record_not_deleted
13951: END IF;
13952:
13953: IF cz_pb_mgr.g_ui_node_prop_new_node_tbl.COUNT > 0
13954: THEN
13955: 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');
13956: 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');
13957: l_plsql_table_list(1).col_name := 'ui_node_id';
13958: l_plsql_table_list(1).table_name := 'cz_pb_mgr.g_ui_node_prop_new_node_tbl';
13959: l_plsql_table_list(2).col_name := 'ui_def_id';
14152: v_cz_ui_defs_old_tbl cz_pb_mgr.t_ref;
14153: v_ui_devl_id_tbl cz_pb_mgr.t_ref;
14154: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
14155: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
14156: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
14157: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
14158: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14153: v_ui_devl_id_tbl cz_pb_mgr.t_ref;
14154: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
14155: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
14156: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
14157: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
14158: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14154: v_ui_comp_id_tbl cz_pb_mgr.t_ref;
14155: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
14156: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
14157: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
14158: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14155: v_ui_rf_id_tbl cz_pb_mgr.t_ref;
14156: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
14157: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
14158: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14156: v_cz_ui_nodes_new_tbl cz_pb_mgr.t_ref;
14157: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
14158: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14157: v_cz_ui_nodes_old_tbl cz_pb_mgr.t_ref;
14158: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14165: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
14158: v_cz_ui_nodes_ui_def_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14165: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
14166: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
14159: v_cz_ui_nodes_parent_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14165: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
14166: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
14167: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
14160: v_cz_ui_nodes_ui_ref_id_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14165: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
14166: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
14167: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
14168: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
14161: v_cz_ui_nodes_ps_node_id_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14165: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
14166: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
14167: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
14168: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
14169: v_page_capt_rule_tbl cz_pb_mgr.t_ref;
14162: v_cz_ui_nodes_component_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14165: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
14166: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
14167: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
14168: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
14169: v_page_capt_rule_tbl cz_pb_mgr.t_ref;
14170: l_from_mt_id_tbl cz_pb_mgr.t_ref;
14163: v_cz_ui_nodes_ui_dref_id_tbl cz_pb_mgr.t_ref;
14164: v_cz_ui_nodes_expl_id_tbl cz_pb_mgr.t_ref;
14165: v_cz_ui_nodes_fcomp_id_tbl cz_pb_mgr.t_ref;
14166: v_cz_ui_nodes_capt_id_tbl cz_pb_mgr.t_ref;
14167: v_cz_ui_nodes_tool_id_tbl cz_pb_mgr.t_ref;
14168: v_menu_capt_rule_tbl cz_pb_mgr.t_ref;
14169: v_page_capt_rule_tbl cz_pb_mgr.t_ref;
14170: l_from_mt_id_tbl cz_pb_mgr.t_ref;
14171: BEGIN
14417: THEN
14418: log_timing_message('end insert_into_table cz_ui_properties');
14419: END IF;
14420:
14421: ----------insert ids of cz_ui_nodes
14422: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
14423:
14424: IF (cz_pb_mgr.g_log_timing = publication_timing)
14425: THEN
14418: log_timing_message('end insert_into_table cz_ui_properties');
14419: END IF;
14420:
14421: ----------insert ids of cz_ui_nodes
14422: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
14423:
14424: IF (cz_pb_mgr.g_log_timing = publication_timing)
14425: THEN
14426: log_timing_message('start bulk collect of cz_ui_nodes');
14422: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
14423:
14424: IF (cz_pb_mgr.g_log_timing = publication_timing)
14425: THEN
14426: log_timing_message('start bulk collect of cz_ui_nodes');
14427: END IF;
14428:
14429: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14430: THEN
14429: IF (cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0)
14430: THEN
14431: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14432: LOOP
14433: v_cz_ui_nodes_new_tbl.DELETE;
14434: v_cz_ui_nodes_old_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14430: THEN
14431: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14432: LOOP
14433: v_cz_ui_nodes_new_tbl.DELETE;
14434: v_cz_ui_nodes_old_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14431: FOR i IN cz_pb_mgr.v_cz_ui_defs_old_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_ref.LAST
14432: LOOP
14433: v_cz_ui_nodes_new_tbl.DELETE;
14434: v_cz_ui_nodes_old_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14432: LOOP
14433: v_cz_ui_nodes_new_tbl.DELETE;
14434: v_cz_ui_nodes_old_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14433: v_cz_ui_nodes_new_tbl.DELETE;
14434: v_cz_ui_nodes_old_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14434: v_cz_ui_nodes_old_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14442: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14435: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14442: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14443: v_cz_ui_nodes_capt_id_tbl.DELETE;
14436: v_cz_ui_nodes_parent_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14442: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14443: v_cz_ui_nodes_capt_id_tbl.DELETE;
14444: v_cz_ui_nodes_tool_id_tbl.DELETE;
14437: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14442: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14443: v_cz_ui_nodes_capt_id_tbl.DELETE;
14444: v_cz_ui_nodes_tool_id_tbl.DELETE;
14445:
14438: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14442: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14443: v_cz_ui_nodes_capt_id_tbl.DELETE;
14444: v_cz_ui_nodes_tool_id_tbl.DELETE;
14445:
14446: BEGIN
14439: v_cz_ui_nodes_component_id_tbl.DELETE;
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14442: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14443: v_cz_ui_nodes_capt_id_tbl.DELETE;
14444: v_cz_ui_nodes_tool_id_tbl.DELETE;
14445:
14446: BEGIN
14447: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
14440: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14441: v_cz_ui_nodes_expl_id_tbl.DELETE;
14442: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14443: v_cz_ui_nodes_capt_id_tbl.DELETE;
14444: v_cz_ui_nodes_tool_id_tbl.DELETE;
14445:
14446: BEGIN
14447: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
14448: , 'cz_ui_nodes_s.nextval' || cz_pb_mgr.v_db_link
14443: v_cz_ui_nodes_capt_id_tbl.DELETE;
14444: v_cz_ui_nodes_tool_id_tbl.DELETE;
14445:
14446: BEGIN
14447: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
14448: , 'cz_ui_nodes_s.nextval' || cz_pb_mgr.v_db_link
14449: ,cz_pb_mgr.v_oraclesequenceincr
14450: )
14451: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
14444: v_cz_ui_nodes_tool_id_tbl.DELETE;
14445:
14446: BEGIN
14447: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_nodes_seq
14448: , 'cz_ui_nodes_s.nextval' || cz_pb_mgr.v_db_link
14449: ,cz_pb_mgr.v_oraclesequenceincr
14450: )
14451: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
14452: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
14450: )
14451: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
14452: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
14453: ,func_comp_id, caption_id, tool_tip_id
14454: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
14455: ,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
14456: ,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
14457: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
14458: FROM cz_ui_nodes
14451: ,ui_node_id, ui_def_id, parent_id, ui_node_ref_id
14452: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
14453: ,func_comp_id, caption_id, tool_tip_id
14454: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
14455: ,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
14456: ,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
14457: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
14458: FROM cz_ui_nodes
14459: 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;
14452: ,ui_def_ref_id, ps_node_id, component_id, model_ref_expl_id
14453: ,func_comp_id, caption_id, tool_tip_id
14454: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
14455: ,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
14456: ,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
14457: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
14458: FROM cz_ui_nodes
14459: 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;
14460: EXCEPTION
14453: ,func_comp_id, caption_id, tool_tip_id
14454: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
14455: ,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
14456: ,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
14457: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
14458: FROM cz_ui_nodes
14459: 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;
14460: EXCEPTION
14461: WHEN NO_DATA_FOUND
14454: BULK COLLECT INTO v_cz_ui_nodes_new_tbl
14455: ,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
14456: ,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
14457: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
14458: FROM cz_ui_nodes
14459: 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;
14460: EXCEPTION
14461: WHEN NO_DATA_FOUND
14462: THEN
14455: ,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
14456: ,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
14457: ,v_cz_ui_nodes_fcomp_id_tbl, v_cz_ui_nodes_capt_id_tbl, v_cz_ui_nodes_tool_id_tbl
14458: FROM cz_ui_nodes
14459: 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;
14460: EXCEPTION
14461: WHEN NO_DATA_FOUND
14462: THEN
14463: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
14463: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
14464: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UINODES', SQLCODE);
14465: WHEN OTHERS
14466: THEN
14467: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_nodes', 'SQLERRM', SQLERRM);
14468: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
14469: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14470: RAISE;
14471: END;
14469: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14470: RAISE;
14471: END;
14472:
14473: IF (v_cz_ui_nodes_new_tbl.COUNT > 0)
14474: THEN
14475: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
14476: LOOP
14477: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
14471: END;
14472:
14473: IF (v_cz_ui_nodes_new_tbl.COUNT > 0)
14474: THEN
14475: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
14476: LOOP
14477: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
14478: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14473: IF (v_cz_ui_nodes_new_tbl.COUNT > 0)
14474: THEN
14475: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
14476: LOOP
14477: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
14478: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14474: THEN
14475: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
14476: LOOP
14477: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
14478: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14475: FOR k IN v_cz_ui_nodes_new_tbl.FIRST .. v_cz_ui_nodes_new_tbl.LAST
14476: LOOP
14477: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
14478: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14476: LOOP
14477: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
14478: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14477: v_ui_node_count := cz_pb_mgr.v_cz_ui_nodes_new_ref.COUNT + 1;
14478: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14478: cz_pb_mgr.v_cz_ui_nodes_new_ref(v_ui_node_count) := v_cz_ui_nodes_new_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14479: cz_pb_mgr.v_cz_ui_nodes_old_ref(v_ui_node_count) := v_cz_ui_nodes_old_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14480: cz_pb_mgr.v_cz_ui_nodes_idx_ref(v_cz_ui_nodes_old_tbl(k)):=v_cz_ui_nodes_new_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14481: cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_def_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14489: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
14482: cz_pb_mgr.v_cz_ui_nodes_parent_id_ref(v_ui_node_count) := v_cz_ui_nodes_parent_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14489: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
14490: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
14483: cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_ref_id_tbl(k);
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14489: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
14490: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
14491: END LOOP;
14484: cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref(v_ui_node_count) := v_cz_ui_nodes_ps_node_id_tbl(k);
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14489: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
14490: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
14491: END LOOP;
14492: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
14485: cz_pb_mgr.v_cz_ui_nodes_component_id_ref(v_ui_node_count) := v_cz_ui_nodes_component_id_tbl(k);
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14489: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
14490: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
14491: END LOOP;
14492: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
14493: END LOOP;
14486: cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref(v_ui_node_count) := v_cz_ui_nodes_ui_dref_id_tbl(k);
14487: cz_pb_mgr.v_cz_ui_nodes_expl_id_ref(v_ui_node_count) := v_cz_ui_nodes_expl_id_tbl(k);
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14489: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
14490: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
14491: END LOOP;
14492: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
14493: END LOOP;
14494: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
14488: cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref(v_ui_node_count) := v_cz_ui_nodes_fcomp_id_tbl(k);
14489: cz_pb_mgr.v_cz_ui_nodes_capt_id_ref(v_ui_node_count) := v_cz_ui_nodes_capt_id_tbl(k);
14490: cz_pb_mgr.v_cz_ui_nodes_tool_id_ref(v_ui_node_count) := v_cz_ui_nodes_tool_id_tbl(k);
14491: END LOOP;
14492: END IF; /* end if of v_cz_ui_nodes_new_tbl.COUNT > 0 */
14493: END LOOP;
14494: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
14495:
14496: IF (cz_pb_mgr.g_log_timing = publication_timing)
14494: END IF; /* end if of cz_pb_mgr.v_cz_ui_defs_old_ref.COUNT > 0 */
14495:
14496: IF (cz_pb_mgr.g_log_timing = publication_timing)
14497: THEN
14498: log_timing_message('end bulk collect of cz_ui_nodes');
14499: END IF;
14500:
14501: ----intl texts of ui nodes
14502: IF (cz_pb_mgr.g_log_timing = publication_timing)
14503: THEN
14504: log_timing_message('start insert_intl_texts caption ids of ui nodes');
14505: END IF;
14506:
14507: insert_intl_texts(cz_pb_mgr.v_cz_ui_nodes_capt_id_ref, 'Caption ids of ui nodes');
14508:
14509: IF (cz_pb_mgr.g_log_timing = publication_timing)
14510: THEN
14511: log_timing_message('end insert_intl_texts caption ids of ui nodes');
14516: THEN
14517: log_timing_message('start resolve_intl_texts caption ids of ui nodes');
14518: END IF;
14519:
14520: 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');
14521:
14522: IF (cz_pb_mgr.g_log_timing = publication_timing)
14523: THEN
14524: log_timing_message('end resolve_intl_texts caption ids of ui nodes');
14529: THEN
14530: log_timing_message('start insert_intl_texts Tool tip ids of ui nodes');
14531: END IF;
14532:
14533: insert_intl_texts(cz_pb_mgr.v_cz_ui_nodes_tool_id_ref, 'Tool tip ids of ui nodes');
14534:
14535: IF (cz_pb_mgr.g_log_timing = publication_timing)
14536: THEN
14537: log_timing_message('end insert_intl_texts Tool tip ids of ui nodes');
14542: THEN
14543: log_timing_message('start resolve_intl_texts tool tip ids of ui nodes');
14544: END IF;
14545:
14546: 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');
14547:
14548: IF (cz_pb_mgr.g_log_timing = publication_timing)
14549: THEN
14550: log_timing_message('end resolve_intl_texts tool tip ids of ui nodes');
14555: THEN
14556: log_timing_message('start resolve_ids ui def ids of ui nodes');
14557: END IF;
14558:
14559: 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');
14560:
14561: IF (cz_pb_mgr.g_log_timing = publication_timing)
14562: THEN
14563: log_timing_message('end resolve_ids ui def ids of ui nodes');
14568: THEN
14569: log_timing_message('start resolve_ids parent ids of ui nodes');
14570: END IF;
14571:
14572: 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');
14573:
14574: IF (cz_pb_mgr.g_log_timing = publication_timing)
14575: THEN
14576: log_timing_message('end resolve_ids parent ids of ui nodes');
14581: THEN
14582: log_timing_message('start resolve_ids ui node ref ids of ui nodes');
14583: END IF;
14584:
14585: 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);
14586:
14587: IF (cz_pb_mgr.g_log_timing = publication_timing)
14588: THEN
14589: log_timing_message('end resolve_ids ui node ref ids of ui nodes');
14594: THEN
14595: log_timing_message('start resolve_ids ps node ids of ui nodes');
14596: END IF;
14597:
14598: 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');
14599:
14600: IF (cz_pb_mgr.g_log_timing = publication_timing)
14601: THEN
14602: log_timing_message('end resolve_ids ps node ids of ui nodes');
14607: THEN
14608: log_timing_message('start resolve_ids component ids of ui nodes');
14609: END IF;
14610:
14611: 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');
14612:
14613: IF (cz_pb_mgr.g_log_timing = publication_timing)
14614: THEN
14615: log_timing_message('end resolve_ids component ids of ui nodes');
14612:
14613: IF (cz_pb_mgr.g_log_timing = publication_timing)
14614: THEN
14615: log_timing_message('end resolve_ids component ids of ui nodes');
14616: log_timing_message('start resolve_ids model ref expl id of cz_ui nodes');
14617: END IF;
14618:
14619: 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');
14620:
14615: log_timing_message('end resolve_ids component ids of ui nodes');
14616: log_timing_message('start resolve_ids model ref expl id of cz_ui nodes');
14617: END IF;
14618:
14619: 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');
14620:
14621: IF (cz_pb_mgr.g_log_timing = publication_timing)
14622: THEN
14623: log_timing_message('end resolve_ids model ref expl id of cz_ui nodes');
14619: 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');
14620:
14621: IF (cz_pb_mgr.g_log_timing = publication_timing)
14622: THEN
14623: log_timing_message('end resolve_ids model ref expl id of cz_ui nodes');
14624: log_timing_message('start resolve_ids func comp ids of ui nodes');
14625: END IF;
14626:
14627: ---------resolve func comp ids of ui nodes
14624: log_timing_message('start resolve_ids func comp ids of ui nodes');
14625: END IF;
14626:
14627: ---------resolve func comp ids of ui nodes
14628: 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');
14629:
14630: IF (cz_pb_mgr.g_log_timing = publication_timing)
14631: THEN
14632: log_timing_message('end resolve_ids func comp ids of ui nodes');
14634: END IF;
14635:
14636: ---------resolve ui_def_ref_id
14637: -- should call resolve_ids instead
14638: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
14639: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14640: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
14641: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
14642: ,'cz_ui_nodes.ui_def_ref_id'
14637: -- should call resolve_ids instead
14638: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
14639: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14640: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
14641: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
14642: ,'cz_ui_nodes.ui_def_ref_id'
14643: ,cz_pb_mgr.v_status_code
14644: );
14645:
14638: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_ui_nodes_new_ref
14639: ,cz_pb_mgr.v_cz_ui_defs_old_ref
14640: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
14641: ,cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref
14642: ,'cz_ui_nodes.ui_def_ref_id'
14643: ,cz_pb_mgr.v_status_code
14644: );
14645:
14646: IF (cz_pb_mgr.g_log_timing = publication_timing)
14649: log_timing_message('start resolve_remote_ui_nodes');
14650: END IF;
14651:
14652: ----------resolve remote ui_node_ids
14653: resolve_remote_ui_nodes(cz_pb_mgr.v_cz_ui_nodes_new_ref
14654: ,cz_pb_mgr.v_models_not_to_be_exported
14655: ,cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref
14656: ,cz_pb_mgr.v_server_id
14657: ,cz_pb_mgr.v_status_code
14651:
14652: ----------resolve remote ui_node_ids
14653: resolve_remote_ui_nodes(cz_pb_mgr.v_cz_ui_nodes_new_ref
14654: ,cz_pb_mgr.v_models_not_to_be_exported
14655: ,cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref
14656: ,cz_pb_mgr.v_server_id
14657: ,cz_pb_mgr.v_status_code
14658: );
14659:
14665: --------populate plsql_table_list for ui_nodes
14666: plsql_table_list.DELETE;
14667: rec_count := 1;
14668: plsql_table_list(rec_count).col_name := 'ui_node_id';
14669: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_new_ref';
14670: rec_count := rec_count + 1;
14671: plsql_table_list(rec_count).col_name := 'ui_def_id';
14672: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref';
14673: rec_count := rec_count + 1;
14668: plsql_table_list(rec_count).col_name := 'ui_node_id';
14669: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_new_ref';
14670: rec_count := rec_count + 1;
14671: plsql_table_list(rec_count).col_name := 'ui_def_id';
14672: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref';
14673: rec_count := rec_count + 1;
14674: plsql_table_list(rec_count).col_name := 'parent_id';
14675: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_parent_id_ref';
14676: rec_count := rec_count + 1;
14671: plsql_table_list(rec_count).col_name := 'ui_def_id';
14672: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_def_id_ref';
14673: rec_count := rec_count + 1;
14674: plsql_table_list(rec_count).col_name := 'parent_id';
14675: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_parent_id_ref';
14676: rec_count := rec_count + 1;
14677: plsql_table_list(rec_count).col_name := 'component_id';
14678: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_component_id_ref';
14679: rec_count := rec_count + 1;
14674: plsql_table_list(rec_count).col_name := 'parent_id';
14675: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_parent_id_ref';
14676: rec_count := rec_count + 1;
14677: plsql_table_list(rec_count).col_name := 'component_id';
14678: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_component_id_ref';
14679: rec_count := rec_count + 1;
14680: plsql_table_list(rec_count).col_name := 'ps_node_id';
14681: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref';
14682: rec_count := rec_count + 1;
14677: plsql_table_list(rec_count).col_name := 'component_id';
14678: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_component_id_ref';
14679: rec_count := rec_count + 1;
14680: plsql_table_list(rec_count).col_name := 'ps_node_id';
14681: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref';
14682: rec_count := rec_count + 1;
14683: plsql_table_list(rec_count).col_name := 'ui_node_ref_id';
14684: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref';
14685: rec_count := rec_count + 1;
14680: plsql_table_list(rec_count).col_name := 'ps_node_id';
14681: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ps_node_id_ref';
14682: rec_count := rec_count + 1;
14683: plsql_table_list(rec_count).col_name := 'ui_node_ref_id';
14684: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref';
14685: rec_count := rec_count + 1;
14686: plsql_table_list(rec_count).col_name := 'ui_def_ref_id';
14687: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref';
14688: rec_count := rec_count + 1;
14683: plsql_table_list(rec_count).col_name := 'ui_node_ref_id';
14684: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_ref_id_ref';
14685: rec_count := rec_count + 1;
14686: plsql_table_list(rec_count).col_name := 'ui_def_ref_id';
14687: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref';
14688: rec_count := rec_count + 1;
14689: plsql_table_list(rec_count).col_name := 'func_comp_id';
14690: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref';
14691: rec_count := rec_count + 1;
14686: plsql_table_list(rec_count).col_name := 'ui_def_ref_id';
14687: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_ui_dref_id_ref';
14688: rec_count := rec_count + 1;
14689: plsql_table_list(rec_count).col_name := 'func_comp_id';
14690: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref';
14691: rec_count := rec_count + 1;
14692: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
14693: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_expl_id_ref';
14694: rec_count := rec_count + 1;
14689: plsql_table_list(rec_count).col_name := 'func_comp_id';
14690: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_fcomp_id_ref';
14691: rec_count := rec_count + 1;
14692: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
14693: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_expl_id_ref';
14694: rec_count := rec_count + 1;
14695: plsql_table_list(rec_count).col_name := 'caption_id';
14696: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_capt_id_ref';
14697: rec_count := rec_count + 1;
14692: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
14693: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_expl_id_ref';
14694: rec_count := rec_count + 1;
14695: plsql_table_list(rec_count).col_name := 'caption_id';
14696: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_capt_id_ref';
14697: rec_count := rec_count + 1;
14698: plsql_table_list(rec_count).col_name := 'tool_tip_id';
14699: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_tool_id_ref';
14700:
14695: plsql_table_list(rec_count).col_name := 'caption_id';
14696: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_capt_id_ref';
14697: rec_count := rec_count + 1;
14698: plsql_table_list(rec_count).col_name := 'tool_tip_id';
14699: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_tool_id_ref';
14700:
14701: IF (cz_pb_mgr.g_log_timing = publication_timing)
14702: THEN
14703: log_timing_message('start insert_into_table cz_ui_nodes');
14699: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_ui_nodes_tool_id_ref';
14700:
14701: IF (cz_pb_mgr.g_log_timing = publication_timing)
14702: THEN
14703: log_timing_message('start insert_into_table cz_ui_nodes');
14704: END IF;
14705:
14706: -----------insert into cz_ui_nodes of target server
14707: insert_into_table('cz_ui_nodes'
14702: THEN
14703: log_timing_message('start insert_into_table cz_ui_nodes');
14704: END IF;
14705:
14706: -----------insert into cz_ui_nodes of target server
14707: insert_into_table('cz_ui_nodes'
14708: ,'ui_node_id'
14709: ,cz_pb_mgr.v_db_link
14710: ,plsql_table_list
14703: log_timing_message('start insert_into_table cz_ui_nodes');
14704: END IF;
14705:
14706: -----------insert into cz_ui_nodes of target server
14707: insert_into_table('cz_ui_nodes'
14708: ,'ui_node_id'
14709: ,cz_pb_mgr.v_db_link
14710: ,plsql_table_list
14711: ,'cz_pb_mgr.v_cz_ui_nodes_old_ref'
14707: insert_into_table('cz_ui_nodes'
14708: ,'ui_node_id'
14709: ,cz_pb_mgr.v_db_link
14710: ,plsql_table_list
14711: ,'cz_pb_mgr.v_cz_ui_nodes_old_ref'
14712: ,cz_pb_mgr.v_cz_ui_nodes_old_ref
14713: );
14714:
14715: IF (cz_pb_mgr.g_log_timing = publication_timing)
14708: ,'ui_node_id'
14709: ,cz_pb_mgr.v_db_link
14710: ,plsql_table_list
14711: ,'cz_pb_mgr.v_cz_ui_nodes_old_ref'
14712: ,cz_pb_mgr.v_cz_ui_nodes_old_ref
14713: );
14714:
14715: IF (cz_pb_mgr.g_log_timing = publication_timing)
14716: THEN
14713: );
14714:
14715: IF (cz_pb_mgr.g_log_timing = publication_timing)
14716: THEN
14717: log_timing_message('end insert_into_table cz_ui_nodes');
14718: END IF;
14719:
14720: --------populate plsql_table_list for ui_node_props
14721: IF (cz_pb_mgr.g_log_timing = publication_timing)
14730: log_timing_message('end insert_into_table cz_ui_node_props');
14731: END IF;
14732:
14733: -------------release local pl/sql tables
14734: v_cz_ui_nodes_new_tbl.DELETE;
14735: v_cz_ui_nodes_old_tbl.DELETE;
14736: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14731: END IF;
14732:
14733: -------------release local pl/sql tables
14734: v_cz_ui_nodes_new_tbl.DELETE;
14735: v_cz_ui_nodes_old_tbl.DELETE;
14736: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14732:
14733: -------------release local pl/sql tables
14734: v_cz_ui_nodes_new_tbl.DELETE;
14735: v_cz_ui_nodes_old_tbl.DELETE;
14736: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14733: -------------release local pl/sql tables
14734: v_cz_ui_nodes_new_tbl.DELETE;
14735: v_cz_ui_nodes_old_tbl.DELETE;
14736: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14741: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14734: v_cz_ui_nodes_new_tbl.DELETE;
14735: v_cz_ui_nodes_old_tbl.DELETE;
14736: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14741: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14742: v_cz_ui_nodes_expl_id_tbl.DELETE;
14735: v_cz_ui_nodes_old_tbl.DELETE;
14736: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14741: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14742: v_cz_ui_nodes_expl_id_tbl.DELETE;
14743: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14736: v_cz_ui_nodes_ui_def_id_tbl.DELETE;
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14741: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14742: v_cz_ui_nodes_expl_id_tbl.DELETE;
14743: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14744:
14737: v_cz_ui_nodes_parent_id_tbl.DELETE;
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14741: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14742: v_cz_ui_nodes_expl_id_tbl.DELETE;
14743: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14744:
14745: EXCEPTION
14738: v_cz_ui_nodes_ui_ref_id_tbl.DELETE;
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14741: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14742: v_cz_ui_nodes_expl_id_tbl.DELETE;
14743: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14744:
14745: EXCEPTION
14746: WHEN OTHERS
14739: v_cz_ui_nodes_ps_node_id_tbl.DELETE;
14740: v_cz_ui_nodes_component_id_tbl.DELETE;
14741: v_cz_ui_nodes_ui_dref_id_tbl.DELETE;
14742: v_cz_ui_nodes_expl_id_tbl.DELETE;
14743: v_cz_ui_nodes_fcomp_id_tbl.DELETE;
14744:
14745: EXCEPTION
14746: WHEN OTHERS
14747: THEN
17364: END IF;
17365: ELSE
17366: IF (l_ui_style IN(g_ui_style_dhtml, g_ui_style_applet)) THEN
17367: SELECT DISTINCT ui_def_id BULK COLLECT INTO l_ui_tbl
17368: FROM cz_ui_nodes
17369: WHERE deleted_flag = '0'
17370: START WITH ui_def_id = p_ui_def_id
17371: CONNECT BY PRIOR ui_def_ref_id = ui_def_id AND PRIOR deleted_flag = '0';
17372: ELSIF (l_ui_style = g_ui_style_jrad) THEN