APPS.FND_ATTACHED_DOCUMENTS2_PKG dependencies on FND_DOCUMENTS_SHORT_TEXT

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 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 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 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 623: FROM fnd_documents_short_text

619:
620:
621: CURSOR shorttext (mid NUMBER) IS
622: SELECT short_text
623: FROM fnd_documents_short_text
624: WHERE media_id = mid;
625:
626: CURSOR longtext (mid NUMBER) IS
627: SELECT long_text

Line 753: INSERT INTO fnd_documents_short_text (

749: OPEN shorttext(docrec.media_id);
750: FETCH shorttext INTO short_text_tmp;
751: CLOSE shorttext;
752:
753: INSERT INTO fnd_documents_short_text (
754: media_id,
755: short_text)
756: VALUES (
757: media_id_tmp,