DBA Data[Home] [Help]

APPS.AMS_CPYUTILITY_PVT dependencies on FND_API

Line 452: x_return_status := fnd_api.g_ret_sts_success;

448: l_number NUMBER;
449:
450: BEGIN
451:
452: x_return_status := fnd_api.g_ret_sts_success;
453: l_number := 0;
454: IF p_arc_act_code = 'CAMP' THEN
455: SELECT actual_exec_end_date ,actual_exec_start_date
456: INTO end_date,start_date

Line 482: x_return_status := fnd_api.g_ret_sts_error;

478:
479: EXCEPTION
480: WHEN OTHERS
481: THEN
482: x_return_status := fnd_api.g_ret_sts_error;
483: END get_dates;
484:
485:
486: -- History

Line 515: RETURN FND_API.G_TRUE;

511: IS
512: BEGIN
513: FOR i IN 1..p_attributes_table.COUNT LOOP
514: IF p_attribute = p_attributes_table(i) THEN
515: RETURN FND_API.G_TRUE;
516: END IF;
517: END LOOP;
518: RETURN FND_API.G_FALSE;
519: END is_copy_attribute;

Line 518: RETURN FND_API.G_FALSE;

514: IF p_attribute = p_attributes_table(i) THEN
515: RETURN FND_API.G_TRUE;
516: END IF;
517: END LOOP;
518: RETURN FND_API.G_FALSE;
519: END is_copy_attribute;
520:
521: -- History
522: -- 29 OCT 2001 rrajesh Created.

Line 573: RETURN FND_API.G_TRUE;

569: OPEN c_csch_exists(p_obj_id);
570: FETCH c_csch_exists INTO l_tmp;
571: CLOSE c_csch_exists;
572: IF l_tmp > 0 THEN
573: RETURN FND_API.G_TRUE;
574: ELSE
575: RETURN FND_API.G_FALSE;
576: END IF;
577: END IF;

Line 575: RETURN FND_API.G_FALSE;

571: CLOSE c_csch_exists;
572: IF l_tmp > 0 THEN
573: RETURN FND_API.G_TRUE;
574: ELSE
575: RETURN FND_API.G_FALSE;
576: END IF;
577: END IF;
578: IF p_obj_attribute = 'MESG' THEN
579: OPEN c_mesg_exists(p_obj_id, p_obj_type);

Line 583: RETURN FND_API.G_TRUE;

579: OPEN c_mesg_exists(p_obj_id, p_obj_type);
580: FETCH c_mesg_exists INTO l_tmp;
581: CLOSE c_mesg_exists;
582: IF l_tmp > 0 THEN
583: RETURN FND_API.G_TRUE;
584: ELSE
585: RETURN FND_API.G_FALSE;
586: END IF;
587: END IF;

Line 585: RETURN FND_API.G_FALSE;

581: CLOSE c_mesg_exists;
582: IF l_tmp > 0 THEN
583: RETURN FND_API.G_TRUE;
584: ELSE
585: RETURN FND_API.G_FALSE;
586: END IF;
587: END IF;
588: IF p_obj_attribute = 'ATCH' THEN
589: OPEN c_atch_exists(p_obj_id, p_obj_type);

Line 592: RETURN FND_API.G_TRUE;

588: IF p_obj_attribute = 'ATCH' THEN
589: OPEN c_atch_exists(p_obj_id, p_obj_type);
590: FETCH c_atch_exists INTO l_tmp;
591: IF l_tmp > 0 THEN
592: RETURN FND_API.G_TRUE;
593: ELSE
594: RETURN FND_API.G_FALSE;
595: END IF;
596: END IF;

Line 594: RETURN FND_API.G_FALSE;

590: FETCH c_atch_exists INTO l_tmp;
591: IF l_tmp > 0 THEN
592: RETURN FND_API.G_TRUE;
593: ELSE
594: RETURN FND_API.G_FALSE;
595: END IF;
596: END IF;
597: IF p_obj_attribute = 'GEOS' THEN
598: OPEN c_geos_exists(p_obj_id, p_obj_type);

Line 601: RETURN FND_API.G_TRUE;

597: IF p_obj_attribute = 'GEOS' THEN
598: OPEN c_geos_exists(p_obj_id, p_obj_type);
599: FETCH c_geos_exists INTO l_tmp;
600: IF l_tmp > 0 THEN
601: RETURN FND_API.G_TRUE;
602: ELSE
603: RETURN FND_API.G_FALSE;
604: END IF;
605: END IF;

Line 603: RETURN FND_API.G_FALSE;

599: FETCH c_geos_exists INTO l_tmp;
600: IF l_tmp > 0 THEN
601: RETURN FND_API.G_TRUE;
602: ELSE
603: RETURN FND_API.G_FALSE;
604: END IF;
605: END IF;
606: IF p_obj_attribute = 'DELV' THEN
607: OPEN c_delv_exists(p_obj_id, p_obj_type);

Line 610: RETURN FND_API.G_TRUE;

606: IF p_obj_attribute = 'DELV' THEN
607: OPEN c_delv_exists(p_obj_id, p_obj_type);
608: FETCH c_delv_exists INTO l_tmp;
609: IF l_tmp > 0 THEN
610: RETURN FND_API.G_TRUE;
611: ELSE
612: RETURN FND_API.G_FALSE;
613: END IF;
614: END IF;

Line 612: RETURN FND_API.G_FALSE;

608: FETCH c_delv_exists INTO l_tmp;
609: IF l_tmp > 0 THEN
610: RETURN FND_API.G_TRUE;
611: ELSE
612: RETURN FND_API.G_FALSE;
613: END IF;
614: END IF;
615: IF p_obj_attribute = 'PROD' THEN
616: OPEN c_prod_exists(p_obj_id, p_obj_type);

Line 619: RETURN FND_API.G_TRUE;

615: IF p_obj_attribute = 'PROD' THEN
616: OPEN c_prod_exists(p_obj_id, p_obj_type);
617: FETCH c_prod_exists INTO l_tmp;
618: IF l_tmp > 0 THEN
619: RETURN FND_API.G_TRUE;
620: ELSE
621: RETURN FND_API.G_FALSE;
622: END IF;
623: END IF;

Line 621: RETURN FND_API.G_FALSE;

617: FETCH c_prod_exists INTO l_tmp;
618: IF l_tmp > 0 THEN
619: RETURN FND_API.G_TRUE;
620: ELSE
621: RETURN FND_API.G_FALSE;
622: END IF;
623: END IF;
624: IF p_obj_attribute = 'CELL' THEN
625: OPEN c_cell_exists(p_obj_id, p_obj_type);

Line 628: RETURN FND_API.G_TRUE;

624: IF p_obj_attribute = 'CELL' THEN
625: OPEN c_cell_exists(p_obj_id, p_obj_type);
626: FETCH c_cell_exists INTO l_tmp;
627: IF l_tmp > 0 THEN
628: RETURN FND_API.G_TRUE;
629: ELSE
630: RETURN FND_API.G_FALSE;
631: END IF;
632: END IF;

Line 630: RETURN FND_API.G_FALSE;

626: FETCH c_cell_exists INTO l_tmp;
627: IF l_tmp > 0 THEN
628: RETURN FND_API.G_TRUE;
629: ELSE
630: RETURN FND_API.G_FALSE;
631: END IF;
632: END IF;
633: IF p_obj_attribute = 'PTNR' THEN
634: OPEN c_ptnr_exists(p_obj_id, p_obj_type);

Line 637: RETURN FND_API.G_TRUE;

633: IF p_obj_attribute = 'PTNR' THEN
634: OPEN c_ptnr_exists(p_obj_id, p_obj_type);
635: FETCH c_ptnr_exists INTO l_tmp;
636: IF l_tmp > 0 THEN
637: RETURN FND_API.G_TRUE;
638: ELSE
639: RETURN FND_API.G_FALSE;
640: END IF;
641: END IF;

Line 639: RETURN FND_API.G_FALSE;

635: FETCH c_ptnr_exists INTO l_tmp;
636: IF l_tmp > 0 THEN
637: RETURN FND_API.G_TRUE;
638: ELSE
639: RETURN FND_API.G_FALSE;
640: END IF;
641: END IF;
642:
643: END check_attrib_exists;