APPS.ENG_ECO_REVISION_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 23: FROM eng_engineering_changes

19: BEGIN
20:
21: SELECT approval_status_type, change_order_type_id ,route_id, priority_code
22: INTO l_id, x_change_order_type_id ,x_route_id ,x_priority_code
23: FROM eng_engineering_changes
24: WHERE change_id = p_change_id ;
25:
26: RETURN l_id;
27:

Line 247: l_chk_co_app eng_engineering_changes.approval_status_type%TYPE;

243: l_login_id NUMBER;
244: l_prog_appid NUMBER;
245: l_prog_id NUMBER;
246: l_request_id NUMBER;
247: l_chk_co_app eng_engineering_changes.approval_status_type%TYPE;
248: l_change_order_type_id NUMBER;
249: l_route_id NUMBER;
250: l_process NUMBER ;
251: l_priority_code eng_engineering_changes.priority_code%TYPE; -- Bug 3665542

Line 251: l_priority_code eng_engineering_changes.priority_code%TYPE; -- Bug 3665542

247: l_chk_co_app eng_engineering_changes.approval_status_type%TYPE;
248: l_change_order_type_id NUMBER;
249: l_route_id NUMBER;
250: l_process NUMBER ;
251: l_priority_code eng_engineering_changes.priority_code%TYPE; -- Bug 3665542
252:
253: BEGIN
254:
255: l_user_id := Eng_Globals.Get_User_Id;

Line 337: UPDATE eng_engineering_changes

333: );
334:
335:
336: /* Bug no:3047312
337: UPDATE eng_engineering_changes
338: SET approval_status_type = 1
339: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id;
340: end of Bug no:3047312 */
341: /* Bug no:3047312*/

Line 353: UPDATE eng_engineering_changes

349: (l_chk_co_app = 5 AND l_process = 1)
350: then
351: -- Set ECO to 'Not Submitted For Approval'
352:
353: UPDATE eng_engineering_changes
354: SET approval_status_type = 1,
355: approval_request_date = null,
356: approval_date = null,
357: last_update_date = SYSDATE,