APPS.PQH_WEL_BUS dependencies on HR_API

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

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

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

119: (p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_worksheet_budget_set_id,hr_api.g_number)
124: <> nvl(pqh_wel_shd.g_old_rec.worksheet_budget_set_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table

Line 124: <> nvl(pqh_wel_shd.g_old_rec.worksheet_budget_set_id,hr_api.g_number)

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

Line 179: and nvl(p_element_type_id,hr_api.g_number)

175: (p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id,
176: p_object_version_number => p_object_version_number);
177: --
178: if (l_api_updating
179: and nvl(p_element_type_id,hr_api.g_number)
180: <> nvl(pqh_wel_shd.g_old_rec.element_type_id,hr_api.g_number)
181: or not l_api_updating) then
182: --
183: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table

Line 180: <> nvl(pqh_wel_shd.g_old_rec.element_type_id,hr_api.g_number)

176: p_object_version_number => p_object_version_number);
177: --
178: if (l_api_updating
179: and nvl(p_element_type_id,hr_api.g_number)
180: <> nvl(pqh_wel_shd.g_old_rec.element_type_id,hr_api.g_number)
181: or not l_api_updating) then
182: --
183: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table
184: --

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

222: (p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id,
223: p_object_version_number => p_object_version_number);
224: --
225: if (l_api_updating
226: and nvl(p_distribution_percentage,hr_api.g_number)
227: <> nvl(pqh_wel_shd.g_old_rec.distribution_percentage,hr_api.g_number)
228: or not l_api_updating)
229: and p_distribution_percentage is not null then
230: --

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

223: p_object_version_number => p_object_version_number);
224: --
225: if (l_api_updating
226: and nvl(p_distribution_percentage,hr_api.g_number)
227: <> nvl(pqh_wel_shd.g_old_rec.distribution_percentage,hr_api.g_number)
228: or not l_api_updating)
229: and p_distribution_percentage is not null then
230: --
231: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table