APPS.PSP_XMLGEN dependencies on FND_LOBS

Line 1185: FROM fnd_lobs fl,

1181: AND ROWNUM = 1;
1182:
1183: CURSOR get_file_id_cur IS
1184: SELECT fl.file_id
1185: FROM fnd_lobs fl,
1186: fnd_attached_documents fad,
1187: fnd_documents_vl fdl
1188: WHERE fad.pk1_value = TO_CHAR(p_wf_item_key)||p_wf_Role_Name
1189: --AND fad.pk3_value = p_wf_role_name

Line 1244: INSERT INTO fnd_lobs

1240: X_description => NULL,
1241: X_file_name => l_pdf_filename,
1242: X_media_id => l_pdf_file_id);
1243:
1244: INSERT INTO fnd_lobs
1245: (file_id, File_name, file_content_type,
1246: upload_date, expiration_date, program_name,
1247: program_tag, file_data, language,
1248: oracle_charset, file_format)

Line 1335: l_file_name fnd_lobs.file_name%type; -- Bug 7229792

1331:
1332: l_error_count NUMBER;
1333: l_return_status CHAR(1);
1334: l_rname wf_roles.name%type; -- Bug 7135471
1335: l_file_name fnd_lobs.file_name%type; -- Bug 7229792
1336:
1337: BEGIN
1338: OPEN get_request_id_cur;
1339: FETCH get_request_id_cur INTO l_request_id;

Line 1362: FROM fnd_lobs fl,

1358: SELECT file_data,
1359: file_id -- Bug 7135471
1360: INTO l_document,
1361: l_pdf_file_id -- Bug 7135471
1362: FROM fnd_lobs fl,
1363: fnd_attached_documents fad,
1364: fnd_documents_vl fdl
1365: WHERE fad.pk1_value = l_item_key || l_rname
1366: AND fdl.document_id = fad.document_id

Line 1369: AND fl.file_id = (select max(file_id) FROM fnd_lobs fl, -- Bug 7135471

1365: WHERE fad.pk1_value = l_item_key || l_rname
1366: AND fdl.document_id = fad.document_id
1367: AND fdl.media_id = fl.file_id
1368: AND fad.entity_name = 'ERDETAILS'
1369: AND fl.file_id = (select max(file_id) FROM fnd_lobs fl, -- Bug 7135471
1370: fnd_attached_documents fad,
1371: fnd_documents_vl fdl
1372: WHERE fad.pk1_value = l_item_key || l_rname
1373: AND fdl.document_id = fad.document_id