APPS.BSC_UPDATE dependencies on BSC_UPDATE_COLOR

Line 1248: SET kpi_color = BSC_UPDATE_COLOR.GRAY,

1244:
1245:
1246: -- All colors in the panel have to be gray
1247: UPDATE bsc_sys_kpi_colors
1248: SET kpi_color = BSC_UPDATE_COLOR.GRAY,
1249: actual_data = NULL,
1250: budget_data = NULL
1251: WHERE indicator = h_indicator;
1252:

Line 1254: SET obj_color = BSC_UPDATE_COLOR.GRAY

1250: budget_data = NULL
1251: WHERE indicator = h_indicator;
1252:
1253: UPDATE bsc_sys_objective_colors
1254: SET obj_color = BSC_UPDATE_COLOR.GRAY
1255: WHERE indicator = h_indicator;
1256:
1257:
1258: -- Update the name of period of indicators in BSC_KPI_DEFAULTS_TL table

Line 3506: IF NOT BSC_UPDATE_COLOR.Create_Temp_Tab_Tables_AT() THEN

3502: RAISE e_could_not_get_lock;
3503: END IF;
3504:
3505: -- LOCKING: call the autonomous transaction function
3506: IF NOT BSC_UPDATE_COLOR.Create_Temp_Tab_Tables_AT() THEN
3507: RAISE e_unexpected_error;
3508: END IF;
3509:
3510: --LOCKING: Commit to release locks

Line 3560: IF NOT BSC_UPDATE_COLOR.Color_Indicator_AT(h_color_indicators(h_i)) THEN

3556: RAISE e_could_not_get_lock;
3557: END IF;
3558:
3559: -- LOCKING: Call the autonomous transaction
3560: IF NOT BSC_UPDATE_COLOR.Color_Indicator_AT(h_color_indicators(h_i)) THEN
3561: RAISE e_unexpected_error;
3562: END IF;
3563:
3564: -- LOCKING: Commit to release the locks