DBA Data[Home] [Help]

APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 306: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

302: l_phone_rec phone_rec_type;
303: l_telex_rec telex_rec_type;
304: l_web_rec web_rec_type;
305: l_eft_rec eft_rec_type;
306: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
307:
308: l_phone_line_type VARCHAR2(30);
309: l_phone_country_code VARCHAR2(10);
310: l_phone_area_code VARCHAR2(10);

Line 884: hz_orig_system_ref_pub.create_orig_system_reference(

880: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';
881: l_orig_sys_reference_rec.owner_table_id := p_contact_point_rec.contact_point_id;
882: l_orig_sys_reference_rec.created_by_module := p_contact_point_rec.created_by_module;
883:
884: hz_orig_system_ref_pub.create_orig_system_reference(
885: FND_API.G_FALSE,
886: l_orig_sys_reference_rec,
887: x_return_status,
888: l_msg_count,

Line 2893: hz_orig_system_ref_pub.get_owner_table_id

2889: and p_contact_point_rec.orig_system <>fnd_api.g_miss_char)
2890: and (p_contact_point_rec.orig_system_reference is not null
2891: and p_contact_point_rec.orig_system_reference <>fnd_api.g_miss_char)
2892: and (p_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or p_contact_point_rec.contact_point_id is null) THEN
2893: hz_orig_system_ref_pub.get_owner_table_id
2894: (p_orig_system => p_contact_point_rec.orig_system,
2895: p_orig_system_reference => p_contact_point_rec.orig_system_reference,
2896: p_owner_table_name => 'HZ_CONTACT_POINTS',
2897: x_owner_table_id => l_contact_point_rec.contact_point_id,