APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 316: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

312: l_phone_rec phone_rec_type;
313: l_telex_rec telex_rec_type;
314: l_web_rec web_rec_type;
315: l_eft_rec eft_rec_type;
316: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
317:
318: l_phone_line_type VARCHAR2(30);
319: l_phone_country_code VARCHAR2(10);
320: l_phone_area_code VARCHAR2(10);

Line 897: hz_orig_system_ref_pub.create_orig_system_reference(

893: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';
894: l_orig_sys_reference_rec.owner_table_id := p_contact_point_rec.contact_point_id;
895: l_orig_sys_reference_rec.created_by_module := p_contact_point_rec.created_by_module;
896:
897: hz_orig_system_ref_pub.create_orig_system_reference(
898: FND_API.G_FALSE,
899: l_orig_sys_reference_rec,
900: x_return_status,
901: l_msg_count,

Line 3049: hz_orig_system_ref_pub.get_owner_table_id

3045: and p_contact_point_rec.orig_system <>fnd_api.g_miss_char)
3046: and (p_contact_point_rec.orig_system_reference is not null
3047: and p_contact_point_rec.orig_system_reference <>fnd_api.g_miss_char)
3048: and (p_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or p_contact_point_rec.contact_point_id is null) THEN
3049: hz_orig_system_ref_pub.get_owner_table_id
3050: (p_orig_system => p_contact_point_rec.orig_system,
3051: p_orig_system_reference => p_contact_point_rec.orig_system_reference,
3052: p_owner_table_name => 'HZ_CONTACT_POINTS',
3053: x_owner_table_id => l_contact_point_rec.contact_point_id,