DBA Data[Home] [Help]

APPS.CZ_RUNTIME dependencies on CZ_UI_DEFS

Line 918: WHERE devl_project_id=(SELECT devl_project_id FROM CZ_UI_DEFS WHERE ui_def_id=p_target_ui_def_id) AND

914: AND PRIOR deleted_flag='0')
915: LOOP
916:
917: SELECT ps_node_id INTO l_target_ps_node_id FROM CZ_PS_NODES
918: WHERE devl_project_id=(SELECT devl_project_id FROM CZ_UI_DEFS WHERE ui_def_id=p_target_ui_def_id) AND
919: persistent_node_id=p_target_page_persist_id AND deleted_flag='0';
920:
921: RETURN TO_CHAR(l_root_persist_id)||'.'||cz_developer_utils_pvt.annotated_node_path (
922: p_root_model_id,

Line 1009: FROM CZ_UI_DEFS WHERE ui_def_id=p_root_ui_def_id;

1005: x_ui_page_tbl := SYSTEM.cz_tgt_ui_page_tbl(SYSTEM.CZ_TGT_UI_PAGE_REC(NULL,NULL,NULL,NULL,NULL,NULL));
1006: l_tbl_counter := 1;
1007:
1008: SELECT devl_project_id INTO l_root_model_id
1009: FROM CZ_UI_DEFS WHERE ui_def_id=p_root_ui_def_id;
1010:
1011:
1012: FOR k IN(SELECT vv.target_page_id, vv.target_ui_def_id,vv.element_id,vv.bound_via_parent_flag from cz_uipages_for_explnodes_v vv
1013: WHERE vv.root_ui_def_id = p_root_ui_def_id AND