DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on FND_API

Line 259: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 260: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 261: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 288: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 289: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 290: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 297: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false);

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

Line 306: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 307: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 308: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 315: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false

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: /****************************************************************************

Line 328: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 329: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 330: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 337: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false

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

Line 350: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 351: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 352: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 359: ,p_approval_flag IN VARCHAR2 :=fnd_api.g_false

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

Line 372: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 373: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 374: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 381: ,p_approval_flag IN VARCHAR2 := fnd_api.g_false

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:

Line 409: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 410: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 411: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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);

Line 429: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 430: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 431: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 441: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false

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: );

Line 462: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 463: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 464: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 474: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false

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);

Line 498: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 499: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 500: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 511: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false

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

Line 525: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 526: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 527: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 538: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false

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

Line 564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 565: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 566: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 584: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 585: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 586: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 601: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 602: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 603: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 613: ,p_child_approval_flag IN VARCHAR2 := fnd_api.g_false

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

Line 637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 638: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 639: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 665: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 666: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 685: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,

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

Line 686: -- FND_API.G_RET_STS_ERROR, or

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: /*****************************************************************************************/

Line 687: -- FND_API.G_RET_STS_UNEXP_ERROR

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(

Line 693: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 694: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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);

Line 762: -- Initialize all column values to FND_API.g_miss_char/num/date

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: /*****************************************************************************************/

Line 804: p_exchange_rate_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR --Added for bug 7030415

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

Line 824: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

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,

Line 825: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

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,