APPS.PO_AME_WF_PVT dependencies on FND_LOBS

Line 3181: l_filename_new fnd_lobs.file_name%type;

3177: l_attachments_exist VARCHAR2(1); -- Holds 'Y' if there are any supplier file attachments
3178: l_duplicate_filenames VARCHAR2(1); -- Holds 'Y' if there are any supplier file attachments with same filename
3179: l_error_flag NUMBER; -- Determines if the error condition (same file namebut different file lengths has been met or not)
3180: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
3181: l_filename_new fnd_lobs.file_name%type;
3182: l_length NUMBER;
3183: l_length_new NUMBER;
3184: l_filename fnd_lobs.file_name%type;
3185: l_api_name VARCHAR2(500) := 'generate_pdf_ame_supp';

Line 3184: l_filename fnd_lobs.file_name%type;

3180: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
3181: l_filename_new fnd_lobs.file_name%type;
3182: l_length NUMBER;
3183: l_length_new NUMBER;
3184: l_filename fnd_lobs.file_name%type;
3185: l_api_name VARCHAR2(500) := 'generate_pdf_ame_supp';
3186: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
3187:
3188: CURSOR l_get_po_attachments_csr(l_po_header_id NUMBER) IS

Line 3194: fnd_lobs fl

3190: FROM fnd_documents d,
3191: fnd_attached_documents ad,
3192: fnd_doc_category_usages dcu,
3193: fnd_attachment_functions af,
3194: fnd_lobs fl
3195: WHERE ( (ad.pk1_value = TO_CHAR(l_po_header_id) AND ad.entity_name = 'PO_HEADERS') OR
3196: (ad.pk1_value = (SELECT To_Char(vendor_id)
3197: FROM po_headers_all
3198: WHERE po_header_id = l_po_header_id) AND ad.entity_name = 'PO_VENDORS') OR

Line 3358: fnd_lobs fl

3354: FROM fnd_documents d,
3355: fnd_attached_documents ad,
3356: fnd_doc_category_usages dcu,
3357: fnd_attachment_functions af,
3358: fnd_lobs fl
3359: WHERE ( (ad.pk1_value = TO_CHAR(l_document_id) AND ad.entity_name = 'PO_HEADERS') OR
3360: --
3361: (ad.pk1_value = TO_CHAR((SELECT vendor_id
3362: FROM po_headers_all