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

Line 3032: fnd_documents fd,

3028: fdtl.doc_attribute13 dattr13,
3029: fdtl.doc_attribute14 dattr14,
3030: fdtl.doc_attribute15 dattr15
3031: FROM fnd_attached_documents fad,
3032: fnd_documents fd,
3033: fnd_documents_tl fdtl
3034: WHERE fad.document_id = fd.document_id
3035: AND fd.document_id = fdtl.document_id
3036: AND fdtl.LANGUAGE = USERENV('LANG')

Line 3033: fnd_documents_tl fdtl

3029: fdtl.doc_attribute14 dattr14,
3030: fdtl.doc_attribute15 dattr15
3031: FROM fnd_attached_documents fad,
3032: fnd_documents fd,
3033: fnd_documents_tl fdtl
3034: WHERE fad.document_id = fd.document_id
3035: AND fd.document_id = fdtl.document_id
3036: AND fdtl.LANGUAGE = USERENV('LANG')
3037: AND fad.pk1_value = TO_CHAR(p_original_ro_id);

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 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 3177: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');

3173:
3174: IF ( Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level ) THEN
3175: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3176: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3177: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');
3178: END IF;
3179:
3180: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,
3181: l_document_id_tmp,

Line 3180: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,

3176: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3177: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');
3178: END IF;
3179:
3180: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,
3181: l_document_id_tmp,
3182: SYSDATE,
3183: Fnd_Global.user_id,
3184: SYSDATE,

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

Line 3577: FROM fnd_documents_tl fdtl,

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,
3579: fnd_attached_documents fad
3580: WHERE fdtl.document_id = fd.document_id
3581: AND fd.document_id = fad.document_id

Line 3578: fnd_documents fd,

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,
3579: fnd_attached_documents fad
3580: WHERE fdtl.document_id = fd.document_id
3581: AND fd.document_id = fad.document_id
3582: AND fd.usage_type = 'O'

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,

Line 3596: FROM fnd_documents_tl fdtl,

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,
3598: fnd_attached_documents fad
3599: WHERE fdtl.document_id = fd.document_id
3600: AND fd.document_id = fad.document_id

Line 3597: fnd_documents fd,

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,
3598: fnd_attached_documents fad
3599: WHERE fdtl.document_id = fd.document_id
3600: AND fd.document_id = fad.document_id
3601: AND fd.usage_type = 'O'

Line 3605: -- Delete from FND_DOCUMENTS_LONG_RAW table

3601: AND fd.usage_type = 'O'
3602: AND fd.datatype_id = 2
3603: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3604:
3605: -- Delete from FND_DOCUMENTS_LONG_RAW table
3606: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3607: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3608: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3609: 'Deleting from fnd_documents_long_raw');

Line 3609: 'Deleting from fnd_documents_long_raw');

3605: -- Delete from FND_DOCUMENTS_LONG_RAW table
3606: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3607: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3608: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3609: 'Deleting from fnd_documents_long_raw');
3610: END IF;
3611:
3612: DELETE FROM fnd_documents_long_raw
3613: WHERE media_id IN

Line 3612: DELETE FROM fnd_documents_long_raw

3608: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3609: 'Deleting from fnd_documents_long_raw');
3610: END IF;
3611:
3612: DELETE FROM fnd_documents_long_raw
3613: WHERE media_id IN
3614: (SELECT fdtl.media_id
3615: FROM fnd_documents_tl fdtl,
3616: fnd_documents fd,

Line 3615: FROM fnd_documents_tl fdtl,

3611:
3612: DELETE FROM fnd_documents_long_raw
3613: WHERE media_id IN
3614: (SELECT fdtl.media_id
3615: FROM fnd_documents_tl fdtl,
3616: fnd_documents fd,
3617: fnd_attached_documents fad
3618: WHERE fdtl.document_id = fd.document_id
3619: AND fd.document_id = fad.document_id

Line 3616: fnd_documents fd,

3612: DELETE FROM fnd_documents_long_raw
3613: WHERE media_id IN
3614: (SELECT fdtl.media_id
3615: FROM fnd_documents_tl fdtl,
3616: fnd_documents fd,
3617: fnd_attached_documents fad
3618: WHERE fdtl.document_id = fd.document_id
3619: AND fd.document_id = fad.document_id
3620: AND fd.usage_type = 'O'

Line 3635: FROM fnd_documents_tl fdtl,

3631:
3632: DELETE FROM fnd_lobs
3633: WHERE file_id IN
3634: (SELECT fdtl.media_id
3635: FROM fnd_documents_tl fdtl,
3636: fnd_documents fd,
3637: fnd_attached_documents fad
3638: WHERE fdtl.document_id = fd.document_id
3639: AND fd.document_id = fad.document_id

Line 3636: fnd_documents fd,

3632: DELETE FROM fnd_lobs
3633: WHERE file_id IN
3634: (SELECT fdtl.media_id
3635: FROM fnd_documents_tl fdtl,
3636: fnd_documents fd,
3637: fnd_attached_documents fad
3638: WHERE fdtl.document_id = fd.document_id
3639: AND fd.document_id = fad.document_id
3640: AND fd.usage_type = 'O'

Line 3644: -- Delete from FND_DOCUMENTS_TL table

3640: AND fd.usage_type = 'O'
3641: AND fd.datatype_id = 6
3642: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3643:
3644: -- Delete from FND_DOCUMENTS_TL table
3645: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3646: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3648: 'Deleting from fnd_documents_tl');

Line 3648: 'Deleting from fnd_documents_tl');

3644: -- Delete from FND_DOCUMENTS_TL table
3645: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3646: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3648: 'Deleting from fnd_documents_tl');
3649: END IF;
3650:
3651: DELETE FROM fnd_documents_tl
3652: WHERE document_id IN

Line 3651: DELETE FROM fnd_documents_tl

3647: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3648: 'Deleting from fnd_documents_tl');
3649: END IF;
3650:
3651: DELETE FROM fnd_documents_tl
3652: WHERE document_id IN
3653: (SELECT fad.document_id
3654: FROM fnd_attached_documents fad, fnd_documents fd
3655: WHERE fad.document_id = fd.document_id

Line 3654: FROM fnd_attached_documents fad, fnd_documents fd

3650:
3651: DELETE FROM fnd_documents_tl
3652: WHERE document_id IN
3653: (SELECT fad.document_id
3654: FROM fnd_attached_documents fad, fnd_documents fd
3655: WHERE fad.document_id = fd.document_id
3656: AND fd.usage_type = 'O'
3657: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3658:

Line 3659: -- Delete from FND_DOCUMENTS table

3655: WHERE fad.document_id = fd.document_id
3656: AND fd.usage_type = 'O'
3657: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3658:
3659: -- Delete from FND_DOCUMENTS table
3660: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3661: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3662: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3663: 'Deleting from fnd_documents');

Line 3663: 'Deleting from fnd_documents');

3659: -- Delete from FND_DOCUMENTS table
3660: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3661: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3662: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3663: 'Deleting from fnd_documents');
3664: END IF;
3665:
3666: DELETE FROM fnd_documents
3667: WHERE usage_type = 'O'

Line 3666: DELETE FROM fnd_documents

3662: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3663: 'Deleting from fnd_documents');
3664: END IF;
3665:
3666: DELETE FROM fnd_documents
3667: WHERE usage_type = 'O'
3668: AND document_id IN
3669: (SELECT document_id
3670: FROM fnd_attached_documents fad