[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row(
px_rowid IN OUT NOCOPY VARCHAR2
, px_xml_request_id IN OUT NOCOPY NUMBER
, p_query_temp_id NUMBER
, p_status VARCHAR2
, p_document BLOB
, p_xmldata CLOB
, p_method VARCHAR2
, p_destination VARCHAR2
, p_object_type VARCHAR2
, p_object_id NUMBER
, p_resource_id NUMBER
, p_view_by VARCHAR2
, p_party_id NUMBER
, p_cust_account_id NUMBER
, p_cust_site_use_id NUMBER
, p_delinquency_id NUMBER
, p_last_update_date DATE
, p_last_updated_by NUMBER
, p_creation_date DATE
, p_created_by NUMBER
, p_last_update_login NUMBER
, p_object_version_number NUMBER
) IS
CURSOR get_rowid IS
SELECT ROWID
FROM iex_xml_request_histories
WHERE xml_request_id = px_xml_request_id;
SELECT IEX_XML_REQUEST_HISTORIES_s.nextval
FROM sys.dual;
INSERT INTO IEX_XML_REQUEST_HISTORIES (
XML_REQUEST_ID
, QUERY_TEMP_ID
, STATUS
, DOCUMENT
, XMLDATA
, METHOD
, DESTINATION
, OBJECT_TYPE
, OBJECT_ID
, RESOURCE_ID
, VIEW_BY
, PARTY_ID
, CUST_ACCOUNT_ID
, CUST_SITE_USE_ID
, DELINQUENCY_ID
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, object_version_number
) VALUES (
px_xml_request_id
, p_query_temp_id
, p_status
, p_document
, p_xmldata
, p_method
, p_destination
, p_object_type
, p_object_id
, p_resource_id
, p_view_by
, p_party_id
, p_cust_account_id
, p_cust_site_use_id
, p_delinquency_id
, p_last_update_date
, p_last_updated_by
, p_creation_date
, p_created_by
, p_last_update_login
, p_object_version_number
);
WriteLog('iextxmlb.pls:insert_row:Exception errmsg='||SQLERRM);
END insert_row;
PROCEDURE delete_row(
p_xml_request_id NUMBER
) IS
BEGIN
DELETE FROM iex_xml_request_histories
WHERE xml_request_id = p_xml_request_id;
WriteLog('iextxmlb.pls:delete_row:Exception errmsg='||SQLERRM);
END delete_row;
PROCEDURE UPDATE_ROW (
p_xml_request_id NUMBER
, p_query_temp_id NUMBER
, p_status VARCHAR2
, p_document BLOB
, p_xmldata CLOB
, p_method VARCHAR2
, p_destination VARCHAR2
, p_object_type VARCHAR2
, p_object_id NUMBER
, p_resource_id NUMBER
, p_view_by VARCHAR2
, p_party_id NUMBER
, p_cust_account_id NUMBER
, p_cust_site_use_id NUMBER
, p_delinquency_id NUMBER
, p_last_update_date DATE
, p_last_updated_by NUMBER
, p_creation_date DATE
, p_created_by NUMBER
, p_last_update_login NUMBER
, p_object_version_number NUMBER
)
IS
cursor c_get_rec (in_request_id number) is
select rowid,
xml_request_id,
query_temp_id,
status,
document,
xmldata,
object_type,
object_id,
resource_id,
method,
destination,
view_by,
party_id,
cust_account_id,
cust_site_use_id,
delinquency_id,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
object_version_number
from iex_xml_request_histories
where xml_request_id = in_request_id
for update nowait;
l_last_update_date DATE;
l_last_updated_by NUMBER;
l_last_update_login NUMBER;
l_last_update_date,
l_last_updated_by,
l_last_update_login,
l_object_version_number;
if (p_last_update_date is not null ) then
l_last_update_date := p_last_update_date;
if (p_last_updated_by is not null ) then
l_last_updated_by := p_last_updated_by;
UPDATE iex_xml_request_histories
SET
query_temp_id = l_query_temp_id
, status = l_status
, document = l_document
, xmldata = l_xmldata
, method = l_method
, destination = l_destination
, object_type = l_object_type
, object_id = l_object_id
, resource_id = l_resource_id
, view_by = l_view_by
, party_id = l_party_id
, cust_account_id = l_cust_account_id
, cust_site_use_id = l_cust_site_use_id
, delinquency_id = l_delinquency_id
, last_update_date = l_last_update_date
, last_updated_by = l_last_updated_by
, last_update_login = l_last_update_login
, creation_date = l_creation_date
, created_by = l_created_by
, object_version_number = l_object_version_number
WHERE xml_request_id = p_xml_request_id;
WriteLog('iextxmlb.pls:update_row:Exception errmsg='||SQLERRM);
END update_row;