DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_FP_WP_GEN_AMT_UTILS

Line 3306: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN

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,

Line 5912: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN

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,

Line 11515: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN

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,

Line 14036: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN

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,