2607: end pre_update ;
2608:
2609: function get_territory_short_name ( p_territory_code in varchar2 )
2610: return varchar2 is
2611: l_return_value fnd_territories_vl.territory_short_name%type := null ;
2612: --
2613: cursor get_territory_short_name is
2614: select territory_short_name
2615: from fnd_territories_vl
2611: l_return_value fnd_territories_vl.territory_short_name%type := null ;
2612: --
2613: cursor get_territory_short_name is
2614: select territory_short_name
2615: from fnd_territories_vl
2616: where territory_code = p_territory_code ;
2617: begin
2618:
2619: if ( p_territory_code is not null ) then