[Home] [Help]
148: --End FPM changes bug 330119
149: p_Base_Perc_Comp_Deriv_Code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
150: -- This param added for FP_M changes 3305199
151: -- Bug#3491609 : Workflow Chanegs FP M
152: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
153: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
154: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
155: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
156: -- Bug#3491609 : Workflow Chanegs FP M
149: p_Base_Perc_Comp_Deriv_Code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
150: -- This param added for FP_M changes 3305199
151: -- Bug#3491609 : Workflow Chanegs FP M
152: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
153: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
154: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
155: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
156: -- Bug#3491609 : Workflow Chanegs FP M
157: x_task_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
150: -- This param added for FP_M changes 3305199
151: -- Bug#3491609 : Workflow Chanegs FP M
152: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
153: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
154: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
155: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
156: -- Bug#3491609 : Workflow Chanegs FP M
157: x_task_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
158: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
151: -- Bug#3491609 : Workflow Chanegs FP M
152: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
153: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
154: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
155: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
156: -- Bug#3491609 : Workflow Chanegs FP M
157: x_task_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
158: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
159: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
169: l_error_message_code VARCHAR2(250);
170:
171: l_carrying_out_org_id NUMBER;
172:
173: l_task_description PA_PROJ_ELEMENTS.description%TYPE;
174: l_location_id NUMBER;
175: --l_country
176: --l_territory_code
177: --l_state_region
176: --l_territory_code
177: --l_state_region
178: --l_city
179: l_task_manager_id NUMBER;
180: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
181: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
182: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
183: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
184: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
177: --l_state_region
178: --l_city
179: l_task_manager_id NUMBER;
180: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
181: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
182: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
183: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
184: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
185: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
178: --l_city
179: l_task_manager_id NUMBER;
180: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
181: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
182: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
183: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
184: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
185: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
186: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
179: l_task_manager_id NUMBER;
180: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
181: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
182: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
183: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
184: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
185: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
186: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
187: --l_scheduled_start_date
180: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
181: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
182: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
183: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
184: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
185: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
186: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
187: --l_scheduled_start_date
188: --l_scheduled_finish_date
181: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
182: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
183: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
184: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
185: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
186: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
187: --l_scheduled_start_date
188: --l_scheduled_finish_date
189: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
182: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
183: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
184: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
185: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
186: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
187: --l_scheduled_start_date
188: --l_scheduled_finish_date
189: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
190: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
185: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
186: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
187: --l_scheduled_start_date
188: --l_scheduled_finish_date
189: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
190: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
191: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
186: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
187: --l_scheduled_start_date
188: --l_scheduled_finish_date
189: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
190: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
191: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
187: --l_scheduled_start_date
188: --l_scheduled_finish_date
189: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
190: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
191: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
188: --l_scheduled_finish_date
189: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
190: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
191: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
189: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
190: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
191: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
190: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
191: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
191: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
192: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
193: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
194: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
195: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
196: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
204: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
197: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
204: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
205: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
198: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
204: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
205: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
206: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
199: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
204: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
205: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
206: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
207: --hsiu
200: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
204: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
205: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
206: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
207: --hsiu
208: --added for advanced structure - versioning
201: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
204: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
205: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
206: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
207: --hsiu
208: --added for advanced structure - versioning
209: l_versioned VARCHAR2(1) := 'N';
202: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
203: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
204: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
205: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
206: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
207: --hsiu
208: --added for advanced structure - versioning
209: l_versioned VARCHAR2(1) := 'N';
210: l_shared VARCHAR2(1) := 'N';
228: l_tk_attribute10 pa_tasks.attribute10%TYPE;
229: -- end xxlu changes
230:
231: -- Bug#3491609 : Workflow Chanegs FP M
232: l_wf_item_type pa_proj_elements.wf_item_type%TYPE;
233: l_wf_process pa_proj_elements.wf_process%TYPE;
234: l_wf_lead_days pa_proj_elements.wf_start_lead_days%TYPE;
235: l_wf_enabled_flag pa_proj_elements.enable_wf_flag%TYPE;
236: -- Bug#3491609 : Workflow Chanegs FP M
229: -- end xxlu changes
230:
231: -- Bug#3491609 : Workflow Chanegs FP M
232: l_wf_item_type pa_proj_elements.wf_item_type%TYPE;
233: l_wf_process pa_proj_elements.wf_process%TYPE;
234: l_wf_lead_days pa_proj_elements.wf_start_lead_days%TYPE;
235: l_wf_enabled_flag pa_proj_elements.enable_wf_flag%TYPE;
236: -- Bug#3491609 : Workflow Chanegs FP M
237:
230:
231: -- Bug#3491609 : Workflow Chanegs FP M
232: l_wf_item_type pa_proj_elements.wf_item_type%TYPE;
233: l_wf_process pa_proj_elements.wf_process%TYPE;
234: l_wf_lead_days pa_proj_elements.wf_start_lead_days%TYPE;
235: l_wf_enabled_flag pa_proj_elements.enable_wf_flag%TYPE;
236: -- Bug#3491609 : Workflow Chanegs FP M
237:
238: --Modified pa_tasks to pa_proj_elements in the following local variables Bug 3809523
231: -- Bug#3491609 : Workflow Chanegs FP M
232: l_wf_item_type pa_proj_elements.wf_item_type%TYPE;
233: l_wf_process pa_proj_elements.wf_process%TYPE;
234: l_wf_lead_days pa_proj_elements.wf_start_lead_days%TYPE;
235: l_wf_enabled_flag pa_proj_elements.enable_wf_flag%TYPE;
236: -- Bug#3491609 : Workflow Chanegs FP M
237:
238: --Modified pa_tasks to pa_proj_elements in the following local variables Bug 3809523
239: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
234: l_wf_lead_days pa_proj_elements.wf_start_lead_days%TYPE;
235: l_wf_enabled_flag pa_proj_elements.enable_wf_flag%TYPE;
236: -- Bug#3491609 : Workflow Chanegs FP M
237:
238: --Modified pa_tasks to pa_proj_elements in the following local variables Bug 3809523
239: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
240: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
241:
242: cursor get_page_name(c_page_id NUMBER)
235: l_wf_enabled_flag pa_proj_elements.enable_wf_flag%TYPE;
236: -- Bug#3491609 : Workflow Chanegs FP M
237:
238: --Modified pa_tasks to pa_proj_elements in the following local variables Bug 3809523
239: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
240: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
241:
242: cursor get_page_name(c_page_id NUMBER)
243: IS
236: -- Bug#3491609 : Workflow Chanegs FP M
237:
238: --Modified pa_tasks to pa_proj_elements in the following local variables Bug 3809523
239: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
240: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
241:
242: cursor get_page_name(c_page_id NUMBER)
243: IS
244: SELECT page_name
286: and project_id = p_project_id
287: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
288: --end bug 3074706
289:
290: -- should be checking for tasks in pa_proj_elements table.
291:
292: /*4156271 : Performance Fix - Commented the following Query for Performance reasons
293: CURSOR cur_chk_pa_tasks
294: IS
292: /*4156271 : Performance Fix - Commented the following Query for Performance reasons
293: CURSOR cur_chk_pa_tasks
294: IS
295: SELECT 'x'
296: FROM pa_tasks pt, pa_proj_elements ppe
297: WHERE pt.project_id = p_project_id
298: AND pt.task_id = ppe.proj_element_id
299: AND ppe.link_task_flag = 'N';
300: */
304: SELECT 'x'
305: FROM pa_tasks pt
306: WHERE pt.project_id = p_project_id
307: AND EXISTS(SELECT 1
308: FROM PA_PROJ_ELEMENTS ppe
309: WHERE ppe.link_task_flag = 'N'
310: AND ppe.project_id = p_project_id
311: );
312: /*End : Fix for 4156271 */
320: --structure version id.
321:
322: CURSOR cur_ref_loc_id
323: IS
324: SELECT location_id from pa_proj_elements where proj_element_id = p_ref_task_id;
325:
326: l_publised_version VARCHAR2(1);
327: l_dummy_char VARCHAR2(1);
328: l_dummy_char2 VARCHAR2(1);
335: INITIAL_STATUS_CODE, BASE_PERCENT_COMP_DERIV_CODE,
336: wf_item_type,wf_process,wf_start_lead_days
337: from pa_task_types
338: where task_type_id = c_task_type_id;
339: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
340: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
341: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
342: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
343: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
336: wf_item_type,wf_process,wf_start_lead_days
337: from pa_task_types
338: where task_type_id = c_task_type_id;
339: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
340: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
341: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
342: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
343: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
344: l_INITIAL_STATUS_CODE PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
337: from pa_task_types
338: where task_type_id = c_task_type_id;
339: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
340: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
341: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
342: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
343: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
344: l_INITIAL_STATUS_CODE PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
345:
338: where task_type_id = c_task_type_id;
339: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
340: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
341: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
342: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
343: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
344: l_INITIAL_STATUS_CODE PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
345:
346: --Bug 2947492
339: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
340: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
341: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
342: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
343: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
344: l_INITIAL_STATUS_CODE PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
345:
346: --Bug 2947492
347:
340: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
341: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
342: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
343: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
344: l_INITIAL_STATUS_CODE PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
345:
346: --Bug 2947492
347:
348: --Bug 3305199: commented out for M
422:
423: --Bug 2168170
424: --dbms_output.put_line('Inside private API');
425: --dbms_output.put_line( 'Check if the task name is unique within the project.'||l_task_number);
426: IF PA_PROJ_ELEMENTS_UTILS.Check_element_number_Unique
427: (
428: p_element_number => l_task_number --Bug 3705333 Changed from p_task_number to l_task_number
429: ,p_element_id => null
430: ,p_project_id => p_project_id
440: --end bug 2669388
441: --dbms_output.put_line( 'After Check if the task name is unique within the project.' );
442:
443: --Check if the task name is unique within the project
444: If (PA_PROJ_ELEMENTS_UTILS.check_element_number_unique(l_task_number, --Bug 3705333 Changed from p_task_number to l_task_number
445: NULL,
446: p_project_id,
447: p_structure_id) <> 'Y') THEN
448: --Name is not unique
548: IF ( p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_TYPE_ID IS NULL )
549: THEN
550: --IF (p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_type = 'PA_TASKS') THEN
551: IF (p_object_type = 'PA_TASKS') THEN
552: l_TYPE_ID := PA_PROJ_ELEMENTS_UTILS.GET_DEFAULT_TASK_TYPE_ID;
553: ELSE
554: l_TYPE_ID := NULL;
555: END IF;
556: ELSE
889: l_wf_process := nvl(p_wf_process,l_wf_process);
890: l_wf_lead_days := nvl(p_wf_lead_days,l_wf_lead_days);
891: -- 3491609 : FP M : Tracking bug : Workflow Excecution
892:
893: PA_PROJ_ELEMENTS_PKG.Insert_Row(
894: X_ROW_ID => X_ROW_ID
895: ,X_PROJ_ELEMENT_ID => x_task_id
896: ,X_PROJECT_ID => p_project_id
897: ,X_OBJECT_TYPE => p_OBJECT_TYPE
1484: p_Base_Perc_Comp_Deriv_Code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1485: -- This param added for FP_M changes 3305199
1486: p_gen_etc_src_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1487: -- Bug#3491609 : Workflow Chanegs FP M
1488: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
1489: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
1490: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
1491: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
1492: -- Bug#3491609 : Workflow Chanegs FP M
1485: -- This param added for FP_M changes 3305199
1486: p_gen_etc_src_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1487: -- Bug#3491609 : Workflow Chanegs FP M
1488: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
1489: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
1490: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
1491: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
1492: -- Bug#3491609 : Workflow Chanegs FP M
1493: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1486: p_gen_etc_src_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1487: -- Bug#3491609 : Workflow Chanegs FP M
1488: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
1489: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
1490: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
1491: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
1492: -- Bug#3491609 : Workflow Chanegs FP M
1493: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1494: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1487: -- Bug#3491609 : Workflow Chanegs FP M
1488: p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
1489: p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
1490: p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
1491: p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
1492: -- Bug#3491609 : Workflow Chanegs FP M
1493: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1494: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1495: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1505: l_change_allowed VARCHAR2(1);
1506:
1507: l_carrying_out_org_id NUMBER;
1508:
1509: l_task_description PA_PROJ_ELEMENTS.description%TYPE;
1510: l_location_id NUMBER;
1511: --l_country
1512: --l_territory_code
1513: --l_state_region
1512: --l_territory_code
1513: --l_state_region
1514: --l_city
1515: l_task_manager_id NUMBER;
1516: l_task_name PA_PROJ_ELEMENTS.name%TYPE;
1517: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
1518: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1513: --l_state_region
1514: --l_city
1515: l_task_manager_id NUMBER;
1516: l_task_name PA_PROJ_ELEMENTS.name%TYPE;
1517: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
1518: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1514: --l_city
1515: l_task_manager_id NUMBER;
1516: l_task_name PA_PROJ_ELEMENTS.name%TYPE;
1517: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
1518: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1522: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
1515: l_task_manager_id NUMBER;
1516: l_task_name PA_PROJ_ELEMENTS.name%TYPE;
1517: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
1518: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1522: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
1523: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
1516: l_task_name PA_PROJ_ELEMENTS.name%TYPE;
1517: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
1518: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1522: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
1523: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
1524: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
1517: l_priority_code PA_PROJ_ELEMENTS.priority_code%TYPE;
1518: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1522: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
1523: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
1524: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
1525: --l_scheduled_start_date
1518: l_TYPE_ID PA_PROJ_ELEMENTS.TYPE_ID %TYPE;
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1522: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
1523: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
1524: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
1525: --l_scheduled_start_date
1526: --l_scheduled_finish_date
1519: l_status_code PA_PROJ_ELEMENTS.status_code%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1522: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
1523: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
1524: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
1525: --l_scheduled_start_date
1526: --l_scheduled_finish_date
1527: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
1520: l_wf_status_code PA_PROJ_ELEMENTS.wf_status_code%TYPE;
1521: l_inc_proj_progress_flag PA_PROJ_ELEMENTS.inc_proj_progress_flag%TYPE;
1522: l_pm_product_code VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_product_code%TYPE;
1523: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
1524: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
1525: --l_scheduled_start_date
1526: --l_scheduled_finish_date
1527: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
1528: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
1523: l_pm_task_reference VARCHAR2(30); --PA_PROJ_ELEMENTS.pm_task_reference%TYPE;
1524: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
1525: --l_scheduled_start_date
1526: --l_scheduled_finish_date
1527: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
1528: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
1529: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1524: l_closed_date PA_PROJ_ELEMENTS.closed_date%TYPE;
1525: --l_scheduled_start_date
1526: --l_scheduled_finish_date
1527: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
1528: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
1529: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1525: --l_scheduled_start_date
1526: --l_scheduled_finish_date
1527: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
1528: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
1529: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1526: --l_scheduled_finish_date
1527: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
1528: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
1529: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1527: l_attribute_category PA_PROJ_ELEMENTS.attribute_category%TYPE;
1528: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
1529: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1528: l_attribute1 PA_PROJ_ELEMENTS.attribute1%TYPE;
1529: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1529: l_attribute2 PA_PROJ_ELEMENTS.attribute2%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1530: l_attribute3 PA_PROJ_ELEMENTS.attribute3%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1531: l_attribute4 PA_PROJ_ELEMENTS.attribute4%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1532: l_attribute5 PA_PROJ_ELEMENTS.attribute5%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1533: l_attribute6 PA_PROJ_ELEMENTS.attribute6%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1534: l_attribute7 PA_PROJ_ELEMENTS.attribute7%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1535: l_attribute8 PA_PROJ_ELEMENTS.attribute8%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1536: l_attribute9 PA_PROJ_ELEMENTS.attribute9%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1537: l_attribute10 PA_PROJ_ELEMENTS.attribute10%TYPE;
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1545:
1538: l_attribute11 PA_PROJ_ELEMENTS.attribute11%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1545:
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1539: l_attribute12 PA_PROJ_ELEMENTS.attribute12%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1545:
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1547: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
1540: l_attribute13 PA_PROJ_ELEMENTS.attribute13%TYPE;
1541: l_attribute14 PA_PROJ_ELEMENTS.attribute14%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1545:
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1547: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
1548: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
1542: l_attribute15 PA_PROJ_ELEMENTS.attribute15%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1545:
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1547: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
1548: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
1549: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
1550: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
1543: l_phase_version_id PA_PROJ_ELEMENTS.phase_version_id%TYPE;
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1545:
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1547: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
1548: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
1549: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
1550: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
1551:
1544: l_phase_code PA_PROJ_ELEMENTS.phase_code%TYPE;
1545:
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1547: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
1548: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
1549: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
1550: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
1551:
1552: -- xxlu added task DFF attributes
1545:
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1547: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
1548: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
1549: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
1550: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
1551:
1552: -- xxlu added task DFF attributes
1553: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
1546: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
1547: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
1548: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;
1549: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
1550: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
1551:
1552: -- xxlu added task DFF attributes
1553: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
1554: l_tk_attribute1 pa_tasks.attribute1%TYPE;
1566: --hsiu added for task status
1567: l_task_status_changed varchar2(1);
1568: --end task status changes
1569:
1570: -- Changed Pa_tasks to pa_proj_elements for Bug 3809523
1571: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
1572: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
1573: cursor get_page_name(c_page_id NUMBER)
1574: IS
1567: l_task_status_changed varchar2(1);
1568: --end task status changes
1569:
1570: -- Changed Pa_tasks to pa_proj_elements for Bug 3809523
1571: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
1572: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
1573: cursor get_page_name(c_page_id NUMBER)
1574: IS
1575: SELECT page_name
1568: --end task status changes
1569:
1570: -- Changed Pa_tasks to pa_proj_elements for Bug 3809523
1571: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
1572: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
1573: cursor get_page_name(c_page_id NUMBER)
1574: IS
1575: SELECT page_name
1576: from pa_page_layouts
1643: ,PHASE_VERSION_ID
1644: ,PHASE_CODE
1645: ,PARENT_STRUCTURE_ID
1646: ,BASE_PERCENT_COMP_DERIV_CODE
1647: FROM PA_PROJ_ELEMENTS
1648: WHERE proj_element_id = p_task_id;
1649:
1650: v_cur_proj_elems_rec cur_proj_elems%ROWTYPE;
1651:
1695:
1696: --hsiu task status changes
1697: cursor get_latest_task_ver_id IS
1698: select b.parent_structure_version_id, b.element_version_id
1699: from pa_proj_elements a,
1700: pa_proj_element_versions b,
1701: pa_proj_elem_ver_structure c
1702: where a.proj_element_id = p_task_id
1703: and a.project_id = b.project_id
1763: l_base_perc_comp_deriv_code VARCHAR2(30);
1764: l_tt_base_perc_comp_der_cd VARCHAR2(30); --Jun 28th
1765:
1766: --Bug 3957706
1767: l_prog_method_code PA_PROJ_ELEMENTS.BASE_PERCENT_COMP_DERIV_CODE%TYPE;
1768:
1769: BEGIN
1770:
1771: IF (p_debug_mode = 'Y') THEN
1848: /* changes end for bug 3705333*/
1849: --dbms_output.put_line('Value of l_task_number'||l_task_number);
1850: --dbms_output.put_line( 'Check if the task name is unique within the project.' );
1851: /** Commenting the code below for Bug 4120380. This check is same as the check implemented by
1852: the constraint PA_PROJ_ELEMENTS_U2. This needs to commented to faciliate updation of task_number in the
1853: case below:
1854: Task 1.0 to be re-named to Taslk 1.1 and Task 1.1 to be renamed to Task 1.0 **/
1855: --Check if the task name is unique within the project
1856: /* Code below is uncommented for bug 4218947 **/
1853: case below:
1854: Task 1.0 to be re-named to Taslk 1.1 and Task 1.1 to be renamed to Task 1.0 **/
1855: --Check if the task name is unique within the project
1856: /* Code below is uncommented for bug 4218947 **/
1857: If (PA_PROJ_ELEMENTS_UTILS.check_element_number_unique(l_task_number, --Bug 3705333 changed from p_task_number to l_task_number
1858: p_task_id,
1859: v_cur_proj_elems_rec.project_id,
1860: v_cur_proj_elems_rec.PARENT_STRUCTURE_ID) <> 'Y') THEN
1861: --Name is not unique
1892: IF ( p_phase_version_id IS NOT NULL) AND
1893: (p_phase_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1894:
1895: -- check if it is top task
1896: IF ('N' = pa_proj_elements_utils.IS_TOP_TASK_ACROSS_ALL_VER(
1897: p_task_id)) THEN
1898: --Is not a top task across all versions. Error
1899: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NOT_ALL_TOP_TASKS');
1900: -- start of bug 3459905
1910: -- end of bug 3459905
1911: END IF;
1912:
1913: -- check if the current phase is already used.
1914: IF ('Y' = pa_proj_elements_utils.CHECK_PHASE_IN_USE(
1915: p_task_id,
1916: p_phase_version_id)) THEN
1917: -- Phase already in use in the structure. Error
1918: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_PHASE_IN_USE');
2273: OPEN get_task_versions_id(p_task_id,l_project_id);
2274: LOOP
2275: FETCH get_task_versions_id INTO l_task_version_id;
2276: EXIT WHEN get_task_versions_id%NOTFOUND;
2277: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);
2278: -- IF l_del_cnt >=1 AND p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE' THEN --Jun 28th
2279: IF l_del_cnt >=1 AND (p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE'
2280: OR l_tt_base_perc_comp_der_cd LIKE 'DELIVERABLE' ) THEN --Jun 28th
2281: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2288: OPEN get_task_versions_id2(p_task_id,l_project_id);
2289: LOOP
2290: FETCH get_task_versions_id2 INTO l_task_version_id;
2291: EXIT WHEN get_task_versions_id2%NOTFOUND;
2292: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);
2293: -- IF l_del_cnt >=1 AND p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE' THEN --Jun 28th
2294: IF l_del_cnt >=1 AND (p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE'
2295: OR l_tt_base_perc_comp_der_cd LIKE 'DELIVERABLE' ) THEN --Jun 28th
2296: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2404: ELSE
2405: l_base_perc_comp_deriv_code := p_base_perc_comp_deriv_code;
2406: END IF;
2407:
2408: --In the update_task process PA_PROJ_ELEMENTS.BASE_PERCENT_COMP_DERIV_CODE columns
2409: --is populated, only if it is null. Task_types value is used to populate base_percent_comp_deriv_code
2410: IF (l_base_perc_comp_deriv_code= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR l_base_perc_comp_deriv_code IS NULL) THEN
2411: l_base_perc_comp_deriv_code:=l_tt_base_perc_comp_der_cd;
2412: END IF;
2619: --dbms_output.put_line(('value of p_task_NUMBER passed'||l_task_NUMBER);
2620: --dbms_output.put_line(('value of p_task_id passed'||p_task_id);
2621: --dbms_output.put_line(('Value of p_task_NAME '||p_task_NAME);
2622: --dbms_output.put_line( 'Before calling UPDATE_ROW API.' );
2623: PA_PROJ_ELEMENTS_PKG.Update_Row(
2624: X_ROW_ID => v_cur_proj_elems_rec.rowid
2625: ,X_PROJ_ELEMENT_ID => p_task_id
2626: ,X_PROJECT_ID => v_cur_proj_elems_rec.PROJECT_ID
2627: ,X_OBJECT_TYPE => 'PA_TASKS'
2766:
2767: -- Modified for FP_M changes
2768: -- Tracking Bug 3305199
2769:
2770: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(P_Task_ID);
2771:
2772: IF (NVL( l_published_version, 'N' ) = 'N' and l_fin_task_flag = 'Y') OR
2773: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' and l_fin_task_flag = 'Y') -- Bug 3305199
2774: THEN
2801: -- xxlu added p_long_task_name
2802:
2803: -- avaithia ,Changed SUBSTR to SUBSTRB as SUBSTR doesnt provide Multi Language Support
2804: -- Included SUBSTRB for Task Description also ,because Task Description size
2805: -- is only 250 char in PA_TASKS Table ,whereas it can be upto 2000 char in pa_proj_elements
2806: -- These changes have been done for Bug 3935874
2807:
2808: PA_TASKS_MAINT_PUB.UPDATE_TASK
2809: (
2852: -- end xxlu changes
2853: ELSE --Added for transaction dates update
2854: --there is a publish version; update task that have financial attribute
2855: -- This code will excecute for fully shared and versioning enabled case
2856: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(p_task_id) = 'Y') THEN
2857: -- xxlu add task DFF attributes
2858: --bug 3690807
2859:
2860: -- Changed SUBSTR to SUBSTRB for 3935874
2961:
2962: --maansari
2963: IF PA_PROGRESS_UTILS.get_system_task_status( l_STATUS_CODE ) = 'CANCELLED'
2964: THEN
2965: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok (
2966: p_task_id => p_task_id
2967: ,p_task_version_id => l_latest_task_ver_rec.element_version_id
2968: ,p_new_task_status => l_STATUS_CODE
2969: ,x_return_status => l_return_status
3208: AND relationship_type = 'S';
3209: CURSOR get_task_detail(cp_task_id NUMBER)
3210: IS
3211: SELECT base_percent_comp_deriv_code
3212: FROM pa_proj_elements
3213: WHERE proj_element_id = cp_task_id;
3214:
3215: X_ROW_ID VARCHAR2(255);
3216: v_cur_proj_elems_rec cur_proj_elems%ROWTYPE;
3360: --
3361: --Bug No 3450684 Smukka 04/Mar/04 Checking for deliverable
3362: --Bug No 3475920
3363: IF p_peer_or_sub = 'PEER' THEN
3364: l_ref_parent_task_ver_id:=PA_PROJ_ELEMENTS_UTILS.GET_PARENT_TASK_VERSION_ID(p_ref_task_version_id);
3365: ELSE
3366: l_ref_parent_task_ver_id:=p_ref_task_version_id;
3367: END IF;
3368: --Bug No 3475920
3369: OPEN get_task_detail(p_task_id);
3370: FETCH get_task_detail INTO l_base_deriv_code;
3371: CLOSE get_task_detail;
3372: IF l_base_deriv_code LIKE 'DELIVERABLE' THEN
3373: IF PA_PROJ_ELEMENTS_UTILS.check_task_parents_deliv(l_ref_parent_task_ver_id) = 'Y' THEN
3374: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3375: p_msg_name => 'PA_TASK_AND_PARENTTASK_DEL');
3376: raise FND_API.G_EXC_ERROR;
3377: END IF;
3450:
3451: --hsiu: bug 2695631
3452: --copy structure version should not validate when creating tasks
3453: IF (p_validation_level <> 0) THEN
3454: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
3455: p_parent_task_ver_id => l_parent_id
3456: ,x_return_status => l_return_status
3457: ,x_error_message_code => l_error_message_code
3458: );
3482: End if; /** Changes end for performance BUg 4046026 */
3483: --hsiu: bug 2695631
3484: --copy structure version should not validate when creating tasks
3485: IF (p_validation_level <> 0) THEN
3486: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
3487: p_parent_task_ver_id => p_ref_task_version_id
3488: ,x_return_status => l_return_status
3489: ,x_error_message_code => l_error_message_code
3490: );
3519: END IF;
3520: END IF;
3521:
3522: --Display sequence is null if the task is a linking task.
3523: l_link_task_flag := PA_PROJ_ELEMENTS_UTILS.link_flag ( p_task_id );
3524: IF l_link_task_flag = 'Y'
3525: THEN
3526: l_DISPLAY_SEQUENCE := null;
3527: END IF;
3580: WHERE display_sequence > l_ref_seq_no
3581: AND element_version_id <> x_task_version_id
3582: AND parent_structure_version_id = v_cur_proj_elems_rec.parent_structure_version_id
3583: AND object_type = 'PA_TASKS'
3584: -- AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390
3585: ;
3586: ELSE
3587: IF p_peer_or_sub = 'PEER' --Bug 4046026
3588: THEN
3591: WHERE display_sequence > l_ref_seq_no
3592: AND element_version_id <> x_task_version_id
3593: AND parent_structure_version_id = v_cur_proj_elems_rec.parent_structure_version_id
3594: AND object_type = 'PA_TASKS'
3595: --AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390
3596: ;
3597: END IF;
3598: END IF; --Added for Bug 4046026 Commented for 4057190 /** Uncommented it again for BUg 4046026 **/
3599:
3651: IF l_link_task_flag = 'N'
3652: THEN
3653: --my_error_msg( 'In create_task_version pvt API Stage 6' );
3654:
3655: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (
3656: p_commit => p_commit
3657: ,p_debug_mode => p_debug_mode
3658: ,p_parent_structure_ver_id => l_parent_struc_ver_id
3659: ,p_task_id => x_task_version_id
3967: IS
3968: SELECT ptt.prog_entry_enable_flag
3969: FROM pa_task_types ptt,
3970: pa_proj_element_versions ppev,
3971: pa_proj_elements ppe
3972: WHERE ppev.element_version_id = c_element_version_id
3973: AND ppev.proj_element_id = ppe.proj_element_id
3974: AND ppe.TYPE_ID = ptt.task_type_id;
3975:
3990: END IF;
3991:
3992: --Bug No 3450684 Smukka 04/Mar/04 Checking for deliverable
3993: --Bug No 3475920 SMukka Commented out following logic to check for deliverable.
3994: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_task_version_id) = 'Y' THEN
3995: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_ref_task_version_id) = 'Y' THEN
3996: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3997: -- p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
3998: -- raise FND_API.G_EXC_ERROR;
3991:
3992: --Bug No 3450684 Smukka 04/Mar/04 Checking for deliverable
3993: --Bug No 3475920 SMukka Commented out following logic to check for deliverable.
3994: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_task_version_id) = 'Y' THEN
3995: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_ref_task_version_id) = 'Y' THEN
3996: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3997: -- p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
3998: -- raise FND_API.G_EXC_ERROR;
3999: -- END IF;
4369: END LOOP;
4370:
4371: --updating wbs number only once after making display seq null
4372:
4373: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
4374: ( p_commit => p_commit
4375: ,p_debug_mode => p_debug_mode
4376: ,p_parent_structure_ver_id => l_parent_struc_ver_id
4377: ,p_task_id => NULL
4670:
4671: --update wbs number for affected tasks
4672: -- Insert
4673: --update WBS NUMBER properly now for the affected rows.
4674: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
4675: ( p_commit => p_commit
4676: ,p_debug_mode => p_debug_mode
4677: ,p_parent_structure_ver_id => cur_affected_tasks_rec.parent_structure_version_id
4678: ,p_task_id => cur_affected_tasks_rec.element_version_id
4719:
4720: --update wbs number for actual tasks
4721: -- Insert
4722: --update WBS NUMBER properly now
4723: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
4724: ( p_commit => p_commit
4725: ,p_debug_mode => p_debug_mode
4726: ,p_parent_structure_ver_id => cur_actual_tasks_rec.parent_structure_version_id
4727: ,p_task_id => cur_actual_tasks_rec.element_version_id
4748: -- dbms_output.put_line( 'cur_affected_tasks_rec.display_sequence '|| cur_affected_tasks_rec.display_sequence );
4749: --update wbs number for affected tasks
4750: -- Insert
4751: --update WBS NUMBER properly now for the affected rows.
4752: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
4753: ( p_commit => p_commit
4754: ,p_debug_mode => p_debug_mode
4755: ,p_parent_structure_ver_id => cur_affected_tasks_rec.parent_structure_version_id
4756: ,p_task_id => cur_affected_tasks_rec.element_version_id
4855: START WITH object_id_from1 = p_task_version_id
4856: CONNECT BY object_id_from1 = PRIOR object_id_to1
4857: AND relationship_type = prior relationship_type -- bug 3919266
4858: AND relationship_type = 'S' ) A, pa_proj_element_versions b
4859: ,pa_proj_elements c --bug 4573340
4860: WHERE a.object_id_to1 = b.element_version_id
4861: --bug 4573340
4862: and b.proj_element_id = c.proj_element_id
4863: and b.project_id = c.project_id
4910:
4911: CURSOR cur_proj_elems( x_proj_element_id NUMBER )
4912: IS
4913: SELECT rowid
4914: FROM pa_proj_elements
4915: WHERE proj_element_id = x_proj_element_id;
4916:
4917:
4918: --Ansari
4932: select b.object_id_to1 object_id_to1
4933: from pa_object_relationships a,
4934: pa_object_relationships b,
4935: pa_proj_element_versions c,
4936: pa_proj_elements d
4937: where a.object_id_to1 = p_task_version_id
4938: and a.object_type_to = 'PA_TASKS'
4939: and a.object_id_from1 = b.object_id_from1
4940: and a.object_type_from = b.object_type_from
5014:
5015: --3035902: process update flag changes
5016: cursor get_task_type_id(c_proj_element_id NUMBER) IS
5017: select type_id
5018: from pa_proj_elements
5019: where proj_element_id = c_proj_element_id;
5020: l_task_type_id NUMBER;
5021: l_progress_flag VARCHAR2(1);
5022: l_Project_ID number;
5187: --added on 08-JAN-2002
5188: --check if task is linked task
5189: IF (p_structure_version_id IS NOT NULL) AND
5190: (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
5191: IF ('N' = pa_proj_elements_utils.check_task_in_structure(
5192: p_structure_version_id,
5193: p_task_version_id)) THEN
5194: --deleting linked task. Error
5195: x_return_status := FND_API.G_RET_STS_ERROR;
5292: END IF;
5293: END IF ; -- Bug#3834117
5294: END IF;
5295:
5296: IF l_delete_flag = 'Y' AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id )= 'Y'
5297: -- Added for FP_M changes Bug 3305199 Bhumesh
5298: THEN
5299:
5300: -- Added for FP_M changes
5397: --check_delete_task ok
5398:
5399: --dbms_output.put_line( 'before chk_delete ' );
5400:
5401: --The following code is reqd. to pass calling mode to check api bcoz PA_PROJ_ELEMENTS_UTILS.check_delete_task_ver_ok again calls
5402: --PA_TASK_UTILS.check_delete_task_ok api
5403: --bug 2947492
5404: --commenting out the 'R'estricted mode logic for bug 3010538
5405: -- IF p_calling_module = 'AMG'
5412:
5413: /* bug 4006401--removed since it is called in PUB.
5414: IF p_called_from_api <> 'MOVE_TASK_VERSION'
5415: THEN
5416: PA_PROJ_ELEMENTS_UTILS.check_delete_task_ver_ok(
5417: p_project_id => x_project_id
5418: ,p_task_version_id => cur_child_tasks_rec.object_id_to1
5419: ,p_parent_structure_ver_id => x_parent_struc_ver_id
5420: --bug 3010538 ,p_validation_mode => l_validation_mode --bug 2947492
5435:
5436: --deleting schedule version if its a workplan
5437: --IF workplan_structure THEN
5438: IF p_called_from_api <> 'MOVE_TASK_VERSION' THEN
5439: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
5440: p_structure_version_id => null
5441: ,p_task_version_id => cur_child_tasks_rec.object_id_to1
5442: ,p_structure_type => 'WORKPLAN' ) = 'Y' THEN
5443:
5585: */
5586: -- 4201927 end
5587:
5588: /*
5589: IF l_delete_flag = 'Y' AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id )= 'Y'
5590: -- Added for FP_M changes Bug 3305199 Bhumesh
5591: THEN
5592:
5593: -- Added for FP_M changes
5812: PA_PROJ_ELEMENT_VERSIONS_PKG.Delete_Row( x_row_id );
5813:
5814: --Ansari
5815: --Call update wbs number
5816: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (
5817: p_commit => p_commit
5818: ,p_debug_mode => p_debug_mode
5819: ,p_parent_structure_ver_id => x_parent_struc_ver_id
5820: ,p_task_id => null
5883: End If;
5884:
5885: -- 4201927 Commented below code
5886: /*
5887: PA_PROJ_ELEMENTS_PKG.delete_row( x_row_id_elem );
5888: */
5889:
5890: -- USING direct delete statement on table
5891: DELETE FROM PA_PROJ_ELEMENTS WHERE PROJ_ELEMENT_ID = l_proj_element_id;
5887: PA_PROJ_ELEMENTS_PKG.delete_row( x_row_id_elem );
5888: */
5889:
5890: -- USING direct delete statement on table
5891: DELETE FROM PA_PROJ_ELEMENTS WHERE PROJ_ELEMENT_ID = l_proj_element_id;
5892:
5893: -- 4201927 end
5894: -- anlee
5895: -- Ext Attribute changes
6039: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')
6040: -- record_version_number = record_version_number + 1
6041: WHERE parent_structure_version_id = x_parent_struc_ver_id
6042: AND (display_sequence > l_selected_seq_num)
6043: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';
6044: EXCEPTION
6045: WHEN OTHERS THEN
6046: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
6047: raise FND_API.G_EXC_ERROR;
6399:
6400:
6401: cursor get_task_type_id(c_proj_element_id NUMBER) IS
6402: select type_id
6403: from pa_proj_elements
6404: where proj_element_id = c_proj_element_id;
6405:
6406: l_task_type_id NUMBER;
6407: l_project_id NUMBER;
6729: END IF;
6730: -- end xxlu changes.
6731:
6732:
6733: PA_PROJ_ELEMENTS_UTILS.Check_Date_range(
6734: p_scheduled_start_date => l_scheduled_start_date
6735: ,p_scheduled_end_date => l_scheduled_end_date
6736: ,p_obligation_start_date => l_obligation_start_date
6737: ,p_obligation_end_date => l_obligation_end_date
7259:
7260: --hsiu added for bug 2634195
7261: cursor get_task_type_id(c_proj_element_id NUMBER) IS
7262: select type_id
7263: from pa_proj_elements
7264: where proj_element_id = c_proj_element_id;
7265: l_task_type_id NUMBER;
7266: --end bug 2634195
7267:
7847: l_level_assignments_flag := p_level_assignments_flag;
7848: END IF;
7849: --end bug 3305199
7850:
7851: PA_PROJ_ELEMENTS_UTILS.Check_Date_range(
7852: p_scheduled_start_date => l_scheduled_start_date
7853: ,p_scheduled_end_date => l_scheduled_end_date
7854: ,p_obligation_start_date => l_obligation_start_date
7855: ,p_obligation_end_date => l_obligation_end_date
8256:
8257: END IF;
8258:
8259: --bug 3301192 fp changes
8260: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_proj_elem_ver_sch_rec.ELEMENT_VERSION_ID ) = 'Y'
8261: THEN
8262:
8263: open get_parent_struc_ver_id(cur_proj_elem_ver_sch_rec.ELEMENT_VERSION_ID);
8264: fetch get_parent_struc_ver_id INTO l_parent_struc_ver_id;
8371: select c.TYPE_ID , c.WQ_ITEM_CODE, c.WQ_UOM_CODE, c.WQ_ACTUAL_ENTRY_CODE,
8372: c.TASK_PROGRESS_ENTRY_PAGE_ID
8373: from pa_proj_element_versions a,
8374: pa_object_relationships b,
8375: pa_proj_elements c
8376: where b.object_id_to1 = p_task_version_id
8377: and b.object_type_to = 'PA_TASKS'
8378: and b.relationship_type = 'S'
8379: and b.object_type_from = 'PA_TASKS'
8384:
8385: CURSOR get_current_task_type_attr IS
8386: select c.TYPE_ID , c.WQ_ITEM_CODE, c.WQ_UOM_CODE, c.WQ_ACTUAL_ENTRY_CODE,
8387: c.TASK_PROGRESS_ENTRY_PAGE_ID
8388: from pa_proj_elements c
8389: where c.proj_element_id = p_task_id;
8390: l_type_attr_rec get_current_task_type_attr%ROWTYPE;
8391: BEGIN
8392: x_return_status := FND_API.G_RET_STS_SUCCESS;
8404: CLOSE get_current_task_type_attr;
8405:
8406: IF (l_parent_type_attr_rec.TYPE_ID = l_type_attr_rec.TYPE_ID ) THEN
8407: --same type as parent at creation time. inherit
8408: UPDATE pa_proj_elements set
8409: -- task_weighting_deriv_code = l_parent_type_attr_rec.TASK_WEIGHTING_DERIV_CODE
8410: WQ_ITEM_CODE = l_parent_type_attr_rec.WQ_ITEM_CODE
8411: ,WQ_UOM_CODE = l_parent_type_attr_rec.WQ_UOM_CODE
8412: ,WQ_ACTUAL_ENTRY_CODE = l_parent_type_attr_rec.WQ_ACTUAL_ENTRY_CODE
8604: IS
8605: SELECT ptt.prog_entry_enable_flag
8606: FROM pa_task_types ptt,
8607: pa_proj_element_versions ppev,
8608: pa_proj_elements ppe
8609: WHERE ppev.element_version_id = c_element_version_id
8610: AND ppev.proj_element_id = ppe.proj_element_id
8611: AND ppe.TYPE_ID = ptt.task_type_id;
8612:
8845: START WITH object_id_from1 = p_task_version_id
8846: CONNECT BY object_id_from1 = PRIOR object_id_to1
8847: AND relationship_type = PRIOR relationship_type --bug 3919266
8848: AND relationship_type = 'S' ) A, pa_proj_element_versions b
8849: ,pa_proj_elements c --bug 4573340
8850: WHERE a.object_id_to1 = b.element_version_id
8851: --bug 4573340
8852: and b.proj_element_id = c.proj_element_id
8853: and b.project_id = c.project_id
8900:
8901: CURSOR cur_proj_elems( x_proj_element_id NUMBER )
8902: IS
8903: SELECT rowid
8904: FROM pa_proj_elements
8905: WHERE proj_element_id = x_proj_element_id;
8906:
8907:
8908: --Ansari
8975:
8976: --3035902: process update flag changes
8977: cursor get_task_type_id(c_proj_element_id NUMBER) IS
8978: select type_id
8979: from pa_proj_elements
8980: where proj_element_id = c_proj_element_id;
8981: l_task_type_id NUMBER;
8982: l_progress_flag VARCHAR2(1);
8983: l_wp_type VARCHAR2(1);
9071:
9072: --deleting schedule version if its a workplan
9073: --IF workplan_structure THEN
9074: --IF p_called_from_api <> 'MOVE_TASK_VERSION' THEN
9075: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
9076: p_structure_version_id => null
9077: ,p_task_version_id => cur_child_tasks_rec.object_id_to1
9078: ,p_structure_type => 'WORKPLAN' ) = 'Y' THEN
9079:
9347: --Ansari
9348: --Call update wbs number
9349: --hsiu: bug 2800553: performance changes: not called when deleting structure
9350: IF (p_calling_module <> 'DEL_STRUCT') THEN
9351: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (
9352: p_commit => p_commit
9353: ,p_debug_mode => p_debug_mode
9354: ,p_parent_structure_ver_id => x_parent_struc_ver_id
9355: ,p_task_id => null
9408: IF x_return_status = FND_API.G_RET_STS_ERROR then
9409: RAISE FND_API.G_EXC_ERROR;
9410: End If;
9411:
9412: PA_PROJ_ELEMENTS_PKG.delete_row( x_row_id_elem );
9413:
9414: -- anlee
9415: -- Ext Attribute changes
9416: -- Bug 2904327
9513: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')
9514: -- record_version_number = record_version_number + 1
9515: WHERE parent_structure_version_id = x_parent_struc_ver_id
9516: AND (display_sequence > l_selected_seq_num)
9517: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';
9518: EXCEPTION
9519: WHEN OTHERS THEN
9520: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
9521: raise FND_API.G_EXC_ERROR;
9711: l_working_parent_id NUMBER;
9712:
9713: CURSOR get_proj_info IS -- Bug 3083997. Modified the cursor to obtain
9714: select proj.project_id,proj.template_flag -- the project template flag also.
9715: from pa_proj_elements ele, pa_projects_all proj
9716: where ele.proj_element_id = p_task_id
9717: and ele.project_id = proj.project_id;
9718: l_project_id NUMBER;
9719: l_opt NUMBER;
9844: BEGIN
9845: IF PA_PROGRESS_UTILS.get_system_task_status( p_task_status ) = 'CANCELLED'
9846: THEN
9847: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( p_project_id );
9848: l_parent_struc_ver_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id( p_project_id, 'WORKPLAN' );
9849:
9850: --Store the whole branch of published version under p_task_id in pl/sql table.
9851: FOR cur_task_hier_rec IN cur_task_hier(l_parent_struc_ver_id) LOOP
9852: i := i + 1;