471: -- ----------------------------------------------------------------------------------
472: -- |----------< Checks whether deletion of public template is allowed >-------|
473: -- ----------------------------------------------------------------------------------
474:
475: FUNCTION can_delete_public_template (p_template_id in hxc_time_building_blocks.time_building_block_id%type
476: ) RETURN VARCHAR2 IS
477:
478: CURSOR cur_attached_public_temp_grps(p_template_id in hxc_time_building_blocks.time_building_block_id%type)
479: IS
474:
475: FUNCTION can_delete_public_template (p_template_id in hxc_time_building_blocks.time_building_block_id%type
476: ) RETURN VARCHAR2 IS
477:
478: CURSOR cur_attached_public_temp_grps(p_template_id in hxc_time_building_blocks.time_building_block_id%type)
479: IS
480: SELECT heg.NAME FROM hxc_entity_groups heg ,
481: hxc_entity_group_comps hegc
482: WHERE