PACKAGE: APPS.DDR_ETL_UTIL_PKG

Source

1 PACKAGE ddr_etl_util_pkg AS
2 /* $Header: ddruetls.pls 120.1.12010000.2 2008/09/13 05:55:33 vbhave ship $ */
3 
4   FUNCTION get_mv_refresh_job_id RETURN VARCHAR2;
5 
6   PROCEDURE refresh_mv (
7         p_list                 IN VARCHAR2,
8         p_method               IN VARCHAR2 DEFAULT NULL,
9         p_rollback_seg         IN VARCHAR2 DEFAULT NULL,
10         p_push_deferred_rpc    IN BOOLEAN  DEFAULT TRUE,
11         p_refresh_after_errors IN BOOLEAN  DEFAULT FALSE,
12         p_purge_option         IN BINARY_INTEGER DEFAULT 1,
13         p_parallelism          IN BINARY_INTEGER DEFAULT 0,
14         p_heap_size            IN BINARY_INTEGER DEFAULT 0,
15         p_atomic_refresh       IN BOOLEAN  DEFAULT TRUE,
16         p_job_id               IN VARCHAR2 DEFAULT NULL,
17         p_refreshed_by         IN VARCHAR2 DEFAULT NULL,
18         x_out                  OUT NOCOPY VARCHAR2,
19         x_message              OUT NOCOPY VARCHAR2
20   );
21 
22   PROCEDURE truncate_mv_log(
23         p_mv_log_name          IN VARCHAR2,
24         p_job_id               IN VARCHAR2 DEFAULT NULL,
25         p_refreshed_by         IN VARCHAR2 DEFAULT NULL,
26         x_out                  OUT NOCOPY VARCHAR2,
27         x_message              OUT NOCOPY VARCHAR2
28   );
29 
30   PROCEDURE Export_Error (
31         p_table_name          IN VARCHAR2,
32         p_load_id             IN NUMBER   DEFAULT NULL,
33         p_file_name           IN VARCHAR2 DEFAULT NULL
34   );
35 
36   PROCEDURE Import_Error (
37         p_table_name          IN VARCHAR2,
38         p_file_name           IN VARCHAR2  DEFAULT NULL
39   );
40 
41   PROCEDURE Import_Error (
42         p_table_name          IN VARCHAR2,
43         p_file_name           IN VARCHAR2  DEFAULT NULL,
44         p_err_table_name      IN VARCHAR2,
45         p_load_id             IN NUMBER    DEFAULT NULL,
46         p_tgt_table_type      IN VARCHAR2  DEFAULT 'I'
47   );
48 
49   PROCEDURE Transfer_Data (
50         p_src_table_name      IN VARCHAR2,
51         p_tgt_table_name      IN VARCHAR2,
52         p_load_id             IN NUMBER    DEFAULT NULL,
53         p_tgt_table_type      IN VARCHAR2  DEFAULT 'I'
54   );
55 
56   PROCEDURE Export_Data (
57         p_table_name          IN VARCHAR2,
58         p_where_clause        IN VARCHAR2  DEFAULT NULL,
59         p_file_name           IN VARCHAR2  DEFAULT NULL
60   );
61 
62   PROCEDURE Import_Data (
63         p_table_name          IN VARCHAR2,
64         p_file_name           IN VARCHAR2  DEFAULT NULL
65   );
66 
67   TYPE string_tab IS TABLE OF VARCHAR2(1000)
68   INDEX BY BINARY_INTEGER;
69 
70   TYPE integer_tab IS TABLE OF PLS_INTEGER
71   INDEX BY BINARY_INTEGER;
72 
73   TYPE string_index_by_char_tab IS TABLE OF VARCHAR2(50)
74   INDEX BY VARCHAR2(50);
75 
76 END ddr_etl_util_pkg;