APPS.OE_OE_FORM_HEADER dependencies on HZ_PHONE_FORMATS

Line 4020: from hz_phone_formats

4016: l_count number:=0;
4017: l_total_count number:=0;
4018: CURSOR c_formats( l_territory_code VARCHAR2) IS
4019: select phone_format_style,area_code_size
4020: from hz_phone_formats
4021: where territory_code=l_territory_code;
4022: l_ph_style_match Boolean;
4023: l_phone_length number;
4024: l_temp_phone_format Varchar2(500);

Line 4099: from hz_phone_formats

4095: IF l_user_territory_code IS NOT NULL THEN
4096: IF p_area_code IS NOT NULL THEN
4097: select Count(territory_code)
4098: into l_count
4099: from hz_phone_formats
4100: where territory_code=l_user_territory_code
4101: and area_code_size=length(p_area_code);
4102:
4103: IF l_count=0 THEN

Line 4106: from hz_phone_formats

4102:
4103: IF l_count=0 THEN
4104: select Count(territory_code)
4105: into l_count
4106: from hz_phone_formats
4107: where territory_code=l_user_territory_code
4108: and area_code_size=0;
4109:
4110: select Count(territory_code)

Line 4112: from hz_phone_formats

4108: and area_code_size=0;
4109:
4110: select Count(territory_code)
4111: into l_total_count
4112: from hz_phone_formats
4113: where territory_code=l_user_territory_code;
4114: oe_debug_pub.add('Entering Validate_Phone_Number-1x'||l_total_count,1);
4115:
4116: IF l_count=0 AND l_total_count=0 THEN