1 package PA_PROJECT_STRUCTURE_PUB1 AUTHID CURRENT_USER as
2 /*$Header: PAXSTCPS.pls 120.4.12020000.3 2013/03/27 07:59:06 bpottipa 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
277 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
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
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
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
336 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
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
369 --
366 -- x_return_status OUT VARCHAR2
367 -- x_msg_count OUT NUMBER
368 -- x_msg_data OUT VARCHAR2
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
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
439 ,p_validation_level IN VARCHAR2 := 100
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
478 -- History
475 -- x_msg_count OUT NUMBER
476 -- x_msg_data OUT VARCHAR2
477 --
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
529 -- x_msg_data OUT VARCHAR2
530 --
531 -- History
532 --
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
592 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
589 procedure Copy_Structure_Version
590 (
591 p_api_version IN NUMBER := 1.0
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
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
639 ,p_project_id IN NUMBER
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 ,p_cbs_version_id IN Number default NULL --Bug15834912
693 ,p_cbs_enable_flag IN VARCHAR2 default 'N' --Bug16083858
694 ) ;
695
696 PROCEDURE update_workplan_versioning
697 ( p_api_version IN NUMBER := 1.0
698 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
702 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
699 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
700 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
701 ,p_validation_level IN VARCHAR2 := 100
703 ,p_debug_mode IN VARCHAR2 := 'N'
704 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
705 ,p_proj_element_id IN NUMBER
706 ,p_enable_wp_version_flag IN VARCHAR2
707 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
708 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
709 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
710 );
711
712 -- API name : Delete_Working_Struc_Ver
713 -- Type : Public Procedure
714 -- Pre-reqs : None
715 -- Return Value : N/A
716 -- Parameters
717 -- p_api_version IN NUMBER := 1.0
718 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
719 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
720 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
721 -- p_validation_level IN VARCHAR2 := 100
722 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
723 -- p_debug_mode IN VARCHAR2 := 'N'
724 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
725 -- p_structure_version_id IN NUMBER
726 -- p_record_version_number IN NUMBER
727 -- x_return_status OUT VARCHAR2
728 -- x_msg_count OUT NUMBER
729 -- x_msg_data OUT VARCHAR2
730 --
731 -- History
732 --
733 -- 17-DEC-02 HSIU -Created
734 --
735 --
736
737
738 procedure Delete_Working_Struc_Ver
739 (
740 p_api_version IN NUMBER := 1.0
741 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
742 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
743 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
744 ,p_validation_level IN VARCHAR2 := 100
745 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
746 ,p_debug_mode IN VARCHAR2 := 'N'
747 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
748 ,p_structure_version_id IN NUMBER
749 ,p_record_version_number IN NUMBER
750 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
751 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
752 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
753 );
754
755 -- API name : Enable_Financial_Structure
756 -- Type : Public Procedure
757 -- Pre-reqs : None
758 -- Return Value : N/A
759 -- Parameters
760 -- p_api_version IN NUMBER := 1.0
761 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
762 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
763 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
764 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
765 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
766 -- p_debug_mode IN VARCHAR2 := 'N'
767 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
768 -- p_project_id IN NUMBER
769 -- p_proj_element_id IN NUMBER
770 -- x_return_status OUT VARCHAR2
771 -- x_msg_count OUT NUMBER
772 -- x_msg_data OUT VARCHAR2
773 --
774 -- History
775 -- 02-JAN-04 Rakesh Raghavan - Created
776 -- 04-MAR-2004 Rakesh Raghavan - Modified for Progress Management Changes. Bug # 3420093.
777 --
778 --
779
780 procedure ENABLE_FINANCIAL_STRUCTURE
781 (
782 p_api_version IN NUMBER := 1.0
783 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
784 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
785 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
786 ,p_validation_level IN NUMBER := 100
787 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788 ,p_debug_mode IN VARCHAR2 := 'N'
789 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
790 ,p_project_id IN NUMBER
791 ,p_proj_element_id IN NUMBER
792 ,p_approval_reqd_flag IN VARCHAR2 DEFAULT 'N'
793 ,p_auto_publish_flag IN VARCHAR2 DEFAULT 'N'
794 ,p_approver_source_id IN NUMBER DEFAULT NULL
795 ,p_approver_source_type IN NUMBER DEFAULT NULL
796 ,p_default_display_lvl IN NUMBER DEFAULT 0
797 ,p_enable_wp_version_flag IN VARCHAR2 DEFAULT 'N'
798 ,p_auto_pub_upon_creation_flag IN VARCHAR2 DEFAULT 'N'
799 ,p_auto_sync_txn_date_flag IN VARCHAR2 DEFAULT 'N'
800 ,p_txn_date_sync_buf_days IN NUMBER DEFAULT NULL
801 ,p_lifecycle_version_id IN NUMBER DEFAULT NULL
802 ,p_current_phase_version_id IN NUMBER DEFAULT NULL
803 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
804 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
805 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
806 );
807
808
809 -- API name : Disable_Financial_Structure
810 -- Type : Public Procedure
811 -- Pre-reqs : None
812 -- Return Value : N/A
813 -- Parameters
814 -- p_api_version IN NUMBER := 1.0
815 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
816 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
817 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
818 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
819 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
820 -- p_debug_mode IN VARCHAR2 := 'N'
821 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822 -- p_project_id IN NUMBER
823 -- x_return_status OUT VARCHAR2
824 -- x_msg_count OUT NUMBER
825 -- x_msg_data OUT VARCHAR2
826 --
827 -- History
828 -- 02-JAN-04 Rakesh Raghavan - Created
829 -- 04-MAR-2004 Rakesh Raghavan - Modified for Progress Management Changes. Bug # 3420093.
830 --
831 --
832
833 procedure DISABLE_FINANCIAL_STRUCTURE
834 (
835 p_api_version IN NUMBER := 1.0
836 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
837 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
838 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
839 ,p_validation_level IN NUMBER := 100
840 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
841 ,p_debug_mode IN VARCHAR2 := 'N'
842 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
843 ,p_project_id IN NUMBER
844 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
845 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
846 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
847 );
848
849
850 -- API name : Clear_Financial_Flag
851 -- Type : Public Procedure
852 -- Pre-reqs : None
853 -- Return Value : N/A
854 -- Parameters
855 -- p_api_version IN NUMBER := 1.0
856 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
857 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
858 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
859 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
860 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
861 -- p_debug_mode IN VARCHAR2 := 'N'
862 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
863 -- p_project_id IN NUMBER
864 -- p_task_version_id IN NUMBER
865 -- p_structure_version_id IN NUMBER
866 -- x_return_status OUT VARCHAR2
867 -- x_msg_count OUT NUMBER
868 -- x_msg_data OUT VARCHAR2
869 --
870 -- History
871 -- 02-JAN-04 Rakesh Raghavan - Created
872 --
873 --
874
875 procedure CLEAR_FINANCIAL_FLAG
876 (
877 p_api_version IN NUMBER := 1.0
878 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
879 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
880 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
881 ,p_validation_level IN NUMBER := 100
882 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
883 ,p_debug_mode IN VARCHAR2 := 'N'
884 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
885 ,p_project_id IN NUMBER
886 ,p_task_version_id IN NUMBER
887 ,p_structure_version_id IN NUMBER
888 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
889 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
890 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
891 );
892
893 -- API name : Update_Sch_Dirty_Flag
894 -- Type : Public Procedure
895 -- Pre-reqs : None
896 -- Return Value : N/A
897 -- Parameters
898 -- p_api_version IN NUMBER := 1.0
899 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
900 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
901 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
902 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
903 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
904 -- p_debug_mode IN VARCHAR2 := 'N'
905 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
906 -- p_project_id IN NUMBER
907 -- p_structure_version_id IN NUMBER
908 -- p_dirty_flag IN VARCHAR2
909 -- x_return_status OUT VARCHAR2
910 -- x_msg_count OUT NUMBER
911 -- x_msg_data OUT VARCHAR2
912 --
913 -- History
914 -- 23-MAR-04 Srikanth Mukka - Created
915 --
916 --
917 PROCEDURE Update_Sch_Dirty_Flag(
918 p_api_version IN NUMBER := 1.0
919 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
920 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
921 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
922 ,p_validation_level IN NUMBER := 100
923 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
924 ,p_debug_mode IN VARCHAR2 := 'N'
925 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
926 ,p_project_id IN NUMBER
927 ,p_structure_version_id IN NUMBER
928 ,p_dirty_flag IN VARCHAR2 := 'N'
929 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
930 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
931 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
932 );
933 --
934 -- History
935 -- 03-May-06 Ram Namburi - Created
936 -- Purpose:
937 -- This is used to enable the program on a project. In forms we are not allowing the user to create a link
938 -- all the times, and if the program is not enabled then we enable that on the fly so the link creation is
939 -- possible. This is needed otherwise users need to go to SS page to enable program on the project and come
940 -- back to forms to create links. In order to remove this dependency we are now calling this API from forms
941 -- as we couldnt directly call the update_structures_setup_attr.
942 -- This wrapper will call the update_structures_setup_attr with other parameters.
943 --
944 PROCEDURE enable_program_flag(
945 p_project_id IN NUMBER
946 ,x_return_status OUT NOCOPY VARCHAR2
947 ,x_msg_count OUT NOCOPY NUMBER
948 ,x_msg_data OUT NOCOPY VARCHAR2
949
950 );
951
952 -- API name : DELETE_PUBLISHED_STRUCTURE_VERSION
953 -- Tracking Bug : 4925192
954 -- Type : Public Procedure
955 -- Pre-reqs : None
956 -- Return Value : N/A
957 -- Parameters
958 -- p_api_version IN NUMBER := 1.0
959 -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
960 -- ,p_project_id IN NUMBER
961 -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
962 -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
963 -- ,x_return_status OUT NOCOPY VARCHAR2
964 -- ,x_msg_count OUT NOCOPY NUMBER
965 -- ,x_msg_data OUT NOCOPY VARCHAR2
966 --
967 -- History
968 --
969 -- 20-Oct-06 Ram Namburi -Created
970 --
971 -- Purpose:
972 --
973 -- This API will delete a published structure version
974 -- 1. It calls the delete validation API to see if deletion is okay.
975 -- 2. Then it calls the Progress API to roll up the progress to the next higher
976 -- later versions
977 -- 3. Then it calls the actual delete API.
978 --
979
980
981 procedure DELETE_PUBLISHED_STRUCTURE_VER
982 (
983 p_api_version IN NUMBER := 1.0
984 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
985 ,p_project_id IN NUMBER
986 ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
987 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
988 ,x_return_status OUT NOCOPY VARCHAR2
989 ,x_msg_count OUT NOCOPY NUMBER
990 ,x_msg_data OUT NOCOPY VARCHAR2
991 );
992
993 /* This Procedure validates enable/diable of CBS for a project */
994 PROCEDURE VALIDATE_PROJECT_FOR_CBS(
995 p_project_id IN NUMBER,
996 p_cbs_flag IN VARCHAR2,
997 x_valid_flag OUT NOCOPY VARCHAR2,
998 x_error_msg_code OUT NOCOPY VARCHAR2 );
999
1000
1001 end PA_PROJECT_STRUCTURE_PUB1;