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_PUB dependencies on FND_DOCUMENTS

Line 157: FROM FND_DOCUMENTS

153:
154: CURSOR C_DOC (cp_document_id number)
155: IS
156: SELECT 'Y'
157: FROM FND_DOCUMENTS
158: WHERE document_id = cp_document_id;
159:
160:
161:

Line 479: -- data is valid, create the document by calling fnd_documents_pkg.insert_row

475: close C_CATEGORY;
476: end if;
477:
478:
479: -- data is valid, create the document by calling fnd_documents_pkg.insert_row
480: -----------------------------------------------------------------------------
481: IF l_debug_level > 0 THEN
482: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW-> FND_DOCUMENTS_PKG.INSERT_ROW' ) ;
483: END IF;

Line 482: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW-> FND_DOCUMENTS_PKG.INSERT_ROW' ) ;

478:
479: -- data is valid, create the document by calling fnd_documents_pkg.insert_row
480: -----------------------------------------------------------------------------
481: IF l_debug_level > 0 THEN
482: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW-> FND_DOCUMENTS_PKG.INSERT_ROW' ) ;
483: END IF;
484:
485: fnd_documents_pkg.insert_row (
486: x_rowid => l_rowid

Line 485: fnd_documents_pkg.insert_row (

481: IF l_debug_level > 0 THEN
482: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW-> FND_DOCUMENTS_PKG.INSERT_ROW' ) ;
483: END IF;
484:
485: fnd_documents_pkg.insert_row (
486: x_rowid => l_rowid
487: ,x_document_id => l_document_id
488: ,x_creation_date => l_curr_date
489: ,x_created_by => l_user_id

Line 533: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW INTO FND_DOCUMENTS_SHORT_TEXT ID' || TO_CHAR ( L_DOCUMENT_ID ) ) ;

529:
530: -- now we need to insert the document text in fnd_document_short_text table
531: ---------------------------------------------------------------------------
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW INTO FND_DOCUMENTS_SHORT_TEXT ID' || TO_CHAR ( L_DOCUMENT_ID ) ) ;
534: END IF;
535:
536: INSERT INTO fnd_documents_short_text
537: (

Line 536: INSERT INTO fnd_documents_short_text

532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'OFA:CREATE_SHORT_TEXT_DOCUMENT:INSERING A ROW INTO FND_DOCUMENTS_SHORT_TEXT ID' || TO_CHAR ( L_DOCUMENT_ID ) ) ;
534: END IF;
535:
536: INSERT INTO fnd_documents_short_text
537: (
538: media_id
539: ,short_text
540: )