DBA Data[Home] [Help]

APPS.IRC_ISC_INS dependencies on SDO_POINT_TYPE

Line 93: ,mdsys.sdo_point_type(p_rec.longitude,p_rec.latitude,null),null,null);

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
97: (search_criteria_id