DBA Data[Home] [Help]

APPS.AMW_CREATE_LINES_PKG dependencies on DUAL

Line 1236: FROM DUAL;

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(
1239: X_ROWID => LX_ROW_ID
1240: ,X_CHANGE_LINE_ID => L_CHANGE_LINE_ID

Line 1292: FROM DUAL;

1288: BEGIN
1289: --Insert into Eng_Change_Subjects
1290: SELECT ENG_CHANGE_SUBJECTS_S.NEXTVAL
1291: INTO L_CHANGE_SUBJECT_ID
1292: FROM DUAL;
1293:
1294: INSERT INTO ENG_CHANGE_SUBJECTS (
1295: CHANGE_SUBJECT_ID
1296: ,CHANGE_ID