APPS.CSP_PART_SEARCH_PVT dependencies on SDO_GEOMETRY

Line 28: l_my_location sdo_geometry;

24: l_organization_id number;
25: l_subinventory_code varchar2(30);
26: l_enough number := -1;
27: l_open_or_closed varchar2(30) := 'OPEN';
28: l_my_location sdo_geometry;
29: l_distance_uom varchar2(30) := 'unit=km';
30: l_server_timezone_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
31: l_search_method varchar2(30):= nvl(p_search_params.search_method,
32: fnd_profile.value('CSP_PART_SEARCH_METHOD'));

Line 496: l_geometry mdsys.sdo_geometry;

492: where moq.organization_id = csi.organization_id
493: and moq.subinventory_code = csi.secondary_inventory_name
494: and moq.inventory_item_id = crpt.alternate_item_id);
495:
496: l_geometry mdsys.sdo_geometry;
497: l_point mdsys.sdo_point_type := mdsys.sdo_point_type(-9999,-9999,0);
498: l_test number := 0;
499: cursor c_compare(p_point mdsys.sdo_point_type) is
500: select 1 from dual

Line 514: l_geometry := MDSYS.SDO_GEOMETRY(2001,8307,cr.point,null,null);

510: fetch c_compare into l_test;
511: close c_compare;
512: log('technicians','l_test:'||l_test);
513: if l_test = 1 then
514: l_geometry := MDSYS.SDO_GEOMETRY(2001,8307,cr.point,null,null);
515: else
516: l_geometry := cr.geometry;
517: end if;
518: l_test := 0;

Line 2091: l_src_geo sdo_geometry;

2087: p_src_org_id number,
2088: p_src_subinv varchar2
2089: )
2090: return varchar2 is
2091: l_src_geo sdo_geometry;
2092: l_dest_geo sdo_geometry;
2093: l_distance_uom_code varchar2(10);
2094: l_distance_uom varchar2(100);
2095: l_distance varchar2(100) := '-';

Line 2092: l_dest_geo sdo_geometry;

2088: p_src_subinv varchar2
2089: )
2090: return varchar2 is
2091: l_src_geo sdo_geometry;
2092: l_dest_geo sdo_geometry;
2093: l_distance_uom_code varchar2(10);
2094: l_distance_uom varchar2(100);
2095: l_distance varchar2(100) := '-';
2096: l_distance_uom_meaning varchar2(100);