[Home] [Help]
452:
453: -- Bug 4549862: When generating a Cost and Revenue together version
454: -- from Staffing Plan with revenue accrual method of COST, the
455: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP
456: -- table (instead of pa_budget_lines) earlier in the code flow by the
457: -- GENERATE_BUDGET_AMT_RES_SCH API so that pc/pfc Commitment amounts
458: -- can be honored. We should not call the currency conversion API in
459: -- this case.
460:
762: END IF;
763:
764: ** End Comment for Bug 4292083 **************************************************/
765:
766: -- Call API to update pa_budget_lines.other_rejection_code
767: -- with any ETC revenue amount calculation errors.
768: -- See bug 5203622 for more details.
769: IF p_pa_debug_mode = 'Y' THEN
770: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2926: --hr_utility.trace('After processing all etc source!');
2927: --dbms_output.put_line('--before mapping++');
2928: /**After calling apis based on each res_asg_id's gen_method, we have all the plan totals and
2929: *ETC amounts populated in tmp2 table, now, we need to map the amounts to the target fin
2930: *plan's resource list, summ up, call calculate to spread into pa_budget_lines if time_phase
2931: *is not null, otherwise, we need to populate into pa_budget_lines by ourselves**/
2932:
2933: /* select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
2934: hr_utility.trace('tmp1 count :'|| l_count_tmp);
2927: --dbms_output.put_line('--before mapping++');
2928: /**After calling apis based on each res_asg_id's gen_method, we have all the plan totals and
2929: *ETC amounts populated in tmp2 table, now, we need to map the amounts to the target fin
2930: *plan's resource list, summ up, call calculate to spread into pa_budget_lines if time_phase
2931: *is not null, otherwise, we need to populate into pa_budget_lines by ourselves**/
2932:
2933: /* select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP1;
2934: hr_utility.trace('tmp1 count :'|| l_count_tmp);
2935: select count(*) into l_count_tmp from PA_FP_CALC_AMT_TMP2;
2966: AND ra.resource_assignment_id = tmp1.target_res_asg_id
2967: AND ( ra.transaction_source_code IS NOT NULL
2968: OR ( ra.transaction_source_code IS NULL
2969: AND NOT EXISTS ( SELECT 1
2970: FROM pa_budget_lines bl
2971: WHERE bl.resource_assignment_id =
2972: ra.resource_assignment_id
2973: AND bl.start_date >= l_etc_start_date
2974: AND rownum = 1 )))
2988: AND ra.resource_assignment_id = tmp1.target_res_asg_id
2989: AND ( ra.transaction_source_code IS NOT NULL
2990: OR ( ra.transaction_source_code IS NULL
2991: AND NOT EXISTS ( SELECT 1
2992: FROM pa_budget_lines bl
2993: WHERE bl.resource_assignment_id =
2994: ra.resource_assignment_id
2995: AND NVL(bl.quantity,0) <>
2996: NVL(bl.init_quantity,0)
3181: IF l_ra_txn_source_code IS NULL THEN
3182: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
3183: SELECT count(*)
3184: INTO l_bl_count
3185: FROM pa_budget_lines
3186: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i)
3187: AND start_date > p_actuals_thru_date;
3188: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
3189: SELECT count(*)
3187: AND start_date > p_actuals_thru_date;
3188: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
3189: SELECT count(*)
3190: INTO l_bl_count
3191: FROM pa_budget_lines
3192: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i)
3193: AND NVL(quantity,0) <> NVL(init_quantity,0);
3194: END IF;
3195: END IF;
3211: /* Mannually entered lines don't exist, so source records will
3212: be honored */
3213: IF p_fp_cols_rec.x_time_phased_code = 'P'
3214: OR p_fp_cols_rec.x_time_phased_code = 'G' THEN
3215: DELETE FROM pa_budget_lines
3216: WHERE resource_assignment_id = l_cal_ra_id_tab_tmp(i)
3217: AND start_date > p_actuals_thru_date;
3218: END IF;
3219:
4146: INTO l_init_qty,
4147: l_init_raw_cost,
4148: l_init_burdened_cost,
4149: l_init_revenue
4150: FROM pa_budget_lines
4151: WHERE resource_assignment_id = l_cal_ra_id_tab(i)
4152: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4153:
4154: l_cal_etc_qty_tab(i) := NVL(l_cal_etc_qty_tab(i),0) +
4317: -- ensure that l_init_qty is not null.
4318: BEGIN
4319: SELECT nvl(sum(nvl(init_quantity,0)),0)
4320: INTO l_init_qty
4321: FROM pa_budget_lines
4322: WHERE resource_assignment_id = l_cal_ra_id_tab(i)
4323: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4324: EXCEPTION
4325: WHEN NO_DATA_FOUND THEN
4487: END IF;
4488:
4489: /*
4490: select count(*) into l_count from
4491: pa_budget_lines where budget_version_id = P_BUDGET_VERSION_ID;
4492:
4493: hr_utility.trace('==before calculate=== no of bdgt lines'||
4494: l_count );
4495: Initializing every pl sql table to null for calling calculate API */
4863: END MAINTAIN_RES_ASG;
4864:
4865:
4866: /**
4867: * This procedure updates pa_budget_lines.other_rejection_code
4868: * for the purpose of signalling ETC revenue amount calculation
4869: * errors. See bug 5203622.
4870: *
4871: * Pre-Conditions:
4947: END IF;
4948: RETURN;
4949: END IF;
4950:
4951: -- Update pa_budget_lines with any other_rejection_codes stored
4952: -- in the txn_currency_code column of the task level selection
4953: -- forecast generation processing table pa_fp_calc_amt_tmp2.
4954:
4955: UPDATE pa_budget_lines bl
4951: -- Update pa_budget_lines with any other_rejection_codes stored
4952: -- in the txn_currency_code column of the task level selection
4953: -- forecast generation processing table pa_fp_calc_amt_tmp2.
4954:
4955: UPDATE pa_budget_lines bl
4956: SET bl.other_rejection_code =
4957: ( SELECT tmp2.txn_currency_code
4958: FROM pa_fp_calc_amt_tmp2 tmp2
4959: WHERE tmp2.transaction_source_code = 'ETC'