APPS.PQH_WFS_BUS dependencies on HR_API

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

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

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

119: (p_worksheet_fund_src_id => p_worksheet_fund_src_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)
124: <> nvl(pqh_wfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)
125: or not l_api_updating) and p_cost_allocation_keyflex_id is not null then
126: --
127: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table

Line 124: <> nvl(pqh_wfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)
124: <> nvl(pqh_wfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)
125: or not l_api_updating) and p_cost_allocation_keyflex_id is not null then
126: --
127: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table
128: --

Line 199: and nvl(p_worksheet_bdgt_elmnt_id,hr_api.g_number)

195: (p_worksheet_fund_src_id => p_worksheet_fund_src_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_worksheet_bdgt_elmnt_id,hr_api.g_number)
200: <> nvl(pqh_wfs_shd.g_old_rec.worksheet_bdgt_elmnt_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if worksheet_bdgt_elmnt_id value exists in pqh_worksheet_bdgt_elmnts table

Line 200: <> nvl(pqh_wfs_shd.g_old_rec.worksheet_bdgt_elmnt_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_worksheet_bdgt_elmnt_id,hr_api.g_number)
200: <> nvl(pqh_wfs_shd.g_old_rec.worksheet_bdgt_elmnt_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if worksheet_bdgt_elmnt_id value exists in pqh_worksheet_bdgt_elmnts table
204: --

Line 312: and nvl(p_distribution_percentage,hr_api.g_number)

308: (p_worksheet_fund_src_id => p_worksheet_fund_src_id,
309: p_object_version_number => p_object_version_number);
310: --
311: if (l_api_updating
312: and nvl(p_distribution_percentage,hr_api.g_number)
313: <> nvl(pqh_wel_shd.g_old_rec.distribution_percentage,hr_api.g_number)
314: or not l_api_updating)
315: and p_distribution_percentage is not null then
316: --

Line 313: <> nvl(pqh_wel_shd.g_old_rec.distribution_percentage,hr_api.g_number)

309: p_object_version_number => p_object_version_number);
310: --
311: if (l_api_updating
312: and nvl(p_distribution_percentage,hr_api.g_number)
313: <> nvl(pqh_wel_shd.g_old_rec.distribution_percentage,hr_api.g_number)
314: or not l_api_updating)
315: and p_distribution_percentage is not null then
316: --
317: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table