DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_CURRENCY

Line 750: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

746:
747: -- if cost is null then derive the cost based on rate and quantity
748: If p_override_trxn_raw_cost is NULL Then
749: If NVL(p_quantity,0) <> 0 then
750: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
751: (l_txn_raw_cost_rate * NVL(p_quantity,1), l_txn_curr_code );
752: Else
753: l_txn_raw_cost := null;
754: End If;

Line 987: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

983: Raise l_no_rate_found;
984: End If;
985:
986: If l_txn_curr_code is NOT NULL Then
987: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
988: (l_txn_raw_cost_rate * NVL(p_quantity,1), l_txn_curr_code);
989: End If;
990: EXCEPTION
991: WHEN NO_DATA_FOUND THEN

Line 1056: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1052: End If;
1053:
1054: If l_txn_curr_code is NOT NULL Then
1055: -- this is the list price per unit
1056: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1057: (l_txn_raw_cost_rate * NVL(p_quantity,1), l_txn_curr_code );
1058: End If;
1059: end if; --End of if condition added for bug 9896718
1060: /*i Bug fix:4154009 The Api returns the rate not the cost So need not re derive the rate

Line 1420: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1416: End If;
1417:
1418: If l_txn_curr_code is NOT NULL Then
1419: l_txn_raw_cost_rate := l_txn_raw_cost_rate * NVL(l_cost_rate_multiplier,1);
1420: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1421: (l_txn_raw_cost_rate * NVL(p_quantity,0), l_txn_curr_code );
1422: End If;
1423:
1424: End If;

Line 1478: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1474: RAISE l_no_rate_found;
1475: End If;
1476:
1477: If l_txn_raw_cost_rate is NOT NULL and l_txn_curr_code is NOT NULL Then
1478: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1479: (l_txn_raw_cost_rate * NVL(p_quantity,0), l_txn_curr_code );
1480: End If;
1481: l_stage := 'ExpcostRateCur['||l_txn_curr_code||']ExpCostRate['||l_txn_raw_cost_rate||']' ;
1482: print_msg(l_debug_flag,l_stage);

Line 1502: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1498: RAISE l_no_rate_found;
1499: End If;
1500:
1501: If l_txn_raw_cost_rate is NOT NULL and l_txn_curr_code is NOT NULL Then
1502: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1503: (l_txn_raw_cost_rate * NVL(p_quantity,0),
1504: l_txn_curr_code );
1505: End If;
1506: l_stage := 'Get_curr_code['||l_txn_curr_code||']ExpCostRate['||

Line 1606: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1602: RAISE l_no_rate_found;
1603: End If;
1604: If l_txn_curr_code is NOT NULL Then
1605: l_txn_raw_cost_rate := l_txn_raw_cost_rate * NVL(l_cost_rate_multiplier,1);
1606: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1607: (l_txn_raw_cost_rate * NVL(p_quantity,0), l_txn_curr_code );
1608: End If;
1609:
1610: END If; -- end of the transaction type

Line 1640: l_burden_cost := pa_currency.round_trans_currency_amt1

1636:
1637: Elsif p_override_burden_cost_rate is NOT NULL Then
1638: -- if quantity is zero this is amount based so multiply cost * rate
1639: If NVL(p_quantity,0) = 0 Then
1640: l_burden_cost := pa_currency.round_trans_currency_amt1
1641: (p_override_burden_cost_rate * x_trxn_raw_cost ,l_txn_curr_code ) ;
1642: Else
1643: l_burden_cost := pa_currency.round_trans_currency_amt1
1644: (p_override_burden_cost_rate * NVL(p_quantity,1),l_txn_curr_code ) ;

Line 1643: l_burden_cost := pa_currency.round_trans_currency_amt1

1639: If NVL(p_quantity,0) = 0 Then
1640: l_burden_cost := pa_currency.round_trans_currency_amt1
1641: (p_override_burden_cost_rate * x_trxn_raw_cost ,l_txn_curr_code ) ;
1642: Else
1643: l_burden_cost := pa_currency.round_trans_currency_amt1
1644: (p_override_burden_cost_rate * NVL(p_quantity,1),l_txn_curr_code ) ;
1645: End If;
1646: End If;
1647:

Line 1722: l_burden_cost := pa_currency.round_trans_currency_amt1((P_quantity*l_burden_cost_rate),l_txn_curr_code);

1718: End If;
1719: */
1720: If (NVL(P_quantity, 0) <> 0 AND NVL(l_txn_raw_cost_rate,0) <> 0 ) Then
1721: l_burden_cost_rate := (l_txn_raw_cost_rate * l_burden_multiplier ) + l_txn_raw_cost_rate;
1722: l_burden_cost := pa_currency.round_trans_currency_amt1((P_quantity*l_burden_cost_rate),l_txn_curr_code);
1723: Else
1724: l_burden_cost := (l_txn_raw_cost * l_burden_multiplier) + l_txn_raw_cost ;
1725: If l_burden_cost = l_txn_raw_cost Then
1726: l_burden_cost_rate := l_txn_raw_cost_rate;

Line 2033: l_nlr_raw_cost := pa_currency.round_trans_currency_amt1

2029: If p_nlr_trxn_raw_cost is NOT NULL Then
2030: l_nlr_raw_cost := p_nlr_trxn_raw_cost;
2031: ElsIF l_cost_rate_curr_code is NOT NULL Then
2032: If l_nlr_raw_cost_rate is NOT NULL Then
2033: l_nlr_raw_cost := pa_currency.round_trans_currency_amt1
2034: (l_nlr_raw_cost_rate * NVL(p_quantity,0), l_cost_rate_curr_code );
2035: End If;
2036:
2037: End If;

Line 2486: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1

2482: ,P_conversion_date => p_Conversion_Date );
2483: If NVL(l_usrRateAllowed,'N') = 'Y' Then
2484: If p_To_Curr_Exchange_Rate is NOT NULL Then
2485:
2486: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2487: (p_txn_raw_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2488: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2489: (p_txn_burden_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2490: x_To_Curr_Exchange_Rate := p_To_Curr_Exchange_Rate ;

Line 2488: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1

2484: If p_To_Curr_Exchange_Rate is NOT NULL Then
2485:
2486: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2487: (p_txn_raw_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2488: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2489: (p_txn_burden_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2490: x_To_Curr_Exchange_Rate := p_To_Curr_Exchange_Rate ;
2491:
2492: If NVL(p_txn_quantity,0) <> 0 Then

Line 2535: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1

2531: ,x_denominator => l_denominator
2532: ,x_numerator => l_numerator
2533: ,x_rate => l_rate
2534: );
2535: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2536: (p_txn_raw_cost * NVL(l_rate,1),p_To_Curr_code);
2537: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2538: (p_txn_burden_cost * NVL(l_rate,1),p_To_Curr_code);
2539: x_To_Curr_Exchange_Rate := l_rate ;

Line 2537: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1

2533: ,x_rate => l_rate
2534: );
2535: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2536: (p_txn_raw_cost * NVL(l_rate,1),p_To_Curr_code);
2537: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2538: (p_txn_burden_cost * NVL(l_rate,1),p_To_Curr_code);
2539: x_To_Curr_Exchange_Rate := l_rate ;
2540:
2541: If NVL(p_txn_quantity,0) <> 0 Then