APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_PHONE_NUMBER_PKG

Line 1109: transposed_phone_number = hz_phone_number_pkg.transpose(

1105: Update hz_contact_points SET
1106: phone_number = l_phone_number(i),
1107: phone_area_code = l_phone_area_code(i),
1108: phone_country_code = l_country_code(i),
1109: transposed_phone_number = hz_phone_number_pkg.transpose(
1110: l_country_code(i)||l_phone_area_code(i)||l_phone_number(i))
1111: Where contact_point_id = l_contact_point_id(i);
1112:
1113: ELSIF l_raw_phone_number(i) IS NULL THEN /* Phone Number is passed */

Line 1116: transposed_phone_number = hz_phone_number_pkg.transpose(

1112:
1113: ELSIF l_raw_phone_number(i) IS NULL THEN /* Phone Number is passed */
1114: Update hz_contact_points SET
1115: raw_phone_number = l_phone_area_code(i) || '-' || l_phone_number(i),
1116: transposed_phone_number = hz_phone_number_pkg.transpose(
1117: l_country_code(i)||l_phone_area_code(i)||l_phone_number(i))
1118: Where contact_point_id = l_contact_point_id(i);
1119: END IF;
1120: