[Home] [Help]
PACKAGE: APPS.PA_PROJECTS_MAINT_PVT
Source
4 -- Type : Private
1 PACKAGE PA_PROJECTS_MAINT_PVT AUTHID CURRENT_USER AS
2 /* $Header: PARMPRVS.pls 120.1 2005/08/19 16:57:21 mwasowic noship $ */
3 -- API name : create_project
5 -- Pre-reqs : None.
6 -- Parameters :
7 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
8 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
9 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
10 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
11 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
12 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
13 -- p_orig_project_id IN NUMBER Required
14 -- p_project_name IN VARCHAR2 Required
15 -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
16 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
17 -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
18 -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
19 -- p_distribution_rule IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
20 -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
21 -- p_carrying_out_organization_id IN NUMBER Optional
22 -- Default = FND_API.G_MISS_NUM
23 -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
24 -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
25 -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
26 -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
27 -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
28 -- p_team_template_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
29 -- p_country_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
30 -- p_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31 -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32 -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
33 -- p_agreement_currency IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
34 -- p_agreement_amount IN NUMBER Optional Default = FND_API.G_MISS_NUM
35 -- p_agreement_org_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
36 -- p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR \
37 -- p_bill_to_customer_id IN NUMBER Optional Default = NULL
38 -- p_ship_to_customer_id IN NUMBER Optional Default = NULL
39 -- p_long_name IN VARCHAR2 Optional Default = NULL
40 -- p_project_id OUT NUMBER Required
41 -- p_new_project_number OUT VARCHAR2 Required
42 -- x_return_status OUT VARCHAR2 Required
43 -- x_msg_count OUT NUMBER Required
44 -- x_msg_data OUT VARCHAR2 Required
45 --
46 -- History
47 --
48 -- 18-AUG-2000 -- Sakthi/William - Created.
49 --
50 --
51 PROCEDURE CREATE_PROJECT
52 ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
56 p_debug_mode IN VARCHAR2 := 'N' ,
57 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
58 p_orig_project_id IN NUMBER ,
59 p_project_name IN VARCHAR2 ,
60 p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
61 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
62 p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
63 p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
64 p_distribution_rule IN VARCHAR2 := FND_API.G_MISS_CHAR ,
65 p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
66 p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
67 p_start_date IN DATE := FND_API.G_MISS_DATE ,
68 p_completion_date IN DATE := FND_API.G_MISS_DATE ,
69 p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
70 p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
71 p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
72 p_team_template_id IN NUMBER := FND_API.G_MISS_NUM ,
73 p_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
74 p_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
75 p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
76 p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
77 p_agreement_currency IN VARCHAR2 := FND_API.G_MISS_CHAR ,
78 p_agreement_amount IN NUMBER := FND_API.G_MISS_NUM ,
79 p_agreement_org_id IN NUMBER := FND_API.G_MISS_NUM ,
80 p_opp_value_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
81 p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
82 p_template_flag IN VARCHAR2 := 'N',
83 p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
84 -- Customer Account Relationship
85 p_bill_to_customer_id IN NUMBER := NULL ,
89 -- Project Long Name changes
86 p_ship_to_customer_id IN NUMBER := NULL ,
87 --Customer Account Relationship
88 -- anlee
90 p_long_name IN VARCHAR2 DEFAULT NULL ,
91 -- end of changes
92 p_project_id OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
93 p_new_project_number OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
94 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
95 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
96 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
97
98 --G_PROJECT_NUMBER_GEN_MODE VARCHAR2(30) := PA_PROJECT_UTILS.GetProjNumMode;
99 --G_PROJECT_NUMBER_TYPE VARCHAR2(30) := PA_PROJECT_UTILS.GetProjNumType;
100
101 -- API name : create_customer
102 -- Type : Public
103 -- Pre-reqs : None.
104 -- Parameters :
105 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
107 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
109 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
110 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
111 -- p_project_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
112 -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
113 -- p_relationship_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
114 -- x_return_status OUT VARCHAR2 REQUIRED
115 -- x_msg_count OUT NUMBER REQUIRED
116 -- x_msg_data OUT VARCHAR2 REQUIRED
117 --
118 -- History
119 --
120 -- 18-AUG-2000 -- Sakthi/William - Created.
121 --
122 --
123 PROCEDURE CREATE_CUSTOMER
124 ( p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
128 p_debug_mode IN VARCHAR2 := 'N' ,
129 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
130 p_project_id IN NUMBER := FND_API.G_MISS_NUM ,
131 p_customer_id IN NUMBER := FND_API.G_MISS_NUM ,
132 p_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
133 --Customer Account Relationships
134 p_bill_to_customer_id IN NUMBER := NULL ,
135 p_ship_to_customer_id IN NUMBER := NULL ,
136 --Customer Account Relationships
137 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
138 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
139 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
140
141 -- API name : Update_project_basic_info
142 -- Type : Public
143 -- Pre-reqs : None.
144 -- Parameters :
145 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
147 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
149 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
150 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
151 -- p_project_id IN NUMBER Required
152 -- p_project_name IN VARCHAR2 Required
153 -- p_project_number IN VARCHAR2 Required
154 -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
155 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
156 -- p_project_status_code IN VARCHAR2 Required
157 -- p_public_sector_flag IN VARCHAR2 Required
158 -- p_carrying_out_organization_id IN NUMBER Optional
159 -- Default = FND_API.G_MISS_NUM
160 -- p_start_date IN DATE Required
161 -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
162 -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
163 -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
164 -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
165 -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
166 -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
167 -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
168 -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
169 -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
170 -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
171 -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
172 -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
173 -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
174 -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
175 -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
176 -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
177 -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
178 -- p_record_version_number IN NUMBER Required
179 -- p_recalculate_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
180 -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
184 -- x_return_status OUT VARCHAR2 Required
181 -- p_target_finish_dateIN DATE Optional Default = FND_API.G_MISS_DATE
182 -- p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
183 -- p_long_name IN VARCHAR2 Optional Default = NULL
185 -- x_msg_count OUT NUMBER Required
186 -- x_msg_data OUT VARCHAR2 Required
187 --
188 -- History
189 --
190 -- 18-AUG-2000 -- Sakthi/William - Created.
191 --
192 --
193 PROCEDURE UPDATE_PROJECT_BASIC_INFO
194 (
195 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
196 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
199 p_debug_mode IN VARCHAR2 := 'N' ,
200 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
201 p_project_id IN NUMBER ,
202 p_project_name IN VARCHAR2 ,
203 p_project_number IN VARCHAR2 ,
204 p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
205 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
206 p_project_status_code IN VARCHAR2 ,
207 p_public_sector_flag IN VARCHAR2 ,
208 p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
209 p_start_date IN DATE ,
210 p_completion_date IN DATE := FND_API.G_MISS_DATE ,
211 p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
212 p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
213 p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
214 p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
215 p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
216 p_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
217 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
218 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
219 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
220 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
221 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
222 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
223 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
224 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
225 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
226 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
227 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
228 p_record_version_number IN NUMBER ,
229 p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
230 p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
231 p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
232 p_security_level IN NUMBER := FND_API.G_MISS_NUM ,
233 -- anlee
234 -- Project Long Name changes
235 p_long_name IN VARCHAR2 DEFAULT NULL ,
236 -- end of changes
237 p_funding_approval_status IN VARCHAR2 DEFAULT NULL , -- added for 4055319
238 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
239 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
240 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
241
242 -- API name : Update_project_additional_info
243 -- Type : Public
244 -- Pre-reqs : None.
245 -- Parameters :
246 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
247 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
248 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
250 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
251 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
252 -- p_project_id IN NUMBER Required
253 -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
254 -- p_work_type_id IN NUMBER
255 -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
256 -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
257 -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
258 -- p_record_version_number IN NUMBER Required
259 -- p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
260 -- p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
261 -- x_return_status OUT VARCHAR2 Required
262 -- x_msg_count OUT NUMBER Required
263 -- x_msg_data OUT VARCHAR2 Required
264 --
265 -- History
266 --
267 -- 18-AUG-2000 -- Sakthi/William - Created.
268 --
269 --
270 PROCEDURE UPDATE_PROJECT_ADDITIONAL_INFO
271 (
272 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
273 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
274 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
275 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
276 p_debug_mode IN VARCHAR2 := 'N' ,
277 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
281 p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
278 p_project_id IN NUMBER ,
279 p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
280 p_work_type_id IN NUMBER ,
282 p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
283 p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
284 p_split_cost_from_wokplan_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
285 p_split_cost_from_bill_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
286 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
287 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
288 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
289 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
290 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
291 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
292 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
293 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
294 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
295 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
296 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
297 p_record_version_number IN NUMBER ,
298 p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
299 p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
300 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
301 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
302 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
303
304 -- API name : Update_project_pipeline_info
305 -- Type : Public
306 -- Pre-reqs : None.
307 -- Parameters :
308 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
310 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
311 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
312 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
313 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
314 -- p_project_id IN NUMBER Required
315 -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
316 -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
317 -- p_expected_approval_date IN DATE Required
318 -- p_record_version_number IN NUMBER Required
319 -- x_return_status OUT VARCHAR2 Required
320 -- x_msg_count OUT NUMBER Required
321 -- x_msg_data OUT VARCHAR2 Required
322 --
323 -- History
324 --
325 -- 18-AUG-2000 -- Sakthi/William - Created.
326 --
327 --
328 PROCEDURE UPDATE_PROJECT_PIPELINE_INFO
329 (
330 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
331 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
332 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
334 p_debug_mode IN VARCHAR2 := 'N' ,
335 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
336 p_project_id IN NUMBER ,
337 p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
338 p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
339 p_expected_approval_date IN DATE ,
340 p_record_version_number IN NUMBER ,
341 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
342 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
343 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
344
345 -- API name : Create_classifications
346 -- Type : Public
347 -- Pre-reqs : None.
348 -- Parameters :
349 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
350 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
351 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
352 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
353 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
354 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
355 -- p_object_id IN NUMBER
356 -- p_object_type IN VARCHAR2
357 -- p_class_category IN VARCHAR2 Required
358 -- p_class_code IN VARCHAR2 Required
359 -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
360 -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
361 -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
362 -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
363 -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
364 -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
365 -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
366 -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
367 -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
368 -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
369 -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
373 -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
370 -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
371 -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
372 -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
374 -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
375 -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
376 -- x_return_status OUT VARCHAR2 Required
377 -- x_msg_count OUT NUMBER Required
378 -- x_msg_data OUT VARCHAR2 Required
379 --
380 -- History
381 --
382 -- 18-AUG-2000 -- Sakthi/William - Created.
383 --
384 --
385 PROCEDURE CREATE_CLASSIFICATIONS
386 (
387 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
388 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
389 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
391 p_debug_mode IN VARCHAR2 := 'N',
392 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
393 p_object_id IN NUMBER,
394 p_object_type IN VARCHAR2,
395 p_class_category IN VARCHAR2 ,
396 p_class_code IN VARCHAR2 ,
397 p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
398 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
399 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
400 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
401 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
402 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
403 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
404 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
405 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
406 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
407 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
408 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
409 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
410 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
411 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
412 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
413 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
414 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
415 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
416 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
417
418
419 -- API name : Update_Classifications
420 -- Type : Public
421 -- Pre-reqs : None.
422 -- Parameters :
423 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
424 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
425 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
426 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
427 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
428 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
429 -- p_object_id IN NUMBER
430 -- p_object_type IN VARCHAR2
431 -- p_class_category IN VARCHAR2 Required
432 -- p_class_code IN VARCHAR2 Required
433 -- p_code_percentage IN NUMBER Optional Default = FND_API.G_MISS_NUM
434 -- p_attribute_category IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
435 -- p_attribute1 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
436 -- p_attribute2 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
437 -- p_attribute3 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
438 -- p_attribute4 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
439 -- p_attribute5 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
440 -- p_attribute6 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
441 -- p_attribute7 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
442 -- p_attribute8 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
443 -- p_attribute9 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
444 -- p_attribute10 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
445 -- p_attribute11 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
446 -- p_attribute12 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
447 -- p_attribute13 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
448 -- p_attribute14 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
449 -- p_attribute15 IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
450 -- p_rowid IN VARCHAR2 Required
451 -- p_record_version_number IN NUMBER Required
452 -- x_return_status OUT VARCHAR2 Required
453 -- x_msg_count OUT NUMBER Required
454 -- x_msg_data OUT VARCHAR2 Required
455 --
456 -- History
457 --
458 -- 12-OCT-2001 -- anlee created.
459 --
460 --
461 PROCEDURE UPDATE_CLASSIFICATIONS
462 (
463 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
464 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
465 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
466 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
470 p_object_type IN VARCHAR2,
467 p_debug_mode IN VARCHAR2 := 'N',
468 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
469 p_object_id IN NUMBER,
471 p_class_category IN VARCHAR2 ,
472 p_class_code IN VARCHAR2 ,
473 p_code_percentage IN NUMBER := FND_API.G_MISS_NUM ,
474 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR ,
475 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
476 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
477 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
478 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
479 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
480 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
481 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
482 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
483 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
484 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
485 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
486 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
487 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
488 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
489 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR ,
490 p_rowid IN VARCHAR2 ,
491 p_record_version_number IN NUMBER ,
492 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
493 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
494 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
495
496
497 -- API name : delete_classifications
498 -- Type : Public
499 -- Pre-reqs : None.
500 -- Parameters :
501 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
502 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
503 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
504 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
505 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
506 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
507 -- p_object_id IN NUMBER Required
508 -- p_object_type IN VARCHAR2 Required
509 -- p_class_category IN VARCHAR2 Required
510 -- p_class_code IN VARCHAR2 Required
511 -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
512 -- x_return_status OUT VARCHAR2 Required
513 -- x_msg_count OUT NUMBER Required
514 -- x_msg_data OUT VARCHAR2 Required
515 --
516 -- History
517 --
518 -- 18-AUG-2000 -- Sakthi/William - Created.
519 --
520 --
521 PROCEDURE DELETE_CLASSIFICATIONS
522 (
523 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
524 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
525 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
527 p_debug_mode IN VARCHAR2 := 'N',
528 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
529 p_object_id IN NUMBER ,
530 p_object_type IN VARCHAR2 ,
531 p_class_category IN VARCHAR2 ,
532 p_class_code IN VARCHAR2 ,
533 p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
534 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
535 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
536 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
537
538 /*
539 -- API name : Validate_Basic_Info
540 -- Type : Validation
541 -- Pre-reqs : None.
542 -- Parameters :
543 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
544 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
545 -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
546 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
547 -- p_project_id IN NUMBER Required
548 -- p_project_name IN VARCHAR2 Required
549 -- p_project_number IN VARCHAR2 Required
550 -- p_project_type IN VARCHAR2 Required
551 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
552 -- p_project_status_code IN VARCHAR2 Required
553 -- p_public_sector_flag IN VARCHAR2 Required
554 -- p_carrying_out_organization_id IN NUMBER Required
558 -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
555 -- p_start_date IN DATE Required
556 -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
557 -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
559 -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
560 -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
561 -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
562 -- p_record_version_number IN NUMBER Required
563 --
564 -- History
565 --
566 -- 18-AUG-2000 -- Sakthi/William - Created.
567 --
568 --
569 PROCEDURE Validate_Basic_Info
570 (
571 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572 p_debug_mode IN VARCHAR2 := 'N',
573 p_action IN VARCHAR2 := 'UPDATE',
574 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM,
575 p_project_id IN NUMBER,
576 p_project_name IN VARCHAR2,
577 p_project_number IN VARCHAR2,
578 p_project_type IN VARCHAR2,
579 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
580 p_project_status_code IN VARCHAR2 ,
581 p_public_sector_flag IN VARCHAR2 ,
582 p_carrying_out_organization_id IN NUMBER ,
583 p_start_date IN DATE ,
584 p_completion_date IN DATE := FND_API.G_MISS_DATE ,
585 p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
586 p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
587 p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
588 p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
589 p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
590 p_record_version_number IN NUMBER);
591
592 -- API name : Validate_additional_info
593 -- Type : Validation
594 -- Pre-reqs : None.
595 -- Parameters :
596 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
597 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
598 -- p_action IN VARCHAR2 Required
599 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
600 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
601 -- p_project_id IN NUMBER Required
602 -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
603 -- p_work_type_id IN NUMBER
604 -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
605 -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
606 -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
607 -- p_record_version_number IN NUMBER Required
608 --
609 -- History
610 --
611 -- 18-AUG-2000 -- Sakthi/William - Created.
612 --
613 --
614 PROCEDURE VALIDATE_ADDITIONAL_INFO
615 (
616 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
617 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
618 p_action IN VARCHAR2 ,
619 p_debug_mode IN VARCHAR2 := 'N',
620 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
621 p_project_id IN NUMBER ,
622 p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
623 p_work_type_id IN NUMBER ,
624 p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
625 p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
626 p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
627 p_record_version_number IN NUMBER );
628
629 -- API name : Validate_pipeline_info
630 -- Type : Validation
631 -- Pre-reqs : None.
632 -- Parameters :
633 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
634 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
635 -- p_action IN VARCHAR2 Required
636 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
637 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
638 -- p_project_id IN NUMBER Required
639 -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
640 -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
641 -- p_expected_approval_date IN DATE Required
642 -- p_record_version_number IN NUMBER Required
643 --
644 -- History
645 --
646 -- 18-AUG-2000 -- Sakthi/William - Created.
647 --
648 --
649 PROCEDURE VALIDATE_PIPELINE_INFO
650 ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
652 p_action IN VARCHAR2 ,
653 p_debug_mode IN VARCHAR2 := 'N',
654 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
658 p_expected_approval_date IN DATE ,
655 p_project_id IN NUMBER ,
656 p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
657 p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
659 p_record_version_number IN NUMBER );
660 */
661
662 -- API name : validate_classifications
663 -- Type : Validation
664 -- Pre-reqs : None.
665 -- Parameters :
666 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
667 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
668 -- p_action IN VARCHAR2 Optional Default = 'INSERT'
669 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
670 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
671 -- p_object_id IN NUMBER Required
672 -- p_object_type IN VARCHAR2 Required
673 -- p_class_category IN VARCHAR2 Required
674 -- p_class_code IN VARCHAR2 Required
675 -- p_code_percentage IN OUT VARCHAR2 Required
676 --
677 -- History
678 --
679 -- 18-AUG-2000 -- Sakthi/William - Created.
680 --
681 --
682 PROCEDURE VALIDATE_CLASSIFICATIONS
683 (
684 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
685 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
686 p_action IN VARCHAR2 := 'INSERT' ,
687 p_debug_mode IN VARCHAR2 := 'N',
689 p_object_id IN NUMBER ,
690 p_object_type IN VARCHAR2 ,
691 p_class_category IN VARCHAR2 ,
692 p_class_code IN VARCHAR2,
693 p_code_percentage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
694 p_rowid IN VARCHAR2 := FND_API.G_MISS_CHAR);
695
696
697 -- API name : Validate_Project_Info
698 -- Type : Validation
699 -- Pre-reqs : None.
700 -- Parameters :
701 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
702 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
703 -- p_action IN VARCHAR2 Optional Default = 'INSERT', 'UPDATE', 'DELETE'
704 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
705 -- p_project_id IN NUMBER Required
706 -- p_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
707 -- p_project_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
708 -- p_project_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
709 -- p_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
710 -- p_project_status_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
711 -- p_public_sector_flag IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
712 -- p_carrying_out_organization_id IN NUMBER Optional
713 -- Default = FND_API.G_MISS_NUM
714 -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
715 -- p_completion_date IN DATE Optional Default = FND_API.G_MISS_DATE
716 -- p_territory_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
717 -- p_country IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
718 -- p_location_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
719 -- p_state_region IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
720 -- p_city IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
721 -- p_calendar_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
722 -- p_work_type_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
723 -- p_role_list_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
724 -- p_cost_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
725 -- p_bill_job_group_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
726 -- p_probability_member_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
727 -- p_project_value IN NUMBER Optional Default = FND_API.G_MISS_NUM
728 -- p_expected_approval_date IN DATE Optional Default = FND_API.G_MISS_DATE
729 -- p_record_version_number IN NUMBER Required
730 -- p_target_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
731 -- p_target_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
732 -- p_long_name IN VARCHAR2 Optional Default = NULL
733 --
734 -- History
735 --
736 -- 18-AUG-2000 -- Sakthi/William - Created.
737 --
738 --
739 PROCEDURE Validate_Project_Info
740 (
741 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
746 p_project_id IN NUMBER ,
743 p_action IN VARCHAR2 := 'UPDATE' ,
744 p_debug_mode IN VARCHAR2 := 'N' ,
745 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
747 p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
748 p_project_number IN VARCHAR2 := FND_API.G_MISS_CHAR ,
749 p_project_type IN VARCHAR2 := FND_API.G_MISS_CHAR ,
750 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR ,
751 p_project_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
752 p_public_sector_flag IN VARCHAR2 := FND_API.G_MISS_CHAR ,
753 p_carrying_out_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
754 p_start_date IN DATE := FND_API.G_MISS_DATE ,
755 p_completion_date IN DATE := FND_API.G_MISS_DATE ,
756 p_territory_code IN VARCHAR2 := FND_API.G_MISS_CHAR ,
757 p_country IN VARCHAR2 := FND_API.G_MISS_CHAR ,
758 p_location_id IN NUMBER := FND_API.G_MISS_NUM ,
759 p_state_region IN VARCHAR2 := FND_API.G_MISS_CHAR ,
760 p_city IN VARCHAR2 := FND_API.G_MISS_CHAR ,
761 p_calendar_id IN NUMBER := FND_API.G_MISS_NUM ,
762 p_work_type_id IN NUMBER := FND_API.G_MISS_NUM ,
763 p_role_list_id IN NUMBER := FND_API.G_MISS_NUM ,
764 p_cost_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
765 p_bill_job_group_id IN NUMBER := FND_API.G_MISS_NUM ,
766 p_probability_member_id IN NUMBER := FND_API.G_MISS_NUM ,
767 p_project_value IN NUMBER := FND_API.G_MISS_NUM ,
768 p_expected_approval_date IN DATE := FND_API.G_MISS_DATE ,
769 p_record_version_number IN NUMBER ,
770 p_target_start_date IN DATE := FND_API.G_MISS_DATE ,
771 p_target_finish_date IN DATE := FND_API.G_MISS_DATE ,
772 -- anlee
773 -- Project Long Name changes
774 p_long_name IN VARCHAR2 DEFAULT NULL
775 -- end of changes
776 );
777
778
779 -- API name : Update_project_staffing_info
780 -- Type : Public
781 -- Pre-reqs : None.
782 -- Parameters :
783 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
784 -- p_validate_only IN VARCHAR2 Optional Default = FND_API.G_TRUE
785 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
786 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
787 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
788 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
789 -- p_project_id IN NUMBER Required
790 -- p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE Optional Default = FND_API.G_MISS_NUM
791 -- p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
792 -- p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE Optional Default = FND_API.G_MISS_NUM
796 -- p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE Optional Default = FND_API.G_MISS_NUM
793 -- p_search_min_availability IN pa_projects_all.search_min_availability%TYPE Optional Default = FND_API.G_MISS_NUM
794 -- p_search_country_code IN pa_projects_all.search_country_code%TYPE Optional Default = FND_API.G_MISS_CHAR
795 -- p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE Optional Default = FND_API.G_MISS_CHAR,
797 -- p_search_exp_org_hier_name IN per_organization_structures.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
798 -- p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE Optional Default = FND_API.G_MISS_NUM
799 -- p_search_exp_start_org_name IN hr_organization_units.name%TYPE Optional Default = FND_API.G_MISS_CHAR,
800 -- p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE Optional Default = FND_API.G_MISS_NUM
801 -- p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE Optional Default = FND_API.G_MISS_CHAR
802 -- p_record_version_number IN NUMBER Required
803 -- x_return_status OUT VARCHAR2 Required
804 -- x_msg_count OUT NUMBER Required
805 -- x_msg_data OUT VARCHAR2 Required
806 --
807 -- History
808 --
809 -- 28-SEP-2000 -- hyau - Created.
810 --
811 --
812 PROCEDURE UPDATE_PROJECT_STAFFING_INFO
813 (
814 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
815 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
819 p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM ,
816 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
817 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
818 p_debug_mode IN VARCHAR2 := 'N' ,
820 p_project_id IN NUMBER ,
821 p_comp_match_weighting IN pa_projects_all.COMPETENCE_MATCH_WT%TYPE := FND_API.G_MISS_NUM,
822 p_avail_match_weighting IN pa_projects_all.availability_match_wt%TYPE := FND_API.G_MISS_NUM,
823 p_job_level_match_weighting IN pa_projects_all.job_level_match_wt%TYPE := FND_API.G_MISS_NUM,
824 p_search_min_availability IN pa_projects_all.search_min_availability%TYPE := FND_API.G_MISS_NUM,
825 p_search_country_code IN pa_projects_all.search_country_code%TYPE := FND_API.G_MISS_CHAR,
826 p_search_exp_org_struct_ver_id IN pa_projects_all.search_org_hier_id%TYPE := FND_API.G_MISS_NUM,
827 p_search_exp_start_org_id IN pa_projects_all.search_starting_org_id%TYPE := FND_API.G_MISS_NUM,
828 p_search_min_candidate_score IN pa_projects_all.min_cand_score_reqd_for_nom%TYPE := FND_API.G_MISS_NUM,
829 p_enable_auto_cand_nom_flag IN pa_projects_all.enable_automated_search%TYPE := FND_API.G_MISS_CHAR,
830 p_record_version_number IN NUMBER ,
831 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
832 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
833 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
834
835
836 END PA_PROJECTS_MAINT_PVT;