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,
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,
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,
321: OR X_pk5_value IS NULL
322: AND fad.pk5_value = X_pk5_value);
323:
324:
325: DELETE FROM fnd_documents_long_text
326: WHERE media_id IN
327: (SELECT fd.media_id
328: FROM fnd_documents_tl fdtl,
329: fnd_documents fd,
624: WHERE media_id = mid;
625:
626: CURSOR longtext (mid NUMBER) IS
627: SELECT long_text
628: FROM fnd_documents_long_text
629: WHERE media_id = mid;
630:
631: CURSOR fnd_lobs_cur (mid NUMBER) IS
632: SELECT file_id,
764: OPEN longtext(docrec.media_id);
765: FETCH longtext INTO long_text_tmp;
766: CLOSE longtext;
767:
768: INSERT INTO fnd_documents_long_text (
769: media_id,
770: long_text)
771: VALUES (
772: media_id_tmp,