APPS.FND_ATTACHED_DOCUMENTS2_PKG dependencies on FND_DOCUMENTS_LONG_TEXT

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 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 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 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 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 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,