DBA Data[Home] [Help]

APPS.IBE_PARTY_V2PVT dependencies on HZ_RELATIONSHIP_V2PUB

Line 621: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

617: x_return_status OUT NOCOPY VARCHAR2,
618: x_msg_count OUT NOCOPY NUMBER,
619: x_msg_data OUT NOCOPY VARCHAR2) is
620:
621: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
622: l_org_contact_party_id NUMBER;
623: l_rel_id NUMBER;
624: l_account_id NUMBER;
625: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

Line 2762: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

2758: SELECT contact_preference_id,object_version_number FROM hz_contact_preferences
2759: WHERE contact_level_table_id = c_party_id and contact_level_table = c_table_name
2760: and contact_type = 'ALL';
2761:
2762: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
2763: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
2764: l_location_rec HZ_LOCATION_V2PUB.location_rec_type := p_location_rec;
2765:
2766: l_party_id NUMBER;