APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on XMLTYPE

Line 927: l_response_xml xmltype;

923: p_event in out NOCOPY WF_EVENT_T)
924: RETURN VARCHAR2 IS
925: l_module VARCHAR2(100) := 'PROCESS_FBO_RESPONSE';
926: l_response_clob CLOB;
927: l_response_xml xmltype;
928: l_result VARCHAR2(100);
929: l_res_message VARCHAR2(4000);
930:
931: l_id VARCHAR2(100);

Line 940: l_result_xml xmltype;

936: l_supplier_status VARCHAR2(30) :='ELIGIBLE';
937: l_error VARCHAR2(4000);
938:
939: l_result CLOB;
940: l_result_xml xmltype;
941: l_success_flag VARCHAR2(400);
942: l_count NUMBER;
943:
944: l_error_msg VARCHAR2(4000):=NULL;

Line 1017: l_result_xml := XMLType(l_response_clob);

1013:
1014: l_supplier_name := p_event.getValueForParameter('PO_EPLS_SUPPLIER_NAME');
1015:
1016:
1017: l_result_xml := XMLType(l_response_clob);
1018:
1019: IF l_result_xml.existsnode('//successful') > 0 THEN
1020:
1021: l_success_flag := l_result_xml.extract('//successful/text()').getStringVal();