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
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
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
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: );
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:
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
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;
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
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
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: );
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:
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
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;
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
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: );
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:
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;
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: