APPS.CZ_PB_MGR dependencies on CZ_UI_NODE_PROPS

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

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'

Line 7828: FROM cz_ui_node_props

7824:
7825: CURSOR ui_node_props_cur(nodeprops_ui_def_id NUMBER)
7826: IS
7827: SELECT last_update_date
7828: FROM cz_ui_node_props
7829: WHERE cz_ui_node_props.ui_def_id = nodeprops_ui_def_id AND cz_ui_node_props.deleted_flag = '0'
7830: ORDER BY last_update_date DESC;
7831:
7832: CURSOR ui_intl_texts_cur(p_ui_def_id NUMBER)

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

7825: CURSOR ui_node_props_cur(nodeprops_ui_def_id NUMBER)
7826: IS
7827: SELECT last_update_date
7828: FROM cz_ui_node_props
7829: WHERE cz_ui_node_props.ui_def_id = nodeprops_ui_def_id AND cz_ui_node_props.deleted_flag = '0'
7830: ORDER BY last_update_date DESC;
7831:
7832: CURSOR ui_intl_texts_cur(p_ui_def_id NUMBER)
7833: IS

Line 14990: FROM cz_ui_node_props prop, cz_ui_nodes node

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

Line 15021: insert_into_table('cz_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';
15020: l_plsql_table_list(2).table_name := 'cz_pb_mgr.g_ui_node_prop_new_uidf_tbl';
15021: insert_into_table('cz_ui_node_props'
15022: ,'ui_node_id'
15023: ,'ui_def_id'
15024: ,cz_pb_mgr.v_db_link
15025: ,l_plsql_table_list

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

15034: COMMIT;
15035: EXCEPTION
15036: WHEN OTHERS
15037: THEN
15038: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_node_props', 'ERR', SQLERRM);
15039: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.NODEPROPS', SQLCODE);
15040: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15041: END insert_ui_node_props;
15042:

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

15779:
15780: --------populate plsql_table_list for ui_node_props
15781: IF (cz_pb_mgr.g_log_timing = publication_timing)
15782: THEN
15783: log_timing_message('start insert_into_table cz_ui_node_props');
15784: END IF;
15785:
15786: insert_ui_node_props(cz_pb_mgr.v_cz_ui_defs_old_ref);
15787:

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

15786: insert_ui_node_props(cz_pb_mgr.v_cz_ui_defs_old_ref);
15787:
15788: IF (cz_pb_mgr.g_log_timing = publication_timing)
15789: THEN
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;