DBA Data[Home] [Help]

APPS.WIP_CPLPROC_PRIV dependencies on WIP_DISCRETE_JOBS

Line 320: from wip_discrete_jobs

316: l_qtyAvailToComplete,
317: x_serialStartOp,
318: l_jobType,
319: l_cplDate
320: from wip_discrete_jobs
321: where wip_entity_id = p_cplRec.wipEntityID
322: for update of quantity_completed nowait;
323:
324: if(p_cplRec.txnActionID = wip_constants.cplassy_action) then

Line 398: update wip_discrete_jobs --increase the qty completed

394: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
395: raise fnd_api.g_exc_unexpected_error;
396: end if;
397:
398: update wip_discrete_jobs --increase the qty completed
399: set quantity_completed = l_qtyCompleted + p_cplRec.priQty, --remember txn qty is negative for returns
400: date_completed = l_cplDate,
401: status_type = nvl(l_jobStatus, status_type),
402: last_updated_by = fnd_global.user_id,