APPS.BEN_PSQ_BUS dependencies on HR_API

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

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

Line 128: and nvl(p_acty_rt_pymt_sched_id,hr_api.g_number)

124: (p_pymt_sched_py_freq_id => p_pymt_sched_py_freq_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_acty_rt_pymt_sched_id,hr_api.g_number)
129: <> nvl(ben_psq_shd.g_old_rec.acty_rt_pymt_sched_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if acty_rt_pymt_sched_id value exists in ben_acty_rt_pymt_sched_f table

Line 129: <> nvl(ben_psq_shd.g_old_rec.acty_rt_pymt_sched_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_acty_rt_pymt_sched_id,hr_api.g_number)
129: <> nvl(ben_psq_shd.g_old_rec.acty_rt_pymt_sched_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if acty_rt_pymt_sched_id value exists in ben_acty_rt_pymt_sched_f table
133: --

Line 200: <> nvl(ben_psq_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and p_dflt_flag
200: <> nvl(ben_psq_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
201: or not l_api_updating)
202: and p_dflt_flag is not null then
203: --
204: -- check if value of lookup falls within lookup type.

Line 206: if hr_api.not_exists_in_hr_lookups

202: and p_dflt_flag is not null then
203: --
204: -- check if value of lookup falls within lookup type.
205: --
206: if hr_api.not_exists_in_hr_lookups
207: (p_lookup_type => 'YES_NO',
208: p_lookup_code => p_dflt_flag,
209: p_effective_date => p_effective_date) then
210: --

Line 268: <> nvl(ben_psq_shd.g_old_rec.py_freq_cd,hr_api.g_varchar2)

264: p_object_version_number => p_object_version_number);
265: --
266: if (l_api_updating
267: and p_py_freq_cd
268: <> nvl(ben_psq_shd.g_old_rec.py_freq_cd,hr_api.g_varchar2)
269: or not l_api_updating) then
270: --
271: -- check if value of lookup falls within lookup type.
272: --

Line 274: if hr_api.not_exists_in_hr_lookups

270: --
271: -- check if value of lookup falls within lookup type.
272: --
273: --
274: if hr_api.not_exists_in_hr_lookups
275: (p_lookup_type => 'BEN_FREQ',
276: p_lookup_code => p_py_freq_cd,
277: p_effective_date => p_effective_date) then
278: --

Line 306: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

302: --
303: -- Call all supporting business operations
304: --
305: --
306: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
307: --
308: chk_pymt_sched_py_freq_id
309: (p_pymt_sched_py_freq_id => p_rec.pymt_sched_py_freq_id,
310: p_object_version_number => p_rec.object_version_number);

Line 341: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

337: --
338: -- Call all supporting business operations
339: --
340: --
341: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
342: --
343: chk_pymt_sched_py_freq_id
344: (p_pymt_sched_py_freq_id => p_rec.pymt_sched_py_freq_id,
345: p_object_version_number => p_rec.object_version_number);

Line 406: hr_api.mandatory_arg_error(p_api_name => l_proc,

402: hr_utility.set_location('Entering:'|| l_proc, 10);
403: --
404: -- Ensure that all the mandatory parameter are not null
405: --
406: hr_api.mandatory_arg_error(p_api_name => l_proc,
407: p_argument => 'pymt_sched_py_freq_id',
408: p_argument_value => p_pymt_sched_py_freq_id);
409: --
410: open csr_leg_code;