179: * 11-22-2002 Rekha Nalluri o Created.
180: *
181: */
182: PROCEDURE validate_master_relation (
183: p_master_relation_rec IN HZ_GEOGRAPHY_PUB.master_relation_rec_type,
184: p_create_update_flag IN VARCHAR2,
185: x_return_status IN OUT NOCOPY VARCHAR2
186: )IS
187:
340: *
341: */
342:
343: PROCEDURE validate_geo_identifier (
344: p_geo_identifier_rec IN HZ_GEOGRAPHY_PUB.geo_identifier_rec_type,
345: p_create_update_flag IN VARCHAR2,
346: x_return_status IN OUT NOCOPY VARCHAR2
347: )IS
348:
523: *
524: */
525:
526: PROCEDURE validate_master_geography (
527: p_master_geography_rec IN HZ_GEOGRAPHY_PUB.master_geography_rec_type,
528: p_create_update_flag IN VARCHAR2,
529: x_return_status IN OUT NOCOPY VARCHAR2
530: ) IS
531:
529: x_return_status IN OUT NOCOPY VARCHAR2
530: ) IS
531:
532: l_count NUMBER;
533: l_parent_geography_tbl HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;
534: l_start_date DATE;
535: l_end_date DATE;
536: l_last NUMBER;
537: --l_geography_type VARCHAR2(30);
723: *
724: */
725:
726: PROCEDURE validate_geography_range (
727: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.geography_range_rec_type,
728: p_create_update_flag IN VARCHAR2,
729: x_return_status IN OUT NOCOPY VARCHAR2
730: ) IS
731: