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.XTR_HEDGE_PROCESS_P dependencies on XTR_GAIN_LOSS_DNM

Line 431: select sum(DECODE(ACTION, 'LOSS',-AMOUNT, AMOUNT)) from xtr_gain_loss_dnm

427: and result_date = p_date;
428: */
429:
430: cursor dnm (p_deal_no in number, p_flag in VARCHAR2, p_amount_type in VARCHAR2, p_date_type in VARCHAR2) is
431: select sum(DECODE(ACTION, 'LOSS',-AMOUNT, AMOUNT)) from xtr_gain_loss_dnm
432: where journal_date <= l_temp_date
433: and deal_number = p_deal_no
434: and reval_eff_flag = p_flag
435: and amount_type = p_amount_type

Line 473: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;

469: l_gl_ccy VARCHAR2(15);
470:
471: BEGIN
472:
473: select XTR_GAIN_LOSS_DNM_S.nextval into l_dnm_id from dual;
474:
475: if p_amount > 0 then
476: l_action := 'PROFIT';
477: elsif p_amount < 0 then

Line 483: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(

479: end if;
480:
481: l_gl_ccy := get_gl_ccy(p_amount_type, p_deal_no, p_company);
482:
483: XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW(
484: l_row_id,
485: l_dnm_id ,
486: p_batch_id,
487: p_company,