255: /****************************************************************************/
256:
257: PROCEDURE create_act_budgets(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
260: ,p_commit IN VARCHAR2 := fnd_api.g_false
261: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
262: ,x_return_status OUT NOCOPY VARCHAR2
263: ,x_msg_count OUT NOCOPY NUMBER
256:
257: PROCEDURE create_act_budgets(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
260: ,p_commit IN VARCHAR2 := fnd_api.g_false
261: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
262: ,x_return_status OUT NOCOPY VARCHAR2
263: ,x_msg_count OUT NOCOPY NUMBER
264: ,x_msg_data OUT NOCOPY VARCHAR2
257: PROCEDURE create_act_budgets(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
260: ,p_commit IN VARCHAR2 := fnd_api.g_false
261: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
262: ,x_return_status OUT NOCOPY VARCHAR2
263: ,x_msg_count OUT NOCOPY NUMBER
264: ,x_msg_data OUT NOCOPY VARCHAR2
265: ,p_act_budgets_rec IN act_budgets_rec_type
284: /****************************************************************************/
285:
286: PROCEDURE create_act_budgets(
287: p_api_version IN NUMBER
288: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
289: ,p_commit IN VARCHAR2 := fnd_api.g_false
290: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
285:
286: PROCEDURE create_act_budgets(
287: p_api_version IN NUMBER
288: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
289: ,p_commit IN VARCHAR2 := fnd_api.g_false
290: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
293: ,x_msg_data OUT NOCOPY VARCHAR2
286: PROCEDURE create_act_budgets(
287: p_api_version IN NUMBER
288: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
289: ,p_commit IN VARCHAR2 := fnd_api.g_false
290: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
293: ,x_msg_data OUT NOCOPY VARCHAR2
294: ,p_act_budgets_rec IN act_budgets_rec_type
293: ,x_msg_data OUT NOCOPY VARCHAR2
294: ,p_act_budgets_rec IN act_budgets_rec_type
295: ,p_act_util_rec IN act_util_rec_type
296: ,x_act_budget_id OUT NOCOPY NUMBER
297: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false);
298:
299:
300: /****************************************************************************
301: * Ying Zhao: 06/21/2004 overloaded function to return actual utilized amount for chargeback
302: * added x_utilized_amount
303: */
304: PROCEDURE create_act_budgets(
305: p_api_version IN NUMBER
306: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
307: ,p_commit IN VARCHAR2 := fnd_api.g_false
308: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER
303: */
304: PROCEDURE create_act_budgets(
305: p_api_version IN NUMBER
306: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
307: ,p_commit IN VARCHAR2 := fnd_api.g_false
308: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER
311: ,x_msg_data OUT NOCOPY VARCHAR2
304: PROCEDURE create_act_budgets(
305: p_api_version IN NUMBER
306: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
307: ,p_commit IN VARCHAR2 := fnd_api.g_false
308: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER
311: ,x_msg_data OUT NOCOPY VARCHAR2
312: ,p_act_budgets_rec IN act_budgets_rec_type
311: ,x_msg_data OUT NOCOPY VARCHAR2
312: ,p_act_budgets_rec IN act_budgets_rec_type
313: ,p_act_util_rec IN act_util_rec_type
314: ,x_act_budget_id OUT NOCOPY NUMBER
315: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false
316: ,x_utilized_amount OUT NOCOPY NUMBER);
317:
318:
319: /****************************************************************************
324: * for TPA Parallel Execution ER Bug#9614703.
325: ****************************************************************************/
326: PROCEDURE create_act_budgets(
327: p_api_version IN NUMBER
328: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
329: ,p_commit IN VARCHAR2 := fnd_api.g_false
330: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
331: ,x_return_status OUT NOCOPY VARCHAR2
332: ,x_msg_count OUT NOCOPY NUMBER
325: ****************************************************************************/
326: PROCEDURE create_act_budgets(
327: p_api_version IN NUMBER
328: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
329: ,p_commit IN VARCHAR2 := fnd_api.g_false
330: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
331: ,x_return_status OUT NOCOPY VARCHAR2
332: ,x_msg_count OUT NOCOPY NUMBER
333: ,x_msg_data OUT NOCOPY VARCHAR2
326: PROCEDURE create_act_budgets(
327: p_api_version IN NUMBER
328: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
329: ,p_commit IN VARCHAR2 := fnd_api.g_false
330: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
331: ,x_return_status OUT NOCOPY VARCHAR2
332: ,x_msg_count OUT NOCOPY NUMBER
333: ,x_msg_data OUT NOCOPY VARCHAR2
334: ,p_act_budgets_rec IN act_budgets_rec_type
333: ,x_msg_data OUT NOCOPY VARCHAR2
334: ,p_act_budgets_rec IN act_budgets_rec_type
335: ,p_act_util_rec IN act_util_rec_type
336: ,x_act_budget_id OUT NOCOPY NUMBER
337: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false
338: ,x_utilized_amount OUT NOCOPY NUMBER
339: ,p_resale_batch_id IN NUMBER
340: ,p_batch_type IN VARCHAR2
341: ,p_use_fund_staging_tables IN VARCHAR2
346:
347: --nirprasa - added for Bug 9383565
348: PROCEDURE create_act_budgets(
349: p_api_version IN NUMBER
350: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
351: ,p_commit IN VARCHAR2 := fnd_api.g_false
352: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER
347: --nirprasa - added for Bug 9383565
348: PROCEDURE create_act_budgets(
349: p_api_version IN NUMBER
350: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
351: ,p_commit IN VARCHAR2 := fnd_api.g_false
352: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER
355: ,x_msg_data OUT NOCOPY VARCHAR2
348: PROCEDURE create_act_budgets(
349: p_api_version IN NUMBER
350: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
351: ,p_commit IN VARCHAR2 := fnd_api.g_false
352: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER
355: ,x_msg_data OUT NOCOPY VARCHAR2
356: ,p_act_budgets_rec IN act_budgets_rec_type
355: ,x_msg_data OUT NOCOPY VARCHAR2
356: ,p_act_budgets_rec IN act_budgets_rec_type
357: ,p_act_util_rec IN act_util_rec_type
358: ,x_act_budget_id OUT NOCOPY NUMBER
359: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false
360: ,x_utilized_amount OUT NOCOPY NUMBER
361: ,p_resale_batch_id IN NUMBER
362: ,p_batch_type IN VARCHAR2
363: ,p_use_fund_staging_tables IN VARCHAR2
368: );
369:
370: PROCEDURE create_act_budgets (
371: p_api_version IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
373: ,p_commit IN VARCHAR2 := fnd_api.g_false
374: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER
369:
370: PROCEDURE create_act_budgets (
371: p_api_version IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
373: ,p_commit IN VARCHAR2 := fnd_api.g_false
374: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER
377: ,x_msg_data OUT NOCOPY VARCHAR2
370: PROCEDURE create_act_budgets (
371: p_api_version IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
373: ,p_commit IN VARCHAR2 := fnd_api.g_false
374: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER
377: ,x_msg_data OUT NOCOPY VARCHAR2
378: ,p_act_budgets_rec IN act_budgets_rec_type
377: ,x_msg_data OUT NOCOPY VARCHAR2
378: ,p_act_budgets_rec IN act_budgets_rec_type
379: ,p_act_util_rec IN act_util_rec_type
380: ,x_act_budget_id OUT NOCOPY NUMBER
381: ,p_approval_flag IN VARCHAR2 := fnd_api.g_false
382: ,x_utilized_amount OUT NOCOPY NUMBER
383: ,x_utilization_id OUT NOCOPY NUMBER
384: );
385:
405: /****************************************************************************/
406:
407: PROCEDURE update_act_budgets(
408: p_api_version IN NUMBER
409: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
410: ,p_commit IN VARCHAR2 := fnd_api.g_false
411: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
412: ,x_return_status OUT NOCOPY VARCHAR2
413: ,x_msg_count OUT NOCOPY NUMBER
406:
407: PROCEDURE update_act_budgets(
408: p_api_version IN NUMBER
409: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
410: ,p_commit IN VARCHAR2 := fnd_api.g_false
411: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
412: ,x_return_status OUT NOCOPY VARCHAR2
413: ,x_msg_count OUT NOCOPY NUMBER
414: ,x_msg_data OUT NOCOPY VARCHAR2
407: PROCEDURE update_act_budgets(
408: p_api_version IN NUMBER
409: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
410: ,p_commit IN VARCHAR2 := fnd_api.g_false
411: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
412: ,x_return_status OUT NOCOPY VARCHAR2
413: ,x_msg_count OUT NOCOPY NUMBER
414: ,x_msg_data OUT NOCOPY VARCHAR2
415: ,p_act_budgets_rec IN act_budgets_rec_type);
425: -- End Of Comments
426: /****************************************************************************/
427: PROCEDURE update_act_budgets(
428: p_api_version IN NUMBER
429: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
430: ,p_commit IN VARCHAR2 := fnd_api.g_false
431: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
432: ,x_return_status OUT NOCOPY VARCHAR2
433: ,x_msg_count OUT NOCOPY NUMBER
426: /****************************************************************************/
427: PROCEDURE update_act_budgets(
428: p_api_version IN NUMBER
429: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
430: ,p_commit IN VARCHAR2 := fnd_api.g_false
431: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
432: ,x_return_status OUT NOCOPY VARCHAR2
433: ,x_msg_count OUT NOCOPY NUMBER
434: ,x_msg_data OUT NOCOPY VARCHAR2
427: PROCEDURE update_act_budgets(
428: p_api_version IN NUMBER
429: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
430: ,p_commit IN VARCHAR2 := fnd_api.g_false
431: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
432: ,x_return_status OUT NOCOPY VARCHAR2
433: ,x_msg_count OUT NOCOPY NUMBER
434: ,x_msg_data OUT NOCOPY VARCHAR2
435: ,p_act_budgets_rec IN act_budgets_rec_type
437: ,p_parent_process_key IN VARCHAR2
438: ,p_parent_context IN VARCHAR2
439: ,p_parent_approval_flag IN VARCHAR2
440: ,p_continue_flow IN VARCHAR2
441: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false
442: -- 10/22/2001 mpande added for allocation bug
443: ,p_requestor_owner_flag IN VARCHAR2 := 'N'
444: ,p_act_util_rec IN act_util_rec_type := NULL
445: );
458: -- End Of Comments
459: /****************************************************************************/
460: PROCEDURE update_act_budgets(
461: p_api_version IN NUMBER
462: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
463: ,p_commit IN VARCHAR2 := fnd_api.g_false
464: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
465: ,x_return_status OUT NOCOPY VARCHAR2
466: ,x_msg_count OUT NOCOPY NUMBER
459: /****************************************************************************/
460: PROCEDURE update_act_budgets(
461: p_api_version IN NUMBER
462: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
463: ,p_commit IN VARCHAR2 := fnd_api.g_false
464: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
465: ,x_return_status OUT NOCOPY VARCHAR2
466: ,x_msg_count OUT NOCOPY NUMBER
467: ,x_msg_data OUT NOCOPY VARCHAR2
460: PROCEDURE update_act_budgets(
461: p_api_version IN NUMBER
462: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
463: ,p_commit IN VARCHAR2 := fnd_api.g_false
464: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
465: ,x_return_status OUT NOCOPY VARCHAR2
466: ,x_msg_count OUT NOCOPY NUMBER
467: ,x_msg_data OUT NOCOPY VARCHAR2
468: ,p_act_budgets_rec IN act_budgets_rec_type
470: ,p_parent_process_key IN VARCHAR2
471: ,p_parent_context IN VARCHAR2
472: ,p_parent_approval_flag IN VARCHAR2
473: ,p_continue_flow IN VARCHAR2
474: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false
475: -- 10/22/2001 mpande added for allocation bug
476: ,p_requestor_owner_flag IN VARCHAR2 := 'N'
477: ,p_act_util_rec IN act_util_rec_type := NULL
478: ,x_utilized_amount OUT NOCOPY NUMBER);
494: -- End Of Comments
495: /****************************************************************************/
496: PROCEDURE update_act_budgets(
497: p_api_version IN NUMBER
498: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
499: ,p_commit IN VARCHAR2 := fnd_api.g_false
500: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
495: /****************************************************************************/
496: PROCEDURE update_act_budgets(
497: p_api_version IN NUMBER
498: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
499: ,p_commit IN VARCHAR2 := fnd_api.g_false
500: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2
496: PROCEDURE update_act_budgets(
497: p_api_version IN NUMBER
498: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
499: ,p_commit IN VARCHAR2 := fnd_api.g_false
500: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
501: ,x_return_status OUT NOCOPY VARCHAR2
502: ,x_msg_count OUT NOCOPY NUMBER
503: ,x_msg_data OUT NOCOPY VARCHAR2
504: ,p_old_act_budgets_rec IN act_budgets_rec_type
507: ,p_parent_process_key IN VARCHAR2
508: ,p_parent_context IN VARCHAR2
509: ,p_parent_approval_flag IN VARCHAR2
510: ,p_continue_flow IN VARCHAR2
511: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false
512: -- 10/22/2001 mpande added for allocation bug
513: ,p_requestor_owner_flag IN VARCHAR2 := 'N'
514: ,p_act_util_rec IN act_util_rec_type := NULL
515: ,x_utilized_amount OUT NOCOPY NUMBER
521: );
522:
523: PROCEDURE update_act_budgets(
524: p_api_version IN NUMBER
525: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
526: ,p_commit IN VARCHAR2 := fnd_api.g_false
527: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
528: ,x_return_status OUT NOCOPY VARCHAR2
529: ,x_msg_count OUT NOCOPY NUMBER
522:
523: PROCEDURE update_act_budgets(
524: p_api_version IN NUMBER
525: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
526: ,p_commit IN VARCHAR2 := fnd_api.g_false
527: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
528: ,x_return_status OUT NOCOPY VARCHAR2
529: ,x_msg_count OUT NOCOPY NUMBER
530: ,x_msg_data OUT NOCOPY VARCHAR2
523: PROCEDURE update_act_budgets(
524: p_api_version IN NUMBER
525: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
526: ,p_commit IN VARCHAR2 := fnd_api.g_false
527: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
528: ,x_return_status OUT NOCOPY VARCHAR2
529: ,x_msg_count OUT NOCOPY NUMBER
530: ,x_msg_data OUT NOCOPY VARCHAR2
531: ,p_old_act_budgets_rec IN act_budgets_rec_type
534: ,p_parent_process_key IN VARCHAR2
535: ,p_parent_context IN VARCHAR2
536: ,p_parent_approval_flag IN VARCHAR2
537: ,p_continue_flow IN VARCHAR2
538: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false
539: -- 10/22/2001 mpande added for allocation bug
540: ,p_requestor_owner_flag IN VARCHAR2 := 'N'
541: ,p_act_util_rec IN act_util_rec_type := NULL
542: ,x_utilized_amount OUT NOCOPY NUMBER
560: -- End Of Comments
561: /****************************************************************************/
562: PROCEDURE update_act_budgets(
563: p_api_version IN NUMBER
564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: ,p_commit IN VARCHAR2 := fnd_api.g_false
566: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: ,x_return_status OUT NOCOPY VARCHAR2
568: ,x_msg_count OUT NOCOPY NUMBER
561: /****************************************************************************/
562: PROCEDURE update_act_budgets(
563: p_api_version IN NUMBER
564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: ,p_commit IN VARCHAR2 := fnd_api.g_false
566: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: ,x_return_status OUT NOCOPY VARCHAR2
568: ,x_msg_count OUT NOCOPY NUMBER
569: ,x_msg_data OUT NOCOPY VARCHAR2
562: PROCEDURE update_act_budgets(
563: p_api_version IN NUMBER
564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: ,p_commit IN VARCHAR2 := fnd_api.g_false
566: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: ,x_return_status OUT NOCOPY VARCHAR2
568: ,x_msg_count OUT NOCOPY NUMBER
569: ,x_msg_data OUT NOCOPY VARCHAR2
570: ,p_act_budgets_rec IN act_budgets_rec_type
580: * added x_utilized_amount
581: */
582: PROCEDURE update_act_budgets(
583: p_api_version IN NUMBER
584: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
585: ,p_commit IN VARCHAR2 := fnd_api.g_false
586: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
587: ,x_return_status OUT NOCOPY VARCHAR2
588: ,x_msg_count OUT NOCOPY NUMBER
581: */
582: PROCEDURE update_act_budgets(
583: p_api_version IN NUMBER
584: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
585: ,p_commit IN VARCHAR2 := fnd_api.g_false
586: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
587: ,x_return_status OUT NOCOPY VARCHAR2
588: ,x_msg_count OUT NOCOPY NUMBER
589: ,x_msg_data OUT NOCOPY VARCHAR2
582: PROCEDURE update_act_budgets(
583: p_api_version IN NUMBER
584: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
585: ,p_commit IN VARCHAR2 := fnd_api.g_false
586: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
587: ,x_return_status OUT NOCOPY VARCHAR2
588: ,x_msg_count OUT NOCOPY NUMBER
589: ,x_msg_data OUT NOCOPY VARCHAR2
590: ,p_act_budgets_rec IN act_budgets_rec_type
597:
598: --kdass - added for Bug 8726683
599: PROCEDURE update_act_budgets (
600: p_api_version IN NUMBER
601: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
602: ,p_commit IN VARCHAR2 := fnd_api.g_false
603: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
598: --kdass - added for Bug 8726683
599: PROCEDURE update_act_budgets (
600: p_api_version IN NUMBER
601: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
602: ,p_commit IN VARCHAR2 := fnd_api.g_false
603: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
606: ,x_msg_data OUT NOCOPY VARCHAR2
599: PROCEDURE update_act_budgets (
600: p_api_version IN NUMBER
601: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
602: ,p_commit IN VARCHAR2 := fnd_api.g_false
603: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
606: ,x_msg_data OUT NOCOPY VARCHAR2
607: ,p_act_budgets_rec IN act_budgets_rec_type
609: ,p_parent_process_key IN VARCHAR2
610: ,p_parent_context IN VARCHAR2
611: ,p_parent_approval_flag IN VARCHAR2
612: ,p_continue_flow IN VARCHAR2
613: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false
614: ,p_requestor_owner_flag IN VARCHAR2 := 'N'
615: ,p_act_util_rec IN act_util_rec_type := NULL
616: ,x_utilized_amount OUT NOCOPY NUMBER
617: ,x_utilization_id OUT NOCOPY NUMBER
633: -- End Of Comments
634:
635: PROCEDURE delete_act_budgets(
636: p_api_version IN NUMBER
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_commit IN VARCHAR2 := fnd_api.g_false
639: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
640: ,x_return_status OUT NOCOPY VARCHAR2
641: ,x_msg_count OUT NOCOPY NUMBER
634:
635: PROCEDURE delete_act_budgets(
636: p_api_version IN NUMBER
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_commit IN VARCHAR2 := fnd_api.g_false
639: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
640: ,x_return_status OUT NOCOPY VARCHAR2
641: ,x_msg_count OUT NOCOPY NUMBER
642: ,x_msg_data OUT NOCOPY VARCHAR2
635: PROCEDURE delete_act_budgets(
636: p_api_version IN NUMBER
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_commit IN VARCHAR2 := fnd_api.g_false
639: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
640: ,x_return_status OUT NOCOPY VARCHAR2
641: ,x_msg_count OUT NOCOPY NUMBER
642: ,x_msg_data OUT NOCOPY VARCHAR2
643: ,p_act_budget_id IN NUMBER
661: -- End Of Comments
662:
663: PROCEDURE lock_act_budgets(
664: p_api_version IN NUMBER
665: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
666: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
667: ,x_return_status OUT NOCOPY VARCHAR2
668: ,x_msg_count OUT NOCOPY NUMBER
669: ,x_msg_data OUT NOCOPY VARCHAR2
662:
663: PROCEDURE lock_act_budgets(
664: p_api_version IN NUMBER
665: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
666: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
667: ,x_return_status OUT NOCOPY VARCHAR2
668: ,x_msg_count OUT NOCOPY NUMBER
669: ,x_msg_data OUT NOCOPY VARCHAR2
670: ,p_act_budget_id IN NUMBER
681: -- Version : Current version 1.0
682: -- Initial version 1.0
683: --
684: -- Note : 1. p_Budgets_rec.activity_Budget_id is a required parameter
685: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
686: -- FND_API.G_RET_STS_ERROR, or
687: -- FND_API.G_RET_STS_UNEXP_ERROR
688: --
689: -- End Of Comments
682: -- Initial version 1.0
683: --
684: -- Note : 1. p_Budgets_rec.activity_Budget_id is a required parameter
685: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
686: -- FND_API.G_RET_STS_ERROR, or
687: -- FND_API.G_RET_STS_UNEXP_ERROR
688: --
689: -- End Of Comments
690: /*****************************************************************************************/
683: --
684: -- Note : 1. p_Budgets_rec.activity_Budget_id is a required parameter
685: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
686: -- FND_API.G_RET_STS_ERROR, or
687: -- FND_API.G_RET_STS_UNEXP_ERROR
688: --
689: -- End Of Comments
690: /*****************************************************************************************/
691: PROCEDURE validate_act_budgets(
689: -- End Of Comments
690: /*****************************************************************************************/
691: PROCEDURE validate_act_budgets(
692: p_api_version IN NUMBER
693: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
694: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
695: ,x_return_status OUT NOCOPY VARCHAR2
696: ,x_msg_count OUT NOCOPY NUMBER
697: ,x_msg_data OUT NOCOPY VARCHAR2
690: /*****************************************************************************************/
691: PROCEDURE validate_act_budgets(
692: p_api_version IN NUMBER
693: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
694: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
695: ,x_return_status OUT NOCOPY VARCHAR2
696: ,x_msg_count OUT NOCOPY NUMBER
697: ,x_msg_data OUT NOCOPY VARCHAR2
698: ,p_act_budgets_rec IN act_budgets_rec_type);
758: --
759: -- NAME
760: -- Init_Act_Budgets_Rec
761: -- PURPOSE
762: -- Initialize all column values to FND_API.g_miss_char/num/date
763: -- HISTORY
764: -- 15-Aug-2000 choang Created.
765: -- 22-Feb-2001 mpande Modified for Hornet changes.
766: /*****************************************************************************************/
800: x_return_status OUT NOCOPY VARCHAR2,
801: x_msg_count OUT NOCOPY NUMBER,
802: x_msg_data OUT NOCOPY VARCHAR2,
803: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
804: p_exchange_rate_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR --Added for bug 7030415
805: );
806:
807: /*****************************************************************************************/
808: -- nirprasa, Added for bug 7425189
820: /******************************************************************************************/
821: /*commented for bug 8532055
822: PROCEDURE update_reconcile_objfundsum (
823: p_api_version IN NUMBER,
824: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
825: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
826: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,
827: p_conv_date IN DATE,
828: x_return_status OUT NOCOPY VARCHAR2,
821: /*commented for bug 8532055
822: PROCEDURE update_reconcile_objfundsum (
823: p_api_version IN NUMBER,
824: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
825: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
826: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,
827: p_conv_date IN DATE,
828: x_return_status OUT NOCOPY VARCHAR2,
829: x_msg_count OUT NOCOPY NUMBER,