APPS.ENG_ECO_UTIL dependencies on ENG_LIFECYCLE_STATUSES

Line 2586: SELECT eng_lifecycle_statuses_s.nextval

2582: phase_types(4) := 6; --'Implemented'
2583:
2584: FOR lp IN phase_types.FIRST..phase_types.LAST
2585: LOOP
2586: SELECT eng_lifecycle_statuses_s.nextval
2587: INTO l_lifecycle_phase_id
2588: FROM dual;
2589:
2590: l_seq_no := l_seq_no + 10;

Line 2592: insert into ENG_LIFECYCLE_STATUSES (

2588: FROM dual;
2589:
2590: l_seq_no := l_seq_no + 10;
2591:
2592: insert into ENG_LIFECYCLE_STATUSES (
2593: CHANGE_LIFECYCLE_STATUS_ID
2594: , ENTITY_NAME
2595: , ENTITY_ID1
2596: , ENTITY_ID2

Line 4315: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els

4311: -- Real code starts here -----------------------------------------------
4312: DELETE FROM ENG_CHANGE_ROUTE_ASSOCS
4313: WHERE ROUTE_PEOPLE_ID in
4314: ( select ecrp.ROUTE_PEOPLE_ID
4315: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4316: where ecrp.STEP_ID = ecrs.step_id
4317: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4318: and els.ENTITY_ID1 = p_change_id
4319: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4329: from ENG_LIFECYCLE_STATUSES

4325: ( select STEP_ID
4326: from ENG_CHANGE_ROUTE_STEPS
4327: where ROUTE_ID in
4328: ( select CHANGE_WF_ROUTE_ID
4329: from ENG_LIFECYCLE_STATUSES
4330: where ENTITY_ID1 = p_change_id
4331: and ENTITY_NAME = 'ENG_CHANGE'
4332: )
4333: )

Line 4339: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els

4335:
4336: delete from ENG_CHANGE_ROUTE_PEOPLE_tl
4337: where ROUTE_PEOPLE_ID in
4338: ( select ecrp.ROUTE_PEOPLE_ID
4339: from ENG_CHANGE_ROUTE_PEOPLE ecrp , ENG_CHANGE_ROUTE_STEPS ecrs , ENG_LIFECYCLE_STATUSES els
4340: where ecrp.STEP_ID = ecrs.step_id
4341: AND ecrs.ROUTE_ID = els.CHANGE_WF_ROUTE_ID
4342: and els.ENTITY_ID1 = p_change_id
4343: and els.ENTITY_NAME = 'ENG_CHANGE'

Line 4353: from ENG_LIFECYCLE_STATUSES

4349: ( select STEP_ID
4350: from ENG_CHANGE_ROUTE_STEPS
4351: where ROUTE_ID in
4352: ( select CHANGE_WF_ROUTE_ID
4353: from ENG_LIFECYCLE_STATUSES
4354: where ENTITY_ID1 = p_change_id
4355: and ENTITY_NAME = 'ENG_CHANGE'
4356: )
4357: )

Line 4368: from ENG_LIFECYCLE_STATUSES

4364: ( select STEP_ID
4365: from ENG_CHANGE_ROUTE_STEPS
4366: where ROUTE_ID in
4367: ( select CHANGE_WF_ROUTE_ID
4368: from ENG_LIFECYCLE_STATUSES
4369: where ENTITY_ID1 = p_change_id
4370: and ENTITY_NAME = 'ENG_CHANGE'
4371: )
4372: );

Line 4381: from ENG_LIFECYCLE_STATUSES

4377: ( select STEP_ID
4378: from ENG_CHANGE_ROUTE_STEPS
4379: where ROUTE_ID in
4380: ( select CHANGE_WF_ROUTE_ID
4381: from ENG_LIFECYCLE_STATUSES
4382: where ENTITY_ID1 = p_change_id
4383: and ENTITY_NAME = 'ENG_CHANGE'
4384: )
4385: );

Line 4390: from ENG_LIFECYCLE_STATUSES

4386:
4387: delete from ENG_CHANGE_ROUTE_STEPS
4388: where ROUTE_ID in
4389: ( select CHANGE_WF_ROUTE_ID
4390: from ENG_LIFECYCLE_STATUSES
4391: where ENTITY_ID1 = p_change_id
4392: and ENTITY_NAME = 'ENG_CHANGE'
4393: );
4394:

Line 4400: from ENG_LIFECYCLE_STATUSES

4396:
4397: delete from ENG_CHANGE_ROUTES_tl
4398: where ROUTE_ID in
4399: ( select CHANGE_WF_ROUTE_ID
4400: from ENG_LIFECYCLE_STATUSES
4401: where ENTITY_ID1 = p_change_id
4402: and ENTITY_NAME = 'ENG_CHANGE'
4403: );
4404:

Line 4409: from ENG_LIFECYCLE_STATUSES

4405:
4406: delete from ENG_CHANGE_ROUTES
4407: where ROUTE_ID in
4408: ( select CHANGE_WF_ROUTE_ID
4409: from ENG_LIFECYCLE_STATUSES
4410: where ENTITY_ID1 = p_change_id
4411: and ENTITY_NAME = 'ENG_CHANGE' );
4412:
4413:

Line 4414: delete from ENG_LIFECYCLE_STATUSES

4410: where ENTITY_ID1 = p_change_id
4411: and ENTITY_NAME = 'ENG_CHANGE' );
4412:
4413:
4414: delete from ENG_LIFECYCLE_STATUSES
4415: where ENTITY_ID1 = p_change_id
4416: and ENTITY_NAME = 'ENG_CHANGE' ;
4417:
4418: delete from ENG_LIFECYCLE_STATUSES

Line 4418: delete from ENG_LIFECYCLE_STATUSES

4414: delete from ENG_LIFECYCLE_STATUSES
4415: where ENTITY_ID1 = p_change_id
4416: and ENTITY_NAME = 'ENG_CHANGE' ;
4417:
4418: delete from ENG_LIFECYCLE_STATUSES
4419: where ENTITY_ID1 = p_change_id
4420: and ENTITY_NAME = 'ENG_CHANGE' ;
4421:
4422: