APPS.AMW_CREATE_LINES_PKG dependencies on ENG_CHANGE_LINES_TL

Line 11: /* Insert into ENG_CHANGE_LINES_B and ENG_CHANGE_LINES_TL */

7: /* Reads the amw_risk-ctrl_interface table */
8: /* following tables: */
9: /* INSERTS OR UPDATES ARE DONE AGAINIST THE FOLLOWING TABLES */
10: /* Insert into ENG_CHANGE_SUBJECTS */
11: /* Insert into ENG_CHANGE_LINES_B and ENG_CHANGE_LINES_TL */
12: /* */
13: /*****************************************************************************/
14: --
15: -- Used for exception processing

Line 61: delete from eng_change_lines_tl where change_line_id in (select change_line_id from eng_change_lines where change_id=p_change_id);

57: END IF;
58:
59: ---02.16.2005 npanandi: need to delete existing lines for this changeRequest
60: ---and re-create rows with new process / risk / control associations
61: delete from eng_change_lines_tl where change_line_id in (select change_line_id from eng_change_lines where change_id=p_change_id);
62: delete from eng_change_lines where change_id=p_change_id;
63: delete from eng_change_subjects where change_line_id is not null and change_id=p_change_id;
64:
65: OPEN C_ENTITY_NAME;