[Home] [Help]
1422: --ad CLOSE dup_rec;
1423:
1424: ELSE
1425: --Retrieve the sequence number
1426: SELECT AHL_SUPPLIER_DOCUMENTS_S.Nextval INTO
1427: l_supplier_document_id from DUAL;
1428: --Insert the record into supplier documents table
1429: INSERT INTO AHL_SUPPLIER_DOCUMENTS
1430: (