[Home] [Help]
261: pv_enty_attr_values PEAV,
262: hz_parties PARTNER,
263: hz_organization_profiles HZOP,
264: hz_parties INTERNAL,
265: hz_relationships HZR,
266: pv_partner_profiles PVPP
267: WHERE HZR.party_id = PVPP.partner_id
268: AND HZR.object_id = INTERNAL.party_id
269: AND HZR.subject_id = PVPP.partner_party_id
634: pv_enty_attr_values PEAV,
635: hz_parties PARTNER,
636: hz_organization_profiles HZOP,
637: hz_parties INTERNAL,
638: hz_relationships HZR,
639: pv_partner_profiles PVPP
640: WHERE HZR.party_id = PVPP.partner_id
641: AND HZR.object_id = INTERNAL.party_id
642: AND HZR.subject_id = PVPP.partner_party_id
1049: cv_partner_party_id NUMBER) IS
1050: SELECT hzr.relationship_id relationship_id,
1051: hzp.party_id party_id,
1052: hzp.party_number party_number
1053: FROM hz_relationships hzr,
1054: hz_parties hzp
1055: WHERE hzr.subject_id = cv_partner_party_id
1056: AND hzr.object_id = cv_vendor_party_id
1057: AND hzr.status = 'A'
1962: -- * Partner Party Site record in HZ_PARTY_SITES table
1963: -- * Call the Create_Relationship API to create the followings -
1964: -- o Get the Default responsibility for the supplied Organization Id
1965: -- o Get the default vendor org id, for the supplied Responsibility id
1966: -- o Create Partner Relationship record in HZ_RELATIONSHIPS table
1967: -- o Create resource for the partner by calling the Admin_Resource API
1968: -- o Create role for the resource by calling Admin_Role API
1969: -- o Create Group for the partner resource by calling Admin_Group API
1970:
2088: l_org_contact_rec.party_rel_rec.application_id:= l_application_id;
2089: l_org_contact_rec.party_rel_rec.status:= 'A';
2090:
2091: -- Call the Create_Org_Contact API to create a contact person relationship record
2092: -- with the Partner organization in HZ_RELATIONSHIPS table.
2093: HZ_PARTY_CONTACT_V2PUB.create_org_contact (
2094: p_init_msg_list => FND_API.G_FALSE,
2095: p_org_contact_rec => l_org_contact_rec,
2096: x_org_contact_id => l_org_contact_id,