APPS.DOM_ATTACHMENT_UTIL_PKG dependencies on DUAL

Line 81: into l_attached_document_id from dual;

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,
85: X_attached_document_id => l_Attached_document_id,

Line 175: into l_attached_document_id from dual;

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:
179: SELECT fnd_documents_s.nextval

Line 181: FROM dual;

177: if ( l_document_id is null ) THEN
178:
179: SELECT fnd_documents_s.nextval
180: INTO l_document_id
181: FROM dual;
182:
183: l_category_id := p_category_id;
184: l_media_id := p_family_id;
185:

Line 221: SELECT userenv('LANG') INTO l_language FROM dual;

217: p_file_name,
218: p_repository_id,
219: 'FILE');
220:
221: SELECT userenv('LANG') INTO l_language FROM dual;
222:
223: fnd_documents_pkg.insert_tl_row(
224: X_document_id => l_document_id,
225: X_creation_date => sysdate,

Line 274: select fnd_documents_s.CURRVAL into l_document_id from dual;

270: WHERE x.document_id = l_document_id;
271:
272: select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;
273:
274: select fnd_documents_s.CURRVAL into l_document_id from dual;
275:
276: fnd_documents_pkg.insert_tl_row(
277: X_document_id => l_document_id,
278: X_creation_date => sysdate,

Line 1355: FROM dual;

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,
1358: document_id,
1359: creation_date,