APPS.BEN_DSQ_BUS dependencies on HR_API

Line 52: and nvl(p_ded_sched_py_freq_id,hr_api.g_number)

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

Line 121: <> nvl(ben_dsq_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

117: p_object_version_number => p_object_version_number);
118: --
119: if (l_api_updating
120: and p_dflt_flag
121: <> nvl(ben_dsq_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
122: or not l_api_updating)
123: and p_dflt_flag is not null then
124: --
125: -- check if value of lookup falls within lookup type.

Line 127: if hr_api.not_exists_in_hr_lookups

123: and p_dflt_flag is not null then
124: --
125: -- check if value of lookup falls within lookup type.
126: --
127: if hr_api.not_exists_in_hr_lookups
128: (p_lookup_type => 'YES_NO',
129: p_lookup_code => p_dflt_flag,
130: p_effective_date => p_effective_date) then
131: --

Line 190: <> nvl(ben_dsq_shd.g_old_rec.pymt_sched_cd,hr_api.g_varchar2)

186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and p_pymt_sched_cd
190: <> nvl(ben_dsq_shd.g_old_rec.pymt_sched_cd,hr_api.g_varchar2)
191: or not l_api_updating) then
192: --
193: -- check if value of lookup falls within lookup type.
194: --

Line 197: if hr_api.not_exists_in_hr_lookups

193: -- check if value of lookup falls within lookup type.
194: --
195: --
196: if p_pymt_sched_cd is not null then
197: if hr_api.not_exists_in_hr_lookups
198: (p_lookup_type => 'BEN_PYMT_SCHED',
199: p_lookup_code => p_pymt_sched_cd,
200: p_effective_date => p_effective_date) then
201: --

Line 261: <> nvl(ben_dsq_shd.g_old_rec.py_freq_cd,hr_api.g_varchar2)

257: p_object_version_number => p_object_version_number);
258: --
259: if (l_api_updating
260: and p_py_freq_cd
261: <> nvl(ben_dsq_shd.g_old_rec.py_freq_cd,hr_api.g_varchar2)
262: or not l_api_updating) then
263: --
264: -- check if value of lookup falls within lookup type.
265: --

Line 268: if hr_api.not_exists_in_hr_lookups

264: -- check if value of lookup falls within lookup type.
265: --
266: --
267: if p_py_freq_cd is not null then
268: if hr_api.not_exists_in_hr_lookups
269: (p_lookup_type => 'BEN_FREQ',
270: p_lookup_code => p_py_freq_cd,
271: p_effective_date => p_effective_date) then
272: --

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

297: --
298: -- Call all supporting business operations
299: --
300: --
301: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
302: --
303: chk_ded_sched_py_freq_id
304: (p_ded_sched_py_freq_id => p_rec.ded_sched_py_freq_id,
305: p_object_version_number => p_rec.object_version_number);

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

340: --
341: -- Call all supporting business operations
342: --
343: --
344: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
345: --
346: chk_ded_sched_py_freq_id
347: (p_ded_sched_py_freq_id => p_rec.ded_sched_py_freq_id,
348: p_object_version_number => p_rec.object_version_number);

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

413: hr_utility.set_location('Entering:'|| l_proc, 10);
414: --
415: -- Ensure that all the mandatory parameter are not null
416: --
417: hr_api.mandatory_arg_error(p_api_name => l_proc,
418: p_argument => 'ded_sched_py_freq_id',
419: p_argument_value => p_ded_sched_py_freq_id);
420: --
421: open csr_leg_code;