245: --
246: --
247: -- Enhancement added for Location Searching
248: --
249: if((fnd_profile.value('IRC_INSTALLED_FLAG') in ('Y','D')) and
250: (fnd_profile.value('IRC_GEOCODE_HOST')is not null)
251: )then
252: p_rec.geometry := Irc_location_utility.address2geometry
253: (address_line1 => p_rec.address_line_1
246: --
247: -- Enhancement added for Location Searching
248: --
249: if((fnd_profile.value('IRC_INSTALLED_FLAG') in ('Y','D')) and
250: (fnd_profile.value('IRC_GEOCODE_HOST')is not null)
251: )then
252: p_rec.geometry := Irc_location_utility.address2geometry
253: (address_line1 => p_rec.address_line_1
254: ,address_line2 => p_rec.address_line_2