840: --
841: END check_unique_name;
842:
843:
844: function get_org_name(p_organization_id IN per_organization_units.organization_id%TYPE)
845: return varchar2 is
846: cursor org_units is
847: select name
848: from per_organization_units porg
844: function get_org_name(p_organization_id IN per_organization_units.organization_id%TYPE)
845: return varchar2 is
846: cursor org_units is
847: select name
848: from per_organization_units porg
849: where porg.organization_id = p_organization_id;
850:
851: l_name per_organization_units.name%TYPE;
852:
847: select name
848: from per_organization_units porg
849: where porg.organization_id = p_organization_id;
850:
851: l_name per_organization_units.name%TYPE;
852:
853: begin
854: for org_units_rec in org_units
855: loop