79: attribute13 VARCHAR2(150),
80: attribute14 VARCHAR2(150),
81: attribute15 VARCHAR2(150),
82: org_id NUMBER,
83: update_from_tbl_flag VARCHAR2(1) := FND_API.g_false,
84: tax_action VARCHAR2(15),
85: sale_date DATE,
86: item_type VARCHAR2(30),
87: tax_amount NUMBER,
114: -- x_create_hist_flag: Returning flag indicating create claim line history or not.
115: --
116: -- NOTES
117: -- 1. p_mode should be 'CREATE', 'UPDATE', or 'DELETE'
118: -- 2. x_create_hist_flag will be set to FND_API.g_true/false
119: -- 3. p_object_attribute could be 'LINE' or 'LNDT'.
120: ---------------------------------------------------------------------
121: PROCEDURE Check_Create_Line_Hist(
122: p_api_version IN NUMBER
119: -- 3. p_object_attribute could be 'LINE' or 'LNDT'.
120: ---------------------------------------------------------------------
121: PROCEDURE Check_Create_Line_Hist(
122: p_api_version IN NUMBER
123: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
124:
125: ,x_return_status OUT NOCOPY VARCHAR2
126: ,x_msg_count OUT NOCOPY NUMBER
127: ,x_msg_data OUT NOCOPY VARCHAR2
139: -- PURPOSE
140: -- Update claim lines from Claim package.
141: --
142: -- PARAMETERS
143: -- p_new_claim_rec: the update records without complete(with FND_API.g_miss_num/char/date value)
144: --
145: -- NOTES
146: ---------------------------------------------------------------------
147: PROCEDURE Update_Line_Fm_Claim(
145: -- NOTES
146: ---------------------------------------------------------------------
147: PROCEDURE Update_Line_Fm_Claim(
148: p_api_version IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
150: ,p_commit IN VARCHAR2 := FND_API.g_false
151: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
152:
153: ,x_return_status OUT NOCOPY VARCHAR2
146: ---------------------------------------------------------------------
147: PROCEDURE Update_Line_Fm_Claim(
148: p_api_version IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
150: ,p_commit IN VARCHAR2 := FND_API.g_false
151: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
152:
153: ,x_return_status OUT NOCOPY VARCHAR2
154: ,x_msg_data OUT NOCOPY VARCHAR2
147: PROCEDURE Update_Line_Fm_Claim(
148: p_api_version IN NUMBER
149: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
150: ,p_commit IN VARCHAR2 := FND_API.g_false
151: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
152:
153: ,x_return_status OUT NOCOPY VARCHAR2
154: ,x_msg_data OUT NOCOPY VARCHAR2
155: ,x_msg_count OUT NOCOPY NUMBER
174: -- 21/02/2011 - Fix for Bug 11793070
175: ---------------------------------------------------------------------
176: PROCEDURE Create_Claim_Line_Tbl(
177: p_api_version IN NUMBER
178: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
179: ,p_commit IN VARCHAR2 := FND_API.g_false
180: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
181:
182: ,x_return_status OUT NOCOPY VARCHAR2
175: ---------------------------------------------------------------------
176: PROCEDURE Create_Claim_Line_Tbl(
177: p_api_version IN NUMBER
178: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
179: ,p_commit IN VARCHAR2 := FND_API.g_false
180: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
181:
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_data OUT NOCOPY VARCHAR2
176: PROCEDURE Create_Claim_Line_Tbl(
177: p_api_version IN NUMBER
178: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
179: ,p_commit IN VARCHAR2 := FND_API.g_false
180: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
181:
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_data OUT NOCOPY VARCHAR2
184: ,x_msg_count OUT NOCOPY NUMBER
206: -- 2. If claim_line_id is passed in, the uniqueness will be checked.
207: -- Raise exception in case of duplicates.
208: -- 3. If claim_line_id is not passed in, generate a unique one from
209: -- the sequence.
210: -- 4. If a flag column is passed in, check if it is FND_API.g_ture/false.
211: -- Raise exception for invalid flag.
212: -- 5. If valid_flag column is not passed in, default it to FND_API.g_false.
213: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
214: ---------------------------------------------------------------------
208: -- 3. If claim_line_id is not passed in, generate a unique one from
209: -- the sequence.
210: -- 4. If a flag column is passed in, check if it is FND_API.g_ture/false.
211: -- Raise exception for invalid flag.
212: -- 5. If valid_flag column is not passed in, default it to FND_API.g_false.
213: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
214: ---------------------------------------------------------------------
215: PROCEDURE Create_Claim_Line(
216: p_api_version IN NUMBER
209: -- the sequence.
210: -- 4. If a flag column is passed in, check if it is FND_API.g_ture/false.
211: -- Raise exception for invalid flag.
212: -- 5. If valid_flag column is not passed in, default it to FND_API.g_false.
213: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
214: ---------------------------------------------------------------------
215: PROCEDURE Create_Claim_Line(
216: p_api_version IN NUMBER
217: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
213: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
214: ---------------------------------------------------------------------
215: PROCEDURE Create_Claim_Line(
216: p_api_version IN NUMBER
217: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
218: ,p_commit IN VARCHAR2 := FND_API.g_false
219: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
220:
221: ,x_return_status OUT NOCOPY VARCHAR2
214: ---------------------------------------------------------------------
215: PROCEDURE Create_Claim_Line(
216: p_api_version IN NUMBER
217: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
218: ,p_commit IN VARCHAR2 := FND_API.g_false
219: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
220:
221: ,x_return_status OUT NOCOPY VARCHAR2
222: ,x_msg_count OUT NOCOPY NUMBER
215: PROCEDURE Create_Claim_Line(
216: p_api_version IN NUMBER
217: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
218: ,p_commit IN VARCHAR2 := FND_API.g_false
219: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
220:
221: ,x_return_status OUT NOCOPY VARCHAR2
222: ,x_msg_count OUT NOCOPY NUMBER
223: ,x_msg_data OUT NOCOPY VARCHAR2
243: -- NOTES
244: ---------------------------------------------------------------------
245: PROCEDURE Delete_Claim_Line_Tbl(
246: p_api_version IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
248: ,p_commit IN VARCHAR2 := FND_API.g_false
249: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
250:
251: ,x_return_status OUT NOCOPY VARCHAR2
244: ---------------------------------------------------------------------
245: PROCEDURE Delete_Claim_Line_Tbl(
246: p_api_version IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
248: ,p_commit IN VARCHAR2 := FND_API.g_false
249: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
250:
251: ,x_return_status OUT NOCOPY VARCHAR2
252: ,x_msg_data OUT NOCOPY VARCHAR2
245: PROCEDURE Delete_Claim_Line_Tbl(
246: p_api_version IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
248: ,p_commit IN VARCHAR2 := FND_API.g_false
249: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
250:
251: ,x_return_status OUT NOCOPY VARCHAR2
252: ,x_msg_data OUT NOCOPY VARCHAR2
253: ,x_msg_count OUT NOCOPY NUMBER
252: ,x_msg_data OUT NOCOPY VARCHAR2
253: ,x_msg_count OUT NOCOPY NUMBER
254:
255: ,p_claim_line_tbl IN claim_line_tbl_type
256: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
257: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
258:
259: ,x_error_index OUT NOCOPY NUMBER
260: );
275: -- 1. Raise exception if the object_version_number doesn't match.
276: --------------------------------------------------------------------
277: PROCEDURE Delete_Claim_Line(
278: p_api_version IN NUMBER
279: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
280: ,p_commit IN VARCHAR2 := FND_API.g_false
281:
282: ,x_return_status OUT NOCOPY VARCHAR2
283: ,x_msg_count OUT NOCOPY NUMBER
276: --------------------------------------------------------------------
277: PROCEDURE Delete_Claim_Line(
278: p_api_version IN NUMBER
279: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
280: ,p_commit IN VARCHAR2 := FND_API.g_false
281:
282: ,x_return_status OUT NOCOPY VARCHAR2
283: ,x_msg_count OUT NOCOPY NUMBER
284: ,x_msg_data OUT NOCOPY VARCHAR2
303: -- 1. Raise exception if the object_version_number doesn't match.
304: --------------------------------------------------------------------
305: PROCEDURE Lock_Claim_Line(
306: p_api_version IN NUMBER
307: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
308:
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER
311: ,x_msg_data OUT NOCOPY VARCHAR2
329: -- NOTES
330: ---------------------------------------------------------------------
331: PROCEDURE Update_Claim_Line_Tbl(
332: p_api_version IN NUMBER
333: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
334: ,p_commit IN VARCHAR2 := FND_API.g_false
335: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
336:
337: ,x_return_status OUT NOCOPY VARCHAR2
330: ---------------------------------------------------------------------
331: PROCEDURE Update_Claim_Line_Tbl(
332: p_api_version IN NUMBER
333: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
334: ,p_commit IN VARCHAR2 := FND_API.g_false
335: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
336:
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_data OUT NOCOPY VARCHAR2
331: PROCEDURE Update_Claim_Line_Tbl(
332: p_api_version IN NUMBER
333: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
334: ,p_commit IN VARCHAR2 := FND_API.g_false
335: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
336:
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_data OUT NOCOPY VARCHAR2
339: ,x_msg_count OUT NOCOPY NUMBER
338: ,x_msg_data OUT NOCOPY VARCHAR2
339: ,x_msg_count OUT NOCOPY NUMBER
340:
341: ,p_claim_line_tbl IN claim_line_tbl_type
342: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
343: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
344:
345: ,x_error_index OUT NOCOPY NUMBER
346: );
357: -- p_claim_line_rec: the record with new items.
358: --
359: -- NOTES
360: -- 1. Raise exception if the object_version_number doesn't match.
361: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
362: -- that column won't be updated.
363: ----------------------------------------------------------------------
364: PROCEDURE Update_Claim_Line(
365: p_api_version IN NUMBER
362: -- that column won't be updated.
363: ----------------------------------------------------------------------
364: PROCEDURE Update_Claim_Line(
365: p_api_version IN NUMBER
366: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
367: ,p_commit IN VARCHAR2 := FND_API.g_false
368: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
369:
370: ,x_return_status OUT NOCOPY VARCHAR2
363: ----------------------------------------------------------------------
364: PROCEDURE Update_Claim_Line(
365: p_api_version IN NUMBER
366: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
367: ,p_commit IN VARCHAR2 := FND_API.g_false
368: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
369:
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ,x_msg_count OUT NOCOPY NUMBER
364: PROCEDURE Update_Claim_Line(
365: p_api_version IN NUMBER
366: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
367: ,p_commit IN VARCHAR2 := FND_API.g_false
368: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
369:
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ,x_msg_count OUT NOCOPY NUMBER
372: ,x_msg_data OUT NOCOPY VARCHAR2
389: -- p_claim_line: the claim line record to be validated
390: --
391: -- NOTES
392: -- 1. p_claim_line_rec should be a complete record. There
393: -- should not be any FND_API.g_miss_char/num/date in it.
394: ----------------------------------------------------------------------
395: PROCEDURE Validate_Claim_Line(
396: p_api_version IN NUMBER
397: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
393: -- should not be any FND_API.g_miss_char/num/date in it.
394: ----------------------------------------------------------------------
395: PROCEDURE Validate_Claim_Line(
396: p_api_version IN NUMBER
397: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
398: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
399:
400: ,x_return_status OUT NOCOPY VARCHAR2
401: ,x_msg_count OUT NOCOPY NUMBER
394: ----------------------------------------------------------------------
395: PROCEDURE Validate_Claim_Line(
396: p_api_version IN NUMBER
397: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
398: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
399:
400: ,x_return_status OUT NOCOPY VARCHAR2
401: ,x_msg_count OUT NOCOPY NUMBER
402: ,x_msg_data OUT NOCOPY VARCHAR2
432: -- Check the record level business rules.
433: --
434: -- PARAMETERS
435: -- p_claim_line_rec: the record to be validated; may contain attributes
436: -- as FND_API.g_miss_char/num/date
437: -- p_complete_rec: the complete record after all "g_miss" items
438: -- have been replaced by current database values
439: ---------------------------------------------------------------------
440: PROCEDURE Check_Claim_Line_Record(
448: -- PROCEDURE
449: -- Init_Claim_Line_Rec
450: --
451: -- PURPOSE
452: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
453: ---------------------------------------------------------------------
454: PROCEDURE Init_Claim_Line_Rec(
455: x_claim_line_rec OUT NOCOPY claim_line_rec_type
456: );
461: -- Complete_Claim_Line_Rec
462: --
463: -- PURPOSE
464: -- For update_claim_line, some attributes may be passed in as
465: -- FND_API.g_miss_char/num/date if the user doesn't want to
466: -- update those attributes. This procedure will replace the
467: -- "g_miss" attributes with current database values.
468: --
469: -- PARAMETERS
467: -- "g_miss" attributes with current database values.
468: --
469: -- PARAMETERS
470: -- p_claim_line_rec: the record which may contain attributes as
471: -- FND_API.g_miss_char/num/date
472: -- x_complete_rec: the complete record after all "g_miss" items
473: -- have been replaced by current database values
474: ---------------------------------------------------------------------
475: PROCEDURE Complete_Claim_Line_Rec(
480: -- Created for Bug4348163:Split a given claim line so as to associate each claim
481: -- line with earnings from only one offer-product combination.
482: PROCEDURE split_claim_line(
483: p_api_version IN NUMBER
484: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
485: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
486: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
487:
488: ,p_claim_line_id IN NUMBER
481: -- line with earnings from only one offer-product combination.
482: PROCEDURE split_claim_line(
483: p_api_version IN NUMBER
484: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
485: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
486: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
487:
488: ,p_claim_line_id IN NUMBER
489: ,x_return_status OUT NOCOPY VARCHAR2
482: PROCEDURE split_claim_line(
483: p_api_version IN NUMBER
484: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
485: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
486: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
487:
488: ,p_claim_line_id IN NUMBER
489: ,x_return_status OUT NOCOPY VARCHAR2
490: ,x_msg_count OUT NOCOPY NUMBER
505: -- 04/03/2011 kpatro Create.
506: ---------------------------------------------------------------------
507: PROCEDURE Delete_All_Association_AssoUI(
508: p_api_version IN NUMBER
509: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
510: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
511: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
512:
513: ,p_claim_id IN NUMBER
506: ---------------------------------------------------------------------
507: PROCEDURE Delete_All_Association_AssoUI(
508: p_api_version IN NUMBER
509: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
510: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
511: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
512:
513: ,p_claim_id IN NUMBER
514: ,x_return_status OUT NOCOPY VARCHAR2
507: PROCEDURE Delete_All_Association_AssoUI(
508: p_api_version IN NUMBER
509: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
510: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
511: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
512:
513: ,p_claim_id IN NUMBER
514: ,x_return_status OUT NOCOPY VARCHAR2
515: ,x_msg_count OUT NOCOPY NUMBER
525: -- update based on change of claim header columns
526: ---------------------------------------------------------------------
527: PROCEDURE Update_Line_Fm_Claim(
528: p_api_version IN NUMBER
529: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
530: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
531: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
532:
533: ,x_return_status OUT NOCOPY VARCHAR2
526: ---------------------------------------------------------------------
527: PROCEDURE Update_Line_Fm_Claim(
528: p_api_version IN NUMBER
529: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
530: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
531: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
532:
533: ,x_return_status OUT NOCOPY VARCHAR2
534: ,x_msg_data OUT NOCOPY VARCHAR2
527: PROCEDURE Update_Line_Fm_Claim(
528: p_api_version IN NUMBER
529: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
530: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
531: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
532:
533: ,x_return_status OUT NOCOPY VARCHAR2
534: ,x_msg_data OUT NOCOPY VARCHAR2
535: ,x_msg_count OUT NOCOPY NUMBER
535: ,x_msg_count OUT NOCOPY NUMBER
536:
537: ,p_claim_id IN NUMBER
538: ,p_tax_action IN VARCHAR2
539: ,p_remove_tax_code IN VARCHAR2 := FND_API.G_FALSE
540: ,p_remove_related_cust IN VARCHAR2 := FND_API.G_FALSE
541: ,p_amount_change_flag IN VARCHAR2 := FND_API.G_FALSE
542: );
543:
536:
537: ,p_claim_id IN NUMBER
538: ,p_tax_action IN VARCHAR2
539: ,p_remove_tax_code IN VARCHAR2 := FND_API.G_FALSE
540: ,p_remove_related_cust IN VARCHAR2 := FND_API.G_FALSE
541: ,p_amount_change_flag IN VARCHAR2 := FND_API.G_FALSE
542: );
543:
544: END OZF_Claim_Line_PVT;
537: ,p_claim_id IN NUMBER
538: ,p_tax_action IN VARCHAR2
539: ,p_remove_tax_code IN VARCHAR2 := FND_API.G_FALSE
540: ,p_remove_related_cust IN VARCHAR2 := FND_API.G_FALSE
541: ,p_amount_change_flag IN VARCHAR2 := FND_API.G_FALSE
542: );
543:
544: END OZF_Claim_Line_PVT;