DBA Data[Home] [Help]

APPS.WIP_CPLPROC_PRIV dependencies on WIP_DISCRETE_JOBS

Line 342: from wip_discrete_jobs

338: l_qtyAvailToComplete,
339: x_serialStartOp,
340: l_jobType,
341: l_cplDate
342: from wip_discrete_jobs
343: where wip_entity_id = p_cplRec.wipEntityID
344: for update of quantity_completed nowait;
345:
346: if(p_cplRec.txnActionID = wip_constants.cplassy_action) then

Line 421: update wip_discrete_jobs --increase the qty completed

417: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
418: raise fnd_api.g_exc_unexpected_error;
419: end if;
420:
421: update wip_discrete_jobs --increase the qty completed
422: set quantity_completed = l_qtyCompleted + p_cplRec.priQty, --remember txn qty is negative for returns
423: date_completed = l_cplDate,
424: status_type = nvl(l_jobStatus, status_type),
425: last_updated_by = fnd_global.user_id,