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_DOCUMENTS

Line 35: DELETE FROM fnd_documents_short_text

31:
32: IF (l_delete_document_flag = 'Y') THEN
33: -- need to delete from each sub-table holding the data
34: -- doing this in a loop to reduce amount of code
35: DELETE FROM fnd_documents_short_text
36: WHERE media_id IN
37: (SELECT fd.media_id
38: FROM fnd_documents_tl fdtl,
39: fnd_documents fd,

Line 38: FROM fnd_documents_tl fdtl,

34: -- doing this in a loop to reduce amount of code
35: DELETE FROM fnd_documents_short_text
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

Line 39: fnd_documents fd,

35: DELETE FROM fnd_documents_short_text
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'

Line 49: DELETE FROM fnd_documents_long_text

45: AND fad.entity_name = X_entity_name
46: AND fad.pk1_value = X_pk1_value);
47:
48:
49: DELETE FROM fnd_documents_long_text
50: WHERE media_id IN
51: (SELECT fd.media_id
52: FROM fnd_documents_tl fdtl,
53: fnd_documents fd,

Line 52: FROM fnd_documents_tl fdtl,

48:
49: DELETE FROM fnd_documents_long_text
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

Line 53: fnd_documents fd,

49: DELETE FROM fnd_documents_long_text
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'

Line 62: DELETE FROM fnd_documents_long_raw

58: AND fd.datatype_id = 2
59: AND fad.entity_name = X_entity_name
60: AND fad.pk1_value = X_pk1_value);
61:
62: DELETE FROM fnd_documents_long_raw
63: WHERE media_id IN
64: (SELECT fd.media_id
65: FROM fnd_documents_tl fdtl,
66: fnd_documents fd,

Line 65: FROM fnd_documents_tl fdtl,

61:
62: DELETE FROM fnd_documents_long_raw
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

Line 66: fnd_documents fd,

62: DELETE FROM fnd_documents_long_raw
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'

Line 78: FROM fnd_documents_tl fdtl,

74:
75: DELETE FROM fnd_lobs
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

Line 79: fnd_documents fd,

75: DELETE FROM fnd_lobs
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'

Line 88: -- Delete from FND_DOCUMENTS_TL table

84: AND fd.datatype_id = 6
85: AND fad.entity_name = X_entity_name
86: AND fad.pk1_value = X_pk1_value);
87:
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

Line 89: DELETE FROM fnd_documents_tl

85: AND fad.entity_name = X_entity_name
86: AND fad.pk1_value = X_pk1_value);
87:
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

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 98: -- Delete from FND_DOCUMENTS table

94: AND fd.usage_type = 'O'
95: AND fad.entity_name = X_entity_name
96: AND fad.pk1_value = X_pk1_value);
97:
98: -- Delete from FND_DOCUMENTS table
99: DELETE FROM fnd_documents
100: WHERE usage_type = 'O'
101: AND document_id IN
102: (SELECT document_id

Line 99: DELETE FROM fnd_documents

95: AND fad.entity_name = X_entity_name
96: AND fad.pk1_value = X_pk1_value);
97:
98: -- Delete from FND_DOCUMENTS table
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

Line 118: DELETE FROM fnd_documents_short_text

114: ELSIF X_pk3_value IS NULL THEN -- performance change IF
115: IF (l_delete_document_flag = 'Y') THEN
116: -- need to delete from each sub-table holding the data
117: -- doing this in a loop to reduce amount of code
118: DELETE FROM fnd_documents_short_text
119: WHERE media_id IN
120: (SELECT fd.media_id
121: FROM fnd_documents_tl fdtl,
122: fnd_documents fd,

Line 121: FROM fnd_documents_tl fdtl,

117: -- doing this in a loop to reduce amount of code
118: DELETE FROM fnd_documents_short_text
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

Line 122: fnd_documents fd,

118: DELETE FROM fnd_documents_short_text
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'

Line 133: DELETE FROM fnd_documents_long_text

129: AND fad.pk1_value = X_pk1_value
130: AND fad.pk2_value = X_pk2_value);
131:
132:
133: DELETE FROM fnd_documents_long_text
134: WHERE media_id IN
135: (SELECT fd.media_id
136: FROM fnd_documents_tl fdtl,
137: fnd_documents fd,

Line 136: FROM fnd_documents_tl fdtl,

132:
133: DELETE FROM fnd_documents_long_text
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

Line 137: fnd_documents fd,

133: DELETE FROM fnd_documents_long_text
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'

Line 147: DELETE FROM fnd_documents_long_raw

143: AND fad.entity_name = X_entity_name
144: AND fad.pk1_value = X_pk1_value
145: AND fad.pk2_value = X_pk2_value);
146:
147: DELETE FROM fnd_documents_long_raw
148: WHERE media_id IN
149: (SELECT fd.media_id
150: FROM fnd_documents_tl fdtl,
151: fnd_documents fd,

Line 150: FROM fnd_documents_tl fdtl,

146:
147: DELETE FROM fnd_documents_long_raw
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

Line 151: fnd_documents fd,

147: DELETE FROM fnd_documents_long_raw
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'

Line 164: FROM fnd_documents_tl fdtl,

160:
161: DELETE FROM fnd_lobs
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

Line 165: fnd_documents fd,

161: DELETE FROM fnd_lobs
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'

Line 175: -- Delete from FND_DOCUMENTS_TL table

171: AND fad.entity_name = X_entity_name
172: AND fad.pk1_value = X_pk1_value
173: AND fad.pk2_value = X_pk2_value);
174:
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

Line 176: DELETE FROM fnd_documents_tl

172: AND fad.pk1_value = X_pk1_value
173: AND fad.pk2_value = X_pk2_value);
174:
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

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 186: -- Delete from FND_DOCUMENTS table

182: AND fad.entity_name = X_entity_name
183: AND fad.pk1_value = X_pk1_value
184: AND fad.pk2_value = X_pk2_value);
185:
186: -- Delete from FND_DOCUMENTS table
187: DELETE FROM fnd_documents
188: WHERE usage_type = 'O'
189: AND document_id IN
190: (SELECT document_id

Line 187: DELETE FROM fnd_documents

183: AND fad.pk1_value = X_pk1_value
184: AND fad.pk2_value = X_pk2_value);
185:
186: -- Delete from FND_DOCUMENTS table
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

Line 208: DELETE FROM fnd_documents_short_text

204: ELSIF X_pk4_value IS NULL THEN -- performance change if
205: IF (l_delete_document_flag = 'Y') THEN
206: -- need to delete from each sub-table holding the data
207: -- doing this in a loop to reduce amount of code
208: DELETE FROM fnd_documents_short_text
209: WHERE media_id IN
210: (SELECT fd.media_id
211: FROM fnd_documents_tl fdtl,
212: fnd_documents fd,

Line 211: FROM fnd_documents_tl fdtl,

207: -- doing this in a loop to reduce amount of code
208: DELETE FROM fnd_documents_short_text
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

Line 212: fnd_documents fd,

208: DELETE FROM fnd_documents_short_text
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'

Line 224: DELETE FROM fnd_documents_long_text

220: AND fad.pk2_value = X_pk2_value
221: AND fad.pk3_value = X_pk3_value);
222:
223:
224: DELETE FROM fnd_documents_long_text
225: WHERE media_id IN
226: (SELECT fd.media_id
227: FROM fnd_documents_tl fdtl,
228: fnd_documents fd,

Line 227: FROM fnd_documents_tl fdtl,

223:
224: DELETE FROM fnd_documents_long_text
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

Line 228: fnd_documents fd,

224: DELETE FROM fnd_documents_long_text
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'

Line 239: DELETE FROM fnd_documents_long_raw

235: AND fad.pk1_value = X_pk1_value
236: AND fad.pk2_value = X_pk2_value
237: AND fad.pk3_value = X_pk3_value);
238:
239: DELETE FROM fnd_documents_long_raw
240: WHERE media_id IN
241: (SELECT fd.media_id
242: FROM fnd_documents_tl fdtl,
243: fnd_documents fd,

Line 242: FROM fnd_documents_tl fdtl,

238:
239: DELETE FROM fnd_documents_long_raw
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

Line 243: fnd_documents fd,

239: DELETE FROM fnd_documents_long_raw
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'

Line 257: FROM fnd_documents_tl fdtl,

253:
254: DELETE FROM fnd_lobs
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

Line 258: fnd_documents fd,

254: DELETE FROM fnd_lobs
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'

Line 269: -- Delete from FND_DOCUMENTS_TL table

265: AND fad.pk1_value = X_pk1_value
266: AND fad.pk2_value = X_pk2_value
267: AND fad.pk3_value = X_pk3_value);
268:
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

Line 270: DELETE FROM fnd_documents_tl

266: AND fad.pk2_value = X_pk2_value
267: AND fad.pk3_value = X_pk3_value);
268:
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

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 281: -- Delete from FND_DOCUMENTS table

277: AND fad.pk1_value = X_pk1_value
278: AND fad.pk2_value = X_pk2_value
279: AND fad.pk3_value = X_pk3_value);
280:
281: -- Delete from FND_DOCUMENTS table
282: DELETE FROM fnd_documents
283: WHERE usage_type = 'O'
284: AND document_id IN
285: (SELECT document_id

Line 282: DELETE FROM fnd_documents

278: AND fad.pk2_value = X_pk2_value
279: AND fad.pk3_value = X_pk3_value);
280:
281: -- Delete from FND_DOCUMENTS table
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

Line 305: DELETE FROM fnd_documents_short_text

301: ELSE -- performance change if
302: IF (l_delete_document_flag = 'Y') THEN
303: -- need to delete from each sub-table holding the data
304: -- doing this in a loop to reduce amount of code
305: DELETE FROM fnd_documents_short_text
306: WHERE media_id IN
307: (SELECT fd.media_id
308: FROM fnd_documents_tl fdtl,
309: fnd_documents fd,

Line 308: FROM fnd_documents_tl fdtl,

304: -- doing this in a loop to reduce amount of code
305: DELETE FROM fnd_documents_short_text
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

Line 309: fnd_documents fd,

305: DELETE FROM fnd_documents_short_text
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'

Line 324: DELETE FROM fnd_documents_long_text

320: AND (X_pk5_value IS NULL
321: OR fad.pk5_value = X_pk5_value));
322:
323:
324: DELETE FROM fnd_documents_long_text
325: WHERE media_id IN
326: (SELECT fd.media_id
327: FROM fnd_documents_tl fdtl,
328: fnd_documents fd,

Line 327: FROM fnd_documents_tl fdtl,

323:
324: DELETE FROM fnd_documents_long_text
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

Line 328: fnd_documents fd,

324: DELETE FROM fnd_documents_long_text
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'

Line 342: DELETE FROM fnd_documents_long_raw

338: AND fad.pk4_value = X_pk4_value
339: AND (X_pk5_value IS NULL
340: OR fad.pk5_value = X_pk5_value));
341:
342: DELETE FROM fnd_documents_long_raw
343: WHERE media_id IN
344: (SELECT fd.media_id
345: FROM fnd_documents_tl fdtl,
346: fnd_documents fd,

Line 345: FROM fnd_documents_tl fdtl,

341:
342: DELETE FROM fnd_documents_long_raw
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

Line 346: fnd_documents fd,

342: DELETE FROM fnd_documents_long_raw
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'

Line 363: FROM fnd_documents_tl fdtl,

359:
360: DELETE FROM fnd_lobs
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

Line 364: fnd_documents fd,

360: DELETE FROM fnd_lobs
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'

Line 378: -- Delete from FND_DOCUMENTS_TL table

374: AND fad.pk4_value = X_pk4_value
375: AND (X_pk5_value IS NULL
376: OR fad.pk5_value = X_pk5_value));
377:
378: -- Delete from FND_DOCUMENTS_TL table
379: -- BUG#5060588 added Parens around OR's.
380: DELETE FROM fnd_documents_tl
381: WHERE document_id IN
382: (SELECT fad.document_id

Line 380: DELETE FROM fnd_documents_tl

376: OR fad.pk5_value = X_pk5_value));
377:
378: -- Delete from FND_DOCUMENTS_TL table
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

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 394: -- Delete from FND_DOCUMENTS table

390: AND fad.pk4_value = X_pk4_value
391: ANd (X_pk5_value IS NULL
392: OR fad.pk5_value = X_pk5_value));
393:
394: -- Delete from FND_DOCUMENTS table
395: -- BUG#5060588 added Parens around OR's.
396: DELETE FROM fnd_documents
397: WHERE usage_type = 'O'
398: AND document_id IN

Line 396: DELETE FROM fnd_documents

392: OR fad.pk5_value = X_pk5_value));
393:
394: -- Delete from FND_DOCUMENTS table
395: -- BUG#5060588 added Parens around OR's.
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

Line 525: fnd_documents fd,

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
529: AND fdtl.language = userenv('LANG')

Line 526: fnd_documents_tl fdtl

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
529: AND fdtl.language = userenv('LANG')
530: AND fad.entity_name = X_from_entity_name

Line 564: fnd_documents fd,

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
568: AND fdtl.language = userenv('LANG')

Line 565: fnd_documents_tl fdtl

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
568: AND fdtl.language = userenv('LANG')
569: AND fad.entity_name = X_from_entity_name

Line 606: fnd_documents fd,

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
610: AND fdtl.language = userenv('LANG')

Line 607: fnd_documents_tl fdtl

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
610: AND fdtl.language = userenv('LANG')
611: AND fad.entity_name = X_from_entity_name

Line 649: fnd_documents fd,

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
653: AND fdtl.language = userenv('LANG')

Line 650: fnd_documents_tl fdtl

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
653: AND fdtl.language = userenv('LANG')
654: AND fad.entity_name = X_from_entity_name

Line 674: FROM fnd_documents_short_text

670:
671:
672: CURSOR shorttext (mid NUMBER) IS
673: SELECT short_text
674: FROM fnd_documents_short_text
675: WHERE media_id = mid;
676:
677: CURSOR longtext (mid NUMBER) IS
678: SELECT long_text

Line 679: FROM fnd_documents_long_text

675: WHERE media_id = mid;
676:
677: CURSOR longtext (mid NUMBER) IS
678: SELECT long_text
679: FROM fnd_documents_long_text
680: WHERE media_id = mid;
681:
682: CURSOR fnd_lobs_cur (mid NUMBER) IS
683: SELECT file_id,

Line 702: long_text_tmp fnd_documents_long_text.long_text%TYPE;

698: document_id_tmp NUMBER;
699: row_id_tmp VARCHAR2(30);
700: short_text_tmp VARCHAR2(4000);
701: --long_text_tmp VARCHAR2(32767);
702: long_text_tmp fnd_documents_long_text.long_text%TYPE;
703: docrec doclist%ROWTYPE;
704: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
705: BEGIN
706: -- Use cursor loop to get all attachments associated with

Line 757: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,

753: --
754: IF (docrec.usage_type = 'O'
755: AND docrec.datatype_id IN (1,2,5,6) ) THEN
756: -- Create Documents records
757: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
758: document_id_tmp,
759: SYSDATE,
760: NVL(X_created_by,0),
761: SYSDATE,

Line 809: INSERT INTO fnd_documents_short_text (

805: OPEN shorttext(docrec.media_id);
806: FETCH shorttext INTO short_text_tmp;
807: CLOSE shorttext;
808:
809: INSERT INTO fnd_documents_short_text (
810: media_id,
811: short_text)
812: VALUES (
813: media_id_tmp,

Line 824: INSERT INTO fnd_documents_long_text (

820: OPEN longtext(docrec.media_id);
821: FETCH longtext INTO long_text_tmp;
822: CLOSE longtext;
823:
824: INSERT INTO fnd_documents_long_text (
825: media_id,
826: long_text)
827: VALUES (
828: media_id_tmp,

Line 937: UPDATE fnd_documents

933: -- was an ole or image that wasn't already a std doc
934: -- (images should be created as Std, but just in case)
935: IF (docrec.datatype_id IN (3,4)
936: AND docrec.usage_type <> 'S') THEN
937: UPDATE fnd_documents
938: SET usage_type = 'S'
939: WHERE document_id = docrec.document_id;
940: END IF;
941: