27: org_id NUMBER,
28: univ_curr_amount NUMBER,
29: fxgl_acctd_amount NUMBER,
30: utilized_acctd_amount NUMBER,
31: update_from_tbl_flag VARCHAR2(1) := FND_API.g_false
32: );
33:
34: TYPE line_util_tbl_type is TABLE OF line_util_rec_type
35: INDEX BY BINARY_INTEGER;
137: -- 25-JUN-2002 mchang Create.
138: ---------------------------------------------------------------------
139: PROCEDURE Get_Utiz_Sql_Stmt(
140: p_api_version IN NUMBER
141: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
142: ,p_commit IN VARCHAR2 := FND_API.g_false
143: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
144:
145: ,x_return_status OUT NOCOPY VARCHAR2
138: ---------------------------------------------------------------------
139: PROCEDURE Get_Utiz_Sql_Stmt(
140: p_api_version IN NUMBER
141: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
142: ,p_commit IN VARCHAR2 := FND_API.g_false
143: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
144:
145: ,x_return_status OUT NOCOPY VARCHAR2
146: ,x_msg_count OUT NOCOPY NUMBER
139: PROCEDURE Get_Utiz_Sql_Stmt(
140: p_api_version IN NUMBER
141: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
142: ,p_commit IN VARCHAR2 := FND_API.g_false
143: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
144:
145: ,x_return_status OUT NOCOPY VARCHAR2
146: ,x_msg_count OUT NOCOPY NUMBER
147: ,x_msg_data OUT NOCOPY VARCHAR2
175: -- NOTES
176: ---------------------------------------------------------------------
177: PROCEDURE Update_Line_Util_Tbl(
178: p_api_version IN NUMBER
179: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
180: ,p_commit IN VARCHAR2 := FND_API.g_false
181: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
182:
183: ,x_return_status OUT NOCOPY VARCHAR2
176: ---------------------------------------------------------------------
177: PROCEDURE Update_Line_Util_Tbl(
178: p_api_version IN NUMBER
179: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
180: ,p_commit IN VARCHAR2 := FND_API.g_false
181: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
182:
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_msg_data OUT NOCOPY VARCHAR2
177: PROCEDURE Update_Line_Util_Tbl(
178: p_api_version IN NUMBER
179: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
180: ,p_commit IN VARCHAR2 := FND_API.g_false
181: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
182:
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_msg_data OUT NOCOPY VARCHAR2
185: ,x_msg_count OUT NOCOPY NUMBER
207: -- NOTES
208: ---------------------------------------------------------------------
209: PROCEDURE Delete_Line_Util_Tbl(
210: p_api_version IN NUMBER
211: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
212: ,p_commit IN VARCHAR2 := FND_API.g_false
213: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
214:
215: ,x_return_status OUT NOCOPY VARCHAR2
208: ---------------------------------------------------------------------
209: PROCEDURE Delete_Line_Util_Tbl(
210: p_api_version IN NUMBER
211: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
212: ,p_commit IN VARCHAR2 := FND_API.g_false
213: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
214:
215: ,x_return_status OUT NOCOPY VARCHAR2
216: ,x_msg_data OUT NOCOPY VARCHAR2
209: PROCEDURE Delete_Line_Util_Tbl(
210: p_api_version IN NUMBER
211: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
212: ,p_commit IN VARCHAR2 := FND_API.g_false
213: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
214:
215: ,x_return_status OUT NOCOPY VARCHAR2
216: ,x_msg_data OUT NOCOPY VARCHAR2
217: ,x_msg_count OUT NOCOPY NUMBER
230: -- PROCEDURE
231: -- Init_Line_Util_Rec
232: --
233: -- PURPOSE
234: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
235: ---------------------------------------------------------------------
236: PROCEDURE Init_Line_Util_Rec(
237: x_line_util_rec OUT NOCOPY line_util_rec_type
238: );
243: -- Complete_Line_Util_Rec
244: --
245: -- PURPOSE
246: -- For update_line_util, some attributes may be passed in as
247: -- FND_API.g_miss_char/num/date if the user doesn't want to
248: -- update those attributes. This procedure will replace the
249: -- "g_miss" attributes with current database values.
250: --
251: -- PARAMETERS
249: -- "g_miss" attributes with current database values.
250: --
251: -- PARAMETERS
252: -- p_line_util_rec: the record which may contain attributes as
253: -- FND_API.g_miss_char/num/date
254: -- x_complete_rec: the complete record after all "g_miss" items
255: -- have been replaced by current database values
256: ---------------------------------------------------------------------
257: PROCEDURE Complete_Line_Util_Rec(
271: -- NOTES
272: ---------------------------------------------------------------------
273: PROCEDURE Update_Group_Line_Util(
274: p_api_version IN NUMBER
275: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276: ,p_commit IN VARCHAR2 := FND_API.g_false
277: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
272: ---------------------------------------------------------------------
273: PROCEDURE Update_Group_Line_Util(
274: p_api_version IN NUMBER
275: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276: ,p_commit IN VARCHAR2 := FND_API.g_false
277: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER
273: PROCEDURE Update_Group_Line_Util(
274: p_api_version IN NUMBER
275: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276: ,p_commit IN VARCHAR2 := FND_API.g_false
277: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER
281: ,x_msg_data OUT NOCOPY VARCHAR2
299: -- NOTES
300: ---------------------------------------------------------------------
301: PROCEDURE Delete_Group_Line_Util(
302: p_api_version IN NUMBER
303: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
304: ,p_commit IN VARCHAR2 := FND_API.g_false
305: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
306:
307: ,x_return_status OUT NOCOPY VARCHAR2
300: ---------------------------------------------------------------------
301: PROCEDURE Delete_Group_Line_Util(
302: p_api_version IN NUMBER
303: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
304: ,p_commit IN VARCHAR2 := FND_API.g_false
305: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
306:
307: ,x_return_status OUT NOCOPY VARCHAR2
308: ,x_msg_count OUT NOCOPY NUMBER
301: PROCEDURE Delete_Group_Line_Util(
302: p_api_version IN NUMBER
303: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
304: ,p_commit IN VARCHAR2 := FND_API.g_false
305: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
306:
307: ,x_return_status OUT NOCOPY VARCHAR2
308: ,x_msg_count OUT NOCOPY NUMBER
309: ,x_msg_data OUT NOCOPY VARCHAR2
327: -- NOTES
328: ---------------------------------------------------------------------
329: PROCEDURE Asso_Accruals_To_Claim(
330: p_api_version IN NUMBER
331: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
332: ,p_commit IN VARCHAR2 := FND_API.g_false
333: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
334:
335: ,x_return_status OUT NOCOPY VARCHAR2
328: ---------------------------------------------------------------------
329: PROCEDURE Asso_Accruals_To_Claim(
330: p_api_version IN NUMBER
331: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
332: ,p_commit IN VARCHAR2 := FND_API.g_false
333: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
334:
335: ,x_return_status OUT NOCOPY VARCHAR2
336: ,x_msg_count OUT NOCOPY NUMBER
329: PROCEDURE Asso_Accruals_To_Claim(
330: p_api_version IN NUMBER
331: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
332: ,p_commit IN VARCHAR2 := FND_API.g_false
333: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
334:
335: ,x_return_status OUT NOCOPY VARCHAR2
336: ,x_msg_count OUT NOCOPY NUMBER
337: ,x_msg_data OUT NOCOPY VARCHAR2
356: -- NOTES
357: ---------------------------------------------------------------------
358: PROCEDURE Asso_Accruals_To_Claim_Line(
359: p_api_version IN NUMBER
360: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
363:
364: ,x_return_status OUT NOCOPY VARCHAR2
357: ---------------------------------------------------------------------
358: PROCEDURE Asso_Accruals_To_Claim_Line(
359: p_api_version IN NUMBER
360: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
363:
364: ,x_return_status OUT NOCOPY VARCHAR2
365: ,x_msg_count OUT NOCOPY NUMBER
358: PROCEDURE Asso_Accruals_To_Claim_Line(
359: p_api_version IN NUMBER
360: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
361: ,p_commit IN VARCHAR2 := FND_API.g_false
362: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
363:
364: ,x_return_status OUT NOCOPY VARCHAR2
365: ,x_msg_count OUT NOCOPY NUMBER
366: ,x_msg_data OUT NOCOPY VARCHAR2
384: -- NOTES
385: ---------------------------------------------------------------------
386: PROCEDURE Create_Claim_For_Accruals(
387: p_api_version IN NUMBER
388: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
389: ,p_commit IN VARCHAR2 := FND_API.g_false
390: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
391:
392: ,x_return_status OUT NOCOPY VARCHAR2
385: ---------------------------------------------------------------------
386: PROCEDURE Create_Claim_For_Accruals(
387: p_api_version IN NUMBER
388: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
389: ,p_commit IN VARCHAR2 := FND_API.g_false
390: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
391:
392: ,x_return_status OUT NOCOPY VARCHAR2
393: ,x_msg_count OUT NOCOPY NUMBER
386: PROCEDURE Create_Claim_For_Accruals(
387: p_api_version IN NUMBER
388: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
389: ,p_commit IN VARCHAR2 := FND_API.g_false
390: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
391:
392: ,x_return_status OUT NOCOPY VARCHAR2
393: ,x_msg_count OUT NOCOPY NUMBER
394: ,x_msg_data OUT NOCOPY VARCHAR2
418: -- Bug# 8632964 fixed.
419: -------------------------------------------------------------------------------
420: PROCEDURE Create_Claim_Existing_Accruals(
421: p_api_version IN NUMBER
422: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
423: ,p_commit IN VARCHAR2 := FND_API.g_false
424: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
425: ,x_return_status OUT NOCOPY VARCHAR2
426: ,x_msg_count OUT NOCOPY NUMBER
419: -------------------------------------------------------------------------------
420: PROCEDURE Create_Claim_Existing_Accruals(
421: p_api_version IN NUMBER
422: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
423: ,p_commit IN VARCHAR2 := FND_API.g_false
424: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
425: ,x_return_status OUT NOCOPY VARCHAR2
426: ,x_msg_count OUT NOCOPY NUMBER
427: ,x_msg_data OUT NOCOPY VARCHAR2
420: PROCEDURE Create_Claim_Existing_Accruals(
421: p_api_version IN NUMBER
422: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
423: ,p_commit IN VARCHAR2 := FND_API.g_false
424: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
425: ,x_return_status OUT NOCOPY VARCHAR2
426: ,x_msg_count OUT NOCOPY NUMBER
427: ,x_msg_data OUT NOCOPY VARCHAR2
428: ,p_claim_rec IN ozf_claim_pvt.claim_rec_type
444: -- NOTES
445: ---------------------------------------------------------------------
446: PROCEDURE Pay_Claim_For_Accruals(
447: p_api_version IN NUMBER
448: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
449: ,p_commit IN VARCHAR2 := FND_API.g_false
450: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
451: ,p_accrual_flag IN VARCHAR2 DEFAULT NULL
452:
445: ---------------------------------------------------------------------
446: PROCEDURE Pay_Claim_For_Accruals(
447: p_api_version IN NUMBER
448: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
449: ,p_commit IN VARCHAR2 := FND_API.g_false
450: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
451: ,p_accrual_flag IN VARCHAR2 DEFAULT NULL
452:
453: ,x_return_status OUT NOCOPY VARCHAR2
446: PROCEDURE Pay_Claim_For_Accruals(
447: p_api_version IN NUMBER
448: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
449: ,p_commit IN VARCHAR2 := FND_API.g_false
450: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
451: ,p_accrual_flag IN VARCHAR2 DEFAULT NULL
452:
453: ,x_return_status OUT NOCOPY VARCHAR2
454: ,x_msg_count OUT NOCOPY NUMBER
474: -- NOTES
475: ---------------------------------------------------------------------
476: PROCEDURE Initiate_Batch_Payment(
477: p_api_version IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
479: ,p_commit IN VARCHAR2 := FND_API.g_false
480: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
481:
482: ,x_return_status OUT NOCOPY VARCHAR2
475: ---------------------------------------------------------------------
476: PROCEDURE Initiate_Batch_Payment(
477: p_api_version IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
479: ,p_commit IN VARCHAR2 := FND_API.g_false
480: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
481:
482: ,x_return_status OUT NOCOPY VARCHAR2
483: ,x_msg_count OUT NOCOPY NUMBER
476: PROCEDURE Initiate_Batch_Payment(
477: p_api_version IN NUMBER
478: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
479: ,p_commit IN VARCHAR2 := FND_API.g_false
480: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
481:
482: ,x_return_status OUT NOCOPY VARCHAR2
483: ,x_msg_count OUT NOCOPY NUMBER
484: ,x_msg_data OUT NOCOPY VARCHAR2
502: -- NOTES
503: ---------------------------------------------------------------------
504: PROCEDURE Adjust_Fund_Utilization(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
507: ,p_commit IN VARCHAR2 := FND_API.g_false
508: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
509:
510: ,x_return_status OUT NOCOPY VARCHAR2
503: ---------------------------------------------------------------------
504: PROCEDURE Adjust_Fund_Utilization(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
507: ,p_commit IN VARCHAR2 := FND_API.g_false
508: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
509:
510: ,x_return_status OUT NOCOPY VARCHAR2
511: ,x_msg_count OUT NOCOPY NUMBER
504: PROCEDURE Adjust_Fund_Utilization(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
507: ,p_commit IN VARCHAR2 := FND_API.g_false
508: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
509:
510: ,x_return_status OUT NOCOPY VARCHAR2
511: ,x_msg_count OUT NOCOPY NUMBER
512: ,x_msg_data OUT NOCOPY VARCHAR2
645: ---------------------------------------------------------------------
646:
647: PROCEDURE Initiate_SD_Payment(
648: p_api_version IN NUMBER
649: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
650: ,p_commit IN VARCHAR2 := FND_API.g_false
651: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
652: ,x_return_status OUT NOCOPY VARCHAR2
653: ,x_msg_count OUT NOCOPY NUMBER
646:
647: PROCEDURE Initiate_SD_Payment(
648: p_api_version IN NUMBER
649: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
650: ,p_commit IN VARCHAR2 := FND_API.g_false
651: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
652: ,x_return_status OUT NOCOPY VARCHAR2
653: ,x_msg_count OUT NOCOPY NUMBER
654: ,x_msg_data OUT NOCOPY VARCHAR2
647: PROCEDURE Initiate_SD_Payment(
648: p_api_version IN NUMBER
649: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
650: ,p_commit IN VARCHAR2 := FND_API.g_false
651: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
652: ,x_return_status OUT NOCOPY VARCHAR2
653: ,x_msg_count OUT NOCOPY NUMBER
654: ,x_msg_data OUT NOCOPY VARCHAR2
655: ,p_ship_debit_id IN NUMBER
702: -- NOTES
703: ---------------------------------------------------------------------
704: PROCEDURE Accruals_Association(
705: p_api_version IN NUMBER
706: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
707: ,p_commit IN VARCHAR2 := FND_API.g_false
708: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
709:
710: ,x_return_status OUT NOCOPY VARCHAR2
703: ---------------------------------------------------------------------
704: PROCEDURE Accruals_Association(
705: p_api_version IN NUMBER
706: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
707: ,p_commit IN VARCHAR2 := FND_API.g_false
708: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
709:
710: ,x_return_status OUT NOCOPY VARCHAR2
711: ,x_msg_count OUT NOCOPY NUMBER
704: PROCEDURE Accruals_Association(
705: p_api_version IN NUMBER
706: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
707: ,p_commit IN VARCHAR2 := FND_API.g_false
708: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
709:
710: ,x_return_status OUT NOCOPY VARCHAR2
711: ,x_msg_count OUT NOCOPY NUMBER
712: ,x_msg_data OUT NOCOPY VARCHAR2