DBA Data[Home] [Help]

APPS.BEN_CMD_BUS dependencies on HR_API

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

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

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

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

Line 124: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_mthd_typ_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_cm_dlvry_mthd_typ_id,hr_api.g_number)
124: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_mthd_typ_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_cm_dlvry_mthd_typ_id is not null then
127: --
128: -- check if cm_dlvry_mthd_typ_id value exists in ben_cm_dlvry_mthd_typ table

Line 196: <> nvl(ben_cmd_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

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

Line 202: if hr_api.not_exists_in_hr_lookups

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

Line 264: <> nvl(ben_cmd_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

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

Line 270: if hr_api.not_exists_in_hr_lookups

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

Line 332: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_cd,hr_api.g_varchar2)

328: p_object_version_number => p_object_version_number);
329: --
330: if (l_api_updating
331: and p_cm_dlvry_med_typ_cd
332: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_cd,hr_api.g_varchar2)
333: or not l_api_updating) then
334: --
335: -- check if value of lookup falls within lookup type.
336: --

Line 338: if hr_api.not_exists_in_hr_lookups

334: --
335: -- check if value of lookup falls within lookup type.
336: --
337: --
338: if hr_api.not_exists_in_hr_lookups
339: (p_lookup_type => 'BEN_DLVRY_MED',
340: p_lookup_code => p_cm_dlvry_med_typ_cd,
341: p_effective_date => p_effective_date) then
342: --

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

451: --
452: -- Call all supporting business operations
453: --
454: --
455: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
456: --
457: chk_cm_dlvry_med_typ_id
458: (p_cm_dlvry_med_typ_id => p_rec.cm_dlvry_med_typ_id,
459: p_object_version_number => p_rec.object_version_number);

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

506: --
507: -- Call all supporting business operations
508: --
509: --
510: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
511: --
512: chk_cm_dlvry_med_typ_id
513: (p_cm_dlvry_med_typ_id => p_rec.cm_dlvry_med_typ_id,
514: p_object_version_number => p_rec.object_version_number);

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

591: hr_utility.set_location('Entering:'|| l_proc, 10);
592: --
593: -- Ensure that all the mandatory parameter are not null
594: --
595: hr_api.mandatory_arg_error(p_api_name => l_proc,
596: p_argument => 'cm_dlvry_med_typ_id',
597: p_argument_value => p_cm_dlvry_med_typ_id);
598: --
599: open csr_leg_code;