APPS.CSF_LOCUS_PUB dependencies on HZ_LOCATIONS

Line 819: * in HZ_LOCATIONS will be updated with the Geometry containing the

815: END compute_and_save_route;
816:
817: /**
818: * For each Location given in the Location Table, the Location Record
819: * in HZ_LOCATIONS will be updated with the Geometry containing the
820: * Latitude and Longitude as given by the corresponding PLSQL Tables.
821: */
822: PROCEDURE compute_and_save_locuses(
823: p_api_version IN NUMBER

Line 856: UPDATE hz_locations

852:
853: l_srid := NVL(p_srid, 8307);
854:
855: FORALL i IN 1..p_location_id_tbl.COUNT
856: UPDATE hz_locations
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)