APPS.ENG_NIR_UTIL_PKG dependencies on ENG_CHANGE_LINES_TL
Line 705: DELETE FROM eng_change_lines_tl WHERE change_line_id = l_change_line_id;
701: -- AND pk2_value = p_org_id
702: -- AND entity_name = 'EGO_ITEM';
703:
704: DELETE FROM eng_change_lines WHERE change_id = p_change_id and change_line_id = l_change_line_id; 705: DELETE FROM eng_change_lines_tl WHERE change_line_id = l_change_line_id; 706: ELSE
707: -- Query change line id
708: SELECT change_line_id INTO l_change_line_id FROM eng_change_subjects
709: WHERE change_id = p_change_id