1 package PA_PROJECT_PARTIES_UTILS AUTHID CURRENT_USER as
2 /* $Header: PARPPU2S.pls 120.1 2005/08/19 16:58:36 mwasowic noship $ */
3
4 --
5 -- Global Variables.
6 --
7 G_PROJECT_MANAGER_ID NUMBER;
8
9 Function VALIDATE_DELETE_PARTY_OK( p_project_id IN NUMBER,
10 p_project_party_id IN NUMBER) return varchar2;
11
12 FUNCTION ACTIVE_PARTY ( p_start_date_active IN DATE,
13 p_end_date_active IN DATE) return varchar2;
14
15 PROCEDURE GET_PROJECT_DATES (p_project_id IN NUMBER,
16 x_project_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
17 x_project_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
18 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
19
20 PROCEDURE VALIDATE_PROJECT_PARTY( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21 p_debug_mode IN VARCHAR2 default 'N',
22 p_object_id IN NUMBER,
23 p_OBJECT_TYPE IN VARCHAR2,
24 p_project_role_id IN NUMBER,
25 p_resource_type_id IN NUMBER default 101,
26 p_resource_source_id IN NUMBER,
27 p_start_date_active IN DATE,
28 p_scheduled_flag IN VARCHAR2,
29 p_record_version_number IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30 p_calling_module IN VARCHAR2,
31 p_action IN VARCHAR2,
32 p_project_id IN NUMBER,
33 p_project_end_date IN DATE,
34 p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
35 p_project_party_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
36 x_call_overlap IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_assignment_action IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
38 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
39
40 Function GET_SCHEDULED_FLAG(p_project_party_id IN NUMBER,
41 p_record_version_number IN NUMBER) return varchar2;
42
43 Function VALIDATE_SCHEDULE_ALLOWED(p_project_role_id IN NUMBER) return varchar2;
44
45 Function GET_PROJECT_ROLE_ID(P_PROJECT_ROLE_TYPE IN VARCHAR2,
46 P_CALLING_MODULE IN VARCHAR2) return number;
47
48 Function GET_RESOURCE_SOURCE_ID(p_resource_name IN VARCHAR2) return number;
49
50 Procedure GET_PERSON_PARTY_ID( p_object_type IN VARCHAR2,
51 p_object_id IN NUMBER,
52 p_project_role_id IN NUMBER,
53 p_resource_type_id IN NUMBER default 101,
54 p_resource_source_id IN NUMBER,
55 p_start_date_active IN DATE,
56 p_end_date_active IN DATE,
57 x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
58 x_record_version_number OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
59
60 PROCEDURE CHECK_MANDATORY_FIELDS(p_project_Role_id IN NUMBER,
61 p_resource_type_id IN NUMBER default 101,
62 p_resource_source_id IN NUMBER,
63 p_start_date_active IN DATE,
64 p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
65 p_project_end_date IN DATE,
66 p_scheduled_flag IN VARCHAR2,
67 x_error_occured OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
68
69 PROCEDURE VALIDATE_DATES( p_start_date_active IN DATE,
70 p_end_date_active IN DATE,
71 x_error_occured OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
72
73 PROCEDURE VALIDATE_NO_OVERLAP_MANAGER( p_object_type IN VARCHAR2,
74 p_object_id IN NUMBER,
75 p_project_role_id IN NUMBER,
76 p_project_party_id IN NUMBER,
77 p_start_date_active IN DATE,
78 p_end_date_active IN DATE,
79 x_error_occured OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
80
81 PROCEDURE VALIDATE_PERSON_NOT_OVERLAPPED( p_object_type IN VARCHAR2,
82 p_object_id IN NUMBER,
83 p_project_role_id IN NUMBER,
84 p_project_party_id IN NUMBER,
85 p_resource_type_id IN NUMBER default 101,
86 p_resource_source_id IN NUMBER,
87 p_start_date_active IN DATE,
88 p_end_date_active IN DATE,
89 x_error_occured OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
90
91 FUNCTION ENABLE_EDIT_LINK(p_project_id IN NUMBER,
92 p_scheduled_flag IN VARCHAR2,
93 p_assignment_id IN NUMBER) return varchar2;
94
95 FUNCTION GET_GRANT_ID(p_project_party_id IN NUMBER) return raw;
96
97 PROCEDURE GET_CURR_PROJ_MGR_DETAILS(p_project_id in number,
98 x_manager_person_id out NOCOPY number, --File.Sql.39 bug 4440895
99 x_manager_name out NOCOPY varchar2, --File.Sql.39 bug 4440895
100 x_project_party_id out NOCOPY number, --File.Sql.39 bug 4440895
101 x_project_role_id out NOCOPY number, --File.Sql.39 bug 4440895
102 x_project_role_name out NOCOPY varchar2, --File.Sql.39 bug 4440895
103 x_return_status out NOCOPY varchar2, --File.Sql.39 bug 4440895
104 x_error_message_code out NOCOPY varchar2); --File.Sql.39 bug 4440895
105
106 FUNCTION get_customer_project_party_id (
107 p_project_id IN NUMBER,
108 p_customer_id IN NUMBER) RETURN NUMBER;
109
110 PROCEDURE VALIDATE_ROLE_PARTY( p_project_role_id IN NUMBER,
111 p_resource_type_id IN NUMBER DEFAULT 101,
112 p_resource_source_id IN NUMBER,
113 x_error_occured OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
114
115
116 -- API name : get_project_manager
117 -- Type : Public
118 -- Pre-reqs : None.
119 -- Parameters :
120 -- p_project_id IN NUMBER
121 -- Return : NUMBER
122 --
123 -- History
124 --
125 -- 26-Dec-2002 -- shyugen - Created
126 --
127 FUNCTION GET_PROJECT_MANAGER ( p_project_id IN NUMBER)
128 RETURN NUMBER;
129
130 -- API name : get_project_manager_name
131 -- Type : Public
132 -- Pre-reqs : None.
133 -- Parameters :
134 -- p_person_id IN NUMBER
135 -- Return : VARCHAR2
136 --
137 -- History
138 --
139 -- 26-Dec-2002 -- shyugen - Created
140 --
141 --
142 FUNCTION GET_PROJECT_MANAGER_NAME
143 RETURN VARCHAR2;
144
145 FUNCTION GET_PROJECT_MANAGER_NAME( p_project_id IN NUMBER)
146 RETURN VARCHAR2;
147
148 /* Added the following procedure for bug #2111806. */
149 PROCEDURE VALIDATE_MANAGER_DATE_RANGE( p_mode IN VARCHAR2,
150 p_project_id IN NUMBER,
151 x_start_no_mgr_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
152 x_end_no_mgr_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
153 x_error_occured OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
154
155 PROCEDURE VALIDATE_ONE_MANAGER_EXISTS( p_project_id IN NUMBER,
156 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
157 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
158 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
159 -- API name : get_current_project_manager
160 -- Type : Public
161 -- Pre-reqs : None.
162 -- Parameters :
163 -- p_project_id IN NUMBER
164 -- Return : NUMBER
165 -- Details: This function is created so as to return the project manager who is
166 -- active on the project as on the sysdate.
167 -- History
168 --
169 -- 23-May-2005 adarora - Created
170 --
171
172 FUNCTION GET_CURRENT_PROJECT_MANAGER ( p_project_id IN NUMBER)
173 RETURN NUMBER;
174
175 -- API name : GET_CURRENT_PROJ_MANAGER_NAME
176 -- Type : Public
177 -- Pre-reqs : None.
178 -- Parameters :
179 -- p_project_id IN NUMBER
180 -- Return : VARCHAR2
181 -- Details: This function is created so as to return the project manager name who is
182 -- active on the project as on the sysdate.
183 -- History
184 --
185 -- 23-May-2005 adarora - Created
186 --
187 FUNCTION GET_CURRENT_PROJ_MANAGER_NAME( p_project_id IN NUMBER)
188 RETURN VARCHAR2;
189
190
191 END PA_PROJECT_PARTIES_UTILS;