[Home] [Help]
PACKAGE: APPS.OKL_INSURANCE_POLICIES_PVT
Source
1 PACKAGE OKL_INSURANCE_POLICIES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRIPXS.pls 120.6 2007/09/13 18:31:52 smereddy ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 SUBTYPE ipyv_rec_type IS Okl_Ipy_Pvt.ipyv_rec_type;
7 SUBTYPE inav_rec_type IS Okl_Ina_Pvt.inav_rec_type;
8
9 -- Added for Credit Memo Bug 3976894
10 SUBTYPE taiv_rec_type IS okl_trx_ar_invoices_pub.taiv_rec_type;
11 SUBTYPE tilv_rec_type IS okl_txl_ar_inv_lns_pub.tilv_rec_type ;
12 SUBTYPE bpd_acc_rec_type IS Okl_Acc_Call_Pub.bpd_acc_rec_type;
13 ---------------------------------------------------------------------------
14 -- GLOBAL MESSAGE CONSTANTS
15 ---------------------------------------------------------------------------
16 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
17 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
18 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
19 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
20 G_COL_VALUE_TOKEN CONSTANT VARCHAR2(200) := 'COL_VALUE';
21 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
22 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
23 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
24 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
25 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_PARENT_RECORD';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
27 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
28 G_INVALID_POLICY CONSTANT VARCHAR2(200) := 'OKL_POLICY_INVALID';
29 G_INVALID_QUOTE_TYPE CONSTANT VARCHAR2(200) := 'OKL_QUOTE_TYPE_INVALID';
30 G_EXPIRED_QUOTE CONSTANT VARCHAR2(200) := 'OKL_QUOTE_EXPIRED';
31 G_NO_STREAM_REC_FOUND CONSTANT VARCHAR2(200) := 'OKL_NO_STREAM_REC_FOUND';
32 G_INVALID_CONTRACT CONSTANT VARCHAR2(200) := 'OKL_INVALID_CONTRACT';
33 G_K_NOT_ACTIVE CONSTANT VARCHAR2(200) := 'OKL_K_NOT_ACTIVE';
34 G_INVALID_FOR_ACTIVE_TYPE CONSTANT VARCHAR2(200) := 'OKL_INVALID_FOR_ACTIVE_TYPE';
35 G_INVALID_FOR_ACTIVE_STATUS CONSTANT VARCHAR2(200) := 'OKL_INVALID_FOR_ACTIVE_STATUS';
36 G_STREAM_ALREADY_ACTIVE CONSTANT VARCHAR2(200) := 'OKL_STREAM_ALREADY_ACTIVE';
37 G_INVALID_CONTRACT_LINE CONSTANT VARCHAR2(200) := 'OKL_INVALID_CONTRACT_LINE';
38 G_FND_LOOKUP_PAYMENT_FREQ CONSTANT VARCHAR2(200) := 'OKL_INS_PAYMENT_FREQUENCY';
39 G_NO_CAPITAL_AMOUNT CONSTANT VARCHAR2(200) := 'OKL_NO_CAPITAL_AMOUNT';
40 G_NO_SYSTEM_PROFILE CONSTANT VARCHAR2(200) := 'OKL_NO_SYSTEM_PROFILE';
41 G_SYS_PROFILE_NAME CONSTANT VARCHAR2(200) := 'OKL_SYS_PROFILE_NAME';
42 G_NO_INSURANCE CONSTANT VARCHAR2(200) := 'OKL_NO_INSURANCE';
43 G_NO_K_TERM CONSTANT VARCHAR2(200) := 'OKL_NO_K_TERM';
44 G_NO_K_OEC CONSTANT VARCHAR2(200) := 'OKL_NO_K_OEC';
45 G_NO_OEC CONSTANT VARCHAR2(200) := 'OKL_NO_OEC';
46 G_NO_KLE CONSTANT VARCHAR2(200) := 'OKL_NO_KLE';
47 G_NO_INS_CLASS CONSTANT VARCHAR2(200) := 'OKL_NO_INS_CLASS';
48 G_FORMULA_REFUND_CALC CONSTANT VARCHAR2(200) := 'INSURANCE REFUND';
49 G_NO_TRX CONSTANT VARCHAR2(200) := 'OKL_NO_TRANSACTION_TYPE';
50 G_NO_STREAM CONSTANT VARCHAR2(200) := 'OKL_NO_STREAM_TYPE';
51 G_NO_THIRD_PARTY CONSTANT VARCHAR2(200) := 'OKL_NO_THIRD_PARTY';
52 G_FORMULA_PARAM_1 CONSTANT VARCHAR2(30) := 'CANCELLATION DATE'; --++ Eff Dated Term Change +++-----
53 G_FORMULA_PARAM_2 CONSTANT VARCHAR2(30) := 'CANCELLATION REASON'; --++ Eff Dated Term Change +++-----
54 G_PURPOSE_TOKEN CONSTANT VARCHAR2(30) := 'PURPOSE'; -- bug 4024785
55 ---------------------------------------------------------------------------
56 -- GLOBAL VARIABLES
57 ---------------------------------------------------------------------------
58 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INSURANCE_POLICIES_PVT';
59 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
60 ---------------------------------------------------------------------------
61 -- GLOBAL EXCEPTION
62 ---------------------------------------------------------------------------
63 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
64 ---------------------------------------------------------------------------
65 -- Procedures and Functions
66 ---------------------------------------------------------------------------
67
68 -- Added for Credit Memo Bug 3976894
69
70 PROCEDURE ON_ACCOUNT_CREDIT_MEMO
71 (
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
74 p_try_id IN NUMBER,
75 p_khr_id IN NUMBER,
76 p_kle_id IN NUMBER,
77 p_ipy_id IN NUMBER DEFAULT Okc_Api.G_MISS_NUM ,
78 p_credit_date IN DATE,
79 p_credit_amount IN NUMBER,
80 p_credit_sty_id IN NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 x_tai_id OUT NOCOPY NUMBER
85
86 );
87
88 PROCEDURE cancel_policy(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_ipyv_rec IN ipyv_rec_type,
95 x_ipyv_rec OUT NOCOPY ipyv_rec_type
96 );
97
98 --Bug#5955320
99 PROCEDURE cancel_create_policies(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_khr_id IN NUMBER,
106 p_cancellation_date IN DATE,
107 p_crx_code IN VARCHAR2 DEFAULT NULL, --+++++++++++++ Effective Dated Term Qte changes -- start +++++++++
108 p_transaction_id IN NUMBER,
109 x_ignore_flag OUT NOCOPY VARCHAR2 -- 3945995
110 );
111
112
113 --+++++++++++++ Effective Dated Term Qte changes -- start +++++++++
114 PROCEDURE check_claims(
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 x_clm_exist OUT NOCOPY VARCHAR2,
121 p_khr_id IN NUMBER,
122 p_trx_date IN DATE
123 );
124 --+++++++++++++ Effective Dated Term Qte changes -- End +++++++++
125
126
127 PROCEDURE delete_policy(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_ipyv_rec IN ipyv_rec_type,
134 x_ipyv_rec OUT NOCOPY ipyv_rec_type
135 );
136
137
138
139
140 PROCEDURE Inactivate_open_items(
141
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_contract_id IN NUMBER,
148 p_contract_line IN NUMBER,
149 p_policy_status IN VARCHAR2
150 );
151
152
153 PROCEDURE cancel_policies(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_contract_id IN NUMBER,
160 p_cancellation_date IN DATE
161 ,p_crx_code IN VARCHAR2 DEFAULT NULL);--++++++++ Effective Dated Term Qte changes +++++++++
162
163 PROCEDURE get_refund(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_policy_id IN NUMBER,
170 p_cancellation_date IN DATE DEFAULT NULL,--++ Eff Dated Term change +++ ---
171 p_crx_code IN VARCHAR2 DEFAULT NULL, ---+++ Eff Dated TErmination +++----
172 x_refund_amount OUT NOCOPY NUMBER
173 );
174
175 PROCEDURE pay_cust_refund(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_contract_id IN NUMBER,
182 p_contract_line IN NUMBER ,
183 p_cancellation_date IN DATE DEFAULT NULL, ---+++ Eff Dated TErmination +++----
184 p_crx_code IN VARCHAR2 DEFAULT NULL, ---+++ Eff Dated TErmination +++----
185
186 x_refund_amount OUT NOCOPY NUMBER
187 );
188
189 PROCEDURE insert_ap_request(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_tap_id IN NUMBER,
196 p_credit_amount IN NUMBER,
197 p_credit_sty_id IN NUMBER,
198 p_khr_id IN NUMBER ,
199 p_kle_id IN NUMBER,
200 p_invoice_date IN DATE,
201 p_trx_id IN NUMBER
202 );
203
204 PROCEDURE insert_ap_request(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_tap_id IN NUMBER,
211 p_credit_amount IN NUMBER,
212 p_credit_sty_id IN NUMBER,
213 p_khr_id IN NUMBER ,
214 p_kle_id IN NUMBER,
215 p_invoice_date IN DATE,
216 p_trx_id IN NUMBER,
217 p_vendor_site_id IN NUMBER ,
218 x_request_id OUT NOCOPY NUMBER
219 );
220
221
222
223 PROCEDURE OKL_INSURANCE_PARTY_MERGE(
224 p_entity_name IN VARCHAR2,
225 p_from_id IN NUMBER,
226 x_to_id OUT NOCOPY NUMBER,
227 p_from_fk_id IN NUMBER,
228 p_to_fk_id IN NUMBER,
229 p_parent_entity_name IN VARCHAR2,
230 p_batch_id IN NUMBER,
231 p_batch_party_id IN NUMBER,
232 x_return_status OUT NOCOPY VARCHAR2
233 );
234
235
236 PROCEDURE OKL_INSURANCE_PARTY_SITE_MERGE(
237 p_entity_name IN VARCHAR2,
238 p_from_id IN NUMBER,
239 x_to_id OUT NOCOPY NUMBER,
240 p_from_fk_id IN NUMBER,
241 p_to_fk_id IN NUMBER,
242 p_parent_entity_name IN VARCHAR2,
243 p_batch_id IN NUMBER,
244 p_batch_party_id IN NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2
246 );
247
248
249 PROCEDURE OKL_INSURANCE_AGENT_MERGE(
250 p_entity_name IN VARCHAR2,
251 p_from_id IN NUMBER,
252 x_to_id OUT NOCOPY NUMBER,
253 p_from_fk_id IN NUMBER,
254 p_to_fk_id IN NUMBER,
255 p_parent_entity_name IN VARCHAR2,
256 p_batch_id IN NUMBER,
257 p_batch_party_id IN NUMBER,
258 x_return_status OUT NOCOPY VARCHAR2
259 );
260
261
262
263
264
265 PROCEDURE OKL_INSURANCE_AGENT_SITE_MERGE(
266 p_entity_name IN VARCHAR2,
267 p_from_id IN NUMBER,
268 x_to_id OUT NOCOPY NUMBER,
269 p_from_fk_id IN NUMBER,
270 p_to_fk_id IN NUMBER,
271 p_parent_entity_name IN VARCHAR2,
272 p_batch_id IN NUMBER,
273 p_batch_party_id IN NUMBER,
274 x_return_status OUT NOCOPY VARCHAR2
275 );
276
277
278
279
280
281
282 END OKL_INSURANCE_POLICIES_PVT;