43: p_convexity OUT NOCOPY NUMBER,
44: p_ccy IN OUT NOCOPY VARCHAR2);
45:
46: PROCEDURE fx_calculator(p_date_args IN SYSTEM.QRM_DATE_TABLE,
47: p_varchar_args IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
48: p_num_args IN OUT NOCOPY xtr_md_num_table);
49:
50:
51: FUNCTION get_curves_from_base (p_curve_types SYSTEM.QRM_VARCHAR_TABLE,
47: p_varchar_args IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
48: p_num_args IN OUT NOCOPY xtr_md_num_table);
49:
50:
51: FUNCTION get_curves_from_base (p_curve_types SYSTEM.QRM_VARCHAR_TABLE,
52: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
53: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE)
54: RETURN SYSTEM.QRM_VARCHAR_TABLE;
55:
48: p_num_args IN OUT NOCOPY xtr_md_num_table);
49:
50:
51: FUNCTION get_curves_from_base (p_curve_types SYSTEM.QRM_VARCHAR_TABLE,
52: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
53: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE)
54: RETURN SYSTEM.QRM_VARCHAR_TABLE;
55:
56:
49:
50:
51: FUNCTION get_curves_from_base (p_curve_types SYSTEM.QRM_VARCHAR_TABLE,
52: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
53: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE)
54: RETURN SYSTEM.QRM_VARCHAR_TABLE;
55:
56:
57: FUNCTION get_rates_from_curves (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
50:
51: FUNCTION get_curves_from_base (p_curve_types SYSTEM.QRM_VARCHAR_TABLE,
52: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
53: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE)
54: RETURN SYSTEM.QRM_VARCHAR_TABLE;
55:
56:
57: FUNCTION get_rates_from_curves (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
58: p_curve_codes SYSTEM.QRM_VARCHAR_TABLE,
53: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE)
54: RETURN SYSTEM.QRM_VARCHAR_TABLE;
55:
56:
57: FUNCTION get_rates_from_curves (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
58: p_curve_codes SYSTEM.QRM_VARCHAR_TABLE,
59: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
54: RETURN SYSTEM.QRM_VARCHAR_TABLE;
55:
56:
57: FUNCTION get_rates_from_curves (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
58: p_curve_codes SYSTEM.QRM_VARCHAR_TABLE,
59: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
62: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
55:
56:
57: FUNCTION get_rates_from_curves (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
58: p_curve_codes SYSTEM.QRM_VARCHAR_TABLE,
59: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
62: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
63: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
56:
57: FUNCTION get_rates_from_curves (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
58: p_curve_codes SYSTEM.QRM_VARCHAR_TABLE,
59: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
62: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
63: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
64: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
57: FUNCTION get_rates_from_curves (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
58: p_curve_codes SYSTEM.QRM_VARCHAR_TABLE,
59: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
62: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
63: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
64: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
65: p_interest_quote_basis VARCHAR2,
58: p_curve_codes SYSTEM.QRM_VARCHAR_TABLE,
59: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
62: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
63: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
64: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
65: p_interest_quote_basis VARCHAR2,
66: p_currency_quote_basis VARCHAR2,
59: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
62: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
63: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
64: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
65: p_interest_quote_basis VARCHAR2,
66: p_currency_quote_basis VARCHAR2,
67: p_spot_date DATE,
60: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
61: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
62: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
63: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
64: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
65: p_interest_quote_basis VARCHAR2,
66: p_currency_quote_basis VARCHAR2,
67: p_spot_date DATE,
68: p_future_date DATE)
68: p_future_date DATE)
69: RETURN xtr_md_num_table;
70:
71:
72: FUNCTION get_rates_from_base (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
73: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
74: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
75: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
76: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
69: RETURN xtr_md_num_table;
70:
71:
72: FUNCTION get_rates_from_base (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
73: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
74: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
75: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
76: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
77: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
70:
71:
72: FUNCTION get_rates_from_base (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
73: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
74: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
75: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
76: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
77: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
78: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
71:
72: FUNCTION get_rates_from_base (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
73: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
74: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
75: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
76: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
77: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
78: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
79: p_interest_quote_basis VARCHAR2,
72: FUNCTION get_rates_from_base (p_rate_types SYSTEM.QRM_VARCHAR_TABLE,
73: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
74: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
75: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
76: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
77: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
78: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
79: p_interest_quote_basis VARCHAR2,
80: p_currency_quote_basis VARCHAR2,
73: p_base_currencies SYSTEM.QRM_VARCHAR_TABLE,
74: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
75: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
76: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
77: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
78: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
79: p_interest_quote_basis VARCHAR2,
80: p_currency_quote_basis VARCHAR2,
81: p_spot_date DATE,
74: p_contra_currencies SYSTEM.QRM_VARCHAR_TABLE,
75: p_quote_bases SYSTEM.QRM_VARCHAR_TABLE,
76: p_interp_methods SYSTEM.QRM_VARCHAR_TABLE,
77: p_data_sides SYSTEM.QRM_VARCHAR_TABLE,
78: p_day_count_bases SYSTEM.QRM_VARCHAR_TABLE,
79: p_interest_quote_basis VARCHAR2,
80: p_currency_quote_basis VARCHAR2,
81: p_spot_date DATE,
82: p_future_date DATE)
85:
86: FUNCTION get_spot_quotation_basis(p_base_currency IN VARCHAR2,
87: p_contra_currency IN VARCHAR2,
88: p_overwrite_sys IN BOOLEAN)
89: RETURN SYSTEM.QRM_VARCHAR_TABLE;
90:
91:
92:
93: --added by sankim 10/2/01
131: p_basis_point_value OUT NOCOPY NUMBER);
132:
133: --added by jbrodsky 11/02/01
134: PROCEDURE fxo_calculator(p_date_args IN SYSTEM.QRM_DATE_TABLE,
135: p_varchar_args IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE,
136: p_num_args IN OUT NOCOPY xtr_md_num_table);
137:
138:
139: END QRM_CALCULATORS_P;