3009: phase_types(4) := 6; --'Implemented'
3010:
3011: FOR lp IN phase_types.FIRST..phase_types.LAST
3012: LOOP
3013: SELECT eng_lifecycle_statuses_s.nextval
3014: INTO l_lifecycle_phase_id
3015: FROM dual;
3016:
3017: l_seq_no := l_seq_no + 10;
3015: FROM dual;
3016:
3017: l_seq_no := l_seq_no + 10;
3018:
3019: insert into ENG_LIFECYCLE_STATUSES (
3020: CHANGE_LIFECYCLE_STATUS_ID
3021: , ENTITY_NAME
3022: , ENTITY_ID1
3023: , ENTITY_ID2
4740: -- Real code starts here -----------------------------------------------
4741: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
4742: WHERE ROUTE_PEOPLE_ID in
4743: ( select ecrp.ROUTE_PEOPLE_ID
4744: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4745: where ecrp.STEP_ID = ecrs.step_id
4746: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4747: and els.ENTITY_ID1 = p_change_id
4748: and els.ENTITY_NAME = 'ENG_CHANGE'
4754: ( select STEP_ID
4755: from ENG_CHANGE_ROUTE_STEPS
4756: where ROUTE_ID in
4757: ( select CHANGE_WF_ROUTE_ID
4758: from ENG_LIFECYCLE_STATUSES
4759: where ENTITY_ID1 = p_change_id
4760: and ENTITY_NAME = 'ENG_CHANGE'
4761: )
4762: )
4764:
4765: delete from ENG_CHANGE_ROUTE_PEOPLE_tl
4766: where ROUTE_PEOPLE_ID in
4767: ( select ecrp.ROUTE_PEOPLE_ID
4768: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4769: where ecrp.STEP_ID = ecrs.step_id
4770: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4771: and els.ENTITY_ID1 = p_change_id
4772: and els.ENTITY_NAME = 'ENG_CHANGE'
4778: ( select STEP_ID
4779: from ENG_CHANGE_ROUTE_STEPS
4780: where ROUTE_ID in
4781: ( select CHANGE_WF_ROUTE_ID
4782: from ENG_LIFECYCLE_STATUSES
4783: where ENTITY_ID1 = p_change_id
4784: and ENTITY_NAME = 'ENG_CHANGE'
4785: )
4786: )
4793: ( select STEP_ID
4794: from ENG_CHANGE_ROUTE_STEPS
4795: where ROUTE_ID in
4796: ( select CHANGE_WF_ROUTE_ID
4797: from ENG_LIFECYCLE_STATUSES
4798: where ENTITY_ID1 = p_change_id
4799: and ENTITY_NAME = 'ENG_CHANGE'
4800: )
4801: );
4806: ( select STEP_ID
4807: from ENG_CHANGE_ROUTE_STEPS
4808: where ROUTE_ID in
4809: ( select CHANGE_WF_ROUTE_ID
4810: from ENG_LIFECYCLE_STATUSES
4811: where ENTITY_ID1 = p_change_id
4812: and ENTITY_NAME = 'ENG_CHANGE'
4813: )
4814: );
4815:
4816: delete from ENG_CHANGE_ROUTE_STEPS
4817: where ROUTE_ID in
4818: ( select CHANGE_WF_ROUTE_ID
4819: from ENG_LIFECYCLE_STATUSES
4820: where ENTITY_ID1 = p_change_id
4821: and ENTITY_NAME = 'ENG_CHANGE'
4822: );
4823:
4825:
4826: delete from ENG_CHANGE_ROUTES_tl
4827: where ROUTE_ID in
4828: ( select CHANGE_WF_ROUTE_ID
4829: from ENG_LIFECYCLE_STATUSES
4830: where ENTITY_ID1 = p_change_id
4831: and ENTITY_NAME = 'ENG_CHANGE'
4832: );
4833:
4834:
4835: delete from ENG_CHANGE_ROUTES
4836: where ROUTE_ID in
4837: ( select CHANGE_WF_ROUTE_ID
4838: from ENG_LIFECYCLE_STATUSES
4839: where ENTITY_ID1 = p_change_id
4840: and ENTITY_NAME = 'ENG_CHANGE' );
4841:
4842:
4839: where ENTITY_ID1 = p_change_id
4840: and ENTITY_NAME = 'ENG_CHANGE' );
4841:
4842:
4843: delete from ENG_LIFECYCLE_STATUSES
4844: where ENTITY_ID1 = p_change_id
4845: and ENTITY_NAME = 'ENG_CHANGE' ;
4846:
4847: delete from ENG_LIFECYCLE_STATUSES
4843: delete from ENG_LIFECYCLE_STATUSES
4844: where ENTITY_ID1 = p_change_id
4845: and ENTITY_NAME = 'ENG_CHANGE' ;
4846:
4847: delete from ENG_LIFECYCLE_STATUSES
4848: where ENTITY_ID1 = p_change_id
4849: and ENTITY_NAME = 'ENG_CHANGE' ;
4850:
4851: