1 package PA_RELATIONSHIP_PUB as
2 /*$Header: PAXRELPS.pls 120.2 2005/08/19 17:18:57 mwasowic noship $*/
3
4 -- API name : Create_Relationship
5 -- Type : Public Procedure
6 -- Pre-reqs : None
7 -- Return Value : N/A
8 -- Parameters
9 -- p_api_version IN NUMBER := 1.0
10 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13 -- p_validation_level IN VARCHAR2 := 100
14 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15 -- p_debug_mode IN VARCHAR2 := 'N'
16 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17 -- p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18 -- p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19 -- p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20 -- p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21 -- p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22 -- p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23 -- p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24 -- p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25 -- p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26 -- p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27 -- p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28 -- p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29 -- p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
30 -- p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
31 -- p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32 -- p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33 -- p_structure_type IN VARCHAR2
34 -- p_initiating_element IN VARCHAR2
35 -- p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
36 -- p_relationship_type IN VARCHAR2
37 -- p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38 -- p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
39 -- p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40 -- x_object_relationship_id OUT NUMBER
41 -- x_return_status OUT VARCHAR2
42 -- x_msg_count OUT NUMBER
43 -- x_msg_data OUT VARCHAR2
44 --
45 -- History
46 --
47 -- 25-JUN-01 HSIU -Created
48 --
49 --
50
51
52 procedure Create_Relationship
53 (
54 p_api_version IN NUMBER := 1.0
55 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
58 ,p_validation_level IN VARCHAR2 := 100
59 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
60 ,p_debug_mode IN VARCHAR2 := 'N'
61 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
62 ,p_project_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
63 ,p_project_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64 ,p_structure_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
65 ,p_structure_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66 ,p_structure_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67 ,p_structure_version_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68 ,p_task_version_id_from IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
69 ,p_task_name_from IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70 ,p_project_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71 ,p_project_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72 ,p_structure_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73 ,p_structure_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74 ,p_structure_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
75 ,p_structure_version_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76 ,p_task_version_id_to IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77 ,p_task_name_to IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78 ,p_structure_type IN VARCHAR2
79 ,p_initiating_element IN VARCHAR2
80 ,p_link_to_latest_structure_ver IN VARCHAR2 := 'N'
81 ,p_relationship_type IN VARCHAR2
82 ,p_relationship_subtype IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
83 ,p_lag_day IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
84 ,p_priority IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85 ,p_weighting_percentage IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
86 ,x_object_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
87 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
88 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
89 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90 );
91
92
93 -- API name : Delete_Relationship
94 -- Type : Public Procedure
95 -- Pre-reqs : None
96 -- Return Value : N/A
97 -- Parameters
98 -- p_api_version IN NUMBER := 1.0
99 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
100 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
101 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
102 -- p_validation_level IN VARCHAR2 := 100
103 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
104 -- p_debug_mode IN VARCHAR2 := 'N'
105 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
106 -- p_object_relationship_id IN NUMBER
107 -- p_record_version_number IN NUMBER
108 -- x_return_status OUT VARCHAR2
109 -- x_msg_count OUT NUMBER
110 -- x_msg_data OUT VARCHAR2
111 --
112 -- History
113 --
114 -- 25-JUN-01 HSIU -Created
115 --
116 --
117
118
119 procedure Delete_Relationship
120 (
121 p_api_version IN NUMBER := 1.0
122 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
123 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
124 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
125 ,p_validation_level IN VARCHAR2 := 100
126 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
127 ,p_debug_mode IN VARCHAR2 := 'N'
128 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
129 ,p_object_relationship_id IN NUMBER
130 ,p_record_version_number IN NUMBER
131 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
133 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134 );
135
136 -- API name : Create_Dependency
137 -- Type : Public Procedure
138 -- Pre-reqs : None
139 -- Return Value : N/A
140 -- Parameters
141 -- p_api_version IN NUMBER := 1.0
142 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
143 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
144 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
145 -- p_validation_level IN VARCHAR2 := 100
146 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
147 -- p_debug_mode IN VARCHAR2 := 'N'
148 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
149 -- p_src_proj_id IN NUMBER := NULL
150 -- p_src_task_ver_id IN NUMBER := NULL
151 -- p_dest_proj_name IN VARCHAR2 := NULL
152 -- p_dest_proj_id IN NUMBER := NULL
153 -- P_dest_task_name IN VARCHAR2 := NULL
154 -- P_dest_task_id IN NUMBER := NULL
155 -- P_type IN VARCHAR2 := 'FS'
156 -- P_lag_days IN NUMBER := 0
157 -- p_comments IN VARCHAR2 := NULL
158 -- x_return_status OUT VARCHAR2
159 -- x_msg_count OUT NUMBER
160 -- x_msg_data OUT VARCHAR2
161 --
162 -- History
163 --
164 -- 10-dec-03 Maansari -Created
165 --
166 -- FPM bug 3301192
167 --
168
169
170 procedure Create_dependency
171 (
172 p_api_version IN NUMBER := 1.0
173 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
174 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
175 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
176 ,p_validation_level IN VARCHAR2 := 100
177 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
178 ,p_debug_mode IN VARCHAR2 := 'N'
179 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
180 ,p_src_proj_id IN NUMBER := NULL
181 ,p_src_task_ver_id IN NUMBER := NULL
182 ,p_dest_proj_name IN VARCHAR2 := NULL
183 ,p_dest_proj_id IN NUMBER := NULL
184 ,p_dest_task_name IN VARCHAR2 := NULL
185 ,p_dest_task_ver_id IN NUMBER := NULL
186 ,p_type IN VARCHAR2 := 'FS'
187 ,p_lag_days IN NUMBER := 0
188 ,p_comments IN VARCHAR2 := NULL
189 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
190 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
191 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
192 );
193
194
195 -- API name : Update_Dependency
196 -- Type : Public Procedure
197 -- Pre-reqs : None
198 -- Return Value : N/A
199 -- Parameters
200 -- p_api_version IN NUMBER := 1.0
201 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
202 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
203 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
204 -- p_validation_level IN VARCHAR2 := 100
205 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
206 -- p_debug_mode IN VARCHAR2 := 'N'
207 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
208 -- p_task_version_id IN NUMBER := NULL
209 -- p_type IN VARCHAR2 := NULL
210 -- p_lag_days IN NUMBER := NULL
211 -- p_comments IN VARCHAR2 := NULL
212 -- p_record_version_number IN NUMBER
213 -- x_return_status OUT VARCHAR2
214 -- x_msg_count OUT NUMBER
215 -- x_msg_data OUT VARCHAR2
216 --
217 -- History
218 --
219 -- 10-dec-03 Maansari -Created
220 --
221 -- FPM bug 3301192
222 --
223
224 procedure Update_dependency
225 (
226 p_api_version IN NUMBER := 1.0
227 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
228 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
229 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
230 ,p_validation_level IN VARCHAR2 := 100
231 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
232 ,p_debug_mode IN VARCHAR2 := 'N'
233 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
234 ,p_task_version_id IN NUMBER := NULL
235 ,p_src_task_version_id IN NUMBER := NULL
236 ,p_type IN VARCHAR2 := NULL
237 ,p_lag_days IN NUMBER := NULL
238 ,p_comments IN VARCHAR2 := NULL
239 ,p_record_version_number IN NUMBER
240 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
241 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
242 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
243 );
244
245 -- API name : Delete_Dependency
246 -- Type : Public Procedure
247 -- Pre-reqs : None
248 -- Return Value : N/A
249 -- Parameters
250 -- p_api_version IN NUMBER := 1.0
251 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
252 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
253 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
254 -- p_validation_level IN VARCHAR2 := 100
255 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
256 -- p_debug_mode IN VARCHAR2 := 'N'
257 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
258 -- p_object_relationship_id IN NUMBER := NULL
259 -- x_return_status OUT VARCHAR2
260 -- x_msg_count OUT NUMBER
261 -- x_msg_data OUT VARCHAR2
262 --
263 -- History
264 --
265 -- 10-dec-03 Maansari -Created
266 --
267 -- FPM bug 3301192
268 --
269 --
270 procedure Delete_Dependency
271 (
272 p_api_version IN NUMBER := 1.0
273 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
274 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
275 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
276 ,p_validation_level IN VARCHAR2 := 100
277 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
278 ,p_debug_mode IN VARCHAR2 := 'N'
279 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
280 ,p_object_relationship_id IN NUMBER := NULL
281 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
282 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
283 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
284 );
285 --
286 -- API name : Create_Subproject_Association
287 -- Type : Public Procedure
288 -- Pre-reqs : None
289 -- Return Value : N/A
290 -- Parameters
291 -- p_api_version IN NUMBER := 1.0
292 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
293 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
294 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
295 -- p_validation_level IN VARCHAR2 := 100
296 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
297 -- p_debug_mode IN VARCHAR2 := 'N'
298 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299 -- p_src_proj_id IN NUMBER
300 -- p_task_ver_id IN NUMBER
301 -- p_dest_proj_id IN NUMBER
302 -- p_dest_proj_name IN VARCHAR2
303 -- p_comment IN VARCHAR2
304 -- x_return_status OUT VARCHAR2
305 -- x_msg_count OUT NUMBER
306 -- x_msg_data OUT VARCHAR2
307 --
308 -- History
309 --
310 -- 20-Feb-04 Smukka -Created
311 --
312 -- FPM bug 3450684
313 --
314 PROCEDURE create_subproject_association(
315 p_api_version IN NUMBER := 1.0
316 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
317 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
318 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
319 ,p_validation_level IN VARCHAR2 := 100
320 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
321 ,p_debug_mode IN VARCHAR2 := 'N'
322 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
323 ,p_src_proj_id IN NUMBER
324 ,p_task_ver_id IN NUMBER
325 ,p_dest_proj_id IN NUMBER
326 ,p_dest_proj_name IN VARCHAR2 := NULL
327 ,p_comment IN VARCHAR2
328 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
329 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
330 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
331
332 --
333 -- API name : Update_Subproject_Association
334 -- Type : Public Procedure
335 -- Pre-reqs : None
336 -- Return Value : N/A
337 -- Parameters
338 -- p_api_version IN NUMBER := 1.0
339 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
340 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
341 -- p_validation_level IN VARCHAR2 := 100
342 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
343 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
344 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
345 -- p_debug_mode IN VARCHAR2 := 'N'
346 -- p_object_relationship_id IN NUMBER
347 -- p_record_version_number IN NUMBER
348 -- p_comment IN VARCHAR2
349 -- x_return_status OUT VARCHAR2
350 -- x_msg_count OUT NUMBER
351 -- x_msg_data OUT VARCHAR2
352 --
353 -- History
354 --
355 -- 20-Feb-04 Smukka -Created
356 -- -Created this procedure for subproject association
357 --
358 -- FPM bug 3450684
359 Procedure Update_Subproject_Association(p_api_version IN NUMBER := 1.0,
360 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
361 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
362 p_validation_level IN VARCHAR2 := 100,
363 p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
364 p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
365 p_commit IN VARCHAR2 := FND_API.G_FALSE,
366 p_debug_mode IN VARCHAR2 := 'N',
367 p_object_relationship_id IN NUMBER,
368 p_record_version_number IN NUMBER,
369 p_comment IN VARCHAR2,
370 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
371 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
372 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
373 --
374 -- API name : Delete_SubProject_Association
375 -- Type : Public Procedure
376 -- Pre-reqs : None
377 -- Return Value : N/A
378 -- Parameters
379 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
380 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
381 -- p_validation_level IN VARCHAR2 := 100
382 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
383 -- p_debug_mode IN VARCHAR2 := 'N'
384 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
385 -- p_object_relationships_id IN NUMBER
386 -- p_record_version_number IN NUMBER
387 -- x_return_status OUT VARCHAR2
388 -- x_msg_count OUT NUMBER
389 -- x_msg_data OUT VARCHAR2
390 --
391 -- History
392 --
393 -- 20-Feb-04 Smukka -Created
394 -- -Created this procedure for subproject association
395 --
396 -- FPM bug 3450684
397 Procedure Delete_SubProject_Association(p_api_version IN NUMBER := 1.0,
398 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
399 p_commit IN VARCHAR2 := FND_API.G_FALSE,
400 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
401 p_validation_level IN VARCHAR2 := 100,
402 p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
403 p_debug_mode IN VARCHAR2 := 'N',
404 p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405 p_object_relationships_id IN NUMBER,
406 p_record_version_number IN NUMBER,
407 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
408 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
409 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
410
411
412 -- -----------------------------------------------------
413 -- function UPDATE_PROGRAM_GROUPS
414 --
415 -- p_operation_type = 'ADD' ==> This API must be called after the
416 -- association row has been added in
417 -- PA_OBJECT_RELATIONSHIPS
418 --
419 -- p_operation_type = 'DROP' ==> This API must be called before the
420 -- association row has been removed
421 -- from PA_OBJECT_RELATIONSHIPS
422 --
423 -- After this API looks up the association information it calls the
424 -- other API UPDATE_PROGRAM_GROUPS with the relevant parameters.
425 --
426 -- History
427 -- 12-MAR-2004 SVERMETT Created
428 --
429 -- -----------------------------------------------------
430 function UPDATE_PROGRAM_GROUPS (p_object_relationship_id in number,
431 p_operation_type in varchar2)
432 return number;
433
434
435 -- -----------------------------------------------------
436 -- function UPDATE_PROGRAM_GROUPS
437 --
438 -- return: 0 = successful level / group propagation
439 -- return: -1 = cycle exists during 'ADD' operation type
440 -- return: -2 = association does not exist during 'DROP' operation
441 --
442 -- *** This API assumes that initially no associations exist and
443 -- *** that associations are added one at a time in serial.
444 --
445 -- History
446 -- 12-MAR-2004 SVERMETT Created
447 -- 24-JUN-2005 SVERMETT Modified to support the relaxed acyclic rule
448 -- (old) acyclic rule:
449 -- No cycle may exist in a program hierarchy.
450 -- (new) relaxed acyclic rule:
451 -- A project may not roll up into a program
452 -- via more than one path.
453 --
454 -- -----------------------------------------------------
455 function UPDATE_PROGRAM_GROUPS (p_parent_task_version_id in number,
456 p_parent_group in number,
457 p_parent_level in number,
458 p_parent_project in number,
459 p_child_structure_version_id in number,
460 p_child_group in number,
461 p_child_level in number,
462 p_child_project in number,
463 p_relationship_type in varchar2,
464 p_operation_type in varchar2)
465 return number;
466
467 end PA_RELATIONSHIP_PUB;