APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_DISCRETE_JOBS

Line 231: FROM wip_discrete_jobs wdj, wip_entities we

227: l_date_closed,
228: l_maintenance_obj_src,
229: l_po_creation_time,
230: l_maint_obj_id
231: FROM wip_discrete_jobs wdj, wip_entities we
232: where wdj.wip_entity_id = l_wip_entity_id
233: and we.wip_entity_id = wdj.wip_entity_id
234: and we.organization_id = wdj.organization_id;
235:

Line 423: l_wo_sched_start_date from wip_discrete_jobs

419: l_to_status_type <> l_current_status THEN
420:
421:
422: select scheduled_start_date into
423: l_wo_sched_start_date from wip_discrete_jobs
424: where wip_entity_id = l_wip_entity_id
425: and organization_id = l_organization_id;
426: IF (l_wo_sched_start_date < sysdate) THEN
427: select nvl(min(period_start_date),l_wo_sched_start_date)

Line 537: WIP_DISCRETE_JOBS wdj,

533: sysdate,
534: fnd_global.user_id,
535: fnd_global.login_id
536: FROM
537: WIP_DISCRETE_JOBS wdj,
538: MTL_EAM_NETWORK_ASSETS mena,
539: CSI_ITEM_INSTANCES CII,
540: MTL_PARAMETERS mp
541: WHERE

Line 876: -- Update WIP_DISCRETE_JOBS with the changed job status

872: END IF; -- End of Close Status
873:
874:
875: /******************************************************/
876: -- Update WIP_DISCRETE_JOBS with the changed job status
877: /******************************************************/
878:
879: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating WO with status'); END IF;
880:

Line 883: UPDATE WIP_DISCRETE_JOBS

879: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating WO with status'); END IF;
880:
881: BEGIN
882:
883: UPDATE WIP_DISCRETE_JOBS
884: SET STATUS_TYPE = l_final_status
885: WHERE ORGANIZATION_ID = l_organization_id
886: AND WIP_ENTITY_ID = l_wip_entity_id;
887:

Line 913: UPDATE wip_discrete_jobs

909: WHERE ORGANIZATION_ID = l_organization_id
910: AND WIP_ENTITY_ID = l_wip_entity_id;
911:
912: /*Code Added for bug#4760468 Start*/
913: UPDATE wip_discrete_jobs
914: SET date_closed = NULL
915: WHERE organization_id = l_organization_id
916: AND WIP_ENTITY_ID = l_wip_entity_id;
917: /*Code added for bug#4760468 End*/