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_INC dependencies on BSC_APPS

Line 41: h_where_tables := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, 'table_name');

37: x_purge_tables(x_num_purge_tables) := x_tables(h_i);
38: END IF;
39: END LOOP;
40:
41: h_where_tables := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, 'table_name');
42:
43: FOR h_i IN 1 .. x_num_tables LOOP
44: -- Insert the child tables
45: h_sql := 'SELECT table_name';

Line 59: BSC_APPS.Add_Value_Big_In_Cond(1, h_table_name);

55:
56: h_num_new_tables := h_num_new_tables + 1;
57: h_new_tables(h_num_new_tables) := h_table_name;
58:
59: BSC_APPS.Add_Value_Big_In_Cond(1, h_table_name);
60: END IF;
61:
62: FETCH h_cursor INTO h_table_name;
63: END LOOP;

Line 81: BSC_APPS.Add_Value_Big_In_Cond(1, h_table_name);

77:
78: h_num_new_tables := h_num_new_tables + 1;
79: h_new_tables(h_num_new_tables) := h_table_name;
80:
81: BSC_APPS.Add_Value_Big_In_Cond(1, h_table_name);
82: END IF;
83:
84: FETCH h_cursor INTO h_table_name;
85: END LOOP;

Line 216: IF BSC_APPS.bsc_mv THEN

212: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INITIALIZED'), BSC_UPDATE_LOG.OUTPUT);
213: END IF;
214:
215: -- We need to load reporting calendar and load calendar into aw
216: IF BSC_APPS.bsc_mv THEN
217: --LOCKING: call the autonomous transaction
218: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar_AT(h_calendar_id, h_error_message) THEN
219: RAISE e_error_load_rpt_cal;
220: END IF;

Line 495: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

491: IF BSC_UPDATE.g_kpi_mode THEN
492:
493: IF BSC_UPDATE.g_num_indicators > 0 THEN
494:
495: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
496: FOR h_i IN 1 .. BSC_UPDATE.g_num_indicators LOOP
497: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
498: END LOOP;
499: h_sql := h_sql||' AND ('||h_where_indics||')';

Line 497: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));

493: IF BSC_UPDATE.g_num_indicators > 0 THEN
494:
495: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
496: FOR h_i IN 1 .. BSC_UPDATE.g_num_indicators LOOP
497: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
498: END LOOP;
499: h_sql := h_sql||' AND ('||h_where_indics||')';
500: END IF;
501: END IF;

Line 635: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'k.indicator');

631: --BSC-BIS-DIMENSIONS: If Loader is running in KPI_MODE only consider indicators
632: -- in g_indicators
633: IF BSC_UPDATE.g_kpi_mode THEN
634: IF BSC_UPDATE.g_num_indicators > 0 THEN
635: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'k.indicator');
636: FOR h_i IN 1 .. BSC_UPDATE.g_num_indicators LOOP
637: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
638: END LOOP;
639: h_sql := h_sql||' AND ('||h_where_indics||')';

Line 637: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));

633: IF BSC_UPDATE.g_kpi_mode THEN
634: IF BSC_UPDATE.g_num_indicators > 0 THEN
635: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'k.indicator');
636: FOR h_i IN 1 .. BSC_UPDATE.g_num_indicators LOOP
637: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
638: END LOOP;
639: h_sql := h_sql||' AND ('||h_where_indics||')';
640: END IF;
641: END IF;

Line 884: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

880:
881: -- Initialize the array h_system_tables with the tables used for the
882: -- indicators in x_purge_indicators
883: IF x_num_purge_indicators > 0 THEN
884: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
885: FOR h_i IN 1 .. x_num_purge_indicators LOOP
886: BSC_APPS.Add_Value_Big_In_Cond(1, x_purge_indicators(h_i));
887:
888: --AW_INTEGRATION: We need to truncate the cubes of the Aw indicators.

Line 886: BSC_APPS.Add_Value_Big_In_Cond(1, x_purge_indicators(h_i));

882: -- indicators in x_purge_indicators
883: IF x_num_purge_indicators > 0 THEN
884: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
885: FOR h_i IN 1 .. x_num_purge_indicators LOOP
886: BSC_APPS.Add_Value_Big_In_Cond(1, x_purge_indicators(h_i));
887:
888: --AW_INTEGRATION: We need to truncate the cubes of the Aw indicators.
889: --I am going to add aw kpis in the array h_aw_indicators to be truncated later.
890: IF BSC_UPDATE_UTIL.Get_Kpi_Impl_Type(x_purge_indicators(h_i)) = 2 THEN

Line 926: h_where_tables := BSC_APPS.Get_New_Big_In_Cond_Varchar2(2, 'table_name');

922: RAISE e_unexpected_error;
923: END IF;
924:
925: -- Build the condition string on the tables names to purge
926: h_where_tables := BSC_APPS.Get_New_Big_In_Cond_Varchar2(2, 'table_name');
927: FOR h_i IN 1 .. h_num_purge_tables LOOP
928: BSC_APPS.Add_Value_Big_In_Cond(2, h_purge_tables(h_i));
929: END LOOP;
930:

Line 928: BSC_APPS.Add_Value_Big_In_Cond(2, h_purge_tables(h_i));

924:
925: -- Build the condition string on the tables names to purge
926: h_where_tables := BSC_APPS.Get_New_Big_In_Cond_Varchar2(2, 'table_name');
927: FOR h_i IN 1 .. h_num_purge_tables LOOP
928: BSC_APPS.Add_Value_Big_In_Cond(2, h_purge_tables(h_i));
929: END LOOP;
930:
931: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPIDATA_DELETION'), BSC_UPDATE_LOG.OUTPUT);
932:

Line 947: BSC_APPS.Add_Value_Big_In_Cond(1, h_indicator);

943:
944: OPEN h_cursor FOR h_sql;
945: FETCH h_cursor INTO h_indicator;
946: WHILE h_cursor%FOUND LOOP
947: BSC_APPS.Add_Value_Big_In_Cond(1, h_indicator);
948:
949: BSC_UPDATE_LOG.Write_Line_log(h_indicator, BSC_UPDATE_LOG.OUTPUT);
950:
951: --AW_INTEGRATION: We need to truncate the cubes of the Aw indicators.

Line 977: IF BSC_APPS.bsc_mv THEN

973: -- and summary tables created for projections at kpi level.
974: -- By design those tables has generation_type <> -1
975: -- Then we need to refresh all the MVs affected by those base tables to delete the data.
976: -- AW_INTEGRATION: no changes to this portion of code, same logic applies to AW
977: IF BSC_APPS.bsc_mv THEN
978: h_where_tables_mv := BSC_APPS.Get_New_Big_In_Cond_Varchar2(3, 'r.table_name');
979: END IF;
980:
981: FOR h_i IN 1 .. h_num_purge_tables LOOP

Line 978: h_where_tables_mv := BSC_APPS.Get_New_Big_In_Cond_Varchar2(3, 'r.table_name');

974: -- By design those tables has generation_type <> -1
975: -- Then we need to refresh all the MVs affected by those base tables to delete the data.
976: -- AW_INTEGRATION: no changes to this portion of code, same logic applies to AW
977: IF BSC_APPS.bsc_mv THEN
978: h_where_tables_mv := BSC_APPS.Get_New_Big_In_Cond_Varchar2(3, 'r.table_name');
979: END IF;
980:
981: FOR h_i IN 1 .. h_num_purge_tables LOOP
982: IF BSC_APPS.bsc_mv THEN

Line 982: IF BSC_APPS.bsc_mv THEN

978: h_where_tables_mv := BSC_APPS.Get_New_Big_In_Cond_Varchar2(3, 'r.table_name');
979: END IF;
980:
981: FOR h_i IN 1 .. h_num_purge_tables LOOP
982: IF BSC_APPS.bsc_mv THEN
983: -- BSC-MV Architecture
984:
985: IF BSC_UPDATE_UTIL.Get_Table_Generation_Type(h_purge_tables(h_i)) <> -1 THEN
986: -- It is an input, base table or a table created to store the projection at kpi level

Line 1019: BSC_APPS.Add_Value_Big_In_Cond(3, h_purge_tables(h_i));

1015: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_DELETION');
1016: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_purge_tables(h_i));
1017: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);
1018:
1019: BSC_APPS.Add_Value_Big_In_Cond(3, h_purge_tables(h_i));
1020: END IF;
1021: ELSE
1022: -- We can truncate the table no matter if it is an input table
1023:

Line 1046: BSC_APPS.Add_Value_Big_In_Cond(3, h_purge_tables(h_i));

1042: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_DELETION');
1043: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_purge_tables(h_i));
1044: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);
1045:
1046: BSC_APPS.Add_Value_Big_In_Cond(3, h_purge_tables(h_i));
1047: END IF;
1048: END IF;
1049: ELSE
1050: -- Summary tables architecture

Line 1113: IF BSC_APPS.bsc_mv THEN

1109:
1110: -- BSC-MV Note: Refresh all MVs affected by the base tables
1111: -- AW_INTEGRATION: For Aw kpis, we need to truncate the AW table created for the base table
1112: -- and also we need to tuncate the kpi cubes.
1113: IF BSC_APPS.bsc_mv THEN
1114: -- Get the base tables
1115: h_sql := 'SELECT r.table_name'||
1116: ' FROM bsc_db_tables_rels r, bsc_db_tables t'||
1117: ' WHERE r.source_table_name = t.table_name AND'||

Line 1378: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

1374: h_sql_kpi := 'UPDATE bsc_kpi_analysis_measures_b ' ||
1375: ' SET prototype_flag = 0 ' ||
1376: ' WHERE prototype_flag = 7 ';
1377:
1378: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
1379: FOR h_i IN 1 .. BSC_UPDATE.g_num_indicators LOOP
1380: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
1381: END LOOP;
1382: h_sql := h_sql || ' AND (' || h_where_indics || ')';

Line 1380: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));

1376: ' WHERE prototype_flag = 7 ';
1377:
1378: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
1379: FOR h_i IN 1 .. BSC_UPDATE.g_num_indicators LOOP
1380: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
1381: END LOOP;
1382: h_sql := h_sql || ' AND (' || h_where_indics || ')';
1383: h_sql_kpi := h_sql_kpi || ' AND (' || h_where_indics || ')';
1384: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);