318: x_msg_data => l_asset_ops_msg_data
319: );
320: END IF;
321:
322: -- Delete data from EAM_WORK_ORDER_ROUTE table
323:
324: DELETE FROM EAM_WORK_ORDER_ROUTE
325: WHERE wip_entity_id = p_wip_entity_id;
326:
320: END IF;
321:
322: -- Delete data from EAM_WORK_ORDER_ROUTE table
323:
324: DELETE FROM EAM_WORK_ORDER_ROUTE
325: WHERE wip_entity_id = p_wip_entity_id;
326:
327: IF (l_current_status in (17,3,6,7,9,11,15)) THEN
328:
550:
551: BEGIN
552: select count(*)
553: into l_route
554: from EAM_WORK_ORDER_ROUTE
555: where wip_entity_id = l_wip_entity_id;
556:
557: if l_route = 0 then
558: INSERT INTO EAM_WORK_ORDER_ROUTE
554: from EAM_WORK_ORDER_ROUTE
555: where wip_entity_id = l_wip_entity_id;
556:
557: if l_route = 0 then
558: INSERT INTO EAM_WORK_ORDER_ROUTE
559: (
560: wip_entity_id ,
561: route_asset_seq_id ,
562: instance_id ,
567: last_update_login
568: )
569: SELECT
570: wdj.wip_entity_id,
571: EAM_WORK_ORDER_ROUTE_S.nextval,
572: mena.maintenance_object_id,
573: sysdate,
574: fnd_global.login_id,
575: sysdate,