APPS.EAM_WO_PROCESSOR dependencies on WIP_DISCRETE_JOBS

Line 290: from wip_discrete_jobs

286: begin
287:
288: select count(*)
289: into l_cnt
290: from wip_discrete_jobs
291: where wip_entity_id = p_wip_entity_id
292: and organization_id = p_org_id
293: and status_type = WIP_CONSTANTS.PEND_SCHED;
294:

Line 317: update wip_discrete_jobs

313: l_routing_exists number;
314: begin
315:
316: -- Change the status to the UNRELEASED
317: update wip_discrete_jobs
318: set status_type = WIP_CONSTANTS.UNRELEASED
319: where wip_entity_id = p_wip_entity_id
320: and organization_id = p_org_id;
321:

Line 325: from wip_discrete_jobs

321:
322: if (p_status_type = WIP_CONSTANTS.RELEASED) then
323: select class_code
324: into l_class_code
325: from wip_discrete_jobs
326: where wip_entity_id = p_wip_entity_id
327: and organization_id = p_org_id;
328:
329: wip_change_status.release(p_wip_entity_id,p_org_id,NULL,NULL,l_class_code,

Line 337: update wip_discrete_jobs

333: wip_change_status.put_job_on_hold(p_wip_entity_id,p_org_id);
334: end if;
335:
336: -- Change the status to the new intended status
337: update wip_discrete_jobs
338: set status_type = p_status_type
339: where wip_entity_id = p_wip_entity_id
340: and organization_id = p_org_id;
341:

Line 349: update wip_discrete_jobs

345: -- Procedure to set the Work Order status to 'Not ready'
346: procedure error_status(p_wip_entity_id in number,
347: p_org_id in number) is
348: begin
349: update wip_discrete_jobs
350: set status_type = WIP_CONSTANTS.DRAFT,
351: date_released = NULL
352: where wip_entity_id = p_wip_entity_id
353: and organization_id = p_org_id;

Line 378: from wip_discrete_jobs

374: X_Horizon_Length => l_horizon_length);
375:
376: select requested_start_date,due_date
377: into l_req_start_date,l_req_due_date
378: from wip_discrete_jobs
379: where wip_entity_id = p_wip_entity_id
380: and organization_id = p_org_id;
381:
382: if (l_req_start_date is not null) then