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

Line 63: return to_char(p_balance*v_rate, FND_CURRENCY.GET_FORMAT_MASK(p_to_curr, 30)); else

59: if p_balance is null then
60: return null;
61: else
62: if p_balance >= 0 then
63: return to_char(p_balance*v_rate, FND_CURRENCY.GET_FORMAT_MASK(p_to_curr, 30)); else
64: return concat('-', to_char(-1*p_balance*v_rate, FND_CURRENCY.GET_FORMAT_MASK(p_to_curr, 30)));
65: end if;
66: end if;
67: end if;

Line 64: return concat('-', to_char(-1p_balancev_rate, FND_CURRENCY.GET_FORMAT_MASK(p_to_curr, 30)));

60: return null;
61: else
62: if p_balance >= 0 then
63: return to_char(p_balance*v_rate, FND_CURRENCY.GET_FORMAT_MASK(p_to_curr, 30)); else
64: return concat('-', to_char(-1*p_balance*v_rate, FND_CURRENCY.GET_FORMAT_MASK(p_to_curr, 30)));
65: end if;
66: end if;
67: end if;
68:

Line 89: return to_char(p_balance, FND_CURRENCY.GET_FORMAT_MASK(p_from_curr, 30)); else

85: if p_balance is null then
86: return null;
87: else
88: if p_balance >= 0 then
89: return to_char(p_balance, FND_CURRENCY.GET_FORMAT_MASK(p_from_curr, 30)); else
90: return concat('-', to_char(-1*p_balance, FND_CURRENCY.GET_FORMAT_MASK(p_from_curr, 30)));
91: end if;
92: end if;
93: END;

Line 90: return concat('-', to_char(-1*p_balance, FND_CURRENCY.GET_FORMAT_MASK(p_from_curr, 30)));

86: return null;
87: else
88: if p_balance >= 0 then
89: return to_char(p_balance, FND_CURRENCY.GET_FORMAT_MASK(p_from_curr, 30)); else
90: return concat('-', to_char(-1*p_balance, FND_CURRENCY.GET_FORMAT_MASK(p_from_curr, 30)));
91: end if;
92: end if;
93: END;
94:

Line 130: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

126: and bb.LEDGER_BALANCE is not null
127: and pb.PROJECTED_BALANCE is not null
128: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
129:
130: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
131: return v_variance;
132: end if;
133: end if;
134:

Line 157: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

153: and pb.BALANCE_DATE = p_balance_date
154: and bb.VALUE_DATED_BALANCE is not null
155: and pb.PROJECTED_BALANCE is not null
156: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
157: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
158: return v_variance;
159: end if;
160: end if;
161:

Line 183: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

179: and pb.BALANCE_DATE = p_balance_date
180: and bb.AVAILABLE_BALANCE is not null
181: and pb.PROJECTED_BALANCE is not null
182: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
183: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
184: return v_variance;
185: end if;
186: end if;
187:

Line 209: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

205: and pb.BALANCE_DATE = p_balance_date
206: and bb.ONE_DAY_FLOAT is not null
207: and pb.PROJECTED_BALANCE is not null
208: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
209: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
210: return v_variance;
211: end if;
212: end if;
213:

Line 235: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

231: and pb.BALANCE_DATE = p_balance_date
232: and bb.TWO_DAY_FLOAT is not null
233: and pb.PROJECTED_BALANCE is not null
234: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
235: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
236: return v_variance;
237: end if;
238: end if;
239:

Line 261: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

257: and pb.BALANCE_DATE = p_balance_date
258: and bb.AVERAGE_CLOSE_LEDGER_MTD is not null
259: and pb.PROJECTED_BALANCE is not null
260: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
261: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
262: return v_variance;
263: end if;
264: end if;
265:

Line 287: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

283: and pb.BALANCE_DATE = p_balance_date
284: and bb.AVERAGE_CLOSE_LEDGER_YTD is not null
285: and pb.PROJECTED_BALANCE is not null
286: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
287: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
288: return v_variance;
289: end if;
290: end if;
291:

Line 313: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

309: and pb.BALANCE_DATE = p_balance_date
310: and bb.AVERAGE_CLOSE_AVAILABLE_MTD is not null
311: and pb.PROJECTED_BALANCE is not null
312: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
313: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
314: return v_variance;
315: end if;
316: end if;
317:

Line 339: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));

335: and pb.BALANCE_DATE = p_balance_date
336: and bb.AVERAGE_CLOSE_AVAILABLE_YTD is not null
337: and pb.PROJECTED_BALANCE is not null
338: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;
339: -- return to_char(v_variance, FND_CURRENCY.GET_FORMAT_MASK(v_currency_code, 30));
340: return v_variance;
341: end if;
342: end if;
343: