eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ALLOC_RUN dependencies on PA_CURRENCY

Line 171: pa_currency.SET_CURRENCY_INFO ;

167: pa_debug.write_file('allocation_run: ' || 'LOG', pa_debug.G_err_stage);
168: END IF;
169: init_who_cols();
170: -- Initialize the global variables for currency information
171: pa_currency.SET_CURRENCY_INFO ;
172: pa_debug.G_err_stage:= 'GETTING CURENCY CODE';
173: IF P_DEBUG_MODE = 'Y' THEN
174: pa_debug.write_file('allocation_run: ' || 'LOG', pa_debug.G_err_stage);
175: END IF;

Line 176: G_denom_currency_code := pa_currency.get_currency_code();

172: pa_debug.G_err_stage:= 'GETTING CURENCY CODE';
173: IF P_DEBUG_MODE = 'Y' THEN
174: pa_debug.write_file('allocation_run: ' || 'LOG', pa_debug.G_err_stage);
175: END IF;
176: G_denom_currency_code := pa_currency.get_currency_code();
177: -- G_lock_name := 'PA_AL-'||to_char(p_rule_id);
178: -- pa_debug.G_err_stage := 'ACQUIRING LOCK';
179: -- pa_debug.write_file( 'LOG', pa_debug.G_err_stage);
180: -- IF (pa_debug.Acquire_User_Lock(G_lock_name) <> 0 ) THEN

Line 2679: -- v_amount:= pa_currency.round_currency_amt( NVl(v_amount,0) );

2675: END IF;
2676: CLOSE get_gl_amount;
2677: -- Commented the following line as a part of fixing rounding issues.
2678: -- The rounding is done for eligible amount
2679: -- v_amount:= pa_currency.round_currency_amt( NVl(v_amount,0) );
2680: IF P_DEBUG_MODE = 'Y' THEN
2681: pa_debug.write_file('calculate_src_GL_amounts: ' || 'LOG', 'v_amount is: '|| to_char(v_amount) );
2682: END IF;
2683: /* then insert into gl_source_det */

Line 2696: , pa_currency.round_currency_amt(v_amount*

2692: , G_last_updated_by
2693: , G_last_update_login
2694: , gl_source_rec.source_percent
2695: , v_amount
2696: , pa_currency.round_currency_amt(v_amount*
2697: (gl_source_rec.source_percent/100)*
2698: ( v_pool_percent/100))
2699: ) ;
2700: IF P_DEBUG_MODE = 'Y' THEN

Line 3457: v_tot_alloc_amount:= pa_currency.round_currency_amt(v_tot_alloc_amount);

3453: , 'T'
3454: , p_amount_type );
3455: v_curr_alloc_amount := NVl(v_curr_alloc_amount,0) - NVl(v_prev_alloc_amount, 0);
3456: END IF;
3457: v_tot_alloc_amount:= pa_currency.round_currency_amt(v_tot_alloc_amount);
3458: v_prev_alloc_amount:= pa_currency.round_currency_amt(v_prev_alloc_amount);
3459: v_curr_alloc_amount:= pa_currency.round_currency_amt(v_curr_alloc_amount);
3460: IF P_DEBUG_MODE = 'Y' THEN
3461: pa_debug.write_file('create_target_txns: ' || 'LOG', 'Amounts after rounding' );

Line 3458: v_prev_alloc_amount:= pa_currency.round_currency_amt(v_prev_alloc_amount);

3454: , p_amount_type );
3455: v_curr_alloc_amount := NVl(v_curr_alloc_amount,0) - NVl(v_prev_alloc_amount, 0);
3456: END IF;
3457: v_tot_alloc_amount:= pa_currency.round_currency_amt(v_tot_alloc_amount);
3458: v_prev_alloc_amount:= pa_currency.round_currency_amt(v_prev_alloc_amount);
3459: v_curr_alloc_amount:= pa_currency.round_currency_amt(v_curr_alloc_amount);
3460: IF P_DEBUG_MODE = 'Y' THEN
3461: pa_debug.write_file('create_target_txns: ' || 'LOG', 'Amounts after rounding' );
3462: pa_debug.write_file('create_target_txns: ' || 'LOG', 'v_tot_alloc_amount:'||to_char(v_tot_alloc_amount) );

Line 3459: v_curr_alloc_amount:= pa_currency.round_currency_amt(v_curr_alloc_amount);

3455: v_curr_alloc_amount := NVl(v_curr_alloc_amount,0) - NVl(v_prev_alloc_amount, 0);
3456: END IF;
3457: v_tot_alloc_amount:= pa_currency.round_currency_amt(v_tot_alloc_amount);
3458: v_prev_alloc_amount:= pa_currency.round_currency_amt(v_prev_alloc_amount);
3459: v_curr_alloc_amount:= pa_currency.round_currency_amt(v_curr_alloc_amount);
3460: IF P_DEBUG_MODE = 'Y' THEN
3461: pa_debug.write_file('create_target_txns: ' || 'LOG', 'Amounts after rounding' );
3462: pa_debug.write_file('create_target_txns: ' || 'LOG', 'v_tot_alloc_amount:'||to_char(v_tot_alloc_amount) );
3463: pa_debug.write_file('create_target_txns: ' || 'LOG', 'v_prev_alloc_amount:'||to_char(v_prev_alloc_amount) );

Line 3721: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);

3717: ELSE /* if full allocation */
3718: v_prev_offset_amount:= 0;
3719: END IF;
3720: v_curr_offset_amount := NVl(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3721: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3722: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3723: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3724: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3725: /* insert into alloc_txn_details */

Line 3722: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);

3718: v_prev_offset_amount:= 0;
3719: END IF;
3720: v_curr_offset_amount := NVl(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3721: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3722: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3723: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3724: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3725: /* insert into alloc_txn_details */
3726: --

Line 3723: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);

3719: END IF;
3720: v_curr_offset_amount := NVl(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3721: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3722: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3723: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3724: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3725: /* insert into alloc_txn_details */
3726: --
3727: -- Bug: 983057 Do not create txn with zero curren alloc amount

Line 3846: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);

3842: ELSE /* if full allocation */
3843: v_prev_offset_amount := 0;
3844: END IF;
3845: v_curr_offset_amount:= NVL(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3846: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3847: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3848: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3849: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3850: /* insert into alloc_txn_details */

Line 3847: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);

3843: v_prev_offset_amount := 0;
3844: END IF;
3845: v_curr_offset_amount:= NVL(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3846: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3847: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3848: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3849: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3850: /* insert into alloc_txn_details */
3851: --

Line 3848: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);

3844: END IF;
3845: v_curr_offset_amount:= NVL(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3846: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3847: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3848: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3849: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3850: /* insert into alloc_txn_details */
3851: --
3852: -- Bug: 983057 Do not create txn with zero curren alloc amount

Line 3927: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);

3923: ELSE /* full allocation */
3924: v_prev_offset_amount:= 0;
3925: END IF;
3926: v_tot_offset_amount := (p_allocated_amount*-1) + v_prev_offset_amount ;
3927: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3928: v_curr_offset_amount:= pa_currency.round_currency_amt(p_allocated_amount*-1);
3929: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3930: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3931: /* insert into alloc_txn_details */

Line 3928: v_curr_offset_amount:= pa_currency.round_currency_amt(p_allocated_amount*-1);

3924: v_prev_offset_amount:= 0;
3925: END IF;
3926: v_tot_offset_amount := (p_allocated_amount*-1) + v_prev_offset_amount ;
3927: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3928: v_curr_offset_amount:= pa_currency.round_currency_amt(p_allocated_amount*-1);
3929: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3930: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3931: /* insert into alloc_txn_details */
3932: --

Line 3929: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);

3925: END IF;
3926: v_tot_offset_amount := (p_allocated_amount*-1) + v_prev_offset_amount ;
3927: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3928: v_curr_offset_amount:= pa_currency.round_currency_amt(p_allocated_amount*-1);
3929: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3930: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3931: /* insert into alloc_txn_details */
3932: --
3933: -- Bug: 983057 Do not create txn with zero curren alloc amount

Line 4048: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);

4044: v_prev_offset_amount:= 0;
4045: END IF;
4046: v_curr_offset_amount:= v_offset_extn_tabtype(I).offset_amount;
4047: v_tot_offset_amount:= NVl(v_curr_offset_amount,0) + NVl(v_prev_offset_amount,0);
4048: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
4049: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
4050: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
4051: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
4052: --

Line 4049: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);

4045: END IF;
4046: v_curr_offset_amount:= v_offset_extn_tabtype(I).offset_amount;
4047: v_tot_offset_amount:= NVl(v_curr_offset_amount,0) + NVl(v_prev_offset_amount,0);
4048: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
4049: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
4050: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
4051: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
4052: --
4053: -- Bug: 983057 Do not create txn with zero curren alloc amount

Line 4050: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);

4046: v_curr_offset_amount:= v_offset_extn_tabtype(I).offset_amount;
4047: v_tot_offset_amount:= NVl(v_curr_offset_amount,0) + NVl(v_prev_offset_amount,0);
4048: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
4049: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
4050: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
4051: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
4052: --
4053: -- Bug: 983057 Do not create txn with zero curren alloc amount
4054: --

Line 6216: , pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6212: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6213: + nvl(pta.i_tot_quantity,0),
6214: 0
6215: )),0) AMOUNT
6216: , pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6217: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6218: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6219: +nvl( pta.i_tot_billable_raw_cost,0),
6220: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 6319: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6315: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6316: + nvl(pta.i_tot_quantity,0),
6317: 0
6318: )),0) AMOUNT
6319: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6320: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6321: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6322: +nvl( pta.i_tot_billable_raw_cost,0),
6323: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 6433: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6429: +nvl(pta.i_tot_labor_hours,0),
6430: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6431: +nvl(pta.i_tot_quantity,0),
6432: 0)),0)AMOUNT
6433: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6434: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6435: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6436: +nvl( pta.i_tot_billable_raw_cost,0),
6437: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 6514: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6510: +nvl(pta.i_tot_labor_hours,0),
6511: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6512: + nvl(pta.i_tot_quantity,0),
6513: 0)),0)AMOUNT
6514: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6515: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6516: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6517: +nvl( pta.i_tot_billable_raw_cost,0),
6518: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 6596: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6592: +nvl(pta.i_tot_labor_hours,0),
6593: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6594: +nvl(pta.i_tot_quantity,0),
6595: 0)),0)AMOUNT
6596: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6597: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6598: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6599: +nvl( pta.i_tot_billable_raw_cost,0),
6600: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 6681: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6677: +nvl(pta.i_tot_labor_hours,0),
6678: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6679: +nvl(pta.i_tot_quantity,0),
6680: 0)),0)AMOUNT
6681: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6682: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6683: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6684: +nvl( pta.i_tot_billable_raw_cost,0),
6685: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 6792: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6788: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6789: +nvl(pta.i_tot_quantity,0),
6790: 0
6791: )),0) AMOUNT
6792: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6793: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6794: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6795: +nvl( pta.i_tot_billable_raw_cost,0),
6796: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 6882: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding

6878: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6879: +nvl(pta.i_tot_quantity,0),
6880: 0
6881: )),0) AMOUNT
6882: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6883: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6884: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6885: +nvl( pta.i_tot_billable_raw_cost,0),
6886: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 7418: v_net_fixed_amount := pa_currency.round_currency_amt( v_net_fixed_amount );

7414: v_resource_list_id := p_resource_list_id ;
7415: -- Create source details record for fixed amount defined at rule level
7416: If nvl(p_fixed_amount, 0) <> 0 then
7417: v_net_fixed_amount := p_fixed_amount*v_pool_percent;
7418: v_net_fixed_amount := pa_currency.round_currency_amt( v_net_fixed_amount );
7419: insert_alloc_run_src_det(p_rule_id, p_run_id, 0,
7420: 0, 0, NULL, p_fixed_amount,
7421: NULL , v_net_fixed_amount,
7422: G_creation_date, G_created_by,

Line 7497: v_pool_amount := pa_currency.round_currency_amt( v_pool_amount );

7493: IF P_DEBUG_MODE = 'Y' THEN
7494: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_amount '||to_char(v_amount));
7495: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_pool_amount '||to_char(v_pool_amount));
7496: END IF;
7497: v_pool_amount := pa_currency.round_currency_amt( v_pool_amount );
7498: v_amount := pa_currency.round_currency_amt( v_amount );
7499: insert_alloc_run_src_det(p_rule_id, p_run_id, src_det_rec.line_num,
7500: src_det_rec.project_id,
7501: src_det_rec.task_id, v_rlm_id, v_amount,

Line 7498: v_amount := pa_currency.round_currency_amt( v_amount );

7494: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_amount '||to_char(v_amount));
7495: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_pool_amount '||to_char(v_pool_amount));
7496: END IF;
7497: v_pool_amount := pa_currency.round_currency_amt( v_pool_amount );
7498: v_amount := pa_currency.round_currency_amt( v_amount );
7499: insert_alloc_run_src_det(p_rule_id, p_run_id, src_det_rec.line_num,
7500: src_det_rec.project_id,
7501: src_det_rec.task_id, v_rlm_id, v_amount,
7502: v_rlm_percent , v_pool_amount,

Line 7539: pa_currency.round_currency_amt(sum( decode (p_bal_type,

7535: +nvl( pta.i_tot_billable_burdened_cost,0),
7536: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7537: +nvl(pta.i_tot_burdened_cost,0),
7538: 0 )),
7539: pa_currency.round_currency_amt(sum( decode (p_bal_type,
7540: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
7541: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
7542: +nvl( pta.i_tot_billable_raw_cost,0),
7543: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 7609: pa_currency.round_currency_amt( sum( decode (p_bal_type,

7605: +nvl( pta.i_tot_billable_burdened_cost,0),
7606: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7607: +nvl(pta.i_tot_burdened_cost,0),
7608: 0 )),
7609: pa_currency.round_currency_amt( sum( decode (p_bal_type,
7610: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
7611: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
7612: +nvl( pta.i_tot_billable_raw_cost,0),
7613: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 7669: pa_currency.round_currency_amt(sum( decode (p_bal_type,

7665: +nvl( pta.i_tot_billable_burdened_cost,0),
7666: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7667: +nvl(pta.i_tot_burdened_cost,0),
7668: 0 )),
7669: pa_currency.round_currency_amt(sum( decode (p_bal_type,
7670: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
7671: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
7672: +nvl( pta.i_tot_billable_raw_cost,0),
7673: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

Line 7724: pa_currency.round_currency_amt(sum( decode (p_bal_type,

7720: +nvl( pta.i_tot_billable_burdened_cost,0),
7721: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7722: +nvl(pta.i_tot_burdened_cost,0),
7723: 0 )),
7724: pa_currency.round_currency_amt(sum( decode (p_bal_type,
7725: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
7726: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
7727: +nvl( pta.i_tot_billable_raw_cost,0),
7728: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)