1: PACKAGE BODY fnd_attached_documents_pkg as
2: /* $Header: AFAKAADB.pls 120.7 2012/03/06 14:40:33 ctilley ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
82: tmp_rowid VARCHAR2(30);
83:
84:
85: CURSOR C IS SELECT rowid
86: FROM fnd_attached_documents
87: WHERE attached_document_id = X_attached_document_id;
88:
89: l_usage_type varchar2(1);
90: l_create_doc varchar2(1);
158: X_orig_doc_id => X_orig_doc_id);
159:
160: END IF; -- done creating document
161:
162: INSERT INTO fnd_attached_documents (
163: attached_document_id,
164: document_id,
165: creation_date,
166: created_by,
305: X_url VARCHAR2 DEFAULT NULL,
306: X_title VARCHAR2 DEFAULT NULL) IS
307: CURSOR C IS
308: SELECT *
309: FROM fnd_attached_documents
310: WHERE rowid = X_Rowid
311: FOR UPDATE of attached_document_id NOWAIT;
312: Recinfo C%ROWTYPE;
313: BEGIN
513: ) IS
514: BEGIN
515:
516: -- Update the attached_documents table
517: UPDATE fnd_attached_documents
518: SET attached_document_id = X_attached_document_id,
519: document_id = X_document_id,
520: last_update_date = X_last_update_date,
521: last_updated_by = X_last_updated_by,
596: X_dm_version_number => X_dm_version_number);
597:
598: END update_row;
599:
600: END fnd_attached_documents_pkg;