APPS.WIP_CHANGE_STATUS dependencies on WIP_REPETITIVE_SCHEDULES

Line 171: FROM WIP_REPETITIVE_SCHEDULES

167: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,
168: P_organization_id))),
169: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,
170: P_organization_id)))
171: FROM WIP_REPETITIVE_SCHEDULES
172: WHERE WIP_ENTITY_ID = P_wip_entity_id
173: AND ORGANIZATION_ID = P_organization_id
174: AND LINE_ID = P_line_id
175: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,

Line 259: wip_repetitive_schedules wrs

255: CURSOR check_routing IS
256: SELECT 'identical routing'
257: FROM wip_operations wo1,
258: wip_operations wo2,
259: wip_repetitive_schedules wrs
260: WHERE wrs.organization_id = P_organization_id
261: AND wo1.organization_id = P_organization_id
262: AND wo2.organization_id = P_organization_id
263: AND wrs.wip_entity_id = P_wip_entity_id

Line 278: wip_repetitive_schedules S

274: AND wo1.backflush_flag = wo2.backflush_flag
275: HAVING count(*) =
276: (SELECT count(*)
277: FROM wip_operations O,
278: wip_repetitive_schedules S
279: WHERE O.organization_id = P_organization_id
280: AND S.organization_id = P_organization_id
281: AND O.wip_entity_id = P_wip_entity_id
282: AND S.wip_entity_id = P_wip_entity_id

Line 290: wip_repetitive_schedules S

286: AND O.repetitive_schedule_id = P_repetitive_schedule_id)
287: AND count(*) =
288: (SELECT count(*)
289: FROM wip_operations O,
290: wip_repetitive_schedules S
291: WHERE O.organization_id = P_organization_id
292: AND S.organization_id = P_organization_id
293: AND O.wip_entity_id = P_wip_entity_id
294: AND S.wip_entity_id = P_wip_entity_id

Line 545: UPDATE WIP_REPETITIVE_SCHEDULES

541: X_user_id NUMBER := FND_GLOBAL.USER_ID;
542: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
543:
544: BEGIN
545: UPDATE WIP_REPETITIVE_SCHEDULES
546: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
547: LAST_UPDATE_DATE = SYSDATE,
548: LAST_UPDATED_BY = X_user_id,
549: LAST_UPDATE_LOGIN = X_login_id