APPS.BSC_UPDATE_INC dependencies on BSC_UPDATE_COLOR

Line 306: IF NOT BSC_UPDATE_COLOR.Create_Temp_Tab_Tables_AT() THEN

302: RAISE e_could_not_get_lock;
303: END IF;
304:
305: -- LOCKING: call the autonomous transaction function
306: IF NOT BSC_UPDATE_COLOR.Create_Temp_Tab_Tables_AT() THEN
307: RAISE e_unexpected_error;
308: END IF;
309:
310: --LOCKING: Commit to release locks

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

321: RAISE e_could_not_get_lock;
322: END IF;
323:
324: -- LOCKING: Call the autonomous transaction
325: IF NOT BSC_UPDATE_COLOR.Color_Indicator_AT(h_color_indicators(h_i)) THEN
326: RAISE e_unexpected_error;
327: END IF;
328:
329: -- LOCKING: Commit to release the locks

Line 1171: l_bind_vars_values(1) := BSC_UPDATE_COLOR.GRAY;

1167: h_sql := h_sql||' actual_data = NULL,';
1168: h_sql := h_sql||' budget_data = NULL';
1169: h_sql := h_sql||' WHERE ('||h_where_indics||')';
1170: l_bind_vars_values.delete;
1171: l_bind_vars_values(1) := BSC_UPDATE_COLOR.GRAY;
1172: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,l_bind_vars_values,1);
1173:
1174: h_sql := 'UPDATE bsc_sys_objective_colors';
1175: h_sql := h_sql||' SET obj_color = :1 ';

Line 1178: l_bind_vars_values(1) := BSC_UPDATE_COLOR.GRAY;

1174: h_sql := 'UPDATE bsc_sys_objective_colors';
1175: h_sql := h_sql||' SET obj_color = :1 ';
1176: h_sql := h_sql||' WHERE ('||h_where_indics||')';
1177: l_bind_vars_values.delete;
1178: l_bind_vars_values(1) := BSC_UPDATE_COLOR.GRAY;
1179: BSC_UPDATE_UTIL.Execute_Immediate(h_sql,l_bind_vars_values,1);
1180:
1181:
1182: --LOCKING: commit to release the locks