DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPRPT_PKG dependencies on FND_DOCUMENTS

Line 1754: FROM fnd_documents

1750: );
1751:
1752: CURSOR expense_documents_cur(l_document_id IN NUMBER) IS
1753: SELECT *
1754: FROM fnd_documents
1755: WHERE document_id = l_document_id;
1756:
1757: CURSOR expense_documents_tl_cur(l_document_id IN NUMBER) IS
1758: SELECT *

Line 1759: FROM fnd_documents_tl

1755: WHERE document_id = l_document_id;
1756:
1757: CURSOR expense_documents_tl_cur(l_document_id IN NUMBER) IS
1758: SELECT *
1759: FROM fnd_documents_tl
1760: WHERE document_id = l_document_id
1761: AND rownum = 1;
1762:
1763: AttachedDocTabRec expense_attachments_cur%ROWTYPE;

Line 1858: FND_DOCUMENTS_PKG.Update_Row

1854: INTO DocumentTLTabRec;
1855:
1856: CLOSE expense_documents_tl_cur;
1857:
1858: FND_DOCUMENTS_PKG.Update_Row
1859: (X_document_id => DocumentTabRec.document_id
1860: ,X_last_update_date => sysdate
1861: ,X_last_updated_by => to_number(fnd_global.user_id)
1862: ,X_last_update_login => to_number(FND_GLOBAL.LOGIN_ID)