APPS.PAY_GB_RTI_FPS dependencies on PAY_ASSIGNMENT_ACTIONS_S

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

6884: end if;
6885: end if; --if (l_flag = 'Y') then
6886:
6887: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
6888: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6889: -- Insert assignment into pay_assignment_actions
6890: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
6891: End if;
6892:

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

6977:
6978: if ((asg_rec.asg_act_id = l_aggr_min_act_id) and (l_earlier_processed = 0)) then
6979: hr_utility.set_location('Creating Assignment Action for assignment_id '||asg_rec.assignment_id, 50);
6980:
6981: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6982: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
6983: -- get the assigment action id of the prepayment payroll action id for the current assignment.
6984: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
6985: FETCH csr_prepay_asg_act_details

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

6994: hr_utility.set_location('Creating other Assignment Action ids for assignment_id '||asg_rec.assignment_id, 50);
6995:
6996: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)
6997: loop*/
6998: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6999: hr_utility.set_location('Creating action for asg '||c_asg.asg_id, 50);
7000: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );
7001: hr_utility.set_location('Created action for asg '||c_asg.asg_id, 50);*/
7002:

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

7010: FETCH csr_agg_all_asg_act_creat
7011: INTO l_asg_id;
7012:
7013: EXIT WHEN csr_agg_all_asg_act_creat%NOTFOUND;
7014: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7015: hr_utility.set_location('Creating action for asg '||l_asg_id, 50);
7016: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );
7017: hr_utility.set_location('Created action for asg '||l_asg_id, 50);
7018:

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

7055:
7056: ELSIF l_flag1 = 'Y' THEN
7057: -- Create one assignment action for every assignment
7058: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7059: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7060:
7061: -- Insert assignment into pay_assignment_actions
7062: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7063: -- get the assigment action id of the prepayment payroll action id for the current assignment.

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

7102: hr_utility.set_location('l_ni_aggr_max_act_id:'|| l_ni_aggr_max_act_id , 50);
7103: hr_utility.set_location('asg_rec.asg_act_id:'|| asg_rec.asg_act_id , 50);
7104: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7105: hr_utility.set_location('Creating action for rti rpt asg:'|| l_ni_rpt_asg_id, 50);
7106: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7107: -- Insert assignment into pay_assignment_actions
7108: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7109: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7110: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);