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.PER_ZA_WSP_ARCHIVE_PKG dependencies on HR_LOOKUPS

Line 2865: , p_ass_cat_name in hr_lookups.meaning%type

2861: , p_person_id in per_all_assignments_f.person_id%type
2862: , p_assignment_id in per_all_assignments_f.assignment_id%type
2863: , p_race in per_all_people_f.per_information4%type
2864: , p_sex in per_all_people_f.sex%type
2865: , p_ass_cat_name in hr_lookups.meaning%type
2866: , p_skills_pri_id in number
2867: , p_trng_event_id in number
2868: , p_trng_event_name in varchar2
2869: , p_trng_event_lookup in varchar2

Line 2943: , p_ass_cat_name in hr_lookups.meaning%type

2939: , p_person_id in per_all_assignments_f.person_id%type
2940: , p_assignment_id in per_all_assignments_f.assignment_id%type
2941: , p_race in per_all_people_f.per_information4%type
2942: , p_sex in per_all_people_f.sex%type
2943: , p_ass_cat_name in hr_lookups.meaning%type
2944: , p_legal_entity_id in number
2945: , p_disability in varchar2
2946: ) is
2947: --

Line 3480: , p_ass_cat_name in hr_lookups.meaning%type

3476: , p_person_id in per_all_assignments_f.person_id%type
3477: , p_assignment_id in per_all_assignments_f.assignment_id%type
3478: , p_race in per_all_people_f.per_information4%type
3479: , p_sex in per_all_people_f.sex%type
3480: , p_ass_cat_name in hr_lookups.meaning%type
3481: , p_skills_pri_id in number
3482: , p_trng_event_id in number
3483: , p_trng_event_name in varchar2
3484: , p_trng_event_lookup in varchar2

Line 3564: , p_ass_cat_name in hr_lookups.meaning%type

3560: , p_person_id in per_all_assignments_f.person_id%type
3561: , p_assignment_id in per_all_assignments_f.assignment_id%type
3562: , p_race in per_all_people_f.per_information4%type
3563: , p_sex in per_all_people_f.sex%type
3564: , p_ass_cat_name in hr_lookups.meaning%type
3565: , p_legal_entity_id in number
3566: , p_disability in varchar2
3567: ) is
3568: l_proc varchar2(50);

Line 4043: l_name hr_lookups.meaning%type;

4039: p_position_id in per_all_assignments_f.position_id%type
4040: ) return varchar2 is
4041:
4042: l_sql varchar2(32767);
4043: l_name hr_lookups.meaning%type;
4044:
4045:
4046: begin
4047: hr_utility.set_location('In side get_occupational_data',1);

Line 4052: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '

4048: hr_utility.set_location('p_flex : ' || p_flex,2);
4049: if p_flex = upper('Job') then
4050: begin
4051: if p_job_id is not null then
4052: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
4053: || to_char(p_job_id)
4054: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = '''
4055: || p_type || ''' and hl.lookup_code = pjd.' || p_segment;
4056: execute immediate l_sql into l_name;

Line 4067: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '

4063: end;
4064: elsif p_flex = upper('Grade') then
4065: begin
4066: if p_grade_id is not null then
4067: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
4068: || to_char(p_grade_id)
4069: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = '''
4070: || p_type ||''' and hl.lookup_code = pgd.' || p_segment;
4071: execute immediate l_sql into l_name;

Line 4082: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '

4078: end;
4079: elsif p_flex = upper('Position') then
4080: begin
4081: if p_position_id is not null then
4082: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
4083: || to_char(p_position_id)
4084: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = '''
4085: || p_type || ''' and hl.lookup_code = ppd.' || p_segment;
4086: execute immediate l_sql into l_name;

Line 4112: l_cat_name hr_lookups.meaning%type;

4108: p_grade_id in per_all_assignments_f.grade_id%type,
4109: p_position_id in per_all_assignments_f.position_id%type,
4110: p_business_group_id in per_all_assignments_f.business_group_id%type
4111: ) return varchar2 is
4112: l_cat_name hr_lookups.meaning%type;
4113: begin
4114: -- Check whether we have cached the location of Occupational data
4115: hr_utility.set_location('Entering get_occupational_category', 10);
4116: hr_utility.set_location('p_assignment_id : '||p_assignment_id, 10);

Line 4150: l_ass_cat_name hr_lookups.meaning%type;

4146:
4147: l_proc varchar2(50);
4148: l_assignment_id per_all_assignments_f.assignment_id%type;
4149: l_person_id per_all_assignments_f.person_id%type;
4150: l_ass_cat_name hr_lookups.meaning%type;
4151: l_race per_all_people_f.per_information4%type;
4152: l_sex per_all_people_f.sex%type;
4153: l_legal_entity_id number(30);
4154: l_disability varchar2(30);