DBA Data[Home] [Help]

APPS.EAM_SCHED_BOTTOM_UP_PVT dependencies on WIP_DISCRETE_JOBS

Line 439: UPDATE wip_discrete_jobs

435: IF ( NVL( l_wo_date_change , 'N' ) = 'Y' ) THEN
436:
437: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating WDJ') ; END IF ;
438:
439: UPDATE wip_discrete_jobs
440: SET scheduled_start_date = l_wo_start_date,
441: scheduled_completion_date = l_wo_end_date ,
442: last_update_date = sysdate ,
443: last_updated_by = FND_GLOBAL.user_id ,

Line 575: FROM wip_discrete_jobs

571:
572: CURSOR get_wo_dates_csr( p_wip_entity_id NUMBER ) IS
573: SELECT scheduled_start_date,
574: scheduled_completion_date
575: FROM wip_discrete_jobs
576: WHERE wip_entity_id = p_wip_entity_id;
577:
578: /* Define local variables */
579: l_return_status varchar2(1);

Line 791: UPDATE wip_discrete_jobs

787: EAM_ERROR_MESSAGE_PVT.Write_Debug(' wo end dates ' || l_scheduled_completion_date) ;
788: END IF ;
789:
790: IF l_min_date < l_scheduled_start_date THEN
791: UPDATE wip_discrete_jobs
792: SET scheduled_start_date = l_min_date,
793: last_update_date = sysdate ,
794: last_updated_by = FND_GLOBAL.user_id ,
795: last_update_login = FND_GLOBAL.login_id

Line 806: UPDATE wip_discrete_jobs

802: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
803: EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating WO completion date ') ;
804: END IF ;
805:
806: UPDATE wip_discrete_jobs
807: SET scheduled_completion_date = l_max_date,
808: last_update_date = sysdate ,
809: last_updated_by = FND_GLOBAL.user_id ,
810: last_update_login = FND_GLOBAL.login_id