APPS.CSF_LOCUS_PUB dependencies on HZ_LOCATIONS

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

711: END compute_and_save_route;
712:
713: /**
714: * For each Location given in the Location Table, the Location Record
715: * in HZ_LOCATIONS will be updated with the Geometry containing the
716: * Latitude and Longitude as given by the corresponding PLSQL Tables.
717: */
718: PROCEDURE compute_and_save_locuses(
719: p_api_version IN NUMBER

Line 752: UPDATE hz_locations

748:
749: l_srid := NVL(p_srid, 8307);
750:
751: FORALL i IN 1..p_location_id_tbl.COUNT
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)