[Home] [Help]
408: return;
409: end if;
410:
411: -- insert the type 3 relationship first
412: select eam_wo_relationships_s.nextval
413: into l_wo_relationship_id from dual;
414: insert into eam_wo_relationships
415: ( wo_relationship_id,
416: parent_object_id,
479:
480: end if;
481:
482:
483: select eam_wo_relationships_s.nextval
484: into l_wo_relationship_id from dual;
485: insert into eam_wo_relationships
486: ( wo_relationship_id,
487: parent_object_id,
540:
541: select maintenance_object_source into l_maint_obj_src
542: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
543: if l_maint_obj_src = 1 then -- EAM
544: update eam_wo_relationships set
545: top_level_object_id = l_top_level_object_id,
546: top_level_object_type_id = l_top_level_object_type_id
547: where
548: parent_object_id = l_relationship_record.parent_object_id
562:
563: elsif l_relationship_type = 4 then -- Follow up
564:
565:
566: select eam_wo_relationships_s.nextval
567: into l_wo_relationship_id from dual;
568: insert into eam_wo_relationships
569: ( wo_relationship_id,
570: parent_object_id,
1510:
1511: end if;
1512:
1513:
1514: select eam_wo_relationships_s.nextval
1515: into l_wo_relationship_id from dual;
1516: insert into eam_wo_relationships
1517: ( wo_relationship_id,
1518: parent_object_id,
1858:
1859: select maintenance_object_source into l_maint_obj_src
1860: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
1861: if l_maint_obj_src = 1 then -- EAM
1862: update eam_wo_relationships set
1863: top_level_object_id = l_child_object_id,
1864: top_level_object_type_id = l_child_object_type_id
1865: where
1866: parent_object_id = l_relationship_record.parent_object_id