APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 7555: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

7551: end if;
7552: end if; --if (l_flag = 'Y') then
7553:
7554: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
7555: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7556: -- Insert assignment into pay_assignment_actions
7557: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
7558: End if;
7559:

Line 7613: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

7609:
7610: if ((asg_rec.asg_act_id = l_aggr_min_act_id) and (l_earlier_processed = 0)) then
7611: hr_utility.set_location('Creating Assignment Action for assignment_id '||asg_rec.assignment_id, 50);
7612:
7613: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7614: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7615: -- get the assigment action id of the prepayment payroll action id for the current assignment.
7616: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
7617: FETCH csr_prepay_asg_act_details

Line 7630: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

7626: hr_utility.set_location('Creating other Assignment Action ids for assignment_id '||asg_rec.assignment_id, 50);
7627:
7628: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)
7629: loop*/
7630: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7631: hr_utility.set_location('Creating action for asg '||c_asg.asg_id, 50);
7632: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );
7633: hr_utility.set_location('Created action for asg '||c_asg.asg_id, 50);*/
7634:

Line 7646: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

7642: FETCH csr_agg_all_asg_act_creat
7643: INTO l_asg_id;
7644:
7645: EXIT WHEN csr_agg_all_asg_act_creat%NOTFOUND;
7646: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7647: hr_utility.set_location('Creating action for asg '||l_asg_id, 50);
7648: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );
7649: hr_utility.set_location('Created action for asg '||l_asg_id, 50);
7650:

Line 7691: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

7687:
7688: ELSIF l_flag1 = 'Y' THEN
7689: -- Create one assignment action for every assignment
7690: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7691: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7692:
7693: -- Insert assignment into pay_assignment_actions
7694: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7695: -- get the assigment action id of the prepayment payroll action id for the current assignment.

Line 7735: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

7731: FETCH csr_ni_aggr_max_act_id INTO l_ni_aggr_max_act_id;
7732: CLOSE csr_ni_aggr_max_act_id;
7733:
7734: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7735: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7736: -- Insert assignment into pay_assignment_actions
7737: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7738: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7739: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);