APPS.IRC_ISC_INS dependencies on SDO_GEOMETRY

Line 81: l_geometry mdsys.sdo_geometry :=null;

77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: l_description clob;
81: l_geometry mdsys.sdo_geometry :=null;
82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: p_rec.object_version_number := 1; -- Initialise the object version

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

88: --
89: -- Insert the row into: irc_search_criteria
90: --
91: if p_rec.longitude is not null and p_rec.latitude is not null then
92: l_geometry:=mdsys.sdo_geometry(2001,8307
93: ,mdsys.sdo_point_type(p_rec.longitude,p_rec.latitude,null),null,null);
94: end if;
95: --
96: insert into irc_search_criteria