APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_TYPES_B

Line 2365: ,hz_geography_types_b tp

2361: BEGIN
2362: SELECT st.geography_type
2363: INTO l_child_geo_type
2364: FROM hz_geo_structure_levels st
2365: ,hz_geography_types_b tp
2366: WHERE st.country_code = l_country_code
2367: AND st.parent_geography_type = l_parent_geo_type
2368: AND st.geography_type = tp.geography_type
2369: AND tp.geography_use = 'MASTER_REF'

Line 2502: FROM hz_geography_types_b

2498: x_return_status => x_return_status);
2499:
2500: -- get geography use
2501: SELECT geography_use INTO l_geography_use
2502: FROM hz_geography_types_b
2503: WHERE geography_type=l_zone_type;
2504:
2505: hz_geography_ranges_pkg.insert_row (
2506: x_rowid => l_rowid,

Line 2685: FROM hz_geography_types_b

2681: RAISE FND_API.G_EXC_ERROR;
2682: END IF;
2683:
2684: SELECT geography_use,limited_by_geography_id INTO l_geography_use,l_limited_by_geography_id
2685: FROM hz_geography_types_b
2686: WHERE geography_type = l_zone_type;
2687:
2688: l_zone_relation_rec.geography_id := p_geography_id;
2689:

Line 2958: FROM hz_geography_types_b

2954: -- get geography_use
2955: BEGIN
2956:
2957: SELECT geography_use,limited_by_geography_id INTO l_geography_use,l_limited_by_geography_id
2958: FROM hz_geography_types_b
2959: WHERE geography_type = p_zone_type;
2960:
2961: EXCEPTION WHEN NO_DATA_FOUND THEN
2962: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

2961: EXCEPTION WHEN NO_DATA_FOUND THEN
2962: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2963: fnd_message.set_token('FK', 'geography_type');
2964: fnd_message.set_token('COLUMN','zone_type');
2965: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2966: fnd_msg_pub.add;
2967: RAISE FND_API.G_EXC_ERROR;
2968: END;
2969: