APPS.XTR_HEDGE_PROCESS_P dependencies on DUAL

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 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 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

Line 1563: select XTR_BATCH_EVENTS_S.NEXTVAL into l_event_id from DUAL;

1559: Raise e_batch_been_run;
1560: Else
1561: Close CHK_BATCH_RUN;
1562:
1563: select XTR_BATCH_EVENTS_S.NEXTVAL into l_event_id from DUAL;
1564:
1565: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,
1566: authorized_by, authorized_on, created_by, creation_date,
1567: last_updated_by, last_update_date, last_update_login)

Line 1846: INTO SOURCE_NAME(cnt) from dual;

1842: if ap_source%NOTFOUND then
1843: select decode(l_ap_source,'Manual Invoice Entry',
1844: fnd_message.get_string('XTR','XTR_AP_SOURCE_MANUAL'),
1845: fnd_message.get_string('XTR','XTR_AP_SOURCE_OTHER'))
1846: INTO SOURCE_NAME(cnt) from dual;
1847: end if;
1848: close ap_source;
1849:
1850: open vendor(l_vendor_id);

Line 2045: select xtr_hedge_relationships_s.nextval into HEDGE_RELATIONSHIP_ID(k) from dual;

2041: close pct;
2042:
2043: PCT_ALLOCATION(k) := 100-nvl(l_pct,0);
2044: REFERENCE_AMOUNT(k) := AMOUNT(k) * (PCT_ALLOCATION(k)/100);
2045: select xtr_hedge_relationships_s.nextval into HEDGE_RELATIONSHIP_ID(k) from dual;
2046:
2047: HEDGE_ATTRIBUTE_ID(k) := p_hedge_no;
2048: SOURCE_TYPE_ID(k) := l_source_id;
2049: INSTRUMENT_ITEM_FLAG(k) := l_iu_flag;

Line 2143: from DUAL

2139: and xp.party_code = nvl(p_company,xp.party_code) -- BUG 3002000 #7
2140: and tt.name = p_trxtype
2141: union all
2142: select '(CUST_TRX_TYPE_ID = -99999) OR ' trxtype
2143: from DUAL
2144: where substr(fnd_message.get_string('XTR','XTR_AR_TRX_TYPE_CASH'),1,20) = p_trxtype;
2145:
2146: /* BUG 3497802 Repalcing RA_CUSTOMERS with HZ_PARTIES
2147: