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

Line 1: PACKAGE BODY fnd_attached_documents2_pkg as

1: PACKAGE BODY fnd_attached_documents2_pkg as
2: /* $Header: AFAKATDB.pls 120.12 2011/11/17 18:46:42 ctilley ship $ */
3:
4:
5:

Line 40: fnd_attached_documents fad

36: WHERE media_id IN
37: (SELECT fd.media_id
38: FROM fnd_documents_tl fdtl,
39: fnd_documents fd,
40: fnd_attached_documents fad
41: WHERE fdtl.document_id = fd.document_id
42: AND fd.document_id = fad.document_id
43: AND fd.usage_type = 'O'
44: AND fd.datatype_id = 1

Line 54: fnd_attached_documents fad

50: WHERE media_id IN
51: (SELECT fd.media_id
52: FROM fnd_documents_tl fdtl,
53: fnd_documents fd,
54: fnd_attached_documents fad
55: WHERE fdtl.document_id = fd.document_id
56: AND fd.document_id = fad.document_id
57: AND fd.usage_type = 'O'
58: AND fd.datatype_id = 2

Line 67: fnd_attached_documents fad

63: WHERE media_id IN
64: (SELECT fd.media_id
65: FROM fnd_documents_tl fdtl,
66: fnd_documents fd,
67: fnd_attached_documents fad
68: WHERE fdtl.document_id = fd.document_id
69: AND fd.document_id = fad.document_id
70: AND fd.usage_type = 'O'
71: AND fd.datatype_id IN (3,4)

Line 80: fnd_attached_documents fad

76: WHERE file_id IN
77: (SELECT fd.media_id
78: FROM fnd_documents_tl fdtl,
79: fnd_documents fd,
80: fnd_attached_documents fad
81: WHERE fdtl.document_id = fd.document_id
82: AND fd.document_id = fad.document_id
83: AND fd.usage_type = 'O'
84: AND fd.datatype_id = 6

Line 92: FROM fnd_attached_documents fad, fnd_documents fd

88: -- Delete from FND_DOCUMENTS_TL table
89: DELETE FROM fnd_documents_tl
90: WHERE document_id IN
91: (SELECT fad.document_id
92: FROM fnd_attached_documents fad, fnd_documents fd
93: WHERE fad.document_id = fd.document_id
94: AND fd.usage_type = 'O'
95: AND fad.entity_name = X_entity_name
96: AND fad.pk1_value = X_pk1_value);

Line 103: FROM fnd_attached_documents fad

99: DELETE FROM fnd_documents
100: WHERE usage_type = 'O'
101: AND document_id IN
102: (SELECT document_id
103: FROM fnd_attached_documents fad
104: WHERE fad.entity_name = X_entity_name
105: AND fad.pk1_value = X_pk1_value);
106: END IF; -- end of if l_delete_document_flag is Y
107:

Line 108: -- delete from FND_ATTACHED_DOCUMENTS table

104: WHERE fad.entity_name = X_entity_name
105: AND fad.pk1_value = X_pk1_value);
106: END IF; -- end of if l_delete_document_flag is Y
107:
108: -- delete from FND_ATTACHED_DOCUMENTS table
109: DELETE FROM fnd_attached_documents fad
110: WHERE fad.entity_name = X_entity_name
111: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
112: AND fad.pk1_value = X_pk1_value;

Line 109: DELETE FROM fnd_attached_documents fad

105: AND fad.pk1_value = X_pk1_value);
106: END IF; -- end of if l_delete_document_flag is Y
107:
108: -- delete from FND_ATTACHED_DOCUMENTS table
109: DELETE FROM fnd_attached_documents fad
110: WHERE fad.entity_name = X_entity_name
111: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
112: AND fad.pk1_value = X_pk1_value;
113:

Line 123: fnd_attached_documents fad

119: WHERE media_id IN
120: (SELECT fd.media_id
121: FROM fnd_documents_tl fdtl,
122: fnd_documents fd,
123: fnd_attached_documents fad
124: WHERE fdtl.document_id = fd.document_id
125: AND fd.document_id = fad.document_id
126: AND fd.usage_type = 'O'
127: AND fd.datatype_id = 1

Line 138: fnd_attached_documents fad

134: WHERE media_id IN
135: (SELECT fd.media_id
136: FROM fnd_documents_tl fdtl,
137: fnd_documents fd,
138: fnd_attached_documents fad
139: WHERE fdtl.document_id = fd.document_id
140: AND fd.document_id = fad.document_id
141: AND fd.usage_type = 'O'
142: AND fd.datatype_id = 2

Line 152: fnd_attached_documents fad

148: WHERE media_id IN
149: (SELECT fd.media_id
150: FROM fnd_documents_tl fdtl,
151: fnd_documents fd,
152: fnd_attached_documents fad
153: WHERE fdtl.document_id = fd.document_id
154: AND fd.document_id = fad.document_id
155: AND fd.usage_type = 'O'
156: AND fd.datatype_id IN (3,4)

Line 166: fnd_attached_documents fad

162: WHERE file_id IN
163: (SELECT fd.media_id
164: FROM fnd_documents_tl fdtl,
165: fnd_documents fd,
166: fnd_attached_documents fad
167: WHERE fdtl.document_id = fd.document_id
168: AND fd.document_id = fad.document_id
169: AND fd.usage_type = 'O'
170: AND fd.datatype_id = 6

Line 179: FROM fnd_attached_documents fad, fnd_documents fd

175: -- Delete from FND_DOCUMENTS_TL table
176: DELETE FROM fnd_documents_tl
177: WHERE document_id IN
178: (SELECT fad.document_id
179: FROM fnd_attached_documents fad, fnd_documents fd
180: WHERE fad.document_id = fd.document_id
181: AND fd.usage_type = 'O'
182: AND fad.entity_name = X_entity_name
183: AND fad.pk1_value = X_pk1_value

Line 191: FROM fnd_attached_documents fad

187: DELETE FROM fnd_documents
188: WHERE usage_type = 'O'
189: AND document_id IN
190: (SELECT document_id
191: FROM fnd_attached_documents fad
192: WHERE fad.entity_name = X_entity_name
193: AND fad.pk1_value = X_pk1_value
194: AND fad.pk2_value = X_pk2_value);
195: END IF; -- end of if l_delete_document_flag is Y

Line 197: -- delete from FND_ATTACHED_DOCUMENTS table

193: AND fad.pk1_value = X_pk1_value
194: AND fad.pk2_value = X_pk2_value);
195: END IF; -- end of if l_delete_document_flag is Y
196:
197: -- delete from FND_ATTACHED_DOCUMENTS table
198: DELETE FROM fnd_attached_documents fad
199: WHERE fad.entity_name = X_entity_name
200: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
201: AND fad.pk1_value = X_pk1_value

Line 198: DELETE FROM fnd_attached_documents fad

194: AND fad.pk2_value = X_pk2_value);
195: END IF; -- end of if l_delete_document_flag is Y
196:
197: -- delete from FND_ATTACHED_DOCUMENTS table
198: DELETE FROM fnd_attached_documents fad
199: WHERE fad.entity_name = X_entity_name
200: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
201: AND fad.pk1_value = X_pk1_value
202: AND fad.pk2_value = X_pk2_value;

Line 213: fnd_attached_documents fad

209: WHERE media_id IN
210: (SELECT fd.media_id
211: FROM fnd_documents_tl fdtl,
212: fnd_documents fd,
213: fnd_attached_documents fad
214: WHERE fdtl.document_id = fd.document_id
215: AND fd.document_id = fad.document_id
216: AND fd.usage_type = 'O'
217: AND fd.datatype_id = 1

Line 229: fnd_attached_documents fad

225: WHERE media_id IN
226: (SELECT fd.media_id
227: FROM fnd_documents_tl fdtl,
228: fnd_documents fd,
229: fnd_attached_documents fad
230: WHERE fdtl.document_id = fd.document_id
231: AND fd.document_id = fad.document_id
232: AND fd.usage_type = 'O'
233: AND fd.datatype_id = 2

Line 244: fnd_attached_documents fad

240: WHERE media_id IN
241: (SELECT fd.media_id
242: FROM fnd_documents_tl fdtl,
243: fnd_documents fd,
244: fnd_attached_documents fad
245: WHERE fdtl.document_id = fd.document_id
246: AND fd.document_id = fad.document_id
247: AND fd.usage_type = 'O'
248: AND fd.datatype_id IN (3,4)

Line 259: fnd_attached_documents fad

255: WHERE file_id IN
256: (SELECT fd.media_id
257: FROM fnd_documents_tl fdtl,
258: fnd_documents fd,
259: fnd_attached_documents fad
260: WHERE fdtl.document_id = fd.document_id
261: AND fd.document_id = fad.document_id
262: AND fd.usage_type = 'O'
263: AND fd.datatype_id = 6

Line 273: FROM fnd_attached_documents fad, fnd_documents fd

269: -- Delete from FND_DOCUMENTS_TL table
270: DELETE FROM fnd_documents_tl
271: WHERE document_id IN
272: (SELECT fad.document_id
273: FROM fnd_attached_documents fad, fnd_documents fd
274: WHERE fad.document_id = fd.document_id
275: AND fd.usage_type = 'O'
276: AND fad.entity_name = X_entity_name
277: AND fad.pk1_value = X_pk1_value

Line 286: FROM fnd_attached_documents fad

282: DELETE FROM fnd_documents
283: WHERE usage_type = 'O'
284: AND document_id IN
285: (SELECT document_id
286: FROM fnd_attached_documents fad
287: WHERE fad.entity_name = X_entity_name
288: AND fad.pk1_value = X_pk1_value
289: AND fad.pk2_value = X_pk2_value
290: AND fad.pk3_value = X_pk3_value);

Line 293: -- delete from FND_ATTACHED_DOCUMENTS table

289: AND fad.pk2_value = X_pk2_value
290: AND fad.pk3_value = X_pk3_value);
291: END IF; -- end of if l_delete_document_flag is Y
292:
293: -- delete from FND_ATTACHED_DOCUMENTS table
294: DELETE FROM fnd_attached_documents fad
295: WHERE fad.entity_name = X_entity_name
296: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
297: AND fad.pk1_value = X_pk1_value

Line 294: DELETE FROM fnd_attached_documents fad

290: AND fad.pk3_value = X_pk3_value);
291: END IF; -- end of if l_delete_document_flag is Y
292:
293: -- delete from FND_ATTACHED_DOCUMENTS table
294: DELETE FROM fnd_attached_documents fad
295: WHERE fad.entity_name = X_entity_name
296: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
297: AND fad.pk1_value = X_pk1_value
298: AND fad.pk2_value = X_pk2_value

Line 310: fnd_attached_documents fad

306: WHERE media_id IN
307: (SELECT fd.media_id
308: FROM fnd_documents_tl fdtl,
309: fnd_documents fd,
310: fnd_attached_documents fad
311: WHERE fdtl.document_id = fd.document_id
312: AND fd.document_id = fad.document_id
313: AND fd.usage_type = 'O'
314: AND fd.datatype_id = 1

Line 329: fnd_attached_documents fad

325: WHERE media_id IN
326: (SELECT fd.media_id
327: FROM fnd_documents_tl fdtl,
328: fnd_documents fd,
329: fnd_attached_documents fad
330: WHERE fdtl.document_id = fd.document_id
331: AND fd.document_id = fad.document_id
332: AND fd.usage_type = 'O'
333: AND fd.datatype_id = 2

Line 347: fnd_attached_documents fad

343: WHERE media_id IN
344: (SELECT fd.media_id
345: FROM fnd_documents_tl fdtl,
346: fnd_documents fd,
347: fnd_attached_documents fad
348: WHERE fdtl.document_id = fd.document_id
349: AND fd.document_id = fad.document_id
350: AND fd.usage_type = 'O'
351: AND fd.datatype_id IN (3,4)

Line 365: fnd_attached_documents fad

361: WHERE file_id IN
362: (SELECT fd.media_id
363: FROM fnd_documents_tl fdtl,
364: fnd_documents fd,
365: fnd_attached_documents fad
366: WHERE fdtl.document_id = fd.document_id
367: AND fd.document_id = fad.document_id
368: AND fd.usage_type = 'O'
369: AND fd.datatype_id = 6

Line 383: FROM fnd_attached_documents fad, fnd_documents fd

379: -- BUG#5060588 added Parens around OR's.
380: DELETE FROM fnd_documents_tl
381: WHERE document_id IN
382: (SELECT fad.document_id
383: FROM fnd_attached_documents fad, fnd_documents fd
384: WHERE fad.document_id = fd.document_id
385: AND fd.usage_type = 'O'
386: AND fad.entity_name = X_entity_name
387: AND fad.pk1_value = X_pk1_value

Line 400: FROM fnd_attached_documents fad

396: DELETE FROM fnd_documents
397: WHERE usage_type = 'O'
398: AND document_id IN
399: (SELECT document_id
400: FROM fnd_attached_documents fad
401: WHERE fad.entity_name = X_entity_name
402: AND fad.pk1_value = X_pk1_value
403: AND fad.pk2_value = X_pk2_value
404: AND fad.pk3_value = X_pk3_value

Line 410: -- delete from FND_ATTACHED_DOCUMENTS table

406: AND (X_pk5_value IS NULL
407: OR fad.pk5_value = X_pk5_value));
408: END IF; -- end of if l_delete_document_flag is Y
409:
410: -- delete from FND_ATTACHED_DOCUMENTS table
411: -- BUG#5060588 added Parens around OR's.
412: DELETE FROM fnd_attached_documents fad
413: WHERE fad.entity_name = X_entity_name
414: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)

Line 412: DELETE FROM fnd_attached_documents fad

408: END IF; -- end of if l_delete_document_flag is Y
409:
410: -- delete from FND_ATTACHED_DOCUMENTS table
411: -- BUG#5060588 added Parens around OR's.
412: DELETE FROM fnd_attached_documents fad
413: WHERE fad.entity_name = X_entity_name
414: AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
415: AND fad.pk1_value = X_pk1_value
416: AND fad.pk2_value = X_pk2_value

Line 524: FROM fnd_attached_documents fad,

520: fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
521: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
522: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title, fd.dm_node,
523: fd.dm_folder_path,fd.dm_type, fd.dm_document_id,fd.dm_version_number
524: FROM fnd_attached_documents fad,
525: fnd_documents fd,
526: fnd_documents_tl fdtl
527: WHERE fad.document_id = fd.document_id
528: AND fd.document_id = fdtl.document_id

Line 563: FROM fnd_attached_documents fad,

559: fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
560: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
561: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title, fd.dm_node,
562: fd.dm_folder_path,fd.dm_type, fd.dm_document_id, fd.dm_version_number
563: FROM fnd_attached_documents fad,
564: fnd_documents fd,
565: fnd_documents_tl fdtl
566: WHERE fad.document_id = fd.document_id
567: AND fd.document_id = fdtl.document_id

Line 605: FROM fnd_attached_documents fad,

601: fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
602: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
603: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title, fd.dm_node,
604: fd.dm_folder_path,fd.dm_type, fd.dm_document_id, fd.dm_version_number
605: FROM fnd_attached_documents fad,
606: fnd_documents fd,
607: fnd_documents_tl fdtl
608: WHERE fad.document_id = fd.document_id
609: AND fd.document_id = fdtl.document_id

Line 648: FROM fnd_attached_documents fad,

644: fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
645: fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
646: fdtl.doc_attribute15 dattr15, fd.url, fdtl.title, fd.dm_node,
647: fd.dm_folder_path,fd.dm_type, fd.dm_document_id, fd.dm_version_number
648: FROM fnd_attached_documents fad,
649: fnd_documents fd,
650: fnd_documents_tl fdtl
651: WHERE fad.document_id = fd.document_id
652: AND fd.document_id = fdtl.document_id

Line 798: -- fnd_attached_documents

794: docrec.document_id);
795:
796: -- overwrite document_id from original
797: -- cursor for later insert into
798: -- fnd_attached_documents
799: docrec.document_id := document_id_tmp;
800:
801: -- Duplicate short or long text
802: IF (docrec.datatype_id = 1) THEN

Line 882: INSERT INTO fnd_attached_documents

878:
879: END IF; -- end if usage_type = 'O' and datatype in (1,2,6)
880:
881: -- Create attachment record
882: INSERT INTO fnd_attached_documents
883: (attached_document_id,
884: document_id,
885: creation_date,
886: created_by,

Line 903: (fnd_attached_documents_s.nextval,

899: attribute5, attribute6, attribute7,
900: attribute8, attribute9, attribute10,
901: attribute11, attribute12, attribute13,
902: attribute14, attribute15, column1, category_id, orig_attach_doc_id) VALUES
903: (fnd_attached_documents_s.nextval,
904: docrec.document_id,
905: sysdate,
906: NVL(X_created_by,0),
907: sysdate,

Line 967: END fnd_attached_documents2_pkg;

963:
964: END copy_attachments;
965:
966:
967: END fnd_attached_documents2_pkg;