1630: * if l_denom_burdened_cost <> 0 then
1631: */
1632: --Bug 4444387: Added l_project_burdened_cost <> 0
1633: /* Bug#54065802 */
1634: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
1635: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
1636: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
1637: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
1638: /* Bug#54065802 */
1631: */
1632: --Bug 4444387: Added l_project_burdened_cost <> 0
1633: /* Bug#54065802 */
1634: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
1635: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
1636: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
1637: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
1638: /* Bug#54065802 */
1639:
1632: --Bug 4444387: Added l_project_burdened_cost <> 0
1633: /* Bug#54065802 */
1634: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
1635: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
1636: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
1637: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
1638: /* Bug#54065802 */
1639:
1640: if ( l_denom_burdened_cost <> 0 OR l_acct_burdened_cost <> 0 OR l_burden_cost <> 0 OR l_project_burdened_cost <> 0 )
1633: /* Bug#54065802 */
1634: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
1635: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
1636: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
1637: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
1638: /* Bug#54065802 */
1639:
1640: if ( l_denom_burdened_cost <> 0 OR l_acct_burdened_cost <> 0 OR l_burden_cost <> 0 OR l_project_burdened_cost <> 0 )
1641: then
2180:
2181: /* Bug#54065802 */
2182: if ( l_bcc_rec.count > 0) then /* Added for bug#6035619 */
2183:
2184: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
2185: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
2186: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
2187: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
2188:
2181: /* Bug#54065802 */
2182: if ( l_bcc_rec.count > 0) then /* Added for bug#6035619 */
2183:
2184: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
2185: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
2186: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
2187: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
2188:
2189: /* Bug#54065802 */
2182: if ( l_bcc_rec.count > 0) then /* Added for bug#6035619 */
2183:
2184: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
2185: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
2186: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
2187: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
2188:
2189: /* Bug#54065802 */
2190: end if; /* Added for bug#6035619 */
2183:
2184: l_denom_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_burdened_cost, bcc_rec.source_denom_currency_code);
2185: l_acct_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_acct_burdened_cost, bcc_rec.source_acct_currency_code);
2186: l_burden_cost :=PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_burden_cost, bcc_rec.source_projfunc_currency_code);
2187: l_project_burdened_cost := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_project_burdened_cost, bcc_rec.source_project_currency_code);
2188:
2189: /* Bug#54065802 */
2190: end if; /* Added for bug#6035619 */
2191: if ( l_denom_burdened_cost <> 0 OR l_acct_burdened_cost <> 0 OR l_burden_cost <> 0 OR l_project_burdened_cost <> 0 )
2840: -- end fix bug#2324127
2841: l_denom_burdened_cost := l_denom_burdened_cost + bcc_rec.denom_burdened_cost ;
2842: commented for bug 5984985 */
2843:
2844: l_burden_cost := l_burden_cost + pa_currency.round_currency_amt1(bcc_rec.source_burden_cost); /* added currency rounding for bug 5984985 */
2845: l_acct_burdened_cost := l_acct_burdened_cost + pa_currency.round_currency_amt1(bcc_rec.acct_burdened_cost); /* added currency rounding for bug 5984985 */
2846: l_denom_burdened_cost := l_denom_burdened_cost + pa_currency.round_trans_currency_amt1(bcc_rec.denom_burdened_cost,bcc_rec.denom_currency_code); /* added currency rounding for bug 5984985 */
2847:
2848: if nvl(bcc_rec.source_txn_ref1,'X') <> nvl(prev_bcc_rec.source_txn_ref1,'X') then
2841: l_denom_burdened_cost := l_denom_burdened_cost + bcc_rec.denom_burdened_cost ;
2842: commented for bug 5984985 */
2843:
2844: l_burden_cost := l_burden_cost + pa_currency.round_currency_amt1(bcc_rec.source_burden_cost); /* added currency rounding for bug 5984985 */
2845: l_acct_burdened_cost := l_acct_burdened_cost + pa_currency.round_currency_amt1(bcc_rec.acct_burdened_cost); /* added currency rounding for bug 5984985 */
2846: l_denom_burdened_cost := l_denom_burdened_cost + pa_currency.round_trans_currency_amt1(bcc_rec.denom_burdened_cost,bcc_rec.denom_currency_code); /* added currency rounding for bug 5984985 */
2847:
2848: if nvl(bcc_rec.source_txn_ref1,'X') <> nvl(prev_bcc_rec.source_txn_ref1,'X') then
2849: l_txn_ref1 := ''; -- nullify the transaction reference column
2842: commented for bug 5984985 */
2843:
2844: l_burden_cost := l_burden_cost + pa_currency.round_currency_amt1(bcc_rec.source_burden_cost); /* added currency rounding for bug 5984985 */
2845: l_acct_burdened_cost := l_acct_burdened_cost + pa_currency.round_currency_amt1(bcc_rec.acct_burdened_cost); /* added currency rounding for bug 5984985 */
2846: l_denom_burdened_cost := l_denom_burdened_cost + pa_currency.round_trans_currency_amt1(bcc_rec.denom_burdened_cost,bcc_rec.denom_currency_code); /* added currency rounding for bug 5984985 */
2847:
2848: if nvl(bcc_rec.source_txn_ref1,'X') <> nvl(prev_bcc_rec.source_txn_ref1,'X') then
2849: l_txn_ref1 := ''; -- nullify the transaction reference column
2850: else
2959: prev_bcc_rec.source_system_linkage_function ); /* 4057874 */
2960: end;
2961: end if;
2962:
2963: l_burden_cost := pa_currency.round_currency_amt1(bcc_rec.source_burden_cost); /* added currency rounding for bug 5984985 */
2964: l_acct_burdened_cost := pa_currency.round_currency_amt1(bcc_rec.acct_burdened_cost); /* added currency rounding for bug 5984985 */ /* 2324127 */
2965: l_denom_burdened_cost := pa_currency.round_trans_currency_amt(bcc_rec.denom_burdened_cost,bcc_rec.denom_currency_code); /* added currency rounding for bug 5984985 */ /* 2324127 */
2966:
2967:
2960: end;
2961: end if;
2962:
2963: l_burden_cost := pa_currency.round_currency_amt1(bcc_rec.source_burden_cost); /* added currency rounding for bug 5984985 */
2964: l_acct_burdened_cost := pa_currency.round_currency_amt1(bcc_rec.acct_burdened_cost); /* added currency rounding for bug 5984985 */ /* 2324127 */
2965: l_denom_burdened_cost := pa_currency.round_trans_currency_amt(bcc_rec.denom_burdened_cost,bcc_rec.denom_currency_code); /* added currency rounding for bug 5984985 */ /* 2324127 */
2966:
2967:
2968: prev_bcc_rec.source_project_id :=bcc_rec.source_project_id;
2961: end if;
2962:
2963: l_burden_cost := pa_currency.round_currency_amt1(bcc_rec.source_burden_cost); /* added currency rounding for bug 5984985 */
2964: l_acct_burdened_cost := pa_currency.round_currency_amt1(bcc_rec.acct_burdened_cost); /* added currency rounding for bug 5984985 */ /* 2324127 */
2965: l_denom_burdened_cost := pa_currency.round_trans_currency_amt(bcc_rec.denom_burdened_cost,bcc_rec.denom_currency_code); /* added currency rounding for bug 5984985 */ /* 2324127 */
2966:
2967:
2968: prev_bcc_rec.source_project_id :=bcc_rec.source_project_id;
2969: prev_bcc_rec.source_task_id :=bcc_rec.source_task_id;
2981: prev_bcc_rec.source_cost_base :=bcc_rec.source_cost_base;
2982: prev_bcc_rec.source_compiled_multiplier :=bcc_rec.source_compiled_multiplier;
2983: prev_bcc_rec.source_ind_rate_sch_id :=bcc_rec.source_ind_rate_sch_id;
2984: prev_bcc_rec.source_ind_rate_sch_rev_id :=bcc_rec.source_ind_rate_sch_rev_id;
2985: prev_bcc_rec.source_burden_cost :=pa_currency.round_currency_amt1(bcc_rec.source_burden_cost); /* added currency rounding for bug 5984985 */
2986: -- prev_bcc_rec.source_burden_cost :=bcc_rec.source_burden_cost;
2987: prev_bcc_rec.source_run_id :=bcc_rec.source_run_id;
2988: prev_bcc_rec.source_burden_sum_rej_code :=bcc_rec.source_burden_sum_rej_code;
2989: prev_bcc_rec.dest_project_id :=bcc_rec.dest_project_id;