[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_html_document BLOB
, p_xmldata CLOB
, p_method VARCHAR2
, p_destination VARCHAR2
, p_subject 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
, p_request_id NUMBER
, p_worker_id NUMBER
, p_confirmation_mode VARCHAR2 -- added by gnramasa for bug 8489610 14-May-09
, p_conc_request_id NUMBER -- added by gnramasa for bug 8489610 14-May-09
, p_org_id number -- added for bug 9151851
, p_template_language VARCHAR2 -- added by gnramasa for bug 8489610 28-May-09
, p_template_territory VARCHAR2 -- added by gnramasa for bug 8489610 28-May-09
, p_document_type VARCHAR2 default NULL
, p_addt_query_id number --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_xmldata CLOB --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_status VARCHAR2 --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_document BLOB --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_html_document BLOB --added for bug 9970624 gnramasa 4th Aug 10
) 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
, HTML_DOCUMENT
, XMLDATA
, METHOD
, DESTINATION
, SUBJECT
, 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
, request_id
, worker_id
, confirmation_mode
, conc_request_id
, language
, territory
, org_id -- added for bug 9151851
, document_type
, addt_query_temp_id
, addt_xmldata
, addt_status
, addt_document
, addt_html_document
) VALUES (
px_xml_request_id
, p_query_temp_id
, p_status
, p_document
, p_html_document
, p_xmldata
, p_method
, p_destination
, p_subject
, 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
, p_request_id
, p_worker_id
, p_confirmation_mode
, p_conc_request_id
, p_template_language
, p_template_territory
, p_org_id -- added for bug 9151851
, p_document_type
, p_addt_query_id
, p_addt_xmldata
, p_addt_status
, p_addt_document
, p_addt_html_document
);
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_html_document BLOB
, p_xmldata CLOB
, p_method VARCHAR2
, p_destination VARCHAR2
, p_subject 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
, p_request_id NUMBER
, p_worker_id NUMBER
, p_confirmation_mode VARCHAR2 -- added by gnramasa for bug 8489610 14-May-09
, p_conc_request_id NUMBER -- added by gnramasa for bug 8489610 14-May-09
, p_template_language VARCHAR2 -- added by gnramasa for bug 8489610 28-May-09
, p_template_territory VARCHAR2 -- added by gnramasa for bug 8489610 28-May-09
, p_document_type VARCHAR2 default NULL
, p_addt_query_id number --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_xmldata CLOB --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_status VARCHAR2 --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_document BLOB --added for bug 9970624 gnramasa 4th Aug 10
, p_addt_html_document BLOB --added for bug 9970624 gnramasa 4th Aug 10
)
IS
cursor c_get_rec (in_request_id number) is
select rowid,
xml_request_id,
query_temp_id,
status,
document,
html_document,
xmldata,
object_type,
object_id,
resource_id,
method,
destination,
subject,
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,
request_id,
worker_id,
confirmation_mode,
conc_request_id,
language,
territory,
document_type,
addt_query_temp_id,
addt_xmldata,
addt_status,
addt_document,
addt_html_document
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,
l_request_id,
l_worker_id,
l_confirmation_mode,
l_conc_request_id,
l_language,
l_territory,
l_document_type,
l_addt_query_temp_id,
l_addt_xmldata,
l_addt_status,
l_addt_document,
l_addt_html_document;
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
, html_document = l_html_document
, xmldata = l_xmldata
, method = l_method
, destination = l_destination
, subject = l_subject
, 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
, request_id = l_request_id
, worker_id = l_worker_id
, confirmation_mode = l_confirmation_mode
, conc_request_id = l_conc_request_id
, language = l_language
, territory = l_territory
, document_type = l_document_type
, addt_query_temp_id = l_addt_query_temp_id
, addt_xmldata = l_addt_xmldata
, addt_status = l_addt_status
, addt_document = l_addt_document
, addt_html_document = l_addt_html_document
WHERE xml_request_id = p_xml_request_id;
WriteLog('iextxmlb.pls:update_row:Exception errmsg='||SQLERRM);
END update_row;