202: l_header_rec := l_old_header_rec;
203: l_header_rec.booked_flag := 'Y';
204: l_header_rec.booked_date := sysdate;
205: l_header_rec.flow_status_code := 'BOOKED';
206: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
207: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
208: l_header_rec.last_update_date := SYSDATE;
209: l_header_rec.lock_control := l_header_rec.lock_control + 1;
210:
203: l_header_rec.booked_flag := 'Y';
204: l_header_rec.booked_date := sysdate;
205: l_header_rec.flow_status_code := 'BOOKED';
206: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
207: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
208: l_header_rec.last_update_date := SYSDATE;
209: l_header_rec.lock_control := l_header_rec.lock_control + 1;
210:
211: -- bug 1406890
371: l_return_status := FND_API.G_RET_STS_SUCCESS;
372: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;
373: l_line_tbl(l_index).booked_flag := 'Y';
374: l_line_tbl(l_index).flow_status_code := 'BOOKED';
375: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;
376: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;
377: l_line_tbl(l_index).last_update_date := SYSDATE;
378: l_line_tbl(l_index).lock_control := l_line_tbl(l_index).lock_control + 1;
379:
372: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;
373: l_line_tbl(l_index).booked_flag := 'Y';
374: l_line_tbl(l_index).flow_status_code := 'BOOKED';
375: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;
376: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;
377: l_line_tbl(l_index).last_update_date := SYSDATE;
378: l_line_tbl(l_index).lock_control := l_line_tbl(l_index).lock_control + 1;
379:
380: OE_MSG_PUB.set_msg_context(
490: UPDATE oe_order_headers_all
491: SET booked_flag = 'Y'
492: , booked_date = sysdate
493: , flow_status_code = 'BOOKED'
494: , last_updated_by = FND_GLOBAL.USER_ID
495: , last_update_login = FND_GLOBAL.LOGIN_ID
496: , last_update_date = SYSDATE
497: , lock_control = lock_control + 1
498: WHERE header_id = p_header_id;
491: SET booked_flag = 'Y'
492: , booked_date = sysdate
493: , flow_status_code = 'BOOKED'
494: , last_updated_by = FND_GLOBAL.USER_ID
495: , last_update_login = FND_GLOBAL.LOGIN_ID
496: , last_update_date = SYSDATE
497: , lock_control = lock_control + 1
498: WHERE header_id = p_header_id;
499:
508:
509: UPDATE oe_order_lines_all
510: SET booked_flag = 'Y'
511: , flow_status_code = 'BOOKED'
512: , last_updated_by = FND_GLOBAL.USER_ID
513: , last_update_login = FND_GLOBAL.LOGIN_ID
514: , last_update_date = SYSDATE
515: , lock_control = lock_control + 1
516: WHERE header_id = p_header_id
509: UPDATE oe_order_lines_all
510: SET booked_flag = 'Y'
511: , flow_status_code = 'BOOKED'
512: , last_updated_by = FND_GLOBAL.USER_ID
513: , last_update_login = FND_GLOBAL.LOGIN_ID
514: , last_update_date = SYSDATE
515: , lock_control = lock_control + 1
516: WHERE header_id = p_header_id
517: AND nvl(cancelled_flag,'N') <> 'Y'; -- nvl added for bug 4486781