[Home] [Help]
PACKAGE: APPS.HR_REPORTS
Source
1 PACKAGE hr_reports AUTHID CURRENT_USER AS
2 /* $Header: peperrep.pkh 120.1 2007/09/12 21:39:15 rnestor noship $
3 ******************************************************************
4 * *
5 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
6 * Chertsey, England. *
7 * *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation UK Ltd, *
17 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
18 * England. *
19 * *
20 ******************************************************************
21 Name : hr_reports (HEADER)
22 File : peperrep.pkh
23 Description : This package declares functions which are used to
24 return Values for the SRW2 reports.
25
26 Change List
27 -----------
28
29 Version Date Author ER/CR No. Description of Change
30 -------+---------+----------+---------+--------------------------
31 70.0 17-JUN-93 JRHODES Date Created
32 70.1 23-JUN-93 JHOBBS Added get_business_group.
33 70.2 30-JUN-93 JHOBBS Changed get_organization and added
34 count_org_subordinates,
35 get_lookup_meaning,
36 get_organization_hierarchy,
37 count_pos_subordinates,
38 get_position_hierarchy
39 JRHODES Added person_matching_skills,
40 get_job,
41 get_position
42 PCHAPPEL Added get_payroll_name
43 07-JUL-93 PCHAPPEL added get_element_name
44 and changed names to hr_reports
45 12-JUL-93 JRHODES Split_segments
46 Gen_partial_matching_lexical
47 14_JUL-93 JHOBBS Added get_desc_flex and
48 get_dvlpr_desc_flex
49 70.3 04-AUG-93 nkhan Added get_attributes,
50 and split_attributes
51 COPIED from jrhodes codes
52 70.4 05-AUG-93 JRHODES Added get_grades and
53 get_status
54 70.5 05-AUG-93 NKHAN Chahged get_attributes -
55 p_title to p_name
56 70.6 06-AUG-93 JHOBBS Added get_person_name.
57 70.7 09-AUG-93 JRHODES Added get_abs_type
58 70.13 13-SEP-95 AMILLS Added procedure
59 get_desc_flex_context.
60 70.11 11-OCT-95 JTHURING Removed spurious end of comment marker
61 110.1 28-NOV-97 MMILLMOR 563806 Changed split_segments and
62 gen_partial_matching_lexical to take
63 an additional paramater p_id_flex_code
64 to correctly identify flexfields.
65 Procedures are overloaded.
66 110.2 01-DEC-97 MMILLMOR 550991 Changed get_desc_flex_context to only
67 display fields with the given display
68 flag. Preserved old function by
69 overloading.
70 110.3 10-FEB-98 SBHATTAL 622283 Created new versions of procedures
71 1) get_dvlpr_desc_flex
72 2) split_attributes
73 3) get_attributes
74 with an extra parameter
75 (p_aol_seperator_flag).
76 Retained old versions of these
77 procedures for existing calls in
78 reports (procedure overloading).
79 110.4 15-SEP-99 ASAHAY 641528 Changed split-segments and
80 gen_partial_matching_lexical to
81 overload new functionality.
82 115.2 12-01-2001 CSIMPSON 1512969 added overloaded get_position
83 function to return position name
84 for position_id on the effective
85 date parameter.
86 115.3 30-07-2002 VRAMANAI 2404099 Changed the SegmentTabType from
87 table of varchar2(60) to table
88 of varchar2(240)
89 115.4 01-08-2002 tabedin 2404098 To avoid gscc warning, changed phase
90 to pls and moved set verify line to
91 the begining
92 115.5 02-NOV-2002 eumenyio added nocopy.
93 115.6 04-FEB-2005 smparame 4081149 Added new function get_party_number
94 to return party_number for a party.
95 115.8 21-MAR-2007 ande 5651801 Changed return type of get_party_number
96 to varchar2.
97 =================================================================
98 */
99 TYPE SegmentTabType IS TABLE OF VARCHAR2(240)
100 INDEX BY BINARY_INTEGER;
101 SEGTAB SegmentTabType;
102 SegmentValue1 VARCHAR2(240);
103 --
104 --
105 function get_budget
106 (p_budget_id number) return varchar2;
107 --
108 --
109 function get_budget_version
110 (p_budget_id number
111 ,p_budget_version_id number) return varchar2;
112 --
113 --
114 procedure get_organization
115 (p_organization_id in number,
116 p_org_name out nocopy varchar2,
117 p_org_type out nocopy varchar2);
118 --
119 --
120 function get_job
121 (p_job_id number) return varchar2;
122 --
123 --
124 function get_position
125 (p_position_id number) return varchar2;
126 --
127 function get_position
128 (p_position_id number,
129 p_effective_date date) return varchar2;
130 --
131 function get_grade
132 (p_grade_id number) return varchar2;
133 --
134 --
135 function get_status
136 (p_business_group_id number,
137 p_assignment_status_type_id number,
138 p_legislation_code varchar2 ) return varchar2;
139 --
140 --
141 function get_abs_type
142 (p_abs_att_type_id number) return varchar2;
143 --
144 --
145 procedure get_time_period
146 (p_time_period_id in number
147 ,p_period_name out nocopy varchar2
148 ,p_start_date out nocopy date
149 ,p_end_date out nocopy date);
150 --
151 --
152 function get_business_group
153 (p_business_group_id number) return varchar2;
154 --
155 --
156 function count_org_subordinates
157 (p_org_structure_version_id number,
158 p_parent_organization_id number) return number;
159 --
160 --
161 function count_pos_subordinates
162 (p_pos_structure_version_id number,
163 p_parent_position_id number) return number;
164 --
165 --
166 procedure get_organization_hierarchy
167 (p_organization_structure_id in number,
168 p_org_structure_version_id in number,
169 p_org_structure_name out nocopy varchar2,
170 p_org_version out nocopy number,
171 p_version_start_date out nocopy date,
172 p_version_end_date out nocopy date);
173 --
174 --
175 procedure get_position_hierarchy
176 (p_position_structure_id in number,
177 p_pos_structure_version_id in number,
178 p_pos_structure_name out nocopy varchar2,
179 p_pos_version out nocopy number,
180 p_version_start_date out nocopy date,
181 p_version_end_date out nocopy date);
182 --
183 --
184 function get_lookup_meaning
185 (p_lookup_type varchar2,
186 p_lookup_code varchar2) return varchar2;
187 --
188 --
189 function person_matching_skills
190 (p_person_id in number
191 ,p_job_position_id in number
192 ,p_job_position_type in varchar2
193 ,p_matching_level in varchar2
194 ,p_no_of_essential in number
195 ,p_no_of_desirable in number) return boolean;
196 --
197 --
198 function get_payroll_name
199 (p_session_date date,
200 p_payroll_id number) return varchar2;
201 --
202 --
203 function get_element_name
204 (p_session_date date,
205 p_element_type_id number) return varchar2;
206 --
207 --
208 procedure split_attributes
209 (p_concatenated_segments in varchar2
210 ,p_title in varchar2
211 ,p_segtab out nocopy segmenttabtype
212 ,p_segments_used out nocopy number);
213 --
214 -- Added for bug fix 622283, version 110.3
215 --
216 procedure split_attributes
217 (p_concatenated_segments in varchar2
218 ,p_title in varchar2
219 ,p_aol_seperator_flag in boolean
220 ,p_segtab out nocopy segmenttabtype
221 ,p_segments_used out nocopy number);
222 --
223 --
224 procedure split_segments
225 (p_concatenated_segments in varchar2
226 ,p_id_flex_num in number
227 ,p_segtab out nocopy segmenttabtype
228 ,p_segments_used out nocopy number);
229 --
230 --
231 procedure split_segments
232 (p_concatenated_segments in varchar2
233 ,p_id_flex_num in number
234 ,p_segtab out nocopy segmenttabtype
235 ,p_segments_used out nocopy number
236 ,p_id_flex_code in varchar2);
237 --
238 --
239 procedure split_segments
240 (p_concatenated_segments in varchar2
241 ,p_id_flex_num in number
242 ,p_segtab out nocopy segmenttabtype
243 ,p_segments_used out nocopy number
244 ,p_id_flex_code in varchar2
245 ,p_application_id in number);
246 --
247 --
248 procedure gen_partial_matching_lexical
249 (p_concatenated_segments in varchar2
250 ,p_id_flex_num in number
251 ,p_matching_lexical in out nocopy varchar2);
252 --
253 --
254 procedure gen_partial_matching_lexical
255 (p_concatenated_segments in varchar2
256 ,p_id_flex_num in number
257 ,p_matching_lexical in out nocopy varchar2
258 ,p_id_flex_code in varchar2);
259 --
260 --
261 procedure gen_partial_matching_lexical
262 (p_concatenated_segments in varchar2
263 ,p_id_flex_num in number
264 ,p_matching_lexical in out nocopy varchar2
265 ,p_id_flex_code in varchar2
266 ,p_application_id in number);
267 --
268 --
269 procedure get_attributes
270 (p_concatenated_segments in varchar2
271 ,p_name in varchar2
272 ,p_segments_used out nocopy number
273 ,p_value1 out nocopy varchar2
274 ,p_value2 out nocopy varchar2
275 ,p_value3 out nocopy varchar2
276 ,p_value4 out nocopy varchar2
277 ,p_value5 out nocopy varchar2
278 ,p_value6 out nocopy varchar2
279 ,p_value7 out nocopy varchar2
280 ,p_value8 out nocopy varchar2
281 ,p_value9 out nocopy varchar2
282 ,p_value10 out nocopy varchar2
283 ,p_value11 out nocopy varchar2
284 ,p_value12 out nocopy varchar2
285 ,p_value13 out nocopy varchar2
286 ,p_value14 out nocopy varchar2
287 ,p_value15 out nocopy varchar2
288 ,p_value16 out nocopy varchar2
289 ,p_value17 out nocopy varchar2
290 ,p_value18 out nocopy varchar2
291 ,p_value19 out nocopy varchar2
292 ,p_value20 out nocopy varchar2
293 ,p_value21 out nocopy varchar2
294 ,p_value22 out nocopy varchar2
295 ,p_value23 out nocopy varchar2
296 ,p_value24 out nocopy varchar2
297 ,p_value25 out nocopy varchar2
298 ,p_value26 out nocopy varchar2
299 ,p_value27 out nocopy varchar2
300 ,p_value28 out nocopy varchar2
301 ,p_value29 out nocopy varchar2
302 ,p_value30 out nocopy varchar2 );
303 --
304 -- Added for bug fix 622283, version 110.3
305 --
306 procedure get_attributes
307 (p_concatenated_segments in varchar2
308 ,p_name in varchar2
309 ,p_aol_seperator_flag in boolean
310 ,p_segments_used out nocopy number
311 ,p_value1 out nocopy varchar2
312 ,p_value2 out nocopy varchar2
313 ,p_value3 out nocopy varchar2
314 ,p_value4 out nocopy varchar2
315 ,p_value5 out nocopy varchar2
316 ,p_value6 out nocopy varchar2
317 ,p_value7 out nocopy varchar2
318 ,p_value8 out nocopy varchar2
319 ,p_value9 out nocopy varchar2
320 ,p_value10 out nocopy varchar2
321 ,p_value11 out nocopy varchar2
322 ,p_value12 out nocopy varchar2
323 ,p_value13 out nocopy varchar2
324 ,p_value14 out nocopy varchar2
325 ,p_value15 out nocopy varchar2
326 ,p_value16 out nocopy varchar2
327 ,p_value17 out nocopy varchar2
328 ,p_value18 out nocopy varchar2
329 ,p_value19 out nocopy varchar2
330 ,p_value20 out nocopy varchar2
331 ,p_value21 out nocopy varchar2
332 ,p_value22 out nocopy varchar2
333 ,p_value23 out nocopy varchar2
334 ,p_value24 out nocopy varchar2
335 ,p_value25 out nocopy varchar2
336 ,p_value26 out nocopy varchar2
337 ,p_value27 out nocopy varchar2
338 ,p_value28 out nocopy varchar2
339 ,p_value29 out nocopy varchar2
340 ,p_value30 out nocopy varchar2 );
341 --
342 --
343 procedure get_segments
344 (p_concatenated_segments in varchar2
345 ,p_id_flex_num in number
346 ,p_segments_used out nocopy number
347 ,p_value1 out nocopy varchar2
348 ,p_value2 out nocopy varchar2
349 ,p_value3 out nocopy varchar2
350 ,p_value4 out nocopy varchar2
351 ,p_value5 out nocopy varchar2
352 ,p_value6 out nocopy varchar2
353 ,p_value7 out nocopy varchar2
354 ,p_value8 out nocopy varchar2
355 ,p_value9 out nocopy varchar2
356 ,p_value10 out nocopy varchar2
357 ,p_value11 out nocopy varchar2
358 ,p_value12 out nocopy varchar2
359 ,p_value13 out nocopy varchar2
360 ,p_value14 out nocopy varchar2
361 ,p_value15 out nocopy varchar2
362 ,p_value16 out nocopy varchar2
363 ,p_value17 out nocopy varchar2
364 ,p_value18 out nocopy varchar2
365 ,p_value19 out nocopy varchar2
366 ,p_value20 out nocopy varchar2
367 ,p_value21 out nocopy varchar2
368 ,p_value22 out nocopy varchar2
369 ,p_value23 out nocopy varchar2
370 ,p_value24 out nocopy varchar2
371 ,p_value25 out nocopy varchar2
372 ,p_value26 out nocopy varchar2
373 ,p_value27 out nocopy varchar2
374 ,p_value28 out nocopy varchar2
375 ,p_value29 out nocopy varchar2
376 ,p_value30 out nocopy varchar2 );
377 --
378 --
379 procedure get_desc_flex
380 (p_appl_short_name in varchar2,
381 p_desc_flex_name in varchar2,
382 p_table_alias in varchar2,
383 p_title out nocopy varchar2,
384 p_label_expr out nocopy varchar2,
385 p_column_expr out nocopy varchar2);
386 --
387 --
388 procedure get_desc_flex_context
389 (p_appl_short_name in varchar2,
390 p_desc_flex_name in varchar2,
391 p_table_alias in varchar2,
392 p_title out nocopy varchar2,
393 p_label_expr out nocopy varchar2,
394 p_column_expr out nocopy varchar2);
395 --
396 --
397 procedure get_desc_flex_context
398 (p_appl_short_name in varchar2,
399 p_desc_flex_name in varchar2,
400 p_table_alias in varchar2,
401 p_display in varchar2,
402 p_title out nocopy varchar2,
403 p_label_expr out nocopy varchar2,
404 p_column_expr out nocopy varchar2);
405 --
406 --
407 procedure get_dvlpr_desc_flex
408 (p_appl_short_name in varchar2,
409 p_desc_flex_name in varchar2,
410 p_desc_flex_context in varchar2,
411 p_table_alias in varchar2,
412 p_title out nocopy varchar2,
413 p_label_expr out nocopy varchar2,
414 p_column_expr out nocopy varchar2);
415 --
416 -- Added for bug fix 622283, version 110.3
417 --
418 procedure get_dvlpr_desc_flex
419 (p_appl_short_name in varchar2,
420 p_desc_flex_name in varchar2,
421 p_desc_flex_context in varchar2,
422 p_table_alias in varchar2,
423 p_aol_seperator_flag in boolean,
424 p_title out nocopy varchar2,
425 p_label_expr out nocopy varchar2,
426 p_column_expr out nocopy varchar2);
427 --
428 --
429 function get_person_name
430 (p_session_date date,
431 p_person_id number) return varchar2;
432 --
433 --
434 -- Bug fix 4081149. added function
435 -- get_party_number
436 --
437 function get_party_number
438 (p_party_id in number) return varchar2;
439 --changed return type to varchar2
440 --
441 end hr_reports;