PACKAGE: APPS.HZ_ELOCATION_PKG

Source

1 PACKAGE hz_elocation_pkg AS
2 /*$Header: ARHELOCS.pls 120.4 2005/10/07 00:19:47 acng noship $*/
3 
4   --------------------------------------------
5   -- declaration of global variables and types
6   --------------------------------------------
7   g_pkg_name       CONSTANT VARCHAR2(30) := 'hz_elocation_pkg';
8   g_debug_count             NUMBER := 0;
9   --g_debug                   BOOLEAN := FALSE;
10   g_index_name     CONSTANT VARCHAR2(20) := 'hz_locations_n15';
11   g_index_owner    CONSTANT VARCHAR2(2)  := 'ar';
12   g_commit_interval         VARCHAR2(5)  := '1000';
13 
14   ------------------------------------
15   -- declaration of private procedures
16   ------------------------------------
17   --PROCEDURE enable_debug;
18   --PROCEDURE disable_debug;
19   PROCEDURE create_index;
20 
21   PROCEDURE update_geometry (
22     errbuf            OUT NOCOPY VARCHAR2,
23     retcode           OUT NOCOPY VARCHAR2,
24     p_loc_type	      IN  VARCHAR2 DEFAULT 'P',
25     p_site_use_type   IN  VARCHAR2 DEFAULT NULL,
26     p_country         IN  VARCHAR2 DEFAULT NULL,
27     p_iden_addr_only  IN  VARCHAR2 DEFAULT 'N',
28     p_incremental     IN  VARCHAR2 DEFAULT 'N',
29     p_all_partial     IN  VARCHAR2 DEFAULT 'ALL',
30     p_nb_row_update   IN  VARCHAR2 DEFAULT 'ALL',
31     p_nb_row          IN  NUMBER   DEFAULT 20,
32     p_nb_try          IN  NUMBER   DEFAULT 3
33 
34   );
35 
36   PROCEDURE rebuild_location_index (
37     errbuf              OUT NOCOPY VARCHAR2,
38     retcode             OUT NOCOPY VARCHAR2,
39     p_concurrent_mode   IN  VARCHAR2 DEFAULT 'Y'
40   );
41 
42 END hz_elocation_pkg;