The following lines contain the word 'select', 'insert', 'update' or 'delete':
select set_id, process_flow_set_id
from PAY_PROCESS_FLOW_SETS
where process_flow_id = p_process_flow_id;
select * from pay_para_set_variables
where set_id = p_csr_set_id;
select destin_set_var_id, source_set_var_id
from pay_para_set_override_vars
where source_set_var_id = p_csr_source_set_var_id;
select set_id into l_flow_set_id
from pay_process_flows
where process_flow_id = p_process_flow_id;
select pay_void_process_request_s1.NEXTVAL
into l_curr_request_id from dual;
insert into PAY_PROCESS_REQUESTS ( process_req_seq_id,
process_request_id,
fnd_request_id,
parent_fnd_request_id,
assignment_action_id,
process_flow_id,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date,
status,
rollback_mode,
sync_mode,
validation_level ) values
(
l_curr_request_id,
pay_void_process_request_s2.NEXTVAL,
null,
null,
p_asg_action,
p_process_flow_id,
null,
null,
null,
fnd_global.user_id,
sysdate,
'U',
'N',
'G',
'F' );
insert into pay_para_set_var_values (
set_variable_value_id,
process_req_seq_id,
set_variable_id,
set_variable_value,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date ) values
(
pay_void_set_var_val_id_s.NEXTVAL,
l_curr_request_id,
l_set_param.set_variable_id,
null,
null,
null,
null,
fnd_global.user_id,
sysdate );
update pay_para_set_var_values
set set_variable_value = p_param_details(no_of_row).set_var_val,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
where set_variable_id = source_set_var.destin_set_var_id
and process_req_seq_id = l_curr_request_id;
select set_variable_value into l_var_value
from pay_para_set_var_values
where set_Variable_id = source_set_var.destin_set_var_id
and process_req_seq_id = l_curr_request_id;
update pay_para_set_var_values
set set_variable_value = p_asg_action,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
where set_variable_id = source_set_var.destin_set_var_id
and process_req_seq_id = l_curr_request_id;
select set_id
from PAY_PROCESS_FLOW_SETS
where process_flow_id = p_process_flow_id
order by process_flow_seq;
select set_variable_value, set_variable_value_id
from pay_para_set_var_values ppsvv,
pay_para_set_variables ppsv
where ppsvv.set_variable_id = ppsv.set_variable_id
and ppsv.set_id = p_set_id
and ppsvv.process_req_seq_id = p_request_id
order by ppsv.set_var_sequence;
select process_req_seq_id
from pay_process_requests
where fnd_request_id = p_fnd_request_id;
select ppr.assignment_action_id
from pay_process_requests ppr
where ppr.process_req_seq_id = p_process_req_seq_id;
select *
from PAY_PROCESS_REQUESTS
where process_req_seq_id = p_process_req_seq_id;
select process_flow_id into l_process_id
from PAY_PROCESS_REQUESTS
where process_req_seq_id = p_request_id;
select wrapper_pkg into l_wrapper_pkg
from pay_parameter_sets
where set_id = l_set_id.set_id;
select distinct group_id into l_group_id
from pay_para_set_variables
where set_id = l_set_id.set_id;
insert_child_request(l_assignment_action_id,
l_request_id);
-- Update the process_req_seq_id column in Pay_para_set_var_values
open get_proc_req_seq_id(l_request_id);
UPDATE PAY_PARA_SET_VAR_VALUES
SET PROCESS_REQ_SEQ_ID = l_proc_req_seq_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE SET_VARIABLE_VALUE_ID = l_set_variable_value.set_variable_value_id;
select status_code into l_process_status
from fnd_concurrent_requests
where request_id = l_request_id;
procedure update_process_status (p_process_request_id in number,
p_fnd_request_id in number) IS
l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.UPDATE_PROCESS_STATUS';
update PAY_PROCESS_REQUESTS
set fnd_request_id = p_fnd_request_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
where process_req_seq_id = p_process_request_id;
END update_process_status;
update_process_status(p_request_id, l_fnd_request_id);
select ppr.fnd_request_id
from PAY_PROCESS_REQUESTS ppr,
fnd_concurrent_requests fcr
where ppr.fnd_request_id is not null
and ppr.PARENT_FND_REQUEST_ID is null
and ppr.fnd_request_id = fcr.request_id
and fcr.phase_code = 'C'
order by fnd_request_id desc ;
select ppr_child.fnd_request_id
from PAY_PROCESS_REQUESTS ppr_child,
pay_process_requests ppr_parent,
fnd_concurrent_requests fcr
where ppr_child.parent_fnd_request_id = p_fnd_request_id
and ppr_parent.fnd_request_id = ppr_child.parent_fnd_request_id
and ppr_parent.fnd_request_id = fcr.request_id
and fcr.phase_code = 'C'
order by ppr_child.fnd_request_id desc ;
select ppsv.set_variable_value_id
from pay_para_set_var_values ppsv,
pay_process_requests ppr
where ppr.fnd_request_id = p_fnd_request_id
and ppsv.process_req_seq_id = ppr.process_req_seq_id ;
l_delete_parent varchar2(2);
l_delete_parent := 'N';
delete
from pay_para_set_var_values
where set_variable_value_id = fnd_set_var_value_rec.set_variable_value_id;
delete
from pay_process_requests
where fnd_request_id = fnd_child_rec.fnd_request_id;
l_delete_parent := 'Y';
if (l_delete_parent = 'Y') then
-- Delete the variable values for the parent request
for fnd_set_var_value_rec in get_set_var_values(p_fnd_request_id)
loop
delete
from pay_para_set_var_values
where set_variable_value_id = fnd_set_var_value_rec.set_variable_value_id;
delete
from pay_process_requests
where fnd_request_id = p_fnd_request_id;
select ppr.fnd_request_id
from pay_process_requests ppr,
fnd_concurrent_requests fcr
where ppr.fnd_request_id =
( select min(fnd_request_id)
from pay_process_requests
where parent_fnd_request_id = p_fnd_request_id
)
and ppr.fnd_request_id = fcr.request_id
and fcr.phase_code = 'P';
procedure insert_child_request(p_assignment_action_id in number,
p_fnd_request_id in number) IS
--
-- Cursor to get the parent request details from the assignment action id
-- If there are more than one record with the same assignment action, get the
-- request with the maximum process_request_id.
CURSOR get_parent_request IS
select ppr_outer.process_request_id,
ppr_outer.fnd_request_id,
ppr_outer.process_flow_id
from pay_process_requests ppr_outer
where ppr_outer.process_request_id =
( SELECT max(ppr_inner.process_request_id)
FROM pay_process_requests ppr_inner
WHERE ppr_inner.assignment_action_id = p_assignment_action_id
AND ppr_inner.parent_fnd_request_id IS null
);
select 'Y'
from pay_process_requests
where fnd_request_id = p_fnd_request_id;
l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.INSERT_CHILD_REQUEST';
insert into PAY_PROCESS_REQUESTS ( process_req_seq_id,
process_request_id,
fnd_request_id,
parent_fnd_request_id,
assignment_action_id,
process_flow_id,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date,
status,
rollback_mode,
sync_mode,
validation_level ) values
(
pay_void_process_request_s1.NEXTVAL,
l_process_request_id,
p_fnd_request_id,
l_parent_fnd_req_id,
p_assignment_action_id,
l_process_flow_id,
null,
null,
null,
fnd_global.user_id,
sysdate,
'U',
'N',
'G',
'F' );
END INSERT_CHILD_REQUEST;