[Home] [Help]
PACKAGE: APPS.OZF_CLAIMS_INT_PVT
Source
1 PACKAGE OZF_Claims_Int_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvcins.pls 120.1.12020000.2 2012/08/08 09:37:59 ninarasi ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Claims_Int_PVT
7 -- Purpose
8 --
9 -- History
10 -- 02-Sep-2005 SSHIVALI R12: Multi-Org Changes
11 --
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17 -- Default number of records fetch per call
18 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
19 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- claims_int_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- interface_claim_id
27 -- object_version_number
28 -- last_update_date
29 -- last_updated_by
30 -- creation_date
31 -- created_by
32 -- last_update_login
33 -- request_id
34 -- program_application_id
35 -- program_update_date
36 -- program_id
37 -- created_from
38 -- batch_id
39 -- claim_id
40 -- claim_number
41 -- claim_type_id
42 -- claim_class
43 -- claim_date
44 -- due_date
45 -- owner_id
46 -- history_event
47 -- history_event_date
48 -- history_event_description
49 -- split_from_claim_id
50 -- duplicate_claim_id
51 -- split_date
52 -- root_claim_id
53 -- amount
54 -- amount_adjusted
55 -- amount_remaining
56 -- amount_settled
57 -- acctd_amount
58 -- acctd_amount_remaining
59 -- tax_amount
60 -- tax_code
61 -- tax_calculation_flag
62 -- currency_code
63 -- exchange_rate_type
64 -- exchange_rate_date
65 -- exchange_rate
66 -- set_of_books_id
67 -- original_claim_date
68 -- source_object_id
69 -- source_object_class
70 -- source_object_type_id
71 -- source_object_number
72 -- cust_account_id
73 -- cust_billto_acct_site_id
74 -- cust_shipto_acct_site_id
75 -- location_id
76 -- pay_related_account_flag
77 -- related_cust_account_id
78 -- related_site_use_id
79 -- relationship_type
80 -- vendor_id
81 -- vendor_site_id
82 -- reason_type
83 -- reason_code_id
84 -- task_template_group_id
85 -- status_code
86 -- user_status_id
87 -- sales_rep_id
88 -- collector_id
89 -- contact_id
90 -- broker_id
91 -- territory_id
92 -- customer_ref_date
93 -- customer_ref_number
94 -- assigned_to
95 -- receipt_id
96 -- receipt_number
97 -- doc_sequence_id
98 -- doc_sequence_value
99 -- gl_date
100 -- payment_method
101 -- voucher_id
102 -- voucher_number
103 -- payment_reference_id
104 -- payment_reference_number
105 -- payment_reference_date
106 -- payment_status
107 -- approved_flag
108 -- approved_date
109 -- approved_by
110 -- settled_date
111 -- settled_by
112 -- effective_date
113 -- custom_setup_id
114 -- task_id
115 -- country_id
116 -- order_type_id
117 -- comments
118 -- attribute_category
119 -- attribute1
120 -- attribute2
121 -- attribute3
122 -- attribute4
123 -- attribute5
124 -- attribute6
125 -- attribute7
126 -- attribute8
127 -- attribute9
128 -- attribute10
129 -- attribute11
130 -- attribute12
131 -- attribute13
132 -- attribute14
133 -- attribute15
134 -- deduction_attribute_category
135 -- deduction_attribute1
136 -- deduction_attribute2
137 -- deduction_attribute3
138 -- deduction_attribute4
139 -- deduction_attribute5
140 -- deduction_attribute6
141 -- deduction_attribute7
142 -- deduction_attribute8
143 -- deduction_attribute9
144 -- deduction_attribute10
145 -- deduction_attribute11
146 -- deduction_attribute12
147 -- deduction_attribute13
148 -- deduction_attribute14
149 -- deduction_attribute15
150 -- org_id
151 -- customer_reason
152 -- ship_to_cust_account_id
153 --
154 -- Required
155 --
156 -- Defaults
157 --
158 -- End of Comments
159 --===================================================================
160 TYPE claims_int_rec_type IS RECORD
161 (
162 interface_claim_id NUMBER,
163 object_version_number NUMBER,
164 last_update_date DATE,
165 last_updated_by NUMBER,
166 creation_date DATE,
167 created_by NUMBER,
168 last_update_login NUMBER,
169 request_id NUMBER,
170 program_application_id NUMBER,
171 program_update_date DATE,
172 program_id NUMBER,
173 created_from VARCHAR2(30),
174 batch_id NUMBER,
175 claim_id NUMBER,
176 claim_number VARCHAR2(30),
177 claim_type_id NUMBER,
178 claim_class VARCHAR2(30),
179 claim_date DATE,
180 due_date DATE,
181 owner_id NUMBER,
182 history_event VARCHAR2(30),
183 history_event_date DATE,
184 history_event_description VARCHAR2(2000),
185 split_from_claim_id NUMBER,
186 duplicate_claim_id NUMBER,
187 split_date DATE,
188 root_claim_id NUMBER,
189 amount NUMBER,
190 amount_adjusted NUMBER,
191 amount_remaining NUMBER,
192 amount_settled NUMBER,
193 acctd_amount NUMBER,
194 acctd_amount_remaining NUMBER,
195 tax_amount NUMBER,
196 tax_code VARCHAR2(50),
197 tax_calculation_flag VARCHAR2(1),
198 currency_code VARCHAR2(15),
199 exchange_rate_type VARCHAR2(30),
200 exchange_rate_date DATE,
201 exchange_rate NUMBER,
202 set_of_books_id NUMBER,
203 original_claim_date DATE,
204 source_object_id NUMBER,
205 source_object_class VARCHAR2(15),
206 source_object_type_id NUMBER,
207 source_object_number VARCHAR2(30),
208 cust_account_id NUMBER,
209 cust_billto_acct_site_id NUMBER,
210 cust_shipto_acct_site_id NUMBER,
211 location_id NUMBER,
212 pay_related_account_flag VARCHAR2(1),
213 related_cust_account_id NUMBER,
214 related_site_use_id NUMBER,
215 relationship_type VARCHAR2(30),
216 vendor_id NUMBER,
217 vendor_site_id NUMBER,
218 reason_type VARCHAR2(30),
219 reason_code_id NUMBER,
220 task_template_group_id NUMBER,
221 status_code VARCHAR2(30),
222 user_status_id NUMBER,
223 sales_rep_id NUMBER,
224 collector_id NUMBER,
225 contact_id NUMBER,
226 broker_id NUMBER,
227 territory_id NUMBER,
228 customer_ref_date DATE,
229 customer_ref_number VARCHAR2(100), --fix for bug 13498038
230 assigned_to NUMBER,
231 receipt_id NUMBER,
232 receipt_number VARCHAR2(30),
233 doc_sequence_id NUMBER,
234 doc_sequence_value NUMBER,
235 gl_date DATE,
236 payment_method VARCHAR2(15),
237 voucher_id NUMBER,
238 voucher_number VARCHAR2(30),
239 payment_reference_id NUMBER,
240 payment_reference_number VARCHAR2(15),
241 payment_reference_date DATE,
242 payment_status VARCHAR2(10),
243 approved_flag VARCHAR2(1),
244 approved_date DATE,
245 approved_by NUMBER,
246 settled_date DATE,
247 settled_by NUMBER,
248 effective_date DATE,
249 custom_setup_id NUMBER,
250 task_id NUMBER,
251 country_id NUMBER,
252 order_type_id NUMBER,
253 comments VARCHAR2(2000),
254 attribute_category VARCHAR2(30),
255 attribute1 VARCHAR2(150),
256 attribute2 VARCHAR2(150),
257 attribute3 VARCHAR2(150),
258 attribute4 VARCHAR2(150),
259 attribute5 VARCHAR2(150),
260 attribute6 VARCHAR2(150),
261 attribute7 VARCHAR2(150),
262 attribute8 VARCHAR2(150),
263 attribute9 VARCHAR2(150),
264 attribute10 VARCHAR2(150),
265 attribute11 VARCHAR2(150),
266 attribute12 VARCHAR2(150),
267 attribute13 VARCHAR2(150),
268 attribute14 VARCHAR2(150),
269 attribute15 VARCHAR2(150),
270 deduction_attribute_category VARCHAR2(30) ,
271 deduction_attribute1 VARCHAR2(150),
272 deduction_attribute2 VARCHAR2(150),
273 deduction_attribute3 VARCHAR2(150),
274 deduction_attribute4 VARCHAR2(150),
275 deduction_attribute5 VARCHAR2(150),
276 deduction_attribute6 VARCHAR2(150),
277 deduction_attribute7 VARCHAR2(150),
278 deduction_attribute8 VARCHAR2(150),
279 deduction_attribute9 VARCHAR2(150),
280 deduction_attribute10 VARCHAR2(150),
281 deduction_attribute11 VARCHAR2(150),
282 deduction_attribute12 VARCHAR2(150),
283 deduction_attribute13 VARCHAR2(150),
284 deduction_attribute14 VARCHAR2(150),
285 deduction_attribute15 VARCHAR2(150),
286 org_id NUMBER,
287 customer_reason VARCHAR2(30),
288 ship_to_cust_account_id NUMBER
289 );
290
291 g_miss_claims_int_rec claims_int_rec_type;
292 TYPE claims_int_tbl_type IS TABLE OF claims_int_rec_type
293 INDEX BY BINARY_INTEGER;
294 g_miss_claims_int_tbl claims_int_tbl_type;
295
296 -- ===========================================================================
297 -- Start of Comments
298 -- ===========================================================================
299 -- API Name
300 -- Create_Claims_Int
301 -- Type
302 -- Private
303 -- Pre-Req
304 --
305 -- Parameters
306 --
307 -- IN
308 -- p_api_version_number IN NUMBER
309 -- Required
310 -- p_init_msg_list IN VARCHAR2
311 -- Optional Default = FND_API_G_FALSE
312 -- p_commit IN VARCHAR2
313 -- Optional Default = FND_API.G_FALSE
314 -- p_validation_level IN NUMBER
315 -- Optional Default = FND_API.G_VALID_LEVEL_FULL
316 -- p_claims_int_rec IN claims_int_rec_type
317 -- Required
318 --
319 -- OUT
320 -- x_return_status OUT VARCHAR2
321 -- x_msg_count OUT NUMBER
322 -- x_msg_data OUT VARCHAR2
323 -- Version : Current version 1.0
324 -- End of Comments
325 -- ===========================================================================
326 --
327 PROCEDURE Create_Claims_Int(
328 p_api_version_number IN NUMBER,
329 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
330 p_commit IN VARCHAR2 := FND_API.G_FALSE,
331 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336
337 p_claims_int_rec IN claims_int_rec_type := g_miss_claims_int_rec,
338 x_interface_claim_id OUT NOCOPY NUMBER
339 );
340
341 -- ===========================================================================
342 -- Start of Comments
343 -- ===========================================================================
344 -- API Name
345 -- Update_Claims_Int
346 -- Type
347 -- Private
348 -- Pre-Req
349 --
350 -- Parameters
351 --
352 -- IN
353 -- p_api_version_number IN NUMBER
354 -- Required
355 -- p_init_msg_list IN VARCHAR2
356 -- Optional Default = FND_API_G_FALSE
357 -- p_commit IN VARCHAR2
358 -- Optional Default = FND_API.G_FALSE
359 -- p_validation_level IN NUMBER
360 -- Optional Default = FND_API.G_VALID_LEVEL_FULL
361 -- p_claims_int_rec IN claims_int_rec_type
362 -- Required
363 --
364 -- OUT
365 -- x_return_status OUT VARCHAR2
366 -- x_msg_count OUT NUMBER
367 -- x_msg_data OUT VARCHAR2
368 -- Version : Current version 1.0
369 --
370 -- End of Comments
371 -- ===========================================================================
372 --
373 PROCEDURE Update_Claims_Int(
374 p_api_version_number IN NUMBER,
375 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376 p_commit IN VARCHAR2 := FND_API.G_FALSE,
377 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378
379 x_return_status OUT NOCOPY VARCHAR2,
380 x_msg_count OUT NOCOPY NUMBER,
381 x_msg_data OUT NOCOPY VARCHAR2,
382
383 p_claims_int_rec IN claims_int_rec_type,
384 x_object_version_number OUT NOCOPY NUMBER
385 );
386
387 -- ===========================================================================
388 -- Start of Comments
389 -- ===========================================================================
390 -- API Name
391 -- Delete_Claims_Int
392 -- Type
393 -- Private
394 -- Pre-Req
395 --
396 -- Parameters
397 --
398 -- IN
399 -- p_api_version_number IN NUMBER
400 -- Required
401 -- p_init_msg_list IN VARCHAR2
402 -- Optional Default = FND_API_G_FALSE
403 -- p_commit IN VARCHAR2
404 -- Optional Default = FND_API.G_FALSE
405 -- p_validation_level IN NUMBER
409 -- Optional Default = NULL
406 -- Optional Default = FND_API.G_VALID_LEVEL_FULL
407 -- p_INTERFACE_CLAIM_ID IN NUMBER
408 -- p_object_version_number IN NUMBER
410 --
411 -- OUT
412 -- x_return_status OUT VARCHAR2
413 -- x_msg_count OUT NUMBER
414 -- x_msg_data OUT VARCHAR2
415 -- Version : Current version 1.0
416 -- End of Comments
417 -- ===========================================================================
418 --
419 PROCEDURE Delete_Claims_Int(
420 p_api_version_number IN NUMBER,
421 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422 p_commit IN VARCHAR2 := FND_API.G_FALSE,
423 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
424 x_return_status OUT NOCOPY VARCHAR2,
425 x_msg_count OUT NOCOPY NUMBER,
426 x_msg_data OUT NOCOPY VARCHAR2,
427 p_interface_claim_id IN NUMBER,
428 p_object_version_number IN NUMBER
429 );
430
431 -- ============================================================================
432 -- Start of Comments
433 -- ============================================================================
434 -- API Name
435 -- Lock_Claims_Int
436 -- Type
437 -- Private
438 -- Pre-Req
439 --
440 -- Parameters
441 --
442 -- IN
443 -- p_api_version_number IN NUMBER
444 -- Required
445 -- p_init_msg_list IN VARCHAR2
446 -- Optional Default = FND_API_G_FALSE
447 -- p_commit IN VARCHAR2
448 -- Optional Default = FND_API.G_FALSE
449 -- p_validation_level IN NUMBER
450 -- Optional Default = FND_API.G_VALID_LEVEL_FULL
451 -- p_claims_int_rec IN claims_int_rec_type
452 -- Required
453 --
454 -- OUT
455 -- x_return_status OUT VARCHAR2
456 -- x_msg_count OUT NUMBER
457 -- x_msg_data OUT VARCHAR2
458 -- Version : Current version 1.0
459 --
460 -- End of Comments
461 -- ============================================================================
462 --
463
464 PROCEDURE Lock_Claims_Int(
465 p_api_version_number IN NUMBER,
466 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
467
468 x_return_status OUT NOCOPY VARCHAR2,
469 x_msg_count OUT NOCOPY NUMBER,
470 x_msg_data OUT NOCOPY VARCHAR2,
471
472 p_interface_claim_id IN NUMBER,
473 p_object_version IN NUMBER
474 );
475
476 -- Start of Comments
477 --
478 -- validation procedures
479 --
480 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
481 -- For create: G_CREATE, for update: G_UPDATE
482 -- End of Comments
483
484 PROCEDURE Validate_claims_int(
485 p_api_version_number IN NUMBER,
486 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
487 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
488 p_claims_int_rec IN claims_int_rec_type,
489 x_return_status OUT NOCOPY VARCHAR2,
490 x_msg_count OUT NOCOPY NUMBER,
491 x_msg_data OUT NOCOPY VARCHAR2
492 );
493
494 -- Start of Comments
495 --
496 -- validation procedures
497 --
498 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
499 -- For create: G_CREATE, for update: G_UPDATE
500 -- End of Comments
501
502 PROCEDURE Check_claims_int_Items (
503 P_claims_int_rec IN claims_int_rec_type,
504 p_validation_mode IN VARCHAR2,
505 x_return_status OUT NOCOPY VARCHAR2
506 );
507
508 -- Start of Comments
509 --
510 -- Record level validation procedures
511 --
512 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
513 -- For create: G_CREATE, for update: G_UPDATE
514 -- End of Comments
515
516 PROCEDURE Validate_claims_int_rec(
517 p_api_version_number IN NUMBER,
518 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
519 x_return_status OUT NOCOPY VARCHAR2,
520 x_msg_count OUT NOCOPY NUMBER,
521 x_msg_data OUT NOCOPY VARCHAR2,
522 p_claims_int_rec IN claims_int_rec_type
523 );
524
525 -- ==========================================================================
526 -- Start of Comments
527 -- ==========================================================================
528 -- API Name
529 -- Start_Replicate
530 -- Type
531 -- Private
532 -- Pre-Req
533 --
534 -- Parameters
535 --
536 -- IN
537 -- ERRBUF
538 -- RETCODE
539 -- End of Comments
540 -- ==========================================================================
541 --
542 PROCEDURE Start_Replicate (
543 ERRBUF OUT NOCOPY VARCHAR2,
544 RETCODE OUT NOCOPY NUMBER,
545 p_org_id IN NUMBER DEFAULT NULL
546 );
547
548 -- ==========================================================================
549 -- ==========================================================================
550 -- Start of Comments
551 -- ==========================================================================
552 -- API Name
553 -- Purge_Claims
554 -- Type
555 -- Private
556 -- Pre-Req
557 --
558 -- Parameters
559 --
560 -- IN
561 -- ERRBUF
562 -- RETCODE
563 -- End of Comments
564 -- ==========================================================================
565 --
566 PROCEDURE Purge_Claims (
567 ERRBUF OUT NOCOPY VARCHAR2,
568 RETCODE OUT NOCOPY NUMBER,
569 p_org_id IN NUMBER DEFAULT NULL
570 );
571
572 END OZF_Claims_Int_PVT;