APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_LINES

Line 3439: FROM eng_change_lines_vl

3435: IS
3436: -- cursor to get the lines for a given eco: bug 5414834
3437: CURSOR lines_for_eco( p_change_id NUMBER) IS
3438: SELECT status_code ,sequence_number , name
3439: FROM eng_change_lines_vl
3440: WHERE eng_change_lines_vl.change_id = p_change_id
3441: and sequence_number<> -1;
3442:
3443:

Line 3440: WHERE eng_change_lines_vl.change_id = p_change_id

3436: -- cursor to get the lines for a given eco: bug 5414834
3437: CURSOR lines_for_eco( p_change_id NUMBER) IS
3438: SELECT status_code ,sequence_number , name
3439: FROM eng_change_lines_vl
3440: WHERE eng_change_lines_vl.change_id = p_change_id
3441: and sequence_number<> -1;
3442:
3443:
3444: BEGIN

Line 3491: UPDATE eng_change_lines SET status_code = p_Unexp_ECO_rec.status_type

3487: --change the status of all open lines bug:5414834
3488: if( p_Unexp_ECO_rec.status_type = 11 OR p_Unexp_ECO_rec.status_type = 5 ) then
3489: FOR line_rec IN lines_for_eco(p_Unexp_ECO_rec.Change_Id)
3490: LOOP
3491: UPDATE eng_change_lines SET status_code = p_Unexp_ECO_rec.status_type
3492: WHERE status_code=1 AND change_id = p_Unexp_ECO_rec.Change_Id;
3493: END LOOP;
3494: end if;
3495: Update_Row