DBA Data[Home] [Help]

APPS.DOM_ATTACHMENT_UTIL_PKG dependencies on FND_ATTACHED_DOCUMENTS_S

Line 80: select fnd_attached_documents_s.nextval

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,

Line 174: select fnd_attached_documents_s.nextval

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:

Line 335: UPDATE fnd_attached_documents set category_id = l_category_id where attached_document_id = l_Attached_document_id;

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;

Line 1353: SELECT fnd_attached_documents_s.NEXTVAL

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,