APPS.PO_AME_WF_PVT dependencies on DBMS_LOB

Line 3189: SELECT fl.file_name, dbms_lob.getlength(fl.file_data)

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
3189: SELECT fl.file_name, dbms_lob.getlength(fl.file_data)
3190: FROM fnd_documents d,
3191: fnd_attached_documents ad,
3192: fnd_doc_category_usages dcu,
3193: fnd_attachment_functions af,

Line 3226: GROUP BY fl.file_name, dbms_lob.getlength(fl.file_data)

3222: AND d.datatype_id = 6
3223: AND af.function_name = 'PO_PRINTPO'
3224: AND d.media_id = fl.file_id
3225: AND dcu.enabled_flag = 'Y'
3226: GROUP BY fl.file_name, dbms_lob.getlength(fl.file_data)
3227: ORDER BY fl.file_name;
3228:
3229: BEGIN
3230: IF (funcmode <> wf_engine.eng_run) THEN