DBA Data[Home] [Help]

APPS.OE_ORDER_BOOK_UTIL dependencies on FND_GLOBAL

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

195: l_header_rec := l_old_header_rec;
196: l_header_rec.booked_flag := 'Y';
197: l_header_rec.booked_date := sysdate;
198: l_header_rec.flow_status_code := 'BOOKED';
199: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
200: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
201: l_header_rec.last_update_date := SYSDATE;
202: l_header_rec.lock_control := l_header_rec.lock_control + 1;
203:

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

196: l_header_rec.booked_flag := 'Y';
197: l_header_rec.booked_date := sysdate;
198: l_header_rec.flow_status_code := 'BOOKED';
199: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
200: l_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
201: l_header_rec.last_update_date := SYSDATE;
202: l_header_rec.lock_control := l_header_rec.lock_control + 1;
203:
204: -- bug 1406890

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

364: l_return_status := FND_API.G_RET_STS_SUCCESS;
365: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;
366: l_line_tbl(l_index).booked_flag := 'Y';
367: l_line_tbl(l_index).flow_status_code := 'BOOKED';
368: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;
369: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;
370: l_line_tbl(l_index).last_update_date := SYSDATE;
371: l_line_tbl(l_index).lock_control := l_line_tbl(l_index).lock_control + 1;
372:

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

365: l_line_tbl(l_index).operation := OE_GLOBALS.G_OPR_UPDATE;
366: l_line_tbl(l_index).booked_flag := 'Y';
367: l_line_tbl(l_index).flow_status_code := 'BOOKED';
368: l_line_tbl(l_index).last_updated_by := FND_GLOBAL.USER_ID;
369: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;
370: l_line_tbl(l_index).last_update_date := SYSDATE;
371: l_line_tbl(l_index).lock_control := l_line_tbl(l_index).lock_control + 1;
372:
373: OE_MSG_PUB.set_msg_context(

Line 457: , last_updated_by = FND_GLOBAL.USER_ID

453: UPDATE oe_order_headers_all
454: SET booked_flag = 'Y'
455: , booked_date = sysdate
456: , flow_status_code = 'BOOKED'
457: , last_updated_by = FND_GLOBAL.USER_ID
458: , last_update_login = FND_GLOBAL.LOGIN_ID
459: , last_update_date = SYSDATE
460: , lock_control = lock_control + 1
461: WHERE header_id = p_header_id;

Line 458: , last_update_login = FND_GLOBAL.LOGIN_ID

454: SET booked_flag = 'Y'
455: , booked_date = sysdate
456: , flow_status_code = 'BOOKED'
457: , last_updated_by = FND_GLOBAL.USER_ID
458: , last_update_login = FND_GLOBAL.LOGIN_ID
459: , last_update_date = SYSDATE
460: , lock_control = lock_control + 1
461: WHERE header_id = p_header_id;
462:

Line 475: , last_updated_by = FND_GLOBAL.USER_ID

471:
472: UPDATE oe_order_lines_all
473: SET booked_flag = 'Y'
474: , flow_status_code = 'BOOKED'
475: , last_updated_by = FND_GLOBAL.USER_ID
476: , last_update_login = FND_GLOBAL.LOGIN_ID
477: , last_update_date = SYSDATE
478: , lock_control = lock_control + 1
479: WHERE header_id = p_header_id

Line 476: , last_update_login = FND_GLOBAL.LOGIN_ID

472: UPDATE oe_order_lines_all
473: SET booked_flag = 'Y'
474: , flow_status_code = 'BOOKED'
475: , last_updated_by = FND_GLOBAL.USER_ID
476: , last_update_login = FND_GLOBAL.LOGIN_ID
477: , last_update_date = SYSDATE
478: , lock_control = lock_control + 1
479: WHERE header_id = p_header_id
480: AND nvl(cancelled_flag,'N') <> 'Y'; -- nvl added for bug 4486781