DBA Data[Home] [Help]

APPS.HZ_FORMAT_PHONE_V2PUB dependencies on HZ_PREFERENCE_PUB

Line 1592: hz_preference_pub.value_varchar2(

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(

Line 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(

Line 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(

Line 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(

Line 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;