367: --
368: --
369: -- Enhancement added for Location Searching
370: --
371: if ((fnd_profile.value('IRC_INSTALLED_FLAG') in ('Y','D')) and
372: (fnd_profile.value('IRC_GEOCODE_HOST')is not null)
373: )then
374: p_rec.geometry := Irc_location_utility.address2geometry
375: (address_line1 => p_rec.address_line_1
368: --
369: -- Enhancement added for Location Searching
370: --
371: if ((fnd_profile.value('IRC_INSTALLED_FLAG') in ('Y','D')) and
372: (fnd_profile.value('IRC_GEOCODE_HOST')is not null)
373: )then
374: p_rec.geometry := Irc_location_utility.address2geometry
375: (address_line1 => p_rec.address_line_1
376: ,address_line2 => p_rec.address_line_2