DBA Data[Home] [Help]

APPS.CSF_UTIL_PVT dependencies on FND_GLOBAL

Line 182: * in user (FND_GLOBAL.USER_ID)

178:
179: /**
180: * Checks whether the given Territory ID is one among the Selected Territories
181: * of the given user. If no user is given, then it checks using the signed
182: * in user (FND_GLOBAL.USER_ID)
183: *
184: * @param p_terr_id Territory ID of the Territory to be checked
185: * @param p_user_id User ID of the user whose list of Territories is used
186: */

Line 264: l_user_id := fnd_global.user_id;

260: l_terr_table := jtf_number_table();
261:
262: -- Use the logged in user's ID if no USER ID is passed to this function
263: IF p_user_id IS NULL THEN
264: l_user_id := fnd_global.user_id;
265: ELSE
266: l_user_id := p_user_id;
267: END IF;
268:

Line 318: l_user_id := fnd_global.user_id;

314: IS
315: l_user_id NUMBER DEFAULT NULL;
316: BEGIN
317: IF p_user_id IS NULL THEN
318: l_user_id := fnd_global.user_id;
319: ELSE
320: l_user_id := p_user_id;
321: END IF;
322:

Line 326: , last_updated_by = fnd_global.user_id

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;

Line 328: , last_update_login = fnd_global.login_id

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

Line 345: , fnd_global.user_id

341: , object_version_number
342: ) VALUES (
343: l_user_id
344: , p_selected_terr
345: , fnd_global.user_id
346: , SYSDATE
347: , fnd_global.login_id
348: , fnd_global.user_id
349: , SYSDATE

Line 347: , fnd_global.login_id

343: l_user_id
344: , p_selected_terr
345: , fnd_global.user_id
346: , SYSDATE
347: , fnd_global.login_id
348: , fnd_global.user_id
349: , SYSDATE
350: , 1);
351: END IF;

Line 348: , fnd_global.user_id

344: , p_selected_terr
345: , fnd_global.user_id
346: , SYSDATE
347: , fnd_global.login_id
348: , fnd_global.user_id
349: , SYSDATE
350: , 1);
351: END IF;
352: END IF;

Line 567: WHERE user_id = fnd_global.user_id

563: SELECT q.where_clause
564: , NVL(qe.owner_enabled_flag, 'N') owner_enabled_flag
565: , ( SELECT COUNT(*)
566: FROM csf_plan_task_owners
567: WHERE user_id = fnd_global.user_id
568: ) owners_count
569: FROM csf_dc_queries_b q
570: , csf_dc_query_extns qe
571: WHERE q.query_id = p_query_id

Line 572: AND qe.user_id(+) = fnd_global.user_id

568: ) owners_count
569: FROM csf_dc_queries_b q
570: , csf_dc_query_extns qe
571: WHERE q.query_id = p_query_id
572: AND qe.user_id(+) = fnd_global.user_id
573: AND qe.query_id(+) = q.query_id;
574:
575: l_query_info c_query_info%ROWTYPE;
576: BEGIN

Line 594: WHERE user_id=fnd_global.user_id) ';

590: l_query_info.where_clause
591: || ' AND (owner_id, owner_type_code)
592: IN (SELECT owner_id, owner_type_code
593: FROM csf_plan_task_owners
594: WHERE user_id=fnd_global.user_id) ';
595: END IF;
596: END IF;
597: RETURN l_query_info.where_clause;
598: END get_query_where;