DBA Data[Home] [Help]

APPS.CSF_LOCUS_PUB dependencies on SDO_POINT_TYPE

Line 44: , MDSYS.sdo_point_type(p_locus.sdo_ordinates(1), p_locus.sdo_ordinates(2), NULL)

40: x_geom :=
41: MDSYS.SDO_GEOMETRY(
42: 2001
43: , NULL
44: , MDSYS.sdo_point_type(p_locus.sdo_ordinates(1), p_locus.sdo_ordinates(2), NULL)
45: , MDSYS.sdo_elem_info_array(1, 1, 1)
46: , NULL
47: );
48: x_return_status := g_ret_locus_success;

Line 756: , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)

752: UPDATE hz_locations
753: SET geometry = mdsys.sdo_geometry(
754: 2001
755: , l_srid
756: , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)
757: , mdsys.sdo_elem_info_array(1,1,1)
758: , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )
759: )
760: WHERE location_id = p_location_id_tbl(i);