APPS.PSP_XMLGEN dependencies on FND_LOBS

Line 1179: FROM fnd_lobs fl,

1175: AND ROWNUM = 1;
1176:
1177: CURSOR get_file_id_cur IS
1178: SELECT fl.file_id
1179: FROM fnd_lobs fl,
1180: fnd_attached_documents fad,
1181: fnd_documents_vl fdl
1182: WHERE fad.pk1_value = TO_CHAR(p_wf_item_key)||p_wf_Role_Name
1183: --AND fad.pk3_value = p_wf_role_name

Line 1238: INSERT INTO fnd_lobs

1234: X_description => NULL,
1235: X_file_name => l_pdf_filename,
1236: X_media_id => l_pdf_file_id);
1237:
1238: INSERT INTO fnd_lobs
1239: (file_id, File_name, file_content_type,
1240: upload_date, expiration_date, program_name,
1241: program_tag, file_data, language,
1242: oracle_charset, file_format)

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

1323:
1324: l_error_count NUMBER;
1325: l_return_status CHAR(1);
1326: l_rname wf_roles.name%type; -- Bug 7135471
1327: l_file_name fnd_lobs.file_name%type; -- Bug 7229792
1328:
1329: BEGIN
1330: OPEN get_request_id_cur;
1331: FETCH get_request_id_cur INTO l_request_id;

Line 1354: FROM fnd_lobs fl,

1350: SELECT file_data,
1351: file_id -- Bug 7135471
1352: INTO l_document,
1353: l_pdf_file_id -- Bug 7135471
1354: FROM fnd_lobs fl,
1355: fnd_attached_documents fad,
1356: fnd_documents_vl fdl
1357: WHERE fad.pk1_value = l_item_key || l_rname
1358: AND fdl.document_id = fad.document_id

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

1357: WHERE fad.pk1_value = l_item_key || l_rname
1358: AND fdl.document_id = fad.document_id
1359: AND fdl.media_id = fl.file_id
1360: AND fad.entity_name = 'ERDETAILS'
1361: AND fl.file_id = (select max(file_id) FROM fnd_lobs fl, -- Bug 7135471
1362: fnd_attached_documents fad,
1363: fnd_documents_vl fdl
1364: WHERE fad.pk1_value = l_item_key || l_rname
1365: AND fdl.document_id = fad.document_id