APPS.OE_OE_FORM_HEADER dependencies on HZ_PHONE_FORMATS

Line 4023: from hz_phone_formats

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

Line 4102: from hz_phone_formats

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

Line 4109: from hz_phone_formats

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

Line 4115: from hz_phone_formats

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