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_TRX_VIEW_PKG dependencies on ARPT_SQL_FUNC_UTIL

Line 244: p_trx_tab(i).paid_flag := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', 'Y');

240: open c_pay(p_trx_tab(i).payment_schedule_id);
241: fetch c_pay into l_dummy;
242: if c_pay%found then
243: -- p_trx_tab(i).paid_flag := 'jtfgtrue.gif';
244: p_trx_tab(i).paid_flag := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', 'Y');
245: else
246: -- p_trx_tab(i).paid_flag := 'jtfgnull.gif';
247: p_trx_tab(i).paid_flag := '';
248: END if;

Line 255: p_trx_tab(i).promised_flag := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', 'Y');

251: open c_pro(p_trx_tab(i).delinquency_id);
252: fetch c_pro into l_dummy;
253: if c_pro%found then
254: -- p_trx_tab(i).promised_flag := 'jtfgtrue.gif';
255: p_trx_tab(i).promised_flag := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('YES/NO', 'Y');
256: else
257: -- p_trx_tab(i).promised_flag := 'jtfgnull.gif';
258: p_trx_tab(i).promised_flag := '';
259: END if;