APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT dependencies on HZ_GEOGRAPHY_TYPES_B

Line 67: FROM hz_geography_types_b

63:
64: BEGIN
65: SELECT count(*)
66: INTO l_count
67: FROM hz_geography_types_b
68: WHERE GEOGRAPHY_TYPE = UPPER(p_geography_type)
69: AND GEOGRAPHY_USE = decode(p_master_ref_flag,'Y','MASTER_REF',GEOGRAPHY_USE);
70:
71: IF l_count = 0 THEN

Line 75: fnd_message.set_token('TABLE', 'hz_geography_types_b');

71: IF l_count = 0 THEN
72: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
73: fnd_message.set_token('FK', 'geography_type');
74: fnd_message.set_token('COLUMN', 'geography_type');
75: fnd_message.set_token('TABLE', 'hz_geography_types_b');
76: fnd_msg_pub.add;
77: x_return_status := fnd_api.g_ret_sts_error;
78: END IF;
79:

Line 638: FROM hz_geography_types_b

634:
635: -- check for the uniqueness of geography_type
636:
637: SELECT count(*) INTO l_count
638: FROM hz_geography_types_b
639: WHERE geography_type=p_zone_type_rec.geography_type;
640:
641: IF l_count > 0 THEN
642: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');