APPS.EAM_SCHED_BOTTOM_UP_PVT dependencies on WIP_OPERATIONS

Line 339: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating Wip_operations ') ; END IF ;

335: END IF;
336:
337: IF ( NVL( l_change_date, 'N' ) = 'Y' ) THEN
338:
339: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating Wip_operations ') ; END IF ;
340:
341: UPDATE wip_operations
342: SET first_unit_start_date = l_op_start_date,
343: first_unit_completion_date = l_op_end_date,

Line 341: UPDATE wip_operations

337: IF ( NVL( l_change_date, 'N' ) = 'Y' ) THEN
338:
339: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating Wip_operations ') ; END IF ;
340:
341: UPDATE wip_operations
342: SET first_unit_start_date = l_op_start_date,
343: first_unit_completion_date = l_op_end_date,
344: last_unit_start_date = l_op_start_date,
345: last_unit_completion_date = l_op_end_date ,

Line 569: FROM wip_operations

565:
566: CURSOR get_op_dates_csr( p_wip_entity_id NUMBER) IS
567: SELECT operation_seq_num, first_unit_start_date,
568: last_unit_completion_date
569: FROM wip_operations
570: WHERE wip_entity_id = p_wip_entity_id;
571:
572: CURSOR get_wo_dates_csr( p_wip_entity_id NUMBER ) IS
573: SELECT scheduled_start_date,

Line 745: UPDATE wip_operations

741: where wip_entity_id = p_wip_entity_id
742: and operation_seq_num = c_operation_rec.operation_seq_num;
743:
744: IF l_min_res_date <> c_operation_rec.first_unit_start_date THEN /*Bug 7336817*/
745: UPDATE wip_operations
746: SET first_unit_start_date = l_min_res_date,
747: last_unit_start_date = l_min_res_date,
748: last_update_date = sysdate ,
749: last_updated_by = FND_GLOBAL.user_id ,

Line 757: UPDATE wip_operations

753:
754: END IF;
755:
756: IF l_max_res_date <> c_operation_rec.last_unit_completion_date THEN /*Bug 7336817*/
757: UPDATE wip_operations
758: SET first_unit_completion_date = l_max_res_date ,
759: last_unit_completion_date = l_max_res_date ,
760: last_update_date = sysdate ,
761: last_updated_by = FND_GLOBAL.user_id ,

Line 781: from wip_operations

777: END IF ;
778:
779: select min(first_unit_start_date), max(last_unit_completion_date)
780: into l_min_date, l_max_date
781: from wip_operations
782: where wip_entity_id = p_wip_entity_id;
783:
784: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
785: EAM_ERROR_MESSAGE_PVT.Write_Debug(' op start dates ' || l_min_date) ;