599: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
600: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
601: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
602: -- p_project_id IN NUMBER Required
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
606: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
607: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
608: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
615: -- p_record_version_number IN NUMBER Required
609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
615: -- p_record_version_number IN NUMBER Required
616: -- x_return_status OUT VARCHAR2 Required
617: -- x_msg_count OUT NUMBER Required
610: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
612: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
615: -- p_record_version_number IN NUMBER Required
616: -- x_return_status OUT VARCHAR2 Required
617: -- x_msg_count OUT NUMBER Required
618: -- x_msg_data OUT VARCHAR2 Required
631: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
632: p_debug_mode IN VARCHAR2 := 'N' ,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
632: p_debug_mode IN VARCHAR2 := 'N' ,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
633: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
634: p_project_id IN NUMBER ,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
638: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
639: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
640: p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
647: p_record_version_number IN NUMBER ,
641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
647: p_record_version_number IN NUMBER ,
648: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
649: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
642: p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR,
643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
644: p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR,
645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
647: p_record_version_number IN NUMBER ,
648: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
649: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
650: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895