DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on PER_JOBS_TL

Line 2141: jname per_jobs_tl.name%type := ''; --14592612

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

Line 2146: from per_jobs_tl

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);

Line 2374: l_job_name per_jobs_tl.name%type := ''; --14592612

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);