APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_ROUTES

Line 1300: FROM eng_change_routes route,

1296: )
1297: IS
1298: SELECT DISTINCT route.route_id wf_route_id
1299: , line.change_line_id
1300: FROM eng_change_routes route,
1301: eng_change_statuses s,
1302: eng_change_lines line,
1303: eng_lifecycle_statuses line_start_after,
1304: eng_lifecycle_statuses new_status,

Line 2006: FROM eng_change_routes route,

2002: l.complete_before_status_code,
2003: l.required_flag,
2004: l.change_type_id ,
2005: route.status_code wf_status_code
2006: FROM eng_change_routes route,
2007: eng_change_statuses s,
2008: eng_change_lines l
2009: WHERE s.status_code = l.status_code
2010: AND route.route_id(+) = l.route_id

Line 2017: l_wf_status_code eng_change_routes.status_code%TYPE;

2013: l_line_status_type eng_change_statuses.status_type%TYPE;
2014: l_status_code eng_change_lines.complete_before_status_code%TYPE;
2015: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
2016: l_change_type_id NUMBER ;
2017: l_wf_status_code eng_change_routes.status_code%TYPE;
2018:
2019: -- Select all revised items
2020: CURSOR c_revItems IS
2021: SELECT status_code

Line 2173: from eng_change_routes

2169: For lifecyc in c_lifecyc
2170: loop
2171: select template_flag, object_id1
2172: into l_temp_flag, l_obj_id1
2173: from eng_change_routes
2174: where route_id = lifecyc.change_wf_route_id;
2175:
2176: if ((l_temp_flag = 'N' or l_temp_flag = 'H') and l_obj_id1 = 0) then
2177: FND_MESSAGE.Set_Name('ENG','ENG_ROUTE_APPLY_NO_TEMP');

Line 3278: from eng_change_routes

3274: For lifecyc in c_lifecyc
3275: loop
3276: select template_flag, object_id1
3277: into l_temp_flag, l_obj_id1
3278: from eng_change_routes
3279: where route_id = lifecyc.change_wf_route_id;
3280:
3281: if ((l_temp_flag = 'N' or l_temp_flag = 'H') and l_obj_id1 = 0) then
3282: FND_MESSAGE.Set_Name('ENG','ENG_ROUTE_APPLY_NO_TEMP');