APPS.CSD_REPAIRS_PVT dependencies on FND_DOCUMENTS_LONG_TEXT

Line 3046: FROM fnd_documents_long_text

3042: WHERE media_id = mid;
3043:
3044: CURSOR longtext (mid NUMBER) IS
3045: SELECT long_text
3046: FROM fnd_documents_long_text
3047: WHERE media_id = mid;
3048:
3049: CURSOR fnd_lobs_cur (mid NUMBER) IS
3050: SELECT file_id,

Line 3222: -- into fnd_documents_long_text.

3218: -- the data type.
3219: -- 1.If datatype id = 1 (short text) then insert
3220: -- into fnd_documents_short_text.
3221: -- 2.If datatype id = 2 (Long text) then insert
3222: -- into fnd_documents_long_text.
3223: -- 3.If datatype id = 6 ( File ) then insert
3224: -- into fnd_lobs_cur.
3225:
3226: -- Duplicate short or long text

Line 3260: 'Inserting into fnd_documents_long_text for

3256:
3257: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3258: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3259: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3260: 'Inserting into fnd_documents_long_text for
3261: document id = '||docrec.document_id);
3262: END IF;
3263:
3264: INSERT INTO fnd_documents_long_text (

Line 3264: INSERT INTO fnd_documents_long_text (

3260: 'Inserting into fnd_documents_long_text for
3261: document id = '||docrec.document_id);
3262: END IF;
3263:
3264: INSERT INTO fnd_documents_long_text (
3265: media_id,
3266: long_text)
3267: VALUES (
3268: l_media_id_tmp,

Line 3586: -- Delete from FND_DOCUMENTS_LONG_TEXT table

3582: AND fd.usage_type = 'O'
3583: AND fd.datatype_id = 1
3584: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3585:
3586: -- Delete from FND_DOCUMENTS_LONG_TEXT table
3587: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3588: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3589: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3590: 'Deleting from fnd_documents_long_text');

Line 3590: 'Deleting from fnd_documents_long_text');

3586: -- Delete from FND_DOCUMENTS_LONG_TEXT table
3587: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3588: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3589: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3590: 'Deleting from fnd_documents_long_text');
3591: END IF;
3592:
3593: DELETE FROM fnd_documents_long_text
3594: WHERE media_id IN

Line 3593: DELETE FROM fnd_documents_long_text

3589: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3590: 'Deleting from fnd_documents_long_text');
3591: END IF;
3592:
3593: DELETE FROM fnd_documents_long_text
3594: WHERE media_id IN
3595: (SELECT fdtl.media_id
3596: FROM fnd_documents_tl fdtl,
3597: fnd_documents fd,