8: p_zone_code_type IN VARCHAR2,
9: p_zone_name_prefix IN VARCHAR2,
10: p_start_date IN DATE,
11: p_end_date IN DATE,
12: p_zone_relation_tbl IN HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE,
13: x_zone_geography_id OUT NOCOPY NUMBER) IS
14:
15: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;
16: l_zone_name VARCHAR2(360);
11: p_end_date IN DATE,
12: p_zone_relation_tbl IN HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE,
13: x_zone_geography_id OUT NOCOPY NUMBER) IS
14:
15: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;
16: l_zone_name VARCHAR2(360);
17: i BINARY_INTEGER;
18: x_msg_count NUMBER;
19: x_msg_data VARCHAR2(2000);
36: l_zone_exists := 'FALSE';
37: END;
38:
39: IF l_zone_exists = 'FALSE' THEN
40: HZ_GEOGRAPHY_PUB.create_zone(
41: p_init_msg_list => 'T',
42: p_zone_type => p_zone_type,
43: p_zone_name => l_zone_name,
44: p_zone_code => p_zone_code,