APPS.AP_WEB_EXPORT_ER dependencies on FND_ATTACHED_DOCUMENTS

Line 888: FROM fnd_attached_documents

884:
885: CURSOR expense_attachments_cur(l_report_header_id IN NUMBER) IS
886: SELECT *
887: FROM ( SELECT *
888: FROM fnd_attached_documents
889: WHERE entity_name = 'OIE_HEADER_ATTACHMENTS'
890: AND pk1_value = To_Char(p_report_header_id)
891: UNION ALL
892: SELECT *

Line 893: FROM fnd_attached_documents

889: WHERE entity_name = 'OIE_HEADER_ATTACHMENTS'
890: AND pk1_value = To_Char(p_report_header_id)
891: UNION ALL
892: SELECT *
893: FROM fnd_attached_documents
894: WHERE entity_name = 'OIE_LINE_ATTACHMENTS'
895: AND pk1_value IN ( SELECT To_Char(report_line_id)
896: FROM ap_expense_report_lines_all
897: WHERE report_header_id = p_report_header_id

Line 944: SELECT fnd_attached_documents_s.nextval

940: EXIT WHEN expense_attachments_cur%NOTFOUND;
941:
942: BEGIN
943:
944: SELECT fnd_attached_documents_s.nextval
945: INTO AttachedDocTabRec.attached_document_id
946: FROM dual;
947:
948:

Line 949: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW

945: INTO AttachedDocTabRec.attached_document_id
946: FROM dual;
947:
948:
949: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW
950: (x_rowid => l_rowid
951: , x_attached_document_id => AttachedDocTabRec.attached_document_id
952: , x_document_id => AttachedDocTabRec.document_id
953: , x_seq_num => l_seq_num

Line 1081: FROM fnd_attached_documents

1077:
1078: SELECT Count(*)
1079: INTO l_count_invalid_cat
1080: FROM ( SELECT *
1081: FROM fnd_attached_documents
1082: WHERE entity_name = 'OIE_HEADER_ATTACHMENTS'
1083: AND pk1_value = To_Char(p_report_header_id)
1084: UNION ALL
1085: SELECT *

Line 1086: FROM fnd_attached_documents

1082: WHERE entity_name = 'OIE_HEADER_ATTACHMENTS'
1083: AND pk1_value = To_Char(p_report_header_id)
1084: UNION ALL
1085: SELECT *
1086: FROM fnd_attached_documents
1087: WHERE entity_name = 'OIE_LINE_ATTACHMENTS'
1088: AND pk1_value IN ( SELECT To_Char(report_line_id)
1089: FROM ap_expense_report_lines_all
1090: WHERE report_header_id = p_report_header_id