238: l_user_id NUMBER DEFAULT NULL;
239:
240: CURSOR c_selected_terr( b_user_id NUMBER ) IS
241: SELECT terr_id
242: from csf_user_selected_terrs
243: WHERE user_id = b_user_id;
244:
245: CURSOR c_plan_terr(b_resource_id NUMBER) IS
246: SELECT DISTINCT pt.terr_id
320: l_user_id := p_user_id;
321: END IF;
322:
323: IF p_selected_terr IS NOT NULL THEN
324: UPDATE csf_user_selected_terrs
325: SET terr_id = p_selected_terr
326: , last_updated_by = fnd_global.user_id
327: , last_update_date = SYSDATE
328: , last_update_login = fnd_global.login_id
329: , object_version_number = object_version_number + 1
330: WHERE user_id = l_user_id;
331:
332: IF sql%NOTFOUND THEN
333: INSERT INTO csf_user_selected_terrs (
334: user_id
335: , terr_id
336: , last_updated_by
337: , last_update_date