APPS.OTA_CANCEL_TRAINING_SS dependencies on FND_USER

Line 56: l_display_person_id fnd_user.employee_id%TYPE;

52: --
53: l_proc VARCHAR2(72) := 'ota_cancel_enrollment_ss.create_enroll_wf_process';
54: l_current_username VARCHAR2(80):= fnd_profile.value('USERNAME');
55: l_current_userid NUMBER := fnd_profile.value('USER_ID');
56: l_display_person_id fnd_user.employee_id%TYPE;
57: l_current_person_name VARCHAR2(80);
58: l_person_displayname per_all_people_f.full_name%TYPE;
59: l_creator_displayname per_all_people_f.full_name%TYPE;
60: --

Line 63: l_supervisor_username fnd_user.user_name%TYPE;

59: l_creator_displayname per_all_people_f.full_name%TYPE;
60: --
61: --Bug 2480134
62: l_supervisor_id per_all_people_f.person_id%Type;
63: l_supervisor_username fnd_user.user_name%TYPE;
64: l_supervisor_full_name per_all_people_f.full_name%TYPE;
65: --Bug 2480134
66: CURSOR person_username_csr (p_person_id IN NUMBER) IS
67: SELECT user_name

Line 68: FROM fnd_user

64: l_supervisor_full_name per_all_people_f.full_name%TYPE;
65: --Bug 2480134
66: CURSOR person_username_csr (p_person_id IN NUMBER) IS
67: SELECT user_name
68: FROM fnd_user
69: WHERE employee_id = p_person_id;
70: --
71: CURSOR display_person_id_csr (l_current_user_id IN NUMBER) IS
72: SELECT employee_id

Line 73: FROM fnd_user

69: WHERE employee_id = p_person_id;
70: --
71: CURSOR display_person_id_csr (l_current_user_id IN NUMBER) IS
72: SELECT employee_id
73: FROM fnd_user
74: WHERE user_id = l_current_userid;
75: --
76: CURSOR display_name_csr (l_display_person_id IN NUMBER) IS
77: -- ,p_course_start_date IN DATE,

Line 103: FROM fnd_user

99: BETWEEN per.effective_start_date AND per.effective_end_date;
100:
101: CURSOR csr_supervisor_user IS
102: SELECT user_name
103: FROM fnd_user
104: WHERE employee_id= l_supervisor_id;
105: -- Bug 2480134
106:
107: BEGIN

Line 436: FROM FND_USER

432: --
433: --
434: CURSOR C_USER(p_owner_id NUMBER) IS
435: SELECT USER_NAME
436: FROM FND_USER
437: WHERE Employee_id = p_owner_id;
438: l_username fnd_user.user_name%TYPE;
439: --
440: BEGIN

Line 438: l_username fnd_user.user_name%TYPE;

434: CURSOR C_USER(p_owner_id NUMBER) IS
435: SELECT USER_NAME
436: FROM FND_USER
437: WHERE Employee_id = p_owner_id;
438: l_username fnd_user.user_name%TYPE;
439: --
440: BEGIN
441: --
442: hr_utility.set_location('Entering:'||l_proc, 10);