eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on EAM_WO_RELATIONSHIPS

Line 192: from eam_wo_relationships where

188: -- I am commenting this out because as per latest design
189: -- on 08/26/2003, we can have 2 relationships for the same
190: -- set of work orders. For eg. type 1 and 3
191: /*select count(*) into l_count
192: from eam_wo_relationships where
193: child_object_id = l_child_object_id
194: and child_object_type_id = l_child_object_type_id
195: and parent_object_id = l_parent_object_id
196: and parent_object_type_id = l_parent_object_type_id;

Line 289: from eam_wo_relationships where

285: -- Check that the Child does not already have an existing relation
286: -- of the same type that is being created currently.
287: if l_parent_maint_obj_src = 1 then -- EAM
288: select count(*) into l_count
289: from eam_wo_relationships where
290: child_object_id = l_child_object_id
291: and child_object_type_id = l_child_object_type_id
292: and parent_relationship_type = l_relationship_type;
293: elsif l_parent_maint_obj_src = 2 then -- CMRO

Line 412: select eam_wo_relationships_s.nextval

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,

Line 414: insert into eam_wo_relationships

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,
417: parent_object_type_id,
418: child_object_id,

Line 483: select eam_wo_relationships_s.nextval

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,

Line 485: insert into eam_wo_relationships

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,
488: parent_object_type_id,
489: child_object_id,

Line 544: update eam_wo_relationships set

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

Line 566: select eam_wo_relationships_s.nextval

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,

Line 568: insert into eam_wo_relationships

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,
571: parent_object_type_id,
572: child_object_id,

Line 1158: DELETE from EAM_WO_RELATIONSHIPS

1154: return;
1155:
1156: end if;
1157:
1158: DELETE from EAM_WO_RELATIONSHIPS
1159: where parent_object_id = l_prior_object_id
1160: and parent_object_type_id = l_prior_object_type_id
1161: and child_object_id = l_next_object_id
1162: and child_object_type_id = l_next_object_type_id

Line 1514: select eam_wo_relationships_s.nextval

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,

Line 1516: insert into eam_wo_relationships

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,
1519: parent_object_type_id,
1520: child_object_id,

Line 1718: delete from eam_wo_relationships where

1714: end if;
1715:
1716: if l_count = 0 then
1717:
1718: delete from eam_wo_relationships where
1719: child_object_id = l_child_object_id
1720: and child_object_type_id = l_child_object_type_id
1721: and parent_object_id = l_parent_object_id
1722: and parent_object_type_id = l_parent_object_type_id

Line 1862: update eam_wo_relationships set

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