APPS.PSP_XMLGEN dependencies on FND_ATTACHED_DOCUMENTS

Line 1180: fnd_attached_documents fad,

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

Line 1249: INSERT INTO fnd_attached_documents

1245: SYSDATE, NULL, 'PSPERPDF',
1246: NULL, empty_blob(), USERENV('LANG'),
1247: NULL, 'binary');
1248:
1249: INSERT INTO fnd_attached_documents
1250: (attached_document_id, document_id, creation_date,
1251: created_by, last_update_date, last_updated_by,
1252: last_update_login, seq_num, entity_name,
1253: pk1_value, pk2_value, pk3_value,

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

1258: attribute5, attribute6, attribute7,
1259: attribute8, attribute9, attribute10,
1260: attribute11, attribute12, attribute13,
1261: attribute14, attribute15, column1)
1262: VALUES (fnd_attached_documents_s.nextval, l_document_id_tmp, SYSDATE,
1263: 1, SYSDATE, 1,
1264: NULL, 10, 'ERDETAILS',
1265: TO_CHAR(p_wf_item_key)||p_wf_Role_Name, p_receiver_flag, null,
1266: NULL, NULL, 'N',

Line 1355: fnd_attached_documents fad,

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

Line 1362: fnd_attached_documents fad,

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