[Home] [Help]
471:
472: -- Bug 4549862: When generating a Cost and Revenue together version
473: -- from Staffing Plan with revenue accrual method of COST, the
474: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP
475: -- table (instead of pa_budget_lines) earlier in the code flow by the
476: -- GENERATE_BUDGET_AMT_RES_SCH API so that pc/pfc Commitment amounts
477: -- can be honored. We should not call the currency conversion API in
478: -- this case.
479:
862: END IF;
863:
864: ** End Comment for Bug 4292083 **************************************************/
865:
866: -- Call API to update pa_budget_lines.other_rejection_code
867: -- with any ETC revenue amount calculation errors.
868: -- See bug 5203622 for more details.
869: IF p_pa_debug_mode = 'Y' THEN
870: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3153: --hr_utility.trace('After processing all etc source!');
3154: --dbms_output.put_line('--before mapping++');
3155: /**After calling apis based on each res_asg_id's gen_method, we have all the plan totals and
3156: *ETC amounts populated in tmp2 table, now, we need to map the amounts to the target fin
3157: *plan's resource list, summ up, call calculate to spread into pa_budget_lines if time_phase
3158: *is not null, otherwise, we need to populate into pa_budget_lines by ourselves**/
3159:
3160: /* select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
3161: hr_utility.trace('tmp1 count :'|| l_count_tmp);
3154: --dbms_output.put_line('--before mapping++');
3155: /**After calling apis based on each res_asg_id's gen_method, we have all the plan totals and
3156: *ETC amounts populated in tmp2 table, now, we need to map the amounts to the target fin
3157: *plan's resource list, summ up, call calculate to spread into pa_budget_lines if time_phase
3158: *is not null, otherwise, we need to populate into pa_budget_lines by ourselves**/
3159:
3160: /* select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
3161: hr_utility.trace('tmp1 count :'|| l_count_tmp);
3162: select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP2;
3193: AND ra.resource_assignment_id = tmp1.target_res_asg_id
3194: AND ( ra.transaction_source_code IS NOT NULL
3195: OR ( ra.transaction_source_code IS NULL
3196: AND NOT EXISTS ( SELECT 1
3197: FROM pa_budget_lines bl
3198: WHERE bl.resource_assignment_id =
3199: ra.resource_assignment_id
3200: AND bl.start_date >= l_etc_start_date
3201: AND rownum = 1 )))
3215: AND ra.resource_assignment_id = tmp1.target_res_asg_id
3216: AND ( ra.transaction_source_code IS NOT NULL
3217: OR ( ra.transaction_source_code IS NULL
3218: AND NOT EXISTS ( SELECT 1
3219: FROM pa_budget_lines bl
3220: WHERE bl.resource_assignment_id =
3221: ra.resource_assignment_id
3222: AND NVL(bl.quantity,0) <>
3223: NVL(bl.init_quantity,0)
3415: IF l_ra_txn_source_code IS NULL THEN
3416: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
3417: SELECT count(*)
3418: INTO l_bl_count
3419: FROM pa_budget_lines
3420: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i)
3421: AND start_date > p_actuals_thru_date;
3422: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
3423: SELECT count(*)
3421: AND start_date > p_actuals_thru_date;
3422: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
3423: SELECT count(*)
3424: INTO l_bl_count
3425: FROM pa_budget_lines
3426: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i)
3427: AND NVL(quantity,0) <> NVL(init_quantity,0);
3428: END IF;
3429: END IF;
3448: -- Avoiding the deletion of budget lines created when l_copy_etc_from_plan_flag is checked
3449: IF (p_fp_cols_rec.x_time_phased_code = 'P'
3450: OR p_fp_cols_rec.x_time_phased_code = 'G')
3451: AND NVL(l_copy_etc_from_plan_flag,'N') = 'N' THEN
3452: DELETE FROM pa_budget_lines
3453: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i)
3454: AND start_date > p_actuals_thru_date;
3455: END IF;
3456: -- gboomina Bug 8318932 for AAI Enhancement - End
4398: INTO l_init_qty,
4399: l_init_raw_cost,
4400: l_init_burdened_cost,
4401: l_init_revenue
4402: FROM pa_budget_lines
4403: WHERE resource_assignment_id = l_cal_ra_id_tab(i)
4404: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4405:
4406: l_cal_etc_qty_tab(i) := NVL(l_cal_etc_qty_tab(i),0) +
4573: -- ensure that l_init_qty is not null.
4574: BEGIN
4575: SELECT nvl(sum(nvl(init_quantity,0)),0)
4576: INTO l_init_qty
4577: FROM pa_budget_lines
4578: WHERE resource_assignment_id = l_cal_ra_id_tab(i)
4579: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4580: EXCEPTION
4581: WHEN NO_DATA_FOUND THEN
4743: END IF;
4744:
4745: /*
4746: select count(*) into l_count from
4747: pa_budget_lines where budget_version_id = P_BUDGET_VERSION_ID;
4748:
4749: hr_utility.trace('==before calculate=== no of bdgt lines'||
4750: l_count );
4751: Initializing every pl sql table to null for calling calculate API */
5125: END MAINTAIN_RES_ASG;
5126:
5127:
5128: /**
5129: * This procedure updates pa_budget_lines.other_rejection_code
5130: * for the purpose of signalling ETC revenue amount calculation
5131: * errors. See bug 5203622.
5132: *
5133: * Pre-Conditions:
5209: END IF;
5210: RETURN;
5211: END IF;
5212:
5213: -- Update pa_budget_lines with any other_rejection_codes stored
5214: -- in the txn_currency_code column of the task level selection
5215: -- forecast generation processing table pa_fp_calc_amt_tmp2.
5216:
5217: UPDATE pa_budget_lines bl
5213: -- Update pa_budget_lines with any other_rejection_codes stored
5214: -- in the txn_currency_code column of the task level selection
5215: -- forecast generation processing table pa_fp_calc_amt_tmp2.
5216:
5217: UPDATE pa_budget_lines bl
5218: SET bl.other_rejection_code =
5219: ( SELECT tmp2.txn_currency_code
5220: FROM pa_fp_calc_amt_tmp2 tmp2
5221: WHERE tmp2.transaction_source_code = 'ETC'