eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1104: from pay_retro_assignments

1100: --
1101: cursor csr_lock_retro_asg
1102: is
1103: select *
1104: from pay_retro_assignments
1105: where retro_assignment_id = p_retro_assignment_id
1106: for update nowait;
1107: begin
1108: hr_utility.set_location('Entering:'|| l_proc, 10);

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

1124: Exception
1125: When HR_Api.Object_Locked then
1126: --
1127: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1128: fnd_message.set_token('TABLE_NAME', 'pay_retro_assignments');
1129: fnd_message.raise_error;
1130: end lock_retro_asg;
1131: --
1132: -- ----------------------------------------------------------------------------

Line 1215: l_old_approval_status pay_retro_assignments.approval_status%type;

1211: l_new_ra_rec t_retro_asg_rec;
1212: l_business_group_id number;
1213: l_payroll_id number;
1214: l_reprocess_date date;
1215: l_old_approval_status pay_retro_assignments.approval_status%type;
1216: l_approval_status pay_retro_assignments.approval_status%type;
1217: l_new_approval_status pay_retro_assignments.approval_status%type;
1218: l_new_reprocess_date date;
1219: l_new_start_date date;

Line 1216: l_approval_status pay_retro_assignments.approval_status%type;

1212: l_business_group_id number;
1213: l_payroll_id number;
1214: l_reprocess_date date;
1215: l_old_approval_status pay_retro_assignments.approval_status%type;
1216: l_approval_status pay_retro_assignments.approval_status%type;
1217: l_new_approval_status pay_retro_assignments.approval_status%type;
1218: l_new_reprocess_date date;
1219: l_new_start_date date;
1220: --

Line 1217: l_new_approval_status pay_retro_assignments.approval_status%type;

1213: l_payroll_id number;
1214: l_reprocess_date date;
1215: l_old_approval_status pay_retro_assignments.approval_status%type;
1216: l_approval_status pay_retro_assignments.approval_status%type;
1217: l_new_approval_status pay_retro_assignments.approval_status%type;
1218: l_new_reprocess_date date;
1219: l_new_start_date date;
1220: --
1221: cursor csr_app_status(p_retro_asg_id in number)

Line 1224: from pay_retro_assignments

1220: --
1221: cursor csr_app_status(p_retro_asg_id in number)
1222: is
1223: select approval_status
1224: from pay_retro_assignments
1225: where retro_assignment_id = p_retro_asg_id;
1226:
1227: l_proc varchar2(72) := g_package||'create_super_retro_asg';
1228: begin

Line 1412: update pay_retro_assignments

1408: or (l_new_start_date is not null)
1409: or (l_new_approval_status is not null) then
1410: hr_utility.set_location(l_proc, 80);
1411: --
1412: update pay_retro_assignments
1413: set
1414: reprocess_date = nvl(l_new_reprocess_date, reprocess_date)
1415: ,start_date = nvl(l_new_start_date, start_date)
1416: ,approval_status = nvl(l_new_approval_status, approval_status)

Line 1573: update pay_retro_assignments

1569: if l_new_rec.approval_status <> 'F'
1570: then
1571: --
1572: hr_utility.set_location(l_proc, 65);
1573: update pay_retro_assignments
1574: set reprocess_date = l_new_rec.reprocess_date
1575: ,start_date = l_new_rec.start_date
1576: ,approval_status = l_new_rec.approval_status
1577: where retro_assignment_id = p_retro_assignment_id;

Line 1586: update pay_retro_assignments

1582: open csr_sys_ent_exists;
1583: fetch csr_sys_ent_exists into l_dummy;
1584: if csr_sys_ent_exists%found then
1585: hr_utility.set_location(l_proc, 85);
1586: update pay_retro_assignments
1587: set reprocess_date = l_new_rec.reprocess_date
1588: ,start_date = l_new_rec.start_date
1589: ,approval_status = l_new_rec.approval_status
1590: where retro_assignment_id = p_retro_assignment_id;

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

1592: -- Trying to update status to Deferred Forever/ Complete
1593: -- for user generated retro entry
1594: hr_utility.set_location (l_proc, 87);
1595: fnd_message.set_name('PER', 'PAY_500024_SYS_ENTRY_NO_EXIST');
1596: fnd_message.set_token('TABLE_NAME','pay_retro_assignments');
1597: fnd_message.raise_error;
1598: end if;
1599: close csr_sys_ent_exists;
1600: End if;

Line 1682: update pay_retro_assignments

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

Line 1705: from pay_retro_assignments

1701: l_count number := 0;
1702: --
1703: cursor csr_sys_retro_asgs is
1704: select null
1705: from pay_retro_assignments
1706: where retro_assignment_id = p_retro_assignment_id
1707: and retro_assignment_action_id is null
1708: for update nowait;
1709:

Line 1716: update pay_retro_assignments

1712: for csr_sys_rec in csr_sys_retro_asgs loop
1713: /*Updating the approval status and retro assignment action id to make sure
1714: that the retro assignments will not get picked up in the next retopay.*/
1715: hr_utility.set_location('Updating the record : '|| l_proc, 20);
1716: update pay_retro_assignments
1717: set retro_assignment_action_id = -1,
1718: approval_status = 'F'
1719: where current of csr_sys_retro_asgs;
1720: hr_utility.set_location('Updation has been done : '|| l_proc, 30);

Line 1744: from pay_retro_assignments

1740: (p_retro_asg_id number
1741: ,p_asg_id number)
1742: is
1743: select retro_assignment_id
1744: from pay_retro_assignments
1745: where superseding_retro_asg_id = p_retro_asg_id
1746: ;
1747: --
1748: begin

Line 1814: update pay_retro_assignments

1810: ,l_old_rec.assignment_id) loop
1811: --
1812: l_replaced_retro_asg_id := l_rec.retro_assignment_id;
1813: --
1814: update pay_retro_assignments
1815: set superseding_retro_asg_id = null
1816: where retro_assignment_id = l_replaced_retro_asg_id;
1817:
1818: end loop;

Line 1823: delete from pay_retro_assignments

1819: hr_utility.set_location(l_proc, 100);
1820: --
1821: -- Delete this retro assignment.
1822: --
1823: delete from pay_retro_assignments
1824: where retro_assignment_id = p_retro_assignment_id;
1825: hr_utility.set_location(l_proc, 110);
1826: --
1827: -- Set out variable.

Line 2264: l_old_approval_status pay_retro_assignments.approval_status%type;

2260: l_old_ra_rec t_retro_asg_rec;
2261: l_business_group_id number;
2262: l_payroll_id number;
2263: l_reprocess_date date;
2264: l_old_approval_status pay_retro_assignments.approval_status%type;
2265: l_new_approval_status pay_retro_assignments.approval_status%type;
2266: l_new_reprocess_date date;
2267:
2268: l_proc varchar2(72) := g_package||'update_reprocess_date';

Line 2265: l_new_approval_status pay_retro_assignments.approval_status%type;

2261: l_business_group_id number;
2262: l_payroll_id number;
2263: l_reprocess_date date;
2264: l_old_approval_status pay_retro_assignments.approval_status%type;
2265: l_new_approval_status pay_retro_assignments.approval_status%type;
2266: l_new_reprocess_date date;
2267:
2268: l_proc varchar2(72) := g_package||'update_reprocess_date';
2269: begin