4523: SELECT pay_assignment_actions_s.NEXTVAL
4524: INTO l_actid
4525: FROM dual;
4526: -- CREATE THE ARCHIVE ASSIGNMENT ACTION
4527: hr_nonrun_asact.insact(lockingactid => l_actid
4528: ,assignid => csr_persons_rec.assignment_id
4529: ,pactid => p_actid
4530: ,chunk => chunk
4531: ,greid => l_legal_employer);
4530: ,chunk => chunk
4531: ,greid => l_legal_employer);
4532: --
4533: END IF;
4534: hr_nonrun_asact.insint(l_actid,csr_persons_rec.assignment_action_id);
4535: END LOOP;
4536: ELSIF l_payroll_type = 'YEARLY' THEN ---- for yearly report
4537:
4538: l_chk_assignment_id := 0;
4543: INTO l_actid
4544: FROM dual;
4545: --Fnd_file.put_line(FND_FILE.LOG,'#######~~csr_rec.assignment_action_id :'||l_actid||','||csr_rec.assignment_action_id);
4546: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
4547: hr_nonrun_asact.insact(lockingactid => l_actid
4548: ,assignid => csr_rec.assignment_id
4549: ,pactid => p_actid
4550: ,chunk => chunk
4551: ,greid => l_legal_employer);
4551: ,greid => l_legal_employer);
4552: --
4553: END IF;
4554: IF csr_rec.assignment_action_id IS NOT NULL THEN
4555: --Fnd_file.put_line(FND_FILE.LOG,'#######~~hr_nonrun_asact.insint');
4556: hr_nonrun_asact.insint(l_actid,csr_rec.assignment_action_id);
4557: END IF;
4558: END LOOP;
4559: ELSE
4552: --
4553: END IF;
4554: IF csr_rec.assignment_action_id IS NOT NULL THEN
4555: --Fnd_file.put_line(FND_FILE.LOG,'#######~~hr_nonrun_asact.insint');
4556: hr_nonrun_asact.insint(l_actid,csr_rec.assignment_action_id);
4557: END IF;
4558: END LOOP;
4559: ELSE
4560: l_chk_assignment_id := 0;
4565: SELECT pay_assignment_actions_s.NEXTVAL
4566: INTO l_actid
4567: FROM dual;
4568: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
4569: hr_nonrun_asact.insact(lockingactid => l_actid
4570: ,assignid => csr_rec.assignment_id
4571: ,pactid => p_actid
4572: ,chunk => chunk
4573: ,greid => l_legal_employer);
4573: ,greid => l_legal_employer);
4574: --
4575: END IF;
4576: IF csr_rec.assignment_action_id IS NOT NULL THEN
4577: hr_nonrun_asact.insint(l_actid,csr_rec.assignment_action_id);
4578: END IF;
4579: END LOOP;
4580: END IF;
4581: --
4617: SELECT pay_assignment_actions_s.NEXTVAL
4618: INTO l_actid
4619: FROM dual;
4620: --
4621: hr_nonrun_asact.insact(lockingactid => l_actid
4622: ,assignid => csr_rec.assignment_id
4623: ,pactid => p_actid
4624: ,chunk => chunk);
4625: --
4622: ,assignid => csr_rec.assignment_id
4623: ,pactid => p_actid
4624: ,chunk => chunk);
4625: --
4626: hr_nonrun_asact.insint( lockingactid => l_actid
4627: ,lockedactid => csr_rec.assignment_action_id );
4628: --
4629: END LOOP;
4630: --