PACKAGE: APPS.RRS_ELOCATION_PKG

Source

1 PACKAGE rrs_elocation_pkg AUTHID CURRENT_USER AS
2 /*$Header: RRSELOCS.pls 120.0 2006/01/19 07:51:35 swbhatna noship $*/
3 
4   --------------------------------------
5   -- PUBLIC PROCEDURE rebuild_spatial_indexes
6   -- DESCRIPTION
7   --   Rebuilds the spatial index on RRS_SITE_TMP.GEOMETRY and RRS_TRADE_AREAS.GEOMETRY.
8   --   Rebuilding the spatial index is required so that the index performs adequately,
9   --   queries can accurately extract the spatial data and Spatial functions can be called
10   --   on these columns
11   -- ARGUMENTS
12   --   OUT:
13   --     errbuf                         Standard AOL concurrent program error buffer.
14   --     retcode                        Standard AOL concurrent program return code.
15   -- MODIFICATION HISTORY
16   --   18/01/2006 swbhatna              Created.
17   --------------------------------------
18   PROCEDURE rebuild_spatial_indexes (
19     errbuf              OUT NOCOPY VARCHAR2,
20     retcode             OUT NOCOPY VARCHAR2
21   );
22 
23   PROCEDURE Update_Index_Metadata (
24   p_index_name   IN  VARCHAR2
25   );
26 
27   PROCEDURE Create_Index (
28   p_index_name   IN  VARCHAR2
29   );
30 
31 END rrs_elocation_pkg;