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_MANDATORY_ENROLL_UTIL dependencies on FND_PROFILE

Line 974: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');

970: BEGIN
971:
972: hr_utility.set_location(' Entering:'||l_proc, 5);
973:
974: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
975: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
976: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
977:
978: IF l_allow_future_end_prof_val is null then

Line 975: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');

971:
972: hr_utility.set_location(' Entering:'||l_proc, 5);
973:
974: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
975: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
976: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
977:
978: IF l_allow_future_end_prof_val is null then
979: l_allow_future_end_prof_val := 'N';

Line 976: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

972: hr_utility.set_location(' Entering:'||l_proc, 5);
973:
974: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
975: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
976: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
977:
978: IF l_allow_future_end_prof_val is null then
979: l_allow_future_end_prof_val := 'N';
980: END IF;

Line 1032: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

1028: ,per_business_groups pbg
1029: WHERE ppf.person_id = paf.person_id
1030: AND (pts.system_person_type IN (''EMP'',''CWK'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))
1031: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1032: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1033: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
1034: OR nvl(:3, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
1035: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1036: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)

Line 1035: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

1031: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1032: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1033: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
1034: OR nvl(:3, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
1035: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1036: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)
1037: OR nvl(:4, trunc(sysdate)) between ptu.effective_start_date and ptu.effective_end_date )
1038: AND paf.job_id = pjt.job_id(+)
1039: AND pjt.language(+) = USERENV(''LANG'')

Line 1049: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))

1045: AND paf.organization_id = orgtl.organization_id
1046: AND pts.system_person_type IN (''EMP'', ''CWK'', ''APL'')
1047: AND paf.assignment_type IN (''A'',''E'',''C'')
1048: AND orgtl.language = USERENV(''LANG'')
1049: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))
1050: AND paf.business_group_id = pbg.business_group_id
1051: AND
1052: ((pts.system_person_type = ''APL''
1053: AND NOT EXISTS (SELECT person_id

Line 1369: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');

1365: BEGIN
1366:
1367: hr_utility.set_location(' Entering:'||l_proc, 5);
1368:
1369: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
1370: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1371: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
1372:
1373: IF l_allow_future_end_prof_val is null then

Line 1370: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');

1366:
1367: hr_utility.set_location(' Entering:'||l_proc, 5);
1368:
1369: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
1370: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1371: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
1372:
1373: IF l_allow_future_end_prof_val is null then
1374: l_allow_future_end_prof_val := 'N';

Line 1371: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

1367: hr_utility.set_location(' Entering:'||l_proc, 5);
1368:
1369: l_allow_future_end_prof_val := fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS');
1370: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1371: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
1372:
1373: IF l_allow_future_end_prof_val is null then
1374: l_allow_future_end_prof_val := 'N';
1375: END IF;

Line 1487: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

1483: ,per_business_groups pbg
1484: WHERE ppf.person_id = paf.person_id
1485: AND ((pts.system_person_type IN (''EMP'',''CWK'') AND paf.primary_flag = ''Y'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))
1486: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1487: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1488: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
1489: OR nvl(:3, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
1490: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1491: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)

Line 1490: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

1486: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1487: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1488: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
1489: OR nvl(:3, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
1490: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
1491: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)
1492: OR nvl(:4, trunc(sysdate)) between ptu.effective_start_date and ptu.effective_end_date )
1493: AND paf.job_id = pjt.job_id(+)
1494: AND pjt.language(+) = USERENV(''LANG'')

Line 1504: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))

1500: AND paf.organization_id = orgtl.organization_id
1501: AND pts.system_person_type IN (''EMP'', ''CWK'', ''APL'')
1502: AND paf.assignment_type IN (''A'',''E'',''C'')
1503: AND orgtl.language = USERENV(''LANG'')
1504: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))
1505: AND paf.business_group_id = pbg.business_group_id
1506: AND
1507: ((pts.system_person_type = ''APL''
1508: AND NOT EXISTS (SELECT person_id

Line 2541: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');

2537:
2538: hr_utility.set_location(' Entering:'||l_proc, 5);
2539:
2540:
2541: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
2542: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
2543:
2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);

Line 2542: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

2538: hr_utility.set_location(' Entering:'||l_proc, 5);
2539:
2540:
2541: l_per_bg_grp_prof_val := fnd_profile.value('PER_BUSINESS_GROUP_ID');
2542: l_ota_global_bg_prof_val := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
2543:
2544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile PER_BUSINESS_GROUP_ID : '||l_per_bg_grp_prof_val);
2545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
2546:

Line 2707: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))

2703: AND paf.organization_id = orgtl.organization_id
2704: AND pts.system_person_type IN (''EMP'', ''CWK'', ''APL'')
2705: AND paf.assignment_type IN (''A'',''E'',''C'')
2706: AND orgtl.language = USERENV(''LANG'')
2707: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))
2708: AND paf.business_group_id = pbg.business_group_id
2709: AND
2710: ((pts.system_person_type = ''APL''
2711: AND NOT EXISTS (SELECT person_id