DBA Data[Home] [Help]

APPS.ZPB_DC_DISTRIBUTE dependencies on ZPB_USERS

Line 266: --Update the ZPB_USERS table with the conc req id

262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: raise FND_API.G_EXC_ERROR;
264: END IF;
265:
266: --Update the ZPB_USERS table with the conc req id
267: UPDATE zpb_users
268: SET conc_request_id = l_conc_request_id,
269: conc_request_start_time = SYSDATE,
270: -- WHO columns

Line 267: UPDATE zpb_users

263: raise FND_API.G_EXC_ERROR;
264: END IF;
265:
266: --Update the ZPB_USERS table with the conc req id
267: UPDATE zpb_users
268: SET conc_request_id = l_conc_request_id,
269: conc_request_start_time = SYSDATE,
270: -- WHO columns
271: last_update_date = SYSDATE,

Line 398: --Update ZPB_USERS and remove the request id

394:
395:
396:
397:
398: --Update ZPB_USERS and remove the request id
399: UPDATE zpb_users
400: SET conc_request_id = NULL,
401: conc_request_start_time = NULL,
402: -- WHO columns

Line 399: UPDATE zpb_users

395:
396:
397:
398: --Update ZPB_USERS and remove the request id
399: UPDATE zpb_users
400: SET conc_request_id = NULL,
401: conc_request_start_time = NULL,
402: -- WHO columns
403: last_update_date = SYSDATE,