DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_ORIG_SYSTEM_REF_PUB

Line 888: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

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;

Line 1413: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

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';

Line 1787: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

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';

Line 2319: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

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

Line 3346: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

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: