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