APPS.PSP_XMLGEN dependencies on FND_ATTACHED_DOCUMENTS

Line 1186: fnd_attached_documents fad,

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
1190: AND fdl.document_id = fad.document_id

Line 1255: INSERT INTO fnd_attached_documents

1251: SYSDATE, NULL, 'PSPERPDF',
1252: NULL, empty_blob(), USERENV('LANG'),
1253: NULL, 'binary');
1254:
1255: INSERT INTO fnd_attached_documents
1256: (attached_document_id, document_id, creation_date,
1257: created_by, last_update_date, last_updated_by,
1258: last_update_login, seq_num, entity_name,
1259: pk1_value, pk2_value, pk3_value,

Line 1268: VALUES (fnd_attached_documents_s.nextval, l_document_id_tmp, SYSDATE,

1264: attribute5, attribute6, attribute7,
1265: attribute8, attribute9, attribute10,
1266: attribute11, attribute12, attribute13,
1267: attribute14, attribute15, column1)
1268: VALUES (fnd_attached_documents_s.nextval, l_document_id_tmp, SYSDATE,
1269: 1, SYSDATE, 1,
1270: NULL, 10, 'ERDETAILS',
1271: TO_CHAR(p_wf_item_key)||p_wf_Role_Name, p_receiver_flag, null,
1272: NULL, NULL, 'N',

Line 1363: fnd_attached_documents fad,

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
1367: AND fdl.media_id = fl.file_id

Line 1370: fnd_attached_documents fad,

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
1374: AND fdl.media_id = fl.file_id