APPS.CZ_PB_MGR dependencies on CZ_UI_NODE_PROPS

Line 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);

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'

Line 7105: FROM cz_ui_node_props

7101:
7102: CURSOR ui_node_props_cur(nodeprops_ui_def_id NUMBER)
7103: IS
7104: SELECT last_update_date
7105: FROM cz_ui_node_props
7106: WHERE cz_ui_node_props.ui_def_id = nodeprops_ui_def_id AND cz_ui_node_props.deleted_flag = '0'
7107: ORDER BY last_update_date DESC;
7108:
7109: CURSOR ui_intl_texts_cur(p_ui_def_id NUMBER)

Line 7106: WHERE cz_ui_node_props.ui_def_id = nodeprops_ui_def_id AND cz_ui_node_props.deleted_flag = '0'

7102: CURSOR ui_node_props_cur(nodeprops_ui_def_id NUMBER)
7103: IS
7104: SELECT last_update_date
7105: FROM cz_ui_node_props
7106: WHERE cz_ui_node_props.ui_def_id = nodeprops_ui_def_id AND cz_ui_node_props.deleted_flag = '0'
7107: ORDER BY last_update_date DESC;
7108:
7109: CURSOR ui_intl_texts_cur(p_ui_def_id NUMBER)
7110: IS

Line 13930: FROM cz_ui_node_props prop, cz_ui_nodes node

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

Line 13961: insert_into_table('cz_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';
13960: l_plsql_table_list(2).table_name := 'cz_pb_mgr.g_ui_node_prop_new_uidf_tbl';
13961: insert_into_table('cz_ui_node_props'
13962: ,'ui_node_id'
13963: ,'ui_def_id'
13964: ,cz_pb_mgr.v_db_link
13965: ,l_plsql_table_list

Line 13978: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_node_props', 'ERR', SQLERRM);

13974: COMMIT;
13975: EXCEPTION
13976: WHEN OTHERS
13977: THEN
13978: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_node_props', 'ERR', SQLERRM);
13979: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.NODEPROPS', SQLCODE);
13980: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
13981: END insert_ui_node_props;
13982:

Line 14723: log_timing_message('start insert_into_table cz_ui_node_props');

14719:
14720: --------populate plsql_table_list for ui_node_props
14721: IF (cz_pb_mgr.g_log_timing = publication_timing)
14722: THEN
14723: log_timing_message('start insert_into_table cz_ui_node_props');
14724: END IF;
14725:
14726: insert_ui_node_props(cz_pb_mgr.v_cz_ui_defs_old_ref);
14727:

Line 14730: log_timing_message('end insert_into_table cz_ui_node_props');

14726: insert_ui_node_props(cz_pb_mgr.v_cz_ui_defs_old_ref);
14727:
14728: IF (cz_pb_mgr.g_log_timing = publication_timing)
14729: THEN
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;