[Home] [Help]
154: nvl(PT.parent_task_id,PT.task_id) parent_task_id,
155: PTA.TASK_ID task_id,
156: PTA.PA_PERIOD,
157: PTA.GL_PERIOD,
158: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
159: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
160: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
155: PTA.TASK_ID task_id,
156: PTA.PA_PERIOD,
157: PTA.GL_PERIOD,
158: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
159: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
160: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
156: PTA.PA_PERIOD,
157: PTA.GL_PERIOD,
158: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
159: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
160: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
164: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
157: PTA.GL_PERIOD,
158: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
159: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
160: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
164: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
165: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
158: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
159: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
160: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
164: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
165: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
166: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
159: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
160: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
164: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
165: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
166: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
167: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
160: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
164: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
165: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
166: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
167: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
168: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
161: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
164: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
165: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
166: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
167: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
168: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
169: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
162: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
163: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
164: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
165: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
166: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
167: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
168: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
169: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
170: PTA.actual_cost_rollup_flag,
195: nvl(parl.migration_code,'-99') <> 'N' and
196: (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
197: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
198: OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
199: OR pa_proj_accum_main.x_summ_process = 'RL') and
200: -- gps.application_id = decode(x_impl_opt,'PA',275,'GL',pa_period_process_pkg.application_id) and
201: ----- commented and added for bug 2569461
202: -- Added TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) for bug 2834359
203: -- bug 3147957: Replaced TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) with p_org_id
214: 0 parent_task_id,
215: 0 task_id,
216: PTA.PA_PERIOD,
217: PTA.GL_PERIOD,
218: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
219: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
220: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
215: 0 task_id,
216: PTA.PA_PERIOD,
217: PTA.GL_PERIOD,
218: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
219: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
220: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
216: PTA.PA_PERIOD,
217: PTA.GL_PERIOD,
218: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
219: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
220: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
224: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
217: PTA.GL_PERIOD,
218: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
219: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
220: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
224: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
225: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
218: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
219: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
220: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
224: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
225: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
226: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
219: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
220: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
224: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
225: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
226: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
227: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
220: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
224: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
225: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
226: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
227: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
228: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
221: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
224: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
225: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
226: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
227: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
228: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
229: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
222: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
223: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
224: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
225: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
226: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
227: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
228: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
229: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
230: PTA.actual_cost_rollup_flag,
254: nvl(parl.migration_code,'-99') <> 'N' and
255: (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
256: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
257: OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
258: OR pa_proj_accum_main.x_summ_process = 'RL') and
259: -- gps.application_id = decode(x_impl_opt,'PA',275,'GL',pa_period_process_pkg.application_id) and
260: -- commented and added for bug 2569461
261: -- Added TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) for bug 2834359
262: -- bug 3147957: Replaced TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) with p_org_id
303: and PTA.task_id = PT.task_id(+)
304: and (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
305: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
306: OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
307: OR pa_proj_accum_main.x_summ_process = 'RL')
308: -- and gps.application_id = decode(x_impl_opt,'PA',275,'GL',pa_period_process_pkg.application_id)
309: ----- commented and added for bug 2569461
310: -- Added TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) for bug 2834359
311: -- bug 3147957: Replaced TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO'),1,10)) with p_org_id
323: nvl(PT.parent_task_id,PT.task_id) parent_task_id,
324: PTA.TASK_ID task_id,
325: PTA.PA_PERIOD,
326: PTA.GL_PERIOD,
327: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
328: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
329: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
324: PTA.TASK_ID task_id,
325: PTA.PA_PERIOD,
326: PTA.GL_PERIOD,
327: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
328: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
329: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
325: PTA.PA_PERIOD,
326: PTA.GL_PERIOD,
327: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
328: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
329: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
333: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
326: PTA.GL_PERIOD,
327: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
328: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
329: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
333: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
334: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
327: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
328: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
329: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
333: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
334: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
335: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
328: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
329: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
333: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
334: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
335: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
336: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
329: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
333: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
334: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
335: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
336: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
337: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
330: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
333: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
334: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
335: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
336: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
337: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
338: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
331: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
332: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
333: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
334: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
335: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
336: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
337: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
338: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
339: PTA.actual_cost_rollup_flag,
364: nvl(parl.migration_code,'-99') <> 'N' and
365: (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
366: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
367: OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
368: OR pa_proj_accum_main.x_summ_process = 'RL') and
369: gps.period_set_name = pi.period_set_name and
370: /* Commented for bug 4631058 gps.period_type = pi.pa_period_type and */
371: gps.adjustment_period_flag = 'N' and
372: -- Removed the fix done for Bug# 5019025
380: 0 parent_task_id,
381: 0 task_id,
382: PTA.PA_PERIOD,
383: PTA.GL_PERIOD,
384: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
385: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
386: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
381: 0 task_id,
382: PTA.PA_PERIOD,
383: PTA.GL_PERIOD,
384: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
385: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
386: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
382: PTA.PA_PERIOD,
383: PTA.GL_PERIOD,
384: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
385: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
386: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
390: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
383: PTA.GL_PERIOD,
384: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
385: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
386: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
390: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
391: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
384: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_REVENUE,0),NVL(PTA.I_TOT_REVENUE,0)) I_TOT_REVENUE,
385: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
386: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
390: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
391: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
392: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
385: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_RAW_COST,0),NVL(PTA.I_TOT_RAW_COST,0)) I_TOT_RAW_COST,
386: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
390: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
391: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
392: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
393: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
386: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BURDENED_COST,0),NVL(PTA.I_TOT_BURDENED_COST,0)) I_TOT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
390: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
391: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
392: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
393: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
394: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
387: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_QUANTITY,0),NVL(PTA.I_TOT_QUANTITY,0)) I_TOT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
390: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
391: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
392: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
393: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
394: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
395: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
388: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_LABOR_HOURS,0),NVL(PTA.I_TOT_LABOR_HOURS,0)) I_TOT_LABOR_HOURS,
389: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_RAW_COST,0),NVL(PTA.I_TOT_BILLABLE_RAW_COST,0)) I_TOT_BILLABLE_RAW_COST ,
390: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_BURDENED_COST,0),NVL(PTA.I_TOT_BILLABLE_BURDENED_COST,0)) I_TOT_BILLABLE_BURDENED_COST,
391: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_QUANTITY,0),NVL(PTA.I_TOT_BILLABLE_QUANTITY,0))I_TOT_BILLABLE_QUANTITY,
392: decode(pa_proj_accum_main.x_summ_process,'RL',NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0),NVL(PTA.I_TOT_BILLABLE_LABOR_HOURS,0)) I_TOT_BILLABLE_LABOR_HOURS,
393: NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
394: NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
395: NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
396: PTA.actual_cost_rollup_flag,
420: nvl(parl.migration_code,'-99') <> 'N' and
421: (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
422: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
423: OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
424: OR pa_proj_accum_main.x_summ_process = 'RL') and
425: gps.period_set_name = pi.period_set_name and
426: /* Commented for bug 4631058 gps.period_type = pi.pa_period_type and */
427: gps.adjustment_period_flag = 'N' and
428: -- Removed the fix done for Bug# 5019025
466: and PTA.task_id = PT.task_id(+)
467: and (PTA.ACTUAL_COST_Rollup_flag = DECODE(x_Actual_Cost_Flag,'Y','Y','X')
468: OR PTA.REVENUE_Rollup_flag = DECODE(x_revenue_Flag,'Y','Y','X')
469: OR PTA.CMT_Rollup_flag = DECODE(x_commitments_Flag,'Y','Y','X')
470: OR pa_proj_accum_main.x_summ_process = 'RL')
471: and gps.period_set_name = pi.period_set_name
472: /* Commented for bug 4631058 and gps.period_type = pi.pa_period_type */
473: and gps.adjustment_period_flag = 'N'
474: -- Removed the fix done for Bug# 5019025
541: -- Task level figures without resources
542:
543: IF (x_commitments_flag = 'Y' and
544: x_txn_accum_rec.cmt_rollup_flag = 'Y' and
545: pa_proj_accum_main.x_summ_process <> 'RL') THEN
546:
547: New_cmt_burd_cost_itd := New_cmt_burd_cost_itd +
548: NVL(x_txn_accum_rec.TOT_CMT_BURDENED_COST,0);
549: New_cmt_burd_cost_ytd := New_cmt_burd_cost_ytd +
564:
565: /*
566: IF ((x_txn_accum_rec.PA_PERIOD = x_current_period ) OR
567: (x_txn_accum_rec.GL_PERIOD = x_current_period )) AND
568: pa_proj_accum_main.x_summ_process <> 'RL' THEN
569: */
570: --New logic implemented for the bug 2753251
571: IF ((x_txn_accum_rec.PA_PERIOD = x_current_period AND X_impl_opt = 'PA' ) OR
572: (x_txn_accum_rec.GL_PERIOD = x_current_period AND X_impl_opt = 'GL')) AND
569: */
570: --New logic implemented for the bug 2753251
571: IF ((x_txn_accum_rec.PA_PERIOD = x_current_period AND X_impl_opt = 'PA' ) OR
572: (x_txn_accum_rec.GL_PERIOD = x_current_period AND X_impl_opt = 'GL')) AND
573: pa_proj_accum_main.x_summ_process <> 'RL'
574: THEN
575:
576:
577: -- bug 2753251 ------------------------------------------------------------
658: /*
659: ELSIF -- Fetched period = Previous period
660: ((x_txn_accum_rec.PA_PERIOD = x_prev_period )
661: OR (x_txn_accum_rec.GL_PERIOD = x_prev_period ))
662: AND pa_proj_accum_main.x_summ_process <> 'RL' THEN
663:
664: */
665:
666: ELSIF -- Fetched period = Previous period
665:
666: ELSIF -- Fetched period = Previous period
667: ((x_txn_accum_rec.PA_PERIOD = x_prev_period AND X_impl_opt = 'PA')
668: OR (x_txn_accum_rec.GL_PERIOD = x_prev_period AND X_impl_opt = 'GL'))
669: AND pa_proj_accum_main.x_summ_process <> 'RL'
670: THEN
671:
672:
673: -- bug 2753251 -----------------------------------------------------------
830: -- (Update only ITD and YTD figures)- Task level
831: -- figures without resources
832:
833: IF x_txn_accum_rec.PERIOD_YEAR = x_current_year
834: and pa_proj_accum_main.x_summ_process <> 'RL' Then
835:
836: IF x_actual_cost_flag = 'Y' and
837: x_txn_accum_rec.actual_cost_rollup_flag = 'Y' THEN
838:
898: -- Fetched period <> current or previous period
899: -- and fetched year <>
900: -- current year (Update only ITD figures )-
901: -- Task level figures without resources
902: If pa_proj_accum_main.x_summ_process <> 'RL' then
903: IF x_actual_cost_flag = 'Y' and
904: x_txn_accum_rec.actual_cost_rollup_flag = 'Y' THEN
905:
906: New_raw_cost_itd := New_raw_cost_itd +
943: ELSE -- for task_id = curr_task_id or curr_task_id = -99 condition
944:
945: -- Store the value onto variables to be later updated on Project
946: -- Level (task = 0 and rlmid = 0) record.
947: if pa_proj_accum_main.x_summ_process <> 'RL' then
948: add_project_amounts;
949: end if;
950:
951: if (x_txn_accum_rec.top_task_id <> curr_parent_id and
960: v_noof_tasks,
961: x_err_stack,
962: x_err_stage,
963: x_err_code);
964: if (pa_proj_accum_main.x_summ_process <> 'RL' and curr_parent_id > 0) then
965: Check_Accum_res_tasks
966: ( x_project_id ,
967: curr_task_id,
968: x_Proj_Accum_id,
1027: If (x_res_accum_rec.actual_cost_rollup_flag = 'Y' and
1028: x_actual_cost_flag = 'Y') or
1029: (x_res_accum_rec.revenue_rollup_flag = 'Y' and
1030: x_revenue_flag = 'Y') or
1031: (pa_proj_accum_main.x_summ_process = 'RL') then
1032: create_actuals := 'Y';
1033: end if;
1034: If (x_res_accum_rec.cmt_rollup_flag = 'Y' and x_commitments_flag = 'Y')
1035: or pa_proj_accum_main.x_summ_process = 'RL' then
1031: (pa_proj_accum_main.x_summ_process = 'RL') then
1032: create_actuals := 'Y';
1033: end if;
1034: If (x_res_accum_rec.cmt_rollup_flag = 'Y' and x_commitments_flag = 'Y')
1035: or pa_proj_accum_main.x_summ_process = 'RL' then
1036: create_commit := 'Y';
1037: end if;
1038: curr_rlmid := x_res_accum_rec.resource_list_member_id;
1039: curr_rid := x_res_accum_rec.resource_id;
1058: -- (Update only ITD,YTD and PTD figures)-
1059: -- Task level figures without resources
1060: IF (x_commitments_flag = 'Y' and
1061: x_res_accum_rec.cmt_rollup_flag = 'Y') or
1062: pa_proj_accum_main.x_summ_process = 'RL' THEN
1063:
1064: New_cmt_quantity_itd := New_cmt_quantity_itd
1065: + x_cmt_quantity;
1066: New_cmt_quantity_ytd := New_cmt_quantity_ytd
1103:
1104:
1105: IF (x_actual_cost_flag = 'Y' and
1106: x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
1107: pa_proj_accum_main.x_summ_process = 'RL' THEN
1108:
1109: New_raw_cost_itd := New_raw_cost_itd +
1110: NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
1111: New_raw_cost_ytd := New_raw_cost_ytd +
1162: END IF;
1163:
1164: IF (x_revenue_flag = 'Y' and
1165: x_res_accum_rec.revenue_rollup_flag = 'Y') or
1166: pa_proj_accum_main.x_summ_process = 'RL' THEN
1167:
1168: New_revenue_itd := New_revenue_itd +
1169: NVL(x_res_accum_rec.I_TOT_REVENUE,0);
1170: New_revenue_ytd := New_revenue_ytd +
1175: END IF;
1176:
1177: /* IF (x_commitments_flag = 'Y' and
1178: x_res_accum_rec.cmt_rollup_flag = 'Y') or
1179: pa_proj_accum_main.x_summ_process = 'RL' THEN
1180:
1181: New_cmt_quantity_itd := New_cmt_quantity_itd
1182: + x_cmt_quantity;
1183: New_cmt_quantity_ytd := New_cmt_quantity_ytd
1225: IF x_res_accum_rec.PERIOD_YEAR = x_current_year THEN
1226:
1227: IF (x_actual_cost_flag = 'Y' and
1228: x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
1229: pa_proj_accum_main.x_summ_process = 'RL' THEN
1230:
1231: New_raw_cost_itd := New_raw_cost_itd +
1232: NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
1233: New_raw_cost_ytd := New_raw_cost_ytd +
1284: END IF;
1285:
1286: IF (x_revenue_flag = 'Y' and
1287: x_res_accum_rec.revenue_rollup_flag = 'Y') or
1288: pa_proj_accum_main.x_summ_process = 'RL' THEN
1289:
1290: New_revenue_itd := New_revenue_itd +
1291: NVL(x_res_accum_rec.I_TOT_REVENUE,0);
1292: New_revenue_ytd := New_revenue_ytd +
1297: END IF;
1298:
1299: /* IF (x_commitments_flag = 'Y' and
1300: x_res_accum_rec.cmt_rollup_flag = 'Y') or
1301: pa_proj_accum_main.x_summ_process = 'RL' THEN
1302:
1303: New_cmt_quantity_itd := New_cmt_quantity_itd +
1304: x_cmt_quantity;
1305: New_cmt_quantity_ytd := New_cmt_quantity_ytd +
1331: -- figures without resources
1332:
1333: IF (x_actual_cost_flag = 'Y' and
1334: x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
1335: pa_proj_accum_main.x_summ_process = 'RL' THEN
1336:
1337: New_raw_cost_itd := New_raw_cost_itd +
1338: NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
1339: New_raw_cost_pp := New_raw_cost_pp +
1375: END IF;
1376:
1377: IF (x_revenue_flag = 'Y' and
1378: x_res_accum_rec.revenue_rollup_flag = 'Y') or
1379: pa_proj_accum_main.x_summ_process = 'RL' THEN
1380:
1381: New_revenue_itd := New_revenue_itd +
1382: NVL(x_res_accum_rec.I_TOT_REVENUE,0);
1383: New_revenue_pp := New_revenue_pp +
1386: END IF;
1387:
1388: /* IF (x_commitments_flag = 'Y' and
1389: x_res_accum_rec.cmt_rollup_flag = 'Y') or
1390: pa_proj_accum_main.x_summ_process = 'RL' THEN
1391:
1392: New_cmt_quantity_itd := New_cmt_quantity_itd +
1393: x_cmt_quantity;
1394: New_cmt_quantity_pp := New_cmt_quantity_pp +
1417: IF x_res_accum_rec.PERIOD_YEAR = x_current_year Then
1418:
1419: IF (x_actual_cost_flag = 'Y' and
1420: x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
1421: pa_proj_accum_main.x_summ_process = 'RL' THEN
1422:
1423: New_raw_cost_itd := New_raw_cost_itd +
1424: NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
1425: New_raw_cost_ytd := New_raw_cost_ytd +
1460: END IF;
1461:
1462: IF (x_revenue_flag = 'Y' and
1463: x_res_accum_rec.revenue_rollup_flag = 'Y') or
1464: pa_proj_accum_main.x_summ_process = 'RL' THEN
1465:
1466: New_revenue_itd := New_revenue_itd +
1467: NVL(x_res_accum_rec.I_TOT_REVENUE,0);
1468: New_revenue_ytd := New_revenue_ytd +
1471: END IF;
1472:
1473: /* IF (x_commitments_flag = 'Y' and
1474: x_res_accum_rec.cmt_rollup_flag = 'Y') or
1475: pa_proj_accum_main.x_summ_process = 'RL' THEN
1476:
1477: New_cmt_quantity_itd := New_cmt_quantity_itd +
1478: x_cmt_quantity;
1479: New_cmt_quantity_ytd := New_cmt_quantity_ytd +
1498: -- Task level figures without resources
1499:
1500: IF (x_actual_cost_flag = 'Y' and
1501: x_res_accum_rec.actual_cost_rollup_flag = 'Y') or
1502: pa_proj_accum_main.x_summ_process = 'RL' THEN
1503:
1504: New_raw_cost_itd := New_raw_cost_itd +
1505: NVL(x_res_accum_rec.I_TOT_RAW_COST,0);
1506: New_quantity_itd := New_quantity_itd + x_quantity;
1520: END IF;
1521:
1522: IF (x_revenue_flag = 'Y' and
1523: x_res_accum_rec.revenue_rollup_flag = 'Y') or
1524: pa_proj_accum_main.x_summ_process = 'RL' THEN
1525:
1526: New_revenue_itd := New_revenue_itd +
1527: NVL(x_res_accum_rec.I_TOT_REVENUE,0);
1528:
1529: END IF;
1530:
1531: /* IF (x_commitments_flag = 'Y' and
1532: x_res_accum_rec.cmt_rollup_flag = 'Y') or
1533: pa_proj_accum_main.x_summ_process = 'RL' THEN
1534:
1535: New_cmt_quantity_itd := New_cmt_quantity_itd +
1536: x_cmt_quantity;
1537: New_cmt_raw_cost_itd := New_cmt_raw_cost_itd +
1690: curr_res_task := x_res_accum_rec.task_id;
1691: END LOOP; -- End of x_Res_Accum_rec in Res_accum_Cur LOOP
1692: else
1693: --- create task level record
1694: if pa_proj_accum_main.x_summ_process <> 'RL' and
1695: curr_parent_id <> 0 then
1696: Check_Accum_Res_Tasks
1697: ( x_project_id,
1698: curr_task_id,
1723: Curr_task_id := x_Txn_Accum_rec.Task_id;
1724: Curr_parent_id := x_txn_accum_rec.top_task_id;
1725:
1726: -- After processing the records, Update the PA_TXN_ACCUM , modifying the
1727: if pa_proj_accum_main.x_summ_process <> 'RL' then
1728: Update PA_TXN_ACCUM Set
1729: TOT_REVENUE = NVL(TOT_REVENUE,0) + NVL(I_TOT_REVENUE,0),
1730: TOT_RAW_COST = NVL(TOT_RAW_COST,0) + NVL(I_TOT_RAW_COST,0),
1731: TOT_BURDENED_COST = NVL(TOT_BURDENED_COST,0) +
1752: I_TOT_BILLABLE_LABOR_HOURS = 0,
1753: ACTUAL_COST_ROLLUP_FLAG = decode(x_actual_cost_flag,'Y','N',actual_cost_rollup_flag),
1754: REVENUE_ROLLUP_FLAG = decode(x_revenue_flag,'Y','N',revenue_rollup_flag),
1755: CMT_ROLLUP_FLAG = decode(x_commitments_flag,'Y','N',cmt_rollup_flag),
1756: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1757: last_update_date = SYSDATE,
1758: request_id = pa_proj_accum_main.x_request_id,
1759: program_application_id =
1760: pa_proj_accum_main.x_program_application_id,
1754: REVENUE_ROLLUP_FLAG = decode(x_revenue_flag,'Y','N',revenue_rollup_flag),
1755: CMT_ROLLUP_FLAG = decode(x_commitments_flag,'Y','N',cmt_rollup_flag),
1756: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1757: last_update_date = SYSDATE,
1758: request_id = pa_proj_accum_main.x_request_id,
1759: program_application_id =
1760: pa_proj_accum_main.x_program_application_id,
1761: program_id = pa_proj_accum_main.x_program_id,
1762: program_update_date = SYSDATE
1756: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1757: last_update_date = SYSDATE,
1758: request_id = pa_proj_accum_main.x_request_id,
1759: program_application_id =
1760: pa_proj_accum_main.x_program_application_id,
1761: program_id = pa_proj_accum_main.x_program_id,
1762: program_update_date = SYSDATE
1763: Where TXN_ACCUM_ID = x_txn_accum_rec.txn_accum_id;
1764: end if;
1757: last_update_date = SYSDATE,
1758: request_id = pa_proj_accum_main.x_request_id,
1759: program_application_id =
1760: pa_proj_accum_main.x_program_application_id,
1761: program_id = pa_proj_accum_main.x_program_id,
1762: program_update_date = SYSDATE
1763: Where TXN_ACCUM_ID = x_txn_accum_rec.txn_accum_id;
1764: end if;
1765: END LOOP; -- End of x_Txn_Accum_rec in PA_Txn_Accum_cur LOOP
1767: CLOSE PA_Txn_Accum_Cur;
1768: CLOSE res_accum_cur;
1769: -- Update pa_project_accum_actuals project level records
1770: if (x_actual_cost_flag = 'Y' or x_revenue_flag = 'Y')
1771: and pa_proj_accum_main.x_summ_process <> 'RL' then
1772: UPDATE Pa_Project_Accum_actuals PAA SET
1773: Raw_cost_itd = nvl(raw_cost_itd,0) + Tsk_raw_cost_itd,
1774: Raw_cost_ytd = nvl(raw_cost_ytd,0) + Tsk_raw_cost_ytd,
1775: Raw_cost_pp = nvl(raw_cost_pp,0) + Tsk_raw_cost_pp,
1811: revenue_ytd = nvl(revenue_ytd,0) + Tsk_revenue_ytd,
1812: revenue_pp = nvl(revenue_pp,0) + Tsk_revenue_pp,
1813: revenue_ptd = nvl(revenue_ptd,0) + Tsk_revenue_ptd,
1814: txn_unit_of_measure = NULL,
1815: request_id = pa_proj_accum_main.x_request_id,
1816: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1817: last_update_date = Trunc(sysdate),
1818: creation_date = Trunc(Sysdate),
1819: created_by = pa_proj_accum_main.x_created_by,
1812: revenue_pp = nvl(revenue_pp,0) + Tsk_revenue_pp,
1813: revenue_ptd = nvl(revenue_ptd,0) + Tsk_revenue_ptd,
1814: txn_unit_of_measure = NULL,
1815: request_id = pa_proj_accum_main.x_request_id,
1816: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1817: last_update_date = Trunc(sysdate),
1818: creation_date = Trunc(Sysdate),
1819: created_by = pa_proj_accum_main.x_created_by,
1820: last_update_login = pa_proj_accum_main.x_last_update_login
1815: request_id = pa_proj_accum_main.x_request_id,
1816: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1817: last_update_date = Trunc(sysdate),
1818: creation_date = Trunc(Sysdate),
1819: created_by = pa_proj_accum_main.x_created_by,
1820: last_update_login = pa_proj_accum_main.x_last_update_login
1821: Where PAA.Project_Accum_id In
1822: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1823: Where Pah.Project_id = x_project_id and
1816: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1817: last_update_date = Trunc(sysdate),
1818: creation_date = Trunc(Sysdate),
1819: created_by = pa_proj_accum_main.x_created_by,
1820: last_update_login = pa_proj_accum_main.x_last_update_login
1821: Where PAA.Project_Accum_id In
1822: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1823: Where Pah.Project_id = x_project_id and
1824: pah.Resource_list_member_id = 0 and
1883: Tsk_revenue_ytd,
1884: Tsk_revenue_pp,
1885: Tsk_revenue_ptd,
1886: NULL,
1887: pa_proj_accum_main.x_request_id,
1888: pa_proj_accum_main.x_last_updated_by,
1889: Trunc(sysdate),
1890: Trunc(Sysdate),
1891: pa_proj_accum_main.x_created_by,
1884: Tsk_revenue_pp,
1885: Tsk_revenue_ptd,
1886: NULL,
1887: pa_proj_accum_main.x_request_id,
1888: pa_proj_accum_main.x_last_updated_by,
1889: Trunc(sysdate),
1890: Trunc(Sysdate),
1891: pa_proj_accum_main.x_created_by,
1892: pa_proj_accum_main.x_last_update_login);
1887: pa_proj_accum_main.x_request_id,
1888: pa_proj_accum_main.x_last_updated_by,
1889: Trunc(sysdate),
1890: Trunc(Sysdate),
1891: pa_proj_accum_main.x_created_by,
1892: pa_proj_accum_main.x_last_update_login);
1893: end if;
1894: end if;
1895: if x_commitments_flag = 'Y' and pa_proj_accum_main.x_summ_process <> 'RL' then
1888: pa_proj_accum_main.x_last_updated_by,
1889: Trunc(sysdate),
1890: Trunc(Sysdate),
1891: pa_proj_accum_main.x_created_by,
1892: pa_proj_accum_main.x_last_update_login);
1893: end if;
1894: end if;
1895: if x_commitments_flag = 'Y' and pa_proj_accum_main.x_summ_process <> 'RL' then
1896: UPDATE Pa_Project_Accum_Commitments PAA SET
1891: pa_proj_accum_main.x_created_by,
1892: pa_proj_accum_main.x_last_update_login);
1893: end if;
1894: end if;
1895: if x_commitments_flag = 'Y' and pa_proj_accum_main.x_summ_process <> 'RL' then
1896: UPDATE Pa_Project_Accum_Commitments PAA SET
1897: Cmt_Raw_cost_itd = nvl(Cmt_Raw_cost_itd,0) + Tsk_cmt_raw_cost_itd,
1898: Cmt_Raw_cost_ytd = nvl(Cmt_Raw_cost_ytd,0) + Tsk_cmt_raw_cost_ytd,
1899: Cmt_Raw_cost_pp = nvl(Cmt_Raw_cost_pp,0) + Tsk_cmt_raw_cost_pp,
1906: Cmt_quantity_ytd = nvl(Cmt_quantity_ytd,0) + Tsk_cmt_quantity_ytd,
1907: Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + Tsk_cmt_quantity_pp,
1908: Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + Tsk_cmt_quantity_ptd,
1909: cmt_unit_of_measure = NULL,
1910: request_id = pa_proj_accum_main.x_request_id,
1911: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1912: last_update_date = Trunc(sysdate),
1913: creation_date = Trunc(Sysdate),
1914: created_by = pa_proj_accum_main.x_created_by,
1907: Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + Tsk_cmt_quantity_pp,
1908: Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + Tsk_cmt_quantity_ptd,
1909: cmt_unit_of_measure = NULL,
1910: request_id = pa_proj_accum_main.x_request_id,
1911: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1912: last_update_date = Trunc(sysdate),
1913: creation_date = Trunc(Sysdate),
1914: created_by = pa_proj_accum_main.x_created_by,
1915: last_update_login = pa_proj_accum_main.x_last_update_login
1910: request_id = pa_proj_accum_main.x_request_id,
1911: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1912: last_update_date = Trunc(sysdate),
1913: creation_date = Trunc(Sysdate),
1914: created_by = pa_proj_accum_main.x_created_by,
1915: last_update_login = pa_proj_accum_main.x_last_update_login
1916: Where PAA.Project_Accum_id In
1917: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1918: Where Pah.Project_id = x_project_id and
1911: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1912: last_update_date = Trunc(sysdate),
1913: creation_date = Trunc(Sysdate),
1914: created_by = pa_proj_accum_main.x_created_by,
1915: last_update_login = pa_proj_accum_main.x_last_update_login
1916: Where PAA.Project_Accum_id In
1917: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1918: Where Pah.Project_id = x_project_id and
1919: pah.Resource_list_member_id = 0 and
1949: Tsk_cmt_quantity_itd,
1950: Tsk_cmt_quantity_ytd,
1951: Tsk_cmt_quantity_pp,
1952: Tsk_cmt_quantity_ptd,
1953: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1954: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
1955: pa_proj_accum_main.x_last_update_login);
1956: end if;
1957: end if;
1950: Tsk_cmt_quantity_ytd,
1951: Tsk_cmt_quantity_pp,
1952: Tsk_cmt_quantity_ptd,
1953: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1954: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
1955: pa_proj_accum_main.x_last_update_login);
1956: end if;
1957: end if;
1958: update pa_resource_list_assignments
1951: Tsk_cmt_quantity_pp,
1952: Tsk_cmt_quantity_ptd,
1953: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1954: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
1955: pa_proj_accum_main.x_last_update_login);
1956: end if;
1957: end if;
1958: update pa_resource_list_assignments
1959: set resource_list_accumulated_flag = 'Y'
2019: Values (v_accum_id,X_project_id,x_task_id,
2020: x_current_period,
2021: x_resource_id,x_resource_list_id,
2022: x_resource_list_assignment_id,x_resource_list_Member_id,
2023: pa_proj_accum_main.x_last_updated_by,
2024: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2025: trunc(sysdate),
2026: pa_proj_accum_main.x_created_by,
2027: pa_proj_accum_main.x_last_update_login );
2020: x_current_period,
2021: x_resource_id,x_resource_list_id,
2022: x_resource_list_assignment_id,x_resource_list_Member_id,
2023: pa_proj_accum_main.x_last_updated_by,
2024: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2025: trunc(sysdate),
2026: pa_proj_accum_main.x_created_by,
2027: pa_proj_accum_main.x_last_update_login );
2028:
2022: x_resource_list_assignment_id,x_resource_list_Member_id,
2023: pa_proj_accum_main.x_last_updated_by,
2024: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2025: trunc(sysdate),
2026: pa_proj_accum_main.x_created_by,
2027: pa_proj_accum_main.x_last_update_login );
2028:
2029: If x_create_actuals = 'Y' then
2030: Insert into PA_PROJECT_ACCUM_ACTUALS (
2023: pa_proj_accum_main.x_last_updated_by,
2024: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2025: trunc(sysdate),
2026: pa_proj_accum_main.x_created_by,
2027: pa_proj_accum_main.x_last_update_login );
2028:
2029: If x_create_actuals = 'Y' then
2030: Insert into PA_PROJECT_ACCUM_ACTUALS (
2031: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2079: New_revenue_ytd,
2080: New_revenue_pp,
2081: New_revenue_ptd,
2082: NULL,
2083: pa_proj_accum_main.x_request_id,
2084: pa_proj_accum_main.x_last_updated_by,
2085: Trunc(sysdate),
2086: Trunc(Sysdate),
2087: pa_proj_accum_main.x_created_by,
2080: New_revenue_pp,
2081: New_revenue_ptd,
2082: NULL,
2083: pa_proj_accum_main.x_request_id,
2084: pa_proj_accum_main.x_last_updated_by,
2085: Trunc(sysdate),
2086: Trunc(Sysdate),
2087: pa_proj_accum_main.x_created_by,
2088: pa_proj_accum_main.x_last_update_login);
2083: pa_proj_accum_main.x_request_id,
2084: pa_proj_accum_main.x_last_updated_by,
2085: Trunc(sysdate),
2086: Trunc(Sysdate),
2087: pa_proj_accum_main.x_created_by,
2088: pa_proj_accum_main.x_last_update_login);
2089: end if;
2090: If x_create_commit = 'Y' then
2091: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2084: pa_proj_accum_main.x_last_updated_by,
2085: Trunc(sysdate),
2086: Trunc(Sysdate),
2087: pa_proj_accum_main.x_created_by,
2088: pa_proj_accum_main.x_last_update_login);
2089: end if;
2090: If x_create_commit = 'Y' then
2091: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2092: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
2110: New_cmt_quantity_itd,
2111: New_cmt_quantity_ytd,
2112: New_cmt_quantity_pp,
2113: New_cmt_quantity_ptd,
2114: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2115: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2116: pa_proj_accum_main.x_last_update_login);
2117: end if;
2118: x_paa_flag := 'N';
2111: New_cmt_quantity_ytd,
2112: New_cmt_quantity_pp,
2113: New_cmt_quantity_ptd,
2114: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2115: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2116: pa_proj_accum_main.x_last_update_login);
2117: end if;
2118: x_paa_flag := 'N';
2119: x_pac_flag := 'N';
2112: New_cmt_quantity_pp,
2113: New_cmt_quantity_ptd,
2114: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2115: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2116: pa_proj_accum_main.x_last_update_login);
2117: end if;
2118: x_paa_flag := 'N';
2119: x_pac_flag := 'N';
2120:
2161: revenue_ytd = nvl(revenue_ytd,0) + New_revenue_ytd,
2162: revenue_pp = nvl(revenue_pp,0) + New_revenue_pp,
2163: revenue_ptd = nvl(revenue_ptd,0) + New_revenue_ptd,
2164: txn_unit_of_measure = NULL,
2165: request_id = pa_proj_accum_main.x_request_id,
2166: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2167: last_update_date = Trunc(sysdate),
2168: creation_date = Trunc(Sysdate),
2169: created_by = pa_proj_accum_main.x_created_by,
2162: revenue_pp = nvl(revenue_pp,0) + New_revenue_pp,
2163: revenue_ptd = nvl(revenue_ptd,0) + New_revenue_ptd,
2164: txn_unit_of_measure = NULL,
2165: request_id = pa_proj_accum_main.x_request_id,
2166: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2167: last_update_date = Trunc(sysdate),
2168: creation_date = Trunc(Sysdate),
2169: created_by = pa_proj_accum_main.x_created_by,
2170: last_update_login = pa_proj_accum_main.x_last_update_login
2165: request_id = pa_proj_accum_main.x_request_id,
2166: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2167: last_update_date = Trunc(sysdate),
2168: creation_date = Trunc(Sysdate),
2169: created_by = pa_proj_accum_main.x_created_by,
2170: last_update_login = pa_proj_accum_main.x_last_update_login
2171: Where PAA.Project_Accum_id = v_accum_id;
2172:
2173: if sql%notfound then
2166: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2167: last_update_date = Trunc(sysdate),
2168: creation_date = Trunc(Sysdate),
2169: created_by = pa_proj_accum_main.x_created_by,
2170: last_update_login = pa_proj_accum_main.x_last_update_login
2171: Where PAA.Project_Accum_id = v_accum_id;
2172:
2173: if sql%notfound then
2174: Insert into PA_PROJECT_ACCUM_ACTUALS (
2223: New_revenue_ytd,
2224: New_revenue_pp,
2225: New_revenue_ptd,
2226: NULL,
2227: pa_proj_accum_main.x_request_id,
2228: pa_proj_accum_main.x_last_updated_by,
2229: Trunc(sysdate),
2230: Trunc(Sysdate),
2231: pa_proj_accum_main.x_created_by,
2224: New_revenue_pp,
2225: New_revenue_ptd,
2226: NULL,
2227: pa_proj_accum_main.x_request_id,
2228: pa_proj_accum_main.x_last_updated_by,
2229: Trunc(sysdate),
2230: Trunc(Sysdate),
2231: pa_proj_accum_main.x_created_by,
2232: pa_proj_accum_main.x_last_update_login);
2227: pa_proj_accum_main.x_request_id,
2228: pa_proj_accum_main.x_last_updated_by,
2229: Trunc(sysdate),
2230: Trunc(Sysdate),
2231: pa_proj_accum_main.x_created_by,
2232: pa_proj_accum_main.x_last_update_login);
2233: end if;
2234:
2235: END;
2228: pa_proj_accum_main.x_last_updated_by,
2229: Trunc(sysdate),
2230: Trunc(Sysdate),
2231: pa_proj_accum_main.x_created_by,
2232: pa_proj_accum_main.x_last_update_login);
2233: end if;
2234:
2235: END;
2236:
2253: Cmt_quantity_ytd = nvl(Cmt_quantity_ytd,0) + New_cmt_quantity_ytd,
2254: Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + New_cmt_quantity_pp,
2255: Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + New_cmt_quantity_ptd,
2256: cmt_unit_of_measure = NULL,
2257: request_id = pa_proj_accum_main.x_request_id,
2258: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2259: last_update_date = Trunc(sysdate),
2260: creation_date = Trunc(Sysdate),
2261: created_by = pa_proj_accum_main.x_created_by,
2254: Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + New_cmt_quantity_pp,
2255: Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + New_cmt_quantity_ptd,
2256: cmt_unit_of_measure = NULL,
2257: request_id = pa_proj_accum_main.x_request_id,
2258: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2259: last_update_date = Trunc(sysdate),
2260: creation_date = Trunc(Sysdate),
2261: created_by = pa_proj_accum_main.x_created_by,
2262: last_update_login = pa_proj_accum_main.x_last_update_login
2257: request_id = pa_proj_accum_main.x_request_id,
2258: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2259: last_update_date = Trunc(sysdate),
2260: creation_date = Trunc(Sysdate),
2261: created_by = pa_proj_accum_main.x_created_by,
2262: last_update_login = pa_proj_accum_main.x_last_update_login
2263: Where PAA.Project_Accum_id = v_accum_id;
2264:
2265: if sql%notfound then
2258: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2259: last_update_date = Trunc(sysdate),
2260: creation_date = Trunc(Sysdate),
2261: created_by = pa_proj_accum_main.x_created_by,
2262: last_update_login = pa_proj_accum_main.x_last_update_login
2263: Where PAA.Project_Accum_id = v_accum_id;
2264:
2265: if sql%notfound then
2266: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2285: New_cmt_quantity_itd,
2286: New_cmt_quantity_ytd,
2287: New_cmt_quantity_pp,
2288: New_cmt_quantity_ptd,
2289: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2290: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2291: pa_proj_accum_main.x_last_update_login);
2292: end if;
2293: END ;
2286: New_cmt_quantity_ytd,
2287: New_cmt_quantity_pp,
2288: New_cmt_quantity_ptd,
2289: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2290: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2291: pa_proj_accum_main.x_last_update_login);
2292: end if;
2293: END ;
2294:
2287: New_cmt_quantity_pp,
2288: New_cmt_quantity_ptd,
2289: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2290: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2291: pa_proj_accum_main.x_last_update_login);
2292: end if;
2293: END ;
2294:
2295: END IF;
2353: Values (v_accum_id,X_project_id,x_task_id,
2354: x_current_period,
2355: x_resource_id,x_resource_list_id,
2356: x_resource_list_assignment_id,x_resource_list_Member_id,
2357: pa_proj_accum_main.x_last_updated_by,
2358: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2359: trunc(sysdate),
2360: pa_proj_accum_main.x_created_by,
2361: pa_proj_accum_main.x_last_update_login );
2354: x_current_period,
2355: x_resource_id,x_resource_list_id,
2356: x_resource_list_assignment_id,x_resource_list_Member_id,
2357: pa_proj_accum_main.x_last_updated_by,
2358: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2359: trunc(sysdate),
2360: pa_proj_accum_main.x_created_by,
2361: pa_proj_accum_main.x_last_update_login );
2362:
2356: x_resource_list_assignment_id,x_resource_list_Member_id,
2357: pa_proj_accum_main.x_last_updated_by,
2358: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2359: trunc(sysdate),
2360: pa_proj_accum_main.x_created_by,
2361: pa_proj_accum_main.x_last_update_login );
2362:
2363: If x_create_wbs_actuals = 'Y' then
2364: Insert into PA_PROJECT_ACCUM_ACTUALS (
2357: pa_proj_accum_main.x_last_updated_by,
2358: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2359: trunc(sysdate),
2360: pa_proj_accum_main.x_created_by,
2361: pa_proj_accum_main.x_last_update_login );
2362:
2363: If x_create_wbs_actuals = 'Y' then
2364: Insert into PA_PROJECT_ACCUM_ACTUALS (
2365: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2413: Prt_revenue_ytd,
2414: Prt_revenue_pp,
2415: Prt_revenue_ptd,
2416: NULL,
2417: pa_proj_accum_main.x_request_id,
2418: pa_proj_accum_main.x_last_updated_by,
2419: Trunc(sysdate),
2420: Trunc(Sysdate),
2421: pa_proj_accum_main.x_created_by,
2414: Prt_revenue_pp,
2415: Prt_revenue_ptd,
2416: NULL,
2417: pa_proj_accum_main.x_request_id,
2418: pa_proj_accum_main.x_last_updated_by,
2419: Trunc(sysdate),
2420: Trunc(Sysdate),
2421: pa_proj_accum_main.x_created_by,
2422: pa_proj_accum_main.x_last_update_login);
2417: pa_proj_accum_main.x_request_id,
2418: pa_proj_accum_main.x_last_updated_by,
2419: Trunc(sysdate),
2420: Trunc(Sysdate),
2421: pa_proj_accum_main.x_created_by,
2422: pa_proj_accum_main.x_last_update_login);
2423: end if;
2424: If x_create_wbs_commit = 'Y' then
2425: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2418: pa_proj_accum_main.x_last_updated_by,
2419: Trunc(sysdate),
2420: Trunc(Sysdate),
2421: pa_proj_accum_main.x_created_by,
2422: pa_proj_accum_main.x_last_update_login);
2423: end if;
2424: If x_create_wbs_commit = 'Y' then
2425: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2426: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
2444: Prt_cmt_quantity_itd,
2445: Prt_cmt_quantity_ytd,
2446: Prt_cmt_quantity_pp,
2447: Prt_cmt_quantity_ptd,
2448: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2449: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2450: pa_proj_accum_main.x_last_update_login);
2451: end if;
2452: x_paa_flag := 'N';
2445: Prt_cmt_quantity_ytd,
2446: Prt_cmt_quantity_pp,
2447: Prt_cmt_quantity_ptd,
2448: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2449: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2450: pa_proj_accum_main.x_last_update_login);
2451: end if;
2452: x_paa_flag := 'N';
2453: x_pac_flag := 'N';
2446: Prt_cmt_quantity_pp,
2447: Prt_cmt_quantity_ptd,
2448: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2449: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2450: pa_proj_accum_main.x_last_update_login);
2451: end if;
2452: x_paa_flag := 'N';
2453: x_pac_flag := 'N';
2454:
2495: revenue_ytd = nvl(revenue_ytd,0) + Prt_revenue_ytd,
2496: revenue_pp = nvl(revenue_pp,0) + Prt_revenue_pp,
2497: revenue_ptd = nvl(revenue_ptd,0) + Prt_revenue_ptd,
2498: txn_unit_of_measure = NULL,
2499: request_id = pa_proj_accum_main.x_request_id,
2500: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2501: last_update_date = Trunc(sysdate),
2502: creation_date = Trunc(Sysdate),
2503: created_by = pa_proj_accum_main.x_created_by,
2496: revenue_pp = nvl(revenue_pp,0) + Prt_revenue_pp,
2497: revenue_ptd = nvl(revenue_ptd,0) + Prt_revenue_ptd,
2498: txn_unit_of_measure = NULL,
2499: request_id = pa_proj_accum_main.x_request_id,
2500: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2501: last_update_date = Trunc(sysdate),
2502: creation_date = Trunc(Sysdate),
2503: created_by = pa_proj_accum_main.x_created_by,
2504: last_update_login = pa_proj_accum_main.x_last_update_login
2499: request_id = pa_proj_accum_main.x_request_id,
2500: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2501: last_update_date = Trunc(sysdate),
2502: creation_date = Trunc(Sysdate),
2503: created_by = pa_proj_accum_main.x_created_by,
2504: last_update_login = pa_proj_accum_main.x_last_update_login
2505: Where PAA.Project_Accum_id = v_accum_id;
2506:
2507: if sql%notfound then
2500: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2501: last_update_date = Trunc(sysdate),
2502: creation_date = Trunc(Sysdate),
2503: created_by = pa_proj_accum_main.x_created_by,
2504: last_update_login = pa_proj_accum_main.x_last_update_login
2505: Where PAA.Project_Accum_id = v_accum_id;
2506:
2507: if sql%notfound then
2508: Insert into PA_PROJECT_ACCUM_ACTUALS (
2557: Prt_revenue_ytd,
2558: Prt_revenue_pp,
2559: Prt_revenue_ptd,
2560: NULL,
2561: pa_proj_accum_main.x_request_id,
2562: pa_proj_accum_main.x_last_updated_by,
2563: Trunc(sysdate),
2564: Trunc(Sysdate),
2565: pa_proj_accum_main.x_created_by,
2558: Prt_revenue_pp,
2559: Prt_revenue_ptd,
2560: NULL,
2561: pa_proj_accum_main.x_request_id,
2562: pa_proj_accum_main.x_last_updated_by,
2563: Trunc(sysdate),
2564: Trunc(Sysdate),
2565: pa_proj_accum_main.x_created_by,
2566: pa_proj_accum_main.x_last_update_login);
2561: pa_proj_accum_main.x_request_id,
2562: pa_proj_accum_main.x_last_updated_by,
2563: Trunc(sysdate),
2564: Trunc(Sysdate),
2565: pa_proj_accum_main.x_created_by,
2566: pa_proj_accum_main.x_last_update_login);
2567: end if;
2568:
2569: END;
2562: pa_proj_accum_main.x_last_updated_by,
2563: Trunc(sysdate),
2564: Trunc(Sysdate),
2565: pa_proj_accum_main.x_created_by,
2566: pa_proj_accum_main.x_last_update_login);
2567: end if;
2568:
2569: END;
2570:
2587: Cmt_quantity_ytd = nvl(Cmt_quantity_ytd,0) + Prt_cmt_quantity_ytd,
2588: Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + Prt_cmt_quantity_pp,
2589: Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + Prt_cmt_quantity_ptd,
2590: cmt_unit_of_measure = NULL,
2591: request_id = pa_proj_accum_main.x_request_id,
2592: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2593: last_update_date = Trunc(sysdate),
2594: creation_date = Trunc(Sysdate),
2595: created_by = pa_proj_accum_main.x_created_by,
2588: Cmt_quantity_pp = nvl(Cmt_quantity_pp,0) + Prt_cmt_quantity_pp,
2589: Cmt_quantity_ptd = nvl(Cmt_quantity_ptd,0) + Prt_cmt_quantity_ptd,
2590: cmt_unit_of_measure = NULL,
2591: request_id = pa_proj_accum_main.x_request_id,
2592: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2593: last_update_date = Trunc(sysdate),
2594: creation_date = Trunc(Sysdate),
2595: created_by = pa_proj_accum_main.x_created_by,
2596: last_update_login = pa_proj_accum_main.x_last_update_login
2591: request_id = pa_proj_accum_main.x_request_id,
2592: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2593: last_update_date = Trunc(sysdate),
2594: creation_date = Trunc(Sysdate),
2595: created_by = pa_proj_accum_main.x_created_by,
2596: last_update_login = pa_proj_accum_main.x_last_update_login
2597: Where PAA.Project_Accum_id = v_accum_id;
2598:
2599: if sql%notfound then
2592: last_updated_by = pa_proj_accum_main.x_last_updated_by,
2593: last_update_date = Trunc(sysdate),
2594: creation_date = Trunc(Sysdate),
2595: created_by = pa_proj_accum_main.x_created_by,
2596: last_update_login = pa_proj_accum_main.x_last_update_login
2597: Where PAA.Project_Accum_id = v_accum_id;
2598:
2599: if sql%notfound then
2600: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2619: Prt_cmt_quantity_itd,
2620: Prt_cmt_quantity_ytd,
2621: Prt_cmt_quantity_pp,
2622: Prt_cmt_quantity_ptd,
2623: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2624: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2625: pa_proj_accum_main.x_last_update_login);
2626: end if;
2627: END ;
2620: Prt_cmt_quantity_ytd,
2621: Prt_cmt_quantity_pp,
2622: Prt_cmt_quantity_ptd,
2623: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2624: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2625: pa_proj_accum_main.x_last_update_login);
2626: end if;
2627: END ;
2628:
2621: Prt_cmt_quantity_pp,
2622: Prt_cmt_quantity_ptd,
2623: NULL,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2624: Trunc(Sysdate),pa_proj_accum_main.x_created_by,
2625: pa_proj_accum_main.x_last_update_login);
2626: end if;
2627: END ;
2628:
2629: END IF;
2714: RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,
2715: CREATION_DATE,REQUEST_ID,CREATED_BY,LAST_UPDATE_LOGIN )
2716: Values (x_Accum_id,X_project_id,x_task_id,
2717: x_current_period,
2718: 0,0,0,0,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),trunc(sysdate),
2719: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
2720:
2721: -- Restore the old x_err_stack;
2722:
2715: CREATION_DATE,REQUEST_ID,CREATED_BY,LAST_UPDATE_LOGIN )
2716: Values (x_Accum_id,X_project_id,x_task_id,
2717: x_current_period,
2718: 0,0,0,0,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),trunc(sysdate),
2719: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
2720:
2721: -- Restore the old x_err_stack;
2722:
2723: x_err_stack := V_Old_Stack;
2833: 0,0,0,
2834: 0,0,0,0,0,0,0,0,
2835: 0,0,0,0,0,0,
2836: 0,0,0,0,
2837: 0,0,NULL,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2838: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
2839: Recs_processed := Recs_processed + 1;
2840: END LOOP;
2841:
2834: 0,0,0,0,0,0,0,0,
2835: 0,0,0,0,0,0,
2836: 0,0,0,0,
2837: 0,0,NULL,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2838: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
2839: Recs_processed := Recs_processed + 1;
2840: END LOOP;
2841:
2842: End If;
2985: 0,0,0,0,0,0,0,0,
2986: 0,0,0,0,
2987: 0,0,0,
2988: 0,0,0,0,
2989: 0,NULL,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2990: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
2991: Recs_processed := Recs_processed + 1;
2992: END LOOP;
2993: End If;
2986: 0,0,0,0,
2987: 0,0,0,
2988: 0,0,0,0,
2989: 0,NULL,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2990: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
2991: Recs_processed := Recs_processed + 1;
2992: END LOOP;
2993: End If;
2994: -- This will check for the Project-Resource combination in the Header records
3035: 0,0,0,0,0,0,0,0,
3036: 0,0,0,0,
3037: 0,0,0,
3038: 0,0,0,0,
3039: 0,NULL,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
3040: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
3041: Recs_processed := Recs_processed + 1;
3042: END IF;
3043: Close Proj_Res_level_Cur;
3036: 0,0,0,0,
3037: 0,0,0,
3038: 0,0,0,0,
3039: 0,NULL,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
3040: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
3041: Recs_processed := Recs_processed + 1;
3042: END IF;
3043: Close Proj_Res_level_Cur;
3044: x_recs_processed := Recs_processed;
3137: BILLABLE_LABOR_HOURS_YTD = 0,
3138: BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PTD,
3139: BILLABLE_LABOR_HOURS_PTD = 0,REVENUE_YTD = 0,
3140: REVENUE_PP = REVENUE_PTD,REVENUE_PTD = 0,
3141: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3142: LAST_UPDATE_DATE = trunc(sysdate),
3143: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3144: Where Project_Accum_id IN
3145: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3139: BILLABLE_LABOR_HOURS_PTD = 0,REVENUE_YTD = 0,
3140: REVENUE_PP = REVENUE_PTD,REVENUE_PTD = 0,
3141: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3142: LAST_UPDATE_DATE = trunc(sysdate),
3143: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3144: Where Project_Accum_id IN
3145: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3146: PAH.Project_Id = x_project_id);
3147: Else
3163: BILLABLE_LABOR_HOURS_PP = BILLABLE_LABOR_HOURS_PTD,
3164: BILLABLE_LABOR_HOURS_PTD = 0,
3165: REVENUE_PP = REVENUE_PTD,
3166: REVENUE_PTD = 0,
3167: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3168: LAST_UPDATE_DATE = trunc(sysdate),
3169: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3170: Where Project_Accum_id IN
3171: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3165: REVENUE_PP = REVENUE_PTD,
3166: REVENUE_PTD = 0,
3167: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3168: LAST_UPDATE_DATE = trunc(sysdate),
3169: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3170: Where Project_Accum_id IN
3171: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3172: PAH.Project_Id = x_project_id);
3173: End If;
3193: BILLABLE_LABOR_HOURS_YTD = 0,
3194: BILLABLE_LABOR_HOURS_PP = 0,
3195: BILLABLE_LABOR_HOURS_PTD = 0,REVENUE_YTD = 0,
3196: REVENUE_PP = 0,REVENUE_PTD = 0,
3197: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3198: LAST_UPDATE_DATE = trunc(sysdate),
3199: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3200: Where Project_Accum_id IN
3201: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3195: BILLABLE_LABOR_HOURS_PTD = 0,REVENUE_YTD = 0,
3196: REVENUE_PP = 0,REVENUE_PTD = 0,
3197: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3198: LAST_UPDATE_DATE = trunc(sysdate),
3199: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3200: Where Project_Accum_id IN
3201: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3202: PAH.Project_Id = x_project_id);
3203: Else
3219: BILLABLE_LABOR_HOURS_PP = 0,
3220: BILLABLE_LABOR_HOURS_PTD = 0,
3221: REVENUE_PP = 0,
3222: REVENUE_PTD = 0,
3223: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3224: LAST_UPDATE_DATE = trunc(sysdate),
3225: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3226: Where Project_Accum_id IN
3227: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3221: REVENUE_PP = 0,
3222: REVENUE_PTD = 0,
3223: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3224: LAST_UPDATE_DATE = trunc(sysdate),
3225: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3226: Where Project_Accum_id IN
3227: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3228: PAH.Project_Id = x_project_id);
3229: End If;
3330: ORIG_LABOR_HOURS_PTD = 0,
3331: BASE_REVENUE_YTD = 0,
3332: BASE_REVENUE_PP = BASE_REVENUE_PTD,
3333: BASE_REVENUE_PTD = 0,
3334: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3335: LAST_UPDATE_DATE = trunc(sysdate),
3336: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3337: Where Project_Accum_id IN
3338: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3332: BASE_REVENUE_PP = BASE_REVENUE_PTD,
3333: BASE_REVENUE_PTD = 0,
3334: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3335: LAST_UPDATE_DATE = trunc(sysdate),
3336: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3337: Where Project_Accum_id IN
3338: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3339: PAH.Project_Id = x_project_id) And
3340: Budget_Type_Code <> Nvl(x_budget_type,'00');
3357: ORIG_LABOR_HOURS_PP = ORIG_LABOR_HOURS_PTD,
3358: ORIG_LABOR_HOURS_PTD = 0,
3359: BASE_REVENUE_PP = BASE_REVENUE_PTD,
3360: BASE_REVENUE_PTD = 0,
3361: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3362: LAST_UPDATE_DATE = trunc(sysdate),
3363: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3364: Where Project_Accum_id IN
3365: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3359: BASE_REVENUE_PP = BASE_REVENUE_PTD,
3360: BASE_REVENUE_PTD = 0,
3361: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3362: LAST_UPDATE_DATE = trunc(sysdate),
3363: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3364: Where Project_Accum_id IN
3365: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3366: PAH.Project_Id = x_project_id) And
3367: Budget_Type_Code <> Nvl(x_budget_type,'00');
3395: ORIG_LABOR_HOURS_PTD = 0,
3396: BASE_REVENUE_YTD = 0,
3397: BASE_REVENUE_PP = 0,
3398: BASE_REVENUE_PTD = 0,
3399: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3400: LAST_UPDATE_DATE = trunc(sysdate),
3401: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3402: Where Project_Accum_id IN
3403: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3397: BASE_REVENUE_PP = 0,
3398: BASE_REVENUE_PTD = 0,
3399: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3400: LAST_UPDATE_DATE = trunc(sysdate),
3401: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3402: Where Project_Accum_id IN
3403: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3404: PAH.Project_Id = x_project_id) And
3405: Budget_Type_Code <> Nvl(x_budget_type,'00');
3422: ORIG_LABOR_HOURS_PP = 0,
3423: ORIG_LABOR_HOURS_PTD = 0,
3424: BASE_REVENUE_PP = 0,
3425: BASE_REVENUE_PTD = 0,
3426: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3427: LAST_UPDATE_DATE = trunc(sysdate),
3428: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3429: Where Project_Accum_id IN
3430: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3424: BASE_REVENUE_PP = 0,
3425: BASE_REVENUE_PTD = 0,
3426: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3427: LAST_UPDATE_DATE = trunc(sysdate),
3428: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3429: Where Project_Accum_id IN
3430: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3431: PAH.Project_Id = x_project_id) And
3432: Budget_Type_Code <> Nvl(x_budget_type,'00');
3522: CMT_BURDENED_COST_PTD = 0,
3523: CMT_QUANTITY_YTD = 0,
3524: CMT_QUANTITY_PP = CMT_QUANTITY_PTD,
3525: CMT_QUANTITY_PTD = 0,
3526: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3527: LAST_UPDATE_DATE = trunc(sysdate),
3528: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3529: Where Project_Accum_id IN
3530: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3524: CMT_QUANTITY_PP = CMT_QUANTITY_PTD,
3525: CMT_QUANTITY_PTD = 0,
3526: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3527: LAST_UPDATE_DATE = trunc(sysdate),
3528: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3529: Where Project_Accum_id IN
3530: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3531: PAH.Project_Id = x_project_id);
3532: Else
3536: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PTD,
3537: CMT_BURDENED_COST_PTD = 0,
3538: CMT_QUANTITY_PP = CMT_QUANTITY_PTD,
3539: CMT_QUANTITY_PTD = 0,
3540: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3541: LAST_UPDATE_DATE = trunc(sysdate),
3542: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3543: Where Project_Accum_id IN
3544: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3538: CMT_QUANTITY_PP = CMT_QUANTITY_PTD,
3539: CMT_QUANTITY_PTD = 0,
3540: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3541: LAST_UPDATE_DATE = trunc(sysdate),
3542: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3543: Where Project_Accum_id IN
3544: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3545: PAH.Project_Id = x_project_id);
3546: End If;
3555: CMT_BURDENED_COST_PTD = 0,
3556: CMT_QUANTITY_YTD = 0,
3557: CMT_QUANTITY_PP = 0,
3558: CMT_QUANTITY_PTD = 0,
3559: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3560: LAST_UPDATE_DATE = trunc(sysdate),
3561: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3562: Where Project_Accum_id IN
3563: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3557: CMT_QUANTITY_PP = 0,
3558: CMT_QUANTITY_PTD = 0,
3559: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3560: LAST_UPDATE_DATE = trunc(sysdate),
3561: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3562: Where Project_Accum_id IN
3563: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3564: PAH.Project_Id = x_project_id);
3565: Else
3569: CMT_BURDENED_COST_PP = 0,
3570: CMT_BURDENED_COST_PTD = 0,
3571: CMT_QUANTITY_PP = 0,
3572: CMT_QUANTITY_PTD = 0,
3573: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3574: LAST_UPDATE_DATE = trunc(sysdate),
3575: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3576: Where Project_Accum_id IN
3577: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3571: CMT_QUANTITY_PP = 0,
3572: CMT_QUANTITY_PTD = 0,
3573: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
3574: LAST_UPDATE_DATE = trunc(sysdate),
3575: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
3576: Where Project_Accum_id IN
3577: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3578: PAH.Project_Id = x_project_id);
3579: End If;