APPS.WIP_CHANGE_STATUS dependencies on WIP_DISCRETE_JOBS

Line 341: FROM WIP_DISCRETE_JOBS

337:
338: CURSOR disc_info IS
339: SELECT STATUS_TYPE,
340: CLASS_CODE
341: FROM WIP_DISCRETE_JOBS
342: WHERE WIP_ENTITY_ID = P_wip_entity_id
343: AND ORGANIZATION_ID = P_organization_id
344: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
345: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,

Line 379: UPDATE WIP_DISCRETE_JOBS

375: wip_osp.release_validation ( P_wip_entity_id, P_organization_id, '') ;
376:
377: end if ;
378:
379: UPDATE WIP_DISCRETE_JOBS
380: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
381: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
382: LAST_UPDATE_DATE = SYSDATE,
383: LAST_UPDATED_BY = X_user_id,

Line 419: FROM WIP_DISCRETE_JOBS

415:
416: CURSOR disc_info IS
417: SELECT STATUS_TYPE,
418: CLASS_CODE
419: FROM WIP_DISCRETE_JOBS
420: WHERE WIP_ENTITY_ID = P_wip_entity_id
421: AND ORGANIZATION_ID = P_organization_id;
422:
423:

Line 447: UPDATE WIP_DISCRETE_JOBS

443: X_class_code, X_status_type, WIP_CONSTANTS.RELEASED,
444: X_routing_exists, SYSDATE);
445:
446:
447: UPDATE WIP_DISCRETE_JOBS
448: SET STATUS_TYPE = WIP_CONSTANTS.RELEASED,
449: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
450: LAST_UPDATE_DATE = SYSDATE,
451: LAST_UPDATED_BY = X_user_id,