1 PACKAGE PA_PROJ_TASK_STRUC_PUB AUTHID DEFINER AS
2 /* $Header: PAPSWRPS.pls 120.4.12020000.2 2013/03/28 01:11:13 skkoppul ship $ */
3
4
5 -- API name : Create_default_structure
6 -- Type : PL/SQL Public procedure
7 -- Pre-reqs : None
8 -- Return Value : N/A
9 -- Prameters
10 -- p_dest_project_id IN NUMBER
11 -- p_dest_project_name IN VARCHAR2
12 -- p_dest_project_number IN VARCHAR2
13 -- p_dest_description IN VARCHAR2
14 -- p_dest_org_id IN NUMBER
15 -- x_msg_count OUT NUMBER
16 -- x_msg_data OUT VARCHAR2
17 -- x_return_status OUT VARCHAR2
18 --
19 -- History
20 --
21 -- 14-DEC-01 MAansari -Created
22 --
23
24 -- <Bug#2843596>
25 g_project_id NUMBER;
26 g_workplan_struct_id NUMBER;
27 g_financial_struct_id NUMBER;
28 g_sharing_enabled VARCHAR2(1);
29 -- </Bug#2843596>
30
31 PROCEDURE Create_default_structure
32 ( p_dest_project_id IN NUMBER
33 ,p_dest_project_name IN VARCHAR2
34 ,p_dest_project_number IN VARCHAR2
35 ,p_dest_description IN VARCHAR2
36 ,p_struc_type IN VARCHAR2 := 'WORKPLAN'
37 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
40
41
42 -- API name : create_default_task_structure
43 -- Type : PL/sql Public procedure
44 -- Pre-reqs : None
45 -- Return Value : N/A
46 -- Prameters
47 -- p_project_id IN NUMBER
48 -- x_msg_count OUT NUMBER
49 -- x_msg_data OUT VARCHAR2
50 -- x_return_status OUT VARCHAR2
51 --
52 -- History
53 --
54 -- 14-DEC-01 MAansari -Created
55 --
56 --
57
58 PROCEDURE create_default_task_structure
59 ( p_project_id IN NUMBER
60 ,p_struc_type IN VARCHAR2 := 'WORKPLAN'
61 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
62 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
64
65
66 -- API name : create_task_structure
67 -- Type : PL/sql Public procedure
68 -- Pre-reqs : None
69 -- Return Value : N/A
70 -- Prameters
71 -- p_project_id IN NUMBER
72 -- ,p_task_id IN NUMBER
73 -- ,p_parent_task_id IN NUMBER
74 -- ,p_task_number IN VARCHAR2
75 -- ,p_task_name IN VARCHAR2
76 -- ,p_task_description IN VARCHAR2
77 -- ,p_carrying_out_organization_id NUMBER
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2
80 -- x_return_status OUT VARCHAR2
81 --
82 -- History
83 --
84 -- 14-DEC-01 MAansari -Created
85 --
86 --
87
88 PROCEDURE create_task_structure(
89 p_calling_module IN VARCHAR2 := 'FORMS'
90 ,p_project_id IN NUMBER
91 ,p_task_id IN NUMBER
92 ,p_parent_task_id IN NUMBER
93 ,p_ref_task_id IN NUMBER := -9999
94 ,p_task_number IN VARCHAR2
95 ,p_task_name IN VARCHAR2
96 ,p_task_description IN VARCHAR2
97 ,p_carrying_out_organization_id IN NUMBER
98 ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
99 ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
100 ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
101 ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
102 ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
103 ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
104 ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
105 ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
106 ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
107 ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
108 ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
109 ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
110 ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
111 ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
112 ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
113 ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
114 ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
115 ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
116 ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
117 ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
118 ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
119 ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
120 ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
121 ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
122 ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
123 ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
124 ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
125 ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
126 ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
127 ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
128 ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
129 ,P_PM_SOURCE_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
130 ,p_location_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
131 ,p_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132 ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133 ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134 ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
135 ,p_phase_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
136 ,p_create_task_version_only IN VARCHAR2 := 'N'
137 ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
138
139 -- (begin venkat) new params for bug #3450684 ----------------------------------------------
140 ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
141 ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
142 ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
143 -- (end venkat) new params for bug #3450684 -------------------------------------------------
144
145 -- (begin) add new params bug - 3654243 -----
146 ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
147 ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148 ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
149 ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
150 ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
151 ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
152 ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
153 ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
154 ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
155 ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
156 ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
157 -- (end) add new params bug - 3654243 -----
158 --Bug 6046869
159 ,p_validate_dff IN VARCHAR2 := 'N'
160 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
161 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
162 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
163 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
164 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
165 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
166 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
167 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
168 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
169 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
170 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
171 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
172 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
173 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
174 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
175 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
176
177 ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
178 ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
179 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
180 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
182
183 -- API name : update_task_structure
184 -- Type : PL/sql Public procedure
185 -- Pre-reqs : None
186 -- Return Value : N/A
187 -- Prameters
188 -- p_calling_module IN VARCHAR2
189 -- ,p_task_id IN NUMBER
190 -- ,p_task_number IN VARCHAR2
191 -- ,p_task_name IN VARCHAR2
192 -- ,p_task_description IN VARCHAR2
193 -- ,p_carrying_out_organization_id IN NUMBER
194 -- ,p_task_manager_id IN NUMBER
195 -- ,p_pm_product_code IN VARCHAR2
196 -- ,p_pm_task_reference IN VARCHAR2
197 -- ,p_record_version_number IN NUMBER
198 -- ,x_msg_count OUT NUMBER
199 -- ,x_msg_data OUT VARCHAR2
200 -- ,x_return_status OUT VARCHAR2--
201 -- History
202 --
203 -- 25-APR-02 MAansari -Created
204 -- 05-APR-2004 Rakesh Raghavan Progress Management Changes. Bug # 3420093.
205 --
206 -- Notes: This api is called from form PAXPREPR.fmb ON-UPDATE of tasks block.
207 -- The call is in PA_PROJECT_STRUCTURES.update_task_structure API.
208
209 PROCEDURE update_task_structure
210 (
211 p_calling_module IN VARCHAR2 := 'FORMS'
212 ,p_ref_task_id IN NUMBER
213 ,p_project_id IN NUMBER
214 ,p_task_id IN NUMBER
215 ,p_task_number IN VARCHAR2
216 ,p_task_name IN VARCHAR2
217 ,p_task_description IN VARCHAR2
218 ,p_carrying_out_organization_id IN NUMBER
219 ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
220 ,p_task_manager_id IN NUMBER
221 ,p_pm_product_code IN VARCHAR2
222 ,p_pm_task_reference IN VARCHAR2
223 ,p_location_id IN NUMBER
224 ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
225 ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
226 ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
227 ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
228 ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
229 ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
230 ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
231 ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
232 ,P_OBLIGATION_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
233 ,P_OBLIGATION_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
234 ,P_ESTIMATED_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
235 ,P_ESTIMATED_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
236 ,P_BASELINE_START_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
237 ,P_BASELINE_FINISH_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
238 ,P_CLOSED_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
239 ,P_WQ_UOM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240 ,P_WQ_ITEM_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
241 ,P_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
242 ,P_WF_STATUS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243 ,P_PRIORITY_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244 ,P_MILESTONE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245 ,P_CRITICAL_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
246 ,P_INC_PROJ_PROGRESS_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
247 ,P_LINK_TASK_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248 ,P_CALENDAR_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
249 ,P_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
250 ,P_DURATION IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
251 ,P_PLANNED_WORK_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
252 ,P_TASK_TYPE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
253 ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
254 ,p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
255 ,p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
256 ,p_phase_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
257 -- (begin venkat) new params for bug #3450684 ----------------------------------------------
258 ,p_ext_act_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
259 ,p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
260 ,p_ext_sch_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug no 3450684
261 -- (end venkat) new params for bug #3450684 -------------------------------------------------
262 -- (begin) add new params bug - 3654243 -----
263 ,p_base_percent_comp_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
264 ,p_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
265 ,p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
266 ,p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
267 ,p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
268 ,p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
269 ,p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
270 ,p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
271 ,p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
272 ,p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
273 ,p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
274 -- (end) add new params bug - 3654243 -----
275
276 -- Progress Management Changes. Bug # 3420093.
277 ,p_etc_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
278 ,p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
279 -- Progress Management Changes. Bug # 3420093.
280 --rtarway, 3908013
281 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
282 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
283 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
284 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
285 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
286 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
287 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
288 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
289 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
290 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
291 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
292 --Bug 6046869
293 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
294 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
295 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
296 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
297 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
298 ,P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Added for Huawei 15876400
299 --end rtarway, 3908013
300 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
301 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
302 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
303
304 -- API name : delete_task_structure
305 -- Type : PL/sql Public procedure
306 -- Pre-reqs : None
307 -- Return Value : N/A
308 -- Prameters
309 -- p_calling_module IN VARCHAR2
310 -- ,p_task_id IN NUMBER
311 -- ,p_record_version_number IN NUMBER
312 -- ,x_msg_count OUT NUMBER
313 -- ,x_msg_data OUT VARCHAR2
314 -- ,x_return_status OUT VARCHAR2--
315 -- History
316 --
317 -- 25-APR-02 MAansari -Created
318 --
319 -- Notes: This api is called from form PAXPREPR.fmb ON-DELETE of tasks block.
320 -- The call is in PA_PROJECT_STRUCTURES.delete_task_structure API.
321
322 PROCEDURE delete_task_structure
323 (
324 p_calling_module IN VARCHAR2
325 ,p_task_id IN NUMBER
326 ,p_task_version_id IN NUMBER := -9999
327 ,p_project_id IN NUMBER := -9999 --bug 2765115
328 ,p_structure_type IN VARCHAR2 := 'FINANCIAL' --bug 3301192
329 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
330 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
331 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
332
333 -- API name : delete_project_structure
334 -- Type : PL/sql Public procedure
335 -- Pre-reqs : None
336 -- Return Value : N/A
337 -- Prameters
338 -- p_calling_module IN VARCHAR2
339 -- ,p_project_id IN NUMBER
340 -- ,x_msg_count OUT NUMBER
341 -- ,x_msg_data OUT VARCHAR2
342 -- ,x_return_status OUT VARCHAR2--
343 -- History
344 --
345 -- 26-APR-02 MAansari -Created
346 --
347 -- Notes: This api is called from form PAXPREPR.fmb ON-DELETE of tasks block.
348 -- The call is in PA_PROJECT_STRUCTURES.delete_task_structure API.
349
350 PROCEDURE delete_project_structure
351 (
352 p_calling_module IN VARCHAR2
353 ,p_project_id IN NUMBER
354 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
355 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
356 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
357
358 -- API name : Published_version_exists
359 -- Type : PL/sql Public Function
360 -- Pre-reqs : None
361 -- Return Value : N/A
362 -- Prameters
363 -- p_project_id IN NUMBER
364 -- History
365 --
366 -- 29-APR-02 MAansari -Created
367 --
368 -- Notes: This api is called from form PAXPREPR.fmb ON-DELETE of task block.
369 -- To check if there exists any published ver.
370
371 FUNCTION Published_version_exists
372 (
373 p_project_id IN NUMBER
374 ) RETURN VARCHAR2;
375
376 -- API name : approve_project
377 -- Type : PL/sql Public Function
378 -- Pre-reqs : None
379 -- Return Value : 'Y', 'N'
380 -- Prameters
381 -- p_project_id IN NUMBER
382 -- History
383 --
384 -- 29-APR-02 MAansari -Created
385 --
386 -- Notes: This api is called from Pa_project_stus_utils.Handle_Project_Status_Change api
387 -- to check the following before changing status to APPROVE.
388 -- 1) The project should contain one structure for Workplan and Costing
389 -- 2) There should be a published version.
390
391 FUNCTION approve_project
392 (
393 p_project_id IN NUMBER
394 ) RETURN VARCHAR2;
395
396 -- API name : Is_PJT_Licensed
397 -- Type : PL/sql Public Function
398 -- Pre-reqs : None
399 -- Return Value : 'Y', 'N'
400 -- Prameters
401 -- History
402 --
403 -- 01-MAY-02 MAansari -Created
404 --
405 -- Notes: This api is called from Projects form and Self Service to display SPLIT_COST_FROM_WORKPLAN_FLAG.
406
407 FUNCTION Is_PJT_Licensed RETURN VARCHAR2;
408
409 -- API name : Progress_rec_exists
410 -- Type : PL/sql Public Function
411 -- Pre-reqs : None
412 -- Return Value : 'Y', 'N'
413 -- Prameters
414 -- p_project_id NUMBER
415 -- History
416 --
417 -- 01-MAY-02 MAansari -Created
418 --
419 -- Notes: This api is called from Projects form and Self Service to allow users to update
420 -- SPLIT_COST_FROM_WORKPLAN_FLAG.
421
422 FUNCTION Progress_rec_exists( p_project_id NUMBER ) RETURN VARCHAR2;
423
424 -- API name : create_delete_workplan_struc
425 -- Type : PL/sql Public procedure
426 -- Pre-reqs : None
427 -- Return Value : N/A
428 -- Prameters
429 -- p_project_id NUMBER
430 -- p_calling_module IN VARCHAR2
431 -- p_project_id IN NUMBER
432 -- p_project_number IN VARCHAR2 := 'JUNK_CHARS'
433 -- p_project_name IN VARCHAR2 := 'JUNK_CHARS'
434 -- p_project_description IN VARCHAR2 := 'JUNK_CHARS'
435 -- p_split_workplan IN VARCHAR2
436 -- History
437 --
438 -- 01-MAY-02 MAansari -Created
439 --
440 -- Notes: This api is called from Projects form and Self Service when the SPLIT_COST_FROM_WORKPLAN_FLAG
441 -- is checked
442
443 PROCEDURE create_delete_workplan_struc(
444 p_calling_module IN VARCHAR2
445 ,p_project_id IN NUMBER
446 ,p_project_number IN VARCHAR2
447 ,p_project_name IN VARCHAR2
448 ,p_project_description IN VARCHAR2
449 ,p_split_workplan IN VARCHAR2
450 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
451 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
452 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
453 );
454
455 -- API name : Copy_Structure
456 -- Type : PL/sql Public procedure
457 -- Pre-reqs : None
458 -- Return Value : N/A
459 -- Prameters
460 -- p_src_project_id NUMBER
461 -- p_dest_project_id NUMBER
462 -- History
463 --
464 -- 03-MAY-02 MAansari -Created
465 --
466 -- Notes: This api is called from PA_PROJECT_CORE1.COPY_PROJECT
467
468 PROCEDURE Copy_Structure(
469 p_src_project_id IN NUMBER
470 ,p_dest_project_id IN NUMBER
471 ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
472 ,p_copy_task_flag IN VARCHAR2 := 'Y'
473 ,p_dest_template_flag IN VARCHAR2 := 'N' --bug 2805602
474 ,p_src_template_flag IN VARCHAR2 := 'N' --bug 2805602
475 ,p_dest_project_name IN VARCHAR2 --bug 2805602
476 ,p_target_start_date IN DATE --bug 2805602
477 ,p_target_finish_date IN DATE --bug 2805602
478 ,p_calendar_id IN NUMBER
479 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
480 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
481 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
482 );
483
484
485 -- API name : Clean_unwanted_tasks
486 -- Type : PL/sql Public procedure
487 -- Pre-reqs : None
488 -- Return Value : N/A
489 -- Prameters
490 -- p_project_id NUMBER
491 -- History
492 --
493 -- 25-MAY-02 MAansari -Created
494 --
495 -- Notes: This api is called from PA_PROJECT_PUB.CREATE_PROJECT to clean up the tasks in pa_proj_elements that were created
496 -- by calling copy structure api. Copy structure api copies template's tasks to pro_elements though there
497 -- are no pa_TASKs for the new project. However pa_tasks and pa_proj_elements must be in syn. To d this we need to firts remove
498 -- tasks from pa_proj_elements as they were erroneously created by COPY_STRUCTURE and then call create_default_structure
499 -- to syn up pa_pro_elements with pa_tasks.
500 --
501
502 PROCEDURE Clean_unwanted_tasks(
503 p_project_id IN NUMBER
504 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
505 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
506 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
507 ) ;
508
509 -- API name : get_task_above
510 -- Type : PL/sql Public procedure
511 -- Pre-reqs : None
512 -- Return Value : N/A
513 -- Prameters
514
515 -- History
516 --
517 -- 14-AUG-02 MAansari -Created
518 --
519 -- Notes: This api is called from Projects form and Self Service when the SPLIT_COST_FROM_WORKPLAN_FLAG
520 -- is checked
521
522 /*PROCEDURE get_task_above(
523 p_task_id IN NUMBER
524 ,p_tasks_in IN pa_project_pub.task_in_tbl_type
525 ,p_tasks_out IN pa_project_pub.task_out_tbl_type
526 ,x_task_id_above OUT NUMBER
527 ,x_return_status OUT VARCHAR2
528 );*/
529
530 -- API name : convert_pm_parent_task_ref
531 -- Type : PL/sql Public procedure
532 -- Pre-reqs : None
533 -- Return Value : N/A
534 -- Prameters
535
536 -- History
537 --
538 -- 14-AUG-02 MAansari -Created
539 --
540 -- Notes: This api is not included in PA_PROJECT_PVT to avoid dependency.
541
542 PROCEDURE convert_pm_parent_task_ref(
543 p_pm_parent_task_reference IN VARCHAR2
544 ,p_project_id IN NUMBER
545 ,x_parent_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
546 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
547 );
548
549 -- API name : publish_structure
550 -- Type : PL/sql Public procedure
551 -- Pre-reqs : None
552 -- Return Value : N/A
553 -- Prameters
554
555 -- History
556 --
557 -- 19-AUG-02 MAansari -Created
558 --
559 -- Notes: This api is a wrapper called from AMG
560
561 PROCEDURE publish_structure(
562 p_api_version IN NUMBER := 1.0
563 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
564 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
565 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
566 ,p_validation_level IN VARCHAR2 := 100
567 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
568 ,p_debug_mode IN VARCHAR2 := 'N'
569 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
570 ,p_responsibility_id IN NUMBER := 0
571 ,p_structure_version_id IN NUMBER
572 ,p_publish_structure_ver_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
573 ,p_structure_ver_desc IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
574 ,p_effective_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
575 ,p_original_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
576 ,p_current_baseline_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
577 ,x_published_struct_ver_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
578 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
579 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
580 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
581 );
582
583 -- API name : delete_structure_version
584 -- Type : PL/sql Public procedure
585 -- Pre-reqs : None
586 -- Return Value : N/A
587 -- Prameters
588
589 -- History
590 --
591 -- 19-AUG-02 MAansari -Created
592 --
593 -- Notes: This api is a wrapper called from AMG
594
595 PROCEDURE delete_structure_version(
596 p_api_version IN NUMBER := 1.0
597 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600 ,p_validation_level IN VARCHAR2 := 100
601 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
602 ,p_debug_mode IN VARCHAR2 := 'N'
603 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
604 ,p_structure_version_id IN NUMBER
605 ,p_record_version_number IN NUMBER
606 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
607 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
608 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
609 );
610
611 -- API name : create_structure
612 -- Type : PL/sql Public procedure
613 -- Pre-reqs : None
614 -- Return Value : N/A
615 -- Prameters
616
617 -- History
618 --
619 -- 19-AUG-02 HUBERT -Created
620 --
621 -- Notes: This api is a wrapper called from AMG
622
623 procedure create_structure(
624 p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
625 ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
626 ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
627 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
628 ,x_structure_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
629 ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
630 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
631 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
632 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
633 );
634
635 -- API name : create_update_struct_ver
636 -- Type : PL/sql Public procedure
637 -- Pre-reqs : None
638 -- Return Value : N/A
639 -- Prameters
640
641 -- History
642 --
643 -- 19-AUG-02 HUBERT -Created
644 --
645 -- Notes: This api is a wrapper called from AMG
646
647 procedure create_update_struct_ver(
648 p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
649 ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650 ,p_structure_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651 ,p_structure_version_id IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
652 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
653 ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
654 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
655 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
656 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
657 );
658
659 -- API name : IS_WP_SEPARATE_FROM_FN
660 -- Type : PL/sql Public Function
661 -- Pre-reqs : None
662 -- Return Value : 'Y', 'N'
663 -- Prameters
664 -- p_project_id IN NUMBER
665 -- History
666 --
667 -- 21-AUG-02 MAansari -Created
668 --
669 -- Notes: This api is returns 'Y' if WORKPLAN is separate from
670 -- FINANCIAL structure
671
672 FUNCTION IS_WP_SEPARATE_FROM_FN
673 (
674 p_project_id IN NUMBER
675 ) RETURN VARCHAR2;
676
677
678 -- API name : IS_WP_VERSIONING_ENABLED
679 -- Type : PL/sql Public Function
680 -- Pre-reqs : None
681 -- Return Value : 'Y', 'N'
682 -- Prameters
683 -- p_project_id IN NUMBER
684 -- History
685 --
686 -- 22-AUG-02 MAansari -Created
687 --
688 -- Notes: This api is returns 'Y' if WORKPLAN is separate from
689 -- FINANCIAL structure
690
691 FUNCTION IS_WP_VERSIONING_ENABLED
692 (
693 p_project_id IN NUMBER
694 ) RETURN VARCHAR2;
695
696 -- API name : get_proj_dates_delta
697 -- Type : PL/sql Public Function
698 -- Pre-reqs : None
699 -- Return Value : NUMBER
700 -- Prameters
701 -- p_project_id IN NUMBER
702 -- History
703 --
704 -- 22-AUG-02 MAansari -Created
705 --
706 -- Notes:
707
708 -- get original project start and completion dates
709 -- determine the shift days (delta).
710 -- delta = new project start date - nvl(old project start date,
711 -- earlist task start date)
712
713 -- old project new project
714 -- case start date start date new start date new end date
715 -- ---- ----------- ----------- ----------------- -----------------
716 -- A not null not null old start date old end date
717 -- + delta + delta
718 -- B-1 null not null old start date old end date
719 -- (old task has start date) + delta + delta
720 -- B-2 null not null new proj start new proj completion
721 -- (old task has no start date) date date
722 -- C not null null old start date old end date
723 -- D null null old start date old end date
724
725 FUNCTION get_proj_dates_delta(
726 x_orig_project_id IN NUMBER
727 ,x_start_date IN DATE )
728 RETURN NUMBER;
729
730 -- API name : create_task_structure2
731 -- Type : PL/sql Public procedure
732 -- Pre-reqs : None
733 -- Return Value : N/A
734 -- Prameters
735 -- p_project_id IN NUMBER
736 -- ,p_task_id IN NUMBER
737 -- ,p_parent_task_id IN NUMBER
738 -- ,p_task_number IN VARCHAR2
739 -- ,p_task_name IN VARCHAR2
740 -- ,p_task_description IN VARCHAR2
741 -- ,p_carrying_out_organization_id NUMBER
742 -- x_msg_count OUT NUMBER
743 -- x_msg_data OUT VARCHAR2
744 -- x_return_status OUT VARCHAR2
745 --
746 -- History
747 --
748 -- 22-AUG-01 MAansari -Created
749 --
750 -- Notes : THis is API is created to avoid the Implementation level error that is thrown
751 -- in the forms if any parameter with default containg a remote package variable is referenced.
752
753 PROCEDURE create_task_structure2(
754 p_calling_module IN VARCHAR2 := 'FORMS'
755 ,p_project_id IN NUMBER
756 ,p_task_id IN NUMBER
757 ,p_parent_task_id IN NUMBER
758 ,p_ref_task_id IN NUMBER := -9999
759 ,p_task_number IN VARCHAR2
760 ,p_task_name IN VARCHAR2
761 ,p_task_description IN VARCHAR2
762 ,p_carrying_out_organization_id IN NUMBER
763 ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
764 ,P_PM_SOURCE_reference IN VARCHAR2
765 ,P_PM_SOURCE_code IN VARCHAR2
766 ,p_task_manager_id IN NUMBER
767 ,p_location_id IN NUMBER
768 ,p_financial_task_flag IN VARCHAR2 := 'Y' --bug 3301192
769 ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
770 ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
771 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
772 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
773 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
774
775 -- API name : update_task_structure2
776 -- Type : PL/sql Public procedure
777 -- Pre-reqs : None
778 -- Return Value : N/A
779 -- Prameters
780 -- p_calling_module IN VARCHAR2
781 -- ,p_task_id IN NUMBER
782 -- ,p_task_number IN VARCHAR2
783 -- ,p_task_name IN VARCHAR2
784 -- ,p_task_description IN VARCHAR2
785 -- ,p_carrying_out_organization_id IN NUMBER
786 -- ,p_task_manager_id IN NUMBER
787 -- ,p_pm_product_code IN VARCHAR2
788 -- ,p_pm_task_reference IN VARCHAR2
789 -- ,p_record_version_number IN NUMBER
790 -- ,x_msg_count OUT NUMBER
791 -- ,x_msg_data OUT VARCHAR2
792 -- ,x_return_status OUT VARCHAR2--
793 -- History
794 --
795 -- 22-AUG-02 MAansari -Created
796 --
797 -- Notes : THis is API is created to avoid the Implementation level error that is thrown
798 -- in the forms if any parameter with default containg a remote package variable is referenced.
799
800 PROCEDURE update_task_structure2
801 (
802 p_calling_module IN VARCHAR2 := 'FORMS'
803 ,p_ref_task_id IN NUMBER
804 ,p_project_id IN NUMBER
805 ,p_task_id IN NUMBER
806 ,p_task_number IN VARCHAR2
807 ,p_task_name IN VARCHAR2
808 ,p_task_description IN VARCHAR2
809 ,p_carrying_out_organization_id IN NUMBER
810 ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
811 ,p_task_manager_id IN NUMBER
812 ,p_pm_product_code IN VARCHAR2
813 ,p_pm_task_reference IN VARCHAR2
814 ,p_location_id IN NUMBER
815 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
816 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
817 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
818
819 -- API name : get_struc_task_ver_ids
820 -- Type : PL/sql Public Function
821 -- Pre-reqs : None
822 -- Return Value : N/A
823 -- Prameters
824 -- p_project_id IN NUMBER
825 -- History
826 --
827 -- 26-AUG-02 MAansari -Created
828 --
829 -- Notes: This api returns task_version_id and parent_structure_version_id for the tasks
830 -- displayed in Forms.
831
832 PROCEDURE get_struc_task_ver_ids
833 (
834 p_project_id IN NUMBER
835 ,p_task_id IN NUMBER
836 ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
837 ,x_parent_struc_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
838 );
839
840 -- API name : WP_STR_EXISTS
841 -- Type : PL/sql Public Function
842 -- Pre-reqs : None
843 -- Return Value : 'Y', 'N'
844 -- Prameters
845 -- p_project_id IN NUMBER
846 -- History
847 --
848 -- 21-AUG-02 MAansari -Created
849 --
850 -- Notes: This api is returns 'TRUE' if WORKPLAN str exists
851
852 FUNCTION WP_STR_EXISTS
853 (
854 p_project_id IN NUMBER
855 ) RETURN VARCHAR2;
856
857 FUNCTION DATE_SYNC_UP_METHOD
858 (
859 p_project_id IN NUMBER
860 ) RETURN VARCHAR2;
861
862 PROCEDURE update_trans_dates(
863 p_project_id IN NUMBER
864 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
865 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
866 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
867
868
869 PROCEDURE update_wp_calendar(
870 p_project_id IN NUMBER
871 ,p_calendar_id IN NUMBER
872 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
873 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
874 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
875 );
876
877
878
879 /*
880 This api is created to create task versions when updating a project.
881 When you update a project you can create a working structure version and add
882 the existing tasks to the new str version. In this case the api should create task versions
883 but not tasks.
884 */
885
886 PROCEDURE create_tasks_versions_only(
887 p_calling_module IN VARCHAR2 := 'FORMS'
888 ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
889 ,p_project_id IN NUMBER
890 ,p_structure_version_id IN NUMBER
891 ,p_pm_product_code IN VARCHAR2 := 'JUNK_CHARS'
892 ,p_tasks_in IN pa_project_pub.task_in_tbl_type
893 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
894 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
895 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
896
897
898 --FUNCTION check_multiple_version
899
900 PROCEDURE recalc_task_weightings(
901 p_tasks_in IN pa_project_pub.task_out_tbl_type
902 ,p_task_version_id IN NUMBER
903 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
904 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
905 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
906
907 FUNCTION GET_MAX_LAST_UPD_DT_WRKNG_VER
908 ( p_structure_version_id IN NUMBER
909 ) return DATE;
910
911 PROCEDURE copy_structures_tasks_bulk
912 ( p_api_version IN NUMBER := 1.0
913 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
914 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
915 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
916 ,p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
917 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
918 ,p_debug_mode IN VARCHAR2 := 'N'
919 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
920 ,p_src_project_id IN NUMBER
921 ,p_dest_project_id IN NUMBER
922 ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
923 ,p_copy_task_flag IN VARCHAR2 := 'Y'
924 ,p_dest_template_flag IN VARCHAR2 := 'N' --bug 2805602
925 ,p_src_template_flag IN VARCHAR2 := 'N' --bug 2805602
926 ,p_dest_project_name IN VARCHAR2 --bug 2805602
927 ,p_target_start_date IN DATE
928 ,p_target_finish_date IN DATE
929 ,p_calendar_id IN NUMBER
930 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
931 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
932 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
933
934 FUNCTION get_adjusted_dates(
935 p_target_start_date DATE
936 ,p_target_finish_date DATE
937 ,p_delta NUMBER
938 ,p_scheduled_start_date DATE
939 ,p_scheduled_finish_date DATE
940 ) RETURN DATE;
941
942 PROCEDURE copy_structures_bulk
943 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
944 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
945 ,p_validation_level IN VARCHAR2 := 100
946 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
947 ,p_debug_mode IN VARCHAR2 := 'N'
948 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
949 ,p_src_project_id IN NUMBER
950 ,p_dest_project_id IN NUMBER
951 ,p_delta IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
952 ,p_copy_task_flag IN VARCHAR2 := 'Y'
953 ,p_dest_template_flag IN VARCHAR2 := 'N' --bug 2805602
954 ,p_src_template_flag IN VARCHAR2 := 'N' --bug 2805602
955 ,p_dest_project_name IN VARCHAR2 --bug 2805602
956 ,p_target_start_date IN DATE
957 ,p_target_finish_date IN DATE
958 ,p_calendar_id IN NUMBER
959 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
960 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
961 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
962
963 FUNCTION calc_duration( p_calendar_id NUMBER, p_start_date DATE, p_finish_date DATE ) RETURN NUMBER;
964
965 PROCEDURE get_version_ids(
966 p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
967 ,p_task_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
968 ,p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
969 ,x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
970 ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
971 );
972
973 PROCEDURE get_task_version_id(
974 p_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
975 ,p_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
976 ,p_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
977 ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
978 );
979
980 PROCEDURE rollup_dates(
981 p_tasks_in IN pa_project_pub.task_out_tbl_type
982 ,p_task_version_id IN NUMBER := null
983 ,p_structure_version_id IN NUMBER
984 ,p_project_id IN NUMBER
985 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
986 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
987 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
988
989 -- API included for Post FP K one off Bug 2931183
990 PROCEDURE PROCESS_TASK_STRUCTURE_BULK
991 ( p_api_version_number IN NUMBER := 1.0
992 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
993 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
994 ,p_calling_module IN VARCHAR2 := 'AMG'
995 ,p_project_id IN pa_projects_all.project_id%TYPE
996 --ADUT. The following parameter is required to identify if the source is project/template.
997 --This will be passed only from create_project context.
998 ,p_source_project_id IN pa_projects_all.project_id%TYPE := NULL
999 ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
1000 ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
1001 ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type
1002 ,p_create_task_version_only IN VARCHAR2 := 'N'
1003 ,p_wp_str_exists IN VARCHAR2
1004 ,p_is_wp_separate_from_fn IN VARCHAR2
1005 ,p_is_wp_versioning_enabled IN VARCHAR2
1006 ,p_structure_version_id IN pa_proj_elem_ver_structure.element_version_id%TYPE --IUP: Impact of calling from Update_project
1007 -- Included NOCOPY for the following parameter. Bug 2931183.
1008 -- PA L Changes 3010538
1009 ,p_process_mode IN VARCHAR2 := 'ONLINE'
1010 -- Bug 3075609. To identify create task version only context.
1011 ,p_create_task_versions_only IN VARCHAR2 := 'N'
1012 ,px_tasks_out_tbl IN OUT NOCOPY pa_project_pub.task_out_tbl_type
1013 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1014 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1015 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1016
1017
1018 PROCEDURE delete_fin_plan_from_task(
1019 p_task_id NUMBER
1020 ,p_project_id NUMBER
1021 ,p_calling_module VARCHAR2 := 'FORMS'
1022 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1023 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1024 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1025
1026 --Bug 3010538 : New API for the Task Weighting Enhancement.
1027 PROCEDURE PROCESS_WBS_UPDATES_WRP
1028 ( p_api_version_number IN NUMBER := 1.0
1029 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1030 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1031 ,p_calling_context IN VARCHAR2 := 'UPDATE'
1032 ,p_project_id IN pa_projects_all.project_id%TYPE
1033 ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1034 ,p_pub_struc_ver_id IN NUMBER := NULL
1035 ,p_pub_prog_flag IN VARCHAR2 := 'Y' --bug 4019845
1036 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1037 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1038 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1039
1040 --Bug 3010538 : New API for the Task Weighting Enhancement.
1041 PROCEDURE PROCESS_WBS_UPDATES_CONC_WRP
1042 ( p_api_version_number IN NUMBER := 1.0
1043 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1044 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1045 ,p_calling_context IN VARCHAR2 := 'UPDATE'
1046 ,p_project_id IN pa_projects_all.project_id%TYPE
1047 ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1048 ,p_pub_struc_ver_id IN NUMBER := NULL
1049 ,p_pub_prog_flag IN VARCHAR2 := 'Y' --bug 4019845
1050 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1051 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1052 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1053
1054 --Bug 3010538 : New API for the Task Weighting Enhancement.
1055 PROCEDURE PROCESS_WBS_UPDATES_CONC
1056 ( errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1057 ,Retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1058 ,p_calling_context IN VARCHAR2 := 'UPDATE'
1059 ,p_project_id IN pa_projects_all.project_id%TYPE
1060 ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1061 ,p_pub_struc_ver_id IN NUMBER := NULL
1062 ,p_pub_prog_flag IN VARCHAR2 := 'Y' --bug 4019845
1063 ,p_rerun_flag IN VARCHAR2 := null --bug 4589289
1064 );
1065
1066 --Bug 3010538 : New API for the Task Weighting Enhancement.
1067 PROCEDURE PROCESS_WBS_UPDATES
1068 ( p_api_version_number IN NUMBER := 1.0
1069 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1070 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1071 ,p_calling_context IN VARCHAR2 := 'UPDATE'
1072 ,p_project_id IN pa_projects_all.project_id%TYPE
1073 ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1074 ,p_pub_struc_ver_id IN NUMBER := NULL
1075 ,p_pub_prog_flag IN VARCHAR2 := 'Y' --bug 4019845
1076 ,p_rerun_flag IN VARCHAR2 := null --bug 4589289
1077 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1078 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1079 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1080
1081 --Bug 3010538 : New API for the Task Weighting Enhancement.
1082 PROCEDURE PROCESS_TASK_WEIGHTAGE
1083 ( p_api_version_number IN NUMBER := 1.0
1084 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1085 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1086 ,p_calling_context IN VARCHAR2 := 'SELF_SERVICE'
1087 ,p_project_id IN pa_projects_all.project_id%TYPE
1088 ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1089 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1090 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1091 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1092
1093 --Bug 3010538 : New API for the Task Weighting Enhancement.
1094 PROCEDURE SET_UPDATE_WBS_FLAG
1095 ( p_api_version_number IN NUMBER := 1.0
1096 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1097 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1098 ,p_calling_context IN VARCHAR2 := 'SELF_SERVICE'
1099 ,p_project_id IN pa_projects_all.project_id%TYPE
1100 ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1101 ,p_update_wbs_flag IN pa_proj_elem_ver_structure.process_update_wbs_flag%TYPE := 'Y'
1102 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1103 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1104 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1105
1106 PROCEDURE PROCESS_WBS_UPDATES_WRP_FORM
1107 ( p_project_id IN pa_projects_all.project_id%TYPE
1108 ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1109 ,p_pub_struc_ver_id IN NUMBER := NULL
1110 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1111 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1112 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
1113
1114 --bug 3035902 maansari
1115 PROCEDURE call_process_WBS_updates(
1116 p_dest_project_id IN NUMBER
1117 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1118 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1119 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1120 );
1121
1122 PROCEDURE Update_Current_Phase
1123 ( p_api_version_number IN NUMBER := 1.0
1124 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1125 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1126 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1127 ,p_validation_level IN VARCHAR2 := 100
1128 ,p_debug_mode IN VARCHAR2 := 'N'
1129 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1130 ,p_user_id IN NUMBER := FND_GLOBAL.USER_ID
1131 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1132 ,p_project_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1133 ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
1134 ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
1135 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1136 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1137 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1138 );
1139
1140 --------------------------------- Added for FP_M changes : Bhumesh
1141 -- Refer to Tracking bug 3305199 for details
1142 -- To import Source Ref, Sub Type and Lag days into the system from an
1143 -- input string parameter
1144 Procedure Parse_Predecessor_Import (
1145 P_String IN VARCHAR2,
1146 P_Delimeter IN VARCHAR2 DEFAULT ',',
1147 P_Task_Version_Id IN NUMBER, --SMUKKA Added this parameter
1148 X_Return_Status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1149 X_Msg_Count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1150 X_Msg_Data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1151 );
1152
1153 -- To export Source Ref, Sub Type and Lag Types from the system to an
1154 -- out string parameter for a given element version ID
1155 Function Parse_Predecessor_Export (
1156 P_Element_Version_ID IN NUMBER,
1157 P_Delimeter IN VARCHAR2 DEFAULT ','
1158 ) RETURN VARCHAR2;
1159 --------------------------------- End of FP_M changes : Bhumesh
1160
1161 Function Parse_Predecessor_Export2 (
1162 P_Element_Version_ID IN NUMBER,
1163 P_Delimeter IN VARCHAR2 DEFAULT ','
1164 ) RETURN VARCHAR2;
1165 --Added by rtarway FP.M Developement
1166 Function GET_SHARE_TYPE (
1167 P_Project_ID IN NUMBER
1168 ) RETURN VARCHAR2;
1169 --Added by rtarway FP.M Developement
1170
1171
1172 PROCEDURE delete_intra_dependency (p_element_version_id IN NUMBER,
1173 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1174 p_debug_mode IN VARCHAR2 := 'N',
1175 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1176 END PA_PROJ_TASK_STRUC_PUB;