APPS.HZ_ORG_CONTACT_BO_PUB dependencies on HZ_PARTIES

Line 266: px_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

262: px_org_contact_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
263: END IF;
264: px_org_contact_rec.party_rel_rec.subject_id := p_person_id;
265: px_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
266: px_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
267: px_org_contact_rec.party_rel_rec.object_id := p_related_org_id;
268: px_org_contact_rec.party_rel_rec.object_type := 'ORGANIZATION';
269: px_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
270: px_org_contact_rec.party_rel_rec.relationship_code := p_org_contact_obj.relationship_code;

Line 269: px_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

265: px_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
266: px_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
267: px_org_contact_rec.party_rel_rec.object_id := p_related_org_id;
268: px_org_contact_rec.party_rel_rec.object_type := 'ORGANIZATION';
269: px_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
270: px_org_contact_rec.party_rel_rec.relationship_code := p_org_contact_obj.relationship_code;
271: px_org_contact_rec.party_rel_rec.relationship_type := p_org_contact_obj.relationship_type;
272: px_org_contact_rec.party_rel_rec.comments := p_org_contact_obj.relationship_comments;
273: px_org_contact_rec.party_rel_rec.start_date := p_org_contact_obj.start_date;

Line 326: FROM HZ_PARTIES per, HZ_ORIG_SYS_REFERENCES ref

322: l_eft_objs HZ_EFT_CP_BO_TBL;
323:
324: CURSOR get_per_id(l_os VARCHAR2, l_osr VARCHAR2) IS
325: SELECT per.party_id
326: FROM HZ_PARTIES per, HZ_ORIG_SYS_REFERENCES ref
327: WHERE ref.owner_table_id = per.party_id
328: AND ref.owner_table_name = 'HZ_PARTIES'
329: AND ref.orig_system = l_os
330: AND ref.orig_system_reference = l_osr

Line 328: AND ref.owner_table_name = 'HZ_PARTIES'

324: CURSOR get_per_id(l_os VARCHAR2, l_osr VARCHAR2) IS
325: SELECT per.party_id
326: FROM HZ_PARTIES per, HZ_ORIG_SYS_REFERENCES ref
327: WHERE ref.owner_table_id = per.party_id
328: AND ref.owner_table_name = 'HZ_PARTIES'
329: AND ref.orig_system = l_os
330: AND ref.orig_system_reference = l_osr
331: AND ref.status = 'A'
332: AND rownum = 1;

Line 336: FROM HZ_PARTIES

332: AND rownum = 1;
333:
334: CURSOR validate_per_id(l_per_id NUMBER) IS
335: SELECT 'X'
336: FROM HZ_PARTIES
337: WHERE party_id = l_per_id
338: AND party_type = 'PERSON'
339: AND status in ('A','I');
340: BEGIN

Line 611: p_contact_level_table => 'HZ_PARTIES',

607: (p_org_contact_obj.contact_pref_objs.COUNT > 0)) THEN
608: HZ_CONTACT_PREFERENCE_BO_PVT.create_contact_preferences(
609: p_cp_pref_objs => p_org_contact_obj.contact_pref_objs,
610: p_contact_level_table_id => l_party_id,
611: p_contact_level_table => 'HZ_PARTIES',
612: x_return_status => x_return_status,
613: x_msg_count => x_msg_count,
614: x_msg_data => x_msg_data
615: );

Line 931: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS rel, HZ_PARTIES p

927:
928: CURSOR get_ovn(l_oc_id NUMBER) IS
929: SELECT oc.object_version_number, rel.object_version_number, p.object_version_number,
930: p.party_id, rel.object_id, rel.subject_id
931: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS rel, HZ_PARTIES p
932: WHERE oc.org_contact_id = l_oc_id
933: AND oc.party_relationship_id = rel.relationship_id
934: AND rel.party_id = p.party_id
935: AND rel.subject_type = 'PERSON'

Line 942: FROM HZ_PARTIES

938: AND p.status in ('A','I');
939:
940: CURSOR get_per_ovn(l_per_id NUMBER) IS
941: SELECT object_version_number
942: FROM HZ_PARTIES
943: WHERE party_id = l_per_id
944: AND status in ('A','I');
945:
946: BEGIN

Line 1193: p_contact_level_table => 'HZ_PARTIES',

1189: (p_org_contact_obj.contact_pref_objs.COUNT > 0)) THEN
1190: HZ_CONTACT_PREFERENCE_BO_PVT.save_contact_preferences(
1191: p_cp_pref_objs => p_org_contact_obj.contact_pref_objs,
1192: p_contact_level_table_id => l_oc_party_id,
1193: p_contact_level_table => 'HZ_PARTIES',
1194: x_return_status => x_return_status,
1195: x_msg_count => x_msg_count,
1196: x_msg_data => x_msg_data
1197: );