APPS.PAY_RETRO_STATUS_INTERNAL dependencies on PAY_RETRO_ASSIGNMENTS

Line 14: subtype t_retro_asg_rec is pay_retro_assignments%rowtype;

10:
11: --
12: -- Global Definitions
13: --
14: subtype t_retro_asg_rec is pay_retro_assignments%rowtype;
15: subtype t_retro_ent_rec is pay_retro_entries%rowtype;
16:
17: --
18: -- ----------------------------------------------------------------------------

Line 31: from pay_retro_assignments pra

27: l_retro_assignment_id number;
28: cursor csr_unproc_retro_asg
29: is
30: select pra.retro_assignment_id
31: from pay_retro_assignments pra
32: where pra.assignment_id = p_assignment_id
33: and pra.retro_assignment_action_id is null
34: and pra.superseding_retro_asg_id is null
35: and approval_status in ('P','A','D');

Line 1136: from pay_retro_assignments

1132: --
1133: cursor csr_lock_retro_asg
1134: is
1135: select *
1136: from pay_retro_assignments
1137: where retro_assignment_id = p_retro_assignment_id
1138: for update nowait;
1139: begin
1140: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1160: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');

1156: Exception
1157: When HR_Api.Object_Locked then
1158: --
1159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1160: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1161: fnd_message.raise_error;
1162: end lock_retro_asg;
1163: --
1164: -- ----------------------------------------------------------------------------

Line 1247: l_old_approval_status pay_retro_assignments.approval_status%type;

1243: l_new_ra_rec t_retro_asg_rec;
1244: l_business_group_id number;
1245: l_payroll_id number;
1246: l_reprocess_date date;
1247: l_old_approval_status pay_retro_assignments.approval_status%type;
1248: l_approval_status pay_retro_assignments.approval_status%type;
1249: l_new_approval_status pay_retro_assignments.approval_status%type;
1250: l_new_reprocess_date date;
1251: l_new_start_date date;

Line 1248: l_approval_status pay_retro_assignments.approval_status%type;

1244: l_business_group_id number;
1245: l_payroll_id number;
1246: l_reprocess_date date;
1247: l_old_approval_status pay_retro_assignments.approval_status%type;
1248: l_approval_status pay_retro_assignments.approval_status%type;
1249: l_new_approval_status pay_retro_assignments.approval_status%type;
1250: l_new_reprocess_date date;
1251: l_new_start_date date;
1252: --

Line 1249: l_new_approval_status pay_retro_assignments.approval_status%type;

1245: l_payroll_id number;
1246: l_reprocess_date date;
1247: l_old_approval_status pay_retro_assignments.approval_status%type;
1248: l_approval_status pay_retro_assignments.approval_status%type;
1249: l_new_approval_status pay_retro_assignments.approval_status%type;
1250: l_new_reprocess_date date;
1251: l_new_start_date date;
1252: --
1253: cursor csr_app_status(p_retro_asg_id in number)

Line 1256: from pay_retro_assignments

1252: --
1253: cursor csr_app_status(p_retro_asg_id in number)
1254: is
1255: select approval_status
1256: from pay_retro_assignments
1257: where retro_assignment_id = p_retro_asg_id;
1258:
1259: l_proc varchar2(72) := g_package||'create_super_retro_asg';
1260: begin

Line 1446: update pay_retro_assignments

1442: or (l_new_start_date is not null)
1443: or (l_new_approval_status is not null) then
1444: hr_utility.set_location(l_proc, 80);
1445: --
1446: update pay_retro_assignments
1447: set
1448: reprocess_date = nvl(l_new_reprocess_date, reprocess_date)
1449: ,start_date = nvl(l_new_start_date, start_date)
1450: ,approval_status = nvl(l_new_approval_status, approval_status)

Line 1593: update pay_retro_assignments

1589: hr_utility.set_location(l_proc, 60);
1590: --
1591: -- Now update the retro assignment.
1592: --
1593: update pay_retro_assignments
1594: set reprocess_date = l_new_rec.reprocess_date
1595: ,start_date = l_new_rec.start_date
1596: ,approval_status = l_new_rec.approval_status
1597: where retro_assignment_id = p_retro_assignment_id;

Line 1679: update pay_retro_assignments

1675: or (l_start_date < l_old_rec.start_date) then
1676: --
1677: hr_utility.set_location(l_proc, 40);
1678: --
1679: update pay_retro_assignments
1680: set reprocess_date = least(l_reprocess_date, l_old_rec.reprocess_date)
1681: ,start_date = least(l_start_date, l_old_rec.start_date)
1682: where retro_assignment_id = p_retro_assignment_id;
1683: end if;

Line 1707: from pay_retro_assignments

1703: (p_retro_asg_id number
1704: ,p_asg_id number)
1705: is
1706: select retro_assignment_id
1707: from pay_retro_assignments
1708: where superseding_retro_asg_id = p_retro_asg_id
1709: ;
1710: --
1711: begin

Line 1768: update pay_retro_assignments

1764: ,l_old_rec.assignment_id) loop
1765: --
1766: l_replaced_retro_asg_id := l_rec.retro_assignment_id;
1767: --
1768: update pay_retro_assignments
1769: set superseding_retro_asg_id = null
1770: where retro_assignment_id = l_replaced_retro_asg_id;
1771:
1772: end loop;

Line 1778: delete from pay_retro_assignments

1774: hr_utility.set_location(l_proc, 60);
1775: --
1776: -- Delete this retro assignment.
1777: --
1778: delete from pay_retro_assignments
1779: where retro_assignment_id = p_retro_assignment_id;
1780:
1781: --
1782: -- Set out variable.

Line 2219: l_old_approval_status pay_retro_assignments.approval_status%type;

2215: l_old_ra_rec t_retro_asg_rec;
2216: l_business_group_id number;
2217: l_payroll_id number;
2218: l_reprocess_date date;
2219: l_old_approval_status pay_retro_assignments.approval_status%type;
2220: l_new_approval_status pay_retro_assignments.approval_status%type;
2221: l_new_reprocess_date date;
2222:
2223: l_proc varchar2(72) := g_package||'update_reprocess_date';

Line 2220: l_new_approval_status pay_retro_assignments.approval_status%type;

2216: l_business_group_id number;
2217: l_payroll_id number;
2218: l_reprocess_date date;
2219: l_old_approval_status pay_retro_assignments.approval_status%type;
2220: l_new_approval_status pay_retro_assignments.approval_status%type;
2221: l_new_reprocess_date date;
2222:
2223: l_proc varchar2(72) := g_package||'update_reprocess_date';
2224: begin