DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_FP_WP_GEN_AMT_UTILS

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

5113: We are not using decode() in insert statement because it resulted in very poor performance
5114: */
5115:
5116:
5117: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
5118:
5119: UPDATE pa_structures_tasks_tmp
5120: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
5121: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,

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

7722: /*4275236 : If Workplan Cost is not enabled,Update the Values of Cost Columns as Empty
7723: We are not using decode() in insert statement because it resulted in very poor performance
7724: */
7725:
7726: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
7727:
7728: UPDATE pa_structures_tasks_tmp
7729: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
7730: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,

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

13844: end if;
13845:
13846: -- Bug # 4875311.
13847:
13848: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
13849:
13850: UPDATE pa_structures_tasks_tmp
13851: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
13852: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,

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

16368: end if;
16369:
16370: -- Bug # 4875311.
16371:
16372: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
16373:
16374: UPDATE pa_structures_tasks_tmp
16375: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
16376: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,