1 PACKAGE CSF_SPATIAL_DATALOAD_PVT AUTHID CURRENT_USER AS
2 /* $Header: CSFVSDLS.pls 120.2 2009/10/28 06:04:26 vpalle noship $ */
3
4 TYPE CHAR30_ARR IS TABLE OF varchar2(30);
5 g_debug_p CONSTANT VARCHAR2 (100)
6 := 'begin dbms_' || 'output' || '.put_line(:1); end;';
7 g_log CONSTANT NUMBER := fnd_file.LOG;
8 g_output CONSTANT NUMBER := fnd_file.output;
9 g_debug BOOLEAN;
10
11 PROCEDURE DROP_INDEXES (
12 p_data_set_name IN VARCHAR2,
13 p_index_type IN VARCHAR2,
14 errbuf OUT NOCOPY VARCHAR2,
15 retcode OUT NOCOPY VARCHAR2 ) ;
16
17 PROCEDURE CREATE_INDEXES(
18 p_data_set_name IN VARCHAR2,
19 p_tablespace IN VARCHAR2,
20 p_index_type IN VARCHAR2,
21 errbuf OUT NOCOPY VARCHAR2,
22 retcode OUT NOCOPY VARCHAR2 );
23
24 PROCEDURE REFRESH_MAT_VIEWS(
25 p_data_set_name IN VARCHAR2,
26 errbuf OUT NOCOPY VARCHAR2,
27 retcode OUT NOCOPY VARCHAR2 );
28
29 PROCEDURE CHECK_TABLE_ROW_COUNT(
30 p_data_set_name IN VARCHAR2,
31 errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY VARCHAR2 );
33
34 PROCEDURE VALIDATE_BLOB_SIZE(
35 p_data_set_name IN VARCHAR2,
36 errbuf OUT NOCOPY VARCHAR2,
37 retcode OUT NOCOPY VARCHAR2 );
38
39 PROCEDURE CHECK_INDEX_VALIDITY(
40 p_data_set_name IN VARCHAR2,
41 p_index_type IN VARCHAR2,
42 p_status OUT NOCOPY VARCHAR2,
43 errbuf OUT NOCOPY VARCHAR2,
44 retcode OUT NOCOPY VARCHAR2 );
45
46 PROCEDURE COMPUTE_STATISTICS(
47 p_data_set_name IN VARCHAR2,
48 errbuf OUT NOCOPY VARCHAR2,
49 retcode OUT NOCOPY VARCHAR2 );
50
51 PROCEDURE RECREATE_INDEX (
52 p_data_set_name IN VARCHAR2,
53 p_index_name IN VARCHAR2,
54 p_tablespace IN VARCHAR2,
55 p_index_type IN VARCHAR2,
56 errbuf OUT NOCOPY VARCHAR2,
57 retcode OUT NOCOPY VARCHAR2 );
58
59 PROCEDURE RECREATE_INVALID_INDEXES(
60 p_data_set_name IN VARCHAR2,
61 p_tablespace IN VARCHAR2,
62 p_index_type IN VARCHAR2,
63 errbuf OUT NOCOPY VARCHAR2,
64 retcode OUT NOCOPY VARCHAR2 );
65
66 /* Procedure to drop route cache table. Fix for bug : 9019583
67
68 When a route is calculated by Time Distance Server (TDS), the route information is stored in CSF_TDS_ROUTE_CACHE table.
69 When the same route details are requested by Scheduler for the second time, TDS doesn't calculate the route again and
70 it provides the route by referring the CSF_TDS_ROUTE_CACHE table. The route details are dataset specific and cannotbe
71 used across the datasets. When a new dataset is loaded, this table data need to be cleared.
72 */
73 PROCEDURE TRUNC_ROUTE_CAHCE_TABLE(
74 p_data_set_name IN VARCHAR2,
75 errbuf OUT NOCOPY VARCHAR2,
76 retcode OUT NOCOPY VARCHAR2 );
77
78
79 PROCEDURE put_stream (p_handle IN NUMBER, p_msg_data IN VARCHAR2);
80
81 PROCEDURE dbgl (p_msg_data VARCHAR2);
82
83 End CSF_SPATIAL_DATALOAD_PVT;