APPS.WIP_MASSLOAD_PUB dependencies on WIP_DISCRETE_JOBS

Line 169: from wip_discrete_jobs wdj,

165: into l_wdj_old_status_type,
166: l_wjsi_new_status_type,
167: l_wdj_wip_entity_id,
168: l_wdj_organization_id
169: from wip_discrete_jobs wdj,
170: wip_job_schedule_interface wjsi
171: where wjsi.rowid = wjsi_rec.rowid
172: and wdj.wip_entity_id = wjsi.wip_entity_id
173: and wdj.organization_id = wjsi.organization_id

Line 483: update wip_discrete_jobs wdj

479: where rowid = p_rowid;
480:
481: if ( l_wjsiSerOp is null and l_loadType = wip_constants.resched_job ) then
482: -- due to re-exploding, we may need to clear out the serialization start op
483: update wip_discrete_jobs wdj
484: set serialization_start_op = null
485: where wip_entity_id = l_wipEntityID
486: and serialization_start_op <> 1
487: and not exists(select 1

Line 500: from wip_discrete_jobs

496: -- logic. the column value might be different between wjsi and wdj because we do update for wdj if
497: -- wjsi is null for job creation. Otherwise, the value should be the same.
498: select serialization_start_op
499: into l_wdjSerOp
500: from wip_discrete_jobs
501: where wip_entity_id = l_wipEntityID;
502:
503: if ( l_wdjSerOp is null ) then
504: return;

Line 510: from wip_discrete_jobs wdj,

506:
507: --job must have an assembly, and the assembly must be serial controlled (predefined).
508: select 1
509: into l_dummy
510: from wip_discrete_jobs wdj,
511: mtl_system_items msi
512: where wdj.primary_item_id = msi.inventory_item_id
513: and wdj.organization_id = msi.organization_id
514: and wdj.wip_entity_id = l_wipEntityID

Line 543: from wip_discrete_jobs

539: --job must be unreleased to change the serialization op on a reschedule request.
540: if ( l_loadType = wip_constants.resched_job and l_wjsiSerOp is not null ) then
541: select 1
542: into l_dummy
543: from wip_discrete_jobs
544: where wip_entity_id = l_wipEntityID
545: and status_type = wip_constants.unreleased;
546: end if;
547: