APPS.WSH_SITE_CONTACT_PERSON_PKG dependencies on HZ_PARTIES

Line 177: l_ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

173:
174: -- Create Org Contact
175:
176: l_ocon_rec.party_rel_rec.subject_id := l_person_party_id;
177: l_ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
178: l_ocon_rec.party_rel_rec.subject_type := 'PERSON';
179: l_ocon_rec.party_rel_rec.object_id := p_carrier_party_id;
180: l_ocon_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
181: l_ocon_rec.party_rel_rec.object_type := 'ORGANIZATION';

Line 180: l_ocon_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

176: l_ocon_rec.party_rel_rec.subject_id := l_person_party_id;
177: l_ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
178: l_ocon_rec.party_rel_rec.subject_type := 'PERSON';
179: l_ocon_rec.party_rel_rec.object_id := p_carrier_party_id;
180: l_ocon_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
181: l_ocon_rec.party_rel_rec.object_type := 'ORGANIZATION';
182: l_ocon_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
183: l_ocon_rec.party_rel_rec.relationship_type := 'CONTACT';
184: l_ocon_rec.party_rel_rec.status := 'A';

Line 241: l_contact_points_rec_type.owner_table_name := 'HZ_PARTIES';

237:
238: -- Create a EMAIL contact point
239:
240: l_contact_points_rec_type.contact_point_type := 'EMAIL';
241: l_contact_points_rec_type.owner_table_name := 'HZ_PARTIES';
242: l_contact_points_rec_type.owner_table_id := l_party_id;
243: l_contact_points_rec_type.primary_flag := 'Y';
244: l_contact_points_rec_type.status := p_status;
245: l_contact_points_rec_type.created_by_module := 'ORACLE_SHIPPING';

Line 346: from hz_parties

342: l_cont_point_version number;
343:
344: CURSOR Get_Object_Version_Number(p_person_party_id NUMBER) IS
345: select object_version_number
346: from hz_parties
347: where party_id = p_person_party_id;
348:
349: CURSOR Get_Contact_Object_Version(p_org_contact_id NUMBER) IS
350: select object_version_number