DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on HZ_PARTIES

Line 653: FUNCTION validate_party_id(p_party_id IN hz_parties.party_id%TYPE)

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:

Line 658: CURSOR c_party(ci_party_id IN hz_parties.party_id%TYPE)

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

Line 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: