eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UPDATE_SUM dependencies on BSC_UPDATE_UTIL

Line 5: g_refreshed_mvs BSC_UPDATE_UTIL.t_array_of_varchar2;

1: PACKAGE BSC_UPDATE_SUM AS
2: /* $Header: BSCDSUMS.pls 120.0 2005/06/01 17:07:41 appldev noship $ */
3:
4: -- BSC-MV Note: Global variable to store the name of MV that has been refreshed.
5: g_refreshed_mvs BSC_UPDATE_UTIL.t_array_of_varchar2;
6: g_num_refreshed_mvs NUMBER := 0;
7:
8:
9: /*===========================================================================+

Line 76: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

72: |
73: +============================================================================*/
74: FUNCTION Calculate_Sum_Table_MV(
75: x_sum_table IN VARCHAR2,
76: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
77: x_num_calculated_sys_tables IN NUMBER,
78: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
79: x_num_system_tables IN NUMBER
80: ) RETURN BOOLEAN;

Line 78: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

74: FUNCTION Calculate_Sum_Table_MV(
75: x_sum_table IN VARCHAR2,
76: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
77: x_num_calculated_sys_tables IN NUMBER,
78: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
79: x_num_system_tables IN NUMBER
80: ) RETURN BOOLEAN;
81:
82: --LOCKING: new function

Line 85: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

81:
82: --LOCKING: new function
83: FUNCTION Calculate_Sum_Table_MV_AT(
84: x_sum_table IN VARCHAR2,
85: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
86: x_num_calculated_sys_tables IN NUMBER,
87: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
88: x_num_system_tables IN NUMBER
89: ) RETURN BOOLEAN;

Line 87: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

83: FUNCTION Calculate_Sum_Table_MV_AT(
84: x_sum_table IN VARCHAR2,
85: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
86: x_num_calculated_sys_tables IN NUMBER,
87: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
88: x_num_system_tables IN NUMBER
89: ) RETURN BOOLEAN;
90:
91:

Line 159: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

155: |
156: +============================================================================*/
157: FUNCTION Calculate_Sum_Table_Total(
158: x_sum_table IN VARCHAR2,
159: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
160: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
161: x_source_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_key_columns IN NUMBER,

Line 160: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

156: +============================================================================*/
157: FUNCTION Calculate_Sum_Table_Total(
158: x_sum_table IN VARCHAR2,
159: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
160: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
161: x_source_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_key_columns IN NUMBER,
164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 161: x_source_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

157: FUNCTION Calculate_Sum_Table_Total(
158: x_sum_table IN VARCHAR2,
159: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
160: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
161: x_source_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_key_columns IN NUMBER,
164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

158: x_sum_table IN VARCHAR2,
159: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
160: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
161: x_source_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_key_columns IN NUMBER,
164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

Line 164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

160: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
161: x_source_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_key_columns IN NUMBER,
164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
167: x_num_data_columns IN NUMBER,
168: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 165: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

161: x_source_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_key_columns IN NUMBER,
164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
167: x_num_data_columns IN NUMBER,
168: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_num_origin_tables IN NUMBER,

Line 166: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

162: x_source_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
163: x_num_key_columns IN NUMBER,
164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
167: x_num_data_columns IN NUMBER,
168: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_num_origin_tables IN NUMBER,
170: x_key_columns_ori IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 168: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

164: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
167: x_num_data_columns IN NUMBER,
168: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_num_origin_tables IN NUMBER,
170: x_key_columns_ori IN BSC_UPDATE_UTIL.t_array_of_varchar2,
171: x_num_key_columns_ori IN NUMBER,
172: x_periodicity IN NUMBER,

Line 170: x_key_columns_ori IN BSC_UPDATE_UTIL.t_array_of_varchar2,

166: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
167: x_num_data_columns IN NUMBER,
168: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_num_origin_tables IN NUMBER,
170: x_key_columns_ori IN BSC_UPDATE_UTIL.t_array_of_varchar2,
171: x_num_key_columns_ori IN NUMBER,
172: x_periodicity IN NUMBER,
173: x_origin_periodicity IN NUMBER,
174: x_period IN NUMBER,

Line 198: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

194: | Notes:
195: |
196: +============================================================================*/
197: FUNCTION Get_Minimun_Origin_Period(
198: x_origin_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
199: x_num_origin_tables IN NUMBER
200: ) RETURN NUMBER;
201:
202:

Line 223: x_origin_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

219: |
220: +============================================================================*/
221: FUNCTION Get_Origin_Tables(
222: x_table_name IN VARCHAR2,
223: x_origin_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
224: x_num_origin_tables IN OUT NOCOPY NUMBER
225: ) RETURN BOOLEAN;
226:
227: