[Home] [Help]
PACKAGE: APPS.PA_SEARCH_PUB
Source
1 PACKAGE PA_SEARCH_PUB AS
2 --$Header: PARISPBS.pls 120.3 2007/10/29 12:14:15 anuragar ship $
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
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
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
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'
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
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
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 );
60
61 END PA_SEARCH_PUB;