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 3340: fnd_documents fd,

3336: fdtl.doc_attribute13 dattr13,
3337: fdtl.doc_attribute14 dattr14,
3338: fdtl.doc_attribute15 dattr15
3339: FROM fnd_attached_documents fad,
3340: fnd_documents fd,
3341: fnd_documents_tl fdtl
3342: WHERE fad.document_id = fd.document_id
3343: AND fd.document_id = fdtl.document_id
3344: AND fdtl.LANGUAGE = USERENV('LANG')

Line 3341: fnd_documents_tl fdtl

3337: fdtl.doc_attribute14 dattr14,
3338: fdtl.doc_attribute15 dattr15
3339: FROM fnd_attached_documents fad,
3340: fnd_documents fd,
3341: fnd_documents_tl fdtl
3342: WHERE fad.document_id = fd.document_id
3343: AND fd.document_id = fdtl.document_id
3344: AND fdtl.LANGUAGE = USERENV('LANG')
3345: AND fad.pk1_value = TO_CHAR(p_original_ro_id);

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

3481:
3482: IF ( Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level ) THEN
3483: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3484: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3485: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');
3486: END IF;
3487:
3488: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,
3489: l_document_id_tmp,

Line 3488: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,

3484: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3485: 'Calling the FND_DOCUMENTS_PKG.Insert_Row');
3486: END IF;
3487:
3488: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,
3489: l_document_id_tmp,
3490: SYSDATE,
3491: Fnd_Global.user_id,
3492: SYSDATE,

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

Line 3885: FROM fnd_documents_tl fdtl,

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,
3887: fnd_attached_documents fad
3888: WHERE fdtl.document_id = fd.document_id
3889: AND fd.document_id = fad.document_id

Line 3886: fnd_documents fd,

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,
3887: fnd_attached_documents fad
3888: WHERE fdtl.document_id = fd.document_id
3889: AND fd.document_id = fad.document_id
3890: AND fd.usage_type = 'O'

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,

Line 3904: FROM fnd_documents_tl fdtl,

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,
3906: fnd_attached_documents fad
3907: WHERE fdtl.document_id = fd.document_id
3908: AND fd.document_id = fad.document_id

Line 3905: fnd_documents fd,

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,
3906: fnd_attached_documents fad
3907: WHERE fdtl.document_id = fd.document_id
3908: AND fd.document_id = fad.document_id
3909: AND fd.usage_type = 'O'

Line 3913: -- Delete from FND_DOCUMENTS_LONG_RAW table

3909: AND fd.usage_type = 'O'
3910: AND fd.datatype_id = 2
3911: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3912:
3913: -- Delete from FND_DOCUMENTS_LONG_RAW table
3914: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3915: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3916: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3917: 'Deleting from fnd_documents_long_raw');

Line 3917: 'Deleting from fnd_documents_long_raw');

3913: -- Delete from FND_DOCUMENTS_LONG_RAW table
3914: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3915: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3916: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3917: 'Deleting from fnd_documents_long_raw');
3918: END IF;
3919:
3920: DELETE FROM fnd_documents_long_raw
3921: WHERE media_id IN

Line 3920: DELETE FROM fnd_documents_long_raw

3916: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3917: 'Deleting from fnd_documents_long_raw');
3918: END IF;
3919:
3920: DELETE FROM fnd_documents_long_raw
3921: WHERE media_id IN
3922: (SELECT fdtl.media_id
3923: FROM fnd_documents_tl fdtl,
3924: fnd_documents fd,

Line 3923: FROM fnd_documents_tl fdtl,

3919:
3920: DELETE FROM fnd_documents_long_raw
3921: WHERE media_id IN
3922: (SELECT fdtl.media_id
3923: FROM fnd_documents_tl fdtl,
3924: fnd_documents fd,
3925: fnd_attached_documents fad
3926: WHERE fdtl.document_id = fd.document_id
3927: AND fd.document_id = fad.document_id

Line 3924: fnd_documents fd,

3920: DELETE FROM fnd_documents_long_raw
3921: WHERE media_id IN
3922: (SELECT fdtl.media_id
3923: FROM fnd_documents_tl fdtl,
3924: fnd_documents fd,
3925: fnd_attached_documents fad
3926: WHERE fdtl.document_id = fd.document_id
3927: AND fd.document_id = fad.document_id
3928: AND fd.usage_type = 'O'

Line 3943: FROM fnd_documents_tl fdtl,

3939:
3940: DELETE FROM fnd_lobs
3941: WHERE file_id IN
3942: (SELECT fdtl.media_id
3943: FROM fnd_documents_tl fdtl,
3944: fnd_documents fd,
3945: fnd_attached_documents fad
3946: WHERE fdtl.document_id = fd.document_id
3947: AND fd.document_id = fad.document_id

Line 3944: fnd_documents fd,

3940: DELETE FROM fnd_lobs
3941: WHERE file_id IN
3942: (SELECT fdtl.media_id
3943: FROM fnd_documents_tl fdtl,
3944: fnd_documents fd,
3945: fnd_attached_documents fad
3946: WHERE fdtl.document_id = fd.document_id
3947: AND fd.document_id = fad.document_id
3948: AND fd.usage_type = 'O'

Line 3952: -- Delete from FND_DOCUMENTS_TL table

3948: AND fd.usage_type = 'O'
3949: AND fd.datatype_id = 6
3950: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3951:
3952: -- Delete from FND_DOCUMENTS_TL table
3953: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3954: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3955: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3956: 'Deleting from fnd_documents_tl');

Line 3956: 'Deleting from fnd_documents_tl');

3952: -- Delete from FND_DOCUMENTS_TL table
3953: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3954: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3955: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3956: 'Deleting from fnd_documents_tl');
3957: END IF;
3958:
3959: DELETE FROM fnd_documents_tl
3960: WHERE document_id IN

Line 3959: DELETE FROM fnd_documents_tl

3955: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3956: 'Deleting from fnd_documents_tl');
3957: END IF;
3958:
3959: DELETE FROM fnd_documents_tl
3960: WHERE document_id IN
3961: (SELECT fad.document_id
3962: FROM fnd_attached_documents fad, fnd_documents fd
3963: WHERE fad.document_id = fd.document_id

Line 3962: FROM fnd_attached_documents fad, fnd_documents fd

3958:
3959: DELETE FROM fnd_documents_tl
3960: WHERE document_id IN
3961: (SELECT fad.document_id
3962: FROM fnd_attached_documents fad, fnd_documents fd
3963: WHERE fad.document_id = fd.document_id
3964: AND fd.usage_type = 'O'
3965: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3966:

Line 3967: -- Delete from FND_DOCUMENTS table

3963: WHERE fad.document_id = fd.document_id
3964: AND fd.usage_type = 'O'
3965: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3966:
3967: -- Delete from FND_DOCUMENTS table
3968: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3969: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3970: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3971: 'Deleting from fnd_documents');

Line 3971: 'Deleting from fnd_documents');

3967: -- Delete from FND_DOCUMENTS table
3968: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3969: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3970: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3971: 'Deleting from fnd_documents');
3972: END IF;
3973:
3974: DELETE FROM fnd_documents
3975: WHERE usage_type = 'O'

Line 3974: DELETE FROM fnd_documents

3970: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3971: 'Deleting from fnd_documents');
3972: END IF;
3973:
3974: DELETE FROM fnd_documents
3975: WHERE usage_type = 'O'
3976: AND document_id IN
3977: (SELECT document_id
3978: FROM fnd_attached_documents fad