912: UPDATE fnd_documents
913: SET category_id = l_inv_category_id
914: WHERE document_id = l_attachment_rec.document_id;
915:
916: UPDATE fnd_documents_tl
917: SET doc_attribute_category = 'MSDS_INV_ITEM'
918: WHERE document_id = l_attachment_rec.document_id;
919:
920: END IF;
2042:
2043: /* Cursor used retrieve the organization_code from the document */
2044: CURSOR c_get_doc_org IS
2045: SELECT doc_attribute5
2046: FROM fnd_documents_tl
2047: WHERE language = userenv('LANG') and
2048: document_id = l_dispatch_rec.document_id;
2049:
2050: /* ----------------- EXCEPTIONS -------------------- */