[Home] [Help]
PACKAGE: APPS.HR_SUIT_MATCH_UTILITY_WEB
Source
1 PACKAGE hr_suit_match_utility_web AUTHID CURRENT_USER AS
2 /* $Header: hrsmutlw.pkh 120.3 2005/12/13 13:42:55 svittal noship $ */
3
4
5 TYPE g_people_rec IS RECORD(
6 person_id per_people_f.person_id%type
7 ,employee_number per_people_f.employee_number%type
8 ,applicant_number per_people_f.applicant_number%type
9 ,name per_people_f.full_name%type
10 ,work_phone per_people_f.work_telephone%type
11 ,hire_date per_periods_of_service.date_start%type
12 ,location_code per_people_f.internal_location%type
13 ,person_type varchar2(2000) );
14 TYPE g_person_table IS TABLE of g_people_rec
15 INDEX BY BINARY_INTEGER;
16
17 TYPE g_competence_rec IS RECORD(
18 competence_element_id per_competence_elements.competence_element_id%TYPE
19 ,effective_date_from per_competence_elements.effective_date_from%TYPE
20 ,competence_id per_competences.competence_id%TYPE
21 ,competence_name per_competences.name%TYPE
22 ,low_rating_level_id per_competence_elements.proficiency_level_id%TYPE
23 ,high_rating_level_id per_competence_elements.high_proficiency_level_id%TYPE
24 ,low_step_value per_rating_levels.step_value%TYPE
25 ,low_step_name per_rating_levels.name%TYPE
26 ,high_step_value per_rating_levels.step_value%TYPE
27 ,high_step_name per_rating_levels.name%TYPE
28 ,mandatory per_competence_elements.mandatory%TYPE
29 ,checked varchar(1) );
30 TYPE g_competence_table IS TABLE of g_competence_rec
31 INDEX BY BINARY_INTEGER;
32
33 TYPE g_rank_rec IS RECORD(
34 id number
35 ,name varchar2(2000)
36 ,e_count number
37 ,d_count number
38 ,match_e_count number
39 ,match_d_count number
40 ,type varchar2(2000)
41 ,assignment_id number);
42 TYPE g_rank_table IS TABLE of g_rank_rec
43 INDEX BY BINARY_INTEGER;
44
45 TYPE g_org_rec IS RECORD(
46 org_id hr_organization_units.organization_id%TYPE
47 ,name hr_organization_units.name%TYPE);
48 TYPE g_org_table IS TABLE of g_org_rec
49 INDEX BY BINARY_INTEGER;
50
51 g_suit_match_work_oppor varchar2(30) :=
52 'HR_SUIT_MATCH_WORK_OPPOR';
53 g_suit_match_openings varchar2(30) :=
54 'HR_SUIT_MATCH_OPENINGS';
55 g_suit_match_successions varchar2(30) :=
56 'HR_SUIT_MATCH_SUCCESSIONS';
57 g_suit_match_deployments varchar2(30) :=
58 'HR_SUIT_MATCH_DEPLOYMENTS';
59 g_none_type varchar2(20) := 'N'; --None
60 g_organization_type varchar2(20) := 'O'; --Organization
61 g_job_type varchar2(20) := 'J'; --Job
62 g_position_type varchar2(20) := 'P'; --Position
63 g_vacancy_type varchar2(20) := 'V'; --Vacancy
64 g_location_type varchar2(20) := 'L'; --Location
65 g_grade_type varchar2(20) := 'G'; --Grade
66 g_class_type varchar2(20) := 'C'; --Class
67 g_people_type varchar2(20) := 'X'; --People
68
69 --Find work opportunites for a person
70 g_match_work_mode varchar2(20) := 'SMW';
71 --Compare pending job applications for a person
72 g_work_vacancies_fast_path varchar2(20) := 'SMW-FV';
73 --Compare current succession options for a person
74 g_work_successions_fast_path varchar2(20) := 'SMW-FS';
75 --Compare current assignments for a person
76 g_work_deployments_fast_path varchar2(20) := 'SMW-FD';
77 --Classes nominated for the person
78 g_work_classes_fast_path varchar2(20) := 'SMW-FC';
79
80 --Suitability matching for a work opportunity
81 g_match_people_mode varchar2(20) := 'SMP';
82 --Compare people assigned to a role
83 g_match_peope_role_mode varchar2(20) := 'SMP-FR';
84 --Compare named successors for a position
85 g_match_successors_pos_mode varchar2(20) := 'SMP-FP';
86 --Compare applicants for an opening
87 g_match_applicants_van_mode varchar2(20) := 'SMP-FV';
88 --Find people for a work opportunity
89 g_select_people_work_mode varchar2(20) := 'SMP-WO';
90
91 --Person Search module
92 g_person_search_mode varchar2(20) := 'PER';
93 --Succession plan module
94 g_succession_plan_mode varchar2(20) := 'SUC';
95 g_succ_plan_per_mode varchar2(20) := 'SUC-PER';
96 g_succ_plan_pos_mode varchar2(20) := 'SUC-POS';
97
98 g_japan_legislation_code varchar2(5) := 'JP';
99
100 -- ---------------------------------------------------------------------------
101 -- get_system_person_type
102 -- ---------------------------------------------------------------------------
103
104 FUNCTION get_system_person_type(p_person_type_id in number)
105 RETURN varchar2;
106 -- ---------------------------------------------------------------------------
107 -- get_option_header
108 -- ---------------------------------------------------------------------------
109 FUNCTION get_option_header(p_mode in varchar2)
110 RETURN varchar2;
111
112 -- ---------------------------------------------------------------------------
113 -- get_lookup_meaning
114 -- ---------------------------------------------------------------------------
115 FUNCTION get_lookup_meaning
116 (p_lookup_type in varchar2
117 ,p_lookup_code in varchar2
118 ,p_schema in varchar2 default 'HR')
119 RETURN varchar2;
120
121 -- ---------------------------------------------------------------------------
122 -- get_max_step_value
123 -- ---------------------------------------------------------------------------
124
125 FUNCTION get_max_step_value
126 (p_competence_id in hr_util_misc_web.g_varchar2_tab_type)
127 RETURN number;
128
129 -- ---------------------------------------------------------------------------
130 -- get_work_detail_name
131 -- ---------------------------------------------------------------------------
132 FUNCTION get_work_detail_name
133 (p_search_type in varchar2
134 ,p_search_id in varchar2)
135 RETURN varchar2;
136
137 -- ---------------------------------------------------------------------------
138 -- encode_competence_table
139 -- ---------------------------------------------------------------------------
140 PROCEDURE encode_competence_table
141 (p_competence_id in hr_util_misc_web.g_varchar2_tab_type
142 ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type
143 ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
144 ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
145 ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type
146 ,p_competence_table out nocopy g_competence_table
147 ,p_essential_count out nocopy number
148 ,p_desirable_count out nocopy number) ;
149
150 -- ---------------------------------------------------------------------------
151 -- decode_competence_table
152 -- ---------------------------------------------------------------------------
153 PROCEDURE decode_competence_table
154 (p_competence_table in g_competence_table
155 ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type
156 ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type
157 ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
158 ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
159 ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type);
160 -- ---------------------------------------------------------------------------
161 -- get_person_info
162 -- ---------------------------------------------------------------------------
163
164 PROCEDURE get_person_info
165 (p_id in number
166 ,p_person_table out nocopy g_person_table);
167 -- ---------------------------------------------------------------------------
168 -- get_people_info
169 -- ---------------------------------------------------------------------------
170 PROCEDURE get_people_info
171 (p_id in hr_util_misc_web.g_varchar2_tab_type
172 ,p_person_table out nocopy g_person_table
173 ,p_count out nocopy number);
174
175 -- ---------------------------------------------------------------------------
176 -- keyflex_select_where_clause
177 -- ---------------------------------------------------------------------------
178 PROCEDURE keyflex_select_where_clause
179 (p_business_group_id in number
180 ,p_keyflex_code in varchar2
181 ,p_filter_clause in varchar2 default null
182 ,p_select_clause out nocopy varchar2
183 ,p_where_clause out nocopy varchar2);
184 -- ---------------------------------------------------------------------------
185 -- get_keyflex_mapped_column_name
186 -- ---------------------------------------------------------------------------
187 PROCEDURE get_keyflex_mapped_column_name
188 (p_business_group_id in number
189 ,p_keyflex_code in varchar2
190 ,p_mapped_col_names out nocopy hr_util_misc_web.g_varchar2_tab_type
191 ,p_segment_separator out nocopy varchar2
192 ,p_count out nocopy number);
193
194 -- ---------------------------------------------------------------------------
195 -- get_search_count
196 -- ---------------------------------------------------------------------------
197
198 FUNCTION get_search_count
199 (p_mode in varchar2
200 ,p_person_type_id in varchar2 default null
201 ,p_assignment_type in varchar2 default null
202 ,p_pre_search_type in varchar2
203 ,p_pre_search_ids in varchar2
204 ,p_search_type in varchar2
205 ,p_filer_match in varchar2
206 ,p_search_criteria in varchar2)
207 RETURN number;
208 -- ---------------------------------------------------------------------------
209 -- get_step_value
210 -- ---------------------------------------------------------------------------
211
212 FUNCTION get_step_value(p_rating_level_id in number)
213 RETURN per_rating_levels.step_value%TYPE;
214 -- ---------------------------------------------------------------------------
215 -- get_competence_name
216 -- ---------------------------------------------------------------------------
217
218 FUNCTION get_competence_name(p_competence_id in number)
219 RETURN per_competences_tl.name%type;
220
221 -- ---------------------------------------------------------------------------
222 -- get_drived_org_job
223 -- ---------------------------------------------------------------------------
224
225 PROCEDURE get_drived_org_job
226 (p_pos_id in number
227 ,p_org_id out nocopy number
228 ,p_job_id out nocopy number);
229 -- ---------------------------------------------------------------------------
230 -- get_item
231 -- ---------------------------------------------------------------------------
232
233 FUNCTION get_item
234 (p_ids in varchar2
235 ,p_index in number)
236 RETURN varchar2;
237 -- ---------------------------------------------------------------------------
238 -- build_items
239 -- ---------------------------------------------------------------------------
240
241 FUNCTION build_items
242 (p_id in hr_util_misc_web.g_varchar2_tab_type
243 ,p_start_index in number default 1)
244 RETURN varchar2;
245
246 -- ---------------------------------------------------------------------------
247 -- build_grade_sql
248 -- ---------------------------------------------------------------------------
249
250 FUNCTION build_grade_sql
251 (p_search_type in varchar2
252 ,p_id in number)
253 RETURN varchar2;
254 -- ---------------------------------------------------------------------------
255 -- build_sql
256 -- ---------------------------------------------------------------------------
257
258 FUNCTION build_sql
259 (p_search_type in varchar2
260 ,p_ids in varchar2)
261 RETURN varchar2;
262
263 -- ---------------------------------------------------------------------------
264 -- build_sql
265 -- ---------------------------------------------------------------------------
266
267 FUNCTION build_sql
268 (p_mode in varchar2
269 ,p_person_type_id in varchar2 default null
270 ,p_assignment_type in varchar2 default null
271 ,p_pre_search_type in varchar2
272 ,p_pre_search_ids in varchar2
273 ,p_search_type in varchar2
274 ,p_filer_match in varchar2
275 ,p_search_criteria in varchar2)
276 RETURN varchar2;
277
278 -- ---------------------------------------------------------------------------
279 -- get_id_name
280 -- ---------------------------------------------------------------------------
281
282 PROCEDURE get_id_name
283 (p_dynamic_sql in varchar2
284 ,p_id out nocopy hr_util_misc_web.g_varchar2_tab_type
285 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
286 ,p_count out nocopy number);
287
288 -- ---------------------------------------------------------------------------
289 -- get_job_info
290 -- ---------------------------------------------------------------------------
291
292 PROCEDURE get_job_info
293 (p_search_type in varchar2
294 ,p_id in varchar2
295 ,p_name out nocopy varchar2
296 ,p_org_name out nocopy varchar2
297 ,p_location_code out nocopy varchar2);
298
299
300 -- ---------------------------------------------------------------------------
301 -- process_filter
302 -- ---------------------------------------------------------------------------
303
304 FUNCTION process_filter
305 (p_filter_match in varchar2
306 ,p_search_criteria in varchar2)
307 RETURN varchar2;
308 -- ---------------------------------------------------------------------------
309 -- get_core_competencies
310 -- ---------------------------------------------------------------------------
311
312 PROCEDURE get_core_competencies
313 (p_business_group_id in number default null
314 ,p_effective_date in date default sysdate
315 ,p_competence_table out nocopy g_competence_table
316 ,p_competence_count out nocopy number
317 ,p_essential_count out nocopy number
318 ,p_desirable_count out nocopy number);
319 -- ---------------------------------------------------------------------------
320 -- get_org_competencies
321 -- ---------------------------------------------------------------------------
322
323 PROCEDURE get_org_competencies
324 (p_org_id in number
325 ,p_effective_date in date default sysdate
326 ,p_include_core_competencies in varchar2 default 'N'
327 ,p_competence_table out nocopy g_competence_table
328 ,p_competence_count out nocopy number
329 ,p_essential_count out nocopy number
330 ,p_desirable_count out nocopy number);
331 -- ---------------------------------------------------------------------------
332 -- get_job_competencies
333 -- ---------------------------------------------------------------------------
334 PROCEDURE get_job_competencies
335 (p_job_id in number
336 ,p_grade_id in number default null
337 ,p_effective_date in date default sysdate
338 ,p_include_core_competencies in varchar2 default 'N'
339 ,p_competence_table out nocopy g_competence_table
340 ,p_competence_count out nocopy number
341 ,p_essential_count out nocopy number
342 ,p_desirable_count out nocopy number);
343 -- ---------------------------------------------------------------------------
344 -- get_pos_competencies
345 -- ---------------------------------------------------------------------------
346
347 PROCEDURE get_pos_competencies
348 (p_pos_id in number
349 ,p_grade_id in number default null
350 ,p_effective_date in date default sysdate
351 ,p_competence_table out nocopy g_competence_table
352 ,p_competence_count out nocopy number
353 ,p_essential_count out nocopy number
354 ,p_desirable_count out nocopy number);
355 -- ---------------------------------------------------------------------------
356 -- get_all_pos_competencies
357 -- ---------------------------------------------------------------------------
358 PROCEDURE get_all_pos_competencies
359 (p_pos_id in number
360 ,p_grade_id in number default null
361 ,p_effective_date in date default sysdate
362 ,p_include_core_competencies in varchar2 default 'N'
363 ,p_competence_table out nocopy g_competence_table
364 ,p_competence_count out nocopy number
365 ,p_essential_count out nocopy number
366 ,p_desirable_count out nocopy number);
367 -- ---------------------------------------------------------------------------
368 -- get_vac_competencies
369 -- ---------------------------------------------------------------------------
370
371 PROCEDURE get_vac_competencies
372 (p_vacancy_id in number
373 ,p_effective_date in date default sysdate
374 ,p_include_core_competencies in varchar2 default 'N'
375 ,p_competence_table out nocopy g_competence_table
376 ,p_competence_count out nocopy number
377 ,p_essential_count out nocopy number
378 ,p_desirable_count out nocopy number);
379
380 -- ---------------------------------------------------------------------------
381 -- get_person_competencies
382 -- ---------------------------------------------------------------------------
383
384 PROCEDURE get_person_competencies
385 (p_person_id in number
386 ,p_effective_date in date default sysdate
387 ,p_competence_table out nocopy g_competence_table
388 ,p_competence_count out nocopy number);
389
390 -- ---------------------------------------------------------------------------
391 -- process_duplicate_competence
392 -- ---------------------------------------------------------------------------
393 PROCEDURE process_duplicate_competence
394 (p_checked_competence_table in out nocopy g_competence_table
395 ,p_against_competence_table in out nocopy g_competence_table);
396 -- ---------------------------------------------------------------------------
397 -- process_exclusive_competence
398 -- ---------------------------------------------------------------------------
399 PROCEDURE process_exclusive_competence
400 (p_checked_competence_table in out nocopy g_competence_table
401 ,p_against_competence_table in out nocopy g_competence_table
402 ,p_competence_count in out nocopy number
403 ,p_essential_count in out nocopy number
404 ,p_desirable_count in out nocopy number);
405 -- ---------------------------------------------------------------------------
406 -- ranking
407 -- ---------------------------------------------------------------------------
408
409 PROCEDURE ranking
410 (p_type in varchar2
411 ,p_id in number
412 ,p_grade_id in number
413 ,p_person_id in number
414 ,p_effective_date in date default sysdate
415 ,p_essential_count out nocopy number
416 ,p_desirable_count out nocopy number
417 ,p_match_essential_count out nocopy number
418 ,p_match_desirable_count out nocopy number);
419
420 -- ---------------------------------------------------------------------------
421 -- ranking
422 -- ---------------------------------------------------------------------------
423
424 PROCEDURE ranking
425 (p_person_id in number
426 ,p_effective_date in date default sysdate
427 ,p_competence_table in g_competence_table
428 ,p_competence_count in number
429 ,p_match_essential_count out nocopy number
430 ,p_match_desirable_count out nocopy number);
431 -- ---------------------------------------------------------------------------
432 -- sort_rank_list
433 -- ---------------------------------------------------------------------------
434
435 PROCEDURE sort_rank_list
436 (p_rank_table in out nocopy g_rank_table
437 ,p_rank_table_count in number);
438 -- ---------------------------------------------------------------------------
439 -- get_people_by_vacancy
440 -- ---------------------------------------------------------------------------
441
442 PROCEDURE get_people_by_vacancy
443 (p_vacancy_id in number
444 ,p_effective_date in date default sysdate
445 ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
446 ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
447 ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
448 ,p_count out nocopy number);
449
450 -- ---------------------------------------------------------------------------
451 -- get_vacancies_by_person
452 -- ---------------------------------------------------------------------------
453
454 PROCEDURE get_vacancies_by_person
455 (p_person_id in number
456 ,p_effective_date in date default sysdate
457 ,p_vacancy_id out nocopy hr_util_misc_web.g_varchar2_tab_type
458 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
459 ,p_count out nocopy number);
460
461 -- ---------------------------------------------------------------------------
462 -- get_succession_by_person
463 -- ---------------------------------------------------------------------------
464
465 PROCEDURE get_succession_by_person
466 (p_person_id in number
467 ,p_effective_date in date default sysdate
468 ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
469 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
470 ,p_count out nocopy number);
471
472 -- ---------------------------------------------------------------------------
473 -- get_deployment_by_person
474 -- ---------------------------------------------------------------------------
475
476 PROCEDURE get_deployment_by_person
477 (p_person_id in number
478 ,p_effective_date in date default sysdate
479 ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
480 ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
481 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
482 ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
483 ,p_count out nocopy number);
484
485 -- ---------------------------------------------------------------------------
486 -- get_job_deployment_by_person
487 -- ---------------------------------------------------------------------------
488
489 PROCEDURE get_job_deployment_by_person
490 (p_person_id in number
491 ,p_effective_date in date default sysdate
492 ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
493 ,p_job_id out nocopy hr_util_misc_web.g_varchar2_tab_type
494 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
495 ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
496 ,p_count out nocopy number);
497
498 -- ---------------------------------------------------------------------------
499 -- get_org_deployment_by_person
500 -- ---------------------------------------------------------------------------
501
502 PROCEDURE get_org_deployment_by_person
503 (p_person_id in number
504 ,p_effective_date in date default sysdate
505 ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
506 ,p_org_id out nocopy hr_util_misc_web.g_varchar2_tab_type
507 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
508 ,p_count out nocopy number);
509
510 -- ---------------------------------------------------------------------------
511 -- get_vac_deployment_by_person
512 -- ---------------------------------------------------------------------------
513
514 PROCEDURE get_vac_deployment_by_person
515 (p_person_id in number
516 ,p_effective_date in date default sysdate
517 ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
518 ,p_vac_id out nocopy hr_util_misc_web.g_varchar2_tab_type
519 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
520 ,p_count out nocopy number);
521 -- ---------------------------------------------------------------------------
522 -- get_succesors_by_position
523 -- ---------------------------------------------------------------------------
524
525 PROCEDURE get_succesors_by_position
526 (p_pos_id in number
527 ,p_effective_date in date default sysdate
528 ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
529 ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
530 ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
531 ,p_count out nocopy number);
532
533 -- ---------------------------------------------------------------------------
534 -- get_people_by_role
535 -- ---------------------------------------------------------------------------
536
537 PROCEDURE get_people_by_role
538 (p_pre_search_type in varchar2
539 ,p_pre_search_id in varchar2
540 ,p_search_type in varchar2
541 ,p_search_id in varchar2
542 ,p_grade_id in number default null
543 ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
544 ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
545 ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
546 ,p_count out nocopy number);
547
548 -- ---------------------------------------------------------------------------
549 -- get_people_by_role_org
550 -- ---------------------------------------------------------------------------
551
552 PROCEDURE get_people_by_role_org
553 (p_org_id in number
554 ,p_effective_date in date default sysdate
555 ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
556 ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
557 ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
558 ,p_count out nocopy number);
559
560 -- ---------------------------------------------------------------------------
561 -- get_people_by_role_job
562 -- ---------------------------------------------------------------------------
563
564 PROCEDURE get_people_by_role_job
565 (p_job_id in number
566 ,p_grade_id in number default null
567 ,p_effective_date in date default sysdate
568 ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
569 ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
570 ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
571 ,p_count out nocopy number);
572
573 -- ---------------------------------------------------------------------------
574 -- get_people_by_role_pos
575 -- ---------------------------------------------------------------------------
576
577 PROCEDURE get_people_by_role_pos
578 (p_pos_id in number
579 ,p_grade_id in number default null
580 ,p_effective_date in date default sysdate
581 ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
582 ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
583 ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
584 ,p_count out nocopy number);
585
586 -- ---------------------------------------------------------------------------
587 -- get_people_by_course
588 -- ---------------------------------------------------------------------------
589
590 PROCEDURE get_people_by_course
591 (p_activity_version_id in number
592 ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
593 ,p_count out nocopy number);
594
595 -- ---------------------------------------------------------------------------
596 -- get_course_by_person
597 -- ---------------------------------------------------------------------------
598
599 PROCEDURE get_course_by_person
600 (p_person_id in number
601 ,p_activity_version_id out nocopy hr_util_misc_web.g_varchar2_tab_type
602 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
603 ,p_count out nocopy number);
604
605
606 -- ---------------------------------------------------------------------------
607 -- get_rating_scale_by_competence
608 -- ---------------------------------------------------------------------------
609
610 PROCEDURE get_rating_scale_by_competence
611 (p_competence_id in number
612 ,p_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
613 ,p_step_value out nocopy hr_util_misc_web.g_varchar2_tab_type
614 ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
615 ,p_count out nocopy number);
616
617
618
619 END hr_suit_match_utility_web;