APPS.OTA_EVT_BUS dependencies on FND_PROFILE

Line 3124: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');

3120: effective_start_date and effective_end_date;
3121:
3122:
3123: l_exist varchar2(1);
3124: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');
3125: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
3126:
3127:
3128: Begin

Line 3125: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

3121:
3122:
3123: l_exist varchar2(1);
3124: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');
3125: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
3126:
3127:
3128: Begin
3129: --

Line 3622: AND f.user_id = to_number(fnd_profile.value('USER_ID'));

3618: per_all_assignments_f p
3619: WHERE p.organization_id = p_organization_id
3620: AND f.employee_id = p.person_id
3621: AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
3622: AND f.user_id = to_number(fnd_profile.value('USER_ID'));
3623:
3624: BEGIN
3625: hr_utility.set_location('Entering:'||l_proc, 5);
3626:

Line 3639: l_user := fnd_profile.value('USERNAME');

3635:
3636:
3637: /* OPEN csr_org;
3638: FETCH csr_org INTO l_username;
3639: l_user := fnd_profile.value('USERNAME');
3640: l_condition := nvl(l_user, 'UNSET1') = nvl(l_username, 'UNSET2');
3641: IF NOT l_condition THEN
3642: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3643: fnd_message.raise_error;