APPS.IEX_XML_PKG dependencies on IEX_XML_REQUEST_HISTORIES

Line 48: FROM iex_xml_request_histories

44: ) IS
45:
46: CURSOR get_rowid IS
47: SELECT ROWID
48: FROM iex_xml_request_histories
49: WHERE xml_request_id = px_xml_request_id;
50: --
51: CURSOR get_seq_csr is
52: SELECT IEX_XML_REQUEST_HISTORIES_s.nextval

Line 52: SELECT IEX_XML_REQUEST_HISTORIES_s.nextval

48: FROM iex_xml_request_histories
49: WHERE xml_request_id = px_xml_request_id;
50: --
51: CURSOR get_seq_csr is
52: SELECT IEX_XML_REQUEST_HISTORIES_s.nextval
53: FROM sys.dual;
54:
55: BEGIN
56: --

Line 67: INSERT INTO IEX_XML_REQUEST_HISTORIES (

63: --dbms_output.put_line('insert');
64: --
65: --Start adding for bug 8489610 by gnramasa 14-May-09
66: WriteLog( ' in xml_pkg org_id ' || p_org_id);
67: INSERT INTO IEX_XML_REQUEST_HISTORIES (
68: XML_REQUEST_ID
69: , QUERY_TEMP_ID
70: , STATUS
71: , DOCUMENT

Line 163: DELETE FROM iex_xml_request_histories

159: PROCEDURE delete_row(
160: p_xml_request_id NUMBER
161: ) IS
162: BEGIN
163: DELETE FROM iex_xml_request_histories
164: WHERE xml_request_id = p_xml_request_id;
165: IF (SQL%NOTFOUND) THEN
166: RAISE NO_DATA_FOUND;
167: END IF;

Line 251: from iex_xml_request_histories

247: addt_xmldata,
248: addt_status,
249: addt_document,
250: addt_html_document
251: from iex_xml_request_histories
252: where xml_request_id = in_request_id
253: for update nowait;
254: --
255: l_xml_request_id NUMBER;

Line 401: UPDATE iex_xml_request_histories

397: if (p_addt_html_document is not null ) then
398: l_addt_html_document := p_addt_html_document;
399: end if;
400:
401: UPDATE iex_xml_request_histories
402: SET
403: query_temp_id = l_query_temp_id
404: , status = l_status
405: , document = l_document