[Home] [Help]
212: l_distance_lvl VARCHAR2(50);
213:
214: BEGIN
215:
216: fnd_profile.get('FTE_DISTANCE_LVL', l_distance_lvl);
217:
218: IF (l_distance_lvl is null) THEN
219: RETURN(NULL);
220: ELSIF (l_distance_lvl = 'CITYSTATE') THEN
239: PROCEDURE GET_DIST_PROFILE (x_profile_value OUT NOCOPY VARCHAR2) IS
240:
241: BEGIN
242:
243: fnd_profile.get('FTE_DISTANCE_LVL',x_profile_value);
244: RETURN;
245:
246: EXCEPTION
247: WHEN OTHERS THEN