DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on HR_NONRUN_ASACT

Line 4275: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );

4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);
4272:
4273: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4274: -- Insert assignment into pay_assignment_actions
4275: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
4276:
4277: --Locking mechanism
4278: -- If NI Aggr and non aggr
4279: if (NVL(asg_rec.per_ni_flag,'N') = 'Y' and NVL(asg_rec.per_agg_flag,'N') = 'N') or (NVL(asg_rec.per_ni_flag,'N') = 'N')then

Line 4287: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);

4283:
4284: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4285: hr_utility.set_location('lockingactid '||lockingactid, 50);
4286: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4287: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4288: else
4289: if l_fps_run_date is not null then
4290:
4291: for asg_actions in csr_all_actions_after_fps(asg_rec.assignment_id,l_pact_id)

Line 4295: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);

4291: for asg_actions in csr_all_actions_after_fps(asg_rec.assignment_id,l_pact_id)
4292: loop
4293: hr_utility.set_location('lockingactid '||lockingactid, 50);
4294: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4295: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4296: end loop;
4297: else
4298: for asg_actions in csr_all_actions_tax_year(asg_rec.assignment_id)
4299: loop

Line 4303: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);

4299: loop
4300: hr_utility.set_location('New Starter ', 50);
4301: hr_utility.set_location('lockingactid '||lockingactid, 50);
4302: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4303: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4304: end loop;
4305: end if;
4306: end if;
4307: end if;

Line 4317: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);

4313:
4314: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4315: hr_utility.set_location('lockingactid '||lockingactid, 50);
4316: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4317: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4318: else
4319: if l_fps_run_date is not null then
4320:
4321: for asg_actions in csr_all_actions_after_fps_agg(asg_rec.person_id,l_pact_id)

Line 4325: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);

4321: for asg_actions in csr_all_actions_after_fps_agg(asg_rec.person_id,l_pact_id)
4322: loop
4323: hr_utility.set_location('lockingactid '||lockingactid, 50);
4324: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4325: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4326: end loop;
4327: else
4328: for asg_actions in csr_all_actions_tax_year_agg(asg_rec.person_id)
4329: loop

Line 4333: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);

4329: loop
4330: hr_utility.set_location('New Starter ', 50);
4331: hr_utility.set_location('lockingactid '||lockingactid, 50);
4332: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4333: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4334: end loop;
4335: end if;
4336: end if;
4337: end if;

Line 4412: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );

4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);
4409:
4410: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4411: -- Insert assignment into pay_assignment_actions
4412: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
4413:
4414: --NI Aggr
4415: hr_utility.set_location('Action Created for RTI Reporting Ni Aggr asg : '||l_ni_rpt_asg_id,20);
4416:

Line 4427: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);

4423:
4424: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4425: hr_utility.set_location('lockingactid '||lockingactid, 50);
4426: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4427: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4428: else
4429: if l_fps_run_date is not null then
4430:
4431: for asg_actions in csr_all_actions_after_fps(l_ni_rpt_asg_id,l_pact_id)

Line 4435: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);

4431: for asg_actions in csr_all_actions_after_fps(l_ni_rpt_asg_id,l_pact_id)
4432: loop
4433: hr_utility.set_location('lockingactid '||lockingactid, 50);
4434: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4435: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4436: end loop;
4437: else
4438: for asg_actions in csr_all_actions_tax_year(l_ni_rpt_asg_id)
4439: loop

Line 4443: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);

4439: loop
4440: hr_utility.set_location('New Starter ', 50);
4441: hr_utility.set_location('lockingactid '||lockingactid, 50);
4442: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4443: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4444: end loop;
4445: end if;
4446: end if;
4447: