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 853: --RETURN TO_CHAR(nvl(l_nsf_stop_payment_amount, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 30));

849: AND cr.customer_site_use_id = p_customer_site_use_id;
850: END IF;
851:
852: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
853: --RETURN TO_CHAR(nvl(l_nsf_stop_payment_amount, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 30));
854: l_num_val := nvl(l_nsf_stop_payment_amount, 0);
855: l_char_val := RTRIM(TO_CHAR(l_num_val,fnd_currency.get_format_mask(g_curr_rec.base_currency, 30)));
856: RETURN l_char_val;
857: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

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

851:
852: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
853: --RETURN TO_CHAR(nvl(l_nsf_stop_payment_amount, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 30));
854: l_num_val := nvl(l_nsf_stop_payment_amount, 0);
855: l_char_val := RTRIM(TO_CHAR(l_num_val,fnd_currency.get_format_mask(g_curr_rec.base_currency, 30)));
856: RETURN l_char_val;
857: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
858:
859: EXCEPTION

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

874: l_sales := COMP_TOT_REC(TRUNC(add_months(sysdate, -12)), TRUNC(sysdate),
875: p_party_id, p_cust_account_id, p_customer_site_use_id);
876:
877: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
878: --RETURN(TO_CHAR(NVL(l_sales, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
879: l_num_val := NVL(l_sales, 0);
880: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
881: RETURN l_char_val;
882: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

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

876:
877: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
878: --RETURN(TO_CHAR(NVL(l_sales, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
879: l_num_val := NVL(l_sales, 0);
880: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
881: RETURN l_char_val;
882: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
883:
884: END GET_SALES;

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

933: AND adj.gl_date <= TRUNC(sysdate);
934: END IF;
935:
936: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
937: --RETURN(TO_CHAR(nvl(l_adj, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
938: l_num_val := nvl(l_adj, 0);
939: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
940: RETURN l_char_val;
941: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

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

935:
936: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
937: --RETURN(TO_CHAR(nvl(l_adj, 0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
938: l_num_val := nvl(l_adj, 0);
939: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
940: RETURN l_char_val;
941: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
942:
943: EXCEPTION

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

1407: AND prof_amt.site_use_id = p_customer_site_use_id;
1408: END IF;
1409:
1410: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1411: -- RETURN (TO_CHAR(nvl(l_credit_limit,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1412: --l_num_val := nvl(l_credit_limit,0);
1413: l_num_val := l_credit_limit;
1414: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1415: RETURN l_char_val;

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

1410: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1411: -- RETURN (TO_CHAR(nvl(l_credit_limit,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1412: --l_num_val := nvl(l_credit_limit,0);
1413: l_num_val := l_credit_limit;
1414: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1415: RETURN l_char_val;
1416: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1417:
1418: EXCEPTION

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

1464: AND trx_summ.site_use_id = p_customer_site_use_id;
1465: END IF;
1466:
1467: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1468: --RETURN TO_CHAR(nvl(l_high_credit_ytd,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50));
1469: l_num_val := nvl(l_high_credit_ytd,0);
1470: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1471: RETURN l_char_val;
1472: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable

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

1466:
1467: --BEGIN-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1468: --RETURN TO_CHAR(nvl(l_high_credit_ytd,0), fnd_currency.get_format_mask(g_curr_rec.base_currency, 50));
1469: l_num_val := nvl(l_high_credit_ytd,0);
1470: l_char_val := RTRIM(TO_CHAR(l_num_val, fnd_currency.get_format_mask(g_curr_rec.base_currency, 50)));
1471: RETURN l_char_val;
1472: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1473:
1474: EXCEPTION