APPS.PAY_FLOW_REQUESTS_PKG dependencies on PAY_PARA_SET_OVERRIDE_VARS

Line 81: CURSOR csr_override_set_vars (p_csr_source_set_var_id pay_para_set_override_vars.source_set_var_id%TYPE)

77: where set_id = p_csr_set_id;
78: ---
79:
80: -- Cursor for identifying shared variables with flow parameters
81: CURSOR csr_override_set_vars (p_csr_source_set_var_id pay_para_set_override_vars.source_set_var_id%TYPE)
82: is
83: select destin_set_var_id, source_set_var_id
84: from pay_para_set_override_vars
85: where source_set_var_id = p_csr_source_set_var_id;

Line 84: from pay_para_set_override_vars

80: -- Cursor for identifying shared variables with flow parameters
81: CURSOR csr_override_set_vars (p_csr_source_set_var_id pay_para_set_override_vars.source_set_var_id%TYPE)
82: is
83: select destin_set_var_id, source_set_var_id
84: from pay_para_set_override_vars
85: where source_set_var_id = p_csr_source_set_var_id;
86: ---
87: l_proc varchar2(72) := 'PAY_FLOW_REQUESTS_PKG.CREATE_REQUEST';
88: ---

Line 195: -- for each record in pay_para_set_override_vars for this set_var_id(i)

191:
192: hr_utility.set_location(l_proc, 30);
193:
194: -- for each set_var_id in the param_array
195: -- for each record in pay_para_set_override_vars for this set_var_id(i)
196: -- update pay_para_set_var_values with the value in set_var_val(i)
197: -- if the default type is 'INCREMENT_VALUE', then
198: -- increment the var value (gets passed back as out variable)
199: -- end loop