DBA Data[Home] [Help]

APPS.PON_PROFILE_UTIL_PKG dependencies on FND_USER

Line 396: FROM fnd_user

392: BEGIN
393: BEGIN
394: SELECT user_id
395: INTO ln_user_id
396: FROM fnd_user
397: WHERE user_name = upper(p_user_name);
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN
400: ln_user_id := null;

Line 451: ln_user_id fnd_user.user_id%TYPE;

447: --
448: PROCEDURE GET_WF_TERRITORY(p_user_name IN VARCHAR2,x_territory_code OUT NOCOPY VARCHAR2)
449: IS
450: l_territory VARCHAR2(150);
451: ln_user_id fnd_user.user_id%TYPE;
452: BEGIN
453:
454: SELECT user_id
455: INTO ln_user_id

Line 456: FROM fnd_user

452: BEGIN
453:
454: SELECT user_id
455: INTO ln_user_id
456: FROM fnd_user
457: WHERE user_name = upper(p_user_name);
458:
459: l_territory := fnd_profile.value_specific('ICX_TERRITORY', ln_user_id, NULL, NULL);
460: