[Home] [Help]
PACKAGE: APPS.EDW_COLLECTION_UTIL
Source
1 PACKAGE edw_collection_util AUTHID CURRENT_USER AS
2 /* $Header: EDWSRCTS.pls 115.28 2003/10/13 18:12:19 vsurendr ship $ */
3 version CONSTANT VARCHAR (80)
4 := '$Header: EDWSRCTS.pls 115.28 2003/10/13 18:12:19 vsurendr ship $';
5
6 -- ------------------------
7 -- Global Variables
8 -- ------------------------
9 g_object_name VARCHAR2 (30);
10 g_instance_code VARCHAR2 (30);
11 g_user_id PLS_INTEGER := 0;
12 g_login_id PLS_INTEGER := 0;
13 g_default_rate_type VARCHAR2 (30);
14 g_global_currency VARCHAR2 (30);
15 g_wh_curr_push_start_date DATE;
16 g_wh_curr_push_end_date DATE;
17 g_local_curr_push_start_date DATE;
18 g_local_curr_push_end_date DATE;
19 g_wh_last_push_end_date DATE;
20 g_local_last_push_start_date DATE;
21 g_wh_last_coll_start_date DATE;
22 g_wh_last_coll_end_date DATE;
23 g_deletion_curr_ver_date DATE;
24 g_start_time DATE;
25 g_offset INTEGER := 0;
26 g_object_type VARCHAR2 (100);
27 g_errbuf VARCHAR2 (2000);
28 g_retcode VARCHAR2 (200);
29 g_push_size PLS_INTEGER := 0;
30 g_request_id PLS_INTEGER;
31 g_push_remote_failure EXCEPTION;
32
33 TYPE tbl_rectype IS RECORD (
34 tbl_name user_tables.table_name%TYPE,
35 tbl_owner user_users.username%TYPE,
36 row_count PLS_INTEGER);
37
38 TYPE tablist_type IS TABLE OF tbl_rectype
39 INDEX BY BINARY_INTEGER;
40
41 TYPE curtyp IS REF CURSOR;
42
43 edw_dim CONSTANT VARCHAR2 (10) := 'DIMENSION';
44 edw_fact CONSTANT VARCHAR2 (10) := 'FACT';
45
46
47 -- ------------------------
48 -- Public Procedures
49 -- ------------------------
50 FUNCTION setup (p_object_name IN VARCHAR2) RETURN BOOLEAN ;
51 FUNCTION setup (
52 p_object_name IN VARCHAR2,
53 p_pk_view IN VARCHAR2,
54 p_missing_key_view IN VARCHAR2,
55 p_transport_data IN BOOLEAN
56 )
57 RETURN BOOLEAN;
58
59 FUNCTION setup (
60 p_object_name IN VARCHAR2,
61 p_local_staging_table IN VARCHAR2,
62 p_remote_staging_table IN VARCHAR2,
63 p_exception_msg OUT NOCOPY VARCHAR2
64 )
65 RETURN BOOLEAN;
66 FUNCTION setup (
67 p_object_name IN VARCHAR2,
68 p_local_staging_table IN VARCHAR2,
69 p_remote_staging_table IN VARCHAR2,
70 p_exception_msg OUT NOCOPY VARCHAR2,
71 p_pk_view IN VARCHAR2,
72 p_missing_key_view IN VARCHAR2,
73 p_transport_data IN BOOLEAN
74 )
75 RETURN BOOLEAN;
76 PROCEDURE wrapup (
77 p_sucessful IN BOOLEAN
78 );
79 PROCEDURE wrapup (
80 p_sucessful IN BOOLEAN,
81 p_rows_inserted IN NUMBER
82 );
83 /*
84 Bug 2875426
85 This API is only meant for EDW_UNSPSC_M_C
86 This API DOES NOT populate the from and to dates. No collection program must
87 call it!
88 */
89 PROCEDURE wrapup(
90 p_sucessful IN BOOLEAN,
91 p_rows_inserted IN NUMBER,
92 p_exception_msg IN VARCHAR2
93 );
94 PROCEDURE wrapup (
95 p_sucessful IN BOOLEAN,
96 p_rows_inserted IN NUMBER,
97 p_period_start IN DATE,
98 p_period_end IN DATE
99 );
100 PROCEDURE wrapup (
101 p_sucessful IN BOOLEAN,
102 p_rows_inserted IN NUMBER,
103 p_exception_msg IN VARCHAR2,
104 p_period_start IN DATE,
105 p_period_end IN DATE
106 );
107 FUNCTION is_instance_enabled
108 RETURN BOOLEAN;
109
110 FUNCTION source_same_as_target
111 RETURN BOOLEAN;
112
113
114 -- FUNCTION get_level_dp(p_lookup_code in varchar2) return VARCHAR2;
115 -- ------------------------
116 -- Private Procedures
117 -- ------------------------
118
119 PROCEDURE get_push_globals (p_staging_table_name IN VARCHAR2);
120 PROCEDURE staging_log (
121 p_no_of_records IN NUMBER,
122 p_status IN VARCHAR2,
123 p_exception_message IN VARCHAR2
124 );
125 PROCEDURE staging_log (
126 p_no_of_records IN NUMBER,
127 p_status IN VARCHAR2,
128 p_exception_message IN VARCHAR2,
129 p_period_start IN DATE,
130 p_period_end IN DATE
131 );
132
133 PROCEDURE set_push_end_dates;
134
135 FUNCTION set_wh_language
136 RETURN BOOLEAN;
137
138 FUNCTION get_wh_lookup_value (
139 p_lookup_type IN VARCHAR2,
140 p_lookup_code IN VARCHAR2
141 )
142 RETURN VARCHAR2;
143
144 FUNCTION get_wh_language
145 RETURN VARCHAR2;
146
147 FUNCTION get_object_type (p_object IN VARCHAR2)
148 RETURN BOOLEAN;
149
150 FUNCTION set_status_ready (p_tab_list IN tablist_type)
151 RETURN NUMBER;
152
153 PROCEDURE truncate_stg (p_tab_list IN tablist_type);
154
155 FUNCTION get_lookup_value (
156 p_lookup_type IN VARCHAR2,
157 p_lookup_code IN VARCHAR2
158 )
159 RETURN VARCHAR2;
160
161 FUNCTION get_last_push_date (p_object IN VARCHAR2)
162 RETURN VARCHAR2;
163
164 FUNCTION get_last_push_date_logical (p_object_logical_name IN VARCHAR2)
165 RETURN VARCHAR2;
166
167 PROCEDURE get_dblink_names (
168 x_source_link OUT NOCOPY VARCHAR2,
169 x_target_link OUT NOCOPY VARCHAR2
170 );
171
172 PROCEDURE clean_up (p_tab_list IN tablist_type, suffix IN VARCHAR2);
173
174 PROCEDURE get_stg_table_names (
175 p_object_name IN VARCHAR2,
176 tablist OUT NOCOPY tablist_type
177 );
178
179 FUNCTION push_to_target
180 RETURN NUMBER;
181
182 FUNCTION get_syn_info (syn_name IN VARCHAR2)
183 RETURN VARCHAR2;
184
185 PROCEDURE put_timestamp;
186
187 PROCEDURE put_debug_msg (p_message IN VARCHAR2);
188
189 FUNCTION is_object_for_local_load (p_object_name IN VARCHAR2)
190 RETURN BOOLEAN;
191
192 PROCEDURE set_transaction_rbs (p_rbs IN VARCHAR2);
193 END edw_collection_util;
194