[Home] [Help]
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;
344:
345:
691: ((v_mdi_rec.ASK IS NULL) AND (v_mdi_rec.BID IS NULL) AND
692: (v_mdi_rec.MID IS NULL)) THEN
693: --XTRMDT special logic fails
694: UPDATE XTR_MARKET_DATA_INTERFACE
695: SET RETURN_CODE = 90,LAST_UPDATED_BY = FND_GLOBAL.user_id,
696: LAST_UPDATED_DATE= SYSDATE WHERE rowid =v_mdi_rec.rowid;
697:
698: --Print error to concurrent log
699: v_e_count := v_e_count + 1;
709: ||v_mdi_rec.datetime||', '||v_trans_stat||' [90]');
710:
711: ELSIF q_code_check(v_mdi_rec.source,v_mdi_rec.external_ref_code) THEN
712: UPDATE XTR_MARKET_DATA_INTERFACE
713: SET RETURN_CODE = 50 ,LAST_UPDATED_BY = FND_GLOBAL.user_id,
714: LAST_UPDATED_DATE= SYSDATE WHERE ROWID = v_mdi_rec.rowid;
715: --Print error to concurrent log
716: v_e_count := v_e_count + 1;
717: IF v_e_count = 1 THEN
727: ELSIF v_mdi_rec.DATETIME IS NULL THEN
728: IF (p_upd_date_missing = 'N') THEN
729: -- UPD_DATE_MISSING = Never
730: UPDATE XTR_MARKET_DATA_INTERFACE
731: SET RETURN_CODE = 60,LAST_UPDATED_BY = FND_GLOBAL.user_id,
732: LAST_UPDATED_DATE= SYSDATE WHERE ROWID = v_mdi_rec.rowid;
733: --Print error to concurrent log
734: v_e_count := v_e_count + 1;
735: IF v_e_count = 1 THEN
756: --transfer to mp
757: transfer_mp(v_ref, v_ask, v_bid, v_mdi_rec.rowid);
758: UPDATE XTR_MARKET_DATA_INTERFACE
759: SET REF_CODE = v_ric, RETURN_CODE = 20,
760: LAST_UPDATED_BY = FND_GLOBAL.user_id, LAST_UPDATED_DATE= SYSDATE
761: WHERE ROWID = v_mdi_rec.rowid;
762: ELSE
763: UPDATE XTR_MARKET_DATA_INTERFACE
764: SET RETURN_CODE = 70,LAST_UPDATED_BY = FND_GLOBAL.user_id,
760: LAST_UPDATED_BY = FND_GLOBAL.user_id, LAST_UPDATED_DATE= SYSDATE
761: WHERE ROWID = v_mdi_rec.rowid;
762: ELSE
763: UPDATE XTR_MARKET_DATA_INTERFACE
764: SET RETURN_CODE = 70,LAST_UPDATED_BY = FND_GLOBAL.user_id,
765: LAST_UPDATED_DATE= SYSDATE WHERE ROWID = v_mdi_rec.rowid;
766: --Print error to concurrent log
767: v_e_count := v_e_count + 1;
768: IF v_e_count = 1 THEN
779: v_mdi_rec.external_ref_code)) THEN
780: --IF (UPD_HISTORY = N)
781: IF (p_upd_history = 'N') THEN
782: UPDATE XTR_MARKET_DATA_INTERFACE
783: SET RETURN_CODE = 80 ,LAST_UPDATED_BY = FND_GLOBAL.user_id,
784: LAST_UPDATED_DATE= SYSDATE WHERE ROWID = v_mdi_rec.rowid;
785: --Print error to concurrent log
786: v_e_count := v_e_count + 1;
787: IF v_e_count = 1 THEN
826: v_nos_of_days,v_ric,v_term_length,v_term_type,v_term_year,
827: v_mdi_rec.datetime,v_day_count_basis);
828: UPDATE XTR_MARKET_DATA_INTERFACE
829: SET REF_CODE = v_ric, RETURN_CODE= 40 ,
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
840: --transfer to mp
841: transfer_mp( v_ref,v_ask, v_bid,v_mdi_rec.rowid);
842: UPDATE XTR_MARKET_DATA_INTERFACE
843: SET REF_CODE = v_ric, RETURN_CODE = 10,
844: LAST_UPDATED_BY = FND_GLOBAL.user_id, LAST_UPDATED_DATE= SYSDATE
845: WHERE ROWID = v_mdi_rec.rowid;
846: END IF;
847:
848: IF v_counter = 50 THEN
944: FROM gl_daily_rates_interface
945: WHERE MODE_FLAG in ('X','F')
946: AND FROM_CONVERSION_DATE=p_start_date
947: AND TO_CONVERSION_DATE=p_end_date
948: AND USER_ID=fnd_global.user_id
949: ORDER BY MODE_FLAG,TO_CURRENCY;
950:
951:
952: Procedure Put_Log(Avr_Buff In Varchar2) is
1020: p_conv_type,
1021: p_rate,
1022: p_mode_flag,
1023: null,
1024: fnd_global.user_id);
1025:
1026: END IF;
1027: END populate_rate;
1028:
1088: end loop;
1089:
1090: delete from gl_daily_rates_interface
1091: where MODE_FLAG in ('X','F')
1092: and USER_ID=fnd_global.user_id
1093: and FROM_CONVERSION_DATE=TO_CONVERSION_DATE
1094: and FROM_CONVERSION_DATE>=v_start_date
1095: and FROM_CONVERSION_DATE<=v_end_date;
1096: