APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_DISCRETE_JOBS

Line 233: FROM wip_discrete_jobs wdj, wip_entities we

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

Line 337: update wip_discrete_jobs

333: X_Line_Id => -1,
334: X_Ent_Type=> 6 );
335:
336: --Fix for bug 8940736: Adding code to make DATE_RELEASED in WDJ to null when work order status is changed to unreleased
337: update wip_discrete_jobs
338: set date_released = null
339: where wip_entity_id = l_wip_entity_id
340: and organization_id=l_organization_id;
341:

Line 464: l_wo_sched_start_date from wip_discrete_jobs

460: l_to_status_type <> l_current_status THEN
461:
462:
463: select scheduled_start_date into
464: l_wo_sched_start_date from wip_discrete_jobs
465: where wip_entity_id = l_wip_entity_id
466: and organization_id = l_organization_id;
467: IF (l_wo_sched_start_date < sysdate) THEN
468: select nvl(min(period_start_date),l_wo_sched_start_date)

Line 579: WIP_DISCRETE_JOBS wdj,

575: sysdate,
576: fnd_global.user_id,
577: fnd_global.login_id
578: FROM
579: WIP_DISCRETE_JOBS wdj,
580: MTL_EAM_NETWORK_ASSETS mena,
581: CSI_ITEM_INSTANCES CII,
582: MTL_PARAMETERS mp
583: WHERE

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

919: END IF; -- End of Close Status
920:
921:
922: /******************************************************/
923: -- Update WIP_DISCRETE_JOBS with the changed job status
924: /******************************************************/
925:
926: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Updating WO with status'); END IF;
927:

Line 930: UPDATE WIP_DISCRETE_JOBS

926: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Updating WO with status'); END IF;
927:
928: BEGIN
929:
930: UPDATE WIP_DISCRETE_JOBS
931: SET STATUS_TYPE = l_final_status
932: WHERE ORGANIZATION_ID = l_organization_id
933: AND WIP_ENTITY_ID = l_wip_entity_id;
934:

Line 960: UPDATE wip_discrete_jobs

956: WHERE ORGANIZATION_ID = l_organization_id
957: AND WIP_ENTITY_ID = l_wip_entity_id;
958:
959: /*Code Added for bug#4760468 Start*/
960: UPDATE wip_discrete_jobs
961: SET date_closed = NULL
962: WHERE organization_id = l_organization_id
963: AND WIP_ENTITY_ID = l_wip_entity_id;
964: /*Code added for bug#4760468 End*/