1 PACKAGE XTR_FPS2_P as
2 /* $Header: xtrfps2s.pls 120.5 2005/09/15 04:37:26 badiredd ship $ */
3 -----------------------------------------------------------------------------------------------------
4 PROCEDURE CALC_CROSS_RATE(quoted_1st IN varchar2,
5 start_date IN date);
6 PROCEDURE CALC_REVALS ( p_start_date IN date,
7 p_end_date IN date,
8 p_sysdate IN date,
9 p_user IN varchar2,
10 p_company_code IN varchar2,
11 p_deal_type IN varchar2,
12 p_deal_subtype IN varchar2,
13 p_product_type IN varchar2,
14 p_portfolio_code IN varchar2);
15 PROCEDURE CALCULATE_FRA_PRICE (t IN NUMBER,
16 T1 IN NUMBER,
17 Rt IN NUMBER,
18 Rt1 IN NUMBER,
19 l_year_basis IN NUMBER,
20 fra_rate IN OUT NOCOPY NUMBER);
21 PROCEDURE DEAL_EXISTS (l_date IN DATE,
22 l_company IN VARCHAR2,
23 l_d_type IN VARCHAR2,
24 l_d_subty IN VARCHAR2,
25 l_dealer IN VARCHAR2,
26 l_exists IN OUT NOCOPY VARCHAR2);
27 PROCEDURE DEFAULTS (l_comp IN OUT NOCOPY VARCHAR2,
28 l_comp_name IN OUT NOCOPY VARCHAR2,
29 l_ccy IN OUT NOCOPY VARCHAR2,
30 l_ccy_name IN OUT NOCOPY VARCHAR2,
31 l_port IN OUT NOCOPY VARCHAR2);
32 /* Bug 1708946
33 PROCEDURE DEFAULT_CCY (l_pty IN VARCHAR2,
34 l_ccy IN OUT NOCOPY VARCHAR2,
35 l_ccy_name IN OUT NOCOPY VARCHAR2);
36 */
37 PROCEDURE DEFAULT_COMP_ACCT (l_company IN VARCHAR2,
38 l_currency IN VARCHAR2,
39 l_acct_nos IN OUT NOCOPY VARCHAR2);
40 PROCEDURE DEFAULT_SPOT_DATE (l_sysdate IN DATE,
41 l_ccy1 IN VARCHAR2,
42 l_ccy2 IN VARCHAR2,
43 out_date IN OUT NOCOPY DATE);
44 PROCEDURE DISCOUNT_INTEREST_CALC(days_in_year IN NUMBER,
45 amount IN NUMBER,
46 rate IN NUMBER,
47 no_of_days IN NUMBER,
48 round_factor IN NUMBER,
49 interest IN OUT NOCOPY NUMBER,
50 rounding_type IN VARCHAR2 default NULL);
51 PROCEDURE EXTRAPOLATE_FROM_YIELD_CURVE(l_ccy IN CHAR,
52 l_days IN NUMBER,
53 l_yield_curve IN VARCHAR2,
54 l_rate IN OUT NOCOPY NUMBER);
55 PROCEDURE EXTRAPOLATE_FROM_MARKET_PRICES(l_ccy IN CHAR,
56 l_days IN NUMBER,
57 l_rate IN OUT NOCOPY NUMBER);
58 PROCEDURE EXTRAPOLATE_RATE(l_company IN VARCHAR2,
59 l_period_from IN DATE,
60 l_period_to IN DATE,
61 l_ccy IN VARCHAR2,
62 l_days IN NUMBER,
63 l_reval_rate IN OUT NOCOPY NUMBER);
64 PROCEDURE INTEREST_CALCULATOR (days_in_year IN NUMBER,
65 amount IN NUMBER,
66 rate IN NUMBER,
67 no_of_days IN NUMBER,
68 round_factor IN NUMBER,
69 interest IN OUT NOCOPY NUMBER,
70 round_type IN VARCHAR2 DEFAULT NULL);
71 PROCEDURE SET_DEFAULTS (l_company_code IN OUT NOCOPY VARCHAR2,
72 l_company_name IN OUT NOCOPY VARCHAR2);
73 PROCEDURE SET_DEFAULTS_PDA (l_company_code IN VARCHAR2,
74 l_portfolio_code IN OUT NOCOPY VARCHAR2,
75 l_portfolio_name IN OUT NOCOPY VARCHAR2);
76 PROCEDURE DEFAULT_PORTFOLIO (l_company_code IN VARCHAR2,
77 l_portfolio_code IN OUT NOCOPY VARCHAR2);
78 PROCEDURE STANDING_SETTLEMENTS (l_party IN VARCHAR2,
79 l_ccy IN VARCHAR2,
80 l_deal_type IN VARCHAR2,
81 l_subtype IN VARCHAR2,
82 l_product IN VARCHAR2,
83 l_amount_type IN VARCHAR2,
84 l_cparty_ref IN OUT NOCOPY VARCHAR2,
85 l_account IN OUT NOCOPY VARCHAR2);
86
87
88 PROCEDURE TAX_BROKERAGE_DEFAULTS(l_deal_type IN VARCHAR2,
89 l_subtype IN VARCHAR2,
90 l_product IN VARCHAR2,
91 l_ref_party IN VARCHAR2,
92 l_prin_settled_by IN OUT NOCOPY VARCHAR2,
93 l_bkr_ref IN OUT NOCOPY VARCHAR2,
94 l_tax_ref IN OUT NOCOPY VARCHAR2,
95 l_int_settled_by IN OUT NOCOPY VARCHAR2,
96 l_int_freq IN OUT NOCOPY VARCHAR2,
97 l_bkr_amt_type IN OUT NOCOPY VARCHAR2,
98 l_tax_amt_type IN OUT NOCOPY VARCHAR2);
99
100 PROCEDURE TAX_BROKERAGE_DEFAULTING(l_deal_type IN VARCHAR2,
101 l_subtype IN VARCHAR2,
102 l_product IN VARCHAR2,
103 l_ref_party IN VARCHAR2,
104 l_prin_settled_by IN OUT NOCOPY VARCHAR2,
105 l_bkr_ref IN OUT NOCOPY VARCHAR2,
106 l_prin_tax_ref IN OUT NOCOPY VARCHAR2,
107 l_income_tax_ref IN OUT NOCOPY VARCHAR2,
108 -- for FX deals, inputted as buy ccy
109 -- outputted as tax ccy
110 l_ccy IN OUT NOCOPY VARCHAR2,
111 l_sell_ccy IN VARCHAR2 DEFAULT NULL,
112 l_int_settled_by IN OUT NOCOPY VARCHAR2,
113 l_int_freq IN OUT NOCOPY VARCHAR2,
114 l_bkr_amt_type IN OUT NOCOPY VARCHAR2);
115
116
117 PROCEDURE TAX_BROKERAGE_AMT_TYPE(l_deal_type IN VARCHAR2,
118 l_bkr_ref IN VARCHAR2,
119 l_tax_ref IN VARCHAR2,
120 l_bkr_amt_type IN OUT NOCOPY VARCHAR2,
121 l_tax_amt_type IN OUT NOCOPY VARCHAR2);
122 PROCEDURE UPDATE_JOURNALS (l_deal_nos IN NUMBER,
123 l_trans_nos IN NUMBER,
124 l_deal_type IN VARCHAR2);
125
126 PROCEDURE PRESENT_VALUE_CALC(days_in_year IN NUMBER,
127 amount IN NUMBER,
128 rate IN NUMBER,
129 no_of_days IN NUMBER,
130 round_factor IN NUMBER,
131 present_value IN OUT NOCOPY NUMBER);
132
133 PROCEDURE PRESENT_VALUE_COMPOUND(days_in_year IN NUMBER,
134 amount IN NUMBER,
135 rate IN NUMBER,
136 no_of_days IN NUMBER,
137 round_factor IN NUMBER,
138 present_value IN OUT NOCOPY NUMBER);
139
140 PROCEDURE RESET_FLOATING_RATES(errbuf OUT NOCOPY VARCHAR2,
141 retcode OUT NOCOPY NUMBER,
142 p_rateset_from IN VARCHAR2,
143 p_rateset_to IN VARCHAR2,
144 p_rateset_adj IN NUMBER,
145 p_deal_type IN VARCHAR2,
146 p_company IN VARCHAR2,
147 p_cparty IN VARCHAR2,
148 p_portfolio IN VARCHAR2,
149 p_currency IN VARCHAR2,
150 p_ric_code IN VARCHAR2,
151 p_source IN VARCHAR2);
152
153 PROCEDURE VALIDATE_TRANSACTION(p_company IN VARCHAR2,
154 p_deal_no IN NUMBER,
155 p_deal_type IN VARCHAR2,
156 p_start_date IN DATE,
157 p_valid_ok OUT NOCOPY BOOLEAN,
158 p_error OUT NOCOPY NUMBER);
159
160 PROCEDURE GET_BENCHMARK_RATE(p_ric_code IN VARCHAR2,
161 p_rate_date IN DATE,
162 p_rateset_adj IN NUMBER,
163 p_rate OUT NOCOPY NUMBER);
164
165 PROCEDURE UPDATE_RATE_ONE_TRANSACTION(p_deal_no IN NUMBER,
166 p_trans_no IN NUMBER,
167 p_deal_type IN VARCHAR2,
168 p_start_date IN DATE,
169 p_new_rate IN NUMBER);
170
171 PROCEDURE UPDATE_RATE_SEQ_TRANSACTION(p_deal_no IN NUMBER,
172 p_trans_no IN NUMBER,
173 p_deal_type IN VARCHAR2,
174 p_start_date IN DATE,
175 p_new_rate IN NUMBER);
176 FUNCTION ROUNDUP(p_amount NUMBER,
177 p_round_factor NUMBER) RETURN NUMBER;
178 FUNCTION INTEREST_ROUND
179 (p_amount NUMBER,
180 p_round_factor NUMBER,
181 p_rounding_type VARCHAR2 DEFAULT NULL
182 ) RETURN NUMBER;
183
184 PROCEDURE CURRENCY_CROSS_RATE (p_currency_from IN VARCHAR2,
185 p_currency_to IN VARCHAR2,
186 p_rate OUT NOCOPY NUMBER);
187
188 TYPE one_step_rec_type is record (p_source Varchar2(20) DEFAULT 'TAX',
189 p_schedule_code Xtr_Tax_Brokerage_Setup.Reference_Code%Type,
190 p_currency Xtr_Deals.Currency%Type,
191 p_amount Number,
192 p_settlement_date Date,
193 p_settlement_account Xtr_Deals.settle_account_no%type,
194 p_company_code Xtr_Deals.Company_Code%type,
195 p_cparty_code Xtr_Deals.Cparty_Code%type,
196 p_cparty_account_no Xtr_Deals.Cparty_Account_No%type,
197 p_error Varchar2(40),
198 p_settle_method Xtr_tax_brokerage_setup.tax_settle_method%type,
199 p_exp_number Xtr_Exposure_Transactions.Transaction_Number%Type
200 );
201
202 Procedure One_Step_Settlement(p_one_step_rec IN OUT NOCOPY one_step_rec_type);
203
204 PROCEDURE GET_SETTLE_METHOD (p_prncpl_tax IN VARCHAR2,
205 p_prncpl_ctype OUT NOCOPY VARCHAR2,
206 p_prncpl_method OUT NOCOPY VARCHAR2,
207 p_income_tax IN VARCHAR2,
208 p_income_ctype OUT NOCOPY VARCHAR2,
209 p_income_method OUT NOCOPY VARCHAR2);
210
211
212 PROCEDURE CALC_TMM_TAX (p_prncpl_ctype IN VARCHAR2,
213 p_prncpl_method IN VARCHAR2,
214 p_income_ctype IN VARCHAR2,
215 p_income_method IN VARCHAR2,
216 p_settle_acct IN VARCHAR2,
217 p_last_tran IN VARCHAR2,
218 p_RT IN OUT NOCOPY XTR_ROLLOVER_TRANSACTIONS_V%ROWTYPE);
219
220 PROCEDURE CALC_TMM_ONE_STEP (p_tax_type IN VARCHAR2,
221 p_deal_no IN NUMBER,
222 p_tran_no IN NUMBER,
223 p_amt_hce IN NUMBER,
224 p_prncpl_ref IN NUMBER,
225 p_prncpl_method IN VARCHAR2,
226 p_income_ref IN NUMBER,
227 p_income_method IN VARCHAR2,
228 p_one_step IN OUT NOCOPY ONE_STEP_REC_TYPE);
229
230
231 PROCEDURE DELETE_TAX_EXPOSURE(p_deal_no IN NUMBER,
232 p_trans_no IN NUMBER default null);
233
234 PROCEDURE DELETE_TAX_EXP_AND_UPDATE(p_tax_settle_no IN NUMBER);
235
236 --Bug 2804548
237 PROCEDURE UPDATE_TAX_EXP (p_exp_number NUMBER,
238 p_amount NUMBER);
239
240 --Bug 2804548
241 PROCEDURE UPDATE_TAX_DDA (p_exp_number NUMBER,
242 p_amount NUMBER);
243
244 ----------------------------------------------------------------------------------------
245 end XTR_FPS2_P;