APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on EAM_WO_RELATIONSHIPS

Line 169: /*UPDATE EAM_WO_RELATIONSHIPS EWR

165: AND WSR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id
166: AND WSR.CHILD_OBJECT_ID = l_work_object_id
167: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id;
168:
169: /*UPDATE EAM_WO_RELATIONSHIPS EWR
170: SET EWR.RELATIONSHIP_STATUS = 1
171: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
172: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;*/
173:

Line 174: UPDATE EAM_WO_RELATIONSHIPS EWR

170: SET EWR.RELATIONSHIP_STATUS = 1
171: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
172: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;*/
173:
174: UPDATE EAM_WO_RELATIONSHIPS EWR
175: SET EWR.RELATIONSHIP_STATUS = 1
176: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
177: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id
178: AND EWR.CHILD_OBJECT_ID = l_work_object_id

Line 208: UPDATE EAM_WO_RELATIONSHIPS EWR

204: AND WSR1.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
205: AND WSR1.RELATIONSHIP_TYPE = 2
206: );
207:
208: UPDATE EAM_WO_RELATIONSHIPS EWR
209: SET EWR.RELATIONSHIP_STATUS = 3
210: WHERE EWR.WO_RELATIONSHIP_ID IN
211: (
212: SELECT EWR1.WO_RELATIONSHIP_ID

Line 213: FROM EAM_WO_RELATIONSHIPS EWR1,

209: SET EWR.RELATIONSHIP_STATUS = 3
210: WHERE EWR.WO_RELATIONSHIP_ID IN
211: (
212: SELECT EWR1.WO_RELATIONSHIP_ID
213: FROM EAM_WO_RELATIONSHIPS EWR1,
214: WIP_DISCRETE_JOBS WDJ1,
215: WIP_DISCRETE_JOBS WDJ2
216: WHERE EWR1.PARENT_OBJECT_TYPE_ID = 1
217: AND EWR1.CHILD_OBJECT_TYPE_ID = 1

Line 565: /*UPDATE EAM_WO_RELATIONSHIPS EWR

561: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
562: AND WSR.RELATIONSHIP_STATUS <> 3;
563:
564:
565: /*UPDATE EAM_WO_RELATIONSHIPS EWR
566: SET EWR.RELATIONSHIP_STATUS = 2
567: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
568: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id
569: AND EWR.RELATIONSHIP_STATUS <> 3;*/

Line 571: UPDATE EAM_WO_RELATIONSHIPS EWR

567: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
568: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id
569: AND EWR.RELATIONSHIP_STATUS <> 3;*/
570:
571: UPDATE EAM_WO_RELATIONSHIPS EWR
572: SET EWR.RELATIONSHIP_STATUS = 2
573: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
574: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id
575: AND EWR.CHILD_OBJECT_ID = l_work_object_id

Line 605: UPDATE EAM_WO_RELATIONSHIPS EWR

601: SET WSR.RELATIONSHIP_STATUS = 0
602: WHERE WSR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
603: AND WSR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
604:
605: UPDATE EAM_WO_RELATIONSHIPS EWR
606: SET EWR.RELATIONSHIP_STATUS = 0
607: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
608: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
609:

Line 624: UPDATE EAM_WO_RELATIONSHIPS EWR

620: SET WSR.RELATIONSHIP_STATUS = 0
621: WHERE WSR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
622: AND WSR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
623:
624: UPDATE EAM_WO_RELATIONSHIPS EWR
625: SET EWR.RELATIONSHIP_STATUS = 0
626: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
627: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
628:

Line 650: UPDATE EAM_WO_RELATIONSHIPS EWR

646: SET WSR.RELATIONSHIP_STATUS = 0
647: WHERE WSR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
648: AND WSR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
649:
650: UPDATE EAM_WO_RELATIONSHIPS EWR
651: SET EWR.RELATIONSHIP_STATUS = 0
652: WHERE EWR.TOP_LEVEL_OBJECT_TYPE_ID = l_top_level_object_type_id
653: AND EWR.TOP_LEVEL_OBJECT_ID = l_top_level_object_id;
654:

Line 767: UPDATE EAM_WO_RELATIONSHIPS EWR

763: OR
764: (WDJ2.STATUS_TYPE IN (12,14,15) AND WDJ2.DATE_COMPLETED IS NULL)));
765:
766:
767: UPDATE EAM_WO_RELATIONSHIPS EWR
768: SET EWR.RELATIONSHIP_STATUS = 3
769: WHERE EWR.CHILD_OBJECT_TYPE_ID = child.child_object_type_id
770: AND EWR.CHILD_OBJECT_ID = child.child_object_id
771: AND EWR.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id