90: return null;
91: end;
92:
93: Function nl_get_territory(p_territory_code in varchar2) return varchar2 is
94: l_territory_name fnd_territories_vl.territory_short_name%type;
95: begin
96: select territory_short_name
97: into l_territory_name
98: from fnd_territories_vl
94: l_territory_name fnd_territories_vl.territory_short_name%type;
95: begin
96: select territory_short_name
97: into l_territory_name
98: from fnd_territories_vl
99: where territory_code = p_territory_code;
100: return l_territory_name;
101: exception
102: when no_data_found then
157: p_rec.tax_field12 := nl_get_territory(p_rec.tax_field31);
158:
159: Begin
160: select territory_short_name into p_rec.tax_field21
161: from fnd_territories_vl
162: where territory_code = p_rec.tax_field32;
163: Exception
164: when no_data_found then
165: null;