536:
537:
538: /*
539: Overview: This function is to retrieve the existing xml data from
540: iex_xml_request_histories table by the xml_request_id.
541: */
542: procedure RetrieveXmlData
543: (
544: p_request_id IN number
549: )
550: IS
551: CURSOR C_GET_XML (IN_REQUEST_ID NUMBER) IS
552: SELECT xmldata
553: FROM IEX_XML_REQUEST_HISTORIES
554: WHERE xml_request_id = in_request_id;
555:
556: l_xml CLOB;
557:
999:
1000:
1001: /*
1002: Overview: This function is to retrieve the existing xml data from
1003: iex_xml_request_histories table by the xml_request_id.
1004: */
1005: function getCurrDeliveryMethod return varchar2
1006: IS
1007: CURSOR C_GET_SETUP IS