[Home] [Help]
PACKAGE: APPS.PA_SEARCH_GLOB
Source
1 PACKAGE PA_SEARCH_GLOB AUTHID CURRENT_USER AS
2 --$Header: PARIGLBS.pls 120.3 2007/10/29 12:12:50 anuragar ship $
3 --
4
5
6 G_ERROR_EXISTS VARCHAR2(1) := FND_API.G_FALSE;
7
8 TYPE resource_weekly_avail_rec_type IS
9 RECORD ( resource_id NUMBER DEFAULT FND_API.G_MISS_NUM
10 , week_start_date DATE DEFAULT FND_API.G_MISS_DATE
11 , week_end_date DATE DEFAULT FND_API.G_MISS_DATE
12 , number_of_hours NUMBER DEFAULT FND_API.G_MISS_NUM
13 , number_of_days NUMBER DEFAULT FND_API.G_MISS_NUM
14 , avg_num_of_hours NUMBER DEFAULT FND_API.G_MISS_NUM
15 );
16
17 TYPE resource_weekly_avail_tbl_type IS TABLE OF resource_weekly_avail_rec_type
18 INDEX BY BINARY_INTEGER;
19
20
21 TYPE asgn_weekly_schedule_rec_type IS
22 RECORD ( assignment_id NUMBER DEFAULT FND_API.G_MISS_NUM
23 , week_start_date DATE DEFAULT FND_API.G_MISS_DATE
24 , week_end_date DATE DEFAULT FND_API.G_MISS_DATE
25 , number_of_hours NUMBER DEFAULT FND_API.G_MISS_NUM
26 , number_of_days NUMBER DEFAULT FND_API.G_MISS_NUM
27 , avg_num_of_hours NUMBER DEFAULT FND_API.G_MISS_NUM
28 );
29
30 TYPE asgn_weekly_schedule_tbl_type IS TABLE OF asgn_weekly_schedule_rec_type
31 INDEX BY BINARY_INTEGER;
32
33 TYPE Search_Criteria_Rec_Type IS
34 RECORD ( assignment_id NUMBER DEFAULT NULL
35 , resource_source_id NUMBER DEFAULT NULL
36 , project_id NUMBER DEFAULT NULL
37 , role_id NUMBER DEFAULT NULL
38 , min_job_level NUMBER DEFAULT NULL
39 , max_job_level NUMBER DEFAULT NULL
40 , org_hierarchy_version_id NUMBER DEFAULT NULL
41 , organization_id NUMBER DEFAULT NULL
42 , employees_only VARCHAR2(1) DEFAULT NULL
43 , territory_code fnd_territories_vl.territory_code%TYPE DEFAULT NULL
44 , region VARCHAR2(240) DEFAULT NULL
45 , city VARCHAR2(80) DEFAULT NULL
46 , start_date DATE DEFAULT NULL
47 , end_date DATE DEFAULT NULL
48 , restrict_res_comp VARCHAR2(1) DEFAULT 'Y'
49 , exclude_candidates VARCHAR2(1) DEFAULT 'Y'
50 , staffing_priority_code VARCHAR2(30) DEFAULT NULL
51 , staffing_owner_person_id NUMBER DEFAULT NULL
52 , min_availability NUMBER DEFAULT 100
53 , provisional_availability VARCHAR2(1) DEFAULT 'N'
54 , competence_match_weighting NUMBER DEFAULT NULL
55 , availability_match_weighting NUMBER DEFAULT NULL
56 , job_level_match_weighting NUMBER DEFAULT NULL
57 , work_current_loc VARCHAR2(1) DEFAULT NULL
58 , work_all_loc VARCHAR2(1) DEFAULT NULL
59 , travel_domestically VARCHAR2(1) DEFAULT NULL
60 , travel_internationally VARCHAR2(1) DEFAULT NULL
61 , person_type VARCHAR2(80) DEFAULT NULL
62 );
63
64
65 TYPE Competence_Criteria_Rec_Type IS
66 RECORD ( competence_id NUMBER DEFAULT FND_API.G_MISS_NUM
67 ,competence_name per_competences.name%TYPE DEFAULT FND_API.G_MISS_CHAR
68 , competence_alias per_competences.competence_alias%TYPE DEFAULT FND_API.G_MISS_CHAR
69 , rating_level NUMBER DEFAULT FND_API.G_MISS_NUM
70 , mandatory_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71 );
72
73 TYPE Competence_Criteria_Tbl_Type IS TABLE OF Competence_Criteria_Rec_Type INDEX BY BINARY_INTEGER;
74
75 G_FIRST VARCHAR2(1) := 'F';
76 G_LAST VARCHAR2(1) := 'L';
77 G_OTHER VARCHAR2(1) := 'O';
78
79 g_search_criteria Search_Criteria_Rec_Type;
80 g_competence_criteria Competence_Criteria_Tbl_Type;
81
82 TYPE Competence_Id_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
83
84 TYPE Competence_Name_Array IS TABLE OF per_competences.name%TYPE INDEX BY BINARY_INTEGER;
85
86 TYPE Competence_Alias_Array IS TABLE OF per_competences.competence_alias%TYPE INDEX BY BINARY_INTEGER;
87
88 TYPE Competence_Rating_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
89
90 TYPE Competence_Mandatory_Array IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
91
92 PROCEDURE Check_Competence_Match(p_search_mode IN VARCHAR2,
93 p_person_id IN per_all_people_f.person_id%TYPE,
94 p_requirement_id IN pa_project_assignments.assignment_id%TYPE,
95 -- p_resource_competences IN PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type,
96 -- p_requirement_competences IN PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type,
97 x_mandatory_match OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
98 x_mandatory_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99 x_optional_match OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
100 x_optional_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
101
102 FUNCTION Check_Availability ( p_resource_id IN NUMBER,
103 p_assignment_id IN NUMBER,
104 p_project_id IN NUMBER
105 ) RETURN NUMBER;
106
107 FUNCTION get_min_prof_level(l_competence_id IN NUMBER)
108 RETURN NUMBER;
109
110 END PA_SEARCH_GLOB;