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

Line 325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));

321: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_ep_whereclause ;
322:
323:
324: if p_enable_logging = 'Y' then
325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));
326: FND_FILE.PUT_LINE(FND_FILE.LOG,'PER_BUSINESS_GROUP_ID :' ||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
327: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_ug_to_be_processed is:'||get_ug_to_be_processed);
328:
329: end if;

Line 326: FND_FILE.PUT_LINE(FND_FILE.LOG,'PER_BUSINESS_GROUP_ID :' ||fnd_profile.value('PER_BUSINESS_GROUP_ID'));

322:
323:
324: if p_enable_logging = 'Y' then
325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));
326: FND_FILE.PUT_LINE(FND_FILE.LOG,'PER_BUSINESS_GROUP_ID :' ||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
327: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_ug_to_be_processed is:'||get_ug_to_be_processed);
328:
329: end if;
330:

Line 398: and ((fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') is not null and business_group_id = '||l_elig_pro_bg_id||') or (business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))))

394: per_assignments_f
395: where
396: trunc(sysdate) between effective_start_date and effective_end_date
397: and((assignment_type in (''E'',''C'') and PRIMARY_FLAG = ''Y'') OR (assignment_type = ''A''))
398: and ((fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') is not null and business_group_id = '||l_elig_pro_bg_id||') or (business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))))
399: QRSLT WHERE ' || assignment_whereclause;
400:
401: if p_enable_logging = 'Y' then
402: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_stmnt is:'||l_sql_stmnt);

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

493: lrnr_rec learner_rec;
494:
495: l_sql_stmnt varchar2(4000);
496: l_counter number:=0;
497: l_per_bg_grp_prof_val number:= fnd_profile.value('PER_BUSINESS_GROUP_ID');
498: l_ota_global_bg_prof_val number:= fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
499:
500: l_object_version_number Number(15);
501: l_request_id number;

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

494:
495: l_sql_stmnt varchar2(4000);
496: l_counter number:=0;
497: l_per_bg_grp_prof_val number:= fnd_profile.value('PER_BUSINESS_GROUP_ID');
498: l_ota_global_bg_prof_val number:= fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
499:
500: l_object_version_number Number(15);
501: l_request_id number;
502: l_action_id number(15);

Line 885: l_per_bg_prof_val number := fnd_profile.value ('PER_BUSINESS_GROUP_ID');

881: l_start_person_action_id number DEFAULT 0;
882: l_end_person_action_id number DEFAULT 0;
883: l_actn varchar2(80);
884: l_cnt number(5) DEFAULT 0;
885: l_per_bg_prof_val number := fnd_profile.value ('PER_BUSINESS_GROUP_ID');
886: l_ota_global_bg_prof_val number:= fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
887:
888: l_eligprof_tab ben_evaluate_elig_profiles.proftab;
889: l_score_tab ben_evaluate_elig_profiles.scoreTab;

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

882: l_end_person_action_id number DEFAULT 0;
883: l_actn varchar2(80);
884: l_cnt number(5) DEFAULT 0;
885: l_per_bg_prof_val number := fnd_profile.value ('PER_BUSINESS_GROUP_ID');
886: l_ota_global_bg_prof_val number:= fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
887:
888: l_eligprof_tab ben_evaluate_elig_profiles.proftab;
889: l_score_tab ben_evaluate_elig_profiles.scoreTab;
890: