APPS.HZ_MAP_PARTY_PUB dependencies on HZ_RELATIONSHIP_V2PUB

Line 1236: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

1232: AND status = 'N';
1233:
1234: l_interface_rec HZ_PARTY_INTERFACE%ROWTYPE;
1235: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
1236: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
1237: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
1238:
1239: l_displayed_duns_party_id NUMBER := NULL;
1240: l_party_id NUMBER := NULL;

Line 6115: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

6111: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
6112: l_location_rec hz_location_v2pub.location_rec_type;
6113: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
6114: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
6115: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
6116:
6117: l_msg_count NUMBER;
6118: l_msg_data VARCHAR2(2000);
6119: l_count NUMBER;

Line 6379: p_party_rel_rec IN OUT NOCOPY HZ_RELATIONSHIP_V2PUB.relationship_rec_type,

6375: | the rel with changed duns number for subject_id
6376: +===========================================================================*/
6377:
6378: procedure store_party_rel(
6379: p_party_rel_rec IN OUT NOCOPY HZ_RELATIONSHIP_V2PUB.relationship_rec_type,
6380: x_return_status IN OUT NOCOPY VARCHAR2
6381: ) IS
6382:
6383: CURSOR c_old_party_rel IS

Line 6420: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

6416: l_old_duns_number hz_organization_profiles.duns_number_c%TYPE;
6417: l_new_duns_number hz_organization_profiles.duns_number_c%TYPE;
6418: l_old_subject_id NUMBER;
6419:
6420: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
6421: l_create_rel BOOLEAN := TRUE;
6422:
6423: i NUMBER := 0;
6424:

Line 6487: HZ_RELATIONSHIP_V2PUB.update_relationship(

6483: l_party_rel_rec.relationship_id := l_rel_id;
6484: l_party_rel_rec.created_by_module := NULL;
6485: l_party_rel_rec.application_id := NULL;
6486:
6487: HZ_RELATIONSHIP_V2PUB.update_relationship(
6488: 'F',
6489: l_party_rel_rec,
6490: l_obj_ver_no,
6491: l_object_version_number2,

Line 6562: HZ_RELATIONSHIP_V2PUB.update_relationship(

6558: l_object_version_number2 := NULL;
6559: l_party_rel_rec.relationship_id := l_old_rel_ids(i);
6560: l_party_rel_rec.created_by_module := NULL;
6561: l_party_rel_rec.application_id := NULL;
6562: HZ_RELATIONSHIP_V2PUB.update_relationship(
6563: 'F',
6564: l_party_rel_rec,
6565: l_object_version_number1,
6566: l_object_version_number2,

Line 6594: HZ_RELATIONSHIP_V2PUB.create_relationship(

6590: arp_util.debug('HZ_MAP_PARTY_PUB.store_party_rel p_party_rel_rec.subject_id = ' || p_party_rel_rec.subject_id );
6591: arp_util.debug('HZ_MAP_PARTY_PUB.store_party_rel p_party_rel_rec.subject_type = ' || p_party_rel_rec.subject_type );
6592:
6593: p_party_rel_rec.created_by_module := 'TCA_DNB_MAPPING';
6594: HZ_RELATIONSHIP_V2PUB.create_relationship(
6595: 'F',
6596: p_party_rel_rec,
6597: x_relationship_id,
6598: x_party_id,