APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_HEDGE_RETRO_TESTS_S

Line 231: LOG_MSG('event', 'updated xtr_hedge_retro_tests sucessfully!');

227: where hedge_attribute_id = p_hedge_no
228: and result_date = p_date;
229:
230: if sql%found then
231: LOG_MSG('event', 'updated xtr_hedge_retro_tests sucessfully!');
232: else
233: LOG_MSG('event', 'could not update xtr_hedge_retro_tests. The hedge already matured.');
234:
235: open get_cumu(p_hedge_no, p_batch_id);

Line 242: select xtr_hedge_retro_tests_s.nextval into l_retro_test_id from dual;

238: close get_cumu;
239:
240: LOG_MSG('l_amount_type = '||l_amount_type);
241:
242: select xtr_hedge_retro_tests_s.nextval into l_retro_test_id from dual;
243:
244: insert into xtr_hedge_retro_tests
245: (HEDGE_RETRO_TEST_ID, COMPANY_CODE, HEDGE_ATTRIBUTE_ID, RESULT_CODE,
246: BATCH_ID, RESULT_DATE,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 1352: select xtr_hedge_retro_tests_s.nextval into l_retro_test_id from dual;

1348:
1349: /* This implies, not called from the form, but done
1350: as part of retro calcualtion for the first time */
1351:
1352: select xtr_hedge_retro_tests_s.nextval into l_retro_test_id from dual;
1353:
1354: insert into xtr_hedge_retro_tests
1355: (HEDGE_RETRO_TEST_ID, COMPANY_CODE, HEDGE_ATTRIBUTE_ID, RESULT_CODE,
1356: BATCH_ID, RESULT_DATE,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 1393: select xtr_hedge_retro_tests_s.nextval into l_retro_test_id from dual;

1389: LOG_MSG('l_ineff_prd' , l_ineff_prd);
1390:
1391: l_ineff_cum:= nvl(l_ineff_prv_cum,0) + nvl(l_ineff_prd,0);
1392:
1393: select xtr_hedge_retro_tests_s.nextval into l_retro_test_id from dual;
1394:
1395: LOG_MSG('event', 'inserting NON-MANUAL test - part of retro calculations');
1396:
1397: insert into xtr_hedge_retro_tests