2155: function getPositionName (p_position_id in number, p_bg_id in number)
2156: return varchar2
2157: is
2158: --pname varchar2(200) := '';
2159: pname hr_all_positions_f_tl.name%type := ''; --14592612
2160: begin
2161:
2162: select name
2163: into pname
2160: begin
2161:
2162: select name
2163: into pname
2164: from hr_all_positions_f_tl
2165: where p_position_id = position_id
2166: and language(+) = userenv('LANG');
2167:
2168: return hr_util_misc_ss.getObjectName('POSITION', p_position_id, p_bg_id, pname);
2421:
2422: --l_position_id number(10):=-1;
2423: l_position_id per_all_assignments_f.position_id%type := -1; --14592612
2424: --l_position_name varchar2(100) := null;
2425: l_position_name hr_all_positions_f_tl.name%type := ''; --14592612
2426: begin
2427:
2428: if(p_rptg_grp_id is not null and p_plan_id is null) then
2429: begin