[Home] [Help]
4519: IF csr_persons_rec.person_id <> l_chk_person_id THEN
4520: --
4521: l_chk_person_id := csr_persons_rec.person_id;
4522: --
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
4538: l_chk_assignment_id := 0;
4539: FOR csr_rec IN csr_assignments_yearly(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
4540: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
4541: l_chk_assignment_id := csr_rec.assignment_id;
4542: SELECT pay_assignment_actions_s.NEXTVAL
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
4561: --
4562: FOR csr_rec IN csr_assignments(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
4563: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
4564: l_chk_assignment_id := csr_rec.assignment_id;
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
4613: l_arc_pactid := TO_NUMBER(get_parameters(p_actid,'REQUEST_ID'));
4614: --
4615: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP
4616: --
4617: SELECT pay_assignment_actions_s.NEXTVAL
4618: INTO l_actid
4619: FROM dual;
4620: --
4621: hr_nonrun_asact.insact(lockingactid => l_actid