227: /****************************************************************************/
228:
229: PROCEDURE create_act_budgets(
230: p_api_version IN NUMBER
231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
232: ,p_commit IN VARCHAR2 := fnd_api.g_false
233: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
234: ,x_return_status OUT NOCOPY VARCHAR2
235: ,x_msg_count OUT NOCOPY NUMBER
228:
229: PROCEDURE create_act_budgets(
230: p_api_version IN NUMBER
231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
232: ,p_commit IN VARCHAR2 := fnd_api.g_false
233: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
234: ,x_return_status OUT NOCOPY VARCHAR2
235: ,x_msg_count OUT NOCOPY NUMBER
236: ,x_msg_data OUT NOCOPY VARCHAR2
229: PROCEDURE create_act_budgets(
230: p_api_version IN NUMBER
231: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
232: ,p_commit IN VARCHAR2 := fnd_api.g_false
233: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
234: ,x_return_status OUT NOCOPY VARCHAR2
235: ,x_msg_count OUT NOCOPY NUMBER
236: ,x_msg_data OUT NOCOPY VARCHAR2
237: ,p_act_budgets_rec IN act_budgets_rec_type
256: /****************************************************************************/
257:
258: PROCEDURE create_act_budgets(
259: p_api_version IN NUMBER
260: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
261: ,p_commit IN VARCHAR2 := fnd_api.g_false
262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER
257:
258: PROCEDURE create_act_budgets(
259: p_api_version IN NUMBER
260: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
261: ,p_commit IN VARCHAR2 := fnd_api.g_false
262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER
265: ,x_msg_data OUT NOCOPY VARCHAR2
258: PROCEDURE create_act_budgets(
259: p_api_version IN NUMBER
260: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
261: ,p_commit IN VARCHAR2 := fnd_api.g_false
262: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER
265: ,x_msg_data OUT NOCOPY VARCHAR2
266: ,p_act_budgets_rec IN act_budgets_rec_type
265: ,x_msg_data OUT NOCOPY VARCHAR2
266: ,p_act_budgets_rec IN act_budgets_rec_type
267: ,p_act_util_rec IN act_util_rec_type
268: ,x_act_budget_id OUT NOCOPY NUMBER
269: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false);
270:
271:
272: /****************************************************************************
273: * Ying Zhao: 06/21/2004 overloaded function to return actual utilized amount for chargeback
274: * added x_utilized_amount
275: */
276: PROCEDURE create_act_budgets(
277: p_api_version IN NUMBER
278: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
279: ,p_commit IN VARCHAR2 := fnd_api.g_false
280: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
281: ,x_return_status OUT NOCOPY VARCHAR2
282: ,x_msg_count OUT NOCOPY NUMBER
275: */
276: PROCEDURE create_act_budgets(
277: p_api_version IN NUMBER
278: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
279: ,p_commit IN VARCHAR2 := fnd_api.g_false
280: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
281: ,x_return_status OUT NOCOPY VARCHAR2
282: ,x_msg_count OUT NOCOPY NUMBER
283: ,x_msg_data OUT NOCOPY VARCHAR2
276: PROCEDURE create_act_budgets(
277: p_api_version IN NUMBER
278: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
279: ,p_commit IN VARCHAR2 := fnd_api.g_false
280: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
281: ,x_return_status OUT NOCOPY VARCHAR2
282: ,x_msg_count OUT NOCOPY NUMBER
283: ,x_msg_data OUT NOCOPY VARCHAR2
284: ,p_act_budgets_rec IN act_budgets_rec_type
283: ,x_msg_data OUT NOCOPY VARCHAR2
284: ,p_act_budgets_rec IN act_budgets_rec_type
285: ,p_act_util_rec IN act_util_rec_type
286: ,x_act_budget_id OUT NOCOPY NUMBER
287: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false
288: ,x_utilized_amount OUT NOCOPY NUMBER);
289:
290:
291: /****************************************************************************/
310: /****************************************************************************/
311:
312: PROCEDURE update_act_budgets(
313: p_api_version IN NUMBER
314: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: ,p_commit IN VARCHAR2 := fnd_api.g_false
316: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: ,x_return_status OUT NOCOPY VARCHAR2
318: ,x_msg_count OUT NOCOPY NUMBER
311:
312: PROCEDURE update_act_budgets(
313: p_api_version IN NUMBER
314: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: ,p_commit IN VARCHAR2 := fnd_api.g_false
316: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: ,x_return_status OUT NOCOPY VARCHAR2
318: ,x_msg_count OUT NOCOPY NUMBER
319: ,x_msg_data OUT NOCOPY VARCHAR2
312: PROCEDURE update_act_budgets(
313: p_api_version IN NUMBER
314: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: ,p_commit IN VARCHAR2 := fnd_api.g_false
316: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: ,x_return_status OUT NOCOPY VARCHAR2
318: ,x_msg_count OUT NOCOPY NUMBER
319: ,x_msg_data OUT NOCOPY VARCHAR2
320: ,p_act_budgets_rec IN act_budgets_rec_type);
330: -- End Of Comments
331: /****************************************************************************/
332: PROCEDURE update_act_budgets(
333: p_api_version IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_count OUT NOCOPY NUMBER
331: /****************************************************************************/
332: PROCEDURE update_act_budgets(
333: p_api_version IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_count OUT NOCOPY NUMBER
339: ,x_msg_data OUT NOCOPY VARCHAR2
332: PROCEDURE update_act_budgets(
333: p_api_version IN NUMBER
334: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_count OUT NOCOPY NUMBER
339: ,x_msg_data OUT NOCOPY VARCHAR2
340: ,p_act_budgets_rec IN act_budgets_rec_type
342: ,p_parent_process_key IN VARCHAR2
343: ,p_parent_context IN VARCHAR2
344: ,p_parent_approval_flag IN VARCHAR2
345: ,p_continue_flow IN VARCHAR2
346: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false
347: -- 10/22/2001 mpande added for allocation bug
348: ,p_requestor_owner_flag IN VARCHAR2 := 'N'
349: ,p_act_util_rec IN act_util_rec_type := NULL
350: );
363: -- End Of Comments
364: /****************************************************************************/
365: PROCEDURE update_act_budgets(
366: p_api_version IN NUMBER
367: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
368: ,p_commit IN VARCHAR2 := fnd_api.g_false
369: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ,x_msg_count OUT NOCOPY NUMBER
364: /****************************************************************************/
365: PROCEDURE update_act_budgets(
366: p_api_version IN NUMBER
367: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
368: ,p_commit IN VARCHAR2 := fnd_api.g_false
369: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ,x_msg_count OUT NOCOPY NUMBER
372: ,x_msg_data OUT NOCOPY VARCHAR2
365: PROCEDURE update_act_budgets(
366: p_api_version IN NUMBER
367: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
368: ,p_commit IN VARCHAR2 := fnd_api.g_false
369: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ,x_msg_count OUT NOCOPY NUMBER
372: ,x_msg_data OUT NOCOPY VARCHAR2
373: ,p_act_budgets_rec IN act_budgets_rec_type
375: ,p_parent_process_key IN VARCHAR2
376: ,p_parent_context IN VARCHAR2
377: ,p_parent_approval_flag IN VARCHAR2
378: ,p_continue_flow IN VARCHAR2
379: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false
380: -- 10/22/2001 mpande added for allocation bug
381: ,p_requestor_owner_flag IN VARCHAR2 := 'N'
382: ,p_act_util_rec IN act_util_rec_type := NULL
383: ,x_utilized_amount OUT NOCOPY NUMBER);
395: -- End Of Comments
396: /****************************************************************************/
397: PROCEDURE update_act_budgets(
398: p_api_version IN NUMBER
399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
400: ,p_commit IN VARCHAR2 := fnd_api.g_false
401: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
402: ,x_return_status OUT NOCOPY VARCHAR2
403: ,x_msg_count OUT NOCOPY NUMBER
396: /****************************************************************************/
397: PROCEDURE update_act_budgets(
398: p_api_version IN NUMBER
399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
400: ,p_commit IN VARCHAR2 := fnd_api.g_false
401: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
402: ,x_return_status OUT NOCOPY VARCHAR2
403: ,x_msg_count OUT NOCOPY NUMBER
404: ,x_msg_data OUT NOCOPY VARCHAR2
397: PROCEDURE update_act_budgets(
398: p_api_version IN NUMBER
399: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
400: ,p_commit IN VARCHAR2 := fnd_api.g_false
401: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
402: ,x_return_status OUT NOCOPY VARCHAR2
403: ,x_msg_count OUT NOCOPY NUMBER
404: ,x_msg_data OUT NOCOPY VARCHAR2
405: ,p_act_budgets_rec IN act_budgets_rec_type
415: * added x_utilized_amount
416: */
417: PROCEDURE update_act_budgets(
418: p_api_version IN NUMBER
419: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
420: ,p_commit IN VARCHAR2 := fnd_api.g_false
421: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
422: ,x_return_status OUT NOCOPY VARCHAR2
423: ,x_msg_count OUT NOCOPY NUMBER
416: */
417: PROCEDURE update_act_budgets(
418: p_api_version IN NUMBER
419: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
420: ,p_commit IN VARCHAR2 := fnd_api.g_false
421: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
422: ,x_return_status OUT NOCOPY VARCHAR2
423: ,x_msg_count OUT NOCOPY NUMBER
424: ,x_msg_data OUT NOCOPY VARCHAR2
417: PROCEDURE update_act_budgets(
418: p_api_version IN NUMBER
419: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
420: ,p_commit IN VARCHAR2 := fnd_api.g_false
421: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
422: ,x_return_status OUT NOCOPY VARCHAR2
423: ,x_msg_count OUT NOCOPY NUMBER
424: ,x_msg_data OUT NOCOPY VARCHAR2
425: ,p_act_budgets_rec IN act_budgets_rec_type
447: -- End Of Comments
448:
449: PROCEDURE delete_act_budgets(
450: p_api_version IN NUMBER
451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
452: ,p_commit IN VARCHAR2 := fnd_api.g_false
453: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
454: ,x_return_status OUT NOCOPY VARCHAR2
455: ,x_msg_count OUT NOCOPY NUMBER
448:
449: PROCEDURE delete_act_budgets(
450: p_api_version IN NUMBER
451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
452: ,p_commit IN VARCHAR2 := fnd_api.g_false
453: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
454: ,x_return_status OUT NOCOPY VARCHAR2
455: ,x_msg_count OUT NOCOPY NUMBER
456: ,x_msg_data OUT NOCOPY VARCHAR2
449: PROCEDURE delete_act_budgets(
450: p_api_version IN NUMBER
451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
452: ,p_commit IN VARCHAR2 := fnd_api.g_false
453: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
454: ,x_return_status OUT NOCOPY VARCHAR2
455: ,x_msg_count OUT NOCOPY NUMBER
456: ,x_msg_data OUT NOCOPY VARCHAR2
457: ,p_act_budget_id IN NUMBER
475: -- End Of Comments
476:
477: PROCEDURE lock_act_budgets(
478: p_api_version IN NUMBER
479: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
480: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
481: ,x_return_status OUT NOCOPY VARCHAR2
482: ,x_msg_count OUT NOCOPY NUMBER
483: ,x_msg_data OUT NOCOPY VARCHAR2
476:
477: PROCEDURE lock_act_budgets(
478: p_api_version IN NUMBER
479: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
480: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
481: ,x_return_status OUT NOCOPY VARCHAR2
482: ,x_msg_count OUT NOCOPY NUMBER
483: ,x_msg_data OUT NOCOPY VARCHAR2
484: ,p_act_budget_id IN NUMBER
495: -- Version : Current version 1.0
496: -- Initial version 1.0
497: --
498: -- Note : 1. p_Budgets_rec.activity_Budget_id is a required parameter
499: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
500: -- FND_API.G_RET_STS_ERROR, or
501: -- FND_API.G_RET_STS_UNEXP_ERROR
502: --
503: -- End Of Comments
496: -- Initial version 1.0
497: --
498: -- Note : 1. p_Budgets_rec.activity_Budget_id is a required parameter
499: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
500: -- FND_API.G_RET_STS_ERROR, or
501: -- FND_API.G_RET_STS_UNEXP_ERROR
502: --
503: -- End Of Comments
504: /*****************************************************************************************/
497: --
498: -- Note : 1. p_Budgets_rec.activity_Budget_id is a required parameter
499: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
500: -- FND_API.G_RET_STS_ERROR, or
501: -- FND_API.G_RET_STS_UNEXP_ERROR
502: --
503: -- End Of Comments
504: /*****************************************************************************************/
505: PROCEDURE validate_act_budgets(
503: -- End Of Comments
504: /*****************************************************************************************/
505: PROCEDURE validate_act_budgets(
506: p_api_version IN NUMBER
507: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
508: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
509: ,x_return_status OUT NOCOPY VARCHAR2
510: ,x_msg_count OUT NOCOPY NUMBER
511: ,x_msg_data OUT NOCOPY VARCHAR2
504: /*****************************************************************************************/
505: PROCEDURE validate_act_budgets(
506: p_api_version IN NUMBER
507: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
508: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
509: ,x_return_status OUT NOCOPY VARCHAR2
510: ,x_msg_count OUT NOCOPY NUMBER
511: ,x_msg_data OUT NOCOPY VARCHAR2
512: ,p_act_budgets_rec IN act_budgets_rec_type);
572: --
573: -- NAME
574: -- Init_Act_Budgets_Rec
575: -- PURPOSE
576: -- Initialize all column values to FND_API.g_miss_char/num/date
577: -- HISTORY
578: -- 15-Aug-2000 choang Created.
579: -- 22-Feb-2001 mpande Modified for Hornet changes.
580: /*****************************************************************************************/
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
618: p_exchange_rate_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR --Added for bug 7030415
619: );
620:
621: /*****************************************************************************************/
622: -- nirprasa, Added for bug 7425189
633:
634: /******************************************************************************************/
635: PROCEDURE update_reconcile_objfundsum (
636: p_api_version IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
638: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
639: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,
640: p_conv_date IN DATE,
641: x_return_status OUT NOCOPY VARCHAR2,
634: /******************************************************************************************/
635: PROCEDURE update_reconcile_objfundsum (
636: p_api_version IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
638: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
639: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,
640: p_conv_date IN DATE,
641: x_return_status OUT NOCOPY VARCHAR2,
642: x_msg_count OUT NOCOPY NUMBER,