[Home] [Help]
61: l_flow_set_id pay_process_flows.set_id%TYPE;
62: l_var_value varchar2(255);
63:
64:
65: -- Cursor for identifying the sets associated with a flow's individual processes
66: CURSOR csr_process_sets(p_process_flow_id pay_process_flows.process_flow_id%TYPE)
67: is
68: select set_id, process_flow_set_id
69: from PAY_PROCESS_FLOW_SETS
119:
120: hr_utility.set_location(l_proc, 10);
121:
122: select pay_void_process_request_s1.NEXTVAL
123: into l_curr_request_id from dual;
124:
125: -- Create a process request
126: insert into PAY_PROCESS_REQUESTS ( process_req_seq_id,
127: process_request_id,
160:
161: -- Find out the sets for the particular process (with process id)
162: FOR l_process_set in csr_process_sets(p_process_flow_id)
163: LOOP
164: -- Create a record in pay_para_set_var_values for each parameter in the individual sets
165: FOR l_set_param in csr_set_parameters(l_process_set.set_id)
166: LOOP
167:
168: insert into pay_para_set_var_values (
197: -- if the default type is 'INCREMENT_VALUE', then
198: -- increment the var value (gets passed back as out variable)
199: -- end loop
200: -- end loop
201: -- Find out the individual process associated with that set
202:
203: FOR no_of_row in 1 .. p_no_of_params
204: LOOP
205:
259: -- ----------------------------------------------------------------------------
260: --
261: -- Description:
262: -- This procedure invokes a flow for all the requests in
263: -- The individual processes in the flow are invoked sequentially
264: -- THIS SHOULD BE A CONCURRENT REQUEST which can handle many assignments
265: -- parallely.
266: --
267: -- ----------------------------------------------------------------------------
831: -- ----------------------------------------------------------------------------
832: --
833: -- Description:
834: -- This procedure inserts the child requests in the pay_process_requests table.
835: -- This can be called from the wrapper packages of individual processes to
836: -- update the table before doing any other processing post request completion.
837: --
838: -- ----------------------------------------------------------------------------
839: procedure insert_child_request(p_assignment_action_id in number,