[Home] [Help]
12: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
13:
14: BEGIN
15: IF (P_repetitive_schedule_id IS NULL) THEN
16: UPDATE WIP_OPERATIONS
17: SET QUANTITY_IN_QUEUE =
18: SCHEDULED_QUANTITY -
19: (QUANTITY_IN_QUEUE + QUANTITY_RUNNING + QUANTITY_COMPLETED),
20: LAST_UPDATED_BY = X_user_id,
24: AND ORGANIZATION_ID = P_organization_id
25: AND REPETITIVE_SCHEDULE_ID IS NULL
26: AND PREVIOUS_OPERATION_SEQ_NUM IS NULL;
27: ELSE
28: UPDATE WIP_OPERATIONS
29: SET QUANTITY_IN_QUEUE =
30: SCHEDULED_QUANTITY -
31: (QUANTITY_IN_QUEUE + QUANTITY_RUNNING + QUANTITY_COMPLETED),
32: LAST_UPDATED_BY = X_user_id,
253: X_diff_routing BOOLEAN := FALSE;
254:
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
254:
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
273: AND wo1.count_point_type = wo2.count_point_type
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
285: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
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
401: /* For Bug 5859224: load_queue API would be called only if the sum of quantity_in_queue,quantity_running
402: and quantity_completed of first operation is zero */
403: BEGIN
404: SELECT (nvl(QUANTITY_IN_QUEUE,0) + nvl(QUANTITY_RUNNING,0) + nvl(QUANTITY_COMPLETED,0))
405: INTO x_tot_op_qty FROM WIP_OPERATIONS
406: WHERE WIP_ENTITY_ID = P_wip_entity_id
407: AND ORGANIZATION_ID = P_organization_id
408: AND nvl(REPETITIVE_SCHEDULE_ID, 0) = nvl(p_repetitive_schedule_id, 0) --Bug 8670946
409: AND ROWNUM = 1 --Bug 6052835: EAM Work orders can have multiple start (independant) operations
413: /*For Bug 7511261:
414: Previously, when QUANTITY_IN_QUEUE, QUANTITY_RUNNING, QUANTITY_COMPLETED is not 0, the P_routing_exists
415: flag was not being set properly and is equal to NULL and resulted into the issue in bug 7304606.
416: If the sql SELECT (nvl(QUANTITY_IN_QUEUE,0) + nvl(QUANTITY_RUNNING,0) + nvl(QUANTITY_COMPLETED,0))
417: INTO x_tot_op_qty FROM WIP_OPERATIONS does not throw exception it implies that there is a routing exists
418: in WIP_OPERATIONS and so the P_routing_exists flag should be 1(WIP_CONSTANTS.YES). If it throws exception,
419: LOAD_QUEUE will handle the P_routing_exists flag
420: */
421: P_routing_exists := WIP_CONSTANTS.YES;
414: Previously, when QUANTITY_IN_QUEUE, QUANTITY_RUNNING, QUANTITY_COMPLETED is not 0, the P_routing_exists
415: flag was not being set properly and is equal to NULL and resulted into the issue in bug 7304606.
416: If the sql SELECT (nvl(QUANTITY_IN_QUEUE,0) + nvl(QUANTITY_RUNNING,0) + nvl(QUANTITY_COMPLETED,0))
417: INTO x_tot_op_qty FROM WIP_OPERATIONS does not throw exception it implies that there is a routing exists
418: in WIP_OPERATIONS and so the P_routing_exists flag should be 1(WIP_CONSTANTS.YES). If it throws exception,
419: LOAD_QUEUE will handle the P_routing_exists flag
420: */
421: P_routing_exists := WIP_CONSTANTS.YES;
422: