DBA Data[Home] [Help]

APPS.POS_SUPP_CONTACT_PKG dependencies on HZ_RELATIONSHIP_V2PUB

Line 17: l_rel_rec hz_relationship_v2pub.relationship_rec_type;

13: x_msg_data OUT nocopy VARCHAR2,
14: x_rel_party_id OUT nocopy NUMBER
15: )
16: IS
17: l_rel_rec hz_relationship_v2pub.relationship_rec_type;
18: l_rel_party_rec hz_party_v2pub.party_rec_type;
19: l_rel_party_number hz_parties.party_number%TYPE;
20: l_rel_id NUMBER;
21: l_rel_party_id NUMBER;

Line 415: l_rel_rec hz_relationship_v2pub.relationship_rec_type;

411:
412: l_rec2 l_cur2%ROWTYPE;
413:
414: l_org_contact_rec hz_party_contact_v2pub.org_contact_rec_type;
415: l_rel_rec hz_relationship_v2pub.relationship_rec_type;
416: l_rel_party_id NUMBER;
417: l_found_org_contact BOOLEAN;
418: l_enddate_changed BOOLEAN;
419:

Line 476: HZ_RELATIONSHIP_V2PUB.get_relationship_rec (

472: CLOSE l_cur2;
473:
474: IF l_found_org_contact THEN
475: -- retrieve the relation record
476: HZ_RELATIONSHIP_V2PUB.get_relationship_rec (
477: p_relationship_id => l_rec2.relationship_id,
478: p_directional_flag => 'F',
479: x_rel_rec => l_rel_rec,
480: x_return_status => x_return_status,