APPS.CSD_REPAIRS_PVT dependencies on FND_DOCUMENTS_LONG_TEXT

Line 3354: FROM fnd_documents_long_text

3350: WHERE media_id = mid;
3351:
3352: CURSOR longtext (mid NUMBER) IS
3353: SELECT long_text
3354: FROM fnd_documents_long_text
3355: WHERE media_id = mid;
3356:
3357: CURSOR fnd_lobs_cur (mid NUMBER) IS
3358: SELECT file_id,

Line 3530: -- into fnd_documents_long_text.

3526: -- the data type.
3527: -- 1.If datatype id = 1 (short text) then insert
3528: -- into fnd_documents_short_text.
3529: -- 2.If datatype id = 2 (Long text) then insert
3530: -- into fnd_documents_long_text.
3531: -- 3.If datatype id = 6 ( File ) then insert
3532: -- into fnd_lobs_cur.
3533:
3534: -- Duplicate short or long text

Line 3568: 'Inserting into fnd_documents_long_text for

3564:
3565: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3566: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3567: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3568: 'Inserting into fnd_documents_long_text for
3569: document id = '||docrec.document_id);
3570: END IF;
3571:
3572: INSERT INTO fnd_documents_long_text (

Line 3572: INSERT INTO fnd_documents_long_text (

3568: 'Inserting into fnd_documents_long_text for
3569: document id = '||docrec.document_id);
3570: END IF;
3571:
3572: INSERT INTO fnd_documents_long_text (
3573: media_id,
3574: long_text)
3575: VALUES (
3576: l_media_id_tmp,

Line 3894: -- Delete from FND_DOCUMENTS_LONG_TEXT table

3890: AND fd.usage_type = 'O'
3891: AND fd.datatype_id = 1
3892: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3893:
3894: -- Delete from FND_DOCUMENTS_LONG_TEXT table
3895: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3896: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3897: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3898: 'Deleting from fnd_documents_long_text');

Line 3898: 'Deleting from fnd_documents_long_text');

3894: -- Delete from FND_DOCUMENTS_LONG_TEXT table
3895: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3896: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3897: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3898: 'Deleting from fnd_documents_long_text');
3899: END IF;
3900:
3901: DELETE FROM fnd_documents_long_text
3902: WHERE media_id IN

Line 3901: DELETE FROM fnd_documents_long_text

3897: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3898: 'Deleting from fnd_documents_long_text');
3899: END IF;
3900:
3901: DELETE FROM fnd_documents_long_text
3902: WHERE media_id IN
3903: (SELECT fdtl.media_id
3904: FROM fnd_documents_tl fdtl,
3905: fnd_documents fd,