2137: function getJobName (p_job_id in number, p_bg_id in number)
2138: return varchar2
2139: is
2140: --jname varchar2(200) := '';
2141: jname per_jobs_tl.name%type := ''; --14592612
2142: begin
2143:
2144: select name
2145: into jname
2142: begin
2143:
2144: select name
2145: into jname
2146: from per_jobs_tl
2147: where p_job_id = job_id
2148: and language(+) = userenv('LANG');
2149:
2150: return hr_util_misc_ss.getObjectName('JOB', p_job_id, p_bg_id, jname);
2370: l_job_id number(10):=-1;
2371: l_transaction_step_id number(10):=-1;
2372: l_asg_id number(10);
2373: --l_job_name varchar2(100) := null;
2374: l_job_name per_jobs_tl.name%type := ''; --14592612
2375: begin
2376: -- hr_utility.trace_on(null,'ORCL');
2377: hr_utility.set_location('Entering: getJobNameNew', 30);
2378: hr_utility.set_location(' p_rptg_grp_id' ||p_rptg_grp_id, 30);