APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_PHONE_NUMBER_PKG

Line 617: l_transposed_phone_no := hz_phone_number_pkg.transpose(phone_rec.phone_country_code

613: x_generate_party_number := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
614: x_gen_contact_number := fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER');
615: x_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
616: x_hz_dup_check := fnd_profile.value('AMS_HZ_DEDUPE_RULE');
617: l_transposed_phone_no := hz_phone_number_pkg.transpose(phone_rec.phone_country_code
618: ||phone_rec.phone_area_code||phone_rec.phone_number);
619:
620: x_email_address := email_rec.email_address;
621:

Line 627: l_org_transposed_phone_no := hz_phone_number_pkg.transpose(org_phone_rec.phone_country_code

623: x_org_email_address := org_email_rec.email_address;
624:
625:
626:
627: l_org_transposed_phone_no := hz_phone_number_pkg.transpose(org_phone_rec.phone_country_code
628: ||org_phone_rec.phone_area_code||org_phone_rec.phone_number);
629:
630: l_org_ps_transposed_phone_no := hz_phone_number_pkg.transpose(org_party_site_phone_rec.phone_country_code
631: ||org_party_site_phone_rec.phone_area_code||org_party_site_phone_rec.phone_number);

Line 630: l_org_ps_transposed_phone_no := hz_phone_number_pkg.transpose(org_party_site_phone_rec.phone_country_code

626:
627: l_org_transposed_phone_no := hz_phone_number_pkg.transpose(org_phone_rec.phone_country_code
628: ||org_phone_rec.phone_area_code||org_phone_rec.phone_number);
629:
630: l_org_ps_transposed_phone_no := hz_phone_number_pkg.transpose(org_party_site_phone_rec.phone_country_code
631: ||org_party_site_phone_rec.phone_area_code||org_party_site_phone_rec.phone_number);
632:
633:
634:

Line 3832: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_phone_area_code||p_phone_number);

3828: p_key_type => 'PERSON',
3829: p_first_name => p_per_first_name,
3830: p_last_name => p_per_last_name
3831: );
3832: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_phone_area_code||p_phone_number);
3833:
3834: end if;
3835: --
3836: -- If customer does not exists then it's a new customer.

Line 4476: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_ph_country_code||p_ph_area_code||p_ph_number)

4472: p_key_type => 'PERSON',
4473: p_first_name => p_per_first_name,
4474: p_last_name => p_per_last_name
4475: );
4476: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_ph_country_code||p_ph_area_code||p_ph_number)
4477: ;
4478: IF p_orig_system_reference IS NULL then
4479: open c_person_exists;
4480: fetch c_person_exists into l_cust_exists;

Line 4766: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_ph_country_code||p_ph_area_code||p_ph_number)

4762: p_key_type => 'PERSON',
4763: p_first_name => p_per_first_name,
4764: p_last_name => p_per_last_name
4765: );
4766: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_ph_country_code||p_ph_area_code||p_ph_number)
4767: ;
4768: IF p_orig_system_reference IS NULL then
4769: open c_person_exists;
4770: fetch c_person_exists into l_cust_exists;