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 3041: FROM fnd_documents_short_text

3037: AND fad.pk1_value = TO_CHAR(p_original_ro_id);
3038:
3039: CURSOR shorttext (mid NUMBER) IS
3040: SELECT short_text
3041: FROM fnd_documents_short_text
3042: WHERE media_id = mid;
3043:
3044: CURSOR longtext (mid NUMBER) IS
3045: SELECT long_text

Line 3220: -- into fnd_documents_short_text.

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

Line 3237: 'Inserting into fnd_documents_short_text for

3233:
3234: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3235: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3236: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3237: 'Inserting into fnd_documents_short_text for
3238: document id = '||docrec.document_id);
3239: END IF;
3240:
3241: INSERT INTO fnd_documents_short_text (

Line 3241: INSERT INTO fnd_documents_short_text (

3237: 'Inserting into fnd_documents_short_text for
3238: document id = '||docrec.document_id);
3239: END IF;
3240:
3241: INSERT INTO fnd_documents_short_text (
3242: media_id,
3243: short_text)
3244: VALUES (
3245: l_media_id_tmp,

Line 3560: -- Delete from FND_DOCUMENTS_SHORT_TEXT table

3556: --
3557: -- Begin API Body
3558: --
3559:
3560: -- Delete from FND_DOCUMENTS_SHORT_TEXT table
3561: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3562: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3563: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3564: 'Deleting from fnd_documents_short_text');

Line 3564: 'Deleting from fnd_documents_short_text');

3560: -- Delete from FND_DOCUMENTS_SHORT_TEXT table
3561: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3562: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3563: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3564: 'Deleting from fnd_documents_short_text');
3565: END IF;
3566:
3567: IF(Fnd_Log.Level_Event >= Fnd_Log.G_Current_Runtime_Level) THEN
3568: Fnd_Log.STRING(Fnd_Log.Level_Event,

Line 3574: DELETE FROM fnd_documents_short_text

3570: 'Started Deleting of Attachments');
3571: END IF;
3572:
3573:
3574: DELETE FROM fnd_documents_short_text
3575: WHERE media_id IN
3576: (SELECT fdtl.media_id
3577: FROM fnd_documents_tl fdtl,
3578: fnd_documents fd,