DBA Data[Home] [Help]

APPS.POA_BIS_ALERTS dependencies on FND_CURRENCY

Line 300: l_format_mask := FND_CURRENCY.get_format_mask(p_currency, 25);

296: l_leakage_amount VARCHAR2(120);
297: l_potential_savings VARCHAR2(120);
298: l_format_mask VARCHAR2(120);
299: BEGIN
300: l_format_mask := FND_CURRENCY.get_format_mask(p_currency, 25);
301:
302: SELECT
303: TO_CHAR(DECODE(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
304: 0,0,100*SUM(NVL(poa.pot_contract_amount,0) *NVL(gl.conversion_rate,1))/

Line 357: l_format_mask := FND_CURRENCY.get_format_mask(p_currency, 25);

353: l_leakage_amount VARCHAR2(120);
354: l_potential_savings VARCHAR2(120);
355: l_format_mask VARCHAR2(120);
356: BEGIN
357: l_format_mask := FND_CURRENCY.get_format_mask(p_currency, 25);
358:
359: SELECT
360: TO_CHAR(DECODE(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
361: 0,0,100*SUM(NVL(poa.pot_contract_amount,0) *NVL(gl.conversion_rate,1))/

Line 415: l_format_mask := FND_CURRENCY.get_format_mask(p_currency, 25);

411: l_leakage_amount VARCHAR2(120);
412: l_potential_savings VARCHAR2(120);
413: l_format_mask VARCHAR2(120);
414: BEGIN
415: l_format_mask := FND_CURRENCY.get_format_mask(p_currency, 25);
416:
417: SELECT
418: TO_CHAR(DECODE(SUM(NVL(poa.purchase_amount,0)*NVL(gl.conversion_rate,1)),
419: 0,0,100*SUM(NVL(poa.pot_contract_amount,0) *NVL(gl.conversion_rate,1))/