PACKAGE: APPS.ZX_GEO_JUR_MIGR_PKG

Source

1 PACKAGE ZX_GEO_JUR_MIGR_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxgeojurmigrs.pls 120.8 2005/10/14 22:52:46 sachandr ship $ */
3 
4 
5 /*THIS PROCEDURE IS USED TO CREATE GEOGRAPHY TYPES */
6 PROCEDURE CREATE_GEO_TYPE;
7 PROCEDURE CREATE_ZONE_TYPE;
8 
9 
10 PROCEDURE CREATE_ZONE_RANGE(p_zone_type IN VARCHAR2,
11                             p_zone_name IN VARCHAR2,
12                             p_zone_code IN VARCHAR2,
13                             p_zone_code_type IN VARCHAR2,
14                             p_zone_name_prefix IN VARCHAR2,
15                             p_start_date IN DATE,
16                             p_end_date IN DATE,
17                             p_zone_relation_tbl IN HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE,
18                             x_zone_geography_id OUT NOCOPY NUMBER);
19 
20 END;