[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT JTF_FM_REQUESTHISTID_S.NEXTVAL
FROM dual;
SELECT 1
FROM JTF_FM_REQUEST_HISTORY
WHERE HIST_REQ_ID = l_id;
INSERT INTO JTF_FM_REQUEST_HISTORY_ALL(
OUTCOME_CODE,
SOURCE_CODE_ID,
SOURCE_CODE,
OBJECT_TYPE,
OBJECT_ID,
order_id,
resubmit_count,
outcome_desc ,
request,
submit_dt_tm,
server_id,
template_id,
app_info,
group_id,
hist_req_id,
user_id,
priority,
processed_dt_tm,
message_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
org_id,
f_deletedflag,
object_version_number,
security_group_id)
VALUES(
p_request_history_rec.outcome_code,
p_request_history_rec.source_code_id,
p_request_history_rec.source_code,
p_request_history_rec.object_type,
p_request_history_rec.object_id,
p_request_history_rec.order_id,
p_request_history_rec.resubmit_count,
p_request_history_rec.outcome_desc,
p_request_history_rec.request,
p_request_history_rec.submit_dt_tm,
p_request_history_rec.server_id,
p_request_history_rec.template_id,
p_request_history_rec.app_info,
p_request_history_rec.group_id,
l_request_history_id,
p_request_history_rec.user_id,
p_request_history_rec.priority,
p_request_history_rec.processed_dt_tm,
p_request_history_rec.message_id,
SYSDATE,
G_USER_ID,
SYSDATE,
G_USER_ID,
G_LOGIN_ID,
p_request_history_rec.org_id,
null,
l_object_version_number,
p_request_history_rec.security_group_id
);