eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_ATTACHMENTS_GRP dependencies on FND_DOCUMENTS

Line 58: fnd_documents fd,

54: fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
55: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
56: fdtl.doc_attribute15 dattr15
57: FROM fnd_attached_documents fad,
58: fnd_documents fd,
59: fnd_documents_tl fdtl
60: WHERE fad.document_id = fd.document_id
61: AND fd.document_id = fdtl.document_id
62: AND fdtl.language = userenv('LANG')

Line 59: fnd_documents_tl fdtl

55: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
56: fdtl.doc_attribute15 dattr15
57: FROM fnd_attached_documents fad,
58: fnd_documents fd,
59: fnd_documents_tl fdtl
60: WHERE fad.document_id = fd.document_id
61: AND fd.document_id = fdtl.document_id
62: AND fdtl.language = userenv('LANG')
63: AND fad.entity_name = X_from_entity_name

Line 80: FROM fnd_documents_short_text

76: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag);
77:
78: CURSOR shorttext (mid NUMBER) IS
79: SELECT short_text
80: FROM fnd_documents_short_text
81: WHERE media_id = mid;
82:
83: CURSOR longtext (mid NUMBER) IS
84: SELECT long_text

Line 85: FROM fnd_documents_long_text

81: WHERE media_id = mid;
82:
83: CURSOR longtext (mid NUMBER) IS
84: SELECT long_text
85: FROM fnd_documents_long_text
86: WHERE media_id = mid;
87:
88: CURSOR fnd_lobs_cur (mid NUMBER) IS
89: SELECT file_id,

Line 140: FND_DOCUMENTS_PKG.Insert_Row

136:
137: THEN
138: --Bug 4381237: End
139: -- Create Documents records
140: FND_DOCUMENTS_PKG.Insert_Row
141: (row_id_tmp,
142: document_id_tmp,
143: SYSDATE,
144: NVL(X_created_by,0),

Line 193: INSERT INTO fnd_documents_short_text

189: OPEN shorttext(docrec.media_id);
190: FETCH shorttext INTO short_text_tmp;
191: CLOSE shorttext;
192:
193: INSERT INTO fnd_documents_short_text
194: (media_id,
195: short_text)
196: VALUES
197: (media_id_tmp,

Line 208: INSERT INTO fnd_documents_long_text

204: OPEN longtext(docrec.media_id);
205: FETCH longtext INTO long_text_tmp;
206: CLOSE longtext;
207:
208: INSERT INTO fnd_documents_long_text
209: (media_id,
210: long_text)
211: VALUES
212: (media_id_tmp,

Line 317: UPDATE fnd_documents

313: -- was an ole or image that wasn't already a std doc
314: -- (images should be created as Std, but just in case)
315: IF (docrec.datatype_id IN (3,4)
316: AND docrec.usage_type <> 'S') THEN
317: UPDATE fnd_documents
318: SET usage_type = 'S'
319: WHERE document_id = docrec.document_id;
320: END IF;
321:

Line 427: fnd_documents fd,

423: fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
424: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
425: fdtl.doc_attribute15 dattr15
426: FROM fnd_attached_documents fad,
427: fnd_documents fd,
428: fnd_documents_tl fdtl
429: --WHERE fad.document_id = fd.document_id
430: WHERE fad.document_id = X_document_id
431: AND fad.document_id = fd.document_id

Line 428: fnd_documents_tl fdtl

424: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
425: fdtl.doc_attribute15 dattr15
426: FROM fnd_attached_documents fad,
427: fnd_documents fd,
428: fnd_documents_tl fdtl
429: --WHERE fad.document_id = fd.document_id
430: WHERE fad.document_id = X_document_id
431: AND fad.document_id = fd.document_id
432: AND fd.document_id = fdtl.document_id

Line 451: FROM fnd_documents_short_text

447: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag);
448:
449: CURSOR shorttext (mid NUMBER) IS
450: SELECT short_text
451: FROM fnd_documents_short_text
452: WHERE media_id = mid;
453:
454: CURSOR longtext (mid NUMBER) IS
455: SELECT long_text

Line 456: FROM fnd_documents_long_text

452: WHERE media_id = mid;
453:
454: CURSOR longtext (mid NUMBER) IS
455: SELECT long_text
456: FROM fnd_documents_long_text
457: WHERE media_id = mid;
458:
459: CURSOR fnd_lobs_cur (mid NUMBER) IS
460: SELECT file_id,

Line 511: FND_DOCUMENTS_PKG.Insert_Row

507:
508: THEN
509: --Bug 4381237: End
510: -- Create Documents records
511: FND_DOCUMENTS_PKG.Insert_Row
512: (row_id_tmp,
513: document_id_tmp,
514: SYSDATE,
515: NVL(X_created_by,0),

Line 564: INSERT INTO fnd_documents_short_text

560: OPEN shorttext(docrec.media_id);
561: FETCH shorttext INTO short_text_tmp;
562: CLOSE shorttext;
563:
564: INSERT INTO fnd_documents_short_text
565: (media_id,
566: short_text)
567: VALUES
568: (media_id_tmp,

Line 579: INSERT INTO fnd_documents_long_text

575: OPEN longtext(docrec.media_id);
576: FETCH longtext INTO long_text_tmp;
577: CLOSE longtext;
578:
579: INSERT INTO fnd_documents_long_text
580: (media_id,
581: long_text)
582: VALUES
583: (media_id_tmp,

Line 688: UPDATE fnd_documents

684: -- was an ole or image that wasn't already a std doc
685: -- (images should be created as Std, but just in case)
686: IF (docrec.datatype_id IN (3,4)
687: AND docrec.usage_type <> 'S') THEN
688: UPDATE fnd_documents
689: SET usage_type = 'S'
690: WHERE document_id = docrec.document_id;
691: END IF;
692:

Line 973: update fnd_documents set

969: where file_id = p_file_id;
970:
971: --this would allow the file to be attached to other business objects
972: --through the Document Catalog button in the attachment Forms UI
973: update fnd_documents set
974: security_type = G_SECURITY_OFF,
975: publish_flag = G_PUBLISH_FLAG_Y
976: where document_id = l_document_id;
977: end if;