122: VALUES
123: (
124: l_postal_code_rec.location_postal_code_id,
125: SYSDATE,
126: FND_GLOBAL.user_id,
127: SYSDATE,
128: FND_GLOBAL.user_id,
129: FND_GLOBAL.conc_login_id,
130: 1,
124: l_postal_code_rec.location_postal_code_id,
125: SYSDATE,
126: FND_GLOBAL.user_id,
127: SYSDATE,
128: FND_GLOBAL.user_id,
129: FND_GLOBAL.conc_login_id,
130: 1,
131: l_postal_code_rec.orig_system_ref,
132: l_postal_code_rec.orig_system_id,
125: SYSDATE,
126: FND_GLOBAL.user_id,
127: SYSDATE,
128: FND_GLOBAL.user_id,
129: FND_GLOBAL.conc_login_id,
130: 1,
131: l_postal_code_rec.orig_system_ref,
132: l_postal_code_rec.orig_system_id,
133: l_postal_code_rec.location_area_id,
297: AND object_version_number = l_postal_code_rec.object_version_number;
298: ELSE
299: UPDATE JTF_LOC_POSTAL_CODES SET
300: last_update_date = SYSDATE,
301: last_updated_by = FND_GLOBAL.user_id,
302: object_version_number = l_postal_code_rec.object_version_number + 1,
303: last_update_login = FND_GLOBAL.conc_login_id,
304: orig_system_ref = l_postal_code_rec.orig_system_ref,
305: orig_system_id = l_postal_code_rec.orig_system_id,
299: UPDATE JTF_LOC_POSTAL_CODES SET
300: last_update_date = SYSDATE,
301: last_updated_by = FND_GLOBAL.user_id,
302: object_version_number = l_postal_code_rec.object_version_number + 1,
303: last_update_login = FND_GLOBAL.conc_login_id,
304: orig_system_ref = l_postal_code_rec.orig_system_ref,
305: orig_system_id = l_postal_code_rec.orig_system_id,
306: location_area_id = l_postal_code_rec.location_area_id,
307: start_date_active = l_postal_code_rec.start_date_active,