DBA Data[Home] [Help]

APPS.OE_ORDER_BOOK_UTIL dependencies on FND_GLOBAL

Line 206: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 207: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 375: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;

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:

Line 376: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;

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(

Line 494: , last_updated_by = FND_GLOBAL.USER_ID

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;

Line 495: , last_update_login = FND_GLOBAL.LOGIN_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:

Line 512: , last_updated_by = FND_GLOBAL.USER_ID

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

Line 513: , last_update_login = FND_GLOBAL.LOGIN_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