APPS.WIP_CHANGE_STATUS dependencies on WIP_REPETITIVE_SCHEDULES

Line 139: FROM WIP_REPETITIVE_SCHEDULES

135: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,
136: P_organization_id))),
137: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,
138: P_organization_id)))
139: FROM WIP_REPETITIVE_SCHEDULES
140: WHERE WIP_ENTITY_ID = P_wip_entity_id
141: AND ORGANIZATION_ID = P_organization_id
142: AND LINE_ID = P_line_id
143: AND STATUS_TYPE IN (WIP_CONSTANTS.RELEASED,

Line 206: wip_repetitive_schedules wrs

202: CURSOR check_routing IS
203: SELECT 'identical routing'
204: FROM wip_operations wo1,
205: wip_operations wo2,
206: wip_repetitive_schedules wrs
207: WHERE wrs.organization_id = P_organization_id
208: AND wo1.organization_id = P_organization_id
209: AND wo2.organization_id = P_organization_id
210: AND wrs.wip_entity_id = P_wip_entity_id

Line 225: wip_repetitive_schedules S

221: AND wo1.backflush_flag = wo2.backflush_flag
222: HAVING count(*) =
223: (SELECT count(*)
224: FROM wip_operations O,
225: wip_repetitive_schedules S
226: WHERE O.organization_id = P_organization_id
227: AND S.organization_id = P_organization_id
228: AND O.wip_entity_id = P_wip_entity_id
229: AND S.wip_entity_id = P_wip_entity_id

Line 237: wip_repetitive_schedules S

233: AND O.repetitive_schedule_id = P_repetitive_schedule_id)
234: AND count(*) =
235: (SELECT count(*)
236: FROM wip_operations O,
237: wip_repetitive_schedules S
238: WHERE O.organization_id = P_organization_id
239: AND S.organization_id = P_organization_id
240: AND O.wip_entity_id = P_wip_entity_id
241: AND S.wip_entity_id = P_wip_entity_id

Line 400: UPDATE WIP_REPETITIVE_SCHEDULES

396: X_user_id NUMBER := FND_GLOBAL.USER_ID;
397: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
398:
399: BEGIN
400: UPDATE WIP_REPETITIVE_SCHEDULES
401: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
402: LAST_UPDATE_DATE = SYSDATE,
403: LAST_UPDATED_BY = X_user_id,
404: LAST_UPDATE_LOGIN = X_login_id