786: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
787: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
788: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
789: -- p_project_id IN NUMBER Required
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
790: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
792: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
793: -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
794: -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795: -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802: -- p_record_version_number IN NUMBER Required
796: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802: -- p_record_version_number IN NUMBER Required
803: -- x_return_status OUT VARCHAR2 Required
804: -- x_msg_count OUT NUMBER Required
797: -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799: -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802: -- p_record_version_number IN NUMBER Required
803: -- x_return_status OUT VARCHAR2 Required
804: -- x_msg_count OUT NUMBER Required
805: -- x_msg_data OUT VARCHAR2 Required
817: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
818: p_debug_mode IN VARCHAR2 := 'N' ,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
818: p_debug_mode IN VARCHAR2 := 'N' ,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
819: p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
820: p_project_id IN NUMBER ,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
821: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
822: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,
823: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,
831: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
824: p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,
831: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
832: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
825: p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830: p_record_version_number IN NUMBER ,
831: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
832: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
833: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895