APPS.WIP_MASSLOAD_PUB dependencies on WIP_OPERATIONS

Line 628: from wip_operations

624: l_opFound boolean := false;
625:
626: cursor c_ops(v_wipEntityID number) is
627: select operation_seq_num
628: from wip_operations
629: where wip_entity_id = v_wipEntityID;
630:
631: begin
632: x_returnStatus := fnd_api.g_ret_sts_success;

Line 655: from wip_operations wo

651: set serialization_start_op = null
652: where wip_entity_id = l_wipEntityID
653: and serialization_start_op <> 1
654: and not exists(select 1
655: from wip_operations wo
656: where wo.wip_entity_id = wdj.wip_entity_id
657: and wo.operation_seq_num = wdj.serialization_start_op);
658: return;
659: end if;

Line 675: from wip_operations wo

671: -- This case happens when operations are added and the serialization_start_op is assigned to the new added operation
672: BEGIN
673: SELECT 1
674: into l_dummy
675: from wip_operations wo
676: WHERE wo.wip_entity_id = l_wipEntityID and wo.operation_seq_num = NVL(l_wjsiSerOp,-99) AND rownum=1;
677: exception
678: WHEN NO_DATA_FOUND THEN
679: l_dummy:=0;

Line 688: from wip_operations wo

684: update wip_discrete_jobs wdj
685: set serialization_start_op = l_wjsiSerOp
686: where wip_entity_id = l_wipEntityID
687: and exists(select 1
688: from wip_operations wo
689: where wo.wip_entity_id = wdj.wip_entity_id
690: and wo.operation_seq_num = l_wjsiSerOp) returning serialization_start_op into l_wdjSerOp;
691: end if;
692: