DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_CURRENCY

Line 722: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

718:
719: -- if cost is null then derive the cost based on rate and quantity
720: If p_override_trxn_raw_cost is NULL Then
721: If NVL(p_quantity,0) <> 0 then
722: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
723: (l_txn_raw_cost_rate * NVL(p_quantity,1), l_txn_curr_code );
724: Else
725: l_txn_raw_cost := null;
726: End If;

Line 959: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

955: Raise l_no_rate_found;
956: End If;
957:
958: If l_txn_curr_code is NOT NULL Then
959: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
960: (l_txn_raw_cost_rate * NVL(p_quantity,1), l_txn_curr_code);
961: End If;
962: EXCEPTION
963: WHEN NO_DATA_FOUND THEN

Line 1022: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1018: End If;
1019:
1020: If l_txn_curr_code is NOT NULL Then
1021: -- this is the list price per unit
1022: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1023: (l_txn_raw_cost_rate * NVL(p_quantity,1), l_txn_curr_code );
1024: End If;
1025: /*i Bug fix:4154009 The Api returns the rate not the cost So need not re derive the rate
1026: If l_txn_raw_cost_rate is NULL Then

Line 1108: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1104: End If;
1105:
1106: If l_txn_curr_code is NOT NULL Then
1107: l_txn_raw_cost_rate := l_txn_raw_cost_rate * NVL(l_cost_rate_multiplier,1);
1108: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1109: (l_txn_raw_cost_rate * NVL(p_quantity,0), l_txn_curr_code );
1110: End If;
1111:
1112: End If;

Line 1166: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1162: RAISE l_no_rate_found;
1163: End If;
1164:
1165: If l_txn_raw_cost_rate is NOT NULL and l_txn_curr_code is NOT NULL Then
1166: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1167: (l_txn_raw_cost_rate * NVL(p_quantity,0), l_txn_curr_code );
1168: End If;
1169: l_stage := 'ExpcostRateCur['||l_txn_curr_code||']ExpCostRate['||l_txn_raw_cost_rate||']' ;
1170: print_msg(l_debug_flag,l_stage);

Line 1190: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1186: RAISE l_no_rate_found;
1187: End If;
1188:
1189: If l_txn_raw_cost_rate is NOT NULL and l_txn_curr_code is NOT NULL Then
1190: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1191: (l_txn_raw_cost_rate * NVL(p_quantity,0),
1192: l_txn_curr_code );
1193: End If;
1194: l_stage := 'Get_curr_code['||l_txn_curr_code||']ExpCostRate['||

Line 1294: l_txn_raw_cost := pa_currency.round_trans_currency_amt1

1290: RAISE l_no_rate_found;
1291: End If;
1292: If l_txn_curr_code is NOT NULL Then
1293: l_txn_raw_cost_rate := l_txn_raw_cost_rate * NVL(l_cost_rate_multiplier,1);
1294: l_txn_raw_cost := pa_currency.round_trans_currency_amt1
1295: (l_txn_raw_cost_rate * NVL(p_quantity,0), l_txn_curr_code );
1296: End If;
1297:
1298: END If; -- end of the transaction type

Line 1328: l_burden_cost := pa_currency.round_trans_currency_amt1

1324:
1325: Elsif p_override_burden_cost_rate is NOT NULL Then
1326: -- if quantity is zero this is amount based so multiply cost * rate
1327: If NVL(p_quantity,0) = 0 Then
1328: l_burden_cost := pa_currency.round_trans_currency_amt1
1329: (p_override_burden_cost_rate * x_trxn_raw_cost ,l_txn_curr_code ) ;
1330: Else
1331: l_burden_cost := pa_currency.round_trans_currency_amt1
1332: (p_override_burden_cost_rate * NVL(p_quantity,1),l_txn_curr_code ) ;

Line 1331: l_burden_cost := pa_currency.round_trans_currency_amt1

1327: If NVL(p_quantity,0) = 0 Then
1328: l_burden_cost := pa_currency.round_trans_currency_amt1
1329: (p_override_burden_cost_rate * x_trxn_raw_cost ,l_txn_curr_code ) ;
1330: Else
1331: l_burden_cost := pa_currency.round_trans_currency_amt1
1332: (p_override_burden_cost_rate * NVL(p_quantity,1),l_txn_curr_code ) ;
1333: End If;
1334: End If;
1335:

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

1406: End If;
1407: */
1408: If (NVL(P_quantity, 0) <> 0 AND NVL(l_txn_raw_cost_rate,0) <> 0 ) Then
1409: l_burden_cost_rate := (l_txn_raw_cost_rate * l_burden_multiplier ) + l_txn_raw_cost_rate;
1410: l_burden_cost := pa_currency.round_trans_currency_amt1((P_quantity*l_burden_cost_rate),l_txn_curr_code);
1411: Else
1412: l_burden_cost := (l_txn_raw_cost * l_burden_multiplier) + l_txn_raw_cost ;
1413: If l_burden_cost = l_txn_raw_cost Then
1414: l_burden_cost_rate := l_txn_raw_cost_rate;

Line 1721: l_nlr_raw_cost := pa_currency.round_trans_currency_amt1

1717: If p_nlr_trxn_raw_cost is NOT NULL Then
1718: l_nlr_raw_cost := p_nlr_trxn_raw_cost;
1719: ElsIF l_cost_rate_curr_code is NOT NULL Then
1720: If l_nlr_raw_cost_rate is NOT NULL Then
1721: l_nlr_raw_cost := pa_currency.round_trans_currency_amt1
1722: (l_nlr_raw_cost_rate * NVL(p_quantity,0), l_cost_rate_curr_code );
1723: End If;
1724:
1725: End If;

Line 2174: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1

2170: ,P_conversion_date => p_Conversion_Date );
2171: If NVL(l_usrRateAllowed,'N') = 'Y' Then
2172: If p_To_Curr_Exchange_Rate is NOT NULL Then
2173:
2174: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2175: (p_txn_raw_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2176: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2177: (p_txn_burden_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2178: x_To_Curr_Exchange_Rate := p_To_Curr_Exchange_Rate ;

Line 2176: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1

2172: If p_To_Curr_Exchange_Rate is NOT NULL Then
2173:
2174: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2175: (p_txn_raw_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2176: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2177: (p_txn_burden_cost * NVL(p_To_Curr_Exchange_Rate,1),P_to_curr_code);
2178: x_To_Curr_Exchange_Rate := p_To_Curr_Exchange_Rate ;
2179:
2180: If NVL(p_txn_quantity,0) <> 0 Then

Line 2223: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1

2219: ,x_denominator => l_denominator
2220: ,x_numerator => l_numerator
2221: ,x_rate => l_rate
2222: );
2223: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2224: (p_txn_raw_cost * NVL(l_rate,1),p_To_Curr_code);
2225: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2226: (p_txn_burden_cost * NVL(l_rate,1),p_To_Curr_code);
2227: x_To_Curr_Exchange_Rate := l_rate ;

Line 2225: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1

2221: ,x_rate => l_rate
2222: );
2223: x_To_Curr_raw_cost := pa_currency.round_trans_currency_amt1
2224: (p_txn_raw_cost * NVL(l_rate,1),p_To_Curr_code);
2225: x_To_Curr_burden_cost := pa_currency.round_trans_currency_amt1
2226: (p_txn_burden_cost * NVL(l_rate,1),p_To_Curr_code);
2227: x_To_Curr_Exchange_Rate := l_rate ;
2228:
2229: If NVL(p_txn_quantity,0) <> 0 Then