APPS.IEX_XML_PKG dependencies on IEX_XML_REQUEST_HISTORIES

Line 33: FROM iex_xml_request_histories

29: ) IS
30:
31: CURSOR get_rowid IS
32: SELECT ROWID
33: FROM iex_xml_request_histories
34: WHERE xml_request_id = px_xml_request_id;
35: --
36: CURSOR get_seq_csr is
37: SELECT IEX_XML_REQUEST_HISTORIES_s.nextval

Line 37: SELECT IEX_XML_REQUEST_HISTORIES_s.nextval

33: FROM iex_xml_request_histories
34: WHERE xml_request_id = px_xml_request_id;
35: --
36: CURSOR get_seq_csr is
37: SELECT IEX_XML_REQUEST_HISTORIES_s.nextval
38: FROM sys.dual;
39:
40: BEGIN
41: --

Line 50: INSERT INTO IEX_XML_REQUEST_HISTORIES (

46: End If;
47: --dbms_output.put_line('id=' || px_xml_request_id);
48: --dbms_output.put_line('insert');
49: --
50: INSERT INTO IEX_XML_REQUEST_HISTORIES (
51: XML_REQUEST_ID
52: , QUERY_TEMP_ID
53: , STATUS
54: , DOCUMENT

Line 115: DELETE FROM iex_xml_request_histories

111: PROCEDURE delete_row(
112: p_xml_request_id NUMBER
113: ) IS
114: BEGIN
115: DELETE FROM iex_xml_request_histories
116: WHERE xml_request_id = p_xml_request_id;
117: IF (SQL%NOTFOUND) THEN
118: RAISE NO_DATA_FOUND;
119: END IF;

Line 175: from iex_xml_request_histories

171: last_update_date,
172: last_updated_by,
173: last_update_login,
174: object_version_number
175: from iex_xml_request_histories
176: where xml_request_id = in_request_id
177: for update nowait;
178: --
179: l_xml_request_id NUMBER;

Line 255: UPDATE iex_xml_request_histories

251: if (p_last_updated_by is not null ) then
252: l_last_updated_by := p_last_updated_by;
253: end if;
254:
255: UPDATE iex_xml_request_histories
256: SET
257: query_temp_id = l_query_temp_id
258: , status = l_status
259: , document = l_document