704: SELECT long_text
705: FROM fnd_documents_long_text
706: WHERE media_id = mid;
707:
708: CURSOR fnd_lobs_cur (mid NUMBER) IS
709: SELECT file_id,
710: file_name,
711: file_content_type,
712: upload_date,
716: file_data,
717: language,
718: oracle_charset,
719: file_format
720: FROM fnd_lobs
721: WHERE file_id = mid;
722:
723: media_id_tmp NUMBER;
724: document_id_tmp NUMBER;
725: row_id_tmp VARCHAR2(30);
726: short_text_tmp VARCHAR2(4000);
727: long_text_tmp LONG;
728: docrec docpk1%ROWTYPE;
729: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
730: BEGIN
731: -- Use cursor loop to get all attachments associated with
732:
733:
831: media_id_tmp := '';
832:
833: ELSIF (docrec.datatype_id=6) THEN
834:
835: OPEN fnd_lobs_cur(docrec.media_id);
836: FETCH fnd_lobs_cur
837: INTO fnd_lobs_rec.file_id,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
832:
833: ELSIF (docrec.datatype_id=6) THEN
834:
835: OPEN fnd_lobs_cur(docrec.media_id);
836: FETCH fnd_lobs_cur
837: INTO fnd_lobs_rec.file_id,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
833: ELSIF (docrec.datatype_id=6) THEN
834:
835: OPEN fnd_lobs_cur(docrec.media_id);
836: FETCH fnd_lobs_cur
837: INTO fnd_lobs_rec.file_id,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
834:
835: OPEN fnd_lobs_cur(docrec.media_id);
836: FETCH fnd_lobs_cur
837: INTO fnd_lobs_rec.file_id,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
835: OPEN fnd_lobs_cur(docrec.media_id);
836: FETCH fnd_lobs_cur
837: INTO fnd_lobs_rec.file_id,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
836: FETCH fnd_lobs_cur
837: INTO fnd_lobs_rec.file_id,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
837: INTO fnd_lobs_rec.file_id,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
838: fnd_lobs_rec.file_name,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
846: fnd_lobs_rec.oracle_charset,
839: fnd_lobs_rec.file_content_type,
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
846: fnd_lobs_rec.oracle_charset,
847: fnd_lobs_rec.file_format;
840: fnd_lobs_rec.upload_date,
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
846: fnd_lobs_rec.oracle_charset,
847: fnd_lobs_rec.file_format;
848: CLOSE fnd_lobs_cur;
841: fnd_lobs_rec.expiration_date,
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
846: fnd_lobs_rec.oracle_charset,
847: fnd_lobs_rec.file_format;
848: CLOSE fnd_lobs_cur;
849:
842: fnd_lobs_rec.program_name,
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
846: fnd_lobs_rec.oracle_charset,
847: fnd_lobs_rec.file_format;
848: CLOSE fnd_lobs_cur;
849:
850: INSERT INTO fnd_lobs (
843: fnd_lobs_rec.program_tag,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
846: fnd_lobs_rec.oracle_charset,
847: fnd_lobs_rec.file_format;
848: CLOSE fnd_lobs_cur;
849:
850: INSERT INTO fnd_lobs (
851: file_id,
844: fnd_lobs_rec.file_data,
845: fnd_lobs_rec.language,
846: fnd_lobs_rec.oracle_charset,
847: fnd_lobs_rec.file_format;
848: CLOSE fnd_lobs_cur;
849:
850: INSERT INTO fnd_lobs (
851: file_id,
852: file_name,
846: fnd_lobs_rec.oracle_charset,
847: fnd_lobs_rec.file_format;
848: CLOSE fnd_lobs_cur;
849:
850: INSERT INTO fnd_lobs (
851: file_id,
852: file_name,
853: file_content_type,
854: upload_date,
860: oracle_charset,
861: file_format)
862: VALUES (
863: media_id_tmp,
864: fnd_lobs_rec.file_name,
865: fnd_lobs_rec.file_content_type,
866: fnd_lobs_rec.upload_date,
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
861: file_format)
862: VALUES (
863: media_id_tmp,
864: fnd_lobs_rec.file_name,
865: fnd_lobs_rec.file_content_type,
866: fnd_lobs_rec.upload_date,
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
862: VALUES (
863: media_id_tmp,
864: fnd_lobs_rec.file_name,
865: fnd_lobs_rec.file_content_type,
866: fnd_lobs_rec.upload_date,
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
863: media_id_tmp,
864: fnd_lobs_rec.file_name,
865: fnd_lobs_rec.file_content_type,
866: fnd_lobs_rec.upload_date,
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
871: fnd_lobs_rec.language,
864: fnd_lobs_rec.file_name,
865: fnd_lobs_rec.file_content_type,
866: fnd_lobs_rec.upload_date,
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
871: fnd_lobs_rec.language,
872: fnd_lobs_rec.oracle_charset,
865: fnd_lobs_rec.file_content_type,
866: fnd_lobs_rec.upload_date,
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
871: fnd_lobs_rec.language,
872: fnd_lobs_rec.oracle_charset,
873: fnd_lobs_rec.file_format);
866: fnd_lobs_rec.upload_date,
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
871: fnd_lobs_rec.language,
872: fnd_lobs_rec.oracle_charset,
873: fnd_lobs_rec.file_format);
874:
867: fnd_lobs_rec.expiration_date,
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
871: fnd_lobs_rec.language,
872: fnd_lobs_rec.oracle_charset,
873: fnd_lobs_rec.file_format);
874:
875: media_id_tmp := '';
868: fnd_lobs_rec.program_name,
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
871: fnd_lobs_rec.language,
872: fnd_lobs_rec.oracle_charset,
873: fnd_lobs_rec.file_format);
874:
875: media_id_tmp := '';
876:
869: fnd_lobs_rec.program_tag,
870: fnd_lobs_rec.file_data,
871: fnd_lobs_rec.language,
872: fnd_lobs_rec.oracle_charset,
873: fnd_lobs_rec.file_format);
874:
875: media_id_tmp := '';
876:
877: END IF; -- end of duplicating text
900: -- need to close all cursors
901: CLOSE docpk1;
902: CLOSE shorttext;
903: CLOSE longtext;
904: CLOSE fnd_lobs_cur;
905:
906: END copy_documents ;
907:
908:
1139: SELECT long_text
1140: FROM fnd_documents_long_text
1141: WHERE media_id = mid;
1142:
1143: CURSOR fnd_lobs_cur (mid NUMBER) IS
1144: SELECT file_id,
1145: file_name,
1146: file_content_type,
1147: upload_date,
1151: file_data,
1152: language,
1153: oracle_charset,
1154: file_format
1155: FROM fnd_lobs
1156: WHERE file_id = mid;
1157:
1158: media_id_tmp NUMBER;
1159: document_id_tmp NUMBER;
1160: row_id_tmp VARCHAR2(30);
1161: short_text_tmp VARCHAR2(4000);
1162: long_text_tmp LONG;
1163: docrec doclist%ROWTYPE;
1164: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
1165: l_to_attachment_id NUMBER;
1166: l_something VARCHAR2(2000);
1167: BEGIN
1168: -- Use cursor loop to get all attachments associated with
1305: long_text_tmp);
1306: media_id_tmp := '';
1307: ELSIF (docrec.datatype_id=6) THEN
1308:
1309: OPEN fnd_lobs_cur(docrec.media_id);
1310: FETCH fnd_lobs_cur
1311: INTO fnd_lobs_rec.file_id,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1306: media_id_tmp := '';
1307: ELSIF (docrec.datatype_id=6) THEN
1308:
1309: OPEN fnd_lobs_cur(docrec.media_id);
1310: FETCH fnd_lobs_cur
1311: INTO fnd_lobs_rec.file_id,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1307: ELSIF (docrec.datatype_id=6) THEN
1308:
1309: OPEN fnd_lobs_cur(docrec.media_id);
1310: FETCH fnd_lobs_cur
1311: INTO fnd_lobs_rec.file_id,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1308:
1309: OPEN fnd_lobs_cur(docrec.media_id);
1310: FETCH fnd_lobs_cur
1311: INTO fnd_lobs_rec.file_id,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1309: OPEN fnd_lobs_cur(docrec.media_id);
1310: FETCH fnd_lobs_cur
1311: INTO fnd_lobs_rec.file_id,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1310: FETCH fnd_lobs_cur
1311: INTO fnd_lobs_rec.file_id,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1311: INTO fnd_lobs_rec.file_id,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1312: fnd_lobs_rec.file_name,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1313: fnd_lobs_rec.file_content_type,
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1321: fnd_lobs_rec.file_format;
1314: fnd_lobs_rec.upload_date,
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1321: fnd_lobs_rec.file_format;
1322: CLOSE fnd_lobs_cur;
1315: fnd_lobs_rec.expiration_date,
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1321: fnd_lobs_rec.file_format;
1322: CLOSE fnd_lobs_cur;
1323: INSERT INTO fnd_lobs (
1316: fnd_lobs_rec.program_name,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1321: fnd_lobs_rec.file_format;
1322: CLOSE fnd_lobs_cur;
1323: INSERT INTO fnd_lobs (
1324: file_id,
1317: fnd_lobs_rec.program_tag,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1321: fnd_lobs_rec.file_format;
1322: CLOSE fnd_lobs_cur;
1323: INSERT INTO fnd_lobs (
1324: file_id,
1325: file_name,
1318: fnd_lobs_rec.file_data,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1321: fnd_lobs_rec.file_format;
1322: CLOSE fnd_lobs_cur;
1323: INSERT INTO fnd_lobs (
1324: file_id,
1325: file_name,
1326: file_content_type,
1319: fnd_lobs_rec.language,
1320: fnd_lobs_rec.oracle_charset,
1321: fnd_lobs_rec.file_format;
1322: CLOSE fnd_lobs_cur;
1323: INSERT INTO fnd_lobs (
1324: file_id,
1325: file_name,
1326: file_content_type,
1327: upload_date,
1333: oracle_charset,
1334: file_format)
1335: VALUES (
1336: media_id_tmp,
1337: fnd_lobs_rec.file_name,
1338: fnd_lobs_rec.file_content_type,
1339: fnd_lobs_rec.upload_date,
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1334: file_format)
1335: VALUES (
1336: media_id_tmp,
1337: fnd_lobs_rec.file_name,
1338: fnd_lobs_rec.file_content_type,
1339: fnd_lobs_rec.upload_date,
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1335: VALUES (
1336: media_id_tmp,
1337: fnd_lobs_rec.file_name,
1338: fnd_lobs_rec.file_content_type,
1339: fnd_lobs_rec.upload_date,
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1336: media_id_tmp,
1337: fnd_lobs_rec.file_name,
1338: fnd_lobs_rec.file_content_type,
1339: fnd_lobs_rec.upload_date,
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1344: fnd_lobs_rec.language,
1337: fnd_lobs_rec.file_name,
1338: fnd_lobs_rec.file_content_type,
1339: fnd_lobs_rec.upload_date,
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1344: fnd_lobs_rec.language,
1345: fnd_lobs_rec.oracle_charset,
1338: fnd_lobs_rec.file_content_type,
1339: fnd_lobs_rec.upload_date,
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1344: fnd_lobs_rec.language,
1345: fnd_lobs_rec.oracle_charset,
1346: fnd_lobs_rec.file_format);
1339: fnd_lobs_rec.upload_date,
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1344: fnd_lobs_rec.language,
1345: fnd_lobs_rec.oracle_charset,
1346: fnd_lobs_rec.file_format);
1347:
1340: fnd_lobs_rec.expiration_date,
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1344: fnd_lobs_rec.language,
1345: fnd_lobs_rec.oracle_charset,
1346: fnd_lobs_rec.file_format);
1347:
1348: media_id_tmp := '';
1341: fnd_lobs_rec.program_name,
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1344: fnd_lobs_rec.language,
1345: fnd_lobs_rec.oracle_charset,
1346: fnd_lobs_rec.file_format);
1347:
1348: media_id_tmp := '';
1349: END IF; -- end of duplicating text
1342: fnd_lobs_rec.program_tag,
1343: fnd_lobs_rec.file_data,
1344: fnd_lobs_rec.language,
1345: fnd_lobs_rec.oracle_charset,
1346: fnd_lobs_rec.file_format);
1347:
1348: media_id_tmp := '';
1349: END IF; -- end of duplicating text
1350:
1433: CLOSE docpk3;
1434: CLOSE doclist;
1435: CLOSE shorttext;
1436: CLOSE longtext;
1437: CLOSE fnd_lobs_cur;
1438:
1439: END copy_attachments_fnd;
1440:
1441: