APPS.IBC_CITEM_VERSIONS_PKG dependencies on FND_LOBS

Line 1266: INSERT INTO fnd_lobs (file_id

1262: OPEN trans_ver_cur(p_citem_version_id,p_base_lang);
1263: LOOP
1264: FETCH trans_ver_cur INTO trans_ver_rec;
1265: EXIT WHEN trans_ver_cur%NOTFOUND;
1266: INSERT INTO fnd_lobs (file_id
1267: ,file_name
1268: ,file_content_type
1269: ,file_data
1270: ,upload_date

Line 1277: SELECT fnd_lobs_s.nextval

1273: ,program_tag
1274: ,oracle_charset
1275: ,file_format
1276: )
1277: SELECT fnd_lobs_s.nextval
1278: ,file_name
1279: ,file_content_type
1280: ,file_data
1281: ,upload_date

Line 1287: FROM fnd_lobs

1283: ,program_name
1284: ,program_tag
1285: ,oracle_charset
1286: ,file_format
1287: FROM fnd_lobs
1288: WHERE file_id = trans_ver_rec.attachment_file_id;
1289:
1290: -- Update the file_id in ibc_citem_versions_tl
1291: UPDATE ibc_citem_versions_tl

Line 1292: SET attachment_file_id = fnd_lobs_s.currval

1288: WHERE file_id = trans_ver_rec.attachment_file_id;
1289:
1290: -- Update the file_id in ibc_citem_versions_tl
1291: UPDATE ibc_citem_versions_tl
1292: SET attachment_file_id = fnd_lobs_s.currval
1293: WHERE citem_version_id = trans_ver_rec.citem_version_id
1294: AND language = trans_ver_rec.language;
1295: END LOOP;
1296: CLOSE trans_ver_cur;

Line 1342: INSERT INTO fnd_lobs (file_id

1338: OPEN trans_ver_cur(p_citem_version_id,p_base_lang);
1339: LOOP
1340: FETCH trans_ver_cur INTO trans_ver_rec;
1341: EXIT WHEN trans_ver_cur%NOTFOUND;
1342: INSERT INTO fnd_lobs (file_id
1343: ,file_name
1344: ,file_content_type
1345: ,file_data
1346: ,upload_date

Line 1353: SELECT fnd_lobs_s.NEXTVAL

1349: ,program_tag
1350: ,oracle_charset
1351: ,file_format
1352: )
1353: SELECT fnd_lobs_s.NEXTVAL
1354: ,file_name
1355: ,file_content_type
1356: ,file_data
1357: ,upload_date

Line 1363: FROM fnd_lobs

1359: ,program_name
1360: ,program_tag
1361: ,oracle_charset
1362: ,file_format
1363: FROM fnd_lobs
1364: WHERE file_id = trans_ver_rec.attachment_file_id;
1365:
1366: -- Update the file_id in ibc_citem_versions_tl
1367: UPDATE ibc_citem_versions_tl

Line 1368: SET attachment_file_id = fnd_lobs_s.CURRVAL

1364: WHERE file_id = trans_ver_rec.attachment_file_id;
1365:
1366: -- Update the file_id in ibc_citem_versions_tl
1367: UPDATE ibc_citem_versions_tl
1368: SET attachment_file_id = fnd_lobs_s.CURRVAL
1369: WHERE citem_version_id = trans_ver_rec.citem_version_id
1370: AND LANGUAGE = trans_ver_rec.LANGUAGE;
1371: END LOOP;
1372: CLOSE trans_ver_cur;