[Home] [Help]
64: wdj.organization_id,
65: wdj.status_type,
66: wdj.class_code,
67: wdj.date_released
68: from wip_discrete_jobs wdj, wip_job_schedule_interface wjsi
69: where wjsi.group_id = p_groupID
70: and process_status in (wip_constants.running, wip_constants.warning)
71: and wjsi.wip_entity_id = wdj.wip_entity_id
72: and wdj.status_type in (wip_constants.released, wip_constants.hold);
140: if(wjsi_rec.load_type in (WIP_CONSTANTS.RESCHED_JOB,
141: WIP_CONSTANTS.RESCHED_EAM_JOB)) then
142: select wdj.status_type
143: into l_wdj_old_status_type
144: from wip_discrete_jobs wdj
145: where wdj.organization_id=wjsi_rec.organization_id
146: and wdj.wip_entity_id=wjsi_rec.wip_entity_id;
147: end if;
148: /*8494582 End*/
218: wdj.organization_id
219: into l_wjsi_new_status_type, /*Removed old status type for bug 8494582*/
220: l_wdj_wip_entity_id,
221: l_wdj_organization_id
222: from wip_discrete_jobs wdj,
223: wip_job_schedule_interface wjsi
224: where wjsi.rowid = wjsi_rec.rowid
225: and wdj.wip_entity_id = wjsi.wip_entity_id
226: and wdj.organization_id = wjsi.organization_id
646: where rowid = p_rowid;
647:
648: if ( l_wjsiSerOp is null and l_loadType = wip_constants.resched_job ) then
649: -- due to re-exploding, we may need to clear out the serialization start op
650: update wip_discrete_jobs wdj
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
663: -- logic. the column value might be different between wjsi and wdj because we do update for wdj if
664: -- wjsi is null for job creation. Otherwise, the value should be the same.
665: select serialization_start_op
666: into l_wdjSerOp
667: from wip_discrete_jobs
668: where wip_entity_id = l_wipEntityID;
669:
670: --Bug#14511983: Updating the serialization_start_op in WDJ when the operations have been added
671: -- This case happens when operations are added and the serialization_start_op is assigned to the new added operation
680: end;
681: if ( l_wdjSerOp is null and l_dummy=0) then
682: return;
683: elsif (l_wdjSerOp is null and l_dummy=1 ) then
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
692:
693: --job must have an assembly, and the assembly must be serial controlled (predefined).
694: select 1
695: into l_dummy
696: from wip_discrete_jobs wdj,
697: mtl_system_items msi
698: where wdj.primary_item_id = msi.inventory_item_id
699: and wdj.organization_id = msi.organization_id
700: and wdj.wip_entity_id = l_wipEntityID
725: --job must be unreleased to change the serialization op on a reschedule request.
726: if ( l_loadType = wip_constants.resched_job and l_wjsiSerOp is not null ) then
727: select 1
728: into l_dummy
729: from wip_discrete_jobs
730: where wip_entity_id = l_wipEntityID
731: and status_type = wip_constants.unreleased;
732: end if;
733: