1 PACKAGE xtr_market_data_interface_p AUTHID CURRENT_USER AS
2 /* $Header: xtrmdtrs.pls 120.2 2005/06/29 10:47:57 badiredd ship $ */
3 PROCEDURE archive_rates(p_called_from_trigger IN BOOLEAN,
4 p_ask_price IN NUMBER,
5 p_bid_price IN NUMBER,
6 p_currency_a IN VARCHAR2,
7 p_currency_b IN VARCHAR2,
8 p_nos_of_days IN NUMBER,
9 p_ric_code IN VARCHAR2,
10 p_term_length IN NUMBER,
11 p_term_type IN VARCHAR2,
12 p_term_year IN NUMBER,
13 p_last_download_time IN DATE,
14 p_day_count_basis IN VARCHAR2);
15
16 PROCEDURE transfer_mp(p_ref IN NUMBER,p_ask IN NUMBER, p_bid IN NUMBER,
17 p_rowid IN ROWID );
18
19 PROCEDURE calc_ask_bid(p_ref IN NUMBER, p_ask IN OUT NOCOPY NUMBER,
20 p_bid IN OUT NOCOPY NUMBER,p_mid IN NUMBER, p_spread IN NUMBER, p_code IN NUMBER);
21
22 FUNCTION q_quote_compare(p_source IN VARCHAR2,
23 p_external_ref_code IN VARCHAR2,p_ask IN OUT NOCOPY NUMBER, p_bid IN OUT NOCOPY NUMBER,
24 p_mid IN NUMBER, p_spread IN NUMBER, p_code IN NUMBER) RETURN BOOLEAN;
25
26 FUNCTION q_code_check(p_source IN VARCHAR2,
27 p_external_ref_code IN VARCHAR2) RETURN BOOLEAN;
28
29 FUNCTION q_date_check(p_date IN DATE, p_source IN VARCHAR2,
30 p_external_ref_code IN VARCHAR2) RETURN BOOLEAN;
31
32 PROCEDURE put_header;
33
34 PROCEDURE market_data_transfer_cp(
35 errbuf OUT NOCOPY VARCHAR2,
36 retcode OUT NOCOPY VARCHAR2,
37 p_upd_date_missing IN VARCHAR2,
38 p_upd_history IN VARCHAR2);
39
40 PROCEDURE upload_rates_to_gl_cp(errbuf OUT NOCOPY VARCHAR2,
41 retcode OUT NOCOPY VARCHAR2,
42 p_rel_abs IN VARCHAR2,
43 p_abs_start_date IN VARCHAR2,
44 p_abs_end_date IN VARCHAR2,
45 p_rel_end_date IN NUMBER,
46 p_rel_start_date IN NUMBER,
47 p_rate_calc IN VARCHAR2,
48 p_bid_mid_ask IN VARCHAR2,
49 p_conv_type IN VARCHAR2,
50 p_overwrite IN VARCHAR2);
51
52 --------------------------------------------------------------------------------------------------------------------
53 PROCEDURE market_data_transfer (p_upd_date_missing IN VARCHAR2,
54 p_upd_history IN VARCHAR2);
55 --------------------------------------------------------------------------------------------------------------------
56 END xtr_market_data_interface_p;