[Home] [Help]
22: x_activity_assoc_id number;
23: begin
24:
25: select activity_association_id into x_activity_assoc_id
26: from mtl_eam_asset_activities meaa, wip_discrete_jobs wdj
27: where meaa.asset_activity_id = wdj.primary_item_id
28: and meaa.maintenance_object_id = wdj.maintenance_object_id
29: and meaa.maintenance_object_type = wdj.maintenance_object_type
30: and wdj.wip_entity_id = p_wip_entity_id;
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416: --bug 3762560: if x_assoc_id is null, then don't process anything, just return
417: IF x_assoc_id is not null then
418: select last_service_end_date into l_last_service_end_date
419: from mtl_eam_asset_activities
420: where activity_association_id=x_assoc_id;
421:
422: if (l_last_service_end_date <= p_wo_end_date and p_meter_reading <> FND_API.G_MISS_NUM ) then --bug# 14549822, prevents corruption of last_service_reading
423: update_last_service_reading(p_wip_entity_id, x_assoc_id, p_meter_id, p_meter_reading);
748: from wip_discrete_jobs wdj
749: where wdj.wip_entity_id=p_wip_entity_id;
750:
751: -- backup last date to previous date
752: update mtl_eam_asset_activities
753: set prev_service_start_date=last_service_start_date,
754: prev_service_end_date=last_service_end_date,
755: prev_scheduled_start_date=last_scheduled_start_date,
756: prev_scheduled_end_date=last_scheduled_end_date,
765: 1,last_service_start_date,2,last_service_end_date,5,last_service_start_date,6,last_service_start_date) <
766: decode(l_schedule_option,3,l_sch_start_date,4,l_sch_end_date,1,p_start_date,2,p_end_date,5,p_start_date,6,p_start_date)));
767:
768: -- copy wdj.scheduled_start/completion_date to meaa.last_scheduled_start/end_date
769: update mtl_eam_asset_activities meaa
770: set (meaa.last_scheduled_start_date,
771: meaa.last_scheduled_end_date,
772: meaa.last_service_start_date, --added for bug #4096193
773: meaa.last_service_end_date,--added for bug #4096193