DBA Data[Home] [Help]

APPS.PQH_ATTRIBUTE_RANGES_PKG dependencies on HR_API

Line 1352: If nvl(l_range_name,'xXx') <> nvl(l_prev_range_name,hr_api.g_varchar2) then

1348: --
1349: --
1350: -- Check if there is a change in rule name
1351: --
1352: If nvl(l_range_name,'xXx') <> nvl(l_prev_range_name,hr_api.g_varchar2) then
1353: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);
1354: --
1355: If cnt > 0 then
1356: hr_utility.set_location('Rules exist '||l_proc, 6);

Line 1768: nvl(l_range_name,'xXx') <> nvl(l_prev_range_name,hr_api.g_varchar2) then

1764: --
1765: -- Check if there is a change in rule name
1766: --
1767: If l_routing_category_id <> l_prev_routing_category_id OR
1768: nvl(l_range_name,'xXx') <> nvl(l_prev_range_name,hr_api.g_varchar2) then
1769: --
1770: hr_utility.set_location('New rule:'||l_range_name ||l_proc, 6);
1771: --
1772: If cnt > 0 then