APPS.CSD_REPAIRS_PVT dependencies on FND_DOCUMENTS_TL

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