APPS.CSF_LOCUS_PUB dependencies on SDO_ELEM_INFO_ARRAY

Line 38: , MDSYS.sdo_elem_info_array(1, 1, 1)

34: MDSYS.SDO_GEOMETRY(
35: 2001
36: , NULL
37: , MDSYS.sdo_point_type(p_locus.sdo_ordinates(1), p_locus.sdo_ordinates(2), NULL)
38: , MDSYS.sdo_elem_info_array(1, 1, 1)
39: , NULL
40: );
41: x_return_status := g_ret_locus_success;
42:

Line 56: , MDSYS.sdo_elem_info_array(1, 1, 1)

52: MDSYS.SDO_GEOMETRY(
53: 2001
54: , NULL
55: , MDSYS.sdo_point_type(p_locus.sdo_point.x, p_locus.sdo_point.y, NULL)
56: , MDSYS.sdo_elem_info_array(1, 1, 1)
57: , NULL
58: );
59: x_return_status := g_ret_locus_success;
60: ELSE

Line 108: , MDSYS.sdo_elem_info_array(1, 1, 1, l_ordinates.COUNT + 1, 0, 5)

104: MDSYS.SDO_GEOMETRY(
105: 2001
106: , NULL
107: , NULL
108: , MDSYS.sdo_elem_info_array(1, 1, 1, l_ordinates.COUNT + 1, 0, 5)
109: , l_ordinates
110: );
111: x_locus.sdo_ordinates.EXTEND(5);
112: x_locus.sdo_ordinates(x_locus.sdo_elem_info(4)) := p_accuracyFactor;

Line 861: , mdsys.sdo_elem_info_array(1,1,1)

857: SET geometry = mdsys.sdo_geometry(
858: 2001
859: , l_srid
860: , mdsys.sdo_point_type( p_longitude_tbl(i), p_latitude_tbl(i), 0)
861: , mdsys.sdo_elem_info_array(1,1,1)
862: , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )
863: )
864: WHERE location_id = p_location_id_tbl(i);
865:

Line 1035: WHERE SDO_NN(r.ROADSEGMENT_GEOMETRY, SDO_GEOMETRY(2002,8307,null,SDO_ELEM_INFO_ARRAY(1,2,1),

1031: select spatial_dataset into l_tbl_sufx from CSF_SPATIAL_CTRY_MAPPINGS where spatial_country_name = p_country or spatial_country_code = p_country;
1032:
1033: l_sql_stmt := 'SELECT /*+ INDEX(r CSF_LF_RDSEGS_N2) */ ROADSEGMENT_ID, SDO_NN_DISTANCE(1) dist
1034: FROM csf_lf_roadsegments' || l_tbl_sufx || ' r
1035: WHERE SDO_NN(r.ROADSEGMENT_GEOMETRY, SDO_GEOMETRY(2002,8307,null,SDO_ELEM_INFO_ARRAY(1,2,1),
1036: SDO_ORDINATE_ARRAY(:1, :2, :3, :4)), ''sdo_num_res=1'', 1) = ''TRUE'' ORDER BY dist';
1037:
1038: OPEN cursor_rdseg for l_sql_stmt USING p_longitude,p_latitude,p_longitude,p_latitude;
1039: LOOP