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_DATA_FEED_CODES

Line 321: p_ref- the reference number from xtr_data_feed_codes based on the source and external ref code of mdi

317:
318: /* transfer_mp
319: This procedure does the actual transfer from mdi to mp
320: parameters
321: p_ref- the reference number from xtr_data_feed_codes based on the source and external ref code of mdi
322: p_ask,p_bid- file quote of ask and bid, computed from what's in mdi
323: p_rowid- the rowid of the mdi record we are dealing with currently
324: */
325:

Line 350: p_ref- the reference number from xtr_data_feed_codes based on the source and external ref code of mdi

346:
347: /* calc_ask_bid
348: This procedure calculates the correct ask and bid values based on ask, bid, mid, and spread that are alredy stored in mdi
349: parameters
350: p_ref- the reference number from xtr_data_feed_codes based on the source and external ref code of mdi
351: p_ask,p_bid,p_mid,p_spread- file quote of ask, bid,mid, and spread that's in mdi
352: p_code- code scheme that lets you know which values are missing based on its code
353: */
354: PROCEDURE calc_ask_bid(p_ref IN NUMBER, p_ask IN OUT NOCOPY NUMBER,

Line 422: SELECT REF_NUMBER INTO v_fref FROM XTR_DATA_FEED_CODES

418: v_fbid NUMBER;-- temporary storage for ask and bid
419: v_fref NUMBER;
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

Line 450: SELECT REF_NUMBER FROM XTR_DATA_FEED_CODES

446: FUNCTION q_code_check(p_source IN VARCHAR2,
447: p_external_ref_code IN VARCHAR2) RETURN BOOLEAN IS
448: --
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

Line 454: WHERE REF_NUMBER = ( SELECT REF_NUMBER FROM XTR_DATA_FEED_CODES

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);
458: --

Line 496: SELECT REF_NUMBER INTO v_fref FROM XTR_DATA_FEED_CODES

492: v_fref NUMBER;
493: v_date DATE;
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

Line 632: xtr_data_feed_codes dfc,

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
636: and dfc.external_ref_code = mdi.external_ref_code

Line 646: xtr_data_feed_codes dfc,

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
650: and dfc.external_ref_code = mdi.external_ref_code

Line 657: xtr_data_feed_codes i_dfc,

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
661: and i_dfc.external_ref_code = i_mdi.external_ref_code

Line 749: SELECT REF_NUMBER INTO v_ref FROM XTR_DATA_FEED_CODES

745: ELSIF (p_upd_date_missing = 'A') OR (q_quote_compare(v_mdi_rec.source,
746: v_mdi_rec.external_ref_code,v_ask,v_bid,v_mdi_rec.mid,v_mdi_rec.spread,
747: v_code)) THEN
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;

Line 797: SELECT REF_NUMBER INTO v_ref FROM XTR_DATA_FEED_CODES

793: v_mdi_rec.external_ref_code||', '||v_mdi_rec.bid||', '||v_mdi_rec.ask
794: ||', '||v_mdi_rec.mid||', '||v_mdi_rec.spread||', '
795: ||v_mdi_rec.datetime||', '||v_trans_stat||' [80]');
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;

Line 834: SELECT REF_NUMBER INTO v_ref FROM XTR_DATA_FEED_CODES

830: LAST_UPDATED_BY = FND_GLOBAL.user_id, LAST_UPDATED_DATE= SYSDATE
831: WHERE ROWID = v_mdi_rec.rowid;
832: END IF;
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;