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.PO_NEGOTIATIONS_SV2 dependencies on FND_LOBS

Line 1011: CURSOR fnd_lobs_cur (mid NUMBER) IS

1007: SELECT long_text
1008: FROM fnd_documents_long_text
1009: WHERE media_id = mid;
1010:
1011: CURSOR fnd_lobs_cur (mid NUMBER) IS
1012: SELECT file_id,
1013: file_name,
1014: file_content_type,
1015: upload_date,

Line 1023: FROM fnd_lobs

1019: file_data,
1020: language,
1021: oracle_charset,
1022: file_format
1023: FROM fnd_lobs
1024: WHERE file_id = mid;
1025:
1026: media_id_tmp NUMBER;
1027: document_id_tmp NUMBER;

Line 1031: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;

1027: document_id_tmp NUMBER;
1028: row_id_tmp VARCHAR2(30);
1029: short_text_tmp Fnd_Documents_Short_Text.short_text%type ; /* Bug 4522511 */
1030: long_text_tmp clob;
1031: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
1032: x_category_id_tmp fnd_documents.category_id%TYPE;
1033: x_language_temp fnd_documents_tl.language%TYPE;
1034: x_progress varchar2(4);
1035:

Line 1178: OPEN fnd_lobs_cur(docrec.media_id);

1174:
1175: ELSIF (docrec.datatype_id=6) THEN
1176:
1177: x_progress :='007';
1178: OPEN fnd_lobs_cur(docrec.media_id);
1179: FETCH fnd_lobs_cur
1180: INTO fnd_lobs_rec.file_id,
1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,

Line 1179: FETCH fnd_lobs_cur

1175: ELSIF (docrec.datatype_id=6) THEN
1176:
1177: x_progress :='007';
1178: OPEN fnd_lobs_cur(docrec.media_id);
1179: FETCH fnd_lobs_cur
1180: INTO fnd_lobs_rec.file_id,
1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,

Line 1180: INTO fnd_lobs_rec.file_id,

1176:
1177: x_progress :='007';
1178: OPEN fnd_lobs_cur(docrec.media_id);
1179: FETCH fnd_lobs_cur
1180: INTO fnd_lobs_rec.file_id,
1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,

Line 1181: fnd_lobs_rec.file_name,

1177: x_progress :='007';
1178: OPEN fnd_lobs_cur(docrec.media_id);
1179: FETCH fnd_lobs_cur
1180: INTO fnd_lobs_rec.file_id,
1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,

Line 1182: fnd_lobs_rec.file_content_type,

1178: OPEN fnd_lobs_cur(docrec.media_id);
1179: FETCH fnd_lobs_cur
1180: INTO fnd_lobs_rec.file_id,
1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,

Line 1183: fnd_lobs_rec.upload_date,

1179: FETCH fnd_lobs_cur
1180: INTO fnd_lobs_rec.file_id,
1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,

Line 1184: fnd_lobs_rec.expiration_date,

1180: INTO fnd_lobs_rec.file_id,
1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,

Line 1185: fnd_lobs_rec.program_name,

1181: fnd_lobs_rec.file_name,
1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,
1189: fnd_lobs_rec.oracle_charset,

Line 1186: fnd_lobs_rec.program_tag,

1182: fnd_lobs_rec.file_content_type,
1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,
1189: fnd_lobs_rec.oracle_charset,
1190: fnd_lobs_rec.file_format;

Line 1187: fnd_lobs_rec.file_data,

1183: fnd_lobs_rec.upload_date,
1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,
1189: fnd_lobs_rec.oracle_charset,
1190: fnd_lobs_rec.file_format;
1191: CLOSE fnd_lobs_cur;

Line 1188: fnd_lobs_rec.language,

1184: fnd_lobs_rec.expiration_date,
1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,
1189: fnd_lobs_rec.oracle_charset,
1190: fnd_lobs_rec.file_format;
1191: CLOSE fnd_lobs_cur;
1192:

Line 1189: fnd_lobs_rec.oracle_charset,

1185: fnd_lobs_rec.program_name,
1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,
1189: fnd_lobs_rec.oracle_charset,
1190: fnd_lobs_rec.file_format;
1191: CLOSE fnd_lobs_cur;
1192:
1193: x_progress :='008';

Line 1190: fnd_lobs_rec.file_format;

1186: fnd_lobs_rec.program_tag,
1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,
1189: fnd_lobs_rec.oracle_charset,
1190: fnd_lobs_rec.file_format;
1191: CLOSE fnd_lobs_cur;
1192:
1193: x_progress :='008';
1194: INSERT INTO fnd_lobs (

Line 1191: CLOSE fnd_lobs_cur;

1187: fnd_lobs_rec.file_data,
1188: fnd_lobs_rec.language,
1189: fnd_lobs_rec.oracle_charset,
1190: fnd_lobs_rec.file_format;
1191: CLOSE fnd_lobs_cur;
1192:
1193: x_progress :='008';
1194: INSERT INTO fnd_lobs (
1195: file_id,

Line 1194: INSERT INTO fnd_lobs (

1190: fnd_lobs_rec.file_format;
1191: CLOSE fnd_lobs_cur;
1192:
1193: x_progress :='008';
1194: INSERT INTO fnd_lobs (
1195: file_id,
1196: file_name,
1197: file_content_type,
1198: upload_date,

Line 1208: fnd_lobs_rec.file_name,

1204: oracle_charset,
1205: file_format)
1206: VALUES (
1207: media_id_tmp,
1208: fnd_lobs_rec.file_name,
1209: fnd_lobs_rec.file_content_type,
1210: fnd_lobs_rec.upload_date,
1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,

Line 1209: fnd_lobs_rec.file_content_type,

1205: file_format)
1206: VALUES (
1207: media_id_tmp,
1208: fnd_lobs_rec.file_name,
1209: fnd_lobs_rec.file_content_type,
1210: fnd_lobs_rec.upload_date,
1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,

Line 1210: fnd_lobs_rec.upload_date,

1206: VALUES (
1207: media_id_tmp,
1208: fnd_lobs_rec.file_name,
1209: fnd_lobs_rec.file_content_type,
1210: fnd_lobs_rec.upload_date,
1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,

Line 1211: fnd_lobs_rec.expiration_date,

1207: media_id_tmp,
1208: fnd_lobs_rec.file_name,
1209: fnd_lobs_rec.file_content_type,
1210: fnd_lobs_rec.upload_date,
1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,
1215: fnd_lobs_rec.language,

Line 1212: fnd_lobs_rec.program_name,

1208: fnd_lobs_rec.file_name,
1209: fnd_lobs_rec.file_content_type,
1210: fnd_lobs_rec.upload_date,
1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,
1215: fnd_lobs_rec.language,
1216: fnd_lobs_rec.oracle_charset,

Line 1213: fnd_lobs_rec.program_tag,

1209: fnd_lobs_rec.file_content_type,
1210: fnd_lobs_rec.upload_date,
1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,
1215: fnd_lobs_rec.language,
1216: fnd_lobs_rec.oracle_charset,
1217: fnd_lobs_rec.file_format);

Line 1214: fnd_lobs_rec.file_data,

1210: fnd_lobs_rec.upload_date,
1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,
1215: fnd_lobs_rec.language,
1216: fnd_lobs_rec.oracle_charset,
1217: fnd_lobs_rec.file_format);
1218:

Line 1215: fnd_lobs_rec.language,

1211: fnd_lobs_rec.expiration_date,
1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,
1215: fnd_lobs_rec.language,
1216: fnd_lobs_rec.oracle_charset,
1217: fnd_lobs_rec.file_format);
1218:
1219: media_id_tmp := '';

Line 1216: fnd_lobs_rec.oracle_charset,

1212: fnd_lobs_rec.program_name,
1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,
1215: fnd_lobs_rec.language,
1216: fnd_lobs_rec.oracle_charset,
1217: fnd_lobs_rec.file_format);
1218:
1219: media_id_tmp := '';
1220:

Line 1217: fnd_lobs_rec.file_format);

1213: fnd_lobs_rec.program_tag,
1214: fnd_lobs_rec.file_data,
1215: fnd_lobs_rec.language,
1216: fnd_lobs_rec.oracle_charset,
1217: fnd_lobs_rec.file_format);
1218:
1219: media_id_tmp := '';
1220:
1221: END IF; -- end of duplicating text

Line 1288: CLOSE fnd_lobs_cur;

1284: EXCEPTION WHEN OTHERS THEN
1285:
1286: CLOSE shorttext;
1287: CLOSE longtext;
1288: CLOSE fnd_lobs_cur;
1289: po_message_s.sql_error('copy_attachments',x_progress, sqlcode);
1290: raise;
1291: END copy_attachments;
1292:

Line 1733: -- FND_DOCUMENTS, FND_LOBS, FND_ATTACHED_DOCUMENTS

1729: --Name: convert_text_to_attach_clob
1730: --Pre-reqs:
1731: -- None.
1732: --Modifies:
1733: -- FND_DOCUMENTS, FND_LOBS, FND_ATTACHED_DOCUMENTS
1734: --Locks:
1735: -- None.
1736: --Function:
1737: -- Converts a CLOB to an Attachment.

Line 1818: -- Insert into FND_LOBS ------------------------------------

1814: , x_description => p_description
1815: , x_media_id => l_media_id -- IN/OUT
1816: , x_file_name => l_file_name
1817: );
1818: -- Insert into FND_LOBS ------------------------------------
1819: DBMS_LOB.CREATETEMPORARY(l_blob_text,true);
1820: DBMS_LOB.CONVERTTOBLOB(l_blob_text,p_clob_text,DBMS_LOB.LOBMAXSIZE,l_dest_offset,l_source_offset,DBMS_LOB.DEFAULT_CSID,l_lang_context,l_warning);
1821: INSERT INTO fnd_lobs(file_id,
1822: file_name,

Line 1821: INSERT INTO fnd_lobs(file_id,

1817: );
1818: -- Insert into FND_LOBS ------------------------------------
1819: DBMS_LOB.CREATETEMPORARY(l_blob_text,true);
1820: DBMS_LOB.CONVERTTOBLOB(l_blob_text,p_clob_text,DBMS_LOB.LOBMAXSIZE,l_dest_offset,l_source_offset,DBMS_LOB.DEFAULT_CSID,l_lang_context,l_warning);
1821: INSERT INTO fnd_lobs(file_id,
1822: file_name,
1823: file_content_type,
1824: file_data,
1825: upload_date,