DBA Data[Home] [Help]

APPS.PQH_BFS_BUS dependencies on HR_API

Line 51: and nvl(p_budget_fund_src_id,hr_api.g_number)

47: (p_budget_fund_src_id => p_budget_fund_src_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_budget_fund_src_id,hr_api.g_number)
52: <> pqh_bfs_shd.g_old_rec.budget_fund_src_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 123: and nvl(p_budget_element_id,hr_api.g_number)

119: (p_budget_fund_src_id => p_budget_fund_src_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_element_id,hr_api.g_number)
124: <> nvl(pqh_bfs_shd.g_old_rec.budget_element_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_element_id value exists in pqh_budget_elements table

Line 124: <> nvl(pqh_bfs_shd.g_old_rec.budget_element_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_budget_element_id,hr_api.g_number)
124: <> nvl(pqh_bfs_shd.g_old_rec.budget_element_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if budget_element_id value exists in pqh_budget_elements table
128: --

Line 245: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)

241: (p_budget_fund_src_id => p_budget_fund_src_id,
242: p_object_version_number => p_object_version_number);
243: --
244: if (l_api_updating
245: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)
246: <> nvl(pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)
247: or not l_api_updating) and p_cost_allocation_keyflex_id is not null then
248: --
249: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table

Line 246: <> nvl(pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)

242: p_object_version_number => p_object_version_number);
243: --
244: if (l_api_updating
245: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)
246: <> nvl(pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)
247: or not l_api_updating) and p_cost_allocation_keyflex_id is not null then
248: --
249: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table
250: --