1 PACKAGE BSC_UPDATE_INC AS
2 /* $Header: BSCDINCS.pls 120.0 2005/06/01 15:58:18 appldev noship $ */
3
4
5 /*===========================================================================+
6 |
7 | Name: Add_Related_Tables
8 |
9 | Description: This recursive function add into the array x_purge_tables
10 | the tables in the graph that are interrelated with the
11 | tables in the array x_tables.
12 |
13 | Parameters: x_tables -array of table names
14 | x_num_tables -number of tables
15 | x_purge_tables - array to add the interrelated tables
16 | x_num_purge_tables - number of tables
17 |
18 | Returns: If any error ocurrs, this function add the error message
19 | to the error stack and return FALSE. Otherwise return
20 | TRUE
21 | Notes:
22 |
23 +============================================================================*/
24 FUNCTION Add_Related_Tables (
25 x_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
26 x_num_tables IN NUMBER,
27 x_purge_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
28 x_num_purge_tables IN OUT NOCOPY NUMBER
29 ) RETURN BOOLEAN;
30
31
32 /*===========================================================================+
33 |
34 | Name: Do_Incremental
35 |
36 | Description: This function check if there are any pending task due to
37 | an incremental change like change in fiscal year or there
38 | are indicators with flag 6 (run update process) or 7 (run
39 | coloring process).
40 |
41 | Parameters:
42 |
43 | Returns: If any error ocurrs, this function add the error message
44 | to the error stack and return FALSE. Otherwise return
45 | TRUE
46 | Notes:
47 |
48 +============================================================================*/
49 FUNCTION Do_Incremental RETURN BOOLEAN;
50
51 --LOCKING: new function
52 FUNCTION Do_Incremental_AT RETURN BOOLEAN;
53
54
55 /*===========================================================================+
56 |
57 | Name: Get_Changed_Calendars
58 |
59 | Description: This function initialize the array x_changed_calendars
60 | with the code of the calendars whose fiscal year has changed.
61 |
62 | Returns: If any error ocurrs, this function add the error message
63 | to the error stack and return FALSE. Otherwise return
64 | TRUE
65 |
66 | Notes:
67 |
68 +============================================================================*/
69 FUNCTION Get_Changed_Calendars (
70 x_changed_calendars IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
71 x_num_changed_calendars IN OUT NOCOPY NUMBER
72 ) RETURN BOOLEAN;
73
74
75 /*===========================================================================+
76 |
77 | Name: Get_Color_Indics_Incremental
78 |
79 | Description: This function initialize the array x_color_indicators
80 | with the code of the indicators with flag = 7 (re-color).
81 |
82 | Parameters: x_color_indicators - array to return the indicators
83 | x_num_color_indicators - number of indicators
84 |
85 | Returns: If any error ocurrs, this function add the error message
86 | to the error stack and return FALSE. Otherwise return
87 | TRUE
88 |
89 | Notes:
90 |
91 +============================================================================*/
92 FUNCTION Get_Color_Indics_Incremental (
93 x_color_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
94 x_num_color_indicators IN OUT NOCOPY NUMBER
95 ) RETURN BOOLEAN;
96
97
98 /*===========================================================================+
99 |
100 | Name: Get_Input_Tables
101 |
102 | Description: This recursive function insert into the array
103 | x_input_tables the input tables from where the system
104 | tables given in the array x_tables are originated.
105 |
106 | Parameters: x_input_tables - array to insert the input tables
107 | x_num_input_tables - number of input tables
108 | x_tables - array of system tables
109 | x_num_tables - num system tables
110 |
111 | Returns: If any error ocurrs, this function add the error message
112 | to the error stack and return FALSE. Otherwise return
113 | TRUE
114 |
115 | Notes:
116 |
117 +============================================================================*/
118 FUNCTION Get_Input_Tables(
119 x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
120 x_num_input_tables IN OUT NOCOPY NUMBER,
121 x_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
122 x_num_tables IN NUMBER
123 ) RETURN BOOLEAN;
124
125
126 /*===========================================================================+
127 |
128 | Name: Get_Input_Tables_Incremental
129 |
130 | Description: This function initialize the array x_input_tables
131 | with the name of the input tables of the indicators with
132 | flag = 6 (non-structural changes).
133 |
134 | Parameters: x_input_tables - array to return the input tables
135 | x_num_input_tables - number of input tables returned
136 |
137 | Returns: If any error ocurrs, this function add the error message
138 | to the error stack and return FALSE. Otherwise return
139 | TRUE
140 |
141 | Notes:
142 |
143 +============================================================================*/
144 FUNCTION Get_Input_Tables_Incremental (
145 x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
146 x_num_input_tables IN OUT NOCOPY NUMBER
147 ) RETURN BOOLEAN;
148
149
150 /*===========================================================================+
151 |
152 | Name: Purge_Data_All_Indicators
153 |
154 | Description: This function purge the data for all indicators.
155 |
156 | Parameters:
157 |
158 | Returns: If any error ocurrs, this function add the error message
159 | to the error stack and return FALSE. Otherwise return
160 | TRUE
161 | Notes:
162 |
163 +============================================================================*/
164 FUNCTION Purge_Data_All_Indicators RETURN BOOLEAN;
165
166
167 /*===========================================================================+
168 |
169 | Name: Purge_Data_Indicators_Calendar
170 |
171 | Description: This function purge the data for indicators using the given
172 | calendar.
173 |
174 | Parameters:
175 |
176 | Returns: If any error ocurrs, this function add the error message
177 | to the error stack and return FALSE. Otherwise return
178 | TRUE
179 | Notes:
180 |
181 +============================================================================*/
182 FUNCTION Purge_Data_Indicators_Calendar(
183 x_calendar_id IN NUMBER
184 ) RETURN BOOLEAN;
185
186
187 /*===========================================================================+
188 |
189 | Name: Purge_Indicators_Data
190 |
191 | Description: This function purge the data for all indicators that are
192 | in the array x_purge_indicators and the interrelated
193 | indicators.
194 |
195 | Parameters: x_purge_indicators - array of indicators to purge
196 | x_num_purge_indicators - number of indicators
197 |
198 | Returns: If any error ocurrs, this function add the error message
199 | to the error stack and return FALSE. Otherwise return
200 | TRUE
201 | Notes:
202 |
203 +============================================================================*/
204 FUNCTION Purge_Indicators_Data (
205 x_purge_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
206 x_num_purge_indicators IN NUMBER
207 ) RETURN BOOLEAN;
208 FUNCTION Purge_Indicators_Data (
209 x_purge_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
210 x_num_purge_indicators IN NUMBER,
211 x_keep_input_data varchar2
212 ) RETURN BOOLEAN;
213 --LOCKING: new function
214 FUNCTION Purge_Indicators_Data_AT (
215 x_purge_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
216 x_num_purge_indicators IN NUMBER,
217 x_keep_input_data varchar2
218 ) RETURN BOOLEAN;
219
220 /*===========================================================================+
221 |
222 | Name: Reset_Flag_Indicators
223 |
224 | Description: This function reset to 0 the prototype flag of all
225 | indicators.
226 |
227 | Parameters:
228 |
229 | Returns: If any error ocurrs, this function add the error message
230 | to the error stack and return FALSE. Otherwise return
231 | TRUE
232 |
233 | Notes:
234 |
235 +============================================================================*/
236 FUNCTION Reset_Flag_Indicators RETURN BOOLEAN;
237
238
239 --LOCKING: new procedure
240 PROCEDURE Purge_AW_Indicator_AT (
241 x_indicator IN NUMBER
242 );
243
244 END BSC_UPDATE_INC;