232: open next_action_id;
233: fetch next_action_id into v_next_action_id;
234: close next_action_id;
235: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);
236: hr_nonrun_asact.insact(v_next_action_id,
237: process_rec.assignment_id,
238: p_payroll_action_id,
239: p_chunk,
240: null);
238: p_payroll_action_id,
239: p_chunk,
240: null);
241: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
242: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
243: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
244: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
245: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
246: end loop;
240: null);
241: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
242: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
243: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
244: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
245: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
246: end loop;
247: hr_utility.set_location('End of assignment_action_code',5);
248:
241: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
242: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
243: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
244: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
245: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
246: end loop;
247: hr_utility.set_location('End of assignment_action_code',5);
248:
249: ELSIF l_get_paysum_details.payment_summary_type = 'A'
264:
265: OPEN next_action_id;
266: FETCH next_action_id into v_next_action_id;
267: CLOSE next_action_id;
268: hr_nonrun_asact.insact(v_next_action_id,
269: csr_rec.assignment_id,
270: p_payroll_action_id,
271: p_chunk,
272: null);
269: csr_rec.assignment_id,
270: p_payroll_action_id,
271: p_chunk,
272: null);
273: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
274: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
275:
276: IF g_debug
277: THEN
270: p_payroll_action_id,
271: p_chunk,
272: null);
273: hr_nonrun_asact.insint(v_next_action_id,csr_rec.assignment_action_id);
274: hr_nonrun_asact.insint(v_next_action_id,csr_rec.datafile_action_id);
275:
276: IF g_debug
277: THEN
278: hr_utility.set_location('Assignment_ID '||csr_rec.assignment_id,35);