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))/
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))/
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))/