[Home] [Help]
PACKAGE: APPS.OKL_K_RATE_PARAMS_PVT
Source
1 PACKAGE OKL_K_RATE_PARAMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRKRPS.pls 120.5.12010000.2 2008/09/30 06:06:06 rpillay ship $ */
3 TYPE krpdel_rec_type IS RECORD (
4 khr_id NUMBER := OKC_API.G_MISS_NUM
5 ,rate_type VARCHAR2(30) := OKC_API.G_MISS_CHAR
6 ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
7 );
8
9 TYPE krpdel_tbl_type IS TABLE OF krpdel_rec_type INDEX BY BINARY_INTEGER;
10
11 TYPE krpr_rec_type IS RECORD (
12 khr_id NUMBER := OKC_API.G_MISS_NUM
13 ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
14 ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
15 ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,interest_index_id NUMBER := OKC_API.G_MISS_NUM
17 ,base_rate NUMBER := OKC_API.G_MISS_NUM
18 ,interest_start_date OKL_K_RATE_PARAMS_V.INTEREST_START_DATE%TYPE := OKC_API.G_MISS_DATE
19 ,adder_rate NUMBER := OKC_API.G_MISS_NUM
20 ,maximum_rate NUMBER := OKC_API.G_MISS_NUM
21 ,minimum_rate NUMBER := OKC_API.G_MISS_NUM
22 ,principal_basis_code OKL_K_RATE_PARAMS_V.PRINCIPAL_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
23 ,days_in_a_month_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_MONTH_CODE%TYPE := OKC_API.G_MISS_CHAR
24 ,days_in_a_year_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_YEAR_CODE%TYPE := OKC_API.G_MISS_CHAR
25 ,interest_basis_code OKL_K_RATE_PARAMS_V.INTEREST_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
26 );
27
28 TYPE krpar_rec_type IS RECORD (
29 khr_id NUMBER := OKC_API.G_MISS_NUM
30 ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
31 ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
32 ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
33 ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR
34 ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM
35 ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
36 ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM
37 ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
38 ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE
39 ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR
40 ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE
41 ,rate_change_frequency_code OKL_K_RATE_PARAMS_V.RATE_CHANGE_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
42 ,rate_change_value NUMBER := OKC_API.G_MISS_NUM
43 );
44
45 TYPE krpc_rec_type IS RECORD (
46 khr_id NUMBER := OKC_API.G_MISS_NUM
47 ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48 ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
49 ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
50 ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
51 ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE
52 ,conversion_type_code OKL_K_RATE_PARAMS_V.CONVERSION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
53 );
54
55 TYPE var_prm_rec_type is RECORD (
56 param_identifier FND_LOOKUPS.LOOKUP_CODE%TYPE,
57 param_identifier_meaning FND_LOOKUPS.MEANING%TYPE,
58 parameter_type_code OKL_K_RATE_PARAMS.PARAMETER_TYPE_CODE%TYPE,
59 interest_index_id OKL_K_RATE_PARAMS.INTEREST_INDEX_ID%TYPE,
60 effective_from_date OKL_K_RATE_PARAMS.EFFECTIVE_FROM_DATE%TYPE,
61 effective_to_date OKL_K_RATE_PARAMS.EFFECTIVE_TO_DATE%TYPE
62 );
63
64 TYPE var_prm_tbl_type IS TABLE OF var_prm_rec_type INDEX BY BINARY_INTEGER;
65
66 subtype krp_rec_type is OKL_KRP_PVT.krp_rec_type;
67 subtype krpv_rec_type is OKL_KRP_PVT.krpv_rec_type;
68 subtype krp_tbl_type is OKL_KRP_PVT.krp_tbl_type;
69 subtype krpv_tbl_type is OKL_KRP_PVT.krpv_tbl_type;
70
71 -- GLOBAL VARIABLES
72
73 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_K_RATE_PARAMS_PVT';
74 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
75
76 procedure get_product(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_khr_id IN okc_k_headers_b.id%type,
83 x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type);
84
85 /* This is to be called from contract import */
86 PROCEDURE create_k_rate_params(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_krpv_rec IN krpv_rec_type,
93 x_krpv_rec OUT NOCOPY krpv_rec_type,
94 p_validate_flag IN VARCHAR2 DEFAULT 'Y');
95
96 PROCEDURE create_k_rate_params(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_krpr_rec IN krpr_rec_type,
103 x_krpr_rec OUT NOCOPY krpr_rec_type);
104
105 PROCEDURE create_k_rate_params(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_krpar_rec IN krpar_rec_type,
112 x_krpar_rec OUT NOCOPY krpar_rec_type);
113
114 PROCEDURE create_k_rate_params(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_krpc_rec IN krpc_rec_type,
121 x_krpc_rec OUT NOCOPY krpc_rec_type);
122
123 /* For both UI and contract import */
124 PROCEDURE update_k_rate_params(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_krpv_rec IN krpv_rec_type,
131 x_krpv_rec OUT NOCOPY krpv_rec_type);
132
133 PROCEDURE update_k_rate_params(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_krpr_rec IN krpr_rec_type,
140 x_krpr_rec OUT NOCOPY krpr_rec_type);
141
142 PROCEDURE update_k_rate_params(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_krpar_rec IN krpar_rec_type,
149 x_krpar_rec OUT NOCOPY krpar_rec_type);
150
151 PROCEDURE update_k_rate_params(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_krpc_rec IN krpc_rec_type,
158 x_krpc_rec OUT NOCOPY krpc_rec_type);
159
160 PROCEDURE delete_k_rate_params(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_krpdel_tbl IN krpdel_tbl_type);
167
168 /* For QA checker to call - stack Error messages and no raise exception*/
169 PROCEDURE validate_k_rate_params(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_khr_id IN okc_k_headers_b.id%type,
176 --Bug# 7440232
177 p_validate_flag IN VARCHAR2 DEFAULT 'Y');
178
179 /* For contract import to call */
180 PROCEDURE validate_k_rate_params(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_product_id IN okl_products_v.id%type,
187 p_k_rate_tbl IN krpv_tbl_type,
188 p_validate_flag IN VARCHAR2 DEFAULT 'Y');
189
190 Procedure generate_rate_summary(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_chr_id IN NUMBER,
197 x_var_par_tbl OUT NOCOPY var_prm_tbl_type);
198
199 PROCEDURE default_k_rate_params(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_deal_type IN okl_product_parameters_v.deal_type%type,
206 p_rev_rec_method IN okl_product_parameters_v.revenue_recognition_method%type,
207 p_int_calc_basis IN okl_product_parameters_v.interest_calculation_basis%type,
208 p_column_name IN VARCHAR2,
209 p_krpv_rec IN OUT NOCOPY krpv_rec_type);
210
211 PROCEDURE cascade_contract_start_date(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
218 p_new_start_date IN DATE);
219
220 PROCEDURE get_rate_rec(p_chr_id IN NUMBER,
221 p_parameter_type_code IN VARCHAR2,
222 p_effective_from_date IN DATE,
223 x_krpv_rec OUT NOCOPY krpv_rec_type,
224 x_no_data_found OUT NOCOPY BOOLEAN
225 );
226
227 -- smadhava Bug#4542290 - 22-Aug-2005 - Added - Start
228 PROCEDURE check_rebook_allowed (
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
235 p_rebook_date IN DATE);
236 -- smadhava Bug#4542290 - 22-Aug-2005 - Added - End
237
238 PROCEDURE SYNC_RATE_PARAMS(
239 p_orig_contract_id IN NUMBER,
240 p_new_contract_id IN NUMBER);
241
242 PROCEDURE check_base_rate(
243 p_khr_id IN NUMBER,
244 x_base_rate_defined OUT NOCOPY BOOLEAN,
245 x_return_status OUT NOCOPY VARCHAR2);
246
247 PROCEDURE check_principal_payment(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
254 x_principal_payment_defined OUT NOCOPY BOOLEAN);
255
256 FUNCTION get_formula_id(p_name IN VARCHAR2) RETURN NUMBER ;
257
258 PROCEDURE copy_k_rate_params(
259 p_api_version IN NUMBER,
260 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2,
264 p_khr_id IN NUMBER,
265 p_effective_from_date IN DATE,
266 p_rate_type IN VARCHAR2,
267 x_krpv_rec OUT NOCOPY krpv_rec_type);
268
269 -- Bug 4917614
270 PROCEDURE SYNC_BASE_RATE(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 p_khr_id IN NUMBER);
277
278 END OKL_K_RATE_PARAMS_PVT;