APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_TYPES_B

Line 2378: ,hz_geography_types_b tp

2374: BEGIN
2375: SELECT st.geography_type
2376: INTO l_child_geo_type
2377: FROM hz_geo_structure_levels st
2378: ,hz_geography_types_b tp
2379: WHERE st.country_code = l_country_code
2380: AND st.parent_geography_type = l_parent_geo_type
2381: AND st.geography_type = tp.geography_type
2382: AND tp.geography_use = 'MASTER_REF'

Line 2515: FROM hz_geography_types_b

2511: x_return_status => x_return_status);
2512:
2513: -- get geography use
2514: SELECT geography_use INTO l_geography_use
2515: FROM hz_geography_types_b
2516: WHERE geography_type=l_zone_type;
2517:
2518: hz_geography_ranges_pkg.insert_row (
2519: x_rowid => l_rowid,

Line 2698: FROM hz_geography_types_b

2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696:
2697: SELECT geography_use,limited_by_geography_id INTO l_geography_use,l_limited_by_geography_id
2698: FROM hz_geography_types_b
2699: WHERE geography_type = l_zone_type;
2700:
2701: l_zone_relation_rec.geography_id := p_geography_id;
2702:

Line 2971: FROM hz_geography_types_b

2967: -- get geography_use
2968: BEGIN
2969:
2970: SELECT geography_use,limited_by_geography_id INTO l_geography_use,l_limited_by_geography_id
2971: FROM hz_geography_types_b
2972: WHERE geography_type = p_zone_type;
2973:
2974: EXCEPTION WHEN NO_DATA_FOUND THEN
2975: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 2978: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');

2974: EXCEPTION WHEN NO_DATA_FOUND THEN
2975: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2976: fnd_message.set_token('FK', 'geography_type');
2977: fnd_message.set_token('COLUMN','zone_type');
2978: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2979: fnd_msg_pub.add;
2980: RAISE FND_API.G_EXC_ERROR;
2981: END;
2982: