[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,
562:
563: select maintenance_object_source into l_maint_obj_src
564: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;*/
565:
566: update eam_wo_relationships set
567: top_level_object_id = l_top_level_object_id,
568: top_level_object_type_id = l_top_level_object_type_id
569: where
570: parent_object_id = l_relationship_record.parent_object_id
584:
585: elsif l_relationship_type = 4 then -- Follow up
586:
587:
588: select eam_wo_relationships_s.nextval
589: into l_wo_relationship_id from dual;
590: insert into eam_wo_relationships
591: ( wo_relationship_id,
592: parent_object_id,
1536:
1537: end if;
1538:
1539:
1540: select eam_wo_relationships_s.nextval
1541: into l_wo_relationship_id from dual;
1542: insert into eam_wo_relationships
1543: ( wo_relationship_id,
1544: parent_object_id,
1885:
1886: select maintenance_object_source into l_maint_obj_src
1887: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
1888: if l_maint_obj_src = 1 then -- EAM
1889: update eam_wo_relationships set
1890: top_level_object_id = l_child_object_id,
1891: top_level_object_type_id = l_child_object_type_id
1892: where
1893: parent_object_id = l_relationship_record.parent_object_id