DBA Data[Home] [Help]

APPS.DOM_ATTACHMENT_UTIL_PKG dependencies on FND_DOCUMENTS_PKG

Line 223: fnd_documents_pkg.insert_tl_row(

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,
226: X_created_by => p_created_by,
227: X_last_update_date => sysdate,

Line 276: fnd_documents_pkg.insert_tl_row(

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,
279: X_created_by => p_created_by,
280: X_last_update_date => sysdate,

Line 379: fnd_documents_pkg.Delete_Row(

375: open check_other_attachments (l_document_id);
376: fetch check_other_attachments INTO l_dummy;
377: CLOSE check_other_attachments;
378: if( l_dummy is null) THEN
379: fnd_documents_pkg.Delete_Row(
380: X_document_id =>l_document_id,
381: X_datatype_id =>l_datatype_id,
382: delete_ref_Flag => 'Y');
383: END if;

Line 745: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,

741: --
742: IF (docrec.usage_type = 'O'
743: AND docrec.datatype_id IN (1,2,5,6,7,8,9) ) THEN
744: -- Create Documents records
745: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
746: document_id_tmp,
747: SYSDATE,
748: NVL(X_created_by,0),
749: SYSDATE,

Line 1222: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,

1218: --
1219: IF (docrec.usage_type = 'O'
1220: AND docrec.datatype_id IN (1,2,5,6,7,8,9) ) THEN
1221: -- Create Documents records
1222: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
1223: document_id_tmp,
1224: SYSDATE,
1225: NVL(X_created_by,0),
1226: SYSDATE,