eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_FND_ATTACHMENTS_PVT dependencies on FND_DOCUMENTS

Line 316: ' , fnd_documents d'||l_newline||

312:
313: l_rule_sql := 'select distinct r.document_id'||l_newline||
314: 'from oe_attachment_rules r'||l_newline||
315: ' , oe_attachment_rule_elements e1'||l_newline||
316: ' , fnd_documents d'||l_newline||
317: 'where r.database_object_name = :p_database_object_name'||l_newline||
318: ' and e1.rule_id = r.rule_id'||l_newline||
319: ' and r.document_id = d.document_id'||l_newline||
320: ' AND sysdate between NVL(d.start_date_active, sysdate)'||l_newline||

Line 720: FROM FND_DOCUMENTS

716:
717: CURSOR C_DOC
718: IS
719: SELECT 'Y'
720: FROM FND_DOCUMENTS
721: WHERE document_id = p_document_id;
722:
723: l_user_id number:=fnd_global.USER_ID;
724: l_login_id number:=fnd_global.LOGIN_ID;

Line 732: l_usage_type fnd_documents.usage_type%TYPE := null;

728: l_media_id NUMBER;
729: l_document_id NUMBER := p_document_id;
730: l_rowid VARCHAR2(60);
731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;

Line 733: l_datatype_id fnd_documents.datatype_id%TYPE := null;

729: l_document_id NUMBER := p_document_id;
730: l_rowid VARCHAR2(60);
731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;

Line 734: l_category_id fnd_documents.category_id%TYPE := null;

730: l_rowid VARCHAR2(60);
731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;

Line 735: l_security_type fnd_documents.security_type%TYPE := null;

731: --included to fix bug 1903257 Begin
732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;

Line 736: l_publish_flag fnd_documents.publish_flag%TYPE := null;

732: l_usage_type fnd_documents.usage_type%TYPE := null;
733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End

Line 737: l_description fnd_documents_vl.description%TYPE := null;

733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741: l_title fnd_documents_vl.title%TYPE := null; ---bug 12402550

Line 738: l_file_name fnd_documents_vl.file_name%TYPE := null;

734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741: l_title fnd_documents_vl.title%TYPE := null; ---bug 12402550
742:

Line 741: l_title fnd_documents_vl.title%TYPE := null; ---bug 12402550

737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741: l_title fnd_documents_vl.title%TYPE := null; ---bug 12402550
742:
743: --
744: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
745: --

Line 811: from fnd_documents

807: --Code changes made to fix bug 1903257 Begin
808: begin
809: select usage_type
810: into l_usage_type
811: from fnd_documents
812: where document_id = p_document_id ;
813: if l_usage_type = 'S' then
814: l_create_doc := null;
815: elsif l_usage_type in ('T','O') then

Line 821: from fnd_documents_vl where document_id = p_document_id;

817: select datatype_id,category_id,security_type,
818: publish_flag,media_id,file_name,description , title
819: into l_datatype_id,l_category_id,l_security_type,
820: l_publish_flag,l_media_id,l_file_name,l_description ,l_title ---bug 12402550
821: from fnd_documents_vl where document_id = p_document_id;
822: l_create_doc := 'Y';
823: l_document_id := null;
824: exception
825: when others then