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 3049: CURSOR fnd_lobs_cur (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,
3051: file_name,
3052: file_content_type,
3053: upload_date,

Line 3061: FROM fnd_lobs

3057: file_data,
3058: LANGUAGE,
3059: oracle_charset,
3060: file_format
3061: FROM fnd_lobs
3062: WHERE file_id = mid;
3063:
3064: l_media_id_tmp NUMBER;
3065: l_document_id_tmp NUMBER;

Line 3069: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;

3065: l_document_id_tmp NUMBER;
3066: l_row_id_tmp VARCHAR2(30);
3067: l_short_text_tmp VARCHAR2(2000);
3068: l_long_text_tmp LONG;
3069: l_fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
3070: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Attachments';
3071: l_api_version CONSTANT NUMBER := 1.0;
3072: l_debug_level NUMBER := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
3073: l_procedure_level NUMBER := Fnd_Log.LEVEL_PROCEDURE;

Line 3224: -- into fnd_lobs_cur.

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

Line 3275: OPEN fnd_lobs_cur(docrec.media_id);

3271: l_media_id_tmp := '';
3272:
3273: ELSIF (docrec.datatype_id=6) THEN
3274:
3275: OPEN fnd_lobs_cur(docrec.media_id);
3276: FETCH fnd_lobs_cur
3277: INTO l_fnd_lobs_rec.file_id,
3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,

Line 3276: FETCH fnd_lobs_cur

3272:
3273: ELSIF (docrec.datatype_id=6) THEN
3274:
3275: OPEN fnd_lobs_cur(docrec.media_id);
3276: FETCH fnd_lobs_cur
3277: INTO l_fnd_lobs_rec.file_id,
3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,

Line 3277: INTO l_fnd_lobs_rec.file_id,

3273: ELSIF (docrec.datatype_id=6) THEN
3274:
3275: OPEN fnd_lobs_cur(docrec.media_id);
3276: FETCH fnd_lobs_cur
3277: INTO l_fnd_lobs_rec.file_id,
3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,

Line 3278: l_fnd_lobs_rec.file_name,

3274:
3275: OPEN fnd_lobs_cur(docrec.media_id);
3276: FETCH fnd_lobs_cur
3277: INTO l_fnd_lobs_rec.file_id,
3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,

Line 3279: l_fnd_lobs_rec.file_content_type,

3275: OPEN fnd_lobs_cur(docrec.media_id);
3276: FETCH fnd_lobs_cur
3277: INTO l_fnd_lobs_rec.file_id,
3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,

Line 3280: l_fnd_lobs_rec.upload_date,

3276: FETCH fnd_lobs_cur
3277: INTO l_fnd_lobs_rec.file_id,
3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,

Line 3281: l_fnd_lobs_rec.expiration_date,

3277: INTO l_fnd_lobs_rec.file_id,
3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,

Line 3282: l_fnd_lobs_rec.program_name,

3278: l_fnd_lobs_rec.file_name,
3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,
3286: l_fnd_lobs_rec.oracle_charset,

Line 3283: l_fnd_lobs_rec.program_tag,

3279: l_fnd_lobs_rec.file_content_type,
3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,
3286: l_fnd_lobs_rec.oracle_charset,
3287: l_fnd_lobs_rec.file_format;

Line 3284: l_fnd_lobs_rec.file_data,

3280: l_fnd_lobs_rec.upload_date,
3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,
3286: l_fnd_lobs_rec.oracle_charset,
3287: l_fnd_lobs_rec.file_format;
3288: CLOSE fnd_lobs_cur;

Line 3285: l_fnd_lobs_rec.LANGUAGE,

3281: l_fnd_lobs_rec.expiration_date,
3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,
3286: l_fnd_lobs_rec.oracle_charset,
3287: l_fnd_lobs_rec.file_format;
3288: CLOSE fnd_lobs_cur;
3289:

Line 3286: l_fnd_lobs_rec.oracle_charset,

3282: l_fnd_lobs_rec.program_name,
3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,
3286: l_fnd_lobs_rec.oracle_charset,
3287: l_fnd_lobs_rec.file_format;
3288: CLOSE fnd_lobs_cur;
3289:
3290: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN

Line 3287: l_fnd_lobs_rec.file_format;

3283: l_fnd_lobs_rec.program_tag,
3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,
3286: l_fnd_lobs_rec.oracle_charset,
3287: l_fnd_lobs_rec.file_format;
3288: CLOSE fnd_lobs_cur;
3289:
3290: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3291: Fnd_Log.STRING(Fnd_Log.Level_Statement,

Line 3288: CLOSE fnd_lobs_cur;

3284: l_fnd_lobs_rec.file_data,
3285: l_fnd_lobs_rec.LANGUAGE,
3286: l_fnd_lobs_rec.oracle_charset,
3287: l_fnd_lobs_rec.file_format;
3288: CLOSE fnd_lobs_cur;
3289:
3290: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3292: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',

Line 3293: 'Inserting into fnd_lobs for

3289:
3290: IF ( Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3292: 'CSD.PLSQL.csd_repairs_pvt.copy_attachments',
3293: 'Inserting into fnd_lobs for
3294: document id = '||docrec.document_id);
3295: END IF;
3296:
3297: INSERT INTO fnd_lobs (

Line 3297: INSERT INTO fnd_lobs (

3293: 'Inserting into fnd_lobs for
3294: document id = '||docrec.document_id);
3295: END IF;
3296:
3297: INSERT INTO fnd_lobs (
3298: file_id,
3299: file_name,
3300: file_content_type,
3301: upload_date,

Line 3311: l_fnd_lobs_rec.file_name,

3307: oracle_charset,
3308: file_format)
3309: VALUES (
3310: l_media_id_tmp,
3311: l_fnd_lobs_rec.file_name,
3312: l_fnd_lobs_rec.file_content_type,
3313: l_fnd_lobs_rec.upload_date,
3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,

Line 3312: l_fnd_lobs_rec.file_content_type,

3308: file_format)
3309: VALUES (
3310: l_media_id_tmp,
3311: l_fnd_lobs_rec.file_name,
3312: l_fnd_lobs_rec.file_content_type,
3313: l_fnd_lobs_rec.upload_date,
3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,

Line 3313: l_fnd_lobs_rec.upload_date,

3309: VALUES (
3310: l_media_id_tmp,
3311: l_fnd_lobs_rec.file_name,
3312: l_fnd_lobs_rec.file_content_type,
3313: l_fnd_lobs_rec.upload_date,
3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,

Line 3314: l_fnd_lobs_rec.expiration_date,

3310: l_media_id_tmp,
3311: l_fnd_lobs_rec.file_name,
3312: l_fnd_lobs_rec.file_content_type,
3313: l_fnd_lobs_rec.upload_date,
3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,
3318: l_fnd_lobs_rec.LANGUAGE,

Line 3315: l_fnd_lobs_rec.program_name,

3311: l_fnd_lobs_rec.file_name,
3312: l_fnd_lobs_rec.file_content_type,
3313: l_fnd_lobs_rec.upload_date,
3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,
3318: l_fnd_lobs_rec.LANGUAGE,
3319: l_fnd_lobs_rec.oracle_charset,

Line 3316: l_fnd_lobs_rec.program_tag,

3312: l_fnd_lobs_rec.file_content_type,
3313: l_fnd_lobs_rec.upload_date,
3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,
3318: l_fnd_lobs_rec.LANGUAGE,
3319: l_fnd_lobs_rec.oracle_charset,
3320: l_fnd_lobs_rec.file_format);

Line 3317: l_fnd_lobs_rec.file_data,

3313: l_fnd_lobs_rec.upload_date,
3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,
3318: l_fnd_lobs_rec.LANGUAGE,
3319: l_fnd_lobs_rec.oracle_charset,
3320: l_fnd_lobs_rec.file_format);
3321:

Line 3318: l_fnd_lobs_rec.LANGUAGE,

3314: l_fnd_lobs_rec.expiration_date,
3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,
3318: l_fnd_lobs_rec.LANGUAGE,
3319: l_fnd_lobs_rec.oracle_charset,
3320: l_fnd_lobs_rec.file_format);
3321:
3322: l_media_id_tmp := '';

Line 3319: l_fnd_lobs_rec.oracle_charset,

3315: l_fnd_lobs_rec.program_name,
3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,
3318: l_fnd_lobs_rec.LANGUAGE,
3319: l_fnd_lobs_rec.oracle_charset,
3320: l_fnd_lobs_rec.file_format);
3321:
3322: l_media_id_tmp := '';
3323:

Line 3320: l_fnd_lobs_rec.file_format);

3316: l_fnd_lobs_rec.program_tag,
3317: l_fnd_lobs_rec.file_data,
3318: l_fnd_lobs_rec.LANGUAGE,
3319: l_fnd_lobs_rec.oracle_charset,
3320: l_fnd_lobs_rec.file_format);
3321:
3322: l_media_id_tmp := '';
3323:
3324: END IF; -- end of duplicating text

Line 3410: IF (fnd_lobs_cur%ISOPEN) THEN

3406: IF (longtext%ISOPEN) THEN
3407: CLOSE longtext;
3408: END IF;
3409:
3410: IF (fnd_lobs_cur%ISOPEN) THEN
3411: CLOSE fnd_lobs_cur;
3412: END IF;
3413:
3414: -- Api body ends here

Line 3411: CLOSE fnd_lobs_cur;

3407: CLOSE longtext;
3408: END IF;
3409:
3410: IF (fnd_lobs_cur%ISOPEN) THEN
3411: CLOSE fnd_lobs_cur;
3412: END IF;
3413:
3414: -- Api body ends here
3415:

Line 3625: -- Delete from FND_LOBS table

3621: AND fd.datatype_id IN (3,4)
3622: AND fad.pk1_value = TO_CHAR(p_repair_line_id));
3623:
3624:
3625: -- Delete from FND_LOBS table
3626: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3627: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3628: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3629: 'Deleting from fnd_lobs');

Line 3629: 'Deleting from fnd_lobs');

3625: -- Delete from FND_LOBS table
3626: IF(Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level) THEN
3627: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3628: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3629: 'Deleting from fnd_lobs');
3630: END IF;
3631:
3632: DELETE FROM fnd_lobs
3633: WHERE file_id IN

Line 3632: DELETE FROM fnd_lobs

3628: 'CSD.PLSQL.csd_repairs_pvt.delete_attachments',
3629: 'Deleting from fnd_lobs');
3630: END IF;
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,