APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on HR_UTIL_MISC_WEB

Line 126: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type)

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

Line 141: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type

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

Line 142: ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type

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

Line 143: ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type

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

Line 144: ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type

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) ;

Line 145: ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type

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:

Line 155: ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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);

Line 156: ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 157: ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 158: ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 159: ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type);

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:

Line 171: (p_id in hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 190: ,p_mapped_col_names out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 242: (p_id in hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 284: ,p_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 285: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 445: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 446: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 447: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 457: ,p_vacancy_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 458: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 468: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 469: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 479: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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);

Line 480: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 481: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 482: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 492: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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);

Line 493: ,p_job_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 494: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 495: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 505: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 506: ,p_org_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 507: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 517: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 518: ,p_vac_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 519: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 528: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 529: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 530: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 543: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 544: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 545: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 555: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 556: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 557: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 568: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 569: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 570: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 581: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 582: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 583: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 592: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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

Line 601: ,p_activity_version_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 602: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: -- ---------------------------------------------------------------------------

Line 612: ,p_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 613: ,p_step_value out nocopy hr_util_misc_web.g_varchar2_tab_type

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:

Line 614: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

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: