DBA Data[Home] [Help]

APPS.EDR_FILES_PUB dependencies on FND_DOCUMENTS

Line 338: -- fnd_documents

334: --Call private package to insert data into the tables
335: --the whole idea is that instead of inserting one row in edr_files_b/tl tables
336: -- we would have to insert a row in:
337: -- edr_files_b/tl
338: -- fnd_documents
339: --fnd_lobs
340: --fnd_attached_documents (attach the file to a default enity named EDR_FILES_B
341:
342: EDR_FILES_PKG.Insert_Row (

Line 381: --to insert in fnd_documents and fnd_attached_dcouments

377: --now that the row is inserted in edr_files table
378: -- we have insert into fn_documents, fnd_attached_documents
379: -- and fnd_lobs
380:
381: --to insert in fnd_documents and fnd_attached_dcouments
382: --use FND_ATTACHED_DOCUMENTS_PKG.Insert_Row
383:
384: OPEN c_get_id;
385: FETCH c_get_id INTO l_attached_document_id;

Line 453: --that you get from inserting a row in FND_DOCUMENTS table

449: p_content_type,
450: p_file_format);
451:
452: --now update the row in the edr_files_b table with the fnd_document_id
453: --that you get from inserting a row in FND_DOCUMENTS table
454:
455: UPDATE EDR_FILES_B
456: SET fnd_document_id = x_document_id
457: WHERE file_id = l_file_id;

Line 583: update fnd_documents set

579:
580: --Bug 3265035: Start
581: --this would allow the file to be attached to other business objects
582: --through the Document Catalog button in the attachment Forms UI
583: update fnd_documents set
584: security_type = G_SECURITY_OFF,
585: publish_flag = G_PUBLISH_FLAG_Y
586: where document_id = x_document_id;
587: --For the Status 'NO APPROVAL' Raise the Approval completion Event