APPS.AMW_CREATE_LINES_PKG dependencies on ENG_CHANGE_LINES

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;

Line 62: delete from eng_change_lines where change_id=p_change_id;

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;
66: FETCH C_ENTITY_NAME INTO L_ENTITY_NAME;

Line 1234: SELECT ENG_CHANGE_LINES_S.NEXTVAL

1230: l_change_line_id NUMBER;
1231: LX_ROW_ID VARCHAR2(255);
1232: BEGIN
1233: --get the changeLineId sequence value
1234: SELECT ENG_CHANGE_LINES_S.NEXTVAL
1235: INTO L_CHANGE_LINE_ID
1236: FROM DUAL;
1237:
1238: ENG_CHANGE_LINES_PKG.INSERT_ROW(

Line 1238: ENG_CHANGE_LINES_PKG.INSERT_ROW(

1234: SELECT ENG_CHANGE_LINES_S.NEXTVAL
1235: INTO L_CHANGE_LINE_ID
1236: FROM DUAL;
1237:
1238: ENG_CHANGE_LINES_PKG.INSERT_ROW(
1239: X_ROWID => LX_ROW_ID
1240: ,X_CHANGE_LINE_ID => L_CHANGE_LINE_ID
1241: ,X_REQUEST_ID => NULL
1242: ,X_CHANGE_ID => P_CHANGE_ID