[Home] [Help]
PACKAGE: APPS.OZF_CLAIM_PVT
Source
1 PACKAGE OZF_CLAIM_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvclas.pls 120.6.12020000.2 2012/08/08 09:49:21 ninarasi ship $ */
3
4
5 -- Default number of records fetch per call
6 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
7
8 --===================================================================
9 -- Start of Comments
10 -- -------------------------------------------------------
11 -- Record name
12 -- claim_rec_type
13 -- -------------------------------------------------------
14 -- Parameters:
15 -- claim_id
16 -- object_version_number
17 -- last_update_date
18 -- last_updated_by
19 -- creation_date
20 -- created_by
21 -- last_update_login
22 -- request_id
23 -- program_application_id
24 -- program_update_date
25 -- program_id
26 -- created_from
27 -- batch_id
28 -- claim_number
29 -- claim_type_id
30 -- claim_class
31 -- claim_date
32 -- due_date
33 -- owner_id
34 -- history_event
35 -- history_event_date
36 -- history_event_description
37 -- split_from_claim_id
38 -- duplicate_claim_id
39 -- split_date
40 -- root_claim_id
41 -- amount
42 -- amount_adjusted
43 -- amount_remaining
44 -- amount_settled
45 -- acctd_amount
46 -- acctd_amount_remaining
47 -- acctd_amount_adjusted
48 -- acctd_amount_settled
49 -- tax_amount
50 -- tax_code
51 -- tax_calculation_flag
52 -- currency_code
53 -- exchange_rate_type
54 -- exchange_rate_date
55 -- exchange_rate
56 -- set_of_books_id
57 -- original_claim_date
58 -- source_object_id
59 -- source_object_class
60 -- source_object_type_id
61 -- source_object_number
62 -- cust_account_id
63 -- cust_billto_acct_site_id
64 -- cust_shipto_acct_site_id
65 -- location_id
66 -- pay_related_account_flag
67 -- related_cust_account_id
68 -- related_site_use_id
69 -- relationship_type
70 -- vendor_id
71 -- vendor_site_id
72 -- reason_type
73 -- reason_code_id
74 -- task_template_group_id
75 -- status_code
76 -- user_status_id
77 -- sales_rep_id
78 -- collector_id
79 -- contact_id
80 -- broker_id
81 -- territory_id
82 -- customer_ref_date
83 -- customer_ref_number
84 -- assigned_to
85 -- receipt_id
86 -- receipt_number
87 -- doc_sequence_id
88 -- doc_sequence_value
89 -- gl_date
90 -- payment_method
91 -- voucher_id
92 -- voucher_number
93 -- payment_reference_id
94 -- payment_reference_number
95 -- payment_reference_date
96 -- payment_status
97 -- approved_flag
98 -- approved_date
99 -- approved_by
100 -- settled_date
101 -- settled_by
102 -- effective_date
103 -- custom_setup_id
104 -- task_id
105 -- country_id
106 -- order_type_id
107 -- comments
108 -- attribute_category
109 -- attribute1
110 -- attribute2
111 -- attribute3
112 -- attribute4
113 -- attribute5
114 -- attribute6
115 -- attribute7
116 -- attribute8
117 -- attribute9
118 -- attribute10
119 -- attribute11
120 -- attribute12
121 -- attribute13
122 -- attribute14
123 -- attribute15
124 -- deduction_attribute_category
125 -- deduction_attribute1
126 -- deduction_attribute2
127 -- deduction_attribute3
128 -- deduction_attribute4
129 -- deduction_attribute5
130 -- deduction_attribute6
131 -- deduction_attribute7
132 -- deduction_attribute8
133 -- deduction_attribute9
134 -- deduction_attribute10
135 -- deduction_attribute11
136 -- deduction_attribute12
137 -- deduction_attribute13
138 -- deduction_attribute14
139 -- deduction_attribute15
140 -- org_id
141 -- legal_entity_id
142 -- write_off_flag
143 -- write_off_threshold_amount
144 -- under_write_off_threshold
145 -- customer_reason
146 -- ship_to_cust_account_id
147 -- amount_applied --Subsequent Receipt Application changes
148 -- applied_receipt_id --Subsequent Receipt Application changes
149 -- applied_receipt_number --Subsequent Receipt Application changes
150 -- wo_rec_trx_id -- Write off Activity Id
151 -- group_claim_id
152 -- appr_wf_item_key
153 -- cstl_wf_item_key
154 -- batch_type
155 -- close_status_id
156 -- open_status_id
157 -- pre_auth_deduction_number -- For Rule Based Settlement
158 -- pre_auth_deduction_normalized -- For Rule Based Settlement
159 -- offer_id -- For Rule Based Settlement
160 -- settled_from -- For Rule Based Settlement
161 -- approval_in_prog -- For Rule Based Settlement
162 -- Required
163 --
164 -- Defaults
165 --
166 -- Note: This is automatic generated record definition, it includes all columns
167 -- defined in the table, developer must manually add or delete some of the attributes.
168 --
169 -- Changed by : Uday Poluri Date:29-05-2003
170 -- 1. Adding new paramters for Auto Write-off of DED/OPM's implementation.
171 -- 2. Removed G_MISS_XXX initialization.
172 -- Changed by : Sandhya Amaresh Date:17-11-2004
173 -- 1. Changed the length of payment_reference_number from varchar2(15) to varchar2(30)
174 -- Changed by : Kishore Dhulipati Date:28-06-2005
175 -- 1. Adding new field for legal_entity_id.
176 -- End of Comments
177 --===================================================================
178 TYPE claim_rec_type IS RECORD
179 (
180 claim_id NUMBER,
181 object_version_number NUMBER,
182 last_update_date DATE,
183 last_updated_by NUMBER,
184 creation_date DATE,
185 created_by NUMBER,
186 last_update_login NUMBER,
187 request_id NUMBER,
188 program_application_id NUMBER,
189 program_update_date DATE,
190 program_id NUMBER,
191 created_from VARCHAR2(30),
192 batch_id NUMBER,
193 claim_number VARCHAR2(30),
194 claim_type_id NUMBER,
195 claim_class VARCHAR2(30),
196 claim_date DATE,
197 due_date DATE,
198 owner_id NUMBER,
199 history_event VARCHAR2(30),
200 history_event_date DATE,
201 history_event_description VARCHAR2(2000),
202 split_from_claim_id NUMBER,
203 duplicate_claim_id NUMBER,
204 split_date DATE,
205 root_claim_id NUMBER,
206 amount NUMBER,
207 amount_adjusted NUMBER,
208 amount_remaining NUMBER,
209 amount_settled NUMBER,
210 acctd_amount NUMBER,
211 acctd_amount_remaining NUMBER,
212 acctd_amount_adjusted NUMBER,
213 acctd_amount_settled NUMBER,
214 tax_amount NUMBER,
215 tax_code VARCHAR2(50),
216 tax_calculation_flag VARCHAR2(1),
217 currency_code VARCHAR2(15),
218 exchange_rate_type VARCHAR2(30),
219 exchange_rate_date DATE,
220 exchange_rate NUMBER,
221 set_of_books_id NUMBER,
222 original_claim_date DATE,
223 source_object_id NUMBER,
224 source_object_class VARCHAR2(15),
225 source_object_type_id NUMBER,
226 source_object_number VARCHAR2(30),
227 cust_account_id NUMBER,
228 cust_billto_acct_site_id NUMBER,
229 cust_shipto_acct_site_id NUMBER,
230 location_id NUMBER,
231 pay_related_account_flag VARCHAR2(1),
232 related_cust_account_id NUMBER,
233 related_site_use_id NUMBER,
234 relationship_type VARCHAR2(30),
235 vendor_id NUMBER,
236 vendor_site_id NUMBER,
237 reason_type VARCHAR2(30),
238 reason_code_id NUMBER,
239 task_template_group_id NUMBER,
240 status_code VARCHAR2(30),
241 user_status_id NUMBER,
242 sales_rep_id NUMBER,
243 collector_id NUMBER,
244 contact_id NUMBER,
245 broker_id NUMBER,
246 territory_id NUMBER,
247 customer_ref_date DATE,
248 customer_ref_number VARCHAR2(100), --fix for bug 13498038
249 assigned_to NUMBER,
250 receipt_id NUMBER,
251 receipt_number VARCHAR2(30),
252 doc_sequence_id NUMBER,
253 doc_sequence_value NUMBER,
254 gl_date DATE,
255 payment_method VARCHAR2(30),
256 voucher_id NUMBER,
257 voucher_number VARCHAR2(30),
258 payment_reference_id NUMBER,
259 payment_reference_number VARCHAR2(30),
260 payment_reference_date DATE,
261 payment_status VARCHAR2(30),
262 approved_flag VARCHAR2(1),
263 approved_date DATE,
264 approved_by NUMBER,
265 settled_date DATE,
266 settled_by NUMBER,
267 effective_date DATE,
268 custom_setup_id NUMBER,
269 task_id NUMBER,
270 country_id NUMBER,
271 order_type_id NUMBER,
272 comments VARCHAR2(2000),
273 attribute_category VARCHAR2(30),
274 attribute1 VARCHAR2(150),
275 attribute2 VARCHAR2(150),
276 attribute3 VARCHAR2(150),
277 attribute4 VARCHAR2(150),
278 attribute5 VARCHAR2(150),
279 attribute6 VARCHAR2(150),
280 attribute7 VARCHAR2(150),
281 attribute8 VARCHAR2(150),
282 attribute9 VARCHAR2(150),
283 attribute10 VARCHAR2(150),
284 attribute11 VARCHAR2(150),
285 attribute12 VARCHAR2(150),
286 attribute13 VARCHAR2(150),
287 attribute14 VARCHAR2(150),
288 attribute15 VARCHAR2(150),
289 deduction_attribute_category VARCHAR2(30),
290 deduction_attribute1 VARCHAR2(150),
291 deduction_attribute2 VARCHAR2(150),
292 deduction_attribute3 VARCHAR2(150),
293 deduction_attribute4 VARCHAR2(150),
294 deduction_attribute5 VARCHAR2(150),
295 deduction_attribute6 VARCHAR2(150),
296 deduction_attribute7 VARCHAR2(150),
297 deduction_attribute8 VARCHAR2(150),
298 deduction_attribute9 VARCHAR2(150),
299 deduction_attribute10 VARCHAR2(150),
300 deduction_attribute11 VARCHAR2(150),
301 deduction_attribute12 VARCHAR2(150),
302 deduction_attribute13 VARCHAR2(150),
303 deduction_attribute14 VARCHAR2(150),
304 deduction_attribute15 VARCHAR2(150),
305 org_id NUMBER,
306 legal_entity_id NUMBER, -- added by kishore.
307 write_off_flag VARCHAR2(1),
308 write_off_threshold_amount NUMBER,
309 under_write_off_threshold VARCHAR2(5),
310 customer_reason VARCHAR2(30),
311 ship_to_cust_account_id NUMBER, -- added by uday
312 amount_applied NUMBER, -- Subsequent Receipt application changes
313 applied_receipt_id NUMBER, -- Subsequent Receipt application changes
314 applied_receipt_number VARCHAR2(30), -- Subsequent Receipt application changes
315 wo_rec_trx_id NUMBER,
316 group_claim_id NUMBER,
317 appr_wf_item_key VARCHAR2(240),
318 cstl_wf_item_key VARCHAR2(240),
319 batch_type VARCHAR2(30),
320 tax_action VARCHAR2(30),
321 close_status_id NUMBER,
322 open_status_id NUMBER,
323 pre_auth_deduction_number VARCHAR2(30), -- Added for Rule Based Settlement
324 pre_auth_deduction_normalized VARCHAR2(30), -- Added for Rule Based Settlement
325 offer_id NUMBER, -- Added for Rule Based Settlement
326 settled_from VARCHAR2(15), -- Added for Rule Based Settlement
327 approval_in_prog VARCHAR2(1) -- Added for Rule Based Settlement
328 );
329
330 g_miss_claim_rec claim_rec_type;
331 TYPE claim_tbl_type IS TABLE OF claim_rec_type INDEX BY BINARY_INTEGER;
332 g_miss_claim_tbl claim_tbl_type;
333
334
335 ---------------------------------------------------------------------
336 -- PROCEDURE
337 -- Create_Claim
338 --
339 -- PURPOSE
340 -- Create a claim.
341 --
342 -- PARAMETERS
343 -- p_claim : the new record to be inserted
344 -- x_claim_id : return the claim_id of the new reason code
345 --
346 -- NOTES
347 -- 1. object_version_number will be set to 1.
348 -- 2. If claim_id is passed in, the uniqueness will be checked.
349 -- Raise exception in case of duplicates.
350 -- 3. If claim_id is not passed in, generate a unique one from
351 -- the sequence.
352 ---------------------------------------------------------------------
353 PROCEDURE Create_Claim (
354 p_api_version IN NUMBER
355 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358
359 ,x_return_status OUT NOCOPY VARCHAR2
360 ,x_msg_data OUT NOCOPY VARCHAR2
361 ,x_msg_count OUT NOCOPY NUMBER
362
363 ,p_claim IN claim_rec_type
364 ,x_claim_id OUT NOCOPY NUMBER
365 );
366
367 ---------------------------------------------------------------------
368 -- PROCEDURE
369 -- Update_Claim
370 --
371 -- PURPOSE
372 -- Update a claim code.
373 --
374 -- PARAMETERS
375 -- p_update_claim : the record with new items.
376 --
377 -- NOTES
378 -- 1. Raise exception if the object_version_number doesn't match.
379 ----------------------------------------------------------------------
380 PROCEDURE Update_Claim (
381 p_api_version IN NUMBER
382 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
383 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
384 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
385
386 ,x_return_status OUT NOCOPY VARCHAR2
387 ,x_msg_data OUT NOCOPY VARCHAR2
388 ,x_msg_count OUT NOCOPY NUMBER
389
390 ,p_claim IN claim_rec_type
391 ,p_event IN VARCHAR2
392 ,p_mode IN VARCHAR2 := OZF_claim_Utility_pvt.G_AUTO_MODE
393 ,x_object_version_number OUT NOCOPY NUMBER
394 );
395 ---------------------------------------------------------------------
396 -- PROCEDURE
397 -- Delete_Claim
398 --
399 -- PURPOSE
400 -- Update a claim code.
401 --
402 -- PARAMETERS
403 -- p_object_id : the record with new items.
404 -- p_object_version_number : object version number
405 --
406 -- NOTES
407 -- 1. Raise exception if the object_version_number doesn't match.
408 ----------------------------------------------------------------------
409 PROCEDURE Delete_Claim (
410 p_api_version_number IN NUMBER
411 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
413 ,p_object_id IN NUMBER
414 ,p_object_version_number IN NUMBER
415 ,x_return_status OUT NOCOPY VARCHAR2
416 ,x_msg_count OUT NOCOPY NUMBER
417 ,x_msg_data OUT NOCOPY VARCHAR2
418 );
419
420 ---------------------------------------------------------------------
421 -- PROCEDURE
422 -- Validate_Claim
423 --
424 -- PURPOSE
425 -- Validate a claim code record.
426 --
427 -- PARAMETERS
428 -- p_validate_claim : the claim code record to be validated
429 --
430 -- NOTES
431 --
432 ----------------------------------------------------------------------
433 PROCEDURE Validate_Claim (
434 p_api_version IN NUMBER
435 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
436 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
437 ,x_return_status OUT NOCOPY VARCHAR2
438 ,x_msg_count OUT NOCOPY NUMBER
439 ,x_msg_data OUT NOCOPY VARCHAR2
440 ,p_claim IN claim_rec_type
441 );
442
443 ---------------------------------------------------------------------
444 -- PROCEDURE
445 -- Check_Claim_Common_Element
446 --
447 -- PURPOSE
448 -- The precedure does validations on claim elements that was not enforced by UI.
449 --
450 -- PARAMETERS
451 -- p_validate_claim : the claim code record to be validated
452 --
453 -- NOTES
454 --
455 ----------------------------------------------------------------------
456 PROCEDURE Check_Claim_Common_Element (
457 p_api_version IN NUMBER
458 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
459 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
460 ,x_return_status OUT NOCOPY VARCHAR2
461 ,x_msg_count OUT NOCOPY NUMBER
462 ,x_msg_data OUT NOCOPY VARCHAR2
463 ,p_claim IN claim_rec_type
464 ,x_claim OUT NOCOPY claim_rec_type
465 ,p_mode IN VARCHAR2 := OZF_claim_Utility_pvt.G_AUTO_MODE
466 );
467
468 ---------------------------------------------------------------------
469 -- PROCEDURE
470 -- Check_Claim_Items
471 --
472 -- PURPOSE
473 -- Perform the item level checking including unique keys,
474 -- required columns, foreign keys, , flag items, domain constraints.
475 --
476 -- PARAMETERS
477 -- p_claim_rec : the record to be validated
478 ---------------------------------------------------------------------
479 PROCEDURE Check_Claim_Items(
480 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
481 ,p_claim_rec IN claim_rec_type
482 ,x_return_status OUT NOCOPY VARCHAR2
483 );
484
485 ---------------------------------------------------------------------
486 -- PROCEDURE
487 -- Complete_Claim_Rec
488 --
489 -- PURPOSE
490 -- For Update_Claim, some attributes may be passed in as
491 -- FND_API.g_miss_char/num/date if the user doesn't want to
492 -- update those attributes. This procedure will replace the
493 -- "g_miss" attributes with current database values.
494 --
495 -- PARAMETERS
496 -- p_claim_rec : the record which may contain attributes as
497 -- FND_API.g_miss_char/num/date
498 -- x_complete_rec: the complete record after all "g_miss" items
499 -- have been replaced by current database values
500 ---------------------------------------------------------------------
501 PROCEDURE Complete_Claim_Rec (
502 p_claim_rec IN claim_rec_type
503 ,x_complete_rec OUT NOCOPY claim_rec_type
504 ,x_return_status OUT NOCOPY varchar2
505 );
506
507 ---------------------------------------------------------------------
508 -- PROCEDURE
509 -- Get_System_Status
510 --
511 -- PURPOSE
512 -- This procedure maps a user_status_id to a system status.
513 --
514 -- PARAMETERS
515 -- p_user_status_id: Id of the status defined by a user.
516 -- p_status_type:
517 -- x_system_status: the system status corresponding a user status id
518 ---------------------------------------------------------------------
519 PROCEDURE Get_System_Status( p_user_status_id IN NUMBER,
520 p_status_type IN VARCHAR2,
521 x_system_status OUT NOCOPY VARCHAR,
522 x_msg_data OUT NOCOPY VARCHAR2,
523 x_msg_count OUT NOCOPY NUMBER,
524 x_return_status OUT NOCOPY VARCHAR2
525 );
526
527 ---------------------------------------------------------------------
528 -- PROCEDURE
529 -- Create_Claim_History
530 --
531 -- PURPOSE
532 -- This procedure create a history record of a claim if needed.
533 --
534 -- PARAMETERS
535 -- p_user_status_id: Id of the status defined by a user.
536 -- p_status_type:
537 -- x_system_status: the system status corresponding a user status id
538 ---------------------------------------------------------------------
539 PROCEDURE Create_Claim_History (
540 p_api_version IN NUMBER
541 ,p_init_msg_list IN VARCHAR2
542 ,p_commit IN VARCHAR2
543 ,p_validation_level IN NUMBER
544
545 ,x_return_status OUT NOCOPY VARCHAR2
546 ,x_msg_data OUT NOCOPY VARCHAR2
547 ,x_msg_count OUT NOCOPY NUMBER
548 ,p_claim IN claim_rec_type
549 ,p_event IN VARCHAR2
550 ,x_need_to_create OUT NOCOPY VARCHAR2
551 ,x_claim_history_id OUT NOCOPY NUMBER
552 );
553
554 ---------------------------------------------------------------------
555 -- PROCEDURE
556 -- Validate_Delete_Claim
557 --
558 -- PURPOSE
559 -- This procedure identify the list of deletable or non deletalbe dependent object
560 -- for a claim.
561 --
562 -- PARAMETERS
563 -- p_object_id IN NUMBER,
564 -- p_object_version_number IN NUMBER,
565 -- x_dependent_object_tbl OUT ozf_utility_pvt.dependent_objects_tbl_type
566 ---------------------------------------------------------------------
567 PROCEDURE Validate_Delete_Claim (
568 p_api_version_number IN NUMBER,
569 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
570 p_commit IN VARCHAR2 := FND_API.G_FALSE,
571 p_object_id IN NUMBER,
572 p_object_version_number IN NUMBER,
573 x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type,
574 x_return_status OUT NOCOPY VARCHAR2,
575 x_msg_count OUT NOCOPY NUMBER,
576 x_msg_data OUT NOCOPY VARCHAR2
577 );
578
579 ---------------------------------------------------------------------
580 -- PROCEDURE
581 -- Create_Claim_tbl
582 --
583 -- PURPOSE
584 -- Create mutiple claims at one time.
585 --
586 -- PARAMETERS
587 -- p_claim_tbl : the new record to be inserted
588 --
589 -- NOTES: for all the claims to be created
590 -- 1. object_version_number will be set to 1.
591 -- 2. If claim_number is passed in, the uniqueness will be checked.
592 -- Raise exception in case of duplicates.
593 ---------------------------------------------------------------------
594 PROCEDURE Create_Claim_tbl (
595 p_api_version IN NUMBER
596 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
597 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
598 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
599
600 ,x_return_status OUT NOCOPY VARCHAR2
601 ,x_msg_data OUT NOCOPY VARCHAR2
602 ,x_msg_count OUT NOCOPY NUMBER
603 ,p_claim_tbl IN claim_tbl_type
604 ,x_error_index OUT NOCOPY NUMBER
605 );
606
607
608 -- ------------------------------------------------------------------
609 -- Bug : 2732290
610 -- Changed by: (Uday Poluri) Date:03-JUN-2003
611 -- Comments: add new procedure to update claims from Claim Summary Screen.
612 -- ------------------------------------------------------------------
613 ---------------------------------------------------------------------
614 -- PROCEDURE
615 -- Update_Claim_tbl
616 --
617 -- PURPOSE
618 -- Update mutiple claims at one time
619 --
620 -- PARAMETERS
621 -- p_claim_tbl : the new record to be inserted
622 --
623 -- NOTES: for all the claims to be created
624 -- 1. object_version_number will be set to 1.
625 -- 2. If claim_number is passed in, the uniqueness will be checked.
626 -- Raise exception in case of duplicates.
627 ---------------------------------------------------------------------
628 PROCEDURE Update_Claim_tbl (
629 p_api_version IN NUMBER
630 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
631 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
632 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
633
634 ,x_return_status OUT NOCOPY VARCHAR2
635 ,x_msg_data OUT NOCOPY VARCHAR2
636 ,x_msg_count OUT NOCOPY NUMBER
637 ,p_claim_tbl IN claim_tbl_type
638 );
639
640 -- --End Bug: 2732290 -----------------------------------------
641
642 -- ------------------------------------------------------------------
643 -- Bug : 2710047
644 -- Changed by: (uday poluri) Date:28-May-2003
645 -- Comments: Called from OZF_Settlement_Doc_PVT
646 -- ------------------------------------------------------------------
647 ---------------------------------------------------------------------
648 -- PROCEDURE
649 -- get_write_off_threshold
650 --
651 -- PURPOSE
652 -- This procedure gets (-VE and +VE)threshold value from customer profile
653 -- and system parameters.
654 --
655 --
656 -- PARAMETERS
657 -- p_cust_account_id : claim cust_account_id
658 -- x_ded_pos_write_off_threshold : Positive threshold value
659 -- x_opy_neg_write_off_threshold : Negetive threshold value
660 --
661 -- NOTES :
662 --
663 ----------------------------------------------------------------------
664 Procedure get_write_off_threshold(p_cust_account_id IN NUMBER,
665 x_ded_pos_write_off_threshold OUT NOCOPY NUMBER,
666 x_opy_neg_write_off_threshold OUT NOCOPY NUMBER,
667 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
668 -- --End Bug: 2732290 -----------------------------------------
669
670 ---------------------------------------------------------------------
671 -- PROCEDURE
672 -- Get_Claim_Number
673 --
674 -- PURPOSE
675 -- This procedure retrieves a claim number based on the object_type
676 -- and class.
677 --
678 -- PARAMETERS
679 -- p_claim : The claim record passed in.
680 -- p_object_type : The type of object.
681 -- p_class : class.
682 -- x_claim_number :claim number based on the object_type and class.
683 -- x_return_status
684 --
685 -- NOTES
686 ---------------------------------------------------------------------
687 PROCEDURE Get_Claim_Number( p_split_from_claim_id IN NUMBER,
688 p_custom_setup_id IN NUMBER,
689 x_claim_number OUT NOCOPY VARCHAR2,
690 x_msg_data OUT NOCOPY VARCHAR2,
691 x_msg_count OUT NOCOPY NUMBER,
692 x_return_status OUT NOCOPY VARCHAR2);
693
694 END OZF_CLAIM_PVT;