1293: WHERE tab_id = p_tab_id;
1294:
1295: IF (l_row_cnt = 1) THEN
1296:
1297: l_user_id := fnd_global.USER_ID;
1298: l_login_id := fnd_global.LOGIN_ID;
1299:
1300: UPDATE bsc_tabs_b
1301: SET last_updated_by = l_user_id,
1294:
1295: IF (l_row_cnt = 1) THEN
1296:
1297: l_user_id := fnd_global.USER_ID;
1298: l_login_id := fnd_global.LOGIN_ID;
1299:
1300: UPDATE bsc_tabs_b
1301: SET last_updated_by = l_user_id,
1302: last_update_date = SYSDATE,