1 PACKAGE ghr_per_sum AS
2 /* $Header: ghpersum.pkh 120.1.12010000.2 2008/08/05 15:10:02 ubhat ship $ */
3 --
4 PROCEDURE fetch_peopleei(
5 p_person_id IN NUMBER
6 ,p_information_type IN VARCHAR2
7 ,p_date_effective IN DATE
8 ,p_information1 IN OUT NOCOPY VARCHAR2
9 ,p_information2 IN OUT NOCOPY VARCHAR2
10 ,p_information3 IN OUT NOCOPY VARCHAR2
11 ,p_information4 IN OUT NOCOPY VARCHAR2
12 ,p_information5 IN OUT NOCOPY VARCHAR2
13 ,p_information6 IN OUT NOCOPY VARCHAR2
14 ,p_information7 IN OUT NOCOPY VARCHAR2
15 ,p_information8 IN OUT NOCOPY VARCHAR2
16 ,p_information9 IN OUT NOCOPY VARCHAR2
17 ,p_information10 IN OUT NOCOPY VARCHAR2
18 ,p_information11 IN OUT NOCOPY VARCHAR2
19 ,p_information12 IN OUT NOCOPY VARCHAR2
20 ,p_information13 IN OUT NOCOPY VARCHAR2
21 ,p_information14 IN OUT NOCOPY VARCHAR2
22 ,p_information15 IN OUT NOCOPY VARCHAR2
23 ,p_information16 IN OUT NOCOPY VARCHAR2
24 ,p_information17 IN OUT NOCOPY VARCHAR2
25 ,p_information18 IN OUT NOCOPY VARCHAR2
26 ,p_information19 IN OUT NOCOPY VARCHAR2
27 ,p_information20 IN OUT NOCOPY VARCHAR2
28 ,p_information21 IN OUT NOCOPY VARCHAR2
29 ,p_information22 IN OUT NOCOPY VARCHAR2
30 ,p_information23 IN OUT NOCOPY VARCHAR2
31 ,p_information24 IN OUT NOCOPY VARCHAR2
32 ,p_information25 IN OUT NOCOPY VARCHAR2
33 ,p_information26 IN OUT NOCOPY VARCHAR2
34 ,p_information27 IN OUT NOCOPY VARCHAR2
35 ,p_information28 IN OUT NOCOPY VARCHAR2
36 ,p_information29 IN OUT NOCOPY VARCHAR2
37 ,p_information30 IN OUT NOCOPY VARCHAR2);
38
39 PROCEDURE fetch_asgei(
40 p_assignment_id IN NUMBER
41 ,p_information_type IN VARCHAR2
42 ,p_date_effective IN DATE
43 ,p_information1 IN OUT NOCOPY VARCHAR2
44 ,p_information2 IN OUT NOCOPY VARCHAR2
45 ,p_information3 IN OUT NOCOPY VARCHAR2
46 ,p_information4 IN OUT NOCOPY VARCHAR2
47 ,p_information5 IN OUT NOCOPY VARCHAR2
48 ,p_information6 IN OUT NOCOPY VARCHAR2
49 ,p_information7 IN OUT NOCOPY VARCHAR2
50 ,p_information8 IN OUT NOCOPY VARCHAR2
51 ,p_information9 IN OUT NOCOPY VARCHAR2
52 ,p_information10 IN OUT NOCOPY VARCHAR2
53 ,p_information11 IN OUT NOCOPY VARCHAR2
54 ,p_information12 IN OUT NOCOPY VARCHAR2
55 ,p_information13 IN OUT NOCOPY VARCHAR2
56 ,p_information14 IN OUT NOCOPY VARCHAR2
57 ,p_information15 IN OUT NOCOPY VARCHAR2
58 ,p_information16 IN OUT NOCOPY VARCHAR2
59 ,p_information17 IN OUT NOCOPY VARCHAR2
60 ,p_information18 IN OUT NOCOPY VARCHAR2
61 ,p_information19 IN OUT NOCOPY VARCHAR2
62 ,p_information20 IN OUT NOCOPY VARCHAR2
63 ,p_information21 IN OUT NOCOPY VARCHAR2
64 ,p_information22 IN OUT NOCOPY VARCHAR2
65 ,p_information23 IN OUT NOCOPY VARCHAR2
66 ,p_information24 IN OUT NOCOPY VARCHAR2
67 ,p_information25 IN OUT NOCOPY VARCHAR2
68 ,p_information26 IN OUT NOCOPY VARCHAR2
69 ,p_information27 IN OUT NOCOPY VARCHAR2
70 ,p_information28 IN OUT NOCOPY VARCHAR2
71 ,p_information29 IN OUT NOCOPY VARCHAR2
72 ,p_information30 IN OUT NOCOPY VARCHAR2);
73
74 PROCEDURE fetch_positionei(
75 p_position_id IN NUMBER
76 ,p_information_type IN VARCHAR2
77 ,p_date_effective IN DATE
78 ,p_information1 IN OUT NOCOPY VARCHAR2
79 ,p_information2 IN OUT NOCOPY VARCHAR2
80 ,p_information3 IN OUT NOCOPY VARCHAR2
81 ,p_information4 IN OUT NOCOPY VARCHAR2
82 ,p_information5 IN OUT NOCOPY VARCHAR2
83 ,p_information6 IN OUT NOCOPY VARCHAR2
84 ,p_information7 IN OUT NOCOPY VARCHAR2
85 ,p_information8 IN OUT NOCOPY VARCHAR2
86 ,p_information9 IN OUT NOCOPY VARCHAR2
87 ,p_information10 IN OUT NOCOPY VARCHAR2
88 ,p_information11 IN OUT NOCOPY VARCHAR2
89 ,p_information12 IN OUT NOCOPY VARCHAR2
90 ,p_information13 IN OUT NOCOPY VARCHAR2
91 ,p_information14 IN OUT NOCOPY VARCHAR2
92 ,p_information15 IN OUT NOCOPY VARCHAR2
93 ,p_information16 IN OUT NOCOPY VARCHAR2
94 ,p_information17 IN OUT NOCOPY VARCHAR2
95 ,p_information18 IN OUT NOCOPY VARCHAR2
96 ,p_information19 IN OUT NOCOPY VARCHAR2
97 ,p_information20 IN OUT NOCOPY VARCHAR2
98 ,p_information21 IN OUT NOCOPY VARCHAR2
99 ,p_information22 IN OUT NOCOPY VARCHAR2
100 ,p_information23 IN OUT NOCOPY VARCHAR2
101 ,p_information24 IN OUT NOCOPY VARCHAR2
102 ,p_information25 IN OUT NOCOPY VARCHAR2
103 ,p_information26 IN OUT NOCOPY VARCHAR2
104 ,p_information27 IN OUT NOCOPY VARCHAR2
105 ,p_information28 IN OUT NOCOPY VARCHAR2
106 ,p_information29 IN OUT NOCOPY VARCHAR2
107 ,p_information30 IN OUT NOCOPY VARCHAR2);
108 --
109 PROCEDURE return_special_information(
110 p_person_id IN NUMBER
111 ,p_structure_name IN VARCHAR2
112 ,p_effective_date IN DATE
113 ,p_segment1 IN OUT NOCOPY VARCHAR2
114 ,p_segment2 IN OUT NOCOPY VARCHAR2
115 ,p_segment3 IN OUT NOCOPY VARCHAR2
116 ,p_segment4 IN OUT NOCOPY VARCHAR2
117 ,p_segment5 IN OUT NOCOPY VARCHAR2
118 ,p_segment6 IN OUT NOCOPY VARCHAR2
119 ,p_segment7 IN OUT NOCOPY VARCHAR2
120 ,p_segment8 IN OUT NOCOPY VARCHAR2
121 ,p_segment9 IN OUT NOCOPY VARCHAR2
122 ,p_segment10 IN OUT NOCOPY VARCHAR2
123 ,p_segment11 IN OUT NOCOPY VARCHAR2
124 ,p_segment12 IN OUT NOCOPY VARCHAR2
125 ,p_segment13 IN OUT NOCOPY VARCHAR2
126 ,p_segment14 IN OUT NOCOPY VARCHAR2
127 ,p_segment15 IN OUT NOCOPY VARCHAR2
128 ,p_segment16 IN OUT NOCOPY VARCHAR2
129 ,p_segment17 IN OUT NOCOPY VARCHAR2
130 ,p_segment18 IN OUT NOCOPY VARCHAR2
131 ,p_segment19 IN OUT NOCOPY VARCHAR2
132 ,p_segment20 IN OUT NOCOPY VARCHAR2
133 ,p_segment21 IN OUT NOCOPY VARCHAR2
134 ,p_segment22 IN OUT NOCOPY VARCHAR2
135 ,p_segment23 IN OUT NOCOPY VARCHAR2
136 ,p_segment24 IN OUT NOCOPY VARCHAR2
137 ,p_segment25 IN OUT NOCOPY VARCHAR2
138 ,p_segment26 IN OUT NOCOPY VARCHAR2
139 ,p_segment27 IN OUT NOCOPY VARCHAR2
140 ,p_segment28 IN OUT NOCOPY VARCHAR2
141 ,p_segment29 IN OUT NOCOPY VARCHAR2
142 ,p_segment30 IN OUT NOCOPY VARCHAR2
143 ,p_person_analysis_id IN OUT NOCOPY NUMBER
144 ,p_object_version_number IN OUT NOCOPY NUMBER);
145
146 PROCEDURE get_grade_details (p_grade_id IN NUMBER
147 ,p_grade_name IN OUT NOCOPY VARCHAR2
148 ,p_pay_plan IN OUT NOCOPY VARCHAR2
149 ,p_grade_or_level IN OUT NOCOPY VARCHAR2);
150
151
152 PROCEDURE get_retained_grade_details (p_person_id IN NUMBER
153 ,p_effective_date IN DATE
154 ,p_person_extra_info_id IN OUT NOCOPY NUMBER
155 ,p_date_from IN OUT NOCOPY DATE
156 ,p_date_to IN OUT NOCOPY DATE
157 ,p_grade_or_level IN OUT NOCOPY VARCHAR2
158 ,p_step_or_rate IN OUT NOCOPY VARCHAR2
159 ,p_pay_plan IN OUT NOCOPY VARCHAR2
160 ,p_pay_table_id IN OUT NOCOPY VARCHAR2
161 ,p_pay_basis IN OUT NOCOPY VARCHAR2
162 ,p_temp_step IN OUT NOCOPY VARCHAR2
163 );
164
165 -- Returns TRUE if there are any other reatined grade details for the person other than the one
166 -- given
167 FUNCTION further_retained_details_exist(p_person_id IN NUMBER
168 ,p_person_extra_info_id IN NUMBER)
169 RETURN BOOLEAN;
170
171 FUNCTION get_poi_desc (p_personnel_office_id IN NUMBER)
172 RETURN VARCHAR2;
173 --
174 PROCEDURE get_duty_station_details (p_location_id IN NUMBER
175 ,p_effective_date IN DATE
176 ,p_duty_sation_code IN OUT NOCOPY VARCHAR2
177 ,p_duty_station_desc IN OUT NOCOPY VARCHAR2
178 ,p_locality_pay_area IN OUT NOCOPY VARCHAR2
179 ,p_locality_pay_area_percentage IN OUT NOCOPY NUMBER
180 );
181 --
182 PROCEDURE get_org_details (p_org_id IN NUMBER
183 ,p_org_name IN OUT NOCOPY VARCHAR2
184 ,p_org_line1 IN OUT NOCOPY VARCHAR2
185 ,p_org_line2 IN OUT NOCOPY VARCHAR2
186 ,p_org_line3 IN OUT NOCOPY VARCHAR2
187 ,p_org_line4 IN OUT NOCOPY VARCHAR2
188 ,p_org_line5 IN OUT NOCOPY VARCHAR2
189 ,p_org_line6 IN OUT NOCOPY VARCHAR2);
190 --
191 -- Could not use ghr_api.retrieve_element_entry_value because that does not return
192 -- effective_start_date
193 PROCEDURE get_element_details (p_element_name IN VARCHAR2
194 ,p_input_value_name IN VARCHAR2
195 ,p_assignment_id IN NUMBER
196 ,p_effective_date IN DATE
197 ,p_value IN OUT NOCOPY VARCHAR2
198 ,p_effective_start_date IN OUT NOCOPY DATE
199 ,p_business_group_id IN NUMBER); -- Bug 4016362
200 --
201 PROCEDURE get_status_code (p_status IN VARCHAR2
202 ,p_status_code OUT NOCOPY VARCHAR2);
203 --
204 PROCEDURE get_element_entry_values (p_element_entry_id IN NUMBER
205 ,p_input_value_name IN VARCHAR2
206 ,p_effective_date IN DATE
207 ,p_value IN OUT NOCOPY VARCHAR2
208 ,p_effective_start_date IN OUT NOCOPY DATE);
209
210 --
211 FUNCTION info_type_is_valid (p_application_id IN NUMBER
212 ,p_responsibility_id IN NUMBER
213 ,p_info_type_table_name IN VARCHAR2
214 ,p_information_type IN VARCHAR2)
215 RETURN BOOLEAN;
216 --
217 FUNCTION get_workflow_id(p_workflow_name IN VARCHAR2)
218 RETURN NUMBER;
219 --
220 PROCEDURE get_noa_code (p_pa_request_id IN NUMBER
221 ,p_noa_code OUT NOCOPY VARCHAR2);
222 --
223 --Begin Bug# 6850492
224 PROCEDURE get_second_noa_code (p_pa_request_id IN NUMBER
225 ,p_second_noa_code OUT NOCOPY VARCHAR2);
226 --End Bug# 6850492
227 PROCEDURE get_dob_asgstat (p_assignment_id IN NUMBER
228 ,p_effective_date IN DATE
229 ,p_dob OUT NOCOPY DATE
230 ,p_system_status OUT NOCOPY VARCHAR2);
231 --
232 PROCEDURE get_current_emp_flag (p_effective_date IN DATE
233 ,p_person_id IN NUMBER
234 ,p_current_emp_flag OUT NOCOPY VARCHAR2);
235 --
236 PROCEDURE get_assignment_id (p_effective_date IN DATE
237 ,p_person_id IN NUMBER
238 ,p_assignment_id OUT NOCOPY NUMBER);
239 --
240 FUNCTION get_payroll_period_start_date (p_assignment_id IN NUMBER
241 ,p_effective_date IN DATE)
242 RETURN DATE;
243 --
244
245
246 END ghr_per_sum;