DBA Data[Home] [Help]

APPS.ZX_GEO_JUR_MIGR_PKG dependencies on HZ_GEOGRAPHY_PUB

Line 12: p_zone_relation_tbl IN HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE,

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);

Line 15: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;

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);

Line 40: HZ_GEOGRAPHY_PUB.create_zone(

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,