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 172: pa_currency.SET_CURRENCY_INFO ;

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

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

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

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

2685: END IF;
2686: CLOSE get_gl_amount;
2687: -- Commented the following line as a part of fixing rounding issues.
2688: -- The rounding is done for eligible amount
2689: -- v_amount:= pa_currency.round_currency_amt( NVl(v_amount,0) );
2690: IF P_DEBUG_MODE = 'Y' THEN
2691: pa_debug.write_file('calculate_src_GL_amounts: ' || 'LOG', 'v_amount is: '|| to_char(v_amount) );
2692: END IF;
2693: /* then insert into gl_source_det */

Line 2706: , pa_currency.round_currency_amt(v_amount*

2702: , G_last_updated_by
2703: , G_last_update_login
2704: , gl_source_rec.source_percent
2705: , v_amount
2706: , pa_currency.round_currency_amt(v_amount*
2707: (gl_source_rec.source_percent/100)*
2708: ( v_pool_percent/100))
2709: ) ;
2710: IF P_DEBUG_MODE = 'Y' THEN

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

3472: v_curr_alloc_amount := NVl(v_curr_alloc_amount,0) - NVl(v_prev_alloc_amount, 0);
3473: END IF;
3474: -- End:added as part of the bug 13949738
3475:
3476: v_tot_alloc_amount:= pa_currency.round_currency_amt(v_tot_alloc_amount);
3477: v_prev_alloc_amount:= pa_currency.round_currency_amt(v_prev_alloc_amount);
3478: v_curr_alloc_amount:= pa_currency.round_currency_amt(v_curr_alloc_amount);
3479: IF P_DEBUG_MODE = 'Y' THEN
3480: pa_debug.write_file('create_target_txns: ' || 'LOG', 'Amounts after rounding' );

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

3473: END IF;
3474: -- End:added as part of the bug 13949738
3475:
3476: v_tot_alloc_amount:= pa_currency.round_currency_amt(v_tot_alloc_amount);
3477: v_prev_alloc_amount:= pa_currency.round_currency_amt(v_prev_alloc_amount);
3478: v_curr_alloc_amount:= pa_currency.round_currency_amt(v_curr_alloc_amount);
3479: IF P_DEBUG_MODE = 'Y' THEN
3480: pa_debug.write_file('create_target_txns: ' || 'LOG', 'Amounts after rounding' );
3481: pa_debug.write_file('create_target_txns: ' || 'LOG', 'v_tot_alloc_amount:'||to_char(v_tot_alloc_amount) );

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

3474: -- End:added as part of the bug 13949738
3475:
3476: v_tot_alloc_amount:= pa_currency.round_currency_amt(v_tot_alloc_amount);
3477: v_prev_alloc_amount:= pa_currency.round_currency_amt(v_prev_alloc_amount);
3478: v_curr_alloc_amount:= pa_currency.round_currency_amt(v_curr_alloc_amount);
3479: IF P_DEBUG_MODE = 'Y' THEN
3480: pa_debug.write_file('create_target_txns: ' || 'LOG', 'Amounts after rounding' );
3481: pa_debug.write_file('create_target_txns: ' || 'LOG', 'v_tot_alloc_amount:'||to_char(v_tot_alloc_amount) );
3482: pa_debug.write_file('create_target_txns: ' || 'LOG', 'v_prev_alloc_amount:'||to_char(v_prev_alloc_amount) );

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

3740: ELSE /* if full allocation */
3741: v_prev_offset_amount:= 0;
3742: END IF;
3743: v_curr_offset_amount := NVl(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3744: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3745: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3746: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3747: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3748: /* insert into alloc_txn_details */

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

3741: v_prev_offset_amount:= 0;
3742: END IF;
3743: v_curr_offset_amount := NVl(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3744: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3745: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3746: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3747: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3748: /* insert into alloc_txn_details */
3749: --

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

3742: END IF;
3743: v_curr_offset_amount := NVl(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3744: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3745: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3746: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3747: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3748: /* insert into alloc_txn_details */
3749: --
3750: -- Bug: 983057 Do not create txn with zero curren alloc amount

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

3865: ELSE /* if full allocation */
3866: v_prev_offset_amount := 0;
3867: END IF;
3868: v_curr_offset_amount:= NVL(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3869: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3870: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3871: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3872: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3873: /* insert into alloc_txn_details */

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

3866: v_prev_offset_amount := 0;
3867: END IF;
3868: v_curr_offset_amount:= NVL(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3869: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3870: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3871: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3872: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3873: /* insert into alloc_txn_details */
3874: --

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

3867: END IF;
3868: v_curr_offset_amount:= NVL(v_tot_offset_amount,0) - NVL(v_prev_offset_amount,0);
3869: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3870: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3871: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
3872: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3873: /* insert into alloc_txn_details */
3874: --
3875: -- Bug: 983057 Do not create txn with zero curren alloc amount

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

3946: ELSE /* full allocation */
3947: v_prev_offset_amount:= 0;
3948: END IF;
3949: v_tot_offset_amount := (p_allocated_amount*-1) + v_prev_offset_amount ;
3950: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3951: v_curr_offset_amount:= pa_currency.round_currency_amt(p_allocated_amount*-1);
3952: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3953: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3954: /* insert into alloc_txn_details */

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

3947: v_prev_offset_amount:= 0;
3948: END IF;
3949: v_tot_offset_amount := (p_allocated_amount*-1) + v_prev_offset_amount ;
3950: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3951: v_curr_offset_amount:= pa_currency.round_currency_amt(p_allocated_amount*-1);
3952: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3953: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3954: /* insert into alloc_txn_details */
3955: --

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

3948: END IF;
3949: v_tot_offset_amount := (p_allocated_amount*-1) + v_prev_offset_amount ;
3950: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
3951: v_curr_offset_amount:= pa_currency.round_currency_amt(p_allocated_amount*-1);
3952: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
3953: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
3954: /* insert into alloc_txn_details */
3955: --
3956: -- Bug: 983057 Do not create txn with zero curren alloc amount

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

4067: v_prev_offset_amount:= 0;
4068: END IF;
4069: v_curr_offset_amount:= v_offset_extn_tabtype(I).offset_amount;
4070: v_tot_offset_amount:= NVl(v_curr_offset_amount,0) + NVl(v_prev_offset_amount,0);
4071: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
4072: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
4073: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
4074: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
4075: --

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

4068: END IF;
4069: v_curr_offset_amount:= v_offset_extn_tabtype(I).offset_amount;
4070: v_tot_offset_amount:= NVl(v_curr_offset_amount,0) + NVl(v_prev_offset_amount,0);
4071: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
4072: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
4073: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
4074: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
4075: --
4076: -- Bug: 983057 Do not create txn with zero curren alloc amount

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

4069: v_curr_offset_amount:= v_offset_extn_tabtype(I).offset_amount;
4070: v_tot_offset_amount:= NVl(v_curr_offset_amount,0) + NVl(v_prev_offset_amount,0);
4071: v_tot_offset_amount:= pa_currency.round_currency_amt(v_tot_offset_amount);
4072: v_prev_offset_amount:= pa_currency.round_currency_amt(v_prev_offset_amount);
4073: v_curr_offset_amount:= pa_currency.round_currency_amt(v_curr_offset_amount);
4074: v_sum_tot_offsets := v_sum_tot_offsets + v_tot_offset_amount ;
4075: --
4076: -- Bug: 983057 Do not create txn with zero curren alloc amount
4077: --

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

6235: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6236: + nvl(pta.i_tot_quantity,0),
6237: 0
6238: )),0) AMOUNT
6239: , pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6240: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6241: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6242: +nvl( pta.i_tot_billable_raw_cost,0),
6243: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

6338: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6339: + nvl(pta.i_tot_quantity,0),
6340: 0
6341: )),0) AMOUNT
6342: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6343: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6344: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6345: +nvl( pta.i_tot_billable_raw_cost,0),
6346: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

6452: +nvl(pta.i_tot_labor_hours,0),
6453: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6454: +nvl(pta.i_tot_quantity,0),
6455: 0)),0)AMOUNT
6456: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6457: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6458: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6459: +nvl( pta.i_tot_billable_raw_cost,0),
6460: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

6533: +nvl(pta.i_tot_labor_hours,0),
6534: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6535: + nvl(pta.i_tot_quantity,0),
6536: 0)),0)AMOUNT
6537: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6538: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6539: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6540: +nvl( pta.i_tot_billable_raw_cost,0),
6541: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

6615: +nvl(pta.i_tot_labor_hours,0),
6616: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6617: +nvl(pta.i_tot_quantity,0),
6618: 0)),0)AMOUNT
6619: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6620: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6621: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6622: +nvl( pta.i_tot_billable_raw_cost,0),
6623: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

6700: +nvl(pta.i_tot_labor_hours,0),
6701: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6702: +nvl(pta.i_tot_quantity,0),
6703: 0)),0)AMOUNT
6704: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6705: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6706: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6707: +nvl( pta.i_tot_billable_raw_cost,0),
6708: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

6811: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6812: +nvl(pta.i_tot_quantity,0),
6813: 0
6814: )),0) AMOUNT
6815: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6816: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6817: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6818: +nvl( pta.i_tot_billable_raw_cost,0),
6819: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

6901: 'TOT_QUANTITY', nvl(pta.tot_quantity,0)
6902: +nvl(pta.i_tot_quantity,0),
6903: 0
6904: )),0) AMOUNT
6905: ,pa_currency.round_currency_amt(NVL(sum( decode (p_bal_type, --Bug 3590551:Introduced rounding
6906: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
6907: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
6908: +nvl( pta.i_tot_billable_raw_cost,0),
6909: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

7475: v_resource_list_id := p_resource_list_id ;
7476: -- Create source details record for fixed amount defined at rule level
7477: If nvl(p_fixed_amount, 0) <> 0 then
7478: v_net_fixed_amount := p_fixed_amount*v_pool_percent;
7479: v_net_fixed_amount := pa_currency.round_currency_amt( v_net_fixed_amount );
7480: insert_alloc_run_src_det(p_rule_id, p_run_id, 0,
7481: 0, 0, NULL, p_fixed_amount,
7482: NULL , v_net_fixed_amount,
7483: G_creation_date, G_created_by,

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

7554: IF P_DEBUG_MODE = 'Y' THEN
7555: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_amount '||to_char(v_amount));
7556: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_pool_amount '||to_char(v_pool_amount));
7557: END IF;
7558: v_pool_amount := pa_currency.round_currency_amt( v_pool_amount );
7559: v_amount := pa_currency.round_currency_amt( v_amount );
7560: insert_alloc_run_src_det(p_rule_id, p_run_id, src_det_rec.line_num,
7561: src_det_rec.project_id,
7562: src_det_rec.task_id, v_rlm_id, v_amount,

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

7555: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_amount '||to_char(v_amount));
7556: pa_debug.write_file('cal_amounts_from_projects: ' || 'LOG', 'v_pool_amount '||to_char(v_pool_amount));
7557: END IF;
7558: v_pool_amount := pa_currency.round_currency_amt( v_pool_amount );
7559: v_amount := pa_currency.round_currency_amt( v_amount );
7560: insert_alloc_run_src_det(p_rule_id, p_run_id, src_det_rec.line_num,
7561: src_det_rec.project_id,
7562: src_det_rec.task_id, v_rlm_id, v_amount,
7563: v_rlm_percent , v_pool_amount,

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

7596: +nvl( pta.i_tot_billable_burdened_cost,0),
7597: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7598: +nvl(pta.i_tot_burdened_cost,0),
7599: 0 )),
7600: pa_currency.round_currency_amt(sum( decode (p_bal_type,
7601: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
7602: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
7603: +nvl( pta.i_tot_billable_raw_cost,0),
7604: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

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

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

7726: +nvl( pta.i_tot_billable_burdened_cost,0),
7727: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7728: +nvl(pta.i_tot_burdened_cost,0),
7729: 0 )),
7730: pa_currency.round_currency_amt(sum( decode (p_bal_type,
7731: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
7732: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
7733: +nvl( pta.i_tot_billable_raw_cost,0),
7734: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)

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

7781: +nvl( pta.i_tot_billable_burdened_cost,0),
7782: 'TOT_BURDENED_COST', nvl(pta.tot_burdened_cost,0)+
7783: +nvl(pta.i_tot_burdened_cost,0),
7784: 0 )),
7785: pa_currency.round_currency_amt(sum( decode (p_bal_type,
7786: 'TOT_RAW_COST', nvl(pta.tot_raw_cost,0) +nvl( pta.i_tot_raw_cost,0),
7787: 'TOT_BILLABLE_RAW_COST', nvl(pta.tot_billable_raw_cost,0)
7788: +nvl( pta.i_tot_billable_raw_cost,0),
7789: 'TOT_BILLABLE_BURDENED_COST', nvl(pta.tot_billable_burdened_cost,0)