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.IEX_COLL_IND dependencies on FND_CURRENCY

Line 964: --RETURN TO_CHAR(nvl(l_nsf_stop_payment_amount, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 30));

960: AND cr.customer_site_use_id = p_customer_site_use_id;
961: END IF;
962:
963: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
964: --RETURN TO_CHAR(nvl(l_nsf_stop_payment_amount, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 30));
965: l_num_val := nvl(l_nsf_stop_payment_amount, 0);
966: l_char_val := RTRIM(TO_CHAR(l_num_val,fnd_currency.get_format_mask(g_curr_rec.base_currency, 30)));
967: RETURN l_char_val;
968: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

Line 966: l_char_val := RTRIM(TO_CHAR(l_num_val,fnd_currency.get_format_mask(g_curr_rec.base_currency, 30)));

962:
963: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
964: --RETURN TO_CHAR(nvl(l_nsf_stop_payment_amount, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 30));
965: l_num_val := nvl(l_nsf_stop_payment_amount, 0);
966: l_char_val := RTRIM(TO_CHAR(l_num_val,fnd_currency.get_format_mask(g_curr_rec.base_currency, 30)));
967: RETURN l_char_val;
968: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
969:
970: EXCEPTION

Line 989: --RETURN(TO_CHAR(NVL(l_sales, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));

985: l_sales := COMP_TOT_REC(TRUNC(add_months(sysdate, -12)), TRUNC(sysdate),
986: p_party_id, p_cust_account_id, p_customer_site_use_id);
987:
988: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
989: --RETURN(TO_CHAR(NVL(l_sales, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
990: l_num_val := NVL(l_sales, 0);
991: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
992: RETURN l_char_val;
993: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

Line 991: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));

987:
988: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
989: --RETURN(TO_CHAR(NVL(l_sales, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
990: l_num_val := NVL(l_sales, 0);
991: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
992: RETURN l_char_val;
993: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
994:
995: END GET_SALES;

Line 1048: --RETURN(TO_CHAR(nvl(l_adj, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));

1044: AND adj.gl_date <= TRUNC(sysdate);
1045: END IF;
1046:
1047: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1048: --RETURN(TO_CHAR(nvl(l_adj, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1049: l_num_val := nvl(l_adj, 0);
1050: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1051: RETURN l_char_val;
1052: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

Line 1050: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));

1046:
1047: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1048: --RETURN(TO_CHAR(nvl(l_adj, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1049: l_num_val := nvl(l_adj, 0);
1050: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1051: RETURN l_char_val;
1052: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1053:
1054: EXCEPTION

Line 1527: -- RETURN (TO_CHAR(nvl(l_credit_limit,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));

1523: AND prof_amt.site_use_id = p_customer_site_use_id;
1524: END IF;
1525: -- End for the bug#8630157 by PNAVEENK
1526: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1527: -- RETURN (TO_CHAR(nvl(l_credit_limit,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1528: --l_num_val := nvl(l_credit_limit,0);
1529: l_num_val := l_credit_limit;
1530: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1531: RETURN l_char_val;

Line 1530: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));

1526: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1527: -- RETURN (TO_CHAR(nvl(l_credit_limit,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1528: --l_num_val := nvl(l_credit_limit,0);
1529: l_num_val := l_credit_limit;
1530: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1531: RETURN l_char_val;
1532: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1533:
1534: EXCEPTION

Line 1583: --RETURN TO_CHAR(nvl(l_high_credit_ytd,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50));

1579: AND trx_summ.site_use_id = p_customer_site_use_id;
1580: END IF;
1581: -- End for the bug#8630157 by PNAVEENK
1582: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1583: --RETURN TO_CHAR(nvl(l_high_credit_ytd,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50));
1584: l_num_val := nvl(l_high_credit_ytd,0);
1585: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1586: RETURN l_char_val;
1587: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

Line 1585: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));

1581: -- End for the bug#8630157 by PNAVEENK
1582: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1583: --RETURN TO_CHAR(nvl(l_high_credit_ytd,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50));
1584: l_num_val := nvl(l_high_credit_ytd,0);
1585: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1586: RETURN l_char_val;
1587: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1588:
1589: EXCEPTION