DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on HZ_PARTIES

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

674: END IF;
675:
676: END check_lookup_val;
677:
678: FUNCTION validate_party_id(p_party_id IN hz_parties.party_id%TYPE)
679: RETURN BOOLEAN
680: IS
681: l_count NUMBER;
682:

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

679: RETURN BOOLEAN
680: IS
681: l_count NUMBER;
682:
683: CURSOR c_party(ci_party_id IN hz_parties.party_id%TYPE)
684: IS
685: SELECT COUNT(party_id)
686: INTO l_count
687: FROM hz_parties

Line 687: FROM hz_parties

683: CURSOR c_party(ci_party_id IN hz_parties.party_id%TYPE)
684: IS
685: SELECT COUNT(party_id)
686: INTO l_count
687: FROM hz_parties
688: WHERE party_id = ci_party_id;
689: BEGIN
690: IF (c_party%ISOPEN) THEN CLOSE c_party; END IF;
691: