DBA Data[Home] [Help]

APPS.CSP_PLANNED_ORDERS dependencies on DUAL

Line 113: SELECT fnd_global.user_id INTO l_user_id from dual;

109: BEGIN
110: SAVEPOINT Create_Orders_PUB;
111: -- initialize return status
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113: SELECT fnd_global.user_id INTO l_user_id from dual;
114:
115: l_line_tbl := px_line_tbl;
116: -- get ship to of warehouse
117: begin

Line 306: FROM dual;

302:
303: /* IF (l_item_attr_rec.mbf = 1) THEN
304: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
305: INTO l_wip_id
306: FROM dual;
307:
308: IF (l_item_attr_rec.build_in_wip <> 'Y' OR
309: l_item_attr_rec.pick_components <> 'N') THEN
310: FND_MESSAGE.SET_NAME('CSP', 'CSP_WIP_ORDER_ERROR');