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

Line 53: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

49: |
50: +============================================================================*/
51: FUNCTION Calculate_Profit(
52: x_table_name IN VARCHAR2,
53: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
54: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
55: x_num_key_columns IN NUMBER,
56: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
57: x_num_data_columns IN NUMBER,

Line 54: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

50: +============================================================================*/
51: FUNCTION Calculate_Profit(
52: x_table_name IN VARCHAR2,
53: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
54: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
55: x_num_key_columns IN NUMBER,
56: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
57: x_num_data_columns IN NUMBER,
58: x_aw_flag IN BOOLEAN,

Line 56: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

52: x_table_name IN VARCHAR2,
53: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
54: x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
55: x_num_key_columns IN NUMBER,
56: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
57: x_num_data_columns IN NUMBER,
58: x_aw_flag IN BOOLEAN,
59: x_change_vector_value IN NUMBER
60: ) RETURN BOOLEAN;

Line 80: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

76: FUNCTION Calculate_Proj_Avg_Last_Year(
77: x_table_name IN VARCHAR2,
78: x_periodicity IN NUMBER,
79: x_period IN NUMBER,
80: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
81: x_num_key_columns IN NUMBER,
82: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
83: x_num_data_columns IN NUMBER,
84: x_lst_data_temp IN VARCHAR2, -- list of data columns in the projection table i.e: 'DATA1, DATA5'

Line 82: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

78: x_periodicity IN NUMBER,
79: x_period IN NUMBER,
80: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
81: x_num_key_columns IN NUMBER,
82: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
83: x_num_data_columns IN NUMBER,
84: x_lst_data_temp IN VARCHAR2, -- list of data columns in the projection table i.e: 'DATA1, DATA5'
85: x_current_fy IN NUMBER,
86: x_num_of_years IN NUMBER,

Line 118: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

114: FUNCTION Calculate_Proj_3_Periods_Perf(
115: x_table_name IN VARCHAR2,
116: x_periodicity IN NUMBER,
117: x_period IN NUMBER,
118: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
119: x_num_key_columns IN NUMBER,
120: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
121: x_num_data_columns IN NUMBER,
122: x_lst_data_temp IN VARCHAR2, -- list of data columns in the projection table i.e: 'DATA1, DATA5'

Line 120: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

116: x_periodicity IN NUMBER,
117: x_period IN NUMBER,
118: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
119: x_num_key_columns IN NUMBER,
120: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
121: x_num_data_columns IN NUMBER,
122: x_lst_data_temp IN VARCHAR2, -- list of data columns in the projection table i.e: 'DATA1, DATA5'
123: x_current_fy IN NUMBER,
124: x_is_base IN BOOLEAN,

Line 154: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

150: FUNCTION Calculate_Proj_User_Defined(
151: x_table_name IN VARCHAR2,
152: x_periodicity IN NUMBER,
153: x_period IN NUMBER,
154: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
155: x_num_key_columns IN NUMBER,
156: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
157: x_num_data_columns IN NUMBER,
158: x_lst_data_temp IN VARCHAR2, -- list of data columns in the projection table i.e: 'DATA1, DATA5'

Line 156: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

152: x_periodicity IN NUMBER,
153: x_period IN NUMBER,
154: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
155: x_num_key_columns IN NUMBER,
156: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
157: x_num_data_columns IN NUMBER,
158: x_lst_data_temp IN VARCHAR2, -- list of data columns in the projection table i.e: 'DATA1, DATA5'
159: x_current_fy IN NUMBER,
160: x_is_base IN BOOLEAN,

Line 193: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

189: FUNCTION Calculate_Projection(
190: x_table_name IN VARCHAR2,
191: x_periodicity IN NUMBER,
192: x_period IN NUMBER,
193: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_num_key_columns IN NUMBER,
195: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
196: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
197: x_num_data_columns IN NUMBER,

Line 195: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

191: x_periodicity IN NUMBER,
192: x_period IN NUMBER,
193: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_num_key_columns IN NUMBER,
195: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
196: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
197: x_num_data_columns IN NUMBER,
198: x_current_fy IN NUMBER,
199: x_num_of_years IN NUMBER,

Line 196: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,

192: x_period IN NUMBER,
193: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194: x_num_key_columns IN NUMBER,
195: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
196: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
197: x_num_data_columns IN NUMBER,
198: x_current_fy IN NUMBER,
199: x_num_of_years IN NUMBER,
200: x_previous_years IN NUMBER,

Line 228: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

224: +============================================================================*/
225: FUNCTION Calculate_Zero_Code(
226: x_table_name IN VARCHAR2,
227: x_zero_code_calc_method IN NUMBER,
228: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
229: x_num_key_columns IN NUMBER,
230: x_src_table IN VARCHAR2
231: ) RETURN BOOLEAN;
232:

Line 282: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

278: +============================================================================*/
279: FUNCTION Init_Projection_Table(
280: x_table_name IN VARCHAR2,
281: x_periodicity IN NUMBER,
282: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
283: x_num_key_columns IN NUMBER,
284: x_current_fy IN NUMBER,
285: x_current_period IN NUMBER,
286: x_is_base IN BOOLEAN,

Line 316: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

312: FUNCTION Delete_Projection(
313: x_table_name IN VARCHAR2,
314: x_periodicity IN NUMBER,
315: x_period IN NUMBER,
316: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
317: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
318: x_num_data_columns IN NUMBER,
319: x_current_fy IN NUMBER,
320: x_is_base IN BOOLEAN

Line 317: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,

313: x_table_name IN VARCHAR2,
314: x_periodicity IN NUMBER,
315: x_period IN NUMBER,
316: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
317: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
318: x_num_data_columns IN NUMBER,
319: x_current_fy IN NUMBER,
320: x_is_base IN BOOLEAN
321: ) RETURN BOOLEAN;

Line 343: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

339: x_table_name IN VARCHAR2,
340: x_periodicity IN NUMBER,
341: x_current_period IN NUMBER,
342: x_new_current_period IN NUMBER,
343: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
344: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
345: x_num_data_columns IN NUMBER,
346: x_current_fy IN NUMBER,
347: x_aw_flag IN BOOLEAN,

Line 344: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,

340: x_periodicity IN NUMBER,
341: x_current_period IN NUMBER,
342: x_new_current_period IN NUMBER,
343: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
344: x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
345: x_num_data_columns IN NUMBER,
346: x_current_fy IN NUMBER,
347: x_aw_flag IN BOOLEAN,
348: x_change_vector_value IN NUMBER

Line 416: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

412: |
413: +============================================================================*/
414: FUNCTION Merge_Data_From_Tables(
415: x_table_name IN VARCHAR2,
416: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
417: x_num_key_columns IN NUMBER
418: ) RETURN BOOLEAN;
419:
420:

Line 426: x_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2,

422: | FUNCTION Merge_Projection |
423: +============================================================================*/
424: FUNCTION Merge_Projection(
425: x_table_name VARCHAR2,
426: x_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2,
427: x_num_key_columns NUMBER,
428: x_data_columns BSC_UPDATE_UTIL.t_array_of_varchar2,
429: x_num_data_columns NUMBER,
430: x_is_base BOOLEAN,

Line 428: x_data_columns BSC_UPDATE_UTIL.t_array_of_varchar2,

424: FUNCTION Merge_Projection(
425: x_table_name VARCHAR2,
426: x_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2,
427: x_num_key_columns NUMBER,
428: x_data_columns BSC_UPDATE_UTIL.t_array_of_varchar2,
429: x_num_data_columns NUMBER,
430: x_is_base BOOLEAN,
431: x_aw_flag BOOLEAN
432: ) RETURN BOOLEAN;

Line 454: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2 ,

450: |
451: +============================================================================*/
452: FUNCTION Refresh_EDW_Views(
453: x_table_name IN VARCHAR2,
454: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2 ,
455: x_num_key_columns IN NUMBER ,
456: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
457: x_num_data_columns IN NUMBER,
458: x_current_fy IN NUMBER,

Line 456: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

452: FUNCTION Refresh_EDW_Views(
453: x_table_name IN VARCHAR2,
454: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2 ,
455: x_num_key_columns IN NUMBER ,
456: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
457: x_num_data_columns IN NUMBER,
458: x_current_fy IN NUMBER,
459: x_periodicity IN NUMBER,
460: x_current_period OUT NOCOPY NUMBER

Line 480: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

476: x_periodicity IN NUMBER,
477: x_period IN NUMBER,
478: x_base_periodicity IN NUMBER,
479: x_base_period IN NUMBER,
480: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
481: x_num_key_columns IN NUMBER,
482: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
483: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
484: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

Line 482: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,

478: x_base_periodicity IN NUMBER,
479: x_base_period IN NUMBER,
480: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
481: x_num_key_columns IN NUMBER,
482: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
483: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
484: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
485: x_num_data_columns IN NUMBER,
486: x_current_fy IN NUMBER,

Line 483: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,

479: x_base_period IN NUMBER,
480: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
481: x_num_key_columns IN NUMBER,
482: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
483: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
484: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
485: x_num_data_columns IN NUMBER,
486: x_current_fy IN NUMBER,
487: x_is_base IN BOOLEAN

Line 484: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,

480: x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
481: x_num_key_columns IN NUMBER,
482: x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
483: x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
484: x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
485: x_num_data_columns IN NUMBER,
486: x_current_fy IN NUMBER,
487: x_is_base IN BOOLEAN
488: ) RETURN BOOLEAN;