64:
65: px_object_version_number := nvl(px_object_version_number, 1);
66:
67:
68: INSERT INTO ams_imp_documents(
69: imp_document_id,
70: last_updated_by,
71: object_version_number,
72: --last_update_by,
150: )
151:
152: IS
153: BEGIN
154: Update ams_imp_documents
155: SET
156: imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
157: --imp_document_id = DECODE( p_imp_document_id, null, imp_document_id, FND_API.G_MISS_NUM, null, p_imp_document_id),
158: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
211: p_imp_document_id NUMBER,
212: p_object_version_number NUMBER)
213: IS
214: BEGIN
215: DELETE FROM ams_imp_documents
216: WHERE imp_document_id = p_imp_document_id
217: AND object_version_number = p_object_version_number;
218: If (SQL%NOTFOUND) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: p_imp_document_id NUMBER)
241: IS
242: CURSOR C IS
243: SELECT *
244: FROM ams_imp_documents
245: WHERE imp_document_id = p_imp_document_id
246: FOR UPDATE OF imp_document_id NOWAIT;
247: Recinfo C%ROWTYPE;
248: BEGIN