DBA Data[Home] [Help]

APPS.IBC_CITEM_VERSIONS_PKG dependencies on FND_LOBS_S

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