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_TL

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 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