72:
73: -- Cursor for identifying parameters in a set
74: CURSOR csr_set_parameters(p_csr_set_id PAY_PROCESS_FLOW_SETS.set_id%TYPE)
75: is
76: select * from pay_para_set_variables
77: where set_id = p_csr_set_id;
78: ---
79:
80: -- Cursor for identifying shared variables with flow parameters
288: order by process_flow_seq;
289:
290: -- Cursor for getting the variable values for a particular request.
291:
292: CURSOR get_process_params(p_set_id pay_para_set_variables.set_id%TYPE) is
293: select set_variable_value, set_variable_value_id
294: from pay_para_set_var_values ppsvv,
295: pay_para_set_variables ppsv
296: where ppsvv.set_variable_id = ppsv.set_variable_id
291:
292: CURSOR get_process_params(p_set_id pay_para_set_variables.set_id%TYPE) is
293: select set_variable_value, set_variable_value_id
294: from pay_para_set_var_values ppsvv,
295: pay_para_set_variables ppsv
296: where ppsvv.set_variable_id = ppsv.set_variable_id
297: and ppsv.set_id = p_set_id
298: and ppsvv.process_req_seq_id = p_request_id
299: order by ppsv.set_var_sequence;
385: -- Get the group id
386: BEGIN
387: --
388: select distinct group_id into l_group_id
389: from pay_para_set_variables
390: where set_id = l_set_id.set_id;
391: --
392: exception
393: when no_data_found then