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.OTA_LEARNER_ENROLL_SS dependencies on FND_USER

Line 123: FND_USER

119: CURSOR csr_user(p_owner_id in number) IS
120: SELECT
121: USER_NAME
122: FROM
123: FND_USER
124: WHERE
125: Employee_id = p_owner_id ;
126:
127: CURSOR csr_activity(p_activity_version_id number )

Line 192: l_owner_username fnd_user.user_name%type;

188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;
191: l_version_name ota_activity_versions.version_name%type;
192: l_owner_username fnd_user.user_name%type;
193: l_offering_id ota_events.offering_id%type;
194: l_booking_status_used varchar2(20);
195:
196: l_existing_bookings NUMBER;

Line 1024: l_supervisor_username fnd_user.user_name%TYPE;

1020: actid IN NUMBER,
1021: funcmode IN VARCHAR2,
1022: resultout OUT nocopy VARCHAR2 ) IS
1023:
1024: l_supervisor_username fnd_user.user_name%TYPE;
1025:
1026: BEGIN
1027:
1028: IF (funcmode='RUN') THEN

Line 1907: FROM FND_USER

1903: AND fln.booking_id = p_booking_id;
1904:
1905: CURSOR C_USER(p_owner_id NUMBER) IS
1906: SELECT USER_NAME
1907: FROM FND_USER
1908: WHERE Employee_id = p_owner_id
1909: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
1910:
1911: l_username fnd_user.user_name%TYPE;

Line 1911: l_username fnd_user.user_name%TYPE;

1907: FROM FND_USER
1908: WHERE Employee_id = p_owner_id
1909: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
1910:
1911: l_username fnd_user.user_name%TYPE;
1912:
1913: BEGIN
1914: hr_utility.set_location('Entering:'||l_proc, 10);
1915:

Line 2135: fnd_user_resp_groups furg,

2131: cursor getResp(l_user_id in varchar2) is
2132: select fr.menu_id, furg.responsibility_id,
2133: furg.security_group_id, furg.responsibility_application_id
2134: from fnd_responsibility fr,
2135: fnd_user_resp_groups furg,
2136: fnd_user fu
2137: where fu.USER_ID = l_user_id
2138: and fu.START_DATE <= sysdate
2139: and (fu.END_DATE is null or fu.END_DATE > sysdate)

Line 2136: fnd_user fu

2132: select fr.menu_id, furg.responsibility_id,
2133: furg.security_group_id, furg.responsibility_application_id
2134: from fnd_responsibility fr,
2135: fnd_user_resp_groups furg,
2136: fnd_user fu
2137: where fu.USER_ID = l_user_id
2138: and fu.START_DATE <= sysdate
2139: and (fu.END_DATE is null or fu.END_DATE > sysdate)
2140: and furg.USER_ID = fu.USER_ID

Line 2168: -- from FND_USER

2164: close getFunctionId;
2165: -- Get user ID of current user (If not available)
2166: -- select USER_ID
2167: -- into l_user_id
2168: -- from FND_USER
2169: -- where USER_NAME = l_username;
2170:
2171: -- Get responsibility ID
2172:

Line 2432: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,

2428:
2429: PROCEDURE get_wf_attr_for_cancel_ntf
2430: (p_event_id IN ota_events.event_id%TYPE,
2431: p_person_id IN number,
2432: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2433: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2434: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2435: p_current_person_name OUT NOCOPY VARCHAR2,
2436: p_current_username OUT NOCOPY VARCHAR2,

Line 2445: l_display_person_id fnd_user.employee_id%TYPE;

2441:
2442: l_proc VARCHAR2(72) := g_package || 'get_wf_attr_for_cancel_ntf';
2443:
2444: l_current_userid NUMBER := fnd_profile.value('USER_ID');
2445: l_display_person_id fnd_user.employee_id%TYPE;
2446:
2447: CURSOR person_username_csr (p_person_id IN NUMBER) IS
2448: SELECT user_name
2449: FROM fnd_user

Line 2449: FROM fnd_user

2445: l_display_person_id fnd_user.employee_id%TYPE;
2446:
2447: CURSOR person_username_csr (p_person_id IN NUMBER) IS
2448: SELECT user_name
2449: FROM fnd_user
2450: WHERE employee_id = p_person_id;
2451: --
2452: CURSOR display_person_id_csr (l_current_user_id IN NUMBER) IS
2453: SELECT employee_id

Line 2454: FROM fnd_user

2450: WHERE employee_id = p_person_id;
2451: --
2452: CURSOR display_person_id_csr (l_current_user_id IN NUMBER) IS
2453: SELECT employee_id
2454: FROM fnd_user
2455: WHERE user_id = l_current_userid;
2456: --
2457: --Bug 3841658
2458: CURSOR display_name_csr (l_display_person_id IN NUMBER) IS

Line 2479: FROM fnd_user

2475: BETWEEN per.effective_start_date AND per.effective_end_date;
2476:
2477: CURSOR csr_supervisor_user IS
2478: SELECT user_name
2479: FROM fnd_user
2480: WHERE employee_id = p_supervisor_id;
2481:
2482: BEGIN
2483: