[Home] [Help]
167: fetch process_assignments into v_assignment_id;
168: exit when process_assignments%notfound;
169: --
170: if g_debug then
171: hr_utility.set_location('pysgiraa: Before calling hr_nonrun_asact.insact',4);
172: end if;
173: --
174: open next_action_id ;
175: fetch next_action_id into v_next_action_id;
174: open next_action_id ;
175: fetch next_action_id into v_next_action_id;
176: close next_action_id;
177: --
178: hr_nonrun_asact.insact( v_next_action_id,
179: v_assignment_id,
180: p_payroll_action_id,
181: p_chunk,
182: null );
183:
184:
185: for arch_rec in csr_archive_action_id(v_assignment_id) loop
186:
187: hr_nonrun_asact.insint(lockingactid => v_next_action_id
188: ,lockedactid => arch_rec.assignment_action_id
189: );
190: for rep_rec in csr_report_action_id(arch_rec.assignment_action_id) loop
191:
188: ,lockedactid => arch_rec.assignment_action_id
189: );
190: for rep_rec in csr_report_action_id(arch_rec.assignment_action_id) loop
191:
192: hr_nonrun_asact.insint(lockingactid => v_next_action_id
193: ,lockedactid => rep_rec.report_action_id
194: );
195:
196: end loop;
198:
199: end loop;
200: --
201: if g_debug then
202: hr_utility.set_location('pysgiraa: After calling hr_nonrun_asact.insact',4);
203: end if;
204: end loop;
205: --
206: close process_assignments;