APPS.WIP_CHANGE_STATUS dependencies on WIP_DISCRETE_JOBS

Line 476: FROM WIP_DISCRETE_JOBS

472:
473: CURSOR disc_info IS
474: SELECT STATUS_TYPE,
475: CLASS_CODE
476: FROM WIP_DISCRETE_JOBS
477: WHERE WIP_ENTITY_ID = P_wip_entity_id
478: AND ORGANIZATION_ID = P_organization_id
479: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
480: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD,

Line 524: UPDATE WIP_DISCRETE_JOBS

520: FND_MESSAGE.SET_NAME('WIP','WIP_PENDING_JOB_ON');
521: raise fnd_api.g_exc_unexpected_error;
522: END IF;*/
523:
524: UPDATE WIP_DISCRETE_JOBS
525: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
526: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
527: LAST_UPDATE_DATE = SYSDATE,
528: LAST_UPDATED_BY = X_user_id,

Line 564: FROM WIP_DISCRETE_JOBS

560:
561: CURSOR disc_info IS
562: SELECT STATUS_TYPE,
563: CLASS_CODE
564: FROM WIP_DISCRETE_JOBS
565: WHERE WIP_ENTITY_ID = P_wip_entity_id
566: AND ORGANIZATION_ID = P_organization_id;
567:
568:

Line 596: UPDATE WIP_DISCRETE_JOBS

592: WIP_OSP.RELEASE_VALIDATION(P_wip_entity_id,
593: P_organization_id,
594: null);
595:
596: UPDATE WIP_DISCRETE_JOBS
597: SET STATUS_TYPE = WIP_CONSTANTS.RELEASED,
598: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
599: LAST_UPDATE_DATE = SYSDATE,
600: LAST_UPDATED_BY = X_user_id,