APPS.ENG_ECO_UTIL dependencies on ENG_CHANGE_LINES

Line 3012: FROM eng_change_lines_vl

3008: IS
3009: -- cursor to get the lines for a given eco: bug 5414834
3010: CURSOR lines_for_eco( p_change_id NUMBER) IS
3011: SELECT status_code ,sequence_number , name
3012: FROM eng_change_lines_vl
3013: WHERE eng_change_lines_vl.change_id = p_change_id
3014: and sequence_number<> -1;
3015:
3016:

Line 3013: WHERE eng_change_lines_vl.change_id = p_change_id

3009: -- cursor to get the lines for a given eco: bug 5414834
3010: CURSOR lines_for_eco( p_change_id NUMBER) IS
3011: SELECT status_code ,sequence_number , name
3012: FROM eng_change_lines_vl
3013: WHERE eng_change_lines_vl.change_id = p_change_id
3014: and sequence_number<> -1;
3015:
3016:
3017: BEGIN

Line 3064: UPDATE eng_change_lines SET status_code = p_Unexp_ECO_rec.status_type

3060: --change the status of all open lines bug:5414834
3061: if( p_Unexp_ECO_rec.status_type = 11 OR p_Unexp_ECO_rec.status_type = 5 ) then
3062: FOR line_rec IN lines_for_eco(p_Unexp_ECO_rec.Change_Id)
3063: LOOP
3064: UPDATE eng_change_lines SET status_code = p_Unexp_ECO_rec.status_type
3065: WHERE status_code=1 AND change_id = p_Unexp_ECO_rec.Change_Id;
3066: END LOOP;
3067: end if;
3068: Update_Row