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_BASE

Line 1313: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_table_info.table_name);

1309:
1310: --ENH_B_TABLES_PERF: In the new strategy the base table may have a projection table
1311: -- In this case we need to truncate the projection table and we do not need to touch
1312: -- the base table since it contains only actuals.
1313: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_table_info.table_name);
1314: IF h_proj_tbl_name IS NOT NULL THEN
1315: BSC_UPDATE_UTIL.Truncate_Table_AT(h_proj_tbl_name);
1316: ELSE
1317: IF h_table_info.yearly_flag = 1 THEN

Line 1397: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_table_info.table_name);

1393: IF BSC_UPDATE_UTIL.Table_Exists(h_table_info.table_name) THEN
1394: --ENH_B_TABLES_PERF: In the new strategy the base table may have a projection table
1395: -- In this case we need to truncate the projection table and we do not need to touch
1396: -- the base table since it contains only actuals.
1397: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_table_info.table_name);
1398: IF h_proj_tbl_name IS NOT NULL THEN
1399: BSC_UPDATE_UTIL.Truncate_Table_AT(h_proj_tbl_name);
1400: ELSE
1401: IF h_table_info.yearly_flag = 1 THEN

Line 1518: h_aw_table_name := BSC_UPDATE_BASE.Get_Base_AW_Table_Name(h_aw_base_tables(h_i));

1514: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_aw_base_tables(h_i)) THEN
1515: RAISE e_could_not_get_lock;
1516: END IF;
1517:
1518: h_aw_table_name := BSC_UPDATE_BASE.Get_Base_AW_Table_Name(h_aw_base_tables(h_i));
1519:
1520: --LOCKING: call the autonomous transaction function
1521: BSC_UPDATE_UTIL.Truncate_Table_AT(h_aw_table_name);
1522:

Line 2941: IF NOT BSC_UPDATE_BASE.Create_Generic_Temp_Tables_AT THEN

2937: RAISE e_could_not_get_lock;
2938: END IF;
2939:
2940: --LOCKING: call the autonomous transaction function
2941: IF NOT BSC_UPDATE_BASE.Create_Generic_Temp_Tables_AT THEN
2942: RAISE e_unexpected_error;
2943: END IF;
2944:
2945: -- ENH_B_TABLES_PERF: create new temporary tables needed in the new strategy

Line 2946: IF NOT BSC_UPDATE_BASE_V2.Create_Generic_Temp_Tables_AT THEN

2942: RAISE e_unexpected_error;
2943: END IF;
2944:
2945: -- ENH_B_TABLES_PERF: create new temporary tables needed in the new strategy
2946: IF NOT BSC_UPDATE_BASE_V2.Create_Generic_Temp_Tables_AT THEN
2947: RAISE e_unexpected_error;
2948: END IF;
2949:
2950: --LOCKING: commit to release the locks

Line 3041: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);

3037: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_BASE_TABLE')||
3038: ' '||h_base_table, BSC_UPDATE_LOG.OUTPUT);
3039:
3040: -- ENH_B_TABLES_PERF: If the base table has a projection table then this is a new strategy.
3041: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);
3042: IF h_proj_tbl_name IS NULL THEN
3043: -- AW_INTEGRATION: pass h_aw_flag
3044: -- LOCKING: call the autonomous transaction function
3045: IF NOT BSC_UPDATE_BASE.Calculate_Base_Table_AT(h_base_table, h_input_table, FALSE, h_aw_flag) THEN

Line 3045: IF NOT BSC_UPDATE_BASE.Calculate_Base_Table_AT(h_base_table, h_input_table, FALSE, h_aw_flag) THEN

3041: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);
3042: IF h_proj_tbl_name IS NULL THEN
3043: -- AW_INTEGRATION: pass h_aw_flag
3044: -- LOCKING: call the autonomous transaction function
3045: IF NOT BSC_UPDATE_BASE.Calculate_Base_Table_AT(h_base_table, h_input_table, FALSE, h_aw_flag) THEN
3046: RAISE e_unexpected_error;
3047: END IF;
3048: ELSE
3049: -- New strategy for better performance.

Line 3050: IF NOT BSC_UPDATE_BASE_V2.Calculate_Base_Table_AT(h_base_table, h_input_table, FALSE, h_aw_flag) THEN

3046: RAISE e_unexpected_error;
3047: END IF;
3048: ELSE
3049: -- New strategy for better performance.
3050: IF NOT BSC_UPDATE_BASE_V2.Calculate_Base_Table_AT(h_base_table, h_input_table, FALSE, h_aw_flag) THEN
3051: RAISE e_unexpected_error;
3052: END IF;
3053: END IF;
3054:

Line 3211: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);

3207: h_aw_flag := FALSE;
3208: END IF;
3209:
3210: -- ENH_B_TABLES_PERF: If the base table has a projection table then this is a new strategy.
3211: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);
3212: IF h_proj_tbl_name IS NULL THEN
3213: -- AW_INTEGRATION: pass h_aw_flag
3214: -- LOCKING: call the autonomous transaction function
3215: IF NOT BSC_UPDATE_BASE.Calculate_Base_Table_AT(h_base_table, x_input_tables(h_i), TRUE, h_aw_flag) THEN

Line 3215: IF NOT BSC_UPDATE_BASE.Calculate_Base_Table_AT(h_base_table, x_input_tables(h_i), TRUE, h_aw_flag) THEN

3211: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);
3212: IF h_proj_tbl_name IS NULL THEN
3213: -- AW_INTEGRATION: pass h_aw_flag
3214: -- LOCKING: call the autonomous transaction function
3215: IF NOT BSC_UPDATE_BASE.Calculate_Base_Table_AT(h_base_table, x_input_tables(h_i), TRUE, h_aw_flag) THEN
3216: RAISE e_unexpected_error;
3217: END IF;
3218: ELSE
3219: -- New strategy for better performance.

Line 3220: IF NOT BSC_UPDATE_BASE_V2.Calculate_Base_Table_AT(h_base_table, x_input_tables(h_i), TRUE, h_aw_flag) THEN

3216: RAISE e_unexpected_error;
3217: END IF;
3218: ELSE
3219: -- New strategy for better performance.
3220: IF NOT BSC_UPDATE_BASE_V2.Calculate_Base_Table_AT(h_base_table, x_input_tables(h_i), TRUE, h_aw_flag) THEN
3221: RAISE e_unexpected_error;
3222: END IF;
3223: END IF;
3224: