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