884: l_msg_count NUMBER;
885: l_msg_data VARCHAR2(2000);
886: l_dummy VARCHAR2(1);
887: l_debug_prefix VARCHAR2(30) := '';
888: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
889:
890: BEGIN
891:
892: l_party_rec.orig_system_reference := null;
1409: l_msg_count NUMBER;
1410: l_msg_data VARCHAR2(2000);
1411: l_dummy VARCHAR2(1);
1412: l_debug_prefix VARCHAR2(30);
1413: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1414: BEGIN
1415:
1416: --Initialize the created by module
1417: p_org_contact_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';
1783: l_debug_prefix VARCHAR2(30) := '';
1784:
1785: -- Bug 2197181
1786: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
1787: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1788: BEGIN
1789:
1790: --Initialize the created by module
1791: p_party_site_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';
2315: l_msg_data VARCHAR2(2000);
2316:
2317: l_location_id NUMBER;
2318: l_loc_id NUMBER;
2319: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2320:
2321: BEGIN
2322:
2323: --Initialize the created by module
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;
3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3345: l_web_rec hz_contact_point_v2pub.web_rec_type;
3346: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3347:
3348: -- Bug 2197181: added for mix-n-match project: the contact point
3349: -- must be visible.
3350: