[Home] [Help]
2301: i number;
2302:
2303: TYPE local_rrs_site_attachment_rec is RECORD (
2304: Last_update_date fnd_attached_documents.last_update_date%TYPE,
2305: Last_updated_by_name fnd_user.user_name%TYPE,
2306: Entity_name fnd_attached_documents.Entity_name%TYPE,
2307: site_id fnd_attached_documents.pk1_value%TYPE,
2308: datatype_id fnd_documents.datatype_id%TYPE,
2309: datatype_name fnd_document_datatypes.user_name%TYPE,
2316: document_entity_id fnd_document_entities.document_entity_id%TYPE,
2317: category_id fnd_attached_documents.category_id%TYPE,
2318: attachment_category_name fnd_document_categories_tl.user_name%TYPE,
2319: status fnd_attached_documents.status%TYPE,
2320: attached_by_name fnd_user.user_name%TYPE,
2321: file_name_sort fnd_documents.URL%TYPE,
2322: usage_type fnd_documents.usage_type%TYPE,
2323: security_type fnd_documents.security_type%TYPE,
2324: publish_flag fnd_documents.publish_flag%TYPE,
2366: -- 'ALLOW_ATTACH_DELETE' ALLOW_ATTACH_DELETE,
2367: ad.category_id category_id,
2368: cl.user_name attachment_category_name,
2369: ad.status,
2370: (select u1.user_name from fnd_user u1 where u1.user_id=ad.CREATED_BY) ATTACHED_BY_NAME,
2371: decode(d.datatype_id, 5, nvl(d.title,d.description)||'('||substr(d.URL, 1, least(length(d.URL),15))||'...)',
2372: decode(d.datatype_id, 6, nvl(d.title, d.file_name), decode(D.TITLE, null, (select message_text from fnd_new_messages where
2373: message_name = 'FND_UNDEFINED' and application_id = 0 and language_code = userenv('LANG')), D.TITLE))) FILE_NAME_SORT,
2374: d.usage_type,
2382: INTO l_attachment_details
2383: FROM FND_DOCUMENTS_VL d,
2384: FND_ATTACHED_DOCUMENTS ad,
2385: FND_DOCUMENT_ENTITIES e,
2386: FND_USER u,
2387: FND_DOCUMENT_CATEGORIES_TL cl,
2388: FND_DM_NODES node
2389: WHERE ad.DOCUMENT_ID = d.DOCUMENT_ID
2390: and ad.ENTITY_NAME = e.DATA_OBJECT_CODE(+)