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 1023: l_supervisor_username fnd_user.user_name%TYPE;

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

Line 1906: FROM FND_USER

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

Line 1910: l_username fnd_user.user_name%TYPE;

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

Line 2134: fnd_user_resp_groups furg,

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

Line 2135: fnd_user fu

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

Line 2167: -- from FND_USER

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

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

2420:
2421: PROCEDURE get_wf_attr_for_cancel_ntf
2422: (p_event_id IN ota_events.event_id%TYPE,
2423: p_person_id IN number,
2424: p_supervisor_username OUT NOCOPY fnd_user.user_name%TYPE,
2425: p_supervisor_full_name OUT NOCOPY per_all_people_f.full_name%TYPE,
2426: p_supervisor_id OUT NOCOPY per_all_people_f.person_id%Type,
2427: p_current_person_name OUT NOCOPY VARCHAR2,
2428: p_current_username OUT NOCOPY VARCHAR2,

Line 2437: l_display_person_id fnd_user.employee_id%TYPE;

2433:
2434: l_proc VARCHAR2(72) := g_package || 'get_wf_attr_for_cancel_ntf';
2435:
2436: l_current_userid NUMBER := fnd_profile.value('USER_ID');
2437: l_display_person_id fnd_user.employee_id%TYPE;
2438:
2439: CURSOR person_username_csr (p_person_id IN NUMBER) IS
2440: SELECT user_name
2441: FROM fnd_user

Line 2441: FROM fnd_user

2437: l_display_person_id fnd_user.employee_id%TYPE;
2438:
2439: CURSOR person_username_csr (p_person_id IN NUMBER) IS
2440: SELECT user_name
2441: FROM fnd_user
2442: WHERE employee_id = p_person_id;
2443: --
2444: CURSOR display_person_id_csr (l_current_user_id IN NUMBER) IS
2445: SELECT employee_id

Line 2446: FROM fnd_user

2442: WHERE employee_id = p_person_id;
2443: --
2444: CURSOR display_person_id_csr (l_current_user_id IN NUMBER) IS
2445: SELECT employee_id
2446: FROM fnd_user
2447: WHERE user_id = l_current_userid;
2448: --
2449: --Bug 3841658
2450: CURSOR display_name_csr (l_display_person_id IN NUMBER) IS

Line 2471: FROM fnd_user

2467: BETWEEN per.effective_start_date AND per.effective_end_date;
2468:
2469: CURSOR csr_supervisor_user IS
2470: SELECT user_name
2471: FROM fnd_user
2472: WHERE employee_id = p_supervisor_id;
2473:
2474: BEGIN
2475: