APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CONTACT_POINTS

Line 3353: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

3349: l_msg_data VARCHAR2(2000);
3350:
3351: l_formatted_phone_number VARCHAR2(100);
3352: l_country_code hz_locations.country%TYPE;
3353: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3354:
3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3357: l_email_rec hz_contact_point_v2pub.email_rec_type;

Line 3374: FROM hz_contact_points

3370: CURSOR c_cp (p_owner_table_name IN VARCHAR2,
3371: p_owner_table_id IN NUMBER,
3372: p_contact_point_type IN VARCHAR2) IS
3373: SELECT 'Y'
3374: FROM hz_contact_points
3375: WHERE owner_table_name = p_owner_table_name
3376: AND owner_table_id = p_owner_table_id
3377: AND contact_point_type = p_contact_point_type
3378: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (

Line 3539: hz_contact_points_pkg.insert_row (

3535: END IF;
3536: --End of bug 7299887
3537:
3538: -- Call table-handler.
3539: hz_contact_points_pkg.insert_row (
3540: x_contact_point_id => p_contact_point_rec.contact_point_id,
3541: x_contact_point_type => p_contact_point_rec.contact_point_type,
3542: x_status => p_contact_point_rec.status,
3543: x_owner_table_name => p_contact_point_rec.owner_table_name,

Line 3609: 'HZ_CONTACT_POINTS',

3605: /*
3606: per HLD,mosr record should not be created for copy case, since old osr is still active
3607: hz_orig_system_ref_pvt.create_mosr_for_merge(
3608: FND_API.G_FALSE,
3609: 'HZ_CONTACT_POINTS',
3610: p_contact_point_rec.contact_point_id,
3611: x_return_status,
3612: l_msg_count,
3613: l_msg_data);

Line 3640: UPDATE hz_contact_points

3636: ELSE
3637: l_contact_point_id := p_contact_point_id;
3638: END IF;
3639:
3640: UPDATE hz_contact_points
3641: SET primary_flag = 'N'
3642: WHERE owner_table_name = p_owner_table_name
3643: AND owner_table_id = p_owner_table_id
3644: AND contact_point_type = p_contact_point_type

Line 3691: UPDATE hz_contact_points

3687: ELSE
3688: l_contact_point_id := p_contact_point_id;
3689: END IF;
3690:
3691: UPDATE hz_contact_points
3692: SET primary_by_purpose = 'N'
3693: WHERE owner_table_name = p_owner_table_name
3694: AND owner_table_id = p_owner_table_id
3695: AND contact_point_type = p_contact_point_type

Line 3745: p_entity_name => 'HZ_CONTACT_POINTS',

3741: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3742:
3743: IF g_cpt_mixnmatch_enabled IS NULL THEN
3744: HZ_MIXNM_UTILITY.LoadDataSources(
3745: p_entity_name => 'HZ_CONTACT_POINTS',
3746: p_entity_attr_id => g_cpt_entity_attr_id,
3747: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
3748: p_selected_datasources => g_cpt_selected_datasources );
3749: END IF;

Line 3753: p_entity_name => 'HZ_CONTACT_POINTS',

3749: END IF;
3750: */
3751:
3752: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
3753: p_entity_name => 'HZ_CONTACT_POINTS',
3754: p_entity_attr_id => g_cpt_entity_attr_id,
3755: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
3756: p_selected_datasources => g_cpt_selected_datasources,
3757: p_content_source_type => l_contact_point_rec.content_source_type,

Line 3849: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

3845: x_msg_count OUT NOCOPY NUMBER,
3846: x_msg_data OUT NOCOPY VARCHAR2
3847: ) IS
3848:
3849: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3850:
3851: BEGIN
3852:
3853: -- Initialize API return status to success.

Line 3868: hz_contact_points_pkg.select_row(

3864:
3865: x_contact_point_rec.contact_point_id := p_contact_point_id;
3866:
3867: -- Call table-handler
3868: hz_contact_points_pkg.select_row(
3869: x_contact_point_id => x_contact_point_rec.contact_point_id,
3870: x_contact_point_type => x_contact_point_rec.contact_point_type,
3871: x_status => x_contact_point_rec.status,
3872: x_owner_table_name => x_contact_point_rec.owner_table_name,