APPS.AP_WEB_EXPORT_ER dependencies on FND_DOCUMENTS

Line 903: FROM fnd_documents

899: ) ORDER BY entity_name,pk1_value,attached_document_id ;--Used the Order by clause so that seq_num will be first given to Header attachments.
900:
901: CURSOR expense_documents_cur(l_document_id IN NUMBER) IS
902: SELECT *
903: FROM fnd_documents
904: WHERE document_id = l_document_id;
905:
906: CURSOR expense_documents_tl_cur(l_document_id IN NUMBER) IS
907: SELECT *

Line 908: FROM fnd_documents_tl

904: WHERE document_id = l_document_id;
905:
906: CURSOR expense_documents_tl_cur(l_document_id IN NUMBER) IS
907: SELECT *
908: FROM fnd_documents_tl
909: WHERE document_id = l_document_id
910: AND rownum = 1;
911:
912: AttachedDocTabRec expense_attachments_cur%ROWTYPE;

Line 1015: FND_DOCUMENTS_PKG.Update_Row

1011: INTO DocumentTLTabRec;
1012:
1013: CLOSE expense_documents_tl_cur;
1014:
1015: FND_DOCUMENTS_PKG.Update_Row
1016: (X_document_id => DocumentTabRec.document_id
1017: ,X_last_update_date => sysdate
1018: ,X_last_updated_by => to_number(fnd_global.user_id)
1019: ,X_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)