670:
671: RETURN (l_count>0);
672: END validate_party_id;
673:
674: FUNCTION validate_app_id(p_app_id IN fnd_application.application_id%TYPE)
675: RETURN BOOLEAN
676: IS
677: l_count NUMBER;
678:
675: RETURN BOOLEAN
676: IS
677: l_count NUMBER;
678:
679: CURSOR c_app(ci_app_id IN fnd_application.application_id%TYPE)
680: IS
681: SELECT count(*)
682: FROM fnd_application
683: WHERE (application_id = ci_app_id);
678:
679: CURSOR c_app(ci_app_id IN fnd_application.application_id%TYPE)
680: IS
681: SELECT count(*)
682: FROM fnd_application
683: WHERE (application_id = ci_app_id);
684:
685: BEGIN
686: IF (c_app%ISOPEN) THEN CLOSE c_app; END IF;