APPS.BSC_UPDATE_UTIL dependencies on BSC_TABS_B

Line 5285: h_sql := 'UPDATE bsc_tabs_b'||

5281: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5282: h_user_id := BSC_APPS.fnd_global_user_id;
5283:
5284: /*
5285: h_sql := 'UPDATE bsc_tabs_b'||
5286: ' SET last_updated_by = :1,'||
5287: ' last_update_date = SYSDATE'||
5288: ' WHERE tab_id IN ('||
5289: ' SELECT tab_id'||

Line 5299: UPDATE bsc_tabs_b

5295: h_bind_vars_values(2) := x_indicator;
5296: h_num_bind_vars := 2;
5297: Execute_Immediate(h_sql, h_bind_vars_values, h_num_bind_vars);
5298: */
5299: UPDATE bsc_tabs_b
5300: SET last_updated_by = h_user_id,
5301: last_update_date = SYSDATE
5302: WHERE tab_id IN (
5303: SELECT tab_id

Line 5339: h_sql := 'UPDATE bsc_tabs_b'||

5335: -- row and it will fail. AUDSID is not PK. After meeting with
5336: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5337: h_user_id := BSC_APPS.fnd_global_user_id;
5338:
5339: h_sql := 'UPDATE bsc_tabs_b'||
5340: ' SET last_updated_by = :1, last_update_date = SYSDATE'||
5341: ' WHERE tab_id IN ('||
5342: ' SELECT tab_id'||
5343: ' FROM bsc_tab_indicators'||