APPS.IRC_ISC_UPD dependencies on SDO_GEOMETRY

Line 61: l_geometry mdsys.sdo_geometry:=null;

57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: l_description clob;
61: l_geometry mdsys.sdo_geometry:=null;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: --

Line 70: l_geometry:=mdsys.sdo_geometry(2001,8307

66: -- Increment the object version
67: p_rec.object_version_number := p_rec.object_version_number + 1;
68: --
69: if p_rec.longitude is not null and p_rec.latitude is not null then
70: l_geometry:=mdsys.sdo_geometry(2001,8307
71: ,mdsys.sdo_point_type(p_rec.longitude,p_rec.latitude,null),null,null);
72: end if;
73: --
74: irc_isc_shd.g_api_dml := true; -- Set the api dml status