1 package PA_PROJECT_STRUCTURE_PUB1 as
2 /*$Header: PAXSTCPS.pls 120.4 2007/07/10 05:57:34 kkorada ship $*/
3
4 -- Global variable to store user_id
5 Global_User_Id NUMBER := NULL;
6
7 FUNCTION CHECK_ACTION_ALLOWED
8 ( p_action IN VARCHAR2
9 ,p_version_id IN NUMBER
10 ,p_status_code IN VARCHAR2
11 ) RETURN VARCHAR2;
12
13 PROCEDURE SetGlobalUserId ( p_user_id NUMBER );
14
15 FUNCTION GetGlobalUserId RETURN NUMBER;
16
17
18 -- API name : Create_Structure
19 -- Type : Public Procedure
20 -- Pre-reqs : None
21 -- Return Value : N/A
22 -- Parameters
23 -- p_api_version IN NUMBER := 1.0
24 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
25 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
26 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
27 -- p_validation_level IN VARCHAR2 := 100
28 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
29 -- p_debug_mode IN VARCHAR2 := 'N'
30 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31 -- p_project_id IN NUMBER
32 -- p_structure_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33 -- p_structure_name IN VARCHAR2
34 -- p_calling_flag IN VARCHAR2 := 'WORKPLAN'
35 -- p_structure_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
37 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52 -- x_structure_id OUT NUMBER
53 -- x_return_status OUT VARCHAR2
54 -- x_msg_count OUT NUMBER
55 -- x_msg_data OUT VARCHAR2
56 --
57 -- History
58 --
59 -- 25-JUN-01 HSIU -Created
60 --
61 --
62
63
64 procedure Create_Structure
65 (
66 p_api_version IN NUMBER := 1.0
67 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
68 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
69 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
70 ,p_validation_level IN VARCHAR2 := 100
71 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
72 ,p_debug_mode IN VARCHAR2 := 'N'
73 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
74 ,p_project_id IN NUMBER
75 ,p_structure_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
76 ,p_structure_name IN VARCHAR2
77 ,p_calling_flag IN VARCHAR2 := 'WORKPLAN'
78 ,p_structure_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
79 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
80 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
81 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
83 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
84 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
86 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
87 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
88 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
89 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
90 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
91 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
92 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
93 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
94 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
95 ,p_approval_reqd_flag IN VARCHAR2 := 'N'
96 ,p_auto_publish_flag IN VARCHAR2 := 'N'
97 ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
98 ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
99 ,p_default_display_lvl IN NUMBER := 0
100 ,p_enable_wp_version_flag IN VARCHAR2 := 'N'
101 ,p_auto_pub_upon_creation_flag IN VARCHAR2 := 'N'
102 ,p_auto_sync_txn_date_flag IN VARCHAR2 := 'N'
103 ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
104 --LDENG
105 ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
106 ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
107 --END LDENG
108 ,p_progress_cycle_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
109 ,p_wq_enable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
110 ,p_remain_effort_enable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
111 ,p_percent_comp_enable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
112 ,p_next_progress_update_date IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
113 ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
114 ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
117 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118 );
119
120
121 -- API name : Create_Structure_Version
122 -- Type : Public Procedure
123 -- Pre-reqs : None
124 -- Return Value : N/A
125 -- Parameters
126 -- p_api_version IN NUMBER := 1.0
127 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
129 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130 -- p_validation_level IN VARCHAR2 := 100
131 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
132 -- p_debug_mode IN VARCHAR2 := 'N'
133 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134 -- p_structure_id IN NUMBER
135 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
136 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
139 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
140 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
141 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
143 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
144 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
146 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
147 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
149 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
150 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
151 -- x_structure_version_id OUT NUMBER
152 -- x_return_status OUT VARCHAR2
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2
155 --
156 -- History
157 --
158 -- 25-JUN-01 HSIU -Created
159 --
160 --
161
162
163 procedure Create_Structure_Version
164 (
165 p_api_version IN NUMBER := 1.0
166 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
167 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
168 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
169 ,p_validation_level IN VARCHAR2 := 100
170 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
171 ,p_debug_mode IN VARCHAR2 := 'N'
172 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
173 ,p_structure_id IN NUMBER
174 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
175 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
176 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
177 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
178 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
179 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
180 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
181 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
182 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
183 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
184 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
185 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
186 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
187 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
188 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
189 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
190 ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
191 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
192 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
193 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
194 );
195
196
197 -- API name : Create_Structure_Version_Attr
198 -- Type : Public Procedure
199 -- Pre-reqs : None
200 -- Return Value : N/A
201 -- Parameters
202 -- p_api_version IN NUMBER := 1.0
203 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
204 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
205 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
206 -- p_validation_level IN VARCHAR2 := 100
207 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
208 -- p_debug_mode IN VARCHAR2 := 'N'
209 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
210 -- p_structure_version_id IN NUMBER
211 -- p_structure_version_name IN VARCHAR2
212 -- p_structure_version_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
213 -- p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
214 -- p_latest_eff_published_flag IN VARCHAR2 := 'N'
215 -- p_published_flag IN VARCHAR2 := 'N'
216 -- p_locked_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
217 -- p_struct_version_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
218 -- p_baseline_current_flag IN VARCHAR2 := 'N'
219 -- p_baseline_original_flag IN VARCHAR2 := 'N'
220 -- x_pev_structure_id OUT NUMBER
221 -- x_return_status OUT VARCHAR2
222 -- x_msg_count OUT NUMBER
223 -- x_msg_data OUT VARCHAR2
224 --
225 -- History
226 --
227 -- 25-JUN-01 HSIU -Created
228 -- 21-JUN-02 HSIU Added change_reason_code
229 --
230
231
232 procedure Create_Structure_Version_Attr
233 (
234 p_api_version IN NUMBER := 1.0
235 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
236 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
237 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
238 ,p_validation_level IN VARCHAR2 := 100
239 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
240 ,p_debug_mode IN VARCHAR2 := 'N'
241 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
242 ,p_structure_version_id IN NUMBER
243 ,p_structure_version_name IN VARCHAR2
244 ,p_structure_version_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245 ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
246 ,p_latest_eff_published_flag IN VARCHAR2 := 'N'
247 ,p_published_flag IN VARCHAR2 := 'N'
248 ,p_locked_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
249 ,p_struct_version_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
250 ,p_baseline_current_flag IN VARCHAR2 := 'N'
251 ,p_baseline_original_flag IN VARCHAR2 := 'N'
252 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
253 ,x_pev_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
254 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
255 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
256 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
257 );
258
259
260 -- API name : Update_Structure
261 -- Type : Public Procedure
262 -- Pre-reqs : None
263 -- Return Value : N/A
264 -- Parameters
265 -- p_api_version IN NUMBER := 1.0
266 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
267 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
268 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
269 -- p_validation_level IN VARCHAR2 := 100
270 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
271 -- p_debug_mode IN VARCHAR2 := 'N'
272 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
273 -- p_structure_id IN NUMBER
274 -- p_structure_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
275 -- p_structure_name IN VARCHAR2
276 -- p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
277 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
278 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
279 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
280 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
281 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
282 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
283 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
284 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
285 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
286 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
287 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
288 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
289 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
290 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
291 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
292 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
293 -- p_record_version_number IN NUMBER
294 -- x_return_status OUT VARCHAR2
295 -- x_msg_count OUT NUMBER
296 -- x_msg_data OUT VARCHAR2
297 --
298 -- History
299 --
300 -- 25-JUN-01 HSIU -Created
301 --
302 --
303
304
305 procedure Update_Structure
306 (
307 p_api_version IN NUMBER := 1.0
308 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
309 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
310 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
311 ,p_validation_level IN VARCHAR2 := 100
312 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
313 ,p_debug_mode IN VARCHAR2 := 'N'
314 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
315 ,p_structure_id IN NUMBER
316 ,p_structure_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
317 ,p_structure_name IN VARCHAR2
318 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
319 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
320 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
321 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
322 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
323 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
324 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
325 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
326 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
327 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
328 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
329 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
330 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
331 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
332 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
336 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
333 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
334 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
335 ,p_record_version_number IN NUMBER
337 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
338 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
339 );
340
341
342 -- API name : Update_Structure_Version_Attr
343 -- Type : Public Procedure
344 -- Pre-reqs : None
345 -- Return Value : N/A
346 -- Parameters
347 -- p_api_version IN NUMBER := 1.0
348 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
349 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
350 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
351 -- p_validation_level IN VARCHAR2 := 100
352 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
353 -- p_debug_mode IN VARCHAR2 := 'N'
354 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
355 -- p_pev_structure_id IN NUMBER
356 -- p_structure_version_name IN VARCHAR2
357 -- p_structure_version_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
358 -- p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
359 -- p_latest_eff_published_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
360 -- p_locked_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
361 -- p_struct_version_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
362 -- p_baseline_current_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
363 -- p_baseline_original_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
364 -- p_record_version_number IN NUMBER
365 -- p_current_working_ver_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
366 -- x_return_status OUT VARCHAR2
367 -- x_msg_count OUT NUMBER
368 -- x_msg_data OUT VARCHAR2
369 --
370 -- History
371 --
372 -- 25-JUN-01 HSIU -Created
373 --
374 --
375
376
377 procedure Update_Structure_Version_Attr
378 (
379 p_api_version IN NUMBER := 1.0
380 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
381 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
382 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
383 ,p_validation_level IN VARCHAR2 := 100
384 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
385 ,p_debug_mode IN VARCHAR2 := 'N'
386 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
387 ,p_pev_structure_id IN NUMBER
388 ,p_structure_version_name IN VARCHAR2
389 ,p_structure_version_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
390 ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
391 ,p_latest_eff_published_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
392 ,p_locked_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
393 ,p_struct_version_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
394 ,p_baseline_current_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
395 ,p_baseline_original_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
396 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
397 ,p_record_version_number IN NUMBER
398 --FP M changes bug 3301192
399 ,p_current_working_ver_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
400 --end FP M changes bug 3301192
401 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
402 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
403 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
404 );
405
406
407 -- API name : Delete_Structure_Version
408 -- Type : Public Procedure
409 -- Pre-reqs : None
410 -- Return Value : N/A
411 -- Parameters
412 -- p_api_version IN NUMBER := 1.0
413 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
414 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
415 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
416 -- p_validation_level IN VARCHAR2 := 100
417 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
418 -- p_debug_mode IN VARCHAR2 := 'N'
419 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420 -- p_structure_version_id IN NUMBER
421 -- p_record_version_number IN NUMBER
422 -- x_return_status OUT VARCHAR2
423 -- x_msg_count OUT NUMBER
424 -- x_msg_data OUT VARCHAR2
425 --
426 -- History
427 --
428 -- 25-JUN-01 HSIU -Created
429 --
430 --
431
432
433 procedure Delete_Structure_Version
434 (
435 p_api_version IN NUMBER := 1.0
439 ,p_validation_level IN VARCHAR2 := 100
436 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
437 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
438 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
440 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
441 ,p_debug_mode IN VARCHAR2 := 'N'
442 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443 ,p_calling_from IN VARCHAR2 := 'XYZ' ---Added for bug 6023347
444 ,p_structure_version_id IN NUMBER
445 ,p_record_version_number IN NUMBER
446 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
447 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
448 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
449 );
450
451
452
453 -- API name : Publish_Structure
454 -- Type : Public Procedure
455 -- Pre-reqs : None
456 -- Return Value : N/A
457 -- Parameters
458 -- p_api_version IN NUMBER := 1.0
459 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
460 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
461 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
462 -- p_validation_level IN VARCHAR2 := 100
463 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
464 -- p_debug_mode IN VARCHAR2 := 'N'
465 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
466 -- p_responsibility_id IN NUMBER := 0
467 -- p_structure_version_id IN NUMBER
468 -- p_publish_structure_ver_name IN VARCHAR2
469 -- p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
470 -- p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
471 -- p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472 -- p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
473 -- x_published_struct_ver_id OUT NUMBER
474 -- x_return_status OUT VARCHAR2
475 -- x_msg_count OUT NUMBER
476 -- x_msg_data OUT VARCHAR2
477 --
478 -- History
479 --
480 -- 25-JUN-01 HSIU -Created
481 --
482 --
483
484
485 procedure Publish_Structure
486 (
487 p_api_version IN NUMBER := 1.0
488 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
489 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
490 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
491 ,p_validation_level IN VARCHAR2 := 100
492 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
493 ,p_debug_mode IN VARCHAR2 := 'N'
494 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
495 ,p_responsibility_id IN NUMBER := 0
496 ,p_user_id IN NUMBER := NULL
497 ,p_structure_version_id IN NUMBER
498 ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
499 ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
500 ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
501 ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
502 ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
503 ,p_pub_prog_flag IN VARCHAR2 DEFAULT 'Y' -- Added for FP_M changes 3420093
504 ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
505 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
506 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
507 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
508 );
509
510
511 -- API name : Copy_Structure
512 -- Type : Public Procedure
513 -- Pre-reqs : None
514 -- Return Value : N/A
515 -- Parameters
516 -- p_api_version IN NUMBER := 1.0
517 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
518 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
519 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
520 -- p_validation_level IN VARCHAR2 := 100
521 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
522 -- p_debug_mode IN VARCHAR2 := 'N'
523 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
524 -- p_src_project_id IN NUMBER
525 -- p_dest_project_id IN NUMBER
526 -- p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
527 -- x_return_status OUT VARCHAR2
528 -- x_msg_count OUT NUMBER
532 --
529 -- x_msg_data OUT VARCHAR2
530 --
531 -- History
533 -- 25-JUN-01 HSIU -Created
534 --
535 --
536
537
538 procedure Copy_Structure
539 (
540 p_api_version IN NUMBER := 1.0
541 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
542 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
543 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
544 ,p_validation_level IN VARCHAR2 := 100
545 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
546 ,p_debug_mode IN VARCHAR2 := 'N'
547 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
548 ,p_src_project_id IN NUMBER
549 ,p_dest_project_id IN NUMBER
550 -- anlee
551 -- Dates changes
552 ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
553 -- End of changes
554 ,p_copy_task_flag IN VARCHAR2 := 'Y'
555 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
556 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
557 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
558 );
559
560
561 -- API name : Copy_Structure_Version
562 -- Type : Public Procedure
563 -- Pre-reqs : None
564 -- Return Value : N/A
565 -- Parameters
566 -- p_api_version IN NUMBER := 1.0
567 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
568 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
569 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
570 -- p_validation_level IN VARCHAR2 := 100
571 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
572 -- p_debug_mode IN VARCHAR2 := 'N'
573 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
574 -- p_structure_version_id IN NUMBER
575 -- p_new_struct_ver_name IN VARCHAR2
576 -- p_new_struct_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
577 -- x_new_struct_ver_id OUT NUMBER
578 -- x_return_status OUT VARCHAR2
579 -- x_msg_count OUT NUMBER
580 -- x_msg_data OUT VARCHAR2
581 --
582 -- History
583 --
584 -- 25-JUN-01 HSIU -Created
585 --
586 --
587
588
589 procedure Copy_Structure_Version
590 (
591 p_api_version IN NUMBER := 1.0
592 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
593 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
594 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
595 ,p_validation_level IN VARCHAR2 := 100
596 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
597 ,p_debug_mode IN VARCHAR2 := 'N'
598 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
599 ,p_structure_version_id IN NUMBER
600 ,p_new_struct_ver_name IN VARCHAR2
601 ,p_new_struct_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
602 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
603 ,x_new_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
604 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
605 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
606 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
607 );
608
609
610 procedure SUBMIT_WORKPLAN
611 (
612 p_api_version IN NUMBER := 1.0
613 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
614 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
615 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
616 ,p_validation_level IN VARCHAR2 := 100
617 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
618 ,p_debug_mode IN VARCHAR2 := 'N'
619 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
620 ,p_project_id IN NUMBER
621 ,p_structure_id IN NUMBER
622 ,p_structure_version_id IN NUMBER
623 ,p_responsibility_id IN NUMBER
624 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
625 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
626 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
627 );
628
629 PROCEDURE rework_workplan
630 (
631 p_api_version IN NUMBER := 1.0
632 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
633 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
634 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
635 ,p_validation_level IN VARCHAR2 := 100
639 ,p_project_id IN NUMBER
636 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
637 ,p_debug_mode IN VARCHAR2 := 'N'
638 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
640 ,p_structure_version_id IN NUMBER
641 ,p_record_version_number IN NUMBER
642 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
643 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
644 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
645 );
646
647
648 -- API name : update_structures_setup_attr
649 -- Type : Update API
650 -- Pre-reqs : None
651 -- Return Value : Update_structures_setup_attr
652 --
653 -- Parameters
654 -- p_project_id IN NUMBER
655 -- p_workplan_enabled_flag IN VARCHAR2
656 -- p_financial_enabled_flag IN VARCHAR2
657 -- p_sharing_enabled_flag IN VARCHAR2
658 --FP M changes bug 3301192
659 -- p_deliverables_enabled_flag IN VARCHAR2
660 -- p_sharing_option_code IN VARCHAR2
661 --End FP M changes bug 3301192
662 -- x_return_status OUT VARCHAR2
663 -- x_msg_count OUT NUMBER
664 -- x_msg_data OUT VARCHAR2
665 --
666 -- History
667 --
668 -- 26-JUL-02 HSIU -Created
669 --
670 PROCEDURE update_structures_setup_attr
671 ( p_api_version IN NUMBER := 1.0
672 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
673 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
674 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
675 ,p_validation_level IN VARCHAR2 := 100
676 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
677 ,p_debug_mode IN VARCHAR2 := 'N'
678 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
679 ,p_project_id IN NUMBER
680 ,p_workplan_enabled_flag IN VARCHAR2
681 ,p_financial_enabled_flag IN VARCHAR2
682 ,p_sharing_enabled_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
683 --FP M changes bug 3301192
684 ,p_deliverables_enabled_flag IN VARCHAR2
685 ,p_sharing_option_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
686 --End FP M changes bug 3301192
687 ,p_sys_program_flag IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
688 ,p_allow_multi_prog_rollup IN varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
689 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
690 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
691 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
692 ) ;
693
694 PROCEDURE update_workplan_versioning
695 ( p_api_version IN NUMBER := 1.0
696 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
697 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
698 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
699 ,p_validation_level IN VARCHAR2 := 100
700 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
701 ,p_debug_mode IN VARCHAR2 := 'N'
702 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
703 ,p_proj_element_id IN NUMBER
704 ,p_enable_wp_version_flag IN VARCHAR2
705 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
706 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
707 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
708 );
709
710 -- API name : Delete_Working_Struc_Ver
711 -- Type : Public Procedure
712 -- Pre-reqs : None
713 -- Return Value : N/A
714 -- Parameters
715 -- p_api_version IN NUMBER := 1.0
716 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
717 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
718 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
719 -- p_validation_level IN VARCHAR2 := 100
720 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
721 -- p_debug_mode IN VARCHAR2 := 'N'
722 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
723 -- p_structure_version_id IN NUMBER
724 -- p_record_version_number IN NUMBER
725 -- x_return_status OUT VARCHAR2
726 -- x_msg_count OUT NUMBER
727 -- x_msg_data OUT VARCHAR2
728 --
729 -- History
730 --
731 -- 17-DEC-02 HSIU -Created
732 --
733 --
734
735
736 procedure Delete_Working_Struc_Ver
737 (
738 p_api_version IN NUMBER := 1.0
739 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
740 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
741 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
742 ,p_validation_level IN VARCHAR2 := 100
743 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
744 ,p_debug_mode IN VARCHAR2 := 'N'
745 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
746 ,p_structure_version_id IN NUMBER
747 ,p_record_version_number IN NUMBER
751 );
748 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
749 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
750 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
752
753 -- API name : Enable_Financial_Structure
754 -- Type : Public Procedure
755 -- Pre-reqs : None
756 -- Return Value : N/A
757 -- Parameters
758 -- p_api_version IN NUMBER := 1.0
759 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
760 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
761 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
762 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
763 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
764 -- p_debug_mode IN VARCHAR2 := 'N'
765 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
766 -- p_project_id IN NUMBER
767 -- p_proj_element_id IN NUMBER
768 -- x_return_status OUT VARCHAR2
769 -- x_msg_count OUT NUMBER
770 -- x_msg_data OUT VARCHAR2
771 --
772 -- History
773 -- 02-JAN-04 Rakesh Raghavan - Created
774 -- 04-MAR-2004 Rakesh Raghavan - Modified for Progress Management Changes. Bug # 3420093.
775 --
776 --
777
778 procedure ENABLE_FINANCIAL_STRUCTURE
779 (
780 p_api_version IN NUMBER := 1.0
781 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
782 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
783 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
784 ,p_validation_level IN NUMBER := 100
785 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
786 ,p_debug_mode IN VARCHAR2 := 'N'
787 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
788 ,p_project_id IN NUMBER
789 ,p_proj_element_id IN NUMBER
790 ,p_approval_reqd_flag IN VARCHAR2 DEFAULT 'N'
791 ,p_auto_publish_flag IN VARCHAR2 DEFAULT 'N'
792 ,p_approver_source_id IN NUMBER DEFAULT NULL
793 ,p_approver_source_type IN NUMBER DEFAULT NULL
794 ,p_default_display_lvl IN NUMBER DEFAULT 0
795 ,p_enable_wp_version_flag IN VARCHAR2 DEFAULT 'N'
796 ,p_auto_pub_upon_creation_flag IN VARCHAR2 DEFAULT 'N'
797 ,p_auto_sync_txn_date_flag IN VARCHAR2 DEFAULT 'N'
798 ,p_txn_date_sync_buf_days IN NUMBER DEFAULT NULL
799 ,p_lifecycle_version_id IN NUMBER DEFAULT NULL
800 ,p_current_phase_version_id IN NUMBER DEFAULT NULL
801 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
802 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
803 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
804 );
805
806
807 -- API name : Disable_Financial_Structure
808 -- Type : Public Procedure
809 -- Pre-reqs : None
810 -- Return Value : N/A
811 -- Parameters
812 -- p_api_version IN NUMBER := 1.0
813 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
814 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
815 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
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'
819 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
820 -- p_project_id IN NUMBER
821 -- x_return_status OUT VARCHAR2
822 -- x_msg_count OUT NUMBER
823 -- x_msg_data OUT VARCHAR2
824 --
825 -- History
826 -- 02-JAN-04 Rakesh Raghavan - Created
827 -- 04-MAR-2004 Rakesh Raghavan - Modified for Progress Management Changes. Bug # 3420093.
828 --
829 --
830
831 procedure DISABLE_FINANCIAL_STRUCTURE
832 (
833 p_api_version IN NUMBER := 1.0
834 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
835 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
836 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
837 ,p_validation_level IN NUMBER := 100
838 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
839 ,p_debug_mode IN VARCHAR2 := 'N'
840 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
841 ,p_project_id IN NUMBER
842 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
843 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
844 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
845 );
846
847
848 -- API name : Clear_Financial_Flag
852 -- Parameters
849 -- Type : Public Procedure
850 -- Pre-reqs : None
851 -- Return Value : N/A
853 -- p_api_version IN NUMBER := 1.0
854 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
855 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
856 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
857 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
858 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
859 -- p_debug_mode IN VARCHAR2 := 'N'
860 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
861 -- p_project_id IN NUMBER
862 -- p_task_version_id IN NUMBER
863 -- p_structure_version_id IN NUMBER
864 -- x_return_status OUT VARCHAR2
865 -- x_msg_count OUT NUMBER
866 -- x_msg_data OUT VARCHAR2
867 --
868 -- History
869 -- 02-JAN-04 Rakesh Raghavan - Created
870 --
871 --
872
873 procedure CLEAR_FINANCIAL_FLAG
874 (
875 p_api_version IN NUMBER := 1.0
876 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
877 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
878 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
879 ,p_validation_level IN NUMBER := 100
880 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
881 ,p_debug_mode IN VARCHAR2 := 'N'
882 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
883 ,p_project_id IN NUMBER
884 ,p_task_version_id IN NUMBER
885 ,p_structure_version_id IN NUMBER
886 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
887 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
888 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
889 );
890
891 -- API name : Update_Sch_Dirty_Flag
892 -- Type : Public Procedure
893 -- Pre-reqs : None
894 -- Return Value : N/A
895 -- Parameters
896 -- p_api_version IN NUMBER := 1.0
897 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
898 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
899 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
900 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
901 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
902 -- p_debug_mode IN VARCHAR2 := 'N'
903 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
904 -- p_project_id IN NUMBER
905 -- p_structure_version_id IN NUMBER
906 -- p_dirty_flag IN VARCHAR2
907 -- x_return_status OUT VARCHAR2
908 -- x_msg_count OUT NUMBER
909 -- x_msg_data OUT VARCHAR2
910 --
911 -- History
912 -- 23-MAR-04 Srikanth Mukka - Created
913 --
914 --
915 PROCEDURE Update_Sch_Dirty_Flag(
916 p_api_version IN NUMBER := 1.0
917 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
918 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
919 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
920 ,p_validation_level IN NUMBER := 100
921 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
922 ,p_debug_mode IN VARCHAR2 := 'N'
923 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
924 ,p_project_id IN NUMBER
925 ,p_structure_version_id IN NUMBER
926 ,p_dirty_flag IN VARCHAR2 := 'N'
927 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
928 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
929 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
930 );
931 --
932 -- History
933 -- 03-May-06 Ram Namburi - Created
934 -- Purpose:
935 -- This is used to enable the program on a project. In forms we are not allowing the user to create a link
936 -- all the times, and if the program is not enabled then we enable that on the fly so the link creation is
937 -- possible. This is needed otherwise users need to go to SS page to enable program on the project and come
938 -- back to forms to create links. In order to remove this dependency we are now calling this API from forms
939 -- as we couldnt directly call the update_structures_setup_attr.
940 -- This wrapper will call the update_structures_setup_attr with other parameters.
941 --
942 PROCEDURE enable_program_flag(
943 p_project_id IN NUMBER
944 ,x_return_status OUT NOCOPY VARCHAR2
945 ,x_msg_count OUT NOCOPY NUMBER
946 ,x_msg_data OUT NOCOPY VARCHAR2
947
948 );
949
953 -- Pre-reqs : None
950 -- API name : DELETE_PUBLISHED_STRUCTURE_VERSION
951 -- Tracking Bug : 4925192
952 -- Type : Public Procedure
957 -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
954 -- Return Value : N/A
955 -- Parameters
956 -- p_api_version IN NUMBER := 1.0
958 -- ,p_project_id IN NUMBER
959 -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
960 -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
961 -- ,x_return_status OUT NOCOPY VARCHAR2
962 -- ,x_msg_count OUT NOCOPY NUMBER
963 -- ,x_msg_data OUT NOCOPY VARCHAR2
964 --
965 -- History
966 --
967 -- 20-Oct-06 Ram Namburi -Created
968 --
969 -- Purpose:
970 --
971 -- This API will delete a published structure version
972 -- 1. It calls the delete validation API to see if deletion is okay.
973 -- 2. Then it calls the Progress API to roll up the progress to the next higher
974 -- later versions
975 -- 3. Then it calls the actual delete API.
976 --
977
978
979 procedure DELETE_PUBLISHED_STRUCTURE_VER
980 (
981 p_api_version IN NUMBER := 1.0
982 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
983 ,p_project_id IN NUMBER
984 ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
985 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
986 ,x_return_status OUT NOCOPY VARCHAR2
987 ,x_msg_count OUT NOCOPY NUMBER
988 ,x_msg_data OUT NOCOPY VARCHAR2
989 );
990
991
992 end PA_PROJECT_STRUCTURE_PUB1;
[Home] [Help]