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

Line 373: l_business_group_id number := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');

369: --
370: l_proc varchar2(72) := g_package||'chk_competence';
371: l_exists varchar2(1);
372:
373: l_business_group_id number := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
374: l_hr_cross varchar2(2) := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
375:
376: --
377: CURSOR csr_competence

Line 374: l_hr_cross varchar2(2) := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');

370: l_proc varchar2(72) := g_package||'chk_competence';
371: l_exists varchar2(1);
372:
373: l_business_group_id number := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
374: l_hr_cross varchar2(2) := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
375:
376: --
377: CURSOR csr_competence
378: IS

Line 410: if ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and

406: --
407: hr_utility.set_location('Entering:'||l_proc, 10);
408: if (p_competence_id is not null) then
409: hr_utility.set_location('Entering:'||l_proc, 15);
410: if ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
411: l_hr_cross ='N') or
412: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and
413: l_hr_cross = 'N' )then
414: open csr_competence;

Line 412: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and

408: if (p_competence_id is not null) then
409: hr_utility.set_location('Entering:'||l_proc, 15);
410: if ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
411: l_hr_cross ='N') or
412: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and
413: l_hr_cross = 'N' )then
414: open csr_competence;
415: fetch csr_competence into l_exists;
416: if csr_competence%notfound then

Line 423: elsif ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and

419: fnd_message.raise_error;
420: end if;
421: close csr_competence;
422: hr_utility.set_location('Entering:'||l_proc, 20);
423: elsif ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and
424: l_hr_cross ='Y') or
425: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
426: l_hr_cross ='Y' )then
427: hr_utility.set_location('Entering:'||l_proc, 25);

Line 425: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and

421: close csr_competence;
422: hr_utility.set_location('Entering:'||l_proc, 20);
423: elsif ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and
424: l_hr_cross ='Y') or
425: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
426: l_hr_cross ='Y' )then
427: hr_utility.set_location('Entering:'||l_proc, 25);
428: open csr_competence_cross;
429: fetch csr_competence_cross into l_exists;