APPS.EAM_WO_PROCESSOR dependencies on WIP_CONSTANTS

Line 262: and process_status <> WIP_CONSTANTS.COMPLETED;

258: into l_err_cnt
259: from wip_job_schedule_interface
260: where wip_entity_id = l_jobs(l_index).wip_entity_id
261: and group_id = p_group_id
262: and process_status <> WIP_CONSTANTS.COMPLETED;
263:
264: if (l_err_cnt <> 0) then
265: error_status(l_jobs(l_index).wip_entity_id,p_org_id);
266: if G_DEBUG then

Line 293: and status_type = WIP_CONSTANTS.PEND_SCHED;

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:
295: if (l_cnt = 0) then
296: return false;
297: end if;

Line 300: if (p_status_type not in (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.HOLD) ) then

296: return false;
297: end if;
298:
299:
300: if (p_status_type not in (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.HOLD) ) then
301: return false;
302: end if;
303:
304: return true;

Line 318: set status_type = WIP_CONSTANTS.UNRELEASED

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:
322: if (p_status_type = WIP_CONSTANTS.RELEASED) then

Line 322: if (p_status_type = WIP_CONSTANTS.RELEASED) then

318: set status_type = WIP_CONSTANTS.UNRELEASED
319: where wip_entity_id = p_wip_entity_id
320: and organization_id = p_org_id;
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

Line 330: WIP_CONSTANTS.PEND_SCHED,WIP_CONSTANTS.RELEASED,

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,
330: WIP_CONSTANTS.PEND_SCHED,WIP_CONSTANTS.RELEASED,
331: l_routing_exists);
332: elsif (p_status_type = WIP_CONSTANTS.HOLD) then
333: wip_change_status.put_job_on_hold(p_wip_entity_id,p_org_id);
334: end if;

Line 332: elsif (p_status_type = WIP_CONSTANTS.HOLD) then

328:
329: wip_change_status.release(p_wip_entity_id,p_org_id,NULL,NULL,l_class_code,
330: WIP_CONSTANTS.PEND_SCHED,WIP_CONSTANTS.RELEASED,
331: l_routing_exists);
332: elsif (p_status_type = WIP_CONSTANTS.HOLD) then
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

Line 350: set status_type = WIP_CONSTANTS.DRAFT,

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;
354: -- commit;

Line 384: l_direction := WIP_CONSTANTS.WPS_FORWARD_SCHEDULE;

380: and organization_id = p_org_id;
381:
382: if (l_req_start_date is not null) then
383: l_horizon_start := l_req_start_date;
384: l_direction := WIP_CONSTANTS.WPS_FORWARD_SCHEDULE;
385: else
386: l_horizon_start := sysdate;
387: l_direction := WIP_CONSTANTS.WPS_BACKWARD_SCHEDULE;
388: end if;

Line 387: l_direction := WIP_CONSTANTS.WPS_BACKWARD_SCHEDULE;

383: l_horizon_start := l_req_start_date;
384: l_direction := WIP_CONSTANTS.WPS_FORWARD_SCHEDULE;
385: else
386: l_horizon_start := sysdate;
387: l_direction := WIP_CONSTANTS.WPS_BACKWARD_SCHEDULE;
388: end if;
389:
390: l_request_id := FND_REQUEST.SUBMIT_REQUEST('WPS',
391: 'WPCWFS',