eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_UTIL_PVT dependencies on CSF_USER_SELECTED_TERRS

Line 242: from csf_user_selected_terrs

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

Line 324: UPDATE csf_user_selected_terrs

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

Line 333: INSERT INTO csf_user_selected_terrs (

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