76: -- SBAG: When Attach action is called, the attached_document_id
77: -- will be null. So the id is created out of the sequence number
78: -- to pass to fnd_attached_documents_pkg.insert_row api.
79:
80: select fnd_attached_documents_s.nextval
81: into l_attached_document_id from dual;
82:
83: fnd_attached_documents_pkg.Insert_Row(
84: X_Rowid => l_row_id,
170: -- SBAG: When Attach action is called, the attached_document_id
171: -- will be null. So the id is created out of the sequence number
172: -- to pass to fnd_attached_documents_pkg.insert_row api.
173:
174: select fnd_attached_documents_s.nextval
175: into l_attached_document_id from dual;
176:
177: if ( l_document_id is null ) THEN
178:
331: X_doc_attribute15 => null,
332: X_create_doc => 'N' -- Fix for 3762710
333: );
334:
335: UPDATE fnd_attached_documents set category_id = l_category_id where attached_document_id = l_Attached_document_id;
336:
337: x_Attached_document_id:=l_Attached_document_id;
338:
339: END Create_Attachment;
1349: END IF; -- end of duplicating text
1350:
1351: END IF; -- end if usage_type = 'O' and datatype in (1,2,6)
1352: -- Create attachment record
1353: SELECT fnd_attached_documents_s.NEXTVAL
1354: INTO l_to_attachment_id
1355: FROM dual;
1356: INSERT INTO fnd_attached_documents
1357: (attached_document_id,