DBA Data[Home] [Help]

APPS.DOM_ATTACHMENT_UTIL_PKG dependencies on FND_LOBS

Line 708: CURSOR fnd_lobs_cur (mid NUMBER) IS

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,

Line 720: FROM fnd_lobs

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;

Line 729: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;

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:

Line 835: OPEN fnd_lobs_cur(docrec.media_id);

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,

Line 836: FETCH fnd_lobs_cur

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,

Line 837: INTO fnd_lobs_rec.file_id,

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,

Line 838: fnd_lobs_rec.file_name,

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,

Line 839: fnd_lobs_rec.file_content_type,

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,

Line 840: fnd_lobs_rec.upload_date,

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,

Line 841: fnd_lobs_rec.expiration_date,

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,

Line 842: fnd_lobs_rec.program_name,

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,

Line 843: fnd_lobs_rec.program_tag,

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;

Line 844: fnd_lobs_rec.file_data,

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;

Line 845: fnd_lobs_rec.language,

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:

Line 846: fnd_lobs_rec.oracle_charset,

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 (

Line 847: fnd_lobs_rec.file_format;

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,

Line 848: CLOSE fnd_lobs_cur;

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,

Line 850: INSERT INTO fnd_lobs (

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,

Line 864: fnd_lobs_rec.file_name,

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,

Line 865: fnd_lobs_rec.file_content_type,

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,

Line 866: fnd_lobs_rec.upload_date,

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,

Line 867: fnd_lobs_rec.expiration_date,

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,

Line 868: fnd_lobs_rec.program_name,

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,

Line 869: fnd_lobs_rec.program_tag,

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

Line 870: fnd_lobs_rec.file_data,

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:

Line 871: fnd_lobs_rec.language,

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 := '';

Line 872: fnd_lobs_rec.oracle_charset,

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:

Line 873: fnd_lobs_rec.file_format);

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

Line 904: CLOSE fnd_lobs_cur;

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:

Line 1143: CURSOR fnd_lobs_cur (mid NUMBER) IS

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,

Line 1155: FROM fnd_lobs

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;

Line 1164: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;

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

Line 1309: OPEN fnd_lobs_cur(docrec.media_id);

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,

Line 1310: FETCH fnd_lobs_cur

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,

Line 1311: INTO fnd_lobs_rec.file_id,

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,

Line 1312: fnd_lobs_rec.file_name,

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,

Line 1313: fnd_lobs_rec.file_content_type,

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,

Line 1314: fnd_lobs_rec.upload_date,

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,

Line 1315: fnd_lobs_rec.expiration_date,

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,

Line 1316: fnd_lobs_rec.program_name,

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,

Line 1317: fnd_lobs_rec.program_tag,

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;

Line 1318: fnd_lobs_rec.file_data,

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;

Line 1319: fnd_lobs_rec.language,

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 (

Line 1320: fnd_lobs_rec.oracle_charset,

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,

Line 1321: fnd_lobs_rec.file_format;

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,

Line 1322: CLOSE fnd_lobs_cur;

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,

Line 1323: INSERT INTO fnd_lobs (

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,

Line 1337: fnd_lobs_rec.file_name,

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,

Line 1338: fnd_lobs_rec.file_content_type,

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,

Line 1339: fnd_lobs_rec.upload_date,

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,

Line 1340: fnd_lobs_rec.expiration_date,

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,

Line 1341: fnd_lobs_rec.program_name,

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,

Line 1342: fnd_lobs_rec.program_tag,

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

Line 1343: fnd_lobs_rec.file_data,

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:

Line 1344: fnd_lobs_rec.language,

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 := '';

Line 1345: fnd_lobs_rec.oracle_charset,

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

Line 1346: fnd_lobs_rec.file_format);

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:

Line 1437: CLOSE fnd_lobs_cur;

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: