[Home] [Help]
PACKAGE: APPS.OKL_MASS_REBOOK_PVT
Source
1 PACKAGE OKL_MASS_REBOOK_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRMRPS.pls 120.6 2007/09/25 04:34:58 rpillay ship $*/
3
4 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(1000) := 'OKL_UNEXPECTED_ERROR';
5 G_NOT_VALID_REQUEST CONSTANT VARCHAR2(1000) := 'OKL_LLA_NOT_VALID_RERQUEST';
6 G_INVALID_CRITERIA CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_CRITERIA';
7 G_FORMAT_ERROR CONSTANT VARCHAR2(1000) := 'OKL_LLA_FORMAT_ERROR';
8 G_NO_MATCH_FOUND CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_MATCH_FOUND';
9 G_INVALID_CODE CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_CODE';
10 G_DUPLICATE_REQUEST CONSTANT VARCHAR2(1000) := 'OKL_LLA_DUPLICATE_REQUEST';
11 G_NO_SEL_CONTRACT CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_SELECTED_CONTRACT';
12 G_INVALID_SET_VALUE CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_SET_VALUE';
13 G_NO_SET_VALUE CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_SET_VALUE';
14 G_INVALID_OPERAND CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_OPERAND';
15 G_INVALID_MATCH_OPTION CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_MATCH_OPTION';
16
17
18 SUBTYPE mrbv_rec_type IS okl_mrb_pvt.mrbv_rec_type;
19 SUBTYPE mrbv_tbl_type IS okl_mrb_pvt.mrbv_tbl_type;
20
21 SUBTYPE mstv_rec_type IS okl_mst_pvt.mstv_rec_type;
22 SUBTYPE mstv_tbl_type IS okl_mst_pvt.mstv_tbl_type;
23
24 subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
25
26 subtype thpv_rec_type IS OKL_TRX_ASSETS_PUB.thpv_rec_type;
27 subtype thpv_tbl_type IS OKL_TRX_ASSETS_PUB.thpv_tbl_type;
28
29 subtype tlpv_rec_type IS OKL_TXL_ASSETS_PUB.tlpv_rec_type;
30 subtype tlpv_tbl_type IS OKL_TXL_ASSETS_PUB.tlpv_tbl_type;
31
32 subtype adpv_rec_type IS OKL_TXD_ASSETS_PUB.adpv_rec_type;
33 subtype adpv_tbl_type IS OKL_TXD_ASSETS_PUB.adpv_tbl_type;
34
35 subtype khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
36 subtype chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
37
38 subtype klev_rec_type IS OKL_CONTRACT_PUB.klev_rec_type;
39 subtype clev_rec_type IS OKL_OKC_MIGRATION_PVT.clev_rec_type;
40
41 subtype klev_tbl_type IS OKL_CONTRACT_PUB.klev_tbl_type;
42 subtype clev_tbl_type IS OKL_OKC_MIGRATION_PVT.clev_tbl_type;
43
44 subtype cvmv_rec_type IS OKL_VERSION_PUB.cvmv_rec_type;
45
46 --
47 -- Order of Criteria Code in Table is important
48 -- It should be as follows, if present
49 --
50 -- CONTRACT_NUMBER, START_DATE, BOOK_TYPE_CODE, DEPRN_METHOD_CODE, DATE_PLACED_IN_SERVICE, ASSET_CATEGORY_ID
51 --
52 TYPE crit_rec_type IS RECORD (
53 LINE_NUMBER NUMBER,
54 CRITERIA_CODE VARCHAR2(30),
55 OPERAND VARCHAR2(150),
56 CRITERIA_VALUE1 VARCHAR2(150),
57 CRITERIA_VALUE2 VARCHAR2(150),
58 SET_VALUE VARCHAR2(150)
59 );
60
61 TYPE crit_tbl_type IS TABLE OF crit_rec_type INDEX BY BINARY_INTEGER;
62
63 TYPE rbk_rec_type IS RECORD (
64 KHR_ID NUMBER := OKL_API.G_MISS_NUM,
65 CONTRACT_NUMBER OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE,
66 KLE_ID OKL_K_LINES_V.ID%TYPE,
67 DESCRIPTION OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE
68 );
69
70 TYPE rbk_tbl_type IS TABLE OF rbk_rec_type INDEX BY BINARY_INTEGER;
71
72 TYPE strm_lalevl_rec_type IS RECORD
73 (
74 Chr_Id NUMBER,
75 Cle_Id NUMBER,
76 Rule_Information1 VARCHAR2 (450),
77 Rule_Information2 VARCHAR2 (450),
78 Rule_Information3 VARCHAR2 (450),
79 Rule_Information4 VARCHAR2 (450),
80 Rule_Information5 VARCHAR2 (450),
81 Rule_Information6 VARCHAR2 (450),
82 Rule_Information7 VARCHAR2 (450),
83 Rule_Information8 VARCHAR2 (450),
84 Rule_Information9 VARCHAR2 (450),
85 Rule_Information10 VARCHAR2 (450),
86 Rule_Information11 VARCHAR2 (450),
87 Rule_Information12 VARCHAR2 (450),
88 Rule_Information13 VARCHAR2 (450),
89 Rule_Information14 VARCHAR2 (450),
90 Rule_Information15 VARCHAR2 (450),
91 Rule_Information_Category VARCHAR2 (90),
92 Object1_Id1 VARCHAR2 (40),
93 Object1_Id2 VARCHAR2 (200),
94 Object2_Id1 VARCHAR2 (40),
95 Object2_Id2 VARCHAR2 (200),
96 Object3_Id1 VARCHAR2 (40),
97 Object3_Id2 VARCHAR2 (200),
98 Jtot_Object1_Code VARCHAR2 (30),
99 Jtot_Object2_Code VARCHAR2 (30),
100 Jtot_Object3_Code VARCHAR2 (30)
101 );
102
103 TYPE strm_lalevl_tbl_type IS TABLE OF strm_lalevl_rec_type INDEX BY BINARY_INTEGER;
104
105 TYPE strm_trx_rec_type IS RECORD (
106 CHR_ID OKC_K_HEADERS_V.ID%TYPE,
107 TRX_NUMBER NUMBER
108 );
109
110 TYPE strm_trx_tbl_type IS TABLE OF strm_trx_rec_type INDEX BY BINARY_INTEGER;
111
112 TYPE kle_rec_type IS RECORD (
113 ID OKL_K_LINES_V.ID%TYPE
114 );
115
116 TYPE kle_tbl_type IS TABLE OF kle_rec_type INDEX BY BINARY_INTEGER;
117
118 PROCEDURE build_and_get_contracts(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
125 p_mrbv_tbl IN mrbv_tbl_type,
126 x_mstv_tbl OUT NOCOPY mstv_tbl_type,
127 x_rbk_count OUT NOCOPY NUMBER
128 );
129
130 PROCEDURE build_and_get_contracts(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
137 p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
138 p_mrbv_tbl IN mrbv_tbl_type,
139 x_mstv_tbl OUT NOCOPY mstv_tbl_type,
140 x_rbk_count OUT NOCOPY NUMBER
141 );
142
143 PROCEDURE process_mass_rebook(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE
150 );
151 PROCEDURE apply_mass_rebook(
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_rbk_tbl IN rbk_tbl_type,
158 p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
159 p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
160 p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
161 p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
162 p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
163 p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
164 p_strm_lalevl_tbl IN strm_lalevl_tbl_type
165 );
166
167 PROCEDURE apply_mass_rebook(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_rbk_tbl IN rbk_tbl_type,
174 p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
175 p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
176 p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
177 p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
178 p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
179 p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
180 p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
181 x_stream_trx_tbl OUT NOCOPY strm_trx_tbl_type
182 );
183
184 PROCEDURE apply_mass_rebook(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_rbk_tbl IN rbk_tbl_type,
191 p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
192 p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
193 p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
194 p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
195 p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
196 p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
197 p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
198 p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
199 x_stream_trx_tbl OUT NOCOPY strm_trx_tbl_type
200 );
201
202 PROCEDURE apply_mass_rebook(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_rbk_tbl IN rbk_tbl_type,
209 p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
210 p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
211 p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
212 p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
213 p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
214 p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
215 p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
216 p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
217 p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
218 x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
219 );
220
221 PROCEDURE apply_mass_rebook(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_rbk_tbl IN rbk_tbl_type,
228 p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
229 p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
230 p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
231 p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
232 p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
233 p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
234 p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
235 p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
236 p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
237 p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
238 x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
239 );
240
241 PROCEDURE apply_mass_rebook(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
248 p_kle_tbl IN kle_tbl_type,
249 p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
250 p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
251 p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
252 x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
253 p_ppd_amount IN NUMBER,
254 p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
255 p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type
256 );
257
258 PROCEDURE update_mass_rbk_contract(
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_mstv_tbl IN MSTV_TBL_TYPE,
265 x_mstv_tbl OUT NOCOPY MSTV_TBL_TYPE
266 );
267
268 PROCEDURE mass_rebook_after_yield(
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
275 );
276 /* Added for CR-Bug # 6112560 CR for Mass Rebook Page Flows*/
277 PROCEDURE create_mass_rbk_set_values(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
284 p_mrbv_tbl IN mrbv_tbl_type,
285 x_mrbv_tbl OUT NOCOPY mrbv_tbl_type);
286
287 -- Bug# 5038395
288 PROCEDURE mass_rebook_activate(
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
291 x_return_status OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_msg_data OUT NOCOPY VARCHAR2,
294 p_chr_id IN NUMBER
295 );
296
297 END OKL_MASS_REBOOK_PVT;