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_UTIL_MISC_SS dependencies on HR_GENERAL

Line 183: SELECT 4 rank, hr_general.decode_lookup('STRUCTURE_TYPE','POS')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src

179: ,p_person_id IN NUMBER
180: ) RETURN VARCHAR2 IS
181:
182: CURSOR c_srcInfo (p_cid IN NUMBER, p_pid IN NUMBER) IS
183: SELECT 4 rank, hr_general.decode_lookup('STRUCTURE_TYPE','POS')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
184: FROM per_competence_elements ce, per_all_assignments_f paf
185: WHERE ce.type = 'REQUIREMENT'
186: AND trunc(sysdate) between nvl(ce.effective_date_from, sysdate) and nvl(ce.effective_date_to, sysdate)
187: AND ce.position_id = paf.position_id

Line 195: SELECT 3 rank, hr_general.decode_lookup('STRUCTURE_TYPE','JOB')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src

191: AND (ce.proficiency_level_id is not null or ce.high_proficiency_level_id is not null)
192: AND ce.competence_id = p_cid
193: AND paf.person_id = p_pid
194: UNION ALL
195: SELECT 3 rank, hr_general.decode_lookup('STRUCTURE_TYPE','JOB')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
196: FROM per_competence_elements ce, per_all_assignments_f paf
197: WHERE ce.type = 'REQUIREMENT'
198: AND trunc(sysdate) between nvl(ce.effective_date_from, sysdate) and nvl(ce.effective_date_to, sysdate)
199: AND ce.job_id = paf.job_id

Line 207: SELECT 2 rank, hr_general.decode_lookup('STRUCTURE_TYPE','ORG')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src

203: AND (ce.proficiency_level_id is not null or ce.high_proficiency_level_id is not null)
204: AND ce.competence_id = p_cid
205: AND paf.person_id = p_pid
206: UNION ALL
207: SELECT 2 rank, hr_general.decode_lookup('STRUCTURE_TYPE','ORG')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
208: FROM per_competence_elements ce, per_all_assignments_f paf
209: WHERE ce.type = 'REQUIREMENT'
210: AND trunc(sysdate) between ce.effective_date_from and nvl(ce.effective_date_to, sysdate)
211: AND ce.organization_id = paf.organization_id

Line 219: SELECT 1 rank, hr_general.decode_lookup('STRUCTURE_TYPE','BUS')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src

215: AND (ce.proficiency_level_id is not null or ce.high_proficiency_level_id is not null)
216: AND ce.competence_id = p_cid
217: AND paf.person_id = p_pid
218: UNION ALL
219: SELECT 1 rank, hr_general.decode_lookup('STRUCTURE_TYPE','BUS')||'#'||proficiency_level_id||'#'||high_proficiency_level_id src
220: FROM per_competence_elements ce, per_all_assignments_f paf
221: WHERE ce.type = 'REQUIREMENT'
222: AND trunc(sysdate) between ce.effective_date_from and nvl(ce.effective_date_to, sysdate)
223: AND ce.enterprise_id = paf.business_group_id

Line 231: SELECT 0 rank, hr_general.decode_lookup('STRUCTURE_TYPE','ADD')||'##' src

227: AND (ce.proficiency_level_id is not null or ce.high_proficiency_level_id is not null)
228: AND ce.competence_id = p_cid
229: AND paf.person_id = p_pid
230: UNION ALL
231: SELECT 0 rank, hr_general.decode_lookup('STRUCTURE_TYPE','ADD')||'##' src
232: FROM dual
233: ORDER BY RANK DESC;
234:
235: BEGIN

Line 258: l_asg_security VARCHAR2(10) := hr_general2.supervisor_assignments_in_use;

254: RETURN VARCHAR2
255: IS
256: l_proc varchar2(72) := g_package||' validate_selected_function';
257: l_status VARCHAR2(10):='F';
258: l_asg_security VARCHAR2(10) := hr_general2.supervisor_assignments_in_use;
259: BEGIN
260:
261: IF g_debug then
262: hr_utility.set_location('Entering: '|| l_proc, 5);