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.PON_ATTACHMENTS dependencies on FND_DOCUMENTS

Line 227: INSERT INTO fnd_documents_short_text(

223: x_doc_attribute15 => NULL
224: );
225:
226: IF (p_datatype_id = PON_ATTACHMENTS.SHORT_TEXT) THEN
227: INSERT INTO fnd_documents_short_text(
228: media_id,
229: short_text)
230: VALUES (
231: l_media_id,

Line 364: -- Insert available Long Text into FND_DOCUMENTS_LONG_TEXT

360: x_doc_attribute14 => NULL ,
361: x_doc_attribute15 => NULL
362: );
363:
364: -- Insert available Long Text into FND_DOCUMENTS_LONG_TEXT
365: l_progress := 6;
366: INSERT INTO fnd_documents_long_text
367: (
368: media_id,

Line 366: INSERT INTO fnd_documents_long_text

362: );
363:
364: -- Insert available Long Text into FND_DOCUMENTS_LONG_TEXT
365: l_progress := 6;
366: INSERT INTO fnd_documents_long_text
367: (
368: media_id,
369: long_text
370: ) VALUES (

Line 414: l_description FND_DOCUMENTS_TL.DESCRIPTION%Type;

410: l_document_id number:= add_attachment_frm_doc_catalog.p_document_id;
411: l_datatype_id number;
412: l_category_id number;
413: l_file_name varchar2(255);
414: l_description FND_DOCUMENTS_TL.DESCRIPTION%Type;
415: l_creation_date date := SYSDATE;
416: l_created_by number;
417: l_last_update_date date := SYSDATE;
418: l_last_updated_by number;

Line 420: l_usage_type FND_DOCUMENTS.USAGE_TYPE%Type;

416: l_created_by number;
417: l_last_update_date date := SYSDATE;
418: l_last_updated_by number;
419: l_lang varchar2(40);
420: l_usage_type FND_DOCUMENTS.USAGE_TYPE%Type;
421:
422: l_create_doc varchar2(1):= 'N';
423:
424: l_doc_attribute_category FND_DOCUMENTS_TL.DOC_ATTRIBUTE_CATEGORY%Type;

Line 424: l_doc_attribute_category FND_DOCUMENTS_TL.DOC_ATTRIBUTE_CATEGORY%Type;

420: l_usage_type FND_DOCUMENTS.USAGE_TYPE%Type;
421:
422: l_create_doc varchar2(1):= 'N';
423:
424: l_doc_attribute_category FND_DOCUMENTS_TL.DOC_ATTRIBUTE_CATEGORY%Type;
425: l_doc_attribute1 FND_DOCUMENTS_TL.DOC_ATTRIBUTE1%Type;
426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;
427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;

Line 425: l_doc_attribute1 FND_DOCUMENTS_TL.DOC_ATTRIBUTE1%Type;

421:
422: l_create_doc varchar2(1):= 'N';
423:
424: l_doc_attribute_category FND_DOCUMENTS_TL.DOC_ATTRIBUTE_CATEGORY%Type;
425: l_doc_attribute1 FND_DOCUMENTS_TL.DOC_ATTRIBUTE1%Type;
426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;
427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;

Line 426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;

422: l_create_doc varchar2(1):= 'N';
423:
424: l_doc_attribute_category FND_DOCUMENTS_TL.DOC_ATTRIBUTE_CATEGORY%Type;
425: l_doc_attribute1 FND_DOCUMENTS_TL.DOC_ATTRIBUTE1%Type;
426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;
427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;

Line 427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;

423:
424: l_doc_attribute_category FND_DOCUMENTS_TL.DOC_ATTRIBUTE_CATEGORY%Type;
425: l_doc_attribute1 FND_DOCUMENTS_TL.DOC_ATTRIBUTE1%Type;
426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;
427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;

Line 428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;

424: l_doc_attribute_category FND_DOCUMENTS_TL.DOC_ATTRIBUTE_CATEGORY%Type;
425: l_doc_attribute1 FND_DOCUMENTS_TL.DOC_ATTRIBUTE1%Type;
426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;
427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;

Line 429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;

425: l_doc_attribute1 FND_DOCUMENTS_TL.DOC_ATTRIBUTE1%Type;
426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;
427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;

Line 430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;

426: l_doc_attribute2 FND_DOCUMENTS_TL.DOC_ATTRIBUTE2%Type;
427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;

Line 431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;

427: l_doc_attribute3 FND_DOCUMENTS_TL.DOC_ATTRIBUTE3%Type;
428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;

Line 432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;

428: l_doc_attribute4 FND_DOCUMENTS_TL.DOC_ATTRIBUTE4%Type;
429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;

Line 433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;

429: l_doc_attribute5 FND_DOCUMENTS_TL.DOC_ATTRIBUTE5%Type;
430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;
437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;

Line 434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;

430: l_doc_attribute6 FND_DOCUMENTS_TL.DOC_ATTRIBUTE6%Type;
431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;
437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;
438: l_doc_attribute14 FND_DOCUMENTS_TL.DOC_ATTRIBUTE14%Type;

Line 435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;

431: l_doc_attribute7 FND_DOCUMENTS_TL.DOC_ATTRIBUTE7%Type;
432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;
437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;
438: l_doc_attribute14 FND_DOCUMENTS_TL.DOC_ATTRIBUTE14%Type;
439: l_doc_attribute15 FND_DOCUMENTS_TL.DOC_ATTRIBUTE15%Type;

Line 436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;

432: l_doc_attribute8 FND_DOCUMENTS_TL.DOC_ATTRIBUTE8%Type;
433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;
437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;
438: l_doc_attribute14 FND_DOCUMENTS_TL.DOC_ATTRIBUTE14%Type;
439: l_doc_attribute15 FND_DOCUMENTS_TL.DOC_ATTRIBUTE15%Type;
440:

Line 437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;

433: l_doc_attribute9 FND_DOCUMENTS_TL.DOC_ATTRIBUTE9%Type;
434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;
437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;
438: l_doc_attribute14 FND_DOCUMENTS_TL.DOC_ATTRIBUTE14%Type;
439: l_doc_attribute15 FND_DOCUMENTS_TL.DOC_ATTRIBUTE15%Type;
440:
441: l_progress number := 0; -- For debugging purposes

Line 438: l_doc_attribute14 FND_DOCUMENTS_TL.DOC_ATTRIBUTE14%Type;

434: l_doc_attribute10 FND_DOCUMENTS_TL.DOC_ATTRIBUTE10%Type;
435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;
437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;
438: l_doc_attribute14 FND_DOCUMENTS_TL.DOC_ATTRIBUTE14%Type;
439: l_doc_attribute15 FND_DOCUMENTS_TL.DOC_ATTRIBUTE15%Type;
440:
441: l_progress number := 0; -- For debugging purposes
442:

Line 439: l_doc_attribute15 FND_DOCUMENTS_TL.DOC_ATTRIBUTE15%Type;

435: l_doc_attribute11 FND_DOCUMENTS_TL.DOC_ATTRIBUTE11%Type;
436: l_doc_attribute12 FND_DOCUMENTS_TL.DOC_ATTRIBUTE12%Type;
437: l_doc_attribute13 FND_DOCUMENTS_TL.DOC_ATTRIBUTE13%Type;
438: l_doc_attribute14 FND_DOCUMENTS_TL.DOC_ATTRIBUTE14%Type;
439: l_doc_attribute15 FND_DOCUMENTS_TL.DOC_ATTRIBUTE15%Type;
440:
441: l_progress number := 0; -- For debugging purposes
442:
443: BEGIN

Line 479: From FND_DOCUMENTS D, FND_DOCUMENTS_TL DTL

475: l_doc_attribute8, l_doc_attribute9,
476: l_doc_attribute10, l_doc_attribute11,
477: l_doc_attribute12, l_doc_attribute13,
478: l_doc_attribute14, l_doc_attribute15
479: From FND_DOCUMENTS D, FND_DOCUMENTS_TL DTL
480: Where DTL.DOCUMENT_ID = D.DOCUMENT_ID
481: And DTL.DOCUMENT_ID = l_document_id
482: And DTL.LANGUAGE = l_lang
483: ;

Line 666: l_file_id FND_DOCUMENTS_TL.MEDIA_ID%Type

662: x_file_id out nocopy NUMBER
663: ) IS
664: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%Type
665: := 0;
666: l_file_id FND_DOCUMENTS_TL.MEDIA_ID%Type
667: := 0;
668: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%Type
669: := add_attachment_frm_ui.p_datatype_id;
670: l_progress NUMBER := 0; -- For debugging purposes

Line 668: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%Type

664: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%Type
665: := 0;
666: l_file_id FND_DOCUMENTS_TL.MEDIA_ID%Type
667: := 0;
668: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%Type
669: := add_attachment_frm_ui.p_datatype_id;
670: l_progress NUMBER := 0; -- For debugging purposes
671: BEGIN
672:

Line 785: From Fnd_Documents doc

781: -- attachments.
782: --
783:
784: Select doc.Usage_Type Into l_usage_type
785: From Fnd_Documents doc
786: Where doc.Document_Id =
787: (
788: Select att.Document_Id
789: From Fnd_Attached_Documents att