349: END IF;
350:
351:
352: --
353: -- do not call Irc_location_utility.address2geometry function if all parameters passed are null
354: --
355: if((p_rec.address_line_1 is null)
356: and (p_rec.address_line_2 is null)
357: and (p_rec.address_line_3 is null)
372: --
373: if ((fnd_profile.value('IRC_INSTALLED_FLAG') in ('Y','D')) and
374: (fnd_profile.value('IRC_GEOCODE_HOST')is not null)
375: )then
376: p_rec.geometry := Irc_location_utility.address2geometry
377: (address_line1 => p_rec.address_line_1
378: ,address_line2 => p_rec.address_line_2
379: ,address_line3 => p_rec.address_line_3
380: ,address_line4 => p_rec.town_or_city