eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_SITE_UTILS dependencies on SDO_GEOMETRY

Line 265: select SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(p_x_coord,p_y_coord,null),null,null)

261: x_theme_id := 0;
262:
263: ELSIF(p_context_flag = 'IDENTIFY' OR p_context_flag = 'POINT_FEATURE' OR p_context_flag = 'POINT_FEATURE_AT_LOCATION') THEN
264:
265: select SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(p_x_coord,p_y_coord,null),null,null)
266: into l_geometry
267: from dual;
268:
269: IF(p_context_flag = 'IDENTIFY') THEN

Line 478: MDSYS.SDO_GEOMETRY(2001,

474: /* Bug 7143445 Do not stamp 0,0 for geometry */
475: UPDATE hz_locations
476: SET
477: geometry = decode(l_is_invalid_geocode, 1, NULL,
478: MDSYS.SDO_GEOMETRY(2001,
479: 8307,
480: SDO_POINT_TYPE(p_long, p_lat, NULL),
481: NULL,
482: NULL)),

Line 503: (geom IN MDSYS.SDO_GEOMETRY,

499:
500: END Update_geometry_for_locations;
501:
502: FUNCTION get_ordinate
503: (geom IN MDSYS.SDO_GEOMETRY,
504: indx IN NUMBER
505: ) RETURN NUMBER
506: IS
507: BEGIN