649: END IF;
650:
651: END check_lookup_val;
652:
653: FUNCTION validate_party_id(p_party_id IN hz_parties.party_id%TYPE)
654: RETURN BOOLEAN
655: IS
656: l_count NUMBER;
657:
654: RETURN BOOLEAN
655: IS
656: l_count NUMBER;
657:
658: CURSOR c_party(ci_party_id IN hz_parties.party_id%TYPE)
659: IS
660: SELECT COUNT(party_id)
661: INTO l_count
662: FROM hz_parties
658: CURSOR c_party(ci_party_id IN hz_parties.party_id%TYPE)
659: IS
660: SELECT COUNT(party_id)
661: INTO l_count
662: FROM hz_parties
663: WHERE party_id = ci_party_id;
664: BEGIN
665: IF (c_party%ISOPEN) THEN CLOSE c_party; END IF;
666: