778: SELECT ui_def_ref_id
779: BULK
780: COLLECT
781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION
779: BULK
780: COLLECT
781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
780: COLLECT
781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: NULL;
781: INTO x_locked_entities
782: FROM cz_ui_nodes
783: WHERE cz_ui_nodes.deleted_flag = '0'
784: AND cz_ui_nodes.ui_def_ref_id IS NOT NULL
785: AND cz_ui_nodes.ui_def_id = p_entity_id;
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: NULL;
789: END;
897: SELECT ui_def_ref_id
898: BULK
899: COLLECT
900: INTO l_locked_entities
901: FROM cz_ui_nodes
902: WHERE deleted_flag = '0'
903: AND ui_def_ref_id IS NOT NULL
904: AND ui_def_id = p_entity_id;
905: