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_SEARCH_PUB dependencies on FND_API

Line 7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

3: --
4:
5: PROCEDURE Run_Search(
6: p_search_mode IN VARCHAR2
7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM

Line 8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM

4:
5: PROCEDURE Run_Search(
6: p_search_mode IN VARCHAR2
7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM

5: PROCEDURE Run_Search(
6: p_search_mode IN VARCHAR2
7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR

6: p_search_mode IN VARCHAR2
7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM

7: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM

8: , p_assignment_number IN pa_project_assignments.assignment_number%TYPE := FND_API.G_MISS_NUM
9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM

Line 13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

9: , p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

Line 14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

10: , p_resource_name IN pa_resources.name%TYPE := FND_API.G_MISS_CHAR
11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM

Line 15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

11: , p_project_id IN pa_projects_all.project_id%TYPE := FND_API.G_MISS_NUM
12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM

12: , p_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

13: , p_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR

Line 18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM

14: , p_min_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

15: , p_max_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
23: , p_start_date IN DATE := FND_API.G_MISS_DATE

Line 20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR

16: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE := FND_API.G_MISS_NUM
17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
23: , p_start_date IN DATE := FND_API.G_MISS_DATE
24: , p_end_date IN DATE := FND_API.G_MISS_DATE

Line 21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR

17: , p_org_hierarchy_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
23: , p_start_date IN DATE := FND_API.G_MISS_DATE
24: , p_end_date IN DATE := FND_API.G_MISS_DATE
25: , p_competence_id IN system.pa_num_tbl_type := NULL

Line 22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

18: , p_organization_id IN hr_organization_units.organization_id%TYPE := FND_API.G_MISS_NUM
19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
23: , p_start_date IN DATE := FND_API.G_MISS_DATE
24: , p_end_date IN DATE := FND_API.G_MISS_DATE
25: , p_competence_id IN system.pa_num_tbl_type := NULL
26: , p_competence_alias IN system.pa_varchar2_30_tbl_type := NULL

Line 23: , p_start_date IN DATE := FND_API.G_MISS_DATE

19: , p_organization_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
23: , p_start_date IN DATE := FND_API.G_MISS_DATE
24: , p_end_date IN DATE := FND_API.G_MISS_DATE
25: , p_competence_id IN system.pa_num_tbl_type := NULL
26: , p_competence_alias IN system.pa_varchar2_30_tbl_type := NULL
27: , p_competence_name IN system.pa_varchar2_240_tbl_type := NULL

Line 24: , p_end_date IN DATE := FND_API.G_MISS_DATE

20: , p_employees_only IN VARCHAR2 := FND_API.G_MISS_CHAR
21: , p_territory_code IN fnd_territories_vl.territory_code%TYPE := FND_API.G_MISS_CHAR
22: , p_territory_short_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
23: , p_start_date IN DATE := FND_API.G_MISS_DATE
24: , p_end_date IN DATE := FND_API.G_MISS_DATE
25: , p_competence_id IN system.pa_num_tbl_type := NULL
26: , p_competence_alias IN system.pa_varchar2_30_tbl_type := NULL
27: , p_competence_name IN system.pa_varchar2_240_tbl_type := NULL
28: , p_rating IN system.pa_num_tbl_type := NULL

Line 31: , p_region IN VARCHAR := FND_API.G_MISS_CHAR

27: , p_competence_name IN system.pa_varchar2_240_tbl_type := NULL
28: , p_rating IN system.pa_num_tbl_type := NULL
29: , p_mandatory IN system.pa_varchar2_1_tbl_type := NULL
30: , p_provisional_availability IN VARCHAR DEFAULT 'N'
31: , p_region IN VARCHAR := FND_API.G_MISS_CHAR
32: , p_city IN VARCHAR := FND_API.G_MISS_CHAR
33: -- , p_competences IN pa_search_glob.Competence_Criteria_Tbl_Type
34: , p_work_current_loc IN VARCHAR DEFAULT 'N'
35: , p_work_all_loc IN VARCHAR DEFAULT 'N'

Line 32: , p_city IN VARCHAR := FND_API.G_MISS_CHAR

28: , p_rating IN system.pa_num_tbl_type := NULL
29: , p_mandatory IN system.pa_varchar2_1_tbl_type := NULL
30: , p_provisional_availability IN VARCHAR DEFAULT 'N'
31: , p_region IN VARCHAR := FND_API.G_MISS_CHAR
32: , p_city IN VARCHAR := FND_API.G_MISS_CHAR
33: -- , p_competences IN pa_search_glob.Competence_Criteria_Tbl_Type
34: , p_work_current_loc IN VARCHAR DEFAULT 'N'
35: , p_work_all_loc IN VARCHAR DEFAULT 'N'
36: , p_travel_domestically IN VARCHAR DEFAULT 'N'

Line 39: , p_minimum_availability IN NUMBER := FND_API.G_MISS_NUM

35: , p_work_all_loc IN VARCHAR DEFAULT 'N'
36: , p_travel_domestically IN VARCHAR DEFAULT 'N'
37: , p_travel_internationally IN VARCHAR DEFAULT 'N'
38: -- , p_ad_hoc_search IN VARCHAR DEFAULT 'N'
39: , p_minimum_availability IN NUMBER := FND_API.G_MISS_NUM
40: , p_restrict_res_comp IN VARCHAR := FND_API.G_MISS_CHAR
41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR
42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR

Line 40: , p_restrict_res_comp IN VARCHAR := FND_API.G_MISS_CHAR

36: , p_travel_domestically IN VARCHAR DEFAULT 'N'
37: , p_travel_internationally IN VARCHAR DEFAULT 'N'
38: -- , p_ad_hoc_search IN VARCHAR DEFAULT 'N'
39: , p_minimum_availability IN NUMBER := FND_API.G_MISS_NUM
40: , p_restrict_res_comp IN VARCHAR := FND_API.G_MISS_CHAR
41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR
42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM

Line 41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR

37: , p_travel_internationally IN VARCHAR DEFAULT 'N'
38: -- , p_ad_hoc_search IN VARCHAR DEFAULT 'N'
39: , p_minimum_availability IN NUMBER := FND_API.G_MISS_NUM
40: , p_restrict_res_comp IN VARCHAR := FND_API.G_MISS_CHAR
41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR
42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR

Line 42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR

38: -- , p_ad_hoc_search IN VARCHAR DEFAULT 'N'
39: , p_minimum_availability IN NUMBER := FND_API.G_MISS_NUM
40: , p_restrict_res_comp IN VARCHAR := FND_API.G_MISS_CHAR
41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR
42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM

Line 43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR

39: , p_minimum_availability IN NUMBER := FND_API.G_MISS_NUM
40: , p_restrict_res_comp IN VARCHAR := FND_API.G_MISS_CHAR
41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR
42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM

Line 44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM

40: , p_restrict_res_comp IN VARCHAR := FND_API.G_MISS_CHAR
41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR
42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM
48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM

Line 45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR

41: , p_exclude_candidates IN VARCHAR := FND_API.G_MISS_CHAR
42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM
48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM
49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE

Line 46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM

42: , p_staffing_priority_code IN VARCHAR := FND_API.G_MISS_CHAR
43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM
48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM
49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE
50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

Line 47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM

43: , p_staffing_priority_name IN VARCHAR := FND_API.G_MISS_CHAR
44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM
48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM
49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE
50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
51: , p_api_version IN NUMBER := 1.0

Line 48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM

44: , p_staffing_owner_person_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM
48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM
49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE
50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
51: , p_api_version IN NUMBER := 1.0
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE

45: , p_staffing_owner_name IN VARCHAR := FND_API.G_MISS_CHAR
46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM
48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM
49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE
50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
51: , p_api_version IN NUMBER := 1.0
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

46: , p_comp_match_weighting IN NUMBER := FND_API.G_MISS_NUM
47: , p_avail_match_weighting IN NUMBER := FND_API.G_MISS_NUM
48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM
49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE
50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
51: , p_api_version IN NUMBER := 1.0
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_commit IN VARCHAR2 := FND_API.G_FALSE
54: , p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

48: , p_job_level_match_weighting IN NUMBER := FND_API.G_MISS_NUM
49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE
50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
51: , p_api_version IN NUMBER := 1.0
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_commit IN VARCHAR2 := FND_API.G_FALSE
54: , p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
55: , p_person_type IN VARCHAR2 := FND_API.G_MISS_CHAR -- Added for Bug 6526674
56: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 53: , p_commit IN VARCHAR2 := FND_API.G_FALSE

49: , p_get_search_criteria IN VARCHAR2 := FND_API.G_FALSE
50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
51: , p_api_version IN NUMBER := 1.0
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_commit IN VARCHAR2 := FND_API.G_FALSE
54: , p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
55: , p_person_type IN VARCHAR2 := FND_API.G_MISS_CHAR -- Added for Bug 6526674
56: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 54: , p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

50: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
51: , p_api_version IN NUMBER := 1.0
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_commit IN VARCHAR2 := FND_API.G_FALSE
54: , p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
55: , p_person_type IN VARCHAR2 := FND_API.G_MISS_CHAR -- Added for Bug 6526674
56: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
58: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 55: , p_person_type IN VARCHAR2 := FND_API.G_MISS_CHAR -- Added for Bug 6526674

51: , p_api_version IN NUMBER := 1.0
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_commit IN VARCHAR2 := FND_API.G_FALSE
54: , p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
55: , p_person_type IN VARCHAR2 := FND_API.G_MISS_CHAR -- Added for Bug 6526674
56: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
58: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: );