eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_LINE_PVT dependencies on FND_API

Line 83: update_from_tbl_flag VARCHAR2(1) := FND_API.g_false,

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,

Line 117: -- 2. x_create_hist_flag will be set to FND_API.g_true/false

113: -- x_create_hist_flag: Returning flag indicating create claim line history or not.
114: --
115: -- NOTES
116: -- 1. p_mode should be 'CREATE', 'UPDATE', or 'DELETE'
117: -- 2. x_create_hist_flag will be set to FND_API.g_true/false
118: -- 3. p_object_attribute could be 'LINE' or 'LNDT'.
119: ---------------------------------------------------------------------
120: PROCEDURE Check_Create_Line_Hist(
121: p_api_version IN NUMBER

Line 122: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

118: -- 3. p_object_attribute could be 'LINE' or 'LNDT'.
119: ---------------------------------------------------------------------
120: PROCEDURE Check_Create_Line_Hist(
121: p_api_version IN NUMBER
122: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
123:
124: ,x_return_status OUT NOCOPY VARCHAR2
125: ,x_msg_count OUT NOCOPY NUMBER
126: ,x_msg_data OUT NOCOPY VARCHAR2

Line 142: -- p_new_claim_rec: the update records without complete(with FND_API.g_miss_num/char/date value)

138: -- PURPOSE
139: -- Update claim lines from Claim package.
140: --
141: -- PARAMETERS
142: -- p_new_claim_rec: the update records without complete(with FND_API.g_miss_num/char/date value)
143: --
144: -- NOTES
145: ---------------------------------------------------------------------
146: PROCEDURE Update_Line_Fm_Claim(

Line 148: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

144: -- NOTES
145: ---------------------------------------------------------------------
146: PROCEDURE Update_Line_Fm_Claim(
147: p_api_version IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
149: ,p_commit IN VARCHAR2 := FND_API.g_false
150: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
151:
152: ,x_return_status OUT NOCOPY VARCHAR2

Line 149: ,p_commit IN VARCHAR2 := FND_API.g_false

145: ---------------------------------------------------------------------
146: PROCEDURE Update_Line_Fm_Claim(
147: p_api_version IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
149: ,p_commit IN VARCHAR2 := FND_API.g_false
150: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_data OUT NOCOPY VARCHAR2

Line 150: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

146: PROCEDURE Update_Line_Fm_Claim(
147: p_api_version IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
149: ,p_commit IN VARCHAR2 := FND_API.g_false
150: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_data OUT NOCOPY VARCHAR2
154: ,x_msg_count OUT NOCOPY NUMBER

Line 175: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

171: -- NOTES
172: ---------------------------------------------------------------------
173: PROCEDURE Create_Claim_Line_Tbl(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
176: ,p_commit IN VARCHAR2 := FND_API.g_false
177: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
178:
179: ,x_return_status OUT NOCOPY VARCHAR2

Line 176: ,p_commit IN VARCHAR2 := FND_API.g_false

172: ---------------------------------------------------------------------
173: PROCEDURE Create_Claim_Line_Tbl(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
176: ,p_commit IN VARCHAR2 := FND_API.g_false
177: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
178:
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_data OUT NOCOPY VARCHAR2

Line 177: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

173: PROCEDURE Create_Claim_Line_Tbl(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
176: ,p_commit IN VARCHAR2 := FND_API.g_false
177: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
178:
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_data OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER

Line 207: -- 4. If a flag column is passed in, check if it is FND_API.g_ture/false.

203: -- 2. If claim_line_id is passed in, the uniqueness will be checked.
204: -- Raise exception in case of duplicates.
205: -- 3. If claim_line_id is not passed in, generate a unique one from
206: -- the sequence.
207: -- 4. If a flag column is passed in, check if it is FND_API.g_ture/false.
208: -- Raise exception for invalid flag.
209: -- 5. If valid_flag column is not passed in, default it to FND_API.g_false.
210: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
211: ---------------------------------------------------------------------

Line 209: -- 5. If valid_flag column is not passed in, default it to FND_API.g_false.

205: -- 3. If claim_line_id is not passed in, generate a unique one from
206: -- the sequence.
207: -- 4. If a flag column is passed in, check if it is FND_API.g_ture/false.
208: -- Raise exception for invalid flag.
209: -- 5. If valid_flag column is not passed in, default it to FND_API.g_false.
210: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
211: ---------------------------------------------------------------------
212: PROCEDURE Create_Claim_Line(
213: p_api_version IN NUMBER

Line 210: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.

206: -- the sequence.
207: -- 4. If a flag column is passed in, check if it is FND_API.g_ture/false.
208: -- Raise exception for invalid flag.
209: -- 5. If valid_flag column is not passed in, default it to FND_API.g_false.
210: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
211: ---------------------------------------------------------------------
212: PROCEDURE Create_Claim_Line(
213: p_api_version IN NUMBER
214: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

Line 214: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

210: -- 6. Please don't pass in any FND_API.g_miss_char/num/date for claim_line record.
211: ---------------------------------------------------------------------
212: PROCEDURE Create_Claim_Line(
213: p_api_version IN NUMBER
214: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
215: ,p_commit IN VARCHAR2 := FND_API.g_false
216: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
217:
218: ,x_return_status OUT NOCOPY VARCHAR2

Line 215: ,p_commit IN VARCHAR2 := FND_API.g_false

211: ---------------------------------------------------------------------
212: PROCEDURE Create_Claim_Line(
213: p_api_version IN NUMBER
214: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
215: ,p_commit IN VARCHAR2 := FND_API.g_false
216: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
217:
218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER

Line 216: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

212: PROCEDURE Create_Claim_Line(
213: p_api_version IN NUMBER
214: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
215: ,p_commit IN VARCHAR2 := FND_API.g_false
216: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
217:
218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2

Line 244: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

240: -- NOTES
241: ---------------------------------------------------------------------
242: PROCEDURE Delete_Claim_Line_Tbl(
243: p_api_version IN NUMBER
244: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
245: ,p_commit IN VARCHAR2 := FND_API.g_false
246: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
247:
248: ,x_return_status OUT NOCOPY VARCHAR2

Line 245: ,p_commit IN VARCHAR2 := FND_API.g_false

241: ---------------------------------------------------------------------
242: PROCEDURE Delete_Claim_Line_Tbl(
243: p_api_version IN NUMBER
244: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
245: ,p_commit IN VARCHAR2 := FND_API.g_false
246: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
247:
248: ,x_return_status OUT NOCOPY VARCHAR2
249: ,x_msg_data OUT NOCOPY VARCHAR2

Line 246: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

242: PROCEDURE Delete_Claim_Line_Tbl(
243: p_api_version IN NUMBER
244: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
245: ,p_commit IN VARCHAR2 := FND_API.g_false
246: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
247:
248: ,x_return_status OUT NOCOPY VARCHAR2
249: ,x_msg_data OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER

Line 253: ,p_change_object_version IN VARCHAR2 := FND_API.g_false

249: ,x_msg_data OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER
251:
252: ,p_claim_line_tbl IN claim_line_tbl_type
253: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
254: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
255:
256: ,x_error_index OUT NOCOPY NUMBER
257: );

Line 276: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

272: -- 1. Raise exception if the object_version_number doesn't match.
273: --------------------------------------------------------------------
274: PROCEDURE Delete_Claim_Line(
275: p_api_version IN NUMBER
276: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
277: ,p_commit IN VARCHAR2 := FND_API.g_false
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER

Line 277: ,p_commit IN VARCHAR2 := FND_API.g_false

273: --------------------------------------------------------------------
274: PROCEDURE Delete_Claim_Line(
275: p_api_version IN NUMBER
276: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
277: ,p_commit IN VARCHAR2 := FND_API.g_false
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER
281: ,x_msg_data OUT NOCOPY VARCHAR2

Line 304: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

300: -- 1. Raise exception if the object_version_number doesn't match.
301: --------------------------------------------------------------------
302: PROCEDURE Lock_Claim_Line(
303: p_api_version IN NUMBER
304: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
305:
306: ,x_return_status OUT NOCOPY VARCHAR2
307: ,x_msg_count OUT NOCOPY NUMBER
308: ,x_msg_data OUT NOCOPY VARCHAR2

Line 330: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

326: -- NOTES
327: ---------------------------------------------------------------------
328: PROCEDURE Update_Claim_Line_Tbl(
329: p_api_version IN NUMBER
330: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
331: ,p_commit IN VARCHAR2 := FND_API.g_false
332: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
333:
334: ,x_return_status OUT NOCOPY VARCHAR2

Line 331: ,p_commit IN VARCHAR2 := FND_API.g_false

327: ---------------------------------------------------------------------
328: PROCEDURE Update_Claim_Line_Tbl(
329: p_api_version IN NUMBER
330: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
331: ,p_commit IN VARCHAR2 := FND_API.g_false
332: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
333:
334: ,x_return_status OUT NOCOPY VARCHAR2
335: ,x_msg_data OUT NOCOPY VARCHAR2

Line 332: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

328: PROCEDURE Update_Claim_Line_Tbl(
329: p_api_version IN NUMBER
330: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
331: ,p_commit IN VARCHAR2 := FND_API.g_false
332: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
333:
334: ,x_return_status OUT NOCOPY VARCHAR2
335: ,x_msg_data OUT NOCOPY VARCHAR2
336: ,x_msg_count OUT NOCOPY NUMBER

Line 339: ,p_change_object_version IN VARCHAR2 := FND_API.g_false

335: ,x_msg_data OUT NOCOPY VARCHAR2
336: ,x_msg_count OUT NOCOPY NUMBER
337:
338: ,p_claim_line_tbl IN claim_line_tbl_type
339: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
340: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
341:
342: ,x_error_index OUT NOCOPY NUMBER
343: );

Line 358: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

354: -- p_claim_line_rec: the record with new items.
355: --
356: -- NOTES
357: -- 1. Raise exception if the object_version_number doesn't match.
358: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
359: -- that column won't be updated.
360: ----------------------------------------------------------------------
361: PROCEDURE Update_Claim_Line(
362: p_api_version IN NUMBER

Line 363: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

359: -- that column won't be updated.
360: ----------------------------------------------------------------------
361: PROCEDURE Update_Claim_Line(
362: p_api_version IN NUMBER
363: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
364: ,p_commit IN VARCHAR2 := FND_API.g_false
365: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
366:
367: ,x_return_status OUT NOCOPY VARCHAR2

Line 364: ,p_commit IN VARCHAR2 := FND_API.g_false

360: ----------------------------------------------------------------------
361: PROCEDURE Update_Claim_Line(
362: p_api_version IN NUMBER
363: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
364: ,p_commit IN VARCHAR2 := FND_API.g_false
365: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
366:
367: ,x_return_status OUT NOCOPY VARCHAR2
368: ,x_msg_count OUT NOCOPY NUMBER

Line 365: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

361: PROCEDURE Update_Claim_Line(
362: p_api_version IN NUMBER
363: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
364: ,p_commit IN VARCHAR2 := FND_API.g_false
365: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
366:
367: ,x_return_status OUT NOCOPY VARCHAR2
368: ,x_msg_count OUT NOCOPY NUMBER
369: ,x_msg_data OUT NOCOPY VARCHAR2

Line 390: -- should not be any FND_API.g_miss_char/num/date in it.

386: -- p_claim_line: the claim line record to be validated
387: --
388: -- NOTES
389: -- 1. p_claim_line_rec should be a complete record. There
390: -- should not be any FND_API.g_miss_char/num/date in it.
391: ----------------------------------------------------------------------
392: PROCEDURE Validate_Claim_Line(
393: p_api_version IN NUMBER
394: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

Line 394: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

390: -- should not be any FND_API.g_miss_char/num/date in it.
391: ----------------------------------------------------------------------
392: PROCEDURE Validate_Claim_Line(
393: p_api_version IN NUMBER
394: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
395: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
396:
397: ,x_return_status OUT NOCOPY VARCHAR2
398: ,x_msg_count OUT NOCOPY NUMBER

Line 395: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

391: ----------------------------------------------------------------------
392: PROCEDURE Validate_Claim_Line(
393: p_api_version IN NUMBER
394: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
395: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
396:
397: ,x_return_status OUT NOCOPY VARCHAR2
398: ,x_msg_count OUT NOCOPY NUMBER
399: ,x_msg_data OUT NOCOPY VARCHAR2

Line 433: -- as FND_API.g_miss_char/num/date

429: -- Check the record level business rules.
430: --
431: -- PARAMETERS
432: -- p_claim_line_rec: the record to be validated; may contain attributes
433: -- as FND_API.g_miss_char/num/date
434: -- p_complete_rec: the complete record after all "g_miss" items
435: -- have been replaced by current database values
436: ---------------------------------------------------------------------
437: PROCEDURE Check_Claim_Line_Record(

Line 449: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

445: -- PROCEDURE
446: -- Init_Claim_Line_Rec
447: --
448: -- PURPOSE
449: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
450: ---------------------------------------------------------------------
451: PROCEDURE Init_Claim_Line_Rec(
452: x_claim_line_rec OUT NOCOPY claim_line_rec_type
453: );

Line 462: -- FND_API.g_miss_char/num/date if the user doesn't want to

458: -- Complete_Claim_Line_Rec
459: --
460: -- PURPOSE
461: -- For update_claim_line, some attributes may be passed in as
462: -- FND_API.g_miss_char/num/date if the user doesn't want to
463: -- update those attributes. This procedure will replace the
464: -- "g_miss" attributes with current database values.
465: --
466: -- PARAMETERS

Line 468: -- FND_API.g_miss_char/num/date

464: -- "g_miss" attributes with current database values.
465: --
466: -- PARAMETERS
467: -- p_claim_line_rec: the record which may contain attributes as
468: -- FND_API.g_miss_char/num/date
469: -- x_complete_rec: the complete record after all "g_miss" items
470: -- have been replaced by current database values
471: ---------------------------------------------------------------------
472: PROCEDURE Complete_Claim_Line_Rec(

Line 481: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

477: -- Created for Bug4348163:Split a given claim line so as to associate each claim
478: -- line with earnings from only one offer-product combination.
479: PROCEDURE split_claim_line(
480: p_api_version IN NUMBER
481: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
482: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
483: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
484:
485: ,p_claim_line_id IN NUMBER

Line 482: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

478: -- line with earnings from only one offer-product combination.
479: PROCEDURE split_claim_line(
480: p_api_version IN NUMBER
481: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
482: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
483: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
484:
485: ,p_claim_line_id IN NUMBER
486: ,x_return_status OUT NOCOPY VARCHAR2

Line 483: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

479: PROCEDURE split_claim_line(
480: p_api_version IN NUMBER
481: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
482: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
483: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
484:
485: ,p_claim_line_id IN NUMBER
486: ,x_return_status OUT NOCOPY VARCHAR2
487: ,x_msg_count OUT NOCOPY NUMBER