eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PROJECTS_ALL

Line 603: -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM

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

Line 604: -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

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,

Line 605: -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM

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

Line 606: -- p_search_min_availability IN pa_projects_all.search_min_availability%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,

Line 607: -- p_search_country_code IN pa_projects_all.search_country_code%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

Line 609: -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_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

Line 611: -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%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

Line 613: -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM

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

Line 614: -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR

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

Line 635: p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,

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,

Line 636: p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,

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,

Line 637: p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,

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,

Line 638: p_search_min_availability IN pa_projects_all.search_min_availability%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,

Line 639: p_search_country_code IN pa_projects_all.search_country_code%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,

Line 641: p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_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,

Line 643: p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%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 ,

Line 645: p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,

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

Line 646: p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,

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