APPS.PO_COMMUNICATION_PVT dependencies on FND_DOCUMENTS_VL

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

2760: --
2761: -- Brought the call out of the select
2762: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype, '_TERMS_', l_org_id, p_document_id,
2763: l_revision_num, l_buyer_language_code);
2764: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2765: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_vl fdl
2766: where
2767: fad.pk2_value = TO_CHAR(p_document_id) and
2768: fad.pk3_value = TO_CHAR(l_revision_num) and

Line 2765: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_vl fdl

2761: -- Brought the call out of the select
2762: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype, '_TERMS_', l_org_id, p_document_id,
2763: l_revision_num, l_buyer_language_code);
2764: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
2765: select count(1) into l_pdf_tc_buyer_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_vl fdl
2766: where
2767: fad.pk2_value = TO_CHAR(p_document_id) and
2768: fad.pk3_value = TO_CHAR(l_revision_num) and
2769: fad.entity_name = 'OKC_CONTRACT_DOCS' and

Line 2825: select count(1) into l_pdf_nt_buyer_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_vl fdl

2821: -- Brought the call out of the select
2822: l_pdf_file_name := po_communication_pvt.getPDFFileName(l_doctype, '_TERMS_', l_org_id, p_document_id,
2823: l_revision_num, l_buyer_language_code);
2824: --Bug #4865352
2825: select count(1) into l_pdf_nt_buyer_exists from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_vl fdl
2826: where
2827: fad.pk1_value = TO_CHAR(p_document_id) and
2828: fad.pk2_value = TO_CHAR(l_revision_num) and
2829: fad.entity_name = l_entity_name and

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

3326: -- For PDF preventing duplicate records is taken care of by explicitly deleting
3327: -- them before generating it everytime. For ZIP, it will be done by returning
3328: -- the same file id as the existing one so that an explicit delete would not be
3329: -- necessary
3330: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
3331: IF p_blob_type = 'ZIP' THEN
3332: Begin
3333: SELECT fdl.media_id
3334: INTO x_media_id

Line 3336: fnd_documents_vl fdl

3332: Begin
3333: SELECT fdl.media_id
3334: INTO x_media_id
3335: FROM fnd_attached_documents fad,
3336: fnd_documents_vl fdl
3337: WHERE fad.pk1_value = to_char(p_document_id)
3338: and fad.pk2_value = to_char(p_revision_number)
3339: and nvl(fad.pk3_value, '*') = nvl(l_draft_id, '*') -- CLM
3340: and fad.entity_name = l_entity_name

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

3907: end if;
3908: /*Begin Edit Akyanama Bug # 13242469 */
3909:
3910: /*IF l_withTerms = 'Y' THEN
3911: --Bug #4865352 - Replaced fnd_documents_tl with fnd_documents_vl
3912: -- Bug 4047688
3913: -- Appended join condition on file name of document to prevent return of multiple rows
3914: SELECT file_data into l_document
3915: FROM fnd_lobs fl,

Line 3917: fnd_documents_vl fdl

3913: -- Appended join condition on file name of document to prevent return of multiple rows
3914: SELECT file_data into l_document
3915: FROM fnd_lobs fl,
3916: fnd_attached_documents fad,
3917: fnd_documents_vl fdl
3918: --Begin Edit Akyanama Bug # 13242469
3919: --Changed the below line
3920: From : fad.pk2_value = to_char(l_document_id) and fad.pk3_value = to_char(l_revision_number)
3921: To : fad.pk1_value = to_char(l_document_id) and fad.pk2_value = to_char(l_revision_number)