APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CONTACT_POINTS

Line 3338: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

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;
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;

Line 3359: FROM hz_contact_points

3355: CURSOR c_cp (p_owner_table_name IN VARCHAR2,
3356: p_owner_table_id IN NUMBER,
3357: p_contact_point_type IN VARCHAR2) IS
3358: SELECT 'Y'
3359: FROM hz_contact_points
3360: WHERE owner_table_name = p_owner_table_name
3361: AND owner_table_id = p_owner_table_id
3362: AND contact_point_type = p_contact_point_type
3363: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (

Line 3503: hz_contact_points_pkg.insert_row (

3499: p_contact_point_rec.primary_by_purpose := 'N';
3500: END IF;
3501:
3502: -- Call table-handler.
3503: hz_contact_points_pkg.insert_row (
3504: x_contact_point_id => p_contact_point_rec.contact_point_id,
3505: x_contact_point_type => p_contact_point_rec.contact_point_type,
3506: x_status => p_contact_point_rec.status,
3507: x_owner_table_name => p_contact_point_rec.owner_table_name,

Line 3573: 'HZ_CONTACT_POINTS',

3569: /*
3570: per HLD,mosr record should not be created for copy case, since old osr is still active
3571: hz_orig_system_ref_pvt.create_mosr_for_merge(
3572: FND_API.G_FALSE,
3573: 'HZ_CONTACT_POINTS',
3574: p_contact_point_rec.contact_point_id,
3575: x_return_status,
3576: l_msg_count,
3577: l_msg_data);

Line 3604: UPDATE hz_contact_points

3600: ELSE
3601: l_contact_point_id := p_contact_point_id;
3602: END IF;
3603:
3604: UPDATE hz_contact_points
3605: SET primary_flag = 'N'
3606: WHERE owner_table_name = p_owner_table_name
3607: AND owner_table_id = p_owner_table_id
3608: AND contact_point_type = p_contact_point_type

Line 3655: UPDATE hz_contact_points

3651: ELSE
3652: l_contact_point_id := p_contact_point_id;
3653: END IF;
3654:
3655: UPDATE hz_contact_points
3656: SET primary_by_purpose = 'N'
3657: WHERE owner_table_name = p_owner_table_name
3658: AND owner_table_id = p_owner_table_id
3659: AND contact_point_type = p_contact_point_type

Line 3709: p_entity_name => 'HZ_CONTACT_POINTS',

3705: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3706:
3707: IF g_cpt_mixnmatch_enabled IS NULL THEN
3708: HZ_MIXNM_UTILITY.LoadDataSources(
3709: p_entity_name => 'HZ_CONTACT_POINTS',
3710: p_entity_attr_id => g_cpt_entity_attr_id,
3711: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
3712: p_selected_datasources => g_cpt_selected_datasources );
3713: END IF;

Line 3717: p_entity_name => 'HZ_CONTACT_POINTS',

3713: END IF;
3714: */
3715:
3716: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
3717: p_entity_name => 'HZ_CONTACT_POINTS',
3718: p_entity_attr_id => g_cpt_entity_attr_id,
3719: p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
3720: p_selected_datasources => g_cpt_selected_datasources,
3721: p_content_source_type => l_contact_point_rec.content_source_type,

Line 3811: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;

3807: x_msg_count OUT NOCOPY NUMBER,
3808: x_msg_data OUT NOCOPY VARCHAR2
3809: ) IS
3810:
3811: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3812:
3813: BEGIN
3814:
3815: -- Initialize API return status to success.

Line 3830: hz_contact_points_pkg.select_row(

3826:
3827: x_contact_point_rec.contact_point_id := p_contact_point_id;
3828:
3829: -- Call table-handler
3830: hz_contact_points_pkg.select_row(
3831: x_contact_point_id => x_contact_point_rec.contact_point_id,
3832: x_contact_point_type => x_contact_point_rec.contact_point_type,
3833: x_status => x_contact_point_rec.status,
3834: x_owner_table_name => x_contact_point_rec.owner_table_name,