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