DBA Data[Home] [Help]

APPS.PA_SEARCH_GLOB dependencies on FND_API

Line 6: G_ERROR_EXISTS VARCHAR2(1) := FND_API.G_FALSE;

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

Line 9: RECORD ( resource_id NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 10: , week_start_date DATE DEFAULT FND_API.G_MISS_DATE

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

Line 11: , week_end_date DATE DEFAULT FND_API.G_MISS_DATE

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

Line 12: , number_of_hours NUMBER DEFAULT FND_API.G_MISS_NUM

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:

Line 13: , number_of_days NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 14: , avg_num_of_hours 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;

Line 22: RECORD ( assignment_id NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 23: , week_start_date DATE DEFAULT FND_API.G_MISS_DATE

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

Line 24: , week_end_date DATE DEFAULT FND_API.G_MISS_DATE

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

Line 25: , number_of_hours NUMBER DEFAULT FND_API.G_MISS_NUM

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:

Line 26: , number_of_days NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 27: , avg_num_of_hours 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;

Line 66: RECORD ( competence_id NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 67: ,competence_name per_competences.name%TYPE 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: );

Line 68: , competence_alias per_competences.competence_alias%TYPE DEFAULT FND_API.G_MISS_CHAR

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:

Line 69: , rating_level NUMBER DEFAULT FND_API.G_MISS_NUM

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;

Line 70: , mandatory_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR

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: