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.HR_POSITION_API dependencies on PER_ALL_POSITIONS

Line 129: from per_all_positions

125: from hr_all_positions_f
126: where position_definition_id = p_position_definition_id)
127: or exists (
128: select null
129: from per_all_positions
130: where position_definition_id = p_position_definition_id)
131: or exists (
132: select null
133: from per_mm_positions

Line 541: -- get the updated Object version number of the per_all_positions table

537: if g_debug then
538: hr_utility.set_location(l_proc, 30);
539: end if;
540: --
541: -- get the updated Object version number of the per_all_positions table
542: -- which is returned to the user as ovn of created row.
543: --
544: p_object_version_number := per_refresh_position.get_position_ovn;
545: --

Line 1164: -- get the updated Object version number of the per_all_positions table which

1160: if g_debug then
1161: hr_utility.set_location(l_proc, 50);
1162: end if;
1163: --
1164: -- get the updated Object version number of the per_all_positions table which
1165: -- is to be returned to the user as ovn of updated row.
1166: --
1167: p_object_version_number := per_refresh_position.get_position_ovn;
1168: --

Line 1617: -- Procedure synchronize_per_all_positions

1613: --
1614: end maintain_valid_grades;
1615: --
1616: --
1617: -- Procedure synchronize_per_all_positions
1618: --
1619: Procedure synchronize_per_all_positions
1620: (p_position_id in hr_all_positions_f.position_id%TYPE
1621: ,p_effective_date in date

Line 1619: Procedure synchronize_per_all_positions

1615: --
1616: --
1617: -- Procedure synchronize_per_all_positions
1618: --
1619: Procedure synchronize_per_all_positions
1620: (p_position_id in hr_all_positions_f.position_id%TYPE
1621: ,p_effective_date in date
1622: ,p_datetrack_mode in varchar2
1623: ,p_object_version_number in out nocopy hr_all_positions_f.object_version_number%TYPE

Line 1635: from per_all_positions

1631: l_proc varchar2(30);
1632: --
1633: cursor c1 (p_position_id in number) is
1634: select object_version_number
1635: from per_all_positions
1636: where position_id = p_position_id;
1637: --
1638: --
1639: begin

Line 1642: l_proc :='synchronize_per_all_positions';

1638: --
1639: begin
1640:
1641: if g_debug then
1642: l_proc :='synchronize_per_all_positions';
1643: hr_utility.set_location('Entering:'||l_proc, 1);
1644: end if;
1645: --
1646: -- Check mandatory parameters have been set

Line 1676: -- lock row in per_all_positions

1672: */
1673: --
1674: if p_datetrack_mode = hr_api.g_zap then
1675: --
1676: -- lock row in per_all_positions
1677: --
1678: if g_debug then
1679: hr_utility.set_location(l_proc, 40);
1680: end if;

Line 1704: -- delete row from per_all_positions

1700: per_pos_shd.lck(
1701: p_position_id => p_position_id
1702: ,p_object_version_number => l_ovn);
1703: --
1704: -- delete row from per_all_positions
1705: --
1706: if g_debug then
1707: hr_utility.set_location(l_proc, 70);
1708: end if;

Line 1728: -- update in per_all_positions table

1724: p_datetrack_mode = hr_api.g_future_change or
1725: p_datetrack_mode is null
1726: then
1727: --
1728: -- update in per_all_positions table
1729: --
1730: begin
1731: -- if l_effective_end_date <> hr_api.g_eot then
1732: -- lock the position rows explicitly

Line 1774: -- per_all_positions

1770: if g_debug then
1771: hr_utility.set_location(l_proc, 100);
1772: end if;
1773: -- call refresh_position procedure to replicate changes in
1774: -- per_all_positions
1775: --
1776: per_refresh_position.refresh_single_position
1777: (p_position_id => p_position_id
1778: ,p_effective_date => p_effective_date

Line 1793: end synchronize_per_all_positions;

1789: hr_utility.set_location( 'Leaving : ' || l_proc, 200);
1790: end if;
1791: --
1792:
1793: end synchronize_per_all_positions;
1794: --
1795: --
1796: -- ----------------------------------------------------------------------------
1797: -- |------------------------< create_position >----------------------|

Line 2066: from per_all_positions

2062: and (business_group_id = p_business_group_id or business_group_id is null);
2063: --
2064: cursor csr_get_nondt_pos(p_position_id in number) is
2065: select object_version_number
2066: from per_all_positions
2067: where position_id = p_position_id;
2068: --
2069: -- bug 2271064 get per_position_definitions segment values where
2070: -- position_definition_id is known

Line 2684: -- Insert in per_all_positions table

2680: , p_position_id => l_position_id
2681: , p_position_definition_id => l_position_definition_id
2682: );
2683: --
2684: -- Insert in per_all_positions table
2685: --
2686: begin
2687: --
2688: -- call refresh_position procedure to replicate changes in per_all_positions

Line 2688: -- call refresh_position procedure to replicate changes in per_all_positions

2684: -- Insert in per_all_positions table
2685: --
2686: begin
2687: --
2688: -- call refresh_position procedure to replicate changes in per_all_positions
2689: --
2690: if g_debug then
2691: hr_utility.set_location ( l_proc, 1000);
2692: hr_utility.set_location ( 'POSITION ID : ' || l_position_id || l_proc, 1000);

Line 2695: synchronize_per_all_positions

2691: hr_utility.set_location ( l_proc, 1000);
2692: hr_utility.set_location ( 'POSITION ID : ' || l_position_id || l_proc, 1000);
2693: end if;
2694: --
2695: synchronize_per_all_positions
2696: (p_position_id => l_position_id
2697: ,p_effective_date => trunc(p_effective_date)
2698: ,p_datetrack_mode => null
2699: ,p_object_version_number => l_object_version_number

Line 3907: -- Refresh per_all_positions

3903: , p_position_definition_id => l_position_definition_id
3904: );
3905: end if;
3906: --
3907: -- Refresh per_all_positions
3908: --
3909: begin
3910: --
3911: -- call refresh_position procedure to replicate changes in per_all_positions

Line 3911: -- call refresh_position procedure to replicate changes in per_all_positions

3907: -- Refresh per_all_positions
3908: --
3909: begin
3910: --
3911: -- call refresh_position procedure to replicate changes in per_all_positions
3912: --
3913: if g_debug then
3914: hr_utility.set_location ( l_proc, 1000);
3915: end if;

Line 3917: synchronize_per_all_positions

3913: if g_debug then
3914: hr_utility.set_location ( l_proc, 1000);
3915: end if;
3916: --
3917: synchronize_per_all_positions
3918: (p_position_id => p_position_id
3919: ,p_effective_date => p_effective_date
3920: ,p_datetrack_mode => p_datetrack_mode
3921: ,p_object_version_number => l_object_version_number

Line 4368: -- call refresh_position procedure to replicate changes in per_all_positions

4364:
4365: --
4366: begin
4367: --
4368: -- call refresh_position procedure to replicate changes in per_all_positions
4369: --
4370: if g_debug then
4371: hr_utility.set_location ( l_proc, 1000);
4372: end if;

Line 4374: synchronize_per_all_positions

4370: if g_debug then
4371: hr_utility.set_location ( l_proc, 1000);
4372: end if;
4373: --
4374: synchronize_per_all_positions
4375: (p_position_id => p_position_id
4376: ,p_effective_date => p_effective_date
4377: ,p_datetrack_mode => p_datetrack_mode
4378: ,p_object_version_number => l_object_version_number