APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_DEAL_RETRO_TESTS_S

Line 282: LOG_MSG('event', 'updated xtr_deal_retro_tests sucessfully!');

278: and result_date = p_date;
279:
280: if sql%found then
281:
282: LOG_MSG('event', 'updated xtr_deal_retro_tests sucessfully!');
283:
284: else
285:
286: LOG_MSG('event', 'could not update xtr_deal_retro_tests. The hedge already matured.');

Line 320: xtr_deal_retro_tests_s.nextval,

316: EXCLUDED_CUM_GAIN_LOSS_AMT,
317: RESULT_DATE
318: )
319: values (
320: xtr_deal_retro_tests_s.nextval,
321: l_retro_test_id,
322: p_batch_id,
323: p_hedge_no,
324: fnd_global.user_id,

Line 1458: values (xtr_deal_retro_tests_s.nextval, l_retro_test_id, p_batch_id, hdg_rec.hedge_no,

1454: EFF_PRD_GAIN_LOSS_AMT, INEFF_PRD_GAIN_LOSS_AMT, EXCLUDED_PRD_GAIN_LOSS_AMT,
1455: RECLASS_GAIN_LOSS_AMT, EFF_CUM_GAIN_LOSS_AMT, INEFF_CUM_GAIN_LOSS_AMT,
1456: EXCLUDED_CUM_GAIN_LOSS_AMT, RESULT_DATE)
1457:
1458: values (xtr_deal_retro_tests_s.nextval, l_retro_test_id, p_batch_id, hdg_rec.hedge_no,
1459: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
1460: fnd_global.conc_program_id, fnd_global.conc_login_id, fnd_global.prog_appl_id,
1461: fnd_global.conc_request_id, deal_rec.deal_no, l_amount_type,
1462: round(l_eff_prd * (deal_rec.alloc_ref_amt/l_deal_total), l_round),