1064: UPDATE OKL_STREAMS
1065: SET say_code = 'HIST',
1066: active_yn = 'N',
1067: date_history = sysdate,
1068: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1069: last_update_date = sysdate,
1070: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1071: WHERE ID = l_id_tbl(i);
1072:
1066: active_yn = 'N',
1067: date_history = sysdate,
1068: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1069: last_update_date = sysdate,
1070: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1071: WHERE ID = l_id_tbl(i);
1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1108: UPDATE OKL_STREAMS
1109: SET say_code = 'HIST',
1110: active_yn = 'N',
1111: date_history = sysdate,
1112: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1113: last_update_date = sysdate,
1114: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1115: WHERE ID = l_rep_id_tbl(i);
1116:
1110: active_yn = 'N',
1111: date_history = sysdate,
1112: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1113: last_update_date = sysdate,
1114: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1115: WHERE ID = l_rep_id_tbl(i);
1116:
1117: EXCEPTION
1118: WHEN OTHERS THEN
1152: UPDATE OKL_STREAMS
1153: SET say_code = 'CURR',
1154: active_yn = 'Y',
1155: date_current = sysdate,
1156: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1157: last_update_date = sysdate,
1158: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1159: WHERE ID = l_id_tbl(i);
1160:
1154: active_yn = 'Y',
1155: date_current = sysdate,
1156: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1157: last_update_date = sysdate,
1158: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1159: WHERE ID = l_id_tbl(i);
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1198: UPDATE OKL_STREAMS
1199: SET say_code = 'CURR',
1200: active_yn = 'N',
1201: date_current = sysdate,
1202: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1203: last_update_date = sysdate,
1204: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1205: WHERE ID = l_rep_id_tbl(i);
1206:
1200: active_yn = 'N',
1201: date_current = sysdate,
1202: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
1203: last_update_date = sysdate,
1204: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
1205: WHERE ID = l_rep_id_tbl(i);
1206:
1207: EXCEPTION
1208: WHEN OTHERS THEN