eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_FLOW_REQUESTS_PKG dependencies on PAY_PARA_SET_VAR_VALUES

Line 164: -- Create a record in pay_para_set_var_values for each parameter in the individual sets

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 (

Line 168: insert into pay_para_set_var_values (

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 (
169: set_variable_value_id,
170: process_req_seq_id,
171: set_variable_id,
172: set_variable_value,

Line 196: -- update pay_para_set_var_values with the value in set_var_val(i)

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
200: -- end loop

Line 209: update pay_para_set_var_values

205:
206: FOR source_set_var in csr_override_set_vars(p_param_details(no_of_row).set_var_id)
207: LOOP
208:
209: update pay_para_set_var_values
210: set set_variable_value = p_param_details(no_of_row).set_var_val,
211: last_update_date = sysdate,
212: last_updated_by = fnd_global.user_id,
213: last_update_login = fnd_global.login_id

Line 218: from pay_para_set_var_values

214: where set_variable_id = source_set_var.destin_set_var_id
215: and process_req_seq_id = l_curr_request_id;
216:
217: select set_variable_value into l_var_value
218: from pay_para_set_var_values
219: where set_Variable_id = source_set_var.destin_set_var_id
220: and process_req_seq_id = l_curr_request_id;
221:
222: if(p_param_details(no_of_row).default_type = 'INCREMENT_VALUE') THEN

Line 234: -- Update the pay_para_set_var_values with Assignment_action_id value

230: END LOOP;
231:
232: hr_utility.set_location(l_proc, 40);
233:
234: -- Update the pay_para_set_var_values with Assignment_action_id value
235:
236: FOR source_set_var in csr_override_set_vars(p_asg_set_var_id)
237: LOOP
238:

Line 239: update pay_para_set_var_values

235:
236: FOR source_set_var in csr_override_set_vars(p_asg_set_var_id)
237: LOOP
238:
239: update pay_para_set_var_values
240: set set_variable_value = p_asg_action,
241: last_update_date = sysdate,
242: last_updated_by = fnd_global.user_id,
243: last_update_login = fnd_global.login_id

Line 294: from pay_para_set_var_values ppsvv,

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
297: and ppsv.set_id = p_set_id
298: and ppsvv.process_req_seq_id = p_request_id

Line 445: -- Update the process_req_seq_id column in Pay_para_set_var_values

441:
442: insert_child_request(l_assignment_action_id,
443: l_request_id);
444:
445: -- Update the process_req_seq_id column in Pay_para_set_var_values
446:
447: open get_proc_req_seq_id(l_request_id);
448: fetch get_proc_req_seq_id into l_proc_req_seq_id;
449: close get_proc_req_seq_id;

Line 454: UPDATE PAY_PARA_SET_VAR_VALUES

450:
451: FOR l_set_variable_value in get_process_params(l_set_id.set_id)
452: LOOP
453: --
454: UPDATE PAY_PARA_SET_VAR_VALUES
455: SET PROCESS_REQ_SEQ_ID = l_proc_req_seq_id,
456: last_update_date = sysdate,
457: last_updated_by = fnd_global.user_id,
458: last_update_login = fnd_global.login_id

Line 595: -- PAY_PARA_SET_VAR_VALUES.

591: --
592: -- Description:
593: -- This function is called from the UI and purges the completed requests and
594: -- associated parameter values from the tables PAY_PROCESS_REQUESTS and
595: -- PAY_PARA_SET_VAR_VALUES.
596: --
597: -- ----------------------------------------------------------------------------
598: procedure purge_requests(p_fnd_request_id in number default null,
599: p_message out NOCOPY varchar2) IS

Line 628: from pay_para_set_var_values ppsv,

624: --
625: -- Cursor to get the Variable values for the request being deleted
626: CURSOR get_set_var_values(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
627: select ppsv.set_variable_value_id
628: from pay_para_set_var_values ppsv,
629: pay_process_requests ppr
630: where ppr.fnd_request_id = p_fnd_request_id
631: and ppsv.process_req_seq_id = ppr.process_req_seq_id ;
632: --

Line 659: from pay_para_set_var_values

655: for fnd_set_var_value_rec in get_set_var_values(fnd_child_rec.fnd_request_id)
656: loop
657:
658: delete
659: from pay_para_set_var_values
660: where set_variable_value_id = fnd_set_var_value_rec.set_variable_value_id;
661:
662: end loop;
663:

Line 681: from pay_para_set_var_values

677: for fnd_set_var_value_rec in get_set_var_values(p_fnd_request_id)
678: loop
679:
680: delete
681: from pay_para_set_var_values
682: where set_variable_value_id = fnd_set_var_value_rec.set_variable_value_id;
683:
684: end loop;
685: