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.OZF_MULTI_CURR_MIG_PVT dependencies on GL_CURRENCY_API

Line 264: SET plan_curr_amount = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,

260: ozf_utility_pvt.write_conc_log (' <===> Backup Completed <===>'||sql%rowcount||' rows inserted');
261: END IF;
262:
263: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b
264: SET plan_curr_amount = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
265: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount,-1),
266: plan_curr_amount_remaining = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
267: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount_remaining,-1),
268: exchange_rate = gl_currency_api.get_closest_rate(plan_currency_code,get_functional_curr(org_id),exchange_rate_date,exchange_rate_type,0),

Line 266: plan_curr_amount_remaining = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,

262:
263: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b
264: SET plan_curr_amount = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
265: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount,-1),
266: plan_curr_amount_remaining = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
267: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount_remaining,-1),
268: exchange_rate = gl_currency_api.get_closest_rate(plan_currency_code,get_functional_curr(org_id),exchange_rate_date,exchange_rate_type,0),
269: last_updated_by = -2,
270: last_update_date = sysdate

Line 268: exchange_rate = gl_currency_api.get_closest_rate(plan_currency_code,get_functional_curr(org_id),exchange_rate_date,exchange_rate_type,0),

264: SET plan_curr_amount = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
265: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount,-1),
266: plan_curr_amount_remaining = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,
267: exchange_rate_date,exchange_rate_type,NULL,fund_request_amount_remaining,-1),
268: exchange_rate = gl_currency_api.get_closest_rate(plan_currency_code,get_functional_curr(org_id),exchange_rate_date,exchange_rate_type,0),
269: last_updated_by = -2,
270: last_update_date = sysdate
271: WHERE plan_currency_code <> (SELECT fund_request_curr_code FROM ozf_offers WHERE qp_list_header_id=plan_id AND transaction_currency_code IS NULL)
272: AND NVL(plan_curr_amount,0) <> 0