DBA Data[Home] [Help]

APPS.AHL_DI_DOC_REVISION_PVT dependencies on DUAL

Line 476: Select AHL_DOC_REVISIONS_B_S.Nextval Into l_doc_revision_id from dual;

472: l_revision_info.attribute13 := p_x_revision_tbl(i).attribute13;
473: l_revision_info.attribute14 := p_x_revision_tbl(i).attribute14;
474: l_revision_info.attribute15 := p_x_revision_tbl(i).attribute15;
475: -- Gets the value from sequence
476: Select AHL_DOC_REVISIONS_B_S.Nextval Into l_doc_revision_id from dual;
477: --Insert the record into doc revisions table
478: AHL_DOC_REVISIONS_PKG.INSERT_ROW(X_ROWID => l_row_id,
479: X_DOC_REVISION_ID => l_doc_revision_id,
480: X_APPROVED_DATE => l_revision_info.approved_date,