[Home] [Help]
2228: i number;
2229:
2230: TYPE local_rrs_site_attachment_rec is RECORD (
2231: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2232: Last_updated_by_name fnd_user.user_name%TYPE,
2233: Entity_name fnd_attached_documents.Entity_name%TYPE,
2234: site_id fnd_attached_documents.pk1_value%TYPE,
2235: datatype_id fnd_documents.datatype_id%TYPE,
2236: datatype_name fnd_document_datatypes.user_name%TYPE,
2243: document_entity_id fnd_document_entities.document_entity_id%TYPE,
2244: category_id fnd_attached_documents.category_id%TYPE,
2245: attachment_category_name fnd_document_categories_tl.user_name%TYPE,
2246: status fnd_attached_documents.status%TYPE,
2247: attached_by_name fnd_user.user_name%TYPE,
2248: file_name_sort fnd_documents.URL%TYPE,
2249: usage_type fnd_documents.usage_type%TYPE,
2250: security_type fnd_documents.security_type%TYPE,
2251: publish_flag fnd_documents.publish_flag%TYPE,
2293: -- 'ALLOW_ATTACH_DELETE' ALLOW_ATTACH_DELETE,
2294: ad.category_id category_id,
2295: cl.user_name attachment_category_name,
2296: ad.status,
2297: (select u1.user_name from fnd_user u1 where u1.user_id=ad.CREATED_BY) ATTACHED_BY_NAME,
2298: decode(d.datatype_id, 5, nvl(d.title,d.description)||'('||substr(d.URL, 1, least(length(d.URL),15))||'...)',
2299: decode(d.datatype_id, 6, nvl(d.title, d.file_name), decode(D.TITLE, null, (select message_text from fnd_new_messages where
2300: message_name = 'FND_UNDEFINED' and application_id = 0 and language_code = userenv('LANG')), D.TITLE))) FILE_NAME_SORT,
2301: d.usage_type,
2309: INTO l_attachment_details
2310: FROM FND_DOCUMENTS_VL d,
2311: FND_ATTACHED_DOCUMENTS ad,
2312: FND_DOCUMENT_ENTITIES e,
2313: FND_USER u,
2314: FND_DOCUMENT_CATEGORIES_TL cl,
2315: FND_DM_NODES node
2316: WHERE ad.DOCUMENT_ID = d.DOCUMENT_ID
2317: and ad.ENTITY_NAME = e.DATA_OBJECT_CODE(+)