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.PO_COMMUNICATION_PVT dependencies on FND_DOCUMENTS_TL

Line 2276: l_buyer_language_code fnd_documents_tl.language%type;

2272: l_request_id number := NULL;
2273:
2274: l_progress VARCHAR2(3);
2275: l_entity_name fnd_attached_documents.entity_name%type;
2276: l_buyer_language_code fnd_documents_tl.language%type;
2277: l_pdf_file_name fnd_lobs.file_name%type; --
2278:
2279: BEGIN
2280: l_progress := '000';

Line 2376: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl

2372: --
2373: -- Brought the call out of the select
2374: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype,'_TERMS_',l_org_id,p_document_id,
2375: l_revision_num,l_buyer_language_code);
2376: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2377: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents_vl fdl
2378: where
2379: fad.pk2_value = TO_CHAR(p_document_id) and
2380: fad.pk3_value = TO_CHAR(l_revision_num) and

Line 2404: select count(1) into l_pdf_tc_sup_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl

2400:
2401: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype,'_TERMS_',l_org_id,p_document_id,
2402: l_revision_num,l_buyer_language_code); --bug#3463617
2403: --Bug #4865352 - Added a join with fnd_documents
2404: select count(1) into l_pdf_tc_sup_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl
2405: where
2406: fad.pk1_value = TO_CHAR(p_document_id) and
2407: fad.pk2_value = TO_CHAR(l_revision_num) and
2408: fad.entity_name = l_entity_name and

Line 2464: select count(1) into l_pdf_nt_sup_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl

2460: -- Brought the call out of the select
2461: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype,'_TERMS_',l_org_id,p_document_id,
2462: l_revision_num,l_language_code);
2463: --Bug #4865352 - Added a join with fnd_documents
2464: select count(1) into l_pdf_nt_sup_exists from fnd_lobs fl,fnd_attached_documents fad, fnd_documents fd, fnd_documents_tl fdl
2465: where
2466: fad.pk1_value = TO_CHAR(p_document_id) and
2467: fad.pk2_value = TO_CHAR(l_revision_num) and
2468: fad.entity_name = l_entity_name and

Line 2907: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl

2903: -- For PDF preventing duplicate records is taken care of by explicitly deleting
2904: -- them before generating it everytime. For ZIP, it will be done by returning
2905: -- the same file id as the existing one so that an explicit delete would not be
2906: -- necessary
2907: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2908: IF p_blob_type = 'ZIP' THEN
2909: Begin
2910: SELECT fdl.media_id
2911: INTO x_media_id

Line 3171: fnd_documents_tl fdl

3167: SELECT file_data into l_document
3168: FROM fnd_lobs fl,
3169: fnd_attached_documents fad,
3170: fnd_documents fd,
3171: fnd_documents_tl fdl
3172: WHERE fad.pk1_value=to_char(l_document_id) and fad.pk2_value=to_char(l_revision_number)
3173: and fdl.document_id = fad.document_id and fdl.document_id = fd.document_id and fd.media_id = fl.file_id
3174: and fad.entity_name = l_entity_name and fdl.language=l_language
3175: and fl.file_name = l_filename ;

Line 3270: fnd_documents_tl fdl

3266: SELECT file_data into l_document
3267: FROM fnd_lobs fl,
3268: fnd_attached_documents fad,
3269: fnd_documents fd,
3270: fnd_documents_tl fdl
3271: WHERE fad.pk2_value=to_char(l_document_id) and fad.pk3_value=to_char(l_revision_number)
3272: and fdl.document_id = fad.document_id and fdl.document_id = fd.document_id and fd.media_id = fl.file_id
3273: and fad.entity_name = 'OKC_CONTRACT_DOCS' and fdl.language=l_language
3274: and fl.file_name = l_filename; -- Bug 4047688

Line 3288: fnd_documents_tl fdl

3284: SELECT file_data into l_document
3285: FROM fnd_lobs fl,
3286: fnd_attached_documents fad,
3287: fnd_documents fd,
3288: fnd_documents_tl fdl
3289: WHERE fad.pk1_value=to_char(l_document_id) and fad.pk2_value=to_char(l_revision_number)
3290: and fdl.document_id = fad.document_id and fd.media_id = fl.file_id
3291: and fd.document_id = fdl.document_id
3292: and fad.entity_name = l_entity_name and fl.file_name = l_filename and fdl.language=l_language;

Line 3418: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl

3414:
3415: IF l_document_type in ('PO','PA') THEN
3416:
3417: IF l_withTerms='Y' THEN
3418: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
3419: -- Bug 4047688
3420: -- Appended join condition on file name of document to prevent return of multiple rows
3421: SELECT file_data into l_document
3422: FROM fnd_lobs fl,

Line 3450: fnd_documents_tl fdl

3446: SELECT file_data into l_document
3447: FROM fnd_lobs fl,
3448: fnd_attached_documents fad,
3449: fnd_documents fd,
3450: fnd_documents_tl fdl
3451: WHERE fad.pk1_value=to_char(l_document_id) and fad.pk2_value=to_char(l_revision_number)
3452: and fdl.document_id = fad.document_id and fd.media_id = fl.file_id and fd.document_id = fdl.document_id
3453: and fad.entity_name = l_entity_name and fl.file_name = l_filename and fdl.language=l_language;
3454:

Line 3752: fnd_documents_tl fdl

3748: INTO l_document,l_filecontent_type
3749: FROM fnd_lobs fl,
3750: fnd_attached_documents fad,
3751: fnd_documents fd,
3752: fnd_documents_tl fdl
3753: WHERE fad.pk1_value=to_char(l_document_id)
3754: and fad.pk2_value=to_char(l_revision_number)
3755: and fad.entity_name = l_entity_name
3756: and fdl.document_id = fad.document_id