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_MARKET_DATA_INTERFACE_P dependencies on XTR_MARKET_PRICES

Line 337: UPDATE XTR_MARKET_PRICES

333: rowid=p_rowid;
334: IF v_now > sysdate THEN
335: v_now := sysdate;
336: END IF;
337: UPDATE XTR_MARKET_PRICES
338: SET ASK_PRICE= p_ask, BID_PRICE= p_bid,LAST_DOWNLOAD_TIME=v_now
339: WHERE XTR_MARKET_PRICES.REF_NUMBER = p_ref;
340: UPDATE XTR_MARKET_DATA_INTERFACE
341: SET LAST_UPDATED_BY = FND_GLOBAL.user_id, LAST_UPDATED_DATE= sysdate

Line 339: WHERE XTR_MARKET_PRICES.REF_NUMBER = p_ref;

335: v_now := sysdate;
336: END IF;
337: UPDATE XTR_MARKET_PRICES
338: SET ASK_PRICE= p_ask, BID_PRICE= p_bid,LAST_DOWNLOAD_TIME=v_now
339: WHERE XTR_MARKET_PRICES.REF_NUMBER = p_ref;
340: UPDATE XTR_MARKET_DATA_INTERFACE
341: SET LAST_UPDATED_BY = FND_GLOBAL.user_id, LAST_UPDATED_DATE= sysdate
342: WHERE XTR_MARKET_DATA_INTERFACE.ROWID = p_rowid;
343: END transfer_mp;

Line 385: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;

381: ELSIF (p_code = 10) THEN -- bid and spread missing
382: p_bid:= 2*p_mid-p_ask;
383: ELSIF (p_code = 11) THEN -- ask, bid, and spread missing
384: SELECT NVL(ASK_PRICE-BID_PRICE,0) INTO v_pspread
385: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;
386: p_ask:= (2*p_mid+v_pspread)/2;
387: p_bid:= (2*p_mid-v_pspread)/2;
388: ELSIF (p_code = 13) THEN-- ask, mid, and spread missing
389: SELECT NVL(ASK_PRICE-BID_PRICE,0) INTO v_pspread

Line 390: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;

386: p_ask:= (2*p_mid+v_pspread)/2;
387: p_bid:= (2*p_mid-v_pspread)/2;
388: ELSIF (p_code = 13) THEN-- ask, mid, and spread missing
389: SELECT NVL(ASK_PRICE-BID_PRICE,0) INTO v_pspread
390: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;
391: p_ask:= p_bid+v_pspread;
392: ELSIF (p_code = 14) THEN-- bid, mid, and spread missing
393: SELECT NVL(ASK_PRICE-BID_PRICE,0) INTO v_pspread
394: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;

Line 394: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;

390: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;
391: p_ask:= p_bid+v_pspread;
392: ELSIF (p_code = 14) THEN-- bid, mid, and spread missing
393: SELECT NVL(ASK_PRICE-BID_PRICE,0) INTO v_pspread
394: FROM XTR_MARKET_PRICES WHERE REF_NUMBER= p_ref;
395: p_bid:=p_ask-v_pspread;
396: END IF;
397: END IF;
398: END calc_ask_bid;

Line 424: SELECT ASK_PRICE INTO v_fask FROM XTR_MARKET_PRICES

420: --
421: BEGIN
422: SELECT REF_NUMBER INTO v_fref FROM XTR_DATA_FEED_CODES
423: WHERE SOURCE = p_source AND EXTERNAL_REF_CODE = p_external_ref_code;
424: SELECT ASK_PRICE INTO v_fask FROM XTR_MARKET_PRICES
425: WHERE REF_NUMBER = v_fref;
426: SELECT BID_PRICE INTO v_fbid FROM XTR_MARKET_PRICES
427: WHERE REF_NUMBER = v_fref;
428: calc_ask_bid(v_fref,p_ask,p_bid,p_mid,p_spread,p_code);

Line 426: SELECT BID_PRICE INTO v_fbid FROM XTR_MARKET_PRICES

422: SELECT REF_NUMBER INTO v_fref FROM XTR_DATA_FEED_CODES
423: WHERE SOURCE = p_source AND EXTERNAL_REF_CODE = p_external_ref_code;
424: SELECT ASK_PRICE INTO v_fask FROM XTR_MARKET_PRICES
425: WHERE REF_NUMBER = v_fref;
426: SELECT BID_PRICE INTO v_fbid FROM XTR_MARKET_PRICES
427: WHERE REF_NUMBER = v_fref;
428: calc_ask_bid(v_fref,p_ask,p_bid,p_mid,p_spread,p_code);
429: IF (v_fask<> p_ask) OR (v_fbid<> p_bid) OR (v_fask IS NULL) OR
430: (v_fbid IS NULL)

Line 453: SELECT RIC_CODE FROM XTR_MARKET_PRICES

449: CURSOR c1_cursor IS
450: SELECT REF_NUMBER FROM XTR_DATA_FEED_CODES
451: WHERE SOURCE = p_source AND EXTERNAL_REF_CODE = p_external_ref_code;
452: CURSOR c2_cursor IS
453: SELECT RIC_CODE FROM XTR_MARKET_PRICES
454: WHERE REF_NUMBER = ( SELECT REF_NUMBER FROM XTR_DATA_FEED_CODES
455: WHERE SOURCE = p_source AND EXTERNAL_REF_CODE = p_external_ref_code);
456: v_fref NUMBER;
457: v_fric VARCHAR2(20);

Line 498: SELECT LAST_DOWNLOAD_TIME INTO v_date FROM XTR_MARKET_PRICES

494: --
495: BEGIN
496: SELECT REF_NUMBER INTO v_fref FROM XTR_DATA_FEED_CODES
497: WHERE SOURCE = p_source AND EXTERNAL_REF_CODE = p_external_ref_code;
498: SELECT LAST_DOWNLOAD_TIME INTO v_date FROM XTR_MARKET_PRICES
499: WHERE REF_NUMBER= v_fref;
500: IF (p_date< v_date) THEN
501: RETURN TRUE;
502: ELSE

Line 613: type currency_list_type is table of xtr_market_prices.currency_a%type index by binary_integer;

609: v_trans_stat VARCHAR2(240);
610: v_e_count NUMBER; --number of rows with errors
611:
612: --bug 2588763
613: type currency_list_type is table of xtr_market_prices.currency_a%type index by binary_integer;
614: v_currency_a_list currency_list_type;
615: v_currency_b_list currency_list_type;
616:
617: --

Line 625: LOCK TABLE XTR_MARKET_DATA_INTERFACE,XTR_MARKET_PRICES IN EXCLUSIVE MODE

621: (p_upd_history = 'N'))) THEN
622: RAISE e_inv;
623: END IF;
624: -- check parameter integrity
625: LOCK TABLE XTR_MARKET_DATA_INTERFACE,XTR_MARKET_PRICES IN EXCLUSIVE MODE
626: NOWAIT;
627:
628: -- bug 2588763 - get list of all currencies that will be updated
629: select distinct mp.currency_a

Line 631: from xtr_market_prices mp,

627:
628: -- bug 2588763 - get list of all currencies that will be updated
629: select distinct mp.currency_a
630: bulk collect into v_currency_a_list
631: from xtr_market_prices mp,
632: xtr_data_feed_codes dfc,
633: xtr_market_data_interface mdi
634: where mp.ric_code=dfc.ric_code
635: and dfc.source = mdi.source

Line 645: from xtr_market_prices mp,

641: and mdi.return_code is null;
642:
643: select distinct mp.currency_b
644: bulk collect into v_currency_b_list
645: from xtr_market_prices mp,
646: xtr_data_feed_codes dfc,
647: xtr_market_data_interface mdi
648: where mp.ric_code=dfc.ric_code
649: and dfc.source = mdi.source

Line 656: from xtr_market_prices i_mp,

652: and mp.currency_b <> 'USD'
653: and nvl(mp.currency_a,'USD')='USD'
654: and not exists
655: (select i_mp.currency_b
656: from xtr_market_prices i_mp,
657: xtr_data_feed_codes i_dfc,
658: xtr_market_data_interface i_mdi
659: where i_mp.ric_code = i_dfc.ric_code
660: and i_dfc.source = i_mdi.source

Line 752: SELECT RIC_CODE INTO v_ric FROM XTR_MARKET_PRICES

748: --UPD_DATE_MISSING = Always OR File Quote <> System Quote
749: SELECT REF_NUMBER INTO v_ref FROM XTR_DATA_FEED_CODES
750: WHERE SOURCE = v_mdi_rec.source
751: AND EXTERNAL_REF_CODE = v_mdi_rec.external_ref_code;
752: SELECT RIC_CODE INTO v_ric FROM XTR_MARKET_PRICES
753: WHERE REF_NUMBER = v_ref;
754: calc_ask_bid(v_ref,v_ask,v_bid,v_mdi_rec.mid,v_mdi_rec.spread,v_code);
755:
756: --transfer to mp

Line 800: SELECT RIC_CODE INTO v_ric FROM XTR_MARKET_PRICES

796: ELSE
797: SELECT REF_NUMBER INTO v_ref FROM XTR_DATA_FEED_CODES
798: WHERE SOURCE = v_mdi_rec.source
799: AND EXTERNAL_REF_CODE = v_mdi_rec.external_ref_code;
800: SELECT RIC_CODE INTO v_ric FROM XTR_MARKET_PRICES
801: WHERE REF_NUMBER = v_ref;
802: calc_ask_bid(v_ref,v_ask,v_bid,v_mdi_rec.mid,v_mdi_rec.spread,v_code);
803: /*
804: SELECT CURRENCY_A INTO v_currency_a FROM XTR_MARKET_PRICES

Line 804: SELECT CURRENCY_A INTO v_currency_a FROM XTR_MARKET_PRICES

800: SELECT RIC_CODE INTO v_ric FROM XTR_MARKET_PRICES
801: WHERE REF_NUMBER = v_ref;
802: calc_ask_bid(v_ref,v_ask,v_bid,v_mdi_rec.mid,v_mdi_rec.spread,v_code);
803: /*
804: SELECT CURRENCY_A INTO v_currency_a FROM XTR_MARKET_PRICES
805: WHERE REF_NUMBER = v_ref;
806: SELECT CURRENCY_B INTO v_currency_b FROM XTR_MARKET_PRICES
807: WHERE REF_NUMBER = v_ref;
808: SELECT NOS_OF_DAYS INTO v_nos_of_days FROM XTR_MARKET_PRICES

Line 806: SELECT CURRENCY_B INTO v_currency_b FROM XTR_MARKET_PRICES

802: calc_ask_bid(v_ref,v_ask,v_bid,v_mdi_rec.mid,v_mdi_rec.spread,v_code);
803: /*
804: SELECT CURRENCY_A INTO v_currency_a FROM XTR_MARKET_PRICES
805: WHERE REF_NUMBER = v_ref;
806: SELECT CURRENCY_B INTO v_currency_b FROM XTR_MARKET_PRICES
807: WHERE REF_NUMBER = v_ref;
808: SELECT NOS_OF_DAYS INTO v_nos_of_days FROM XTR_MARKET_PRICES
809: WHERE REF_NUMBER = v_ref;
810: SELECT TERM_LENGTH INTO v_term_length FROM XTR_MARKET_PRICES

Line 808: SELECT NOS_OF_DAYS INTO v_nos_of_days FROM XTR_MARKET_PRICES

804: SELECT CURRENCY_A INTO v_currency_a FROM XTR_MARKET_PRICES
805: WHERE REF_NUMBER = v_ref;
806: SELECT CURRENCY_B INTO v_currency_b FROM XTR_MARKET_PRICES
807: WHERE REF_NUMBER = v_ref;
808: SELECT NOS_OF_DAYS INTO v_nos_of_days FROM XTR_MARKET_PRICES
809: WHERE REF_NUMBER = v_ref;
810: SELECT TERM_LENGTH INTO v_term_length FROM XTR_MARKET_PRICES
811: WHERE REF_NUMBER = v_ref;
812: SELECT TERM_TYPE INTO v_term_type FROM XTR_MARKET_PRICES

Line 810: SELECT TERM_LENGTH INTO v_term_length FROM XTR_MARKET_PRICES

806: SELECT CURRENCY_B INTO v_currency_b FROM XTR_MARKET_PRICES
807: WHERE REF_NUMBER = v_ref;
808: SELECT NOS_OF_DAYS INTO v_nos_of_days FROM XTR_MARKET_PRICES
809: WHERE REF_NUMBER = v_ref;
810: SELECT TERM_LENGTH INTO v_term_length FROM XTR_MARKET_PRICES
811: WHERE REF_NUMBER = v_ref;
812: SELECT TERM_TYPE INTO v_term_type FROM XTR_MARKET_PRICES
813: WHERE REF_NUMBER = v_ref;
814: SELECT TERM_YEAR INTO v_term_year FROM XTR_MARKET_PRICES

Line 812: SELECT TERM_TYPE INTO v_term_type FROM XTR_MARKET_PRICES

808: SELECT NOS_OF_DAYS INTO v_nos_of_days FROM XTR_MARKET_PRICES
809: WHERE REF_NUMBER = v_ref;
810: SELECT TERM_LENGTH INTO v_term_length FROM XTR_MARKET_PRICES
811: WHERE REF_NUMBER = v_ref;
812: SELECT TERM_TYPE INTO v_term_type FROM XTR_MARKET_PRICES
813: WHERE REF_NUMBER = v_ref;
814: SELECT TERM_YEAR INTO v_term_year FROM XTR_MARKET_PRICES
815: WHERE REF_NUMBER = v_ref;
816: */

Line 814: SELECT TERM_YEAR INTO v_term_year FROM XTR_MARKET_PRICES

810: SELECT TERM_LENGTH INTO v_term_length FROM XTR_MARKET_PRICES
811: WHERE REF_NUMBER = v_ref;
812: SELECT TERM_TYPE INTO v_term_type FROM XTR_MARKET_PRICES
813: WHERE REF_NUMBER = v_ref;
814: SELECT TERM_YEAR INTO v_term_year FROM XTR_MARKET_PRICES
815: WHERE REF_NUMBER = v_ref;
816: */
817: SELECT currency_a, currency_b, nos_of_days, term_length, term_type,
818: term_type, term_year, day_count_basis

Line 821: FROM xtr_market_prices

817: SELECT currency_a, currency_b, nos_of_days, term_length, term_type,
818: term_type, term_year, day_count_basis
819: INTO v_currency_a, v_currency_b, v_nos_of_days, v_term_length,
820: v_term_type, v_term_type, v_term_year, v_day_count_basis
821: FROM xtr_market_prices
822: WHERE ref_number = v_ref;
823:
824: --transfer to history table
825: archive_rates(FALSE,v_ask,v_bid,v_currency_a,v_currency_b,

Line 837: SELECT RIC_CODE INTO v_ric FROM XTR_MARKET_PRICES

833: ELSE
834: SELECT REF_NUMBER INTO v_ref FROM XTR_DATA_FEED_CODES
835: WHERE SOURCE = v_mdi_rec.source
836: AND EXTERNAL_REF_CODE = v_mdi_rec.external_ref_code;
837: SELECT RIC_CODE INTO v_ric FROM XTR_MARKET_PRICES
838: WHERE REF_NUMBER = v_ref;
839: calc_ask_bid(v_ref,v_ask,v_bid,v_mdi_rec.mid,v_mdi_rec.spread,v_code);
840: --transfer to mp
841: transfer_mp( v_ref,v_ask, v_bid,v_mdi_rec.rowid);

Line 852: LOCK TABLE XTR_MARKET_DATA_INTERFACE,XTR_MARKET_PRICES

848: IF v_counter = 50 THEN
849: COMMIT;
850: v_counter:= 0;
851: -- lock the tables again because it was released by commit statement
852: LOCK TABLE XTR_MARKET_DATA_INTERFACE,XTR_MARKET_PRICES
853: IN EXCLUSIVE MODE NOWAIT;
854: END IF;
855: END LOOP;
856: