APPS.PER_PERRPRAS_XMLP_PKG dependencies on HR_REPORTS

Line 37: c_business_group_name := hr_reports.get_business_group(l_business_group_id);

33: FETCH csr_org_structure_version INTO l_business_group_id;
34: CLOSE csr_org_structure_version;
35: END IF;
36: IF (l_business_group_id IS NOT NULL) THEN
37: c_business_group_name := hr_reports.get_business_group(l_business_group_id);
38: ELSE
39: c_business_group_name := c_global_hierarchy;
40: END IF;
41:

Line 49: hr_reports.get_organization_hierarchy

45: from per_business_groups
46: where business_group_id = p_business_group_id;
47: p_legislation_code := l_legislation_code;
48: if p_org_structure_version_id is not null then
49: hr_reports.get_organization_hierarchy
50: (null
51: ,p_org_structure_version_id
52: ,l_organization_stucture_desc
53: ,l_org_version_desc

Line 74: hr_reports.get_organization

70: else
71: c_session_date := c_version_from_desc;
72: end if;
73: if p_parent_organization_id is not null then
74: hr_reports.get_organization
75: (p_parent_organization_id
76: ,l_organization_desc
77: ,l_organization_type);
78:

Line 84: hr_reports.get_job(p_job_id);

80: end if;
81:
82: if p_job_id is not null then
83: c_job_desc :=
84: hr_reports.get_job(p_job_id);
85: p_job_matching :=
86: 'and a.job_id = ' || to_char(p_job_id);
87: end if;
88: if p_position_id is not null then

Line 90: hr_reports.get_position(p_position_id);

86: 'and a.job_id = ' || to_char(p_job_id);
87: end if;
88: if p_position_id is not null then
89: c_position_desc :=
90: hr_reports.get_position(p_position_id);
91: p_position_matching :=
92: 'and a.position_id = '|| to_char(p_position_id);
93: end if;
94: if p_grade_id is not null then

Line 96: hr_reports.get_grade(p_grade_id);

92: 'and a.position_id = '|| to_char(p_position_id);
93: end if;
94: if p_grade_id is not null then
95: c_grade_desc :=
96: hr_reports.get_grade(p_grade_id);
97: p_grade_matching :=
98: 'and a.grade_id = ' || to_char(p_grade_id);
99: end if;
100: if p_payroll_id is not null then

Line 102: hr_reports.get_payroll_name(p_session_date,p_payroll_id);

98: 'and a.grade_id = ' || to_char(p_grade_id);
99: end if;
100: if p_payroll_id is not null then
101: c_payroll_desc :=
102: hr_reports.get_payroll_name(p_session_date,p_payroll_id);
103: p_payroll_matching :=
104: 'and a.payroll_id+0 = '|| to_char(p_payroll_id);
105: end if;
106: if p_asg_status_type_id1 is not null then

Line 108: hr_reports.get_status(p_business_group_id

104: 'and a.payroll_id+0 = '|| to_char(p_payroll_id);
105: end if;
106: if p_asg_status_type_id1 is not null then
107: c_asg_status_desc1 :=
108: hr_reports.get_status(p_business_group_id
109: ,p_asg_status_type_id1
110: ,p_legislation_code);
111: p_status_matching_1 :=
112: p_status_matching || ',' || to_char(p_asg_status_type_id1) ;

Line 118: hr_reports.get_status(p_business_group_id

114: c_status_list || ',' || c_asg_status_desc1;
115: end if;
116: if p_asg_status_type_id2 is not null then
117: c_asg_status_desc2 :=
118: hr_reports.get_status(p_business_group_id
119: ,p_asg_status_type_id2
120: ,p_legislation_code);
121: p_status_matching_1 :=
122: p_status_matching || ',' || to_char(p_asg_status_type_id2);

Line 128: hr_reports.get_status(p_business_group_id

124: c_status_list || ',' || c_asg_status_desc2;
125: end if;
126: if p_asg_status_type_id3 is not null then
127: c_asg_status_desc3 :=
128: hr_reports.get_status(p_business_group_id
129: ,p_asg_status_type_id3
130: ,p_legislation_code);
131: p_status_matching_1 :=
132: p_status_matching || ',' || to_char(p_asg_status_type_id3);

Line 138: hr_reports.get_status(p_business_group_id

134: c_status_list || ',' || c_asg_status_desc3;
135: end if;
136: if p_asg_status_type_id4 is not null then
137: c_asg_status_desc4 :=
138: hr_reports.get_status(p_business_group_id
139: ,p_asg_status_type_id4
140: ,p_legislation_code);
141: p_status_matching_1 :=
142: p_status_matching || ',' || to_char(p_asg_status_type_id4);

Line 158: hr_reports.get_lookup_meaning('YES_NO',p_primary_flag);

154: substr(c_status_list,2,NVL(length(c_status_list), 0) - 1);
155: end if;
156: if p_primary_flag is not null then
157: c_primary_flag_desc :=
158: hr_reports.get_lookup_meaning('YES_NO',p_primary_flag);
159: end if;
160:
161: if p_person_type is not null then
162: c_person_type_desc :=

Line 163: hr_reports.get_lookup_meaning('EMP_OR_APL',p_person_type);

159: end if;
160:
161: if p_person_type is not null then
162: c_person_type_desc :=
163: hr_reports.get_lookup_meaning('EMP_OR_APL',p_person_type);
164: end if;
165:
166: if p_people_group_id is not null then
167: HR_REPORTS.gen_partial_matching_lexical

Line 167: HR_REPORTS.gen_partial_matching_lexical

163: hr_reports.get_lookup_meaning('EMP_OR_APL',p_person_type);
164: end if;
165:
166: if p_people_group_id is not null then
167: HR_REPORTS.gen_partial_matching_lexical
168: (p_people_group_id,
169: p_people_group_flex_id,
170: p_matching_criteria,'GRP');
171: end if;