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_UPDATE_LOCK

Line 199: IF NOT BSC_UPDATE_LOCK.Lock_Calendar(h_calendar_id) THEN

195:
196: IF BSC_UPDATE_UTIL.Get_Calendar_EDW_Flag(h_calendar_id) = 0 THEN
197: -- This is just for BSC Calendars
198: --LOCKING: Lock the calendar
199: IF NOT BSC_UPDATE_LOCK.Lock_Calendar(h_calendar_id) THEN
200: RAISE e_could_not_get_lock;
201: END IF;
202:
203: -- Fix bug#3822940 We need to validate that this is not a DBI calendar

Line 238: IF NOT BSC_UPDATE_LOCK.Lock_Calendar(h_calendar_id) THEN

234: END IF;
235:
236: -- Reset FISCAL_CHANGE variable to 0
237: --LOCKING: Lock the calendar
238: IF NOT BSC_UPDATE_LOCK.Lock_Calendar(h_calendar_id) THEN
239: RAISE e_could_not_get_lock;
240: END IF;
241:
242: UPDATE bsc_sys_calendars_b

Line 252: IF NOT BSC_UPDATE_LOCK.Lock_Prototype_Indicators(h_calendar_id) THEN

248:
249: -- Reset the flags for the indicators (flag = 6 or 7) to 0 because now there
250: -- is no data to update.
251: --LOCKING: lock indicators prototype
252: IF NOT BSC_UPDATE_LOCK.Lock_Prototype_Indicators(h_calendar_id) THEN
253: RAISE e_could_not_get_lock;
254: END IF;
255:
256: UPDATE bsc_kpis_b

Line 301: IF NOT BSC_UPDATE_LOCK.Lock_Temp_Tables('COLOR') THEN

297: END IF;
298:
299: IF h_num_color_indicators > 0 THEN
300: -- LOCKING: Lock temp tables for coloring
301: IF NOT BSC_UPDATE_LOCK.Lock_Temp_Tables('COLOR') THEN
302: RAISE e_could_not_get_lock;
303: END IF;
304:
305: -- LOCKING: call the autonomous transaction function

Line 320: IF NOT BSC_UPDATE_LOCK.Lock_Color_Indicator(h_color_indicators(h_i)) THEN

316: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||' '||h_color_indicators(h_i),
317: BSC_UPDATE_LOG.OUTPUT);
318:
319: --LOCKING: Lock indicator color
320: IF NOT BSC_UPDATE_LOCK.Lock_Color_Indicator(h_color_indicators(h_i)) THEN
321: RAISE e_could_not_get_lock;
322: END IF;
323:
324: -- LOCKING: Call the autonomous transaction

Line 339: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN

335: BSC_UPDATE_LOG.OUTPUT);
336:
337:
338: --LOCKING: Lock the update period of the indicator
339: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN
340: RAISE e_could_not_get_lock;
341: END IF;
342:
343: -- LOCKING: review not commit between this point and the commit to release the locks

Line 364: IF NOT BSC_UPDATE_LOCK.Lock_Prototype_Indicators THEN

360: END IF;
361:
362: -- Reset the flags for the indicators (flag = 6 or 7) to 0
363: --LOCKING: lock the indicators with prototype flag 6 or 7
364: IF NOT BSC_UPDATE_LOCK.Lock_Prototype_Indicators THEN
365: RAISE e_could_not_get_lock;
366: END IF;
367:
368: IF NOT Reset_Flag_Indicators() THEN

Line 998: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN

994: IF BSC_UPDATE_UTIL.Get_Table_Type(h_purge_tables(h_i)) <> 0 THEN
995: -- It is not an input table, we can truncate it.
996:
997: --LOCKING: Lock the table
998: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN
999: RAISE e_could_not_get_lock;
1000: END IF;
1001:
1002: --LOCKING: Call the autonomous transaction function

Line 1025: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN

1021: ELSE
1022: -- We can truncate the table no matter if it is an input table
1023:
1024: --LOCKING: Lock the table
1025: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN
1026: RAISE e_could_not_get_lock;
1027: END IF;
1028:
1029: --LOCKING: Call the autonomous transaction function

Line 1062: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN

1058: IF BSC_UPDATE_UTIL.Get_Table_Type(h_purge_tables(h_i)) <> 0 THEN
1059: -- It is not an input table, we can truncate it.
1060:
1061: --LOCKING: Lock the table
1062: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN
1063: RAISE e_could_not_get_lock;
1064: END IF;
1065:
1066: --LOCKING: Call the autonomous transaction function

Line 1086: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN

1082: END IF;
1083: ELSE
1084: -- We can truncate all tables no matter if it is an input table
1085: --LOCKING: Lock the table
1086: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_purge_tables(h_i)) THEN
1087: RAISE e_could_not_get_lock;
1088: END IF;
1089:
1090: --LOCKING: Call the autonomous transaction function

Line 1147: IF NOT BSC_UPDATE_LOCK.Lock_AW_Indicator_Cubes(h_aw_indicators(h_i)) THEN

1143:
1144: -- AW_INTEGRATION: Truncate kpis cubes
1145: FOR h_i IN 1..h_num_aw_indicators LOOP
1146: --LOCKING: lock the aw cubes of the indicator
1147: IF NOT BSC_UPDATE_LOCK.Lock_AW_Indicator_Cubes(h_aw_indicators(h_i)) THEN
1148: RAISE e_could_not_get_lock;
1149: END IF;
1150:
1151: --LOCKING: call the autonomous transaction procedure

Line 1161: IF NOT BSC_UPDATE_LOCK.Lock_Color_Indicators(h_lock_indicators, h_num_lock_indicators) THEN

1157: END IF;
1158:
1159: -- Reset to gray the color of the indicators
1160: --LOCKING: Lock the color of the indicators
1161: IF NOT BSC_UPDATE_LOCK.Lock_Color_Indicators(h_lock_indicators, h_num_lock_indicators) THEN
1162: RAISE e_could_not_get_lock;
1163: END IF;
1164:
1165: h_sql := 'UPDATE bsc_sys_kpi_colors';

Line 1188: IF NOT BSC_UPDATE_LOCK.Lock_Tables(h_purge_tables, h_num_purge_tables) THEN

1184:
1185: -- Reset some information by calendar
1186: --LOCKING: Lock the tables. We are going to udate the current period of
1187: -- all the tables and we need to prevent loader is processing those tables at the same time
1188: IF NOT BSC_UPDATE_LOCK.Lock_Tables(h_purge_tables, h_num_purge_tables) THEN
1189: RAISE e_could_not_get_lock;
1190: END IF;
1191:
1192: --LOCKING: Lock the update period of the indicators. We are going to upadte the current period

Line 1194: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicators(h_lock_indicators, h_num_lock_indicators) THEN

1190: END IF;
1191:
1192: --LOCKING: Lock the update period of the indicators. We are going to upadte the current period
1193: -- of all the affected indicators
1194: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicators(h_lock_indicators, h_num_lock_indicators) THEN
1195: RAISE e_could_not_get_lock;
1196: END IF;
1197:
1198: -- LOCKING: review not commit between this point and the commit to release the locks