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 1415: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

1411: l_msg_count NUMBER;
1412: l_msg_data VARCHAR2(2000);
1413: l_dummy VARCHAR2(1);
1414: l_debug_prefix VARCHAR2(30);
1415: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1416: BEGIN
1417:
1418: --Initialize the created by module
1419: p_org_contact_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';

Line 1791: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

1787: l_debug_prefix VARCHAR2(30) := '';
1788:
1789: -- Bug 2197181
1790: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
1791: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1792: BEGIN
1793:
1794: --Initialize the created by module
1795: p_party_site_rec.created_by_module := 'HZ_TCA_CUSTOMER_MERGE';

Line 2325: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

2321: l_msg_data VARCHAR2(2000);
2322:
2323: l_location_id NUMBER;
2324: l_loc_id NUMBER;
2325: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
2326:
2327: BEGIN
2328:
2329: --Initialize the created by module

Line 3361: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

3357: l_email_rec hz_contact_point_v2pub.email_rec_type;
3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3360: l_web_rec hz_contact_point_v2pub.web_rec_type;
3361: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3362:
3363: -- Bug 2197181: added for mix-n-match project: the contact point
3364: -- must be visible.
3365: