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.HR_APPRAISAL_WORKFLOW_SS dependencies on HR_GENERAL_UTILITIES

Line 591: select instr(lv_participants_list,hr_general_utilities.g_separator) into check_sep from dual;

587: return;
588: end if;
589:
590: -- check if the value has any delimiter in it
591: select instr(lv_participants_list,hr_general_utilities.g_separator) into check_sep from dual;
592: if(check_sep=0) then
593: -- no seperator(delimiter) found
594: ln_particpant_person_id := lv_participants_list;
595: lv_participants_list := null;

Line 598: ln_particpant_person_id := substr(lv_participants_list,1,instr(lv_participants_list,hr_general_utilities.g_separator)-1);

594: ln_particpant_person_id := lv_participants_list;
595: lv_participants_list := null;
596: else
597: -- reset the list
598: ln_particpant_person_id := substr(lv_participants_list,1,instr(lv_participants_list,hr_general_utilities.g_separator)-1);
599: lv_participants_list := substr(lv_participants_list,instr(lv_participants_list,hr_general_utilities.g_separator)+length(hr_general_utilities.g_separator));
600: end if;
601: -- get the role details for the participant and set the item attributes
602: wf_directory.getrolename(g_orig_system,ln_particpant_person_id,lv_particpant_user_name,lv_particpant_display_name);

Line 599: lv_participants_list := substr(lv_participants_list,instr(lv_participants_list,hr_general_utilities.g_separator)+length(hr_general_utilities.g_separator));

595: lv_participants_list := null;
596: else
597: -- reset the list
598: ln_particpant_person_id := substr(lv_participants_list,1,instr(lv_participants_list,hr_general_utilities.g_separator)-1);
599: lv_participants_list := substr(lv_participants_list,instr(lv_participants_list,hr_general_utilities.g_separator)+length(hr_general_utilities.g_separator));
600: end if;
601: -- get the role details for the participant and set the item attributes
602: wf_directory.getrolename(g_orig_system,ln_particpant_person_id,lv_particpant_user_name,lv_particpant_display_name);
603: -- set the details to the performer for the participant