DBA Data[Home] [Help]

APPS.BEN_CMT_BUS dependencies on HR_API

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

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

Line 124: and nvl(p_cm_typ_id,hr_api.g_number)

120: (p_cm_dlvry_mthd_typ_id => p_cm_dlvry_mthd_typ_id,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_cm_typ_id,hr_api.g_number)
125: <> nvl(ben_cmt_shd.g_old_rec.cm_typ_id,hr_api.g_number)
126: or not l_api_updating) and
127: p_cm_typ_id is not null then
128: --

Line 125: <> nvl(ben_cmt_shd.g_old_rec.cm_typ_id,hr_api.g_number)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_cm_typ_id,hr_api.g_number)
125: <> nvl(ben_cmt_shd.g_old_rec.cm_typ_id,hr_api.g_number)
126: or not l_api_updating) and
127: p_cm_typ_id is not null then
128: --
129: -- check if cm_typ_id value exists in ben_cm_typ_f table

Line 197: <> nvl(ben_cmt_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_dflt_flag
197: <> nvl(ben_cmt_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if value of lookup falls within lookup type.
201: --

Line 203: if hr_api.not_exists_in_hr_lookups

199: --
200: -- check if value of lookup falls within lookup type.
201: --
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'YES_NO',
205: p_lookup_code => p_dflt_flag,
206: p_effective_date => p_effective_date) then
207: --

Line 265: <> nvl(ben_cmt_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating
264: and p_rqd_flag
265: <> nvl(ben_cmt_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
266: or not l_api_updating) then
267: --
268: -- check if value of lookup falls within lookup type.
269: --

Line 271: if hr_api.not_exists_in_hr_lookups

267: --
268: -- check if value of lookup falls within lookup type.
269: --
270: --
271: if hr_api.not_exists_in_hr_lookups
272: (p_lookup_type => 'YES_NO',
273: p_lookup_code => p_rqd_flag,
274: p_effective_date => p_effective_date) then
275: --

Line 334: <> nvl(ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd,hr_api.g_varchar2)

330: p_object_version_number => p_object_version_number);
331: --
332: if (l_api_updating
333: and p_cm_dlvry_mthd_typ_cd
334: <> nvl(ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd,hr_api.g_varchar2)
335: or not l_api_updating) then
336: --
337: -- check if value of lookup falls within lookup type.
338: --

Line 340: if hr_api.not_exists_in_hr_lookups

336: --
337: -- check if value of lookup falls within lookup type.
338: --
339: --
340: if hr_api.not_exists_in_hr_lookups
341: (p_lookup_type => 'BEN_DLVRY_MTHD',
342: p_lookup_code => p_cm_dlvry_mthd_typ_cd,
343: p_effective_date => p_effective_date) then
344: --

Line 403: where cm_typ_id = nvl(p_cm_typ_id, hr_api.g_number)

399: --
400: cursor crs_cm_dlvry_mthd is
401: select null
402: from ben_cm_dlvry_mthd_typ
403: where cm_typ_id = nvl(p_cm_typ_id, hr_api.g_number)
404: /* Bug Fix for Bug 1862 Benefits Bugs */
405: and cm_dlvry_mthd_typ_cd = p_cm_dlvry_mthd_typ_cd
406: and business_group_id + 0 = p_business_group_id ;
407: --

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

456: --
457: -- Call all supporting business operations
458: --
459: --
460: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
461: --
462: chk_cm_dlvry_mthd_typ_id
463: (p_cm_dlvry_mthd_typ_id => p_rec.cm_dlvry_mthd_typ_id,
464: p_object_version_number => p_rec.object_version_number);

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

510: --
511: -- Call all supporting business operations
512: --
513: --
514: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
515: --
516: chk_cm_dlvry_mthd_typ_id
517: (p_cm_dlvry_mthd_typ_id => p_rec.cm_dlvry_mthd_typ_id,
518: p_object_version_number => p_rec.object_version_number);

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

594: hr_utility.set_location('Entering:'|| l_proc, 10);
595: --
596: -- Ensure that all the mandatory parameter are not null
597: --
598: hr_api.mandatory_arg_error(p_api_name => l_proc,
599: p_argument => 'cm_dlvry_mthd_typ_id',
600: p_argument_value => p_cm_dlvry_mthd_typ_id);
601: --
602: open csr_leg_code;