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 3839: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_phone_area_code||p_phone_number);

3835: p_key_type => 'PERSON',
3836: p_first_name => p_per_first_name,
3837: p_last_name => p_per_last_name
3838: );
3839: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_phone_area_code||p_phone_number);
3840:
3841: end if;
3842: --
3843: -- If customer does not exists then it's a new customer.

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

4479: p_key_type => 'PERSON',
4480: p_first_name => p_per_first_name,
4481: p_last_name => p_per_last_name
4482: );
4483: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_ph_country_code||p_ph_area_code||p_ph_number)
4484: ;
4485: IF p_orig_system_reference IS NULL then
4486: open c_person_exists;
4487: fetch c_person_exists into l_cust_exists;

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

4769: p_key_type => 'PERSON',
4770: p_first_name => p_per_first_name,
4771: p_last_name => p_per_last_name
4772: );
4773: l_transposed_phone_no := hz_phone_number_pkg.transpose(p_ph_country_code||p_ph_area_code||p_ph_number)
4774: ;
4775: IF p_orig_system_reference IS NULL then
4776: open c_person_exists;
4777: fetch c_person_exists into l_cust_exists;