APPS.PQH_BCE_BUS dependencies on HR_API

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

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

Line 123: and nvl(p_dflt_elmnt_frequency,hr_api.g_varchar2)

119: (p_bdgt_cmmtmnt_elmnt_id => p_bdgt_cmmtmnt_elmnt_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_dflt_elmnt_frequency,hr_api.g_varchar2)
124: <> nvl(pqh_bce_shd.g_old_rec.dflt_elmnt_frequency,hr_api.g_varchar2)
125: or not l_api_updating) and
126: p_dflt_elmnt_frequency is not null then
127: --

Line 124: <> nvl(pqh_bce_shd.g_old_rec.dflt_elmnt_frequency,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_dflt_elmnt_frequency,hr_api.g_varchar2)
124: <> nvl(pqh_bce_shd.g_old_rec.dflt_elmnt_frequency,hr_api.g_varchar2)
125: or not l_api_updating) and
126: p_dflt_elmnt_frequency is not null then
127: --
128: -- check if dflt_elmnt_frequency value exists in per_time_period_types table

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

195: (p_bdgt_cmmtmnt_elmnt_id => p_bdgt_cmmtmnt_elmnt_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_budget_id,hr_api.g_number)
200: <> nvl(pqh_bce_shd.g_old_rec.budget_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if budget_id value exists in pqh_budgets table

Line 200: <> nvl(pqh_bce_shd.g_old_rec.budget_id,hr_api.g_number)

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

Line 271: <> nvl(pqh_bce_shd.g_old_rec.actual_commitment_type,hr_api.g_varchar2)

267: p_object_version_number => p_object_version_number);
268: --
269: if (l_api_updating
270: and p_actual_commitment_type
271: <> nvl(pqh_bce_shd.g_old_rec.actual_commitment_type,hr_api.g_varchar2)
272: or not l_api_updating)
273: and p_actual_commitment_type is not null then
274: --
275: -- check if value of lookup falls within lookup type.

Line 277: if hr_api.not_exists_in_hr_lookups

273: and p_actual_commitment_type is not null then
274: --
275: -- check if value of lookup falls within lookup type.
276: --
277: if hr_api.not_exists_in_hr_lookups
278: (p_lookup_type => 'PQH_BDGT_CALC_TYPE',
279: p_lookup_code => p_actual_commitment_type,
280: p_effective_date => p_effective_date) then
281: --

Line 339: <> nvl(pqh_bce_shd.g_old_rec.salary_basis_flag,hr_api.g_varchar2)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_salary_basis_flag
339: <> nvl(pqh_bce_shd.g_old_rec.salary_basis_flag,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_salary_basis_flag is not null then
342: --
343: -- check if value of lookup falls within lookup type.

Line 345: if hr_api.not_exists_in_hr_lookups

341: and p_salary_basis_flag is not null then
342: --
343: -- check if value of lookup falls within lookup type.
344: --
345: if hr_api.not_exists_in_hr_lookups
346: (p_lookup_type => 'YES_NO',
347: p_lookup_code => p_salary_basis_flag,
348: p_effective_date => p_effective_date) then
349: --