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

Line 57: g_indicators BSC_UPDATE_UTIL.t_array_of_number;

53: g_session_id NUMBER;
54: g_user_id NUMBER;
55: g_schema_name VARCHAR2(30);
56:
57: g_indicators BSC_UPDATE_UTIL.t_array_of_number;
58: g_num_indicators NUMBER;
59: g_kpi_mode BOOLEAN;
60: g_keep_input_table_data varchar2(20);
61:

Line 89: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

85: |
86: +============================================================================*/
87: FUNCTION Can_Calculate_Sys_Table(
88: x_system_table IN VARCHAR2,
89: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
90: x_num_calculated_sys_tables IN NUMBER,
91: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
92: x_num_system_tables IN NUMBER
93: ) RETURN BOOLEAN;

Line 91: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

87: FUNCTION Can_Calculate_Sys_Table(
88: x_system_table IN VARCHAR2,
89: x_calculated_sys_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
90: x_num_calculated_sys_tables IN NUMBER,
91: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
92: x_num_system_tables IN NUMBER
93: ) RETURN BOOLEAN;
94:
95:

Line 116: x_loaded_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

112: |
113: +============================================================================*/
114: FUNCTION Can_Load_Dim_Table(
115: x_dim_table IN VARCHAR2,
116: x_loaded_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
117: x_num_loaded_tables IN NUMBER,
118: x_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
119: x_num_dim_tables IN NUMBER
120: ) RETURN BOOLEAN;

Line 118: x_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

114: FUNCTION Can_Load_Dim_Table(
115: x_dim_table IN VARCHAR2,
116: x_loaded_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
117: x_num_loaded_tables IN NUMBER,
118: x_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
119: x_num_dim_tables IN NUMBER
120: ) RETURN BOOLEAN;
121:
122:

Line 335: x_edw_dim_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

331: | Notes:
332: |
333: +============================================================================*/
334: FUNCTION Get_EDW_Dims_In_Input_Tables (
335: x_edw_dim_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
336: x_num_edw_dim_tables IN OUT NOCOPY NUMBER
337: ) RETURN BOOLEAN;
338:
339:

Line 363: x_base_tables_to_color IN BSC_UPDATE_UTIL.t_array_of_varchar2,

359: | Notes:
360: |
361: +============================================================================*/
362: FUNCTION Get_Indicators_To_Color(
363: x_base_tables_to_color IN BSC_UPDATE_UTIL.t_array_of_varchar2,
364: x_num_base_tables_to_color IN NUMBER,
365: x_color_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
366: x_num_color_indicators IN OUT NOCOPY NUMBER
367: ) RETURN BOOLEAN;

Line 365: x_color_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,

361: +============================================================================*/
362: FUNCTION Get_Indicators_To_Color(
363: x_base_tables_to_color IN BSC_UPDATE_UTIL.t_array_of_varchar2,
364: x_num_base_tables_to_color IN NUMBER,
365: x_color_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
366: x_num_color_indicators IN OUT NOCOPY NUMBER
367: ) RETURN BOOLEAN;
368:
369:

Line 447: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

443: | Notes:
444: |
445: +============================================================================*/
446: FUNCTION Get_Process_Input_Tables (
447: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
448: x_num_input_tables IN OUT NOCOPY NUMBER,
449: x_status IN VARCHAR2
450: ) RETURN BOOLEAN;
451:

Line 487: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

483: | Notes:
484: |
485: +============================================================================*/
486: FUNCTION Import_ITables_From_DBSrc(
487: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
488: x_num_input_tables IN NUMBER
489: ) RETURN BOOLEAN;
490:
491: --LOCKING: new function

Line 493: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

489: ) RETURN BOOLEAN;
490:
491: --LOCKING: new function
492: FUNCTION Import_ITables_From_DBSrc_AT(
493: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
494: x_num_input_tables IN NUMBER
495: ) RETURN BOOLEAN;
496:
497:

Line 548: x_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

544: | Notes:
545: |
546: +============================================================================*/
547: FUNCTION Insert_Affected_Tables (
548: x_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
549: x_num_tables IN NUMBER,
550: x_affected_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
551: x_num_affected_tables IN OUT NOCOPY NUMBER
552: ) RETURN BOOLEAN;

Line 550: x_affected_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

546: +============================================================================*/
547: FUNCTION Insert_Affected_Tables (
548: x_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
549: x_num_tables IN NUMBER,
550: x_affected_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
551: x_num_affected_tables IN OUT NOCOPY NUMBER
552: ) RETURN BOOLEAN;
553:
554:

Line 573: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

569: | Notes:
570: |
571: +============================================================================*/
572: FUNCTION Load_Dim_Input_Tables(
573: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
574: x_num_input_tables IN NUMBER
575: ) RETURN BOOLEAN;
576:
577:

Line 588: x_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

584: | It does in a proper oder parents first then the childs.
585: |
586: +============================================================================*/
587: FUNCTION Load_Dims_Into_AW(
588: x_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
589: x_num_dim_tables IN NUMBER
590: ) RETURN BOOLEAN;
591:
592:

Line 621: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

617: | Notes:
618: |
619: +============================================================================*/
620: FUNCTION Process_Input_Tables(
621: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
622: x_num_input_tables IN NUMBER,
623: x_start_from IN NUMBER
624: ) RETURN BOOLEAN;
625:

Line 628: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

624: ) RETURN BOOLEAN;
625:
626: --LOCKING: new function
627: FUNCTION Process_Input_Tables_AT(
628: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
629: x_num_input_tables IN NUMBER,
630: x_start_from IN NUMBER
631: ) RETURN BOOLEAN;
632:

Line 647: p_base_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

643: | Notes:
644: |
645: +============================================================================*/
646: FUNCTION Refresh_System_MVs(
647: p_base_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
648: p_num_base_tables IN NUMBER
649: ) RETURN BOOLEAN;
650:
651: FUNCTION Refresh_System_MVs_Mig(

Line 652: p_base_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

648: p_num_base_tables IN NUMBER
649: ) RETURN BOOLEAN;
650:
651: FUNCTION Refresh_System_MVs_Mig(
652: p_base_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
653: p_num_base_tables IN NUMBER
654: ) RETURN BOOLEAN;
655:
656:

Line 882: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,

878: | array x_indicators
879: |
880: +============================================================================*/
881: FUNCTION Get_Input_Tables_Kpis(
882: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
883: x_num_indicators IN NUMBER,
884: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
885: x_num_input_tables IN OUT NOCOPY NUMBER
886: ) RETURN BOOLEAN;

Line 884: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

880: +============================================================================*/
881: FUNCTION Get_Input_Tables_Kpis(
882: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
883: x_num_indicators IN NUMBER,
884: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
885: x_num_input_tables IN OUT NOCOPY NUMBER
886: ) RETURN BOOLEAN;
887:
888:

Line 899: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,

895: | in the array x_indicators
896: |
897: +============================================================================*/
898: FUNCTION Get_Dim_Input_Tables_Kpis(
899: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
900: x_num_indicators IN NUMBER,
901: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
902: x_num_input_tables IN OUT NOCOPY NUMBER
903: ) RETURN BOOLEAN;

Line 901: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,

897: +============================================================================*/
898: FUNCTION Get_Dim_Input_Tables_Kpis(
899: x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
900: x_num_indicators IN NUMBER,
901: x_input_tables IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
902: x_num_input_tables IN OUT NOCOPY NUMBER
903: ) RETURN BOOLEAN;
904:
905:

Line 1099: x_requests IN BSC_UPDATE_UTIL.t_array_of_number,

1095: /*===========================================================================+
1096: | FUNCTION Wait_For_Requests
1097: +============================================================================*/
1098: FUNCTION Wait_For_Requests(
1099: x_requests IN BSC_UPDATE_UTIL.t_array_of_number,
1100: x_num_requests IN NUMBER
1101: ) RETURN BOOLEAN;
1102:
1103: function get_kpi_for_input_tables(

Line 1104: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

1100: x_num_requests IN NUMBER
1101: ) RETURN BOOLEAN;
1102:
1103: function get_kpi_for_input_tables(
1104: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
1105: x_num_input_tables IN NUMBER,
1106: x_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
1107: x_num_indicators IN OUT NOCOPY NUMBER
1108: )return boolean;

Line 1106: x_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,

1102:
1103: function get_kpi_for_input_tables(
1104: x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
1105: x_num_input_tables IN NUMBER,
1106: x_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
1107: x_num_indicators IN OUT NOCOPY NUMBER
1108: )return boolean;
1109:
1110: function get_kpi_for_input_tables(

Line 1112: x_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,

1108: )return boolean;
1109:
1110: function get_kpi_for_input_tables(
1111: x_input_table varchar2,
1112: x_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
1113: x_num_indicators IN OUT NOCOPY NUMBER
1114: )return boolean;
1115:
1116: function value_in_array(

Line 1118: x_array BSC_UPDATE_UTIL.t_array_of_number,

1114: )return boolean;
1115:
1116: function value_in_array(
1117: x_value number,
1118: x_array BSC_UPDATE_UTIL.t_array_of_number,
1119: x_num_array NUMBER
1120: )return boolean;
1121:
1122: /*===========================================================================+

Line 1126: x_number_array IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number

1122: /*===========================================================================+
1123: | FUNCTION Get_Indicator_List
1124: +============================================================================*/
1125: function Get_Indicator_List(
1126: x_number_array IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number
1127: )return number;
1128:
1129: --Fix bug#4681065
1130: PROCEDURE Write_Warning_Kpis_In_Prot (

Line 1131: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,

1127: )return number;
1128:
1129: --Fix bug#4681065
1130: PROCEDURE Write_Warning_Kpis_In_Prot (
1131: x_system_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
1132: x_num_system_tables IN NUMBER
1133: );
1134:
1135: END BSC_UPDATE;