[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;
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: --bug 3762560: if x_assoc_id is null, then don't process anything, just return
416: IF x_assoc_id is not null then
417: select last_service_end_date into l_last_service_end_date
418: from mtl_eam_asset_activities
419: where activity_association_id=x_assoc_id;
420:
421: if (l_last_service_end_date <= p_wo_end_date) then
422: update_last_service_reading(p_wip_entity_id, x_assoc_id, p_meter_id, p_meter_reading);
745: from wip_discrete_jobs wdj
746: where wdj.wip_entity_id=p_wip_entity_id;
747:
748: -- backup last date to previous date
749: update mtl_eam_asset_activities
750: set prev_service_start_date=last_service_start_date,
751: prev_service_end_date=last_service_end_date,
752: prev_scheduled_start_date=last_scheduled_start_date,
753: prev_scheduled_end_date=last_scheduled_end_date,
762: 1,last_service_start_date,2,last_service_end_date,5,last_service_start_date,6,last_service_start_date) <
763: 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)));
764:
765: -- copy wdj.scheduled_start/completion_date to meaa.last_scheduled_start/end_date
766: update mtl_eam_asset_activities meaa
767: set (meaa.last_scheduled_start_date,
768: meaa.last_scheduled_end_date,
769: meaa.last_service_start_date, --added for bug #4096193
770: meaa.last_service_end_date,--added for bug #4096193