DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on ENG_CHANGE_ROUTES

Line 17225: SELECT ENG_CHANGE_ROUTES_S.NEXTVAL into l_to_route_id FROM DUAL;

17221:
17222: FOR C_CHANGES_REC IN C_CHANGES LOOP
17223:
17224: -- Get new ROute Id
17225: SELECT ENG_CHANGE_ROUTES_S.NEXTVAL into l_to_route_id FROM DUAL;
17226:
17227: IF Bom_Globals.Get_Debug = 'Y' THEN
17228: Error_Handler.Write_Debug('Inside Loop Template_id: ' ||
17229: C_CHANGES_REC.CHANGE_WF_ROUTE_TEMPLATE_ID);

Line 17255: UPDATE ENG_CHANGE_ROUTES

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,
17257: CLASSIFICATION_CODE = l_classification_code,
17258: OWNER_ID = FND_GLOBAL.USER_ID,
17259: APPLIED_TEMPLATE_ID = C_CHANGES_REC.CHANGE_WF_ROUTE_TEMPLATE_ID