1 PACKAGE XTR_EXP_SUMM_P as
2 /* $Header: xtrexpos.pls 120.1 2005/06/29 06:29:38 badiredd ship $ */
3 ----------------------------------------------------------------------------------------------------------------
4 PROCEDURE CALC_HEDGE_DETAILS
5 (ref_number IN NUMBER,
6 sel_ccy IN VARCHAR2,
7 l_base_ccy IN VARCHAR2,
8 l_company IN VARCHAR2,
9 incl_options IN VARCHAR2,
10 incl_indic_exp IN VARCHAR2,
11 l_portfolio IN VARCHAR2,
12 perspective IN VARCHAR2,
13 l_yield_curve IN VARCHAR2,
14 l_year_basis IN NUMBER,
15 l_dflt_disc_rate IN NUMBER,
16 l_rounding IN NUMBER,
17 l_wk_mth IN VARCHAR2);
18 ------------------------------------------------------------------------------------------------
19 PROCEDURE CALC_TRADING_DETAILS
20 (ref_number IN NUMBER,
21 l_ccy_a IN VARCHAR2,
22 l_ccy_b IN VARCHAR2,
23 l_company IN VARCHAR2,
24 incl_options IN VARCHAR2,
25 l_portfolio IN VARCHAR2,
26 perspective IN VARCHAR2,
27 l_year_basis IN NUMBER,
28 l_rounding IN NUMBER);
29 ------------------------------------------------------------------------------------------------
30 PROCEDURE CALC_FX_FWD_RATE
31 (l_ccya IN VARCHAR2,
32 l_ccyb IN VARCHAR2,
33 l_company_code IN VARCHAR2,
34 l_yr_basis IN NUMBER,
35 l_end_date IN DATE,
36 l_base_ccy IN VARCHAR2,
37 l_answer IN OUT NOCOPY NUMBER);
38 ------------------------------------------------------------------------------------------------
39 PROCEDURE CALC_ALL_CCY_EXPOSURES
40 (ref_number IN NUMBER,
41 p_sel_ccy IN VARCHAR2,
42 l_base_ccy IN VARCHAR2,
43 l_company IN VARCHAR2,
44 incl_options IN VARCHAR2,
45 incl_indic_exp IN VARCHAR2,
46 l_portfolio IN VARCHAR2,
47 perspective IN VARCHAR2,
48 l_yield_curve IN VARCHAR2,
49 p_year_basis IN NUMBER,
50 l_dflt_disc_rate IN NUMBER,
51 p_rounding IN NUMBER,
52 p_count_months_from IN DATE);
53 ------------------------------------------------------------------------------------------------
54 FUNCTION GET_SPOT_RATE(p_base_ccy VARCHAR2,
55 p_contra_ccy VARCHAR2,
56 p_date DATE) RETURN NUMBER ;
57
58 ------------------------------------------------------------------------------------------------
59 FUNCTION GET_HCE_RATE(p_base_ccy VARCHAR2,
60 p_date DATE) RETURN NUMBER ;
61 ------------------------------------------------------------------------------------------------
62 PROCEDURE SUMMARY_COST_OF_FUNDS(errbuf OUT NOCOPY VARCHAR2,
63 retcode OUT NOCOPY NUMBER);
64 ------------------------------------------------------------------------------------------------
65 PROCEDURE MAINTAIN_COST_OF_FUNDS(
66 L_REF_DATE IN date,
67 L_COMPANY_CODE IN VARCHAR2,
68 L_CURRENCY IN VARCHAR2,
69 L_DEAL_TYPE IN VARCHAR2,
70 L_DEAL_SUBTYPE IN VARCHAR2,
71 L_PRODUCT_TYPE IN VARCHAR2,
72 L_PORTFOLIO_CODE IN VARCHAR2,
73 L_PARTY_CODE IN VARCHAR2,
74 L_CONTRA_CCY IN VARCHAR2,
75 L_CURRENCY_COMBINATION IN VARCHAR2,
76 L_ACCOUNT IN VARCHAR2,
77 L_AMOUNT_DATE IN DATE,
78 L_TRANSACTION_RATE IN NUMBER,
79 L_AMOUNT IN NUMBER,
80 L_AMOUNT_INDIC IN NUMBER,
81 L_ACTION_INDIC IN NUMBER);
82 ------------------------------------------------------------------------------------------------
83 end XTR_EXP_SUMM_P;