3302: We are not using decode() in insert statement because it resulted in very poor performance
3303: */
3304:
3305:
3306: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
3307:
3308: UPDATE pa_structures_tasks_tmp
3309: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
3310: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
5908: /*4275236 : If Workplan Cost is not enabled,Update the Values of Cost Columns as Empty
5909: We are not using decode() in insert statement because it resulted in very poor performance
5910: */
5911:
5912: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
5913:
5914: UPDATE pa_structures_tasks_tmp
5915: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
5916: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
11511: end if;
11512:
11513: -- Bug # 4875311.
11514:
11515: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
11516:
11517: UPDATE pa_structures_tasks_tmp
11518: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
11519: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
14032: end if;
14033:
14034: -- Bug # 4875311.
14035:
14036: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
14037:
14038: UPDATE pa_structures_tasks_tmp
14039: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
14040: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,