1588: -- get party preference if it is a valid party and
1589: -- has preferences
1590:
1591: l_user_territory_code :=
1592: hz_preference_pub.value_varchar2(
1593: p_customer_id,'TCA Phone','USER_TERRITORY_CODE');
1594:
1595: l_default_area_code :=
1596: hz_preference_pub.value_varchar2(
1592: hz_preference_pub.value_varchar2(
1593: p_customer_id,'TCA Phone','USER_TERRITORY_CODE');
1594:
1595: l_default_area_code :=
1596: hz_preference_pub.value_varchar2(
1597: p_customer_id,'TCA Phone','DEFAULT_AREA_CODE');
1598:
1599: l_display_area_code :=
1600: hz_preference_pub.value_varchar2(
1596: hz_preference_pub.value_varchar2(
1597: p_customer_id,'TCA Phone','DEFAULT_AREA_CODE');
1598:
1599: l_display_area_code :=
1600: hz_preference_pub.value_varchar2(
1601: p_customer_id,'TCA Phone','DISPLAY_AREA_CODE');
1602:
1603: l_display_all_prefixes :=
1604: hz_preference_pub.value_varchar2(
1600: hz_preference_pub.value_varchar2(
1601: p_customer_id,'TCA Phone','DISPLAY_AREA_CODE');
1602:
1603: l_display_all_prefixes :=
1604: hz_preference_pub.value_varchar2(
1605: p_customer_id,'TCA Phone','DISPLAY_ALL_PREFIXES');
1606:
1607: l_pabx_prefix :=
1608: hz_preference_pub.value_varchar2(
1604: hz_preference_pub.value_varchar2(
1605: p_customer_id,'TCA Phone','DISPLAY_ALL_PREFIXES');
1606:
1607: l_pabx_prefix :=
1608: hz_preference_pub.value_varchar2(
1609: p_customer_id,'TCA Phone','PABX_PREFIX');
1610:
1611: pref_user_territory_code_tab(p_customer_id) := l_user_territory_code;
1612: pref_default_area_code_tab(p_customer_id) := l_default_area_code;