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

Line 75: -- l_certification_next := to_char(to_date(l_certification_next),fnd_profile.value('ICX_DATE_FORMAT_MASK'));

71: l_certification_next := hr_transaction_api.get_varchar2_value
72: (p_transaction_step_id => p_transaction_step_id
73: ,p_name => 'P_CERTNEXT');
74:
75: -- l_certification_next := to_char(to_date(l_certification_next),fnd_profile.value('ICX_DATE_FORMAT_MASK'));
76:
77: l_comments := hr_transaction_api.get_varchar2_value
78: (p_transaction_step_id => p_transaction_step_id
79: ,p_name => 'P_COMMENTS');

Line 1422: --:= fnd_profile.value('USERNAME');

1418: l_LP_retValue varchar2(100);
1419:
1420: l_user_name varchar2(80);
1421: l_current_username varchar2(80);
1422: --:= fnd_profile.value('USERNAME');
1423: l_current_user_Id number ;
1424: --:= fnd_profile.value('USER_ID');
1425:
1426: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');

Line 1424: --:= fnd_profile.value('USER_ID');

1420: l_user_name varchar2(80);
1421: l_current_username varchar2(80);
1422: --:= fnd_profile.value('USERNAME');
1423: l_current_user_Id number ;
1424: --:= fnd_profile.value('USER_ID');
1425:
1426: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');
1427: l_creator_user_Id number := fnd_profile.value('USER_ID');
1428:

Line 1426: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');

1422: --:= fnd_profile.value('USERNAME');
1423: l_current_user_Id number ;
1424: --:= fnd_profile.value('USER_ID');
1425:
1426: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');
1427: l_creator_user_Id number := fnd_profile.value('USER_ID');
1428:
1429: l_creator_person_id per_all_people_f.person_id%type;
1430: l_ntf_url varchar2(4000);

Line 1427: l_creator_user_Id number := fnd_profile.value('USER_ID');

1423: l_current_user_Id number ;
1424: --:= fnd_profile.value('USER_ID');
1425:
1426: l_creator_username varchar2(80):= fnd_profile.value('USERNAME');
1427: l_creator_user_Id number := fnd_profile.value('USER_ID');
1428:
1429: l_creator_person_id per_all_people_f.person_id%type;
1430: l_ntf_url varchar2(4000);
1431: l_comp_ids varchar2(4000);

Line 1545: and (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null or --Bug#6869342

1541: is
1542: Select 1 from
1543: per_all_people_f
1544: where person_id= p_person_id
1545: and (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null or --Bug#6869342
1546: business_group_id = ota_general.get_business_group_id);
1547:
1548: -- get certification name
1549: cursor certification_name

Line 1911: --l_jsp_apps_agent := fnd_profile.value('APPS_FRAMEWORK_AGENT');

1907:
1908: begin
1909: hr_utility.set_location('Entering'||l_proc, 5);
1910:
1911: --l_jsp_apps_agent := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1912: --HR_UTILITY.TRACE ('Agent :: ' || l_jsp_apps_agent);
1913: if p_func='APPROVAL' then
1914: l_func:='OTA_ADMIN_COMPETENCE_UPDATE';
1915: else

Line 1993: Select nvl(fnd_profile.value('OTA_ALLOW_COMPETENCY_UPDATE_WITH_RENEWAL_PERIOD'),'N') from dual;

1989: --AND pc.renewal_period_units IS NOT NULL modified for bug8410902
1990: AND pc.renewal_period_units IN ('Y','D','H','MIN','M','Q','W');
1991:
1992: Cursor get_comp_profile is
1993: Select nvl(fnd_profile.value('OTA_ALLOW_COMPETENCY_UPDATE_WITH_RENEWAL_PERIOD'),'N') from dual;
1994:
1995: CURSOR csr_get_lp_comps IS
1996: SELECT pce.competence_id CompetenceId
1997: ,nvl(pce.proficiency_level_id,-1) LevelId