153: UPDATE pn_locations_all /*sdm14jul*/
154: SET location_code = new_cd_tbl(i),
155: location_alias = als_nm_tbl(i),
156: last_update_date = SYSDATE,
157: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
158: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
159: WHERE location_id = loc_id_tbl(i)
160: AND NVL(TRUNC(ACTIVE_END_DATE), TRUNC(SYSDATE)) >= TRUNC(SYSDATE); /* Bug 6735518 */
161:
154: SET location_code = new_cd_tbl(i),
155: location_alias = als_nm_tbl(i),
156: last_update_date = SYSDATE,
157: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),
158: last_update_login = nvl(fnd_profile.value('USER_ID'), -1)
159: WHERE location_id = loc_id_tbl(i)
160: AND NVL(TRUNC(ACTIVE_END_DATE), TRUNC(SYSDATE)) >= TRUNC(SYSDATE); /* Bug 6735518 */
161:
162: pnp_debug_pkg.debug(l_desc ||' (-)');