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_LOBS

Line 3357: CURSOR fnd_lobs_cur (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,
3359: file_name,
3360: file_content_type,
3361: upload_date,

Line 3369: FROM fnd_lobs

3365: file_data,
3366: LANGUAGE,
3367: oracle_charset,
3368: file_format
3369: FROM fnd_lobs
3370: WHERE file_id = mid;
3371:
3372: l_media_id_tmp NUMBER;
3373: l_document_id_tmp NUMBER;

Line 3377: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;

3373: l_document_id_tmp NUMBER;
3374: l_row_id_tmp VARCHAR2(30);
3375: l_short_text_tmp VARCHAR2(2000);
3376: l_long_text_tmp LONG;
3377: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
3378: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3379: l_api_version CONSTANT NUMBER := 1.0;
3380: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3381: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

Line 3532: -- into fnd_lobs_cur.

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
3535: IF (docrec.datatype_id = 1) THEN
3536: -- Handle short Text

Line 3583: OPEN fnd_lobs_cur(docrec.media_id);

3579: l_media_id_tmp := '';
3580:
3581: ELSIF (docrec.datatype_id=6) THEN
3582:
3583: OPEN fnd_lobs_cur(docrec.media_id);
3584: FETCH fnd_lobs_cur
3585: INTO l_fnd_lobs_rec.file_id,
3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,

Line 3584: FETCH fnd_lobs_cur

3580:
3581: ELSIF (docrec.datatype_id=6) THEN
3582:
3583: OPEN fnd_lobs_cur(docrec.media_id);
3584: FETCH fnd_lobs_cur
3585: INTO l_fnd_lobs_rec.file_id,
3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,

Line 3585: INTO l_fnd_lobs_rec.file_id,

3581: ELSIF (docrec.datatype_id=6) THEN
3582:
3583: OPEN fnd_lobs_cur(docrec.media_id);
3584: FETCH fnd_lobs_cur
3585: INTO l_fnd_lobs_rec.file_id,
3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,

Line 3586: l_fnd_lobs_rec.file_name,

3582:
3583: OPEN fnd_lobs_cur(docrec.media_id);
3584: FETCH fnd_lobs_cur
3585: INTO l_fnd_lobs_rec.file_id,
3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,

Line 3587: l_fnd_lobs_rec.file_content_type,

3583: OPEN fnd_lobs_cur(docrec.media_id);
3584: FETCH fnd_lobs_cur
3585: INTO l_fnd_lobs_rec.file_id,
3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,

Line 3588: l_fnd_lobs_rec.upload_date,

3584: FETCH fnd_lobs_cur
3585: INTO l_fnd_lobs_rec.file_id,
3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,

Line 3589: l_fnd_lobs_rec.expiration_date,

3585: INTO l_fnd_lobs_rec.file_id,
3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,

Line 3590: l_fnd_lobs_rec.program_name,

3586: l_fnd_lobs_rec.file_name,
3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,
3594: l_fnd_lobs_rec.oracle_charset,

Line 3591: l_fnd_lobs_rec.program_tag,

3587: l_fnd_lobs_rec.file_content_type,
3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,
3594: l_fnd_lobs_rec.oracle_charset,
3595: l_fnd_lobs_rec.file_format;

Line 3592: l_fnd_lobs_rec.file_data,

3588: l_fnd_lobs_rec.upload_date,
3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,
3594: l_fnd_lobs_rec.oracle_charset,
3595: l_fnd_lobs_rec.file_format;
3596: CLOSE fnd_lobs_cur;

Line 3593: l_fnd_lobs_rec.LANGUAGE,

3589: l_fnd_lobs_rec.expiration_date,
3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,
3594: l_fnd_lobs_rec.oracle_charset,
3595: l_fnd_lobs_rec.file_format;
3596: CLOSE fnd_lobs_cur;
3597:

Line 3594: l_fnd_lobs_rec.oracle_charset,

3590: l_fnd_lobs_rec.program_name,
3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,
3594: l_fnd_lobs_rec.oracle_charset,
3595: l_fnd_lobs_rec.file_format;
3596: CLOSE fnd_lobs_cur;
3597:
3598: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3595: l_fnd_lobs_rec.file_format;

3591: l_fnd_lobs_rec.program_tag,
3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,
3594: l_fnd_lobs_rec.oracle_charset,
3595: l_fnd_lobs_rec.file_format;
3596: CLOSE fnd_lobs_cur;
3597:
3598: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3599: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 3596: CLOSE fnd_lobs_cur;

3592: l_fnd_lobs_rec.file_data,
3593: l_fnd_lobs_rec.LANGUAGE,
3594: l_fnd_lobs_rec.oracle_charset,
3595: l_fnd_lobs_rec.file_format;
3596: CLOSE fnd_lobs_cur;
3597:
3598: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3599: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3600: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

Line 3601: 'Inserting into fnd_lobs for

3597:
3598: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3599: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3600: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3601: 'Inserting into fnd_lobs for
3602: document id = '||docrec.document_id);
3603: END IF;
3604:
3605: INSERT INTO fnd_lobs (

Line 3605: INSERT INTO fnd_lobs (

3601: 'Inserting into fnd_lobs for
3602: document id = '||docrec.document_id);
3603: END IF;
3604:
3605: INSERT INTO fnd_lobs (
3606: file_id,
3607: file_name,
3608: file_content_type,
3609: upload_date,

Line 3619: l_fnd_lobs_rec.file_name,

3615: oracle_charset,
3616: file_format)
3617: VALUES (
3618: l_media_id_tmp,
3619: l_fnd_lobs_rec.file_name,
3620: l_fnd_lobs_rec.file_content_type,
3621: l_fnd_lobs_rec.upload_date,
3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,

Line 3620: l_fnd_lobs_rec.file_content_type,

3616: file_format)
3617: VALUES (
3618: l_media_id_tmp,
3619: l_fnd_lobs_rec.file_name,
3620: l_fnd_lobs_rec.file_content_type,
3621: l_fnd_lobs_rec.upload_date,
3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,

Line 3621: l_fnd_lobs_rec.upload_date,

3617: VALUES (
3618: l_media_id_tmp,
3619: l_fnd_lobs_rec.file_name,
3620: l_fnd_lobs_rec.file_content_type,
3621: l_fnd_lobs_rec.upload_date,
3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,

Line 3622: l_fnd_lobs_rec.expiration_date,

3618: l_media_id_tmp,
3619: l_fnd_lobs_rec.file_name,
3620: l_fnd_lobs_rec.file_content_type,
3621: l_fnd_lobs_rec.upload_date,
3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,
3626: l_fnd_lobs_rec.LANGUAGE,

Line 3623: l_fnd_lobs_rec.program_name,

3619: l_fnd_lobs_rec.file_name,
3620: l_fnd_lobs_rec.file_content_type,
3621: l_fnd_lobs_rec.upload_date,
3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,
3626: l_fnd_lobs_rec.LANGUAGE,
3627: l_fnd_lobs_rec.oracle_charset,

Line 3624: l_fnd_lobs_rec.program_tag,

3620: l_fnd_lobs_rec.file_content_type,
3621: l_fnd_lobs_rec.upload_date,
3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,
3626: l_fnd_lobs_rec.LANGUAGE,
3627: l_fnd_lobs_rec.oracle_charset,
3628: l_fnd_lobs_rec.file_format);

Line 3625: l_fnd_lobs_rec.file_data,

3621: l_fnd_lobs_rec.upload_date,
3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,
3626: l_fnd_lobs_rec.LANGUAGE,
3627: l_fnd_lobs_rec.oracle_charset,
3628: l_fnd_lobs_rec.file_format);
3629:

Line 3626: l_fnd_lobs_rec.LANGUAGE,

3622: l_fnd_lobs_rec.expiration_date,
3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,
3626: l_fnd_lobs_rec.LANGUAGE,
3627: l_fnd_lobs_rec.oracle_charset,
3628: l_fnd_lobs_rec.file_format);
3629:
3630: l_media_id_tmp := '';

Line 3627: l_fnd_lobs_rec.oracle_charset,

3623: l_fnd_lobs_rec.program_name,
3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,
3626: l_fnd_lobs_rec.LANGUAGE,
3627: l_fnd_lobs_rec.oracle_charset,
3628: l_fnd_lobs_rec.file_format);
3629:
3630: l_media_id_tmp := '';
3631:

Line 3628: l_fnd_lobs_rec.file_format);

3624: l_fnd_lobs_rec.program_tag,
3625: l_fnd_lobs_rec.file_data,
3626: l_fnd_lobs_rec.LANGUAGE,
3627: l_fnd_lobs_rec.oracle_charset,
3628: l_fnd_lobs_rec.file_format);
3629:
3630: l_media_id_tmp := '';
3631:
3632: END IF; -- end of duplicating text

Line 3718: IF (fnd_lobs_cur%ISOPEN) THEN

3714: IF (longtext%ISOPEN) THEN
3715: CLOSE longtext;
3716: END IF;
3717:
3718: IF (fnd_lobs_cur%ISOPEN) THEN
3719: CLOSE fnd_lobs_cur;
3720: END IF;
3721:
3722: -- Api body ends here

Line 3719: CLOSE fnd_lobs_cur;

3715: CLOSE longtext;
3716: END IF;
3717:
3718: IF (fnd_lobs_cur%ISOPEN) THEN
3719: CLOSE fnd_lobs_cur;
3720: END IF;
3721:
3722: -- Api body ends here
3723:

Line 3933: -- Delete from FND_LOBS table

3929: AND fd.datatype_id IN (3,4)
3930: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3931:
3932:
3933: -- Delete from FND_LOBS table
3934: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3935: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3936: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3937: 'Deleting from fnd_lobs');

Line 3937: 'Deleting from fnd_lobs');

3933: -- Delete from FND_LOBS table
3934: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3935: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3936: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3937: 'Deleting from fnd_lobs');
3938: END IF;
3939:
3940: DELETE FROM fnd_lobs
3941: WHERE file_id IN

Line 3940: DELETE FROM fnd_lobs

3936: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3937: 'Deleting from fnd_lobs');
3938: END IF;
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,