APPS.ENG_VALIDATE_ECO dependencies on ENG_CHANGE_LINES

Line 511: FROM eng_change_lines

507: --Bug 2921474
508: l_cl_exists NUMBER := 0;
509: CURSOR GetChangeLines(p_change_id NUMBER) IS
510: SELECT 'x'
511: FROM eng_change_lines
512: WHERE change_id = p_change_id;
513:
514: l_er_exists NUMBER := 0;
515: CURSOR GetEcoRevisions IS

Line 1189: FROM eng_change_lines_vl

1185:
1186:
1187: CURSOR lines_for_eco( p_change_id NUMBER) IS
1188: SELECT status_code ,sequence_number , name
1189: FROM eng_change_lines_vl
1190: WHERE eng_change_lines_vl.change_id = p_change_id
1191: and sequence_number<> -1;
1192:
1193: CURSOR revised_items_for_eco( p_change_id NUMBER) IS

Line 1190: WHERE eng_change_lines_vl.change_id = p_change_id

1186:
1187: CURSOR lines_for_eco( p_change_id NUMBER) IS
1188: SELECT status_code ,sequence_number , name
1189: FROM eng_change_lines_vl
1190: WHERE eng_change_lines_vl.change_id = p_change_id
1191: and sequence_number<> -1;
1192:
1193: CURSOR revised_items_for_eco( p_change_id NUMBER) IS
1194: SELECT STATUS_TYPE ,scheduled_date

Line 1491: l_up_ch :=1; --we need not check in eng_change_lines as it being updated now

1487: if l_change_line_rec.sequence_number = lines_for_eco_rec.sequence_number
1488: and
1489: l_change_line_rec.name = lines_for_eco_rec.name
1490: then
1491: l_up_ch :=1; --we need not check in eng_change_lines as it being updated now
1492: end if;
1493: END LOOP;
1494: END IF; --p_change_line_tbl.Count <> 0
1495: if(

Line 1524: l_up_cr :=1; --we need not check in eng_change_lines as it being updated now

1520: FOR I IN 1..p_revised_item_tbl.Count LOOP
1521: l_revised_item_rec := p_revised_item_tbl(I);
1522: if l_revised_item_rec .Start_Effective_Date = revised_items_for_eco_rec.scheduled_date
1523: then
1524: l_up_cr :=1; --we need not check in eng_change_lines as it being updated now
1525: end if;
1526: END LOOP;
1527: END IF; --p_change_line_tbl.Count <> 0
1528: