PACKAGE: APPS.CSF_SPATIAL_TTSP_PVT

Source

1 PACKAGE CSF_SPATIAL_TTSP_PVT AUTHID CURRENT_USER AS
2 /* $Header: CSFVTTSPS.pls 120.1 2009/08/25 10:56:28 vpalle noship $ */
3 
4     g_debug_p             CONSTANT VARCHAR2 (100)
5                           := 'begin dbms_' || 'output' || '.put_line(:1); end;';
6     g_log                 CONSTANT NUMBER         := fnd_file.LOG;
7     g_output              CONSTANT NUMBER         := fnd_file.output;
8     g_debug                        BOOLEAN;
9     g_directory_name       CONSTANT VARCHAR2(100) := 'TTS_NAVTEQ_2008';
10 
11   PROCEDURE DATAPUMP_EXPORT(
12       p_dmp_file       IN   VARCHAR2,
13       p_table_space  IN   VARCHAR2,
14       p_data_set_name  IN   VARCHAR2,
15       errbuf OUT nocopy VARCHAR2,
16       retcode OUT nocopy VARCHAR2);
17 
18   PROCEDURE DATAPUMP_IMPORT(
19       p_dmp_file         IN VARCHAR2,
20       p_data_file_dir    IN VARCHAR2,
21       p_data_file_str    IN VARCHAR2,
22       p_data_set_name    IN VARCHAR2,
23       errbuf OUT nocopy VARCHAR2,
24       retcode OUT nocopy VARCHAR2) ;
25 
26   PROCEDURE CREATE_DIRECTORY(
27       p_directory_path IN VARCHAR2,
28       errbuf OUT nocopy VARCHAR2,
29       retcode OUT nocopy VARCHAR2);
30 
31   PROCEDURE INITIALIZE_INDEXES_FOR_TTS(
32       errbuf OUT nocopy VARCHAR2,
33       retcode OUT nocopy VARCHAR2);
34 
35  PROCEDURE IMPORT_TABLE_STATS(
36       p_data_set_name IN             VARCHAR2,
37       errbuf OUT nocopy VARCHAR2,
38       retcode OUT nocopy VARCHAR2) ;
39 
40   PROCEDURE CREATE_SYNONYMS(
41       p_data_set_name IN             VARCHAR2,
42       errbuf          OUT nocopy     VARCHAR2,
43       retcode         OUT nocopy     VARCHAR2) ;
44 
45   PROCEDURE DROP_TTSP_STATS(
46       p_data_set_name    IN VARCHAR2,
47       errbuf    OUT nocopy     VARCHAR2,
48       retcode   OUT nocopy     VARCHAR);
49 
50   PROCEDURE DROP_MATERIALIZED_VIEWS(
51       p_data_set_name IN VARCHAR2,
52       errbuf    OUT nocopy     VARCHAR2,
53       retcode   OUT nocopy     VARCHAR);
54 
55   PROCEDURE DROP_SPATIAL_TABLES(
56       p_data_set_name IN VARCHAR2,
57       errbuf    OUT nocopy     VARCHAR2,
58       retcode   OUT nocopy     VARCHAR2 ) ;
59 
60   PROCEDURE PREPARE_INDEXES_FOR_TTS(
61       p_table_space  IN VARCHAR2,
62       errbuf OUT nocopy VARCHAR2,
63       retcode OUT nocopy VARCHAR2);
64 
65   PROCEDURE EXPORT_TABLE_STATS(
66       p_data_set_name IN             VARCHAR2,
67       errbuf OUT nocopy VARCHAR2,
68       retcode OUT nocopy VARCHAR2) ;
69 
70   /*  The following procedure is used to print the log messages.  */
71   PROCEDURE put_stream(
72       p_handle IN NUMBER,
73       p_msg_data IN VARCHAR2) ;
74 
75 END CSF_SPATIAL_TTSP_PVT;
76