APPS.ENG_ECO_PVT dependencies on ENG_LIFECYCLE_STATUSES

Line 13808: FROM eng_lifecycle_statuses

13804:
13805: /* Cursor to Fetch all the life cycle Statuses for corresponding Type. */
13806: CURSOR c_lifecycle_statuses IS
13807: SELECT *
13808: FROM eng_lifecycle_statuses
13809: WHERE entity_name = 'ENG_CHANGE_TYPE'
13810: AND entity_id1 = p_change_type_id;
13811:
13812: BEGIN

Line 13816: SELECT ENG_LIFECYCLE_STATUSES_S.NEXTVAL

13812: BEGIN
13813: FOR cls IN c_lifecycle_statuses
13814: LOOP
13815: -- fetch the CHANGE_LIFECYCLE_STATUS_ID from sequence
13816: SELECT ENG_LIFECYCLE_STATUSES_S.NEXTVAL
13817: INTO l_lifecycle_status_id
13818: FROM dual;
13819:
13820: -- Insert the Statuses data

Line 13821: INSERT INTO ENG_LIFECYCLE_STATUSES

13817: INTO l_lifecycle_status_id
13818: FROM dual;
13819:
13820: -- Insert the Statuses data
13821: INSERT INTO ENG_LIFECYCLE_STATUSES
13822: ( CHANGE_LIFECYCLE_STATUS_ID
13823: , ENTITY_NAME
13824: , ENTITY_ID1
13825: , ENTITY_ID2

Line 17169: FROM ENG_LIFECYCLE_STATUSES

17165: CREATION_DATE,
17166: CREATED_BY,
17167: LAST_UPDATE_DATE,
17168: LAST_UPDATED_BY
17169: FROM ENG_LIFECYCLE_STATUSES
17170: WHERE ENTITY_ID1 IN
17171: (SELECT CHANGE_ID
17172: FROM ENG_ENGINEERING_CHANGES
17173: WHERE CHANGE_NOTICE = p_change_notice

Line 17242: --Will need to update the various related tables along with the ENG_LIFECYCLE_STATUSES

17238: IF Bom_Globals.Get_Debug = 'Y' THEN
17239: Error_Handler.Write_Debug('New Route Id Created is ' || l_to_route_id);
17240: END IF;
17241:
17242: --Will need to update the various related tables along with the ENG_LIFECYCLE_STATUSES
17243: UPDATE ENG_LIFECYCLE_STATUSES
17244: SET CHANGE_WF_ROUTE_ID = l_to_route_id,
17245: WORKFLOW_STATUS = 'NOT_STARTED'
17246: WHERE ENTITY_ID1 = C_CHANGES_REC.ENTITY_ID1

Line 17243: UPDATE ENG_LIFECYCLE_STATUSES

17239: Error_Handler.Write_Debug('New Route Id Created is ' || l_to_route_id);
17240: END IF;
17241:
17242: --Will need to update the various related tables along with the ENG_LIFECYCLE_STATUSES
17243: UPDATE ENG_LIFECYCLE_STATUSES
17244: SET CHANGE_WF_ROUTE_ID = l_to_route_id,
17245: WORKFLOW_STATUS = 'NOT_STARTED'
17246: WHERE ENTITY_ID1 = C_CHANGES_REC.ENTITY_ID1
17247: AND CHANGE_LIFECYCLE_STATUS_ID =

Line 17252: FROM eng_lifecycle_statuses

17248: C_CHANGES_REC.CHANGE_LIFECYCLE_STATUS_ID;
17249:
17250: SELECT to_char(status_code)
17251: INTO l_classification_code
17252: FROM eng_lifecycle_statuses
17253: WHERE change_wf_route_id = l_to_route_id;
17254:
17255: UPDATE ENG_CHANGE_ROUTES
17256: SET OBJECT_ID1 = C_CHANGES_REC.ENTITY_ID1,