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.DOM_ATTACHMENT_UTIL_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 78: -- to pass to fnd_attached_documents_pkg.insert_row api.

74:
75:
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:

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 83: fnd_attached_documents_pkg.Insert_Row(

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,
86: X_document_id => l_document_id,
87: X_creation_date => sysdate,

Line 172: -- to pass to fnd_attached_documents_pkg.insert_row api.

168:
169:
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:

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 291: fnd_attached_documents_pkg.Insert_Row(

287:
288:
289: end if;
290:
291: fnd_attached_documents_pkg.Insert_Row(
292: X_Rowid => l_row_id,
293: X_attached_document_id => l_Attached_document_id,
294: X_document_id => l_document_id,
295: X_creation_date => sysdate,

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 349: from fnd_attached_documents att,

345: IS
346: cursor get_document_id
347: is
348: select att.document_id,docs.datatype_id
349: from fnd_attached_documents att,
350: fnd_documents docs
351: where Attached_document_id=p_Attached_document_id
352: and docs.document_id=att.document_id;
353:

Line 358: FROM fnd_attached_documents

354:
355: cursor check_other_attachments (cp_document_id number)
356: IS
357: SELECT attached_document_id
358: FROM fnd_attached_documents
359: where document_id=cp_document_id;
360:
361:
362: l_document_id number;

Line 372: delete fnd_attached_documents

368: fetch get_document_id INTO
369: l_document_id,l_datatype_id;
370: CLOSE get_document_id;
371:
372: delete fnd_attached_documents
373: where attached_document_id = p_Attached_document_id;
374:
375: open check_other_attachments (l_document_id);
376: fetch check_other_attachments INTO l_dummy;

Line 405: from fnd_attached_documents

401:
402: cursor get_document_id(cp_Attached_document_id number)
403: is
404: select document_id
405: from fnd_attached_documents
406: where Attached_document_id=p_Attached_document_id;
407: l_document_id number;
408:
409: BEGIN

Line 432: update fnd_attached_documents

428: ,last_updated_by = p_last_updated_by
429: ,last_update_login =p_last_update_login
430: where document_id= l_document_id;
431:
432: update fnd_attached_documents
433: set Category_id= p_Category
434: ,last_updated_by = p_last_updated_by
435: ,last_update_login =p_last_update_login
436: where Attached_document_id=p_Attached_document_id;

Line 453: UPDATE fnd_attached_documents

449:
450: IS
451:
452: BEGIN
453: UPDATE fnd_attached_documents
454: SET document_id = p_Document_id,
455: last_update_date = sysdate,
456: last_updated_by = p_last_updated_by,
457: last_update_login = p_last_update_login

Line 498: from fnd_attached_documents att,

494:
495: CURSOR get_affected_attachments(cp_dm_document_id NUMBER)
496: IS
497: select att.attached_document_id
498: from fnd_attached_documents att,
499: fnd_documents docs
500: where docs.document_id=att.document_id
501: and docs.dm_document_id=cp_dm_document_id;
502:

Line 549: UPDATE fnd_attached_documents

545:
546: --Update status for all the attached documents for the WS document.
547: FOR rec in get_affected_attachments(p_Document_id) LOOP
548: --dbms_output.put_line('Updating attachment id= '||rec.attached_document_id);
549: UPDATE fnd_attached_documents
550: SET status = p_Status,
551: last_update_date = sysdate,
552: last_updated_by = p_submitted_by,
553: last_update_login = p_last_update_login

Line 560: UPDATE fnd_attached_documents

556: END IF;
557:
558: IF( p_Attached_document_id IS NOT NULL) THEN
559: --Update status for Non-WebServices document
560: UPDATE fnd_attached_documents
561: SET status = p_Status,
562: last_update_date = sysdate,
563: last_updated_by = p_submitted_by,
564: last_update_login = p_last_update_login

Line 636: fnd_attached_documents2_pkg.delete_attachments(X_entity_name,

632: X_delete_document_flag IN VARCHAR2,
633: X_automatically_added_flag IN VARCHAR2 DEFAULT NULL) IS
634: l_delete_document_flag varchar2(1);
635: BEGIN
636: fnd_attached_documents2_pkg.delete_attachments(X_entity_name,
637: X_pk1_value,
638: X_pk2_value,
639: X_pk3_value,
640: X_pk4_value,

Line 690: FROM fnd_attached_documents fad,

686: fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
687: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
688: fd.URL fd_URL,
689: fd.MEDIA_ID fd_MEDIA_ID
690: FROM fnd_attached_documents fad,
691: fnd_documents fd,
692: fnd_documents_tl fdtl
693: WHERE fad.document_id = fd.document_id
694: AND fd.document_id = fdtl.document_id

Line 782: -- fnd_attached_documents

778: 'N',docrec.url, docrec.title);
779:
780: -- overwrite document_id from original
781: -- cursor for later insert into
782: -- fnd_attached_documents
783:
784: docrec.document_id := document_id_tmp;
785:
786: IF(docrec.datatype_id =7 OR docrec.datatype_id =8 OR docrec.datatype_id =9)

Line 963: FROM fnd_attached_documents fad,

959: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
960: fd.URL fd_URL,
961: fd.MEDIA_ID fd_MEDIA_ID
962:
963: FROM fnd_attached_documents fad,
964: fnd_documents fd,
965: fnd_documents_tl fdtl
966: WHERE fd.document_id = fad.document_id
967: AND fdtl.document_id = fd.document_id

Line 1008: FROM fnd_attached_documents fad,

1004: fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
1005: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
1006: fd.URL fd_URL,
1007: fd.MEDIA_ID fd_MEDIA_ID
1008: FROM fnd_attached_documents fad,
1009: fnd_documents fd,
1010: fnd_documents_tl fdtl
1011: WHERE fd.document_id = fad.document_id
1012: AND fdtl.document_id = fd.document_id

Line 1057: FROM fnd_attached_documents fad,

1053: fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
1054: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
1055: fd.URL fd_URL,
1056: fd.MEDIA_ID fd_MEDIA_ID
1057: FROM fnd_attached_documents fad,
1058: fnd_documents fd,
1059: fnd_documents_tl fdtl
1060: WHERE fd.document_id = fad.document_id
1061: AND fdtl.document_id = fd.document_id

Line 1107: FROM fnd_attached_documents fad,

1103: fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
1104: fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
1105: fd.URL fd_URL,
1106: fd.MEDIA_ID fd_MEDIA_ID
1107: FROM fnd_attached_documents fad,
1108: fnd_documents fd,
1109: fnd_documents_tl fdtl
1110: WHERE fd.document_id = fad.document_id
1111: AND fdtl.document_id = fd.document_id

Line 1259: -- fnd_attached_documents

1255: 'N',docrec.url, docrec.title);
1256:
1257: -- overwrite document_id from original
1258: -- cursor for later insert into
1259: -- fnd_attached_documents
1260:
1261: --update the document row for ws/webdav attachments
1262: IF(docrec.datatype_id =7 OR docrec.datatype_id =8 OR docrec.datatype_id =9)
1263: then

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,

Line 1356: INSERT INTO fnd_attached_documents

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,
1360: created_by,