eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIRS_PVT dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 3349: FROM fnd_documents_short_text

3345: AND fad.pk1_value = TO_CHAR(p_original_ro_id);
3346:
3347: CURSOR shorttext (mid NUMBER) IS
3348: SELECT short_text
3349: FROM fnd_documents_short_text
3350: WHERE media_id = mid;
3351:
3352: CURSOR longtext (mid NUMBER) IS
3353: SELECT long_text

Line 3528: -- into fnd_documents_short_text.

3524:
3525: -- Insert data into media tables depending on
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.

Line 3545: 'Inserting into fnd_documents_short_text for

3541:
3542: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3543: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3544: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3545: 'Inserting into fnd_documents_short_text for
3546: document id = '||docrec.document_id);
3547: END IF;
3548:
3549: INSERT INTO fnd_documents_short_text (

Line 3549: INSERT INTO fnd_documents_short_text (

3545: 'Inserting into fnd_documents_short_text for
3546: document id = '||docrec.document_id);
3547: END IF;
3548:
3549: INSERT INTO fnd_documents_short_text (
3550: media_id,
3551: short_text)
3552: VALUES (
3553: l_media_id_tmp,

Line 3868: -- Delete from FND_DOCUMENTS_SHORT_TEXT table

3864: --
3865: -- Begin API Body
3866: --
3867:
3868: -- Delete from FND_DOCUMENTS_SHORT_TEXT table
3869: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3870: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3871: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3872: 'Deleting from fnd_documents_short_text');

Line 3872: 'Deleting from fnd_documents_short_text');

3868: -- Delete from FND_DOCUMENTS_SHORT_TEXT table
3869: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3870: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3871: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3872: 'Deleting from fnd_documents_short_text');
3873: END IF;
3874:
3875: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3876: Fnd_Log.STRING(Fnd_Log.Level_Event,

Line 3882: DELETE FROM fnd_documents_short_text

3878: 'Started Deleting of Attachments');
3879: END IF;
3880:
3881:
3882: DELETE FROM fnd_documents_short_text
3883: WHERE media_id IN
3884: (SELECT fdtl.media_id
3885: FROM fnd_documents_tl fdtl,
3886: fnd_documents fd,