DBA Data[Home] [Help]

APPS.IEX_SEND_XML_PVT dependencies on IEX_XML_REQUEST_HISTORIES

Line 257: FROM iex_xml_request_histories

253: and trx.printing_option = 'PRI';
254:
255: cursor c_get_document_type (p_xml_req_id number) is
256: SELECT document_type
257: FROM iex_xml_request_histories
258: WHERE xml_request_id = p_xml_req_id;
259:
260: l_document_type varchar2(240);
261:

Line 743: iex_xml_request_histories table by the xml_request_id.

739:
740:
741: /*
742: Overview: This function is to retrieve the existing xml data from
743: iex_xml_request_histories table by the xml_request_id.
744: */
745: procedure RetrieveXmlData
746: (
747: p_request_id IN number

Line 757: FROM IEX_XML_REQUEST_HISTORIES

753: )
754: IS
755: CURSOR C_GET_XML (IN_REQUEST_ID NUMBER) IS
756: SELECT xmldata, addt_xmldata
757: FROM IEX_XML_REQUEST_HISTORIES
758: WHERE xml_request_id = in_request_id;
759:
760: l_xml CLOB;
761: l_addt_xml CLOB;

Line 1299: iex_xml_request_histories table by the xml_request_id.

1295:
1296:
1297: /*
1298: Overview: This function is to retrieve the existing xml data from
1299: iex_xml_request_histories table by the xml_request_id.
1300: */
1301: function getCurrDeliveryMethod return varchar2
1302: IS
1303: CURSOR C_GET_SETUP IS