APPS.HXT_UTIL dependencies on FND_USER

Line 444: --------------------------Fnd Username --------------------------

440: END IF;
441: END LOOP;
442: END;
443: --
444: --------------------------Fnd Username --------------------------
445: FUNCTION Fnd_Username( a_user_id NUMBER ) RETURN VARCHAR2 IS
446: -- Get FND user name
447: CURSOR cur_user is
448: SELECT user_name

Line 445: FUNCTION Fnd_Username( a_user_id NUMBER ) RETURN VARCHAR2 IS

441: END LOOP;
442: END;
443: --
444: --------------------------Fnd Username --------------------------
445: FUNCTION Fnd_Username( a_user_id NUMBER ) RETURN VARCHAR2 IS
446: -- Get FND user name
447: CURSOR cur_user is
448: SELECT user_name
449: FROM fnd_user

Line 446: -- Get FND user name

442: END;
443: --
444: --------------------------Fnd Username --------------------------
445: FUNCTION Fnd_Username( a_user_id NUMBER ) RETURN VARCHAR2 IS
446: -- Get FND user name
447: CURSOR cur_user is
448: SELECT user_name
449: FROM fnd_user
450: WHERE user_id = a_user_id;

Line 449: FROM fnd_user

445: FUNCTION Fnd_Username( a_user_id NUMBER ) RETURN VARCHAR2 IS
446: -- Get FND user name
447: CURSOR cur_user is
448: SELECT user_name
449: FROM fnd_user
450: WHERE user_id = a_user_id;
451: l_user_name fnd_user.user_name%TYPE;
452: BEGIN
453: OPEN cur_user;

Line 451: l_user_name fnd_user.user_name%TYPE;

447: CURSOR cur_user is
448: SELECT user_name
449: FROM fnd_user
450: WHERE user_id = a_user_id;
451: l_user_name fnd_user.user_name%TYPE;
452: BEGIN
453: OPEN cur_user;
454: FETCH cur_user INTO l_user_name;
455: CLOSE cur_user;

Line 457: END fnd_username;

453: OPEN cur_user;
454: FETCH cur_user INTO l_user_name;
455: CLOSE cur_user;
456: return (l_user_name);
457: END fnd_username;
458: --
459: --------------------------Element Cat --------------------------
460: -- BEGIN ORACLE bug #712501
461: FUNCTION element_cat(p_element_type_id IN NUMBER,

Line 1013: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id;

1009: l_error_text VARCHAR2(128) DEFAULT NULL;
1010: l_batch_id_error EXCEPTION;
1011: l_reference_num_error EXCEPTION;
1012: l_retcode NUMBER DEFAULT 0;
1013: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id;
1014: l_user_name fnd_user.user_name%TYPE := 'OTM';
1015: l_sysdate DATE := trunc(SYSDATE);
1016: l_bus_group_id hr_organization_units.business_group_id%TYPE :=
1017: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );

Line 1014: l_user_name fnd_user.user_name%TYPE := 'OTM';

1010: l_batch_id_error EXCEPTION;
1011: l_reference_num_error EXCEPTION;
1012: l_retcode NUMBER DEFAULT 0;
1013: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id;
1014: l_user_name fnd_user.user_name%TYPE := 'OTM';
1015: l_sysdate DATE := trunc(SYSDATE);
1016: l_bus_group_id hr_organization_units.business_group_id%TYPE :=
1017: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
1018: