APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_LOCATIONS

Line 1786: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;

1782: l_dummy VARCHAR2(1);
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

Line 1800: from hz_locations

1796:
1797: -- Bug 2197181
1798: select actual_content_source
1799: into l_loc_actual_content_source
1800: from hz_locations
1801: where location_id = p_party_site_rec.location_id;
1802:
1803: /* SSM SST Integration and Extension
1804: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.

Line 1961: SELECT * FROM hz_locations

1957: p_location_id IN NUMBER
1958: ) IS
1959:
1960: CURSOR c_loc IS
1961: SELECT * FROM hz_locations
1962: WHERE location_id = p_location_id;
1963:
1964: CURSOR c_party IS
1965: SELECT 'Y'

Line 2105: p_entity_name => 'HZ_LOCATIONS',

2101: -- sources for this entity.
2102: /*
2103: IF g_pst_mixnmatch_enabled IS NULL THEN
2104: HZ_MIXNM_UTILITY.LoadDataSources(
2105: p_entity_name => 'HZ_LOCATIONS',
2106: p_entity_attr_id => g_pst_entity_attr_id,
2107: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
2108: p_selected_datasources => g_pst_selected_datasources );
2109: END IF;

Line 3337: l_country_code hz_locations.country%TYPE;

3333: l_msg_count NUMBER;
3334: l_msg_data VARCHAR2(2000);
3335:
3336: l_formatted_phone_number VARCHAR2(100);
3337: l_country_code hz_locations.country%TYPE;
3338: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3339:
3340: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;