1949: l_module_name CONSTANT VARCHAR2(30) := 'LOCK_ROW';
1950:
1951: CURSOR C1 IS
1952: SELECT *
1953: FROM WMS_ZONES_VL
1954: WHERE ZONE_ID = P_ZONE_ID
1955: FOR UPDATE OF ZONE_ID NOWAIT;
1956:
1957: rec1 C1%ROWTYPE;
2281: WHERE organization_id = p_organization_id;
2282:
2283: CURSOR c_zone_name IS
2284: SELECT 1
2285: FROM wms_zones_vl
2286: WHERE zone_name = p_zone_name
2287: AND organization_id = p_organization_id;
2288:
2289: BEGIN