1 PACKAGE XTR_FPS1_P AUTHID CURRENT_USER as
2 /* $Header: xtrfps1s.pls 120.1 2005/06/29 07:20:41 badiredd ship $ */
3 ----------------------------------------------------------------------------------------------------------------
4 PROCEDURE ADVICE_LETTERS (l_deal_type IN VARCHAR2,
5 l_product IN VARCHAR2,
6 l_cparty IN VARCHAR2,
7 l_client IN VARCHAR2,
8 l_cparty_adv IN OUT NOCOPY VARCHAR2,
9 l_client_adv IN OUT NOCOPY VARCHAR2);
10 PROCEDURE CAL_BOND_PRICE (num_full_cpn_remain IN NUMBER,
11 annual_yield IN NUMBER,
12 days_settle_to_nxt_cpn IN NUMBER,
13 days_last_cpn_to_nxt_cpn IN NUMBER,
14 annual_cpn IN NUMBER,
15 l_vol_chg_ann_yield IN NUMBER,
16 cum_price IN OUT NOCOPY NUMBER,
17 ex_price IN OUT NOCOPY NUMBER,
18 vol_price IN OUT NOCOPY NUMBER);
19 PROCEDURE CALC_OPTION_PRICE (l_expiry IN DATE,
20 l_volatility IN NUMBER,
21 l_counter_ccy IN CHAR,
22 l_market_rate IN NUMBER,
23 l_strike_rate IN NUMBER,
24 l_spot_rate IN NUMBER,
25 l_subtype IN CHAR,
26 l_int_rate IN NUMBER,
27 l_ref_amount IN NUMBER,
28 l_put_call IN CHAR,
29 l_reval_amt IN OUT NOCOPY NUMBER,
30 l_end_date IN DATE);
31
32 PROCEDURE CALC_TAX_BROKERAGE(l_deal_type IN VARCHAR2,
33 l_deal_date IN DATE,
34 l_tax_ref IN VARCHAR2,
35 l_bkge_ref IN VARCHAR2,
36 l_ccy IN VARCHAR2,
37 l_yr_basis IN NUMBER,
38 l_num_days IN NUMBER,
39 l_tax_amt_type IN VARCHAR2,
40 l_tax_amt IN NUMBER,
41 l_tax_rate IN OUT NOCOPY NUMBER,
42 l_bkr_amt_type IN VARCHAR2,
43 l_bkr_amt IN NUMBER,
44 l_bkr_rate IN OUT NOCOPY NUMBER,
45 l_tax_out IN OUT NOCOPY NUMBER,
46 l_tax_out_hce IN OUT NOCOPY NUMBER,
47 l_bkge_out IN OUT NOCOPY NUMBER,
48 l_bkge_out_hce IN OUT NOCOPY NUMBER,
49 l_err_code OUT NOCOPY NUMBER,
50 l_level OUT NOCOPY VARCHAR2);
51
52 PROCEDURE CALC_TAX_AMOUNT (l_deal_type IN VARCHAR2,
53 l_deal_date IN DATE,
54 l_prin_tax_ref IN VARCHAR2,
55 l_income_tax_ref IN VARCHAR2,
56 l_ccy_buy IN VARCHAR2, -- ccy for MM deals
57 l_ccy_sell IN VARCHAR2 DEFAULT NULL,
58 l_year_basis IN NUMBER,
59 l_num_days IN NUMBER,
60 l_prin_tax_amount IN NUMBER,
61 l_prin_tax_rate IN OUT NOCOPY NUMBER,
62 l_income_tax_amount IN NUMBER,
63 l_income_tax_rate IN OUT NOCOPY NUMBER,
64 l_prin_tax_out IN OUT NOCOPY NUMBER,
65 l_income_tax_out IN OUT NOCOPY NUMBER,
66 l_err_code OUT NOCOPY NUMBER,
67 l_level OUT NOCOPY VARCHAR2);
68
69 FUNCTION GET_TAX_SETTLE_METHOD (l_tax_ref VARCHAR2) RETURN VARCHAR2;
70
71
72 FUNCTION GET_TAX_ROUND_FACTOR(l_rounding_precision VARCHAR2,
73 l_ccy VARCHAR2) RETURN NUMBER;
74
75
76 PROCEDURE CHK_CCY_CODE (l_currency IN VARCHAR2,
77 l_ccy_name IN OUT NOCOPY VARCHAR2,
78 l_yr_basis IN OUT NOCOPY NUMBER,
79 l_round IN OUT NOCOPY NUMBER,
80 l_err_code OUT NOCOPY NUMBER,
81 l_level OUT NOCOPY VARCHAR2);
82 PROCEDURE CHK_CLIENT_CODE (l_client_code IN VARCHAR2,
83 l_client_name IN OUT NOCOPY VARCHAR2,
84 l_query IN VARCHAR2,
85 l_err_code OUT NOCOPY NUMBER,
86 l_level OUT NOCOPY VARCHAR2);
87 PROCEDURE CHK_COMPANY_CODE (l_company_code IN VARCHAR2,
88 l_company_name IN OUT NOCOPY VARCHAR2,
89 l_query IN VARCHAR2,
90 l_err_code OUT NOCOPY NUMBER,
91 l_level OUT NOCOPY VARCHAR2);
92 PROCEDURE CHK_CPARTY_ACCOUNT (l_cparty_code IN VARCHAR2,
93 l_cparty_ref IN VARCHAR2,
94 l_currency IN VARCHAR2,
95 l_cparty_account IN OUT NOCOPY VARCHAR2,
96 l_err_code OUT NOCOPY NUMBER,
97 l_level OUT NOCOPY VARCHAR2);
98 PROCEDURE CHK_CPARTY_CODE (l_cparty_code IN VARCHAR2,
99 l_cparty_name IN OUT NOCOPY VARCHAR2,
100 l_query IN VARCHAR2,
101 l_err_code OUT NOCOPY NUMBER,
102 l_level OUT NOCOPY VARCHAR2);
103 PROCEDURE CHK_CPARTY_LIMIT (l_cparty_code IN VARCHAR2,
104 l_company_code IN VARCHAR2,
105 l_limit_code IN VARCHAR2,
106 l_err_code OUT NOCOPY NUMBER,
107 l_level OUT NOCOPY VARCHAR2);
108 PROCEDURE CHK_DEALER_CODE (l_dealer_code IN VARCHAR2,
109 l_err_code OUT NOCOPY NUMBER,
110 l_level OUT NOCOPY VARCHAR2);
111 PROCEDURE CHK_DEAL_STATUS (l_deal_number IN NUMBER,
112 l_err_code OUT NOCOPY NUMBER,
113 l_level OUT NOCOPY VARCHAR2);
114 ----------------------------------------------------------------------------------------------------------------
115 end XTR_FPS1_P;