1 PACKAGE XTR_CALC_P as
2 /* $Header: xtrcalcs.pls 120.4.12000000.3 2007/10/24 08:24:46 srsampat ship $ */
3 ----------------------------------------------------------------------------------------------------------------
4 -- Calculate over a Year Basis and Number of Days ased on different calc methods
5 PROCEDURE CALC_DAYS_RUN_C(start_date IN DATE,
6 end_date IN DATE,
7 method IN VARCHAR2,
8 frequency IN NUMBER,
9 num_days IN OUT NOCOPY NUMBER,
10 year_basis IN OUT NOCOPY NUMBER,
11 fwd_adjust IN NUMBER DEFAULT NULL,
12 day_count_type IN VARCHAR2 DEFAULT NULL,
13 first_trans_flag IN VARCHAR2 DEFAULT NULL);
14
15 PROCEDURE CALC_DAYS_RUN_B(start_date IN DATE,
16 end_date IN DATE,
17 method IN VARCHAR2,
18 frequency IN NUMBER,
19 num_days IN OUT NOCOPY NUMBER,
20 year_basis IN OUT NOCOPY NUMBER);
21
22 PROCEDURE CALC_DAYS_RUN(start_date IN DATE,
23 end_date IN DATE,
24 method IN VARCHAR2,
25 num_days IN OUT NOCOPY NUMBER,
26 year_basis IN OUT NOCOPY NUMBER,
27 fwd_adjust IN NUMBER DEFAULT NULL,
28 day_count_type IN VARCHAR2 DEFAULT NULL,
29 first_trans_flag IN VARCHAR2 DEFAULT NULL);
30
31 PROCEDURE CALCULATE_BOND_PRICE_YIELD(p_bond_issue_code IN VARCHAR2,
32 p_settlement_date IN DATE,
33 p_ex_cum_next_coupon IN VARCHAR2,-- EX,CUM
34 p_calculate_yield_or_price IN VARCHAR2,-- Y,P
35 p_yield IN OUT NOCOPY NUMBER,
36 p_accrued_interest IN OUT NOCOPY NUMBER,
37 p_clean_price IN OUT NOCOPY NUMBER,
38 p_dirty_price IN OUT NOCOPY NUMBER,
39 p_input_or_calculator IN VARCHAR2, -- C,I
40 p_commence_date IN DATE,
41 p_maturity_date IN DATE,
42 p_prev_coupon_date IN DATE,
43 p_next_coupon_date IN DATE,
44 p_calc_type IN VARCHAR2,
45 p_year_calc_type IN VARCHAR2,
46 p_accrued_int_calc_basis IN VARCHAR2,
47 p_coupon_freq IN NUMBER,
48 p_calc_rounding IN NUMBER,
49 p_price_rounding IN NUMBER,
50 p_price_round_type IN VARCHAR2,
51 p_yield_rounding IN NUMBER,
52 p_yield_round_type IN VARCHAR2,
53 p_coupon_rate IN NUMBER,
54 p_num_coupons_remain IN NUMBER,
55 p_day_count_type IN VARCHAR2 DEFAULT null,
56 p_first_trans_flag IN VARCHAR2 DEFAULT null,
57 p_deal_subtype IN VARCHAR2 DEFAULT null,
58 p_currency IN VARCHAR2 DEFAULT null,
59 p_face_value IN NUMBER DEFAULT null,
60 p_consideration IN NUMBER DEFAULT null,
61 p_rounding_type IN VARCHAR2 DEFAULT null);
62
63 PROCEDURE Calculate_Bond_Coupon_Amounts (
64 p_bond_issue_code IN VARCHAR2,
65 p_next_coupon_date IN DATE,
66 p_settlement_date IN DATE,
67 p_deal_number IN NUMBER,
68 p_deal_date IN DATE,
69 p_company_code IN VARCHAR2,
70 p_cparty_code IN VARCHAR2,
71 p_dealer_code IN VARCHAR2,
72 p_status_code IN VARCHAR2,
73 p_client_code IN VARCHAR2,
74 p_acceptor_code IN VARCHAR2,
75 p_maturity_account_number IN VARCHAR2,
76 p_maturity_amount IN NUMBER,
77 p_deal_subtype IN VARCHAR2,
78 p_product_type IN VARCHAR2,
79 p_portfolio_code IN VARCHAR2,
80 p_rounding_type IN VARCHAR2 DEFAULT NULL,
81 p_day_count_type IN VARCHAR2 DEFAULT NULL,
82 p_income_tax_ref IN VARCHAR2 DEFAULT NULL,
83 p_income_tax_rate IN OUT NOCOPY NUMBER,
84 p_income_tax_settled_ref IN OUT NOCOPY NUMBER);
85
86
87 PROCEDURE RECALC_DT_DETAILS (
88 l_deal_no IN NUMBER,
89 l_least_inserted IN VARCHAR2,
90 l_ref_date IN DATE,
91 l_trans_num IN NUMBER,
92 l_last_row IN VARCHAR2,
93 g_chk_bal IN VARCHAR2,
94 g_expected_balance_bf IN OUT NOCOPY NUMBER,
95 g_balance_out_bf IN OUT NOCOPY NUMBER,
96 g_accum_interest_bf IN OUT NOCOPY NUMBER,
97 g_principal_adjust IN OUT NOCOPY NUMBER,
98 c_principal_action IN VARCHAR2,
99 c_principal_amount_type IN VARCHAR2,
100 c_principal_adjust IN NUMBER,
101 c_writoff_int IN NUMBER,
102 c_increase_effective_from IN DATE,
103 --Add Interest Override
104 l_rounding_type IN VARCHAR2 DEFAULT null,
105 l_day_count_type IN VARCHAR2 DEFAULT null);
106
107 -- bug 5349167
108 PROCEDURE CALC_DAYS_RUN_IG(start_date IN DATE,
109 end_date IN DATE,
110 method IN VARCHAR2,
111 num_days IN OUT NOCOPY NUMBER,
112 year_basis IN OUT NOCOPY NUMBER,
113 fwd_adjust IN NUMBER DEFAULT NULL,
114 day_count_type IN VARCHAR2 DEFAULT NULL,
115 first_trans_flag IN VARCHAR2 DEFAULT NULL);
116
117
118 end XTR_CALC_P;