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_BASE_V2 dependencies on BSC_UPDATE_UTIL

Line 51: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

47: x_periodicity IN NUMBER,
48: x_calendar_id IN NUMBER,
49: x_current_period IN NUMBER,
50: x_current_fy IN NUMBER,
51: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
52: x_num_key_columns IN NUMBER,
53: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
54: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
55: x_num_data_columns IN NUMBER,

Line 53: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

49: x_current_period IN NUMBER,
50: x_current_fy IN NUMBER,
51: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
52: x_num_key_columns IN NUMBER,
53: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
54: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
55: x_num_data_columns IN NUMBER,
56: x_partition_name IN VARCHAR2,
57: x_batch_value IN NUMBER,

Line 54: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,

50: x_current_fy IN NUMBER,
51: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
52: x_num_key_columns IN NUMBER,
53: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
54: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
55: x_num_data_columns IN NUMBER,
56: x_partition_name IN VARCHAR2,
57: x_batch_value IN NUMBER,
58: x_parallel_jobs IN VARCHAR2,

Line 78: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

74: x_calendar_id IN NUMBER,
75: x_current_period IN NUMBER,
76: x_old_current_period IN NUMBER,
77: x_current_fy IN NUMBER,
78: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
79: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
80: x_num_key_columns IN NUMBER,
81: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
82: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 79: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

75: x_current_period IN NUMBER,
76: x_old_current_period IN NUMBER,
77: x_current_fy IN NUMBER,
78: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
79: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
80: x_num_key_columns IN NUMBER,
81: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
82: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
83: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

Line 81: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

77: x_current_fy IN NUMBER,
78: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
79: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
80: x_num_key_columns IN NUMBER,
81: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
82: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
83: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
84: x_num_data_columns IN NUMBER,
85: x_partition_name IN VARCHAR2,

Line 82: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

78: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
79: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
80: x_num_key_columns IN NUMBER,
81: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
82: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
83: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
84: x_num_data_columns IN NUMBER,
85: x_partition_name IN VARCHAR2,
86: x_batch_value IN NUMBER,

Line 83: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

79: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
80: x_num_key_columns IN NUMBER,
81: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
82: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
83: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
84: x_num_data_columns IN NUMBER,
85: x_partition_name IN VARCHAR2,
86: x_batch_value IN NUMBER,
87: x_num_partitions IN NUMBER,

Line 105: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

101: x_periodicity IN NUMBER,
102: x_calendar_id IN NUMBER,
103: x_current_period IN NUMBER,
104: x_current_fy IN NUMBER,
105: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
106: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
107: x_num_key_columns IN NUMBER,
108: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
109: x_num_data_columns IN NUMBER,

Line 106: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

102: x_calendar_id IN NUMBER,
103: x_current_period IN NUMBER,
104: x_current_fy IN NUMBER,
105: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
106: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
107: x_num_key_columns IN NUMBER,
108: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
109: x_num_data_columns IN NUMBER,
110: x_partition_name IN VARCHAR2,

Line 108: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

104: x_current_fy IN NUMBER,
105: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
106: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
107: x_num_key_columns IN NUMBER,
108: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
109: x_num_data_columns IN NUMBER,
110: x_partition_name IN VARCHAR2,
111: x_batch_value IN NUMBER,
112: x_num_partitions IN NUMBER,

Line 122: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

118: );
119:
120: PROCEDURE Create_Types_For_MV_Load(
121: x_base_table IN VARCHAR2,
122: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
123: x_num_key_columns IN NUMBER,
124: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
125: x_num_data_columns IN NUMBER,
126: x_return_status OUT NOCOPY VARCHAR2,

Line 124: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

120: PROCEDURE Create_Types_For_MV_Load(
121: x_base_table IN VARCHAR2,
122: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
123: x_num_key_columns IN NUMBER,
124: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
125: x_num_data_columns IN NUMBER,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_error_message OUT NOCOPY VARCHAR2
128: );

Line 164: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

160: x_calendar_id IN NUMBER,
161: x_current_period IN NUMBER,
162: x_old_current_period IN NUMBER,
163: x_current_fy IN NUMBER,
164: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_num_key_columns IN NUMBER,
167: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
168: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 165: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

161: x_current_period IN NUMBER,
162: x_old_current_period IN NUMBER,
163: x_current_fy IN NUMBER,
164: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_num_key_columns IN NUMBER,
167: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
168: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

Line 167: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

163: x_current_fy IN NUMBER,
164: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_num_key_columns IN NUMBER,
167: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
168: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
170: x_num_data_columns IN NUMBER,
171: x_partition_name IN VARCHAR2,

Line 168: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

164: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_num_key_columns IN NUMBER,
167: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
168: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
170: x_num_data_columns IN NUMBER,
171: x_partition_name IN VARCHAR2,
172: x_batch_value IN NUMBER,

Line 169: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

165: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166: x_num_key_columns IN NUMBER,
167: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
168: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
170: x_num_data_columns IN NUMBER,
171: x_partition_name IN VARCHAR2,
172: x_batch_value IN NUMBER,
173: x_num_partitions IN NUMBER,

Line 190: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

186: x_periodicity IN NUMBER,
187: x_calendar_id IN NUMBER,
188: x_current_period IN NUMBER,
189: x_current_fy IN NUMBER,
190: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
191: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
192: x_num_key_columns IN NUMBER,
193: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 191: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

187: x_calendar_id IN NUMBER,
188: x_current_period IN NUMBER,
189: x_current_fy IN NUMBER,
190: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
191: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
192: x_num_key_columns IN NUMBER,
193: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
195: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

Line 193: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

189: x_current_fy IN NUMBER,
190: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
191: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
192: x_num_key_columns IN NUMBER,
193: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
195: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
196: x_num_data_columns IN NUMBER,
197: x_partition_name IN VARCHAR2,

Line 194: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

190: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
191: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
192: x_num_key_columns IN NUMBER,
193: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
195: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
196: x_num_data_columns IN NUMBER,
197: x_partition_name IN VARCHAR2,
198: x_batch_value IN NUMBER,

Line 195: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

191: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
192: x_num_key_columns IN NUMBER,
193: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
195: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
196: x_num_data_columns IN NUMBER,
197: x_partition_name IN VARCHAR2,
198: x_batch_value IN NUMBER,
199: x_num_partitions IN NUMBER,

Line 208: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

204:
205: PROCEDURE Calc_Higher_Periodicities(
206: x_base_table IN VARCHAR2,
207: x_periodicity IN NUMBER,
208: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
209: x_num_key_columns IN NUMBER,
210: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
211: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
212: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

Line 210: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

206: x_base_table IN VARCHAR2,
207: x_periodicity IN NUMBER,
208: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
209: x_num_key_columns IN NUMBER,
210: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
211: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
212: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
213: x_num_data_columns IN NUMBER,
214: x_partition_name IN VARCHAR2,

Line 211: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

207: x_periodicity IN NUMBER,
208: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
209: x_num_key_columns IN NUMBER,
210: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
211: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
212: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
213: x_num_data_columns IN NUMBER,
214: x_partition_name IN VARCHAR2,
215: x_batch_value IN NUMBER,

Line 212: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

208: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
209: x_num_key_columns IN NUMBER,
210: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
211: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
212: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
213: x_num_data_columns IN NUMBER,
214: x_partition_name IN VARCHAR2,
215: x_batch_value IN NUMBER,
216: x_parallel_jobs IN VARCHAR2,

Line 252: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

248: x_calendar_id IN NUMBER,
249: x_current_fy IN NUMBER,
250: x_current_period IN NUMBER,
251: x_old_current_period IN NUMBER,
252: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
253: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
254: x_num_key_columns IN NUMBER,
255: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
256: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

Line 253: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

249: x_current_fy IN NUMBER,
250: x_current_period IN NUMBER,
251: x_old_current_period IN NUMBER,
252: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
253: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
254: x_num_key_columns IN NUMBER,
255: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
256: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
257: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,

Line 255: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

251: x_old_current_period IN NUMBER,
252: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
253: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
254: x_num_key_columns IN NUMBER,
255: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
256: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
257: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
258: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
259: x_num_data_columns IN NUMBER,

Line 256: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

252: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
253: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
254: x_num_key_columns IN NUMBER,
255: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
256: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
257: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
258: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
259: x_num_data_columns IN NUMBER,
260: x_proj_table IN VARCHAR2,

Line 257: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,

253: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
254: x_num_key_columns IN NUMBER,
255: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
256: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
257: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
258: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
259: x_num_data_columns IN NUMBER,
260: x_proj_table IN VARCHAR2,
261: x_rowid_table IN VARCHAR2,

Line 258: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

254: x_num_key_columns IN NUMBER,
255: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
256: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
257: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
258: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
259: x_num_data_columns IN NUMBER,
260: x_proj_table IN VARCHAR2,
261: x_rowid_table IN VARCHAR2,
262: x_partition_name IN VARCHAR2,